Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00382: expression is of wrong type (PLSQL)
PLS-00382: expression is of wrong type [message #580017] Tue, 19 March 2013 05:48 Go to next message
koteswar
Messages: 4
Registered: August 2012
Location: bangalore
Junior Member


hi all,

i got this error 'PLS-00382: expression is of wrong type' please help me.
--declaration

l_recipe_detail_tbl apps.gmd_recipe_detail.recipe_detail_tbl;

begin


ln_recipe_id := NULL;
OPEN lcu_recipe_id (lt_per (i).recipe_no,lt_per (i).recipe_version);
FETCH lcu_recipe_id
INTO ln_recipe_id;
CLOSE lcu_recipe_id;

BEGIN
SELECT msi.inventory_item_id, msi.segment1,
xofs.required_qty
INTO ln_inventory_item_id, lc_segment1,
ln_required_qty
FROM apps.mtl_system_items_b msi,
xxren_opm_formula_stg xofs
WHERE msi.segment1 = xofs.item_no;
EXCEPTION
WHEN NO_DATA_FOUND
THEN
apps.fnd_file.put_line(apps.fnd_file.LOG,'INVENTORY ITEM ID IS NOT VALID'|| ln_inventory_item_id);
apps.fnd_file.put_line (apps.fnd_file.LOG,'REQUIRED_QTY IS NOT VALID' || ln_required_qty);
apps.fnd_file.put_line (apps.fnd_file.LOG,'ITEM NO IS NOT VALID' || lc_segment1);
WHEN OTHERS
THEN
ln_inventory_item_id := NULL;
lc_segment1 := NULL;
ln_required_qty := NULL;
END;


ln_count := 1;

l_recipe_detail_tbl(ln_count).recipe_id := lcu_recipe_id;
l_recipe_detail_tbl(ln_count).recipe_no := lt_per(i).recipe_no;
l_recipe_detail_tbl(ln_count).recipe_version := lt_per(i).recipe_version;
l_recipe_detail_tbl(ln_count).user_id := l_user_id;
l_recipe_detail_tbl(ln_count).user_name := l_user_name;
l_recipe_detail_tbl(ln_count).orgn_code := lt_per (i).owner_org_code;
l_recipe_detail_tbl(ln_count).organization_id := lt_per (i).organization_id;
l_recipe_detail_tbl(ln_count).site_id := null;
l_recipe_detail_tbl(ln_count).org_id := null;
l_recipe_detail_tbl(ln_count).recipe_process_loss_id := null;
l_recipe_detail_tbl(ln_count).process_loss := null;
l_recipe_detail_tbl(ln_count).activity_factor := null;
l_recipe_detail_tbl(ln_count).max_capacity := null;
l_recipe_detail_tbl(ln_count).min_capacity := null;
l_recipe_detail_tbl(ln_count).process_parameter_1 := null;
l_recipe_detail_tbl(ln_count).process_parameter_2 := null;
l_recipe_detail_tbl(ln_count).process_parameter_3 := null;
l_recipe_detail_tbl(ln_count).process_parameter_4 := null;
l_recipe_detail_tbl(ln_count).process_parameter_5 := null;
l_recipe_detail_tbl(ln_count).customer_id := null;
l_recipe_detail_tbl(ln_count).customer_no := null;
l_recipe_detail_tbl(ln_count).routingstep_id := lt_per (i).routstep_id;
l_recipe_detail_tbl(ln_count).oprn_line_id := null;
l_recipe_detail_tbl(ln_count).resources := null;
l_recipe_detail_tbl(ln_count).process_um := null;
l_recipe_detail_tbl(ln_count).usage_uom := null;
l_recipe_detail_tbl(ln_count).resource_usage := null;
l_recipe_detail_tbl(ln_count).process_qty := null;
l_recipe_detail_tbl(ln_count).step_qty := null;
l_recipe_detail_tbl(ln_count).mass_qty := null;
l_recipe_detail_tbl(ln_count).mass_ref_uom := null;
l_recipe_detail_tbl(ln_count).volume_qty := null;
l_recipe_detail_tbl(ln_count).volume_ref_uom := null;
l_recipe_detail_tbl(ln_count).mass_std_uom := null;
l_recipe_detail_tbl(ln_count).volume_std_uom := null;
l_recipe_detail_tbl(ln_count).text_code := null;
l_recipe_detail_tbl(ln_count).delete_mark := 0;
l_recipe_detail_tbl(ln_count).contiguous_ind := 1;
l_recipe_detail_tbl(ln_count).creation_date := gn_sysdate;
l_recipe_detail_tbl(ln_count).created_by := l_user_id;
l_recipe_detail_tbl(ln_count).last_updated_by := l_user_id;
l_recipe_detail_tbl(ln_count).last_update_date := gn_sysdate;
l_recipe_detail_tbl(ln_count).last_update_login := l_user_id;
l_recipe_detail_tbl(ln_count).item_id := ln_inventory_item_id;
l_recipe_detail_tbl(ln_count).owner_id := null;
l_recipe_detail_tbl(ln_count).fixed_process_loss := null;
l_recipe_detail_tbl(ln_count).fixed_process_loss_uom := null;


GMD_RECIPE_DETAIL.RECIPE_ROUTING_STEPS
( p_api_version => 1.0
,p_init_msg_list => 'F'
,p_commit => 'F'
,p_called_from_forms => 'NO'
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_recipe_detail_tbl => l_recipe_detail_tbl
,p_recipe_insert_flex => l_recipe_flex
,p_recipe_update_flex => l_recipe_update_flex
);


exception
when others then
null;
end;


thanks,
Koteswar
Re: PLS-00382: expression is of wrong type [message #580018 is a reply to message #580017] Tue, 19 March 2013 05:57 Go to previous message
Michel Cadot
Messages: 58523
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
exception
when others then
null;
end;


NEVER do this, read WHEN OTHERS.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Also always post your Oracle version, with 4 decimals.

Use SQL*Plus and copy and paste your session, the WHOLE session.

Regards
Michel
Previous Topic: Vertical partitioning
Next Topic: GROUPING ISSUE (merged)
Goto Forum:
  


Current Time: Thu Jul 24 02:05:29 CDT 2014

Total time taken to generate the page: 0.10519 seconds