eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_SUBSTITUTE_COMPONENT_API dependencies on INVPUOPI

Line 206: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

202: commit_cnt := 0;
203: FOR c0rec in c0 LOOP
204: commit_cnt := commit_cnt + 1;
205: IF (c0rec.SCI is null and c0rec.SCN is not null) THEN
206: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
207: org_id => c0rec.OI,
208: flex_code => 'MSTK',
209: flex_name => c0rec.SCN,
210: flex_id => c0rec.SCI,

Line 214: ret_code := INVPUOPI.mtl_log_interface_err(

210: flex_id => c0rec.SCI,
211: set_id => -1,
212: err_text => err_text);
213: IF (ret_code <> 0) THEN
214: ret_code := INVPUOPI.mtl_log_interface_err(
215: org_id => NULL,
216: user_id => user_id,
217: login_id => login_id,
218: prog_appid => prog_appid,

Line 240: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

236:
237: stmt_num := 4;
238: IF (c0rec.A = G_Update AND c0rec.NSCI is null
239: AND c0rec.NSCN is not null) THEN
240: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
241: org_id => c0rec.OI,
242: flex_code => 'MSTK',
243: flex_name => c0rec.NSCN,
244: flex_id => c0rec.NSCI,

Line 248: ret_code := INVPUOPI.mtl_log_interface_err(

244: flex_id => c0rec.NSCI,
245: set_id => -1,
246: err_text => err_text);
247: IF (ret_code <> 0) THEN
248: ret_code := INVPUOPI.mtl_log_interface_err(
249: org_id => NULL,
250: user_id => user_id,
251: login_id => login_id,
252: prog_appid => prog_appid,

Line 301: ret_code := INVPUOPI.mtl_log_interface_err(

297: commit_cnt := 0;
298: FOR c1rec in c1 LOOP
299: commit_cnt := commit_cnt + 1;
300: IF (c1rec.OI is null and c1rec.BSI is null) THEN
301: ret_code := INVPUOPI.mtl_log_interface_err(
302: org_id => NULL,
303: user_id => user_id,
304: login_id => login_id,
305: prog_appid => prog_appid,

Line 328: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

324: ** Get assembly item id
325: */
326: stmt_num := 8;
327: IF (c1rec.AII is null and c1rec.BSI is null) THEN
328: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
329: org_id=> c1rec.OI,
330: flex_code => 'MSTK',
331: flex_name => c1rec.AIN,
332: flex_id => c1rec.AII,

Line 336: ret_code := INVPUOPI.mtl_log_interface_err(

332: flex_id => c1rec.AII,
333: set_id => -1,
334: err_text => err_text);
335: IF (ret_code <> 0) THEN
336: ret_code := INVPUOPI.mtl_log_interface_err(
337: org_id => NULL,
338: user_id => user_id,
339: login_id => login_id,
340: prog_appid => prog_appid,

Line 374: ret_code := INVPUOPI.mtl_log_interface_err(

370: AND nvl(alternate_bom_designator, 'NONE') =
371: nvl(c1rec.ABD, 'NONE');
372: EXCEPTION
373: WHEN no_data_found THEN
374: ret_code := INVPUOPI.mtl_log_interface_err(
375: org_id => NULL,
376: user_id => user_id,
377: login_id => login_id,
378: prog_appid => prog_appid,

Line 402: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

398: ** Get component item id
399: */
400: stmt_num := 10;
401: IF (c1rec.CII is null) THEN
402: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
403: org_id=> c1rec.OI,
404: flex_code => 'MSTK',
405: flex_name => c1rec.CIN,
406: flex_id => c1rec.CII,

Line 410: ret_code := INVPUOPI.mtl_log_interface_err(

406: flex_id => c1rec.CII,
407: set_id => -1,
408: err_text => err_text);
409: IF (ret_code <> 0) THEN
410: ret_code := INVPUOPI.mtl_log_interface_err(
411: org_id => NULL,
412: user_id => user_id,
413: login_id => login_id,
414: prog_appid => prog_appid,

Line 447: ret_code := INVPUOPI.mtl_log_interface_err(

443: AND operation_seq_num = c1rec.OSN
444: AND effectivity_date = to_date(c1rec.ED,'YYYY/MM/DD HH24:MI:SS');
445: EXCEPTION
446: WHEN no_data_found THEN
447: ret_code := INVPUOPI.mtl_log_interface_err(
448: org_id => NULL,
449: user_id => user_id,
450: login_id => login_id,
451: prog_appid => prog_appid,

Line 508: ret_code := INVPUOPI.mtl_log_interface_err(

504: from bom_inventory_components
505: where component_sequence_id = c2rec.CSI;
506: EXCEPTION
507: when NO_DATA_FOUND then
508: ret_code := INVPUOPI.mtl_log_interface_err(
509: org_id => NULL,
510: user_id => user_id,
511: login_id => login_id,
512: prog_appid => prog_appid,

Line 898: ret_code := INVPUOPI.mtl_log_interface_err(

894: AND bic.implementation_date is not null;
895:
896: EXCEPTION
897: WHEN No_Data_Found THEN
898: ret_code := INVPUOPI.mtl_log_interface_err(
899: org_id => NULL,
900: user_id => user_id,
901: login_id => login_id,
902: prog_appid => prog_appid,

Line 932: ret_code := INVPUOPI.mtl_log_interface_err(

928: IF (c2rec.CD is not null
929: OR c2rec.CB is not null
930: OR c2rec.ACD is not null
931: OR c2rec.CN is not null) THEN
932: ret_code := INVPUOPI.mtl_log_interface_err(
933: org_id => 999999,
934: user_id => user_id,
935: login_id => login_id,
936: prog_appid => prog_appid,

Line 1056: ret_code := INVPUOPI.mtl_log_interface_err(

1052: AND mtl.organization_id = bbom.organization_id;
1053:
1054: EXCEPTION
1055: WHEN no_data_found THEN
1056: ret_code := INVPUOPI.mtl_log_interface_err(
1057: org_id => c1rec.OI,
1058: user_id => user_id,
1059: login_id => login_id,
1060: prog_appid => prog_appid,

Line 1083: ret_code := INVPUOPI.mtl_log_interface_err(

1079: ** non-standard components or Product Families
1080: */
1081: stmt_num := 8;
1082: IF (dummy in (3,5) OR comp_type <> 4) THEN
1083: ret_code := INVPUOPI.mtl_log_interface_err(
1084: org_id => org_id_dummy,
1085: user_id => user_id,
1086: login_id => login_id,
1087: prog_appid => prog_appid,

Line 1112: ret_code := INVPUOPI.mtl_log_interface_err(

1108: ret_code := Verify_Unique_Substitute (
1109: trans_id => c1rec.TI,
1110: err_text => err_text);
1111: IF (ret_code <> 0) THEN
1112: ret_code := INVPUOPI.mtl_log_interface_err(
1113: org_id => org_id_dummy,
1114: user_id => user_id,
1115: login_id => login_id,
1116: prog_appid => prog_appid,

Line 1176: ret_code := INVPUOPI.mtl_log_interface_err(

1172: END IF;
1173: EXCEPTION
1174: WHEN no_data_found THEN
1175: err_text := 'Substitute item does not exist or has incorrect attributes in item master';
1176: ret_code := INVPUOPI.mtl_log_interface_err(
1177: org_id => org_id_dummy,
1178: user_id => user_id,
1179: login_id => login_id,
1180: prog_appid => prog_appid,

Line 1222: ret_code := INVPUOPI.mtl_log_interface_err(

1218: OR
1219: (bbom.assembly_type = 1
1220: AND msi.eng_item_flag = 'N')));
1221: err_text := 'Substitute item does not exist in common organizations or has incorrect attributes';
1222: ret_code := INVPUOPI.mtl_log_interface_err(
1223: org_id => org_id_dummy,
1224: user_id => user_id,
1225: login_id => login_id,
1226: prog_appid => prog_appid,

Line 1255: ret_code := INVPUOPI.mtl_log_interface_err(

1251: IF ((c3rec.TT = G_Update AND c3rec.NSCI in (c3rec.AII, c3rec.CII))
1252: OR
1253: (c3rec.TT = G_Insert AND c3rec.SCI in (c3rec.AII,c3rec.CII))) THEN
1254: err_text := 'Substitute item is the same as assembly item or component item';
1255: ret_code := INVPUOPI.mtl_log_interface_err(
1256: org_id => org_id_dummy,
1257: user_id => user_id,
1258: login_id => login_id,
1259: prog_appid => prog_appid,

Line 1292: ret_code := INVPUOPI.mtl_log_interface_err(

1288: WHERE organization_id = c3rec.OI
1289: AND change_notice = c3rec.CN;
1290: EXCEPTION
1291: WHEN no_data_found THEN
1292: ret_code := INVPUOPI.mtl_log_interface_err(
1293: org_id => c3rec.OI,
1294: user_id => user_id,
1295: login_id => login_id,
1296: prog_appid => prog_appid,

Line 1323: ret_code := INVPUOPI.mtl_log_interface_err(

1319: quantity ZERO -- Bug : 2101294
1320: stmt_num := 15;
1321: IF (c3rec.SIQ = 0) THEN
1322: err_text := 'Quantity cannot be zero';
1323: ret_code := INVPUOPI.mtl_log_interface_err(
1324: org_id => org_id_dummy,
1325: user_id => user_id,
1326: login_id => login_id,
1327: prog_appid => prog_appid,