DBA Data[Home] [Help]

APPS.BOM_REFERENCE_DESIGNATOR_API dependencies on INVPUOPI

Line 187: ret_code := INVPUOPI.mtl_log_interface_err(

183: commit_cnt := 0;
184: FOR c1rec in c1 LOOP
185: commit_cnt := commit_cnt + 1;
186: IF (c1rec.OI is null and c1rec.BSI is null) THEN
187: ret_code := INVPUOPI.mtl_log_interface_err(
188: org_id => NULL,
189: user_id => user_id,
190: login_id => login_id,
191: prog_appid => prog_appid,

Line 214: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

210: ** Get assembly item id
211: */
212: stmt_num := 4;
213: IF (c1rec.AII is null and c1rec.BSI is null) THEN
214: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
215: org_id=> c1rec.OI,
216: flex_code => 'MSTK',
217: flex_name => c1rec.AIN,
218: flex_id => c1rec.AII,

Line 222: ret_code := INVPUOPI.mtl_log_interface_err(

218: flex_id => c1rec.AII,
219: set_id => -1,
220: err_text => err_text);
221: IF (ret_code <> 0) THEN
222: ret_code := INVPUOPI.mtl_log_interface_err(
223: org_id => NULL,
224: user_id => user_id,
225: login_id => login_id,
226: prog_appid => prog_appid,

Line 260: ret_code := INVPUOPI.mtl_log_interface_err(

256: AND nvl(alternate_bom_designator, 'NONE') =
257: nvl(c1rec.ABD, 'NONE');
258: EXCEPTION
259: WHEN no_data_found THEN
260: ret_code := INVPUOPI.mtl_log_interface_err(
261: org_id => NULL,
262: user_id => user_id,
263: login_id => login_id,
264: prog_appid => prog_appid,

Line 288: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

284: ** Get component item id
285: */
286: stmt_num := 6;
287: IF (c1rec.CII is null) THEN
288: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
289: org_id=> c1rec.OI,
290: flex_code => 'MSTK',
291: flex_name => c1rec.CIN,
292: flex_id => c1rec.CII,

Line 296: ret_code := INVPUOPI.mtl_log_interface_err(

292: flex_id => c1rec.CII,
293: set_id => -1,
294: err_text => err_text);
295: IF (ret_code <> 0) THEN
296: ret_code := INVPUOPI.mtl_log_interface_err(
297: org_id => NULL,
298: user_id => user_id,
299: login_id => login_id,
300: prog_appid => prog_appid,

Line 333: ret_code := INVPUOPI.mtl_log_interface_err(

329: AND operation_seq_num = c1rec.OSN
330: AND effectivity_date = to_date(c1rec.ED,'YYYY/MM/DD HH24:MI:SS');
331: EXCEPTION
332: WHEN no_data_found THEN
333: ret_code := INVPUOPI.mtl_log_interface_err(
334: org_id => NULL,
335: user_id => user_id,
336: login_id => login_id,
337: prog_appid => prog_appid,

Line 816: ret_code := INVPUOPI.mtl_log_interface_err(

812: AND bic.implementation_date is not null;
813:
814: EXCEPTION
815: WHEN No_Data_Found THEN
816: ret_code := INVPUOPI.mtl_log_interface_err(
817: org_id => NULL,
818: user_id => user_id,
819: login_id => login_id,
820: prog_appid => prog_appid,

Line 850: ret_code := INVPUOPI.mtl_log_interface_err(

846: IF (c2rec.CD is not null
847: OR c2rec.CB is not null
848: OR c2rec.ACD is not null
849: OR c2rec.CN is not null) THEN
850: ret_code := INVPUOPI.mtl_log_interface_err(
851: org_id => 999999,
852: user_id => user_id,
853: login_id => login_id,
854: prog_appid => prog_appid,

Line 936: ret_code := INVPUOPI.mtl_log_interface_err(

932: cmp_seq_id => c2rec.CSI,
933: quantity => X_component_quantity,
934: err_text => err_text);
935: IF (ret_code <> 0) THEN
936: ret_code := INVPUOPI.mtl_log_interface_err(
937: org_id => org_id,
938: user_id => user_id,
939: login_id => login_id,
940: prog_appid => prog_appid,

Line 999: ret_code := INVPUOPI.mtl_log_interface_err(

995: WHERE organization_id = c3rec.OI
996: AND change_notice = c3rec.CN;
997: EXCEPTION
998: WHEN no_data_found THEN
999: ret_code := INVPUOPI.mtl_log_interface_err(
1000: org_id => c3rec.OI,
1001: user_id => user_id,
1002: login_id => login_id,
1003: prog_appid => prog_appid,

Line 1050: ret_code := INVPUOPI.mtl_log_interface_err(

1046:
1047: IF (dummy = 0) THEN
1048: null;
1049: ELSE
1050: ret_code := INVPUOPI.mtl_log_interface_err(
1051: org_id => org_id,
1052: user_id => user_id,
1053: login_id => login_id,
1054: prog_appid => prog_appid,

Line 1097: ret_code := INVPUOPI.mtl_log_interface_err(

1093: AND mtl.organization_id = bbom.organization_id;
1094:
1095: EXCEPTION
1096: WHEN no_data_found THEN
1097: ret_code := INVPUOPI.mtl_log_interface_err(
1098: org_id => c1rec.OI,
1099: user_id => user_id,
1100: login_id => login_id,
1101: prog_appid => prog_appid,

Line 1124: ret_code := INVPUOPI.mtl_log_interface_err(

1120: ** non-standard components or Product Families
1121: */
1122: stmt_num := 9;
1123: IF (dummy in (3,5) OR comp_type <> 4) THEN
1124: ret_code := INVPUOPI.mtl_log_interface_err(
1125: org_id => org_id_dummy,
1126: user_id => user_id,
1127: login_id => login_id,
1128: prog_appid => prog_appid,

Line 1154: ret_code := INVPUOPI.mtl_log_interface_err(

1150: ret_code := Verify_Unique_Designator (
1151: trans_id => c1rec.TI,
1152: err_text => err_text);
1153: IF (ret_code <> 0) THEN
1154: ret_code := INVPUOPI.mtl_log_interface_err(
1155: org_id => org_id_dummy,
1156: user_id => user_id,
1157: login_id => login_id,
1158: prog_appid => prog_appid,

Line 1187: ret_code := INVPUOPI.mtl_log_interface_err(

1183: cmp_seq_id => c1rec.CSI,
1184: quantity => X_component_quantity,
1185: err_text => err_text);
1186: IF (ret_code <> 0) THEN
1187: ret_code := INVPUOPI.mtl_log_interface_err(
1188: org_id => org_id,
1189: user_id => user_id,
1190: login_id => login_id,
1191: prog_appid => prog_appid,