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.BOMPVALB dependencies on INVPUOPI

Line 83: ret_code := INVPUOPI.mtl_log_interface_err(

79: from mtl_parameters
80: where organization_id = c1rec.OI;
81: EXCEPTION
82: when NO_DATA_FOUND then
83: ret_code := INVPUOPI.mtl_log_interface_err(
84: org_id => c1rec.OI,
85: user_id => user_id,
86: login_id => login_id,
87: prog_appid => prog_appid,

Line 115: ret_code := INVPUOPI.mtl_log_interface_err(

111: where organization_id = c1rec.OI
112: and alternate_designator_code = c1rec.ABD;
113: EXCEPTION
114: when NO_DATA_FOUND then
115: ret_code := INVPUOPI.mtl_log_interface_err(
116: org_id => c1rec.OI,
117: user_id => user_id,
118: login_id => login_id,
119: prog_appid => prog_appid,

Line 144: ret_code := INVPUOPI.mtl_log_interface_err(

140: org_id => c1rec.OI,
141: assy_id => c1rec.AII,
142: err_text => err_text);
143: if (ret_code <> 0) then
144: ret_code := INVPUOPI.mtl_log_interface_err(
145: org_id => c1rec.OI,
146: user_id => user_id,
147: login_id => login_id,
148: prog_appid => prog_appid,

Line 168: ret_code := INVPUOPI.mtl_log_interface_err(

164: end if;
165:
166: stmt_num := 4; /* assembly_type must be 1 or 2 */
167: if (c1rec.AST <> 1) and (c1rec.AST <> 2) then
168: ret_code := INVPUOPI.mtl_log_interface_err(
169: org_id => c1rec.OI,
170: user_id => user_id,
171: login_id => login_id,
172: prog_appid => prog_appid,

Line 196: ret_code := INVPUOPI.mtl_log_interface_err(

192: bom_seq_id => c1rec.BSI,
193: mode_type => 1,
194: err_text => err_text);
195: if (ret_code <> 0) then
196: ret_code := INVPUOPI.mtl_log_interface_err(
197: org_id => c1rec.OI,
198: user_id => user_id,
199: login_id => login_id,
200: prog_appid => prog_appid,

Line 230: ret_code := INVPUOPI.mtl_log_interface_err(

226: alt_desg => c1rec.ABD,
227: assy_type => c1rec.AST,
228: err_text => err_text);
229: if (ret_code <> 0) then
230: ret_code := INVPUOPI.mtl_log_interface_err(
231: org_id => c1rec.OI,
232: user_id => user_id,
233: login_id => login_id,
234: prog_appid => prog_appid,

Line 259: ret_code := INVPUOPI.mtl_log_interface_err(

255: assy_id => c1rec.AII,
256: assy_type => c1rec.AST,
257: err_text => err_text);
258: if (ret_code <> 0) then
259: ret_code := INVPUOPI.mtl_log_interface_err(
260: org_id => c1rec.OI,
261: user_id => user_id,
262: login_id => login_id,
263: prog_appid => prog_appid,

Line 290: ret_code := INVPUOPI.mtl_log_interface_err(

286: bom_seq_id => c1rec.CBSI,
287: mode_type => 2,
288: err_text => err_text);
289: if (ret_code <> 0) then
290: ret_code := INVPUOPI.mtl_log_interface_err(
291: org_id => c1rec.OI,
292: user_id => user_id,
293: login_id => login_id,
294: prog_appid => prog_appid,

Line 324: ret_code := INVPUOPI.mtl_log_interface_err(

320: cmn_org_id => c1rec.COI,
321: alt_desg => c1rec.ABD,
322: err_text => err_text);
323: if (ret_code <> 0) then
324: ret_code := INVPUOPI.mtl_log_interface_err(
325: org_id => c1rec.OI,
326: user_id => user_id,
327: login_id => login_id,
328: prog_appid => prog_appid,

Line 1130: ret_code := INVPUOPI.mtl_log_interface_err(

1126: cmp_seq_id => c1rec.CSI,
1127: exist_flag => 2,
1128: err_text => err_text);
1129: if (ret_code <> 0) then
1130: ret_code := INVPUOPI.mtl_log_interface_err(
1131: org_id => c1rec.OI,
1132: user_id => user_id,
1133: login_id => login_id,
1134: prog_appid => prog_appid,

Line 1162: ret_code := INVPUOPI.mtl_log_interface_err(

1158: cmp_item_id => c1rec.CII,
1159: op_seq => c1rec.OSN,
1160: err_text => err_text);
1161: if (ret_code <> 0) then
1162: ret_code := INVPUOPI.mtl_log_interface_err(
1163: org_id => c1rec.OI,
1164: user_id => user_id,
1165: login_id => login_id,
1166: prog_appid => prog_appid,

Line 1192: ret_code := INVPUOPI.mtl_log_interface_err(

1188: bom_seq_id => c1rec.BSI,
1189: mode_type => 2,
1190: err_text => err_text);
1191: if (ret_code <> 0) then
1192: ret_code := INVPUOPI.mtl_log_interface_err(
1193: org_id => c1rec.OI,
1194: user_id => user_id,
1195: login_id => login_id,
1196: prog_appid => prog_appid,

Line 1226: ret_code := INVPUOPI.mtl_log_interface_err(

1222: eff_date => c1rec.ED,
1223: dis_date => c1rec.DD,
1224: err_text => err_text);
1225: if (ret_code <> 0) then
1226: ret_code := INVPUOPI.mtl_log_interface_err(
1227: org_id => c1rec.OI,
1228: user_id => user_id,
1229: login_id => login_id,
1230: prog_appid => prog_appid,

Line 1260: ret_code := INVPUOPI.mtl_log_interface_err(

1256: from bom_bill_of_materials
1257: where bill_sequence_id = c1rec.BSI
1258: and common_bill_sequence_id <> c1rec.BSI;
1259:
1260: ret_code := INVPUOPI.mtl_log_interface_err(
1261: org_id => c1rec.OI,
1262: user_id => user_id,
1263: login_id => login_id,
1264: prog_appid => prog_appid,

Line 1292: ret_code := INVPUOPI.mtl_log_interface_err(

1288: where bill_sequence_id = c1rec.BSI
1289: and process_flag = 4
1290: and common_bill_sequence_id <> c1rec.BSI;
1291:
1292: ret_code := INVPUOPI.mtl_log_interface_err(
1293: org_id => c1rec.OI,
1294: user_id => user_id,
1295: login_id => login_id,
1296: prog_appid => prog_appid,

Line 1352: ret_code := INVPUOPI.mtl_log_interface_err(

1348: eng_bill => eng_bill,
1349: assy_id => c1rec.AII,
1350: err_text => err_text);
1351: if (ret_code <> 0) then
1352: ret_code := INVPUOPI.mtl_log_interface_err(
1353: org_id => c1rec.OI,
1354: user_id => user_id,
1355: login_id => login_id,
1356: prog_appid => prog_appid,

Line 1385: ret_code := INVPUOPI.mtl_log_interface_err(

1381: alt_desg => c1rec.ABD,
1382: op_seq => c1rec.OSN,
1383: err_text => err_text);
1384: if (ret_code <> 0) then
1385: ret_code := INVPUOPI.mtl_log_interface_err(
1386: org_id => c1rec.OI,
1387: user_id => user_id,
1388: login_id => login_id,
1389: prog_appid => prog_appid,

Line 1412: ret_code := INVPUOPI.mtl_log_interface_err(

1408: */
1409: stmt_num := 9;
1410: if (to_date(c1rec.ED,'YYYY/MM/DD HH24:MI') >
1411: to_date(c1rec.DD,'YYYY/MM/DD HH24:MI')) then
1412: ret_code := INVPUOPI.mtl_log_interface_err(
1413: org_id => c1rec.OI,
1414: user_id => user_id,
1415: login_id => login_id,
1416: prog_appid => prog_appid,

Line 1451: ret_code := INVPUOPI.mtl_log_interface_err(

1447: ) then
1448: NULL;
1449: else
1450: err_text := 'Planning percentage must be 100';
1451: ret_code := INVPUOPI.mtl_log_interface_err(
1452: org_id => c1rec.OI,
1453: user_id => user_id,
1454: login_id => login_id,
1455: prog_appid => prog_appid,

Line 1480: ret_code := INVPUOPI.mtl_log_interface_err(

1476: */
1477: stmt_num := 11;
1478: if (c1rec.BITC = 4 and c1rec.RTOFC = 'Y' and c1rec.BITA in (1,2)
1479: and c1rec.PCFA = 'Y' and c1rec.O = 2) then
1480: ret_code := INVPUOPI.mtl_log_interface_err(
1481: org_id => c1rec.OI,
1482: user_id => user_id,
1483: login_id => login_id,
1484: prog_appid => prog_appid,

Line 1636: ret_code := INVPUOPI.mtl_log_interface_err(

1632: null;
1633: end;
1634:
1635: if (err_text is not null) then
1636: ret_code := INVPUOPI.mtl_log_interface_err(
1637: org_id => c1rec.OI,
1638: user_id => user_id,
1639: login_id => login_id,
1640: prog_appid => prog_appid,

Line 1957: ret_code := INVPUOPI.mtl_log_interface_err(

1953: end if;
1954:
1955: Exception
1956: when write_loc_error then
1957: ret_code := INVPUOPI.mtl_log_interface_err(
1958: org_id => org_id,
1959: user_id => user_id,
1960: login_id => login_id,
1961: prog_appid => prog_appid,

Line 1978: ret_code := INVPUOPI.mtl_log_interface_err(

1974: raise ret_code_error;
1975: end if;
1976:
1977: when write_subinv_error then
1978: ret_code := INVPUOPI.mtl_log_interface_err(
1979: org_id => org_id,
1980: user_id => user_id,
1981: login_id => login_id,
1982: prog_appid => prog_appid,

Line 2548: ret_code := INVPUOPI.mtl_log_interface_err(

2544:
2545: if (dummy = 0) then
2546: NULL;
2547: else
2548: ret_code := INVPUOPI.mtl_log_interface_err(
2549: org_id => org_id,
2550: user_id => user_id,
2551: login_id => login_id,
2552: prog_appid => prog_appid,

Line 2579: ret_code := INVPUOPI.mtl_log_interface_err(

2575: cmp_seq_id => c1rec.CSI,
2576: exist_flag => 1,
2577: err_text => err_text);
2578: if (ret_code <> 0) then
2579: ret_code := INVPUOPI.mtl_log_interface_err(
2580: org_id => org_id,
2581: user_id => user_id,
2582: login_id => login_id,
2583: prog_appid => prog_appid,

Line 2608: ret_code := INVPUOPI.mtl_log_interface_err(

2604: ret_code := BOMPVALB.bmvundesg_verify_unique_desg (
2605: trans_id => c1rec.TI,
2606: err_text => err_text);
2607: if (ret_code <> 0) then
2608: ret_code := INVPUOPI.mtl_log_interface_err(
2609: org_id => org_id,
2610: user_id => user_id,
2611: login_id => login_id,
2612: prog_appid => prog_appid,

Line 2638: ret_code := INVPUOPI.mtl_log_interface_err(

2634: trans_id => c1rec.TI,
2635: cmp_seq_id => c1rec.CSI,
2636: err_text => err_text);
2637: if (ret_code <> 0) then
2638: ret_code := INVPUOPI.mtl_log_interface_err(
2639: org_id => org_id,
2640: user_id => user_id,
2641: login_id => login_id,
2642: prog_appid => prog_appid,

Line 2720: ret_code := INVPUOPI.mtl_log_interface_err(

2716: and msi.inventory_item_id = assy_id_dummy;
2717:
2718: if (dummy = 3) then
2719: err_text := 'Cannot have reference desgs for planning bills';
2720: ret_code := INVPUOPI.mtl_log_interface_err(
2721: org_id => org_id_dummy,
2722: user_id => user_id,
2723: login_id => login_id,
2724: prog_appid => prog_appid,

Line 2744: ret_code := INVPUOPI.mtl_log_interface_err(

2740: end if;
2741:
2742: if (comp_type <> 4) then
2743: err_text := 'Cannot have reference desgs for model, option class, or planning components';
2744: ret_code := INVPUOPI.mtl_log_interface_err(
2745: org_id => org_id_dummy,
2746: user_id => user_id,
2747: login_id => login_id,
2748: prog_appid => prog_appid,

Line 3031: ret_code := INVPUOPI.mtl_log_interface_err(

3027: cmp_seq_id => c1rec.CSI,
3028: exist_flag => 1,
3029: err_text => err_text);
3030: if (ret_code <> 0) then
3031: ret_code := INVPUOPI.mtl_log_interface_err(
3032: org_id => c1rec.OI,
3033: user_id => user_id,
3034: login_id => login_id,
3035: prog_appid => prog_appid,

Line 3118: ret_code := INVPUOPI.mtl_log_interface_err(

3114: where msi.organization_id = org_id_dummy
3115: and msi.inventory_item_id = assy_id_dummy;
3116:
3117: if (dummy = 3) then
3118: ret_code := INVPUOPI.mtl_log_interface_err(
3119: org_id => org_id_dummy,
3120: user_id => user_id,
3121: login_id => login_id,
3122: prog_appid => prog_appid,

Line 3141: ret_code := INVPUOPI.mtl_log_interface_err(

3137: goto continue_loop;
3138: end if;
3139:
3140: if (comp_type <> 4) then
3141: ret_code := INVPUOPI.mtl_log_interface_err(
3142: org_id => org_id_dummy,
3143: user_id => user_id,
3144: login_id => login_id,
3145: prog_appid => prog_appid,

Line 3178: ret_code := INVPUOPI.mtl_log_interface_err(

3174: and b.inventory_item_id = a.substitute_component_id);
3175:
3176: if (dummy <> 0) then
3177: err_text := 'Substitute item does not exist in item master';
3178: ret_code := INVPUOPI.mtl_log_interface_err(
3179: org_id => org_id_dummy,
3180: user_id => user_id,
3181: login_id => login_id,
3182: prog_appid => prog_appid,

Line 3207: ret_code := INVPUOPI.mtl_log_interface_err(

3203: ret_code := BOMPVALB.bmvunsub_verify_unique_sub (
3204: trans_id => c1rec.TI,
3205: err_text => err_text);
3206: if (ret_code <> 0) then
3207: ret_code := INVPUOPI.mtl_log_interface_err(
3208: org_id => org_id_dummy,
3209: user_id => user_id,
3210: login_id => login_id,
3211: prog_appid => prog_appid,

Line 3243: ret_code := INVPUOPI.mtl_log_interface_err(

3239: and process_flag <> 3 and process_flag <> 7;
3240:
3241: if (dummy <> 0) then
3242: err_text := 'Substitute item is the same as assembly item or component item';
3243: ret_code := INVPUOPI.mtl_log_interface_err(
3244: org_id => org_id_dummy,
3245: user_id => user_id,
3246: login_id => login_id,
3247: prog_appid => prog_appid,

Line 3284: ret_code := INVPUOPI.mtl_log_interface_err(

3280: (assy_type_dummy = 1
3281: and eng_item_flag = 'N')));
3282: if (dummy <> 0) then
3283: err_text := 'Substitute item has invalid item attributes';
3284: ret_code := INVPUOPI.mtl_log_interface_err(
3285: org_id => org_id_dummy,
3286: user_id => user_id,
3287: login_id => login_id,
3288: prog_appid => prog_appid,

Line 3317: ret_code := INVPUOPI.mtl_log_interface_err(

3313: and process_flag <> 3 and process_flag <> 7
3314: and substitute_item_quantity = 0;
3315: if (dummy <> 0) then
3316: err_text := 'Quantity cannot be zero';
3317: ret_code := INVPUOPI.mtl_log_interface_err(
3318: org_id => org_id_dummy,
3319: user_id => user_id,
3320: login_id => login_id,
3321: prog_appid => prog_appid,

Line 3519: ret_code := INVPUOPI.mtl_log_interface_err(

3515: for c0rec in c0 loop
3516: commit_cnt := commit_cnt + 1;
3517: stmt_num := 1;
3518: if (c0rec.R is null) then
3519: ret_code := INVPUOPI.mtl_log_interface_err(
3520: org_id => org_id,
3521: user_id => user_id,
3522: login_id => login_id,
3523: prog_appid => prog_appid,

Line 3551: ret_code := INVPUOPI.mtl_log_interface_err(

3547: from mtl_parameters
3548: where organization_id = c0rec.OI;
3549: EXCEPTION
3550: when NO_DATA_FOUND then
3551: ret_code := INVPUOPI.mtl_log_interface_err(
3552: org_id => c0rec.OI,
3553: user_id => user_id,
3554: login_id => login_id,
3555: prog_appid => prog_appid,

Line 3579: ret_code := INVPUOPI.mtl_log_interface_err(

3575: org_id => c0rec.OI,
3576: assy_id => c0rec.AII,
3577: err_text => err_text);
3578: if (ret_code <> 0) then
3579: ret_code := INVPUOPI.mtl_log_interface_err(
3580: org_id => c0rec.OI,
3581: user_id => user_id,
3582: login_id => login_id,
3583: prog_appid => prog_appid,

Line 3621: ret_code := INVPUOPI.mtl_log_interface_err(

3617: and organization_id = c0rec.OI
3618: and assembly_item_id = c0rec.AII;
3619:
3620: if (dummy_bill = 0) then
3621: ret_code := INVPUOPI.mtl_log_interface_err(
3622: org_id => c0rec.OI,
3623: user_id => user_id,
3624: login_id => login_id,
3625: prog_appid => prog_appid,

Line 3799: ret_code := INVPUOPI.mtl_log_interface_err(

3795: where transaction_id = c1rec.TI;
3796: goto continue_loop;
3797:
3798: <>
3799: ret_code := INVPUOPI.mtl_log_interface_err(
3800: org_id => org_id,
3801: user_id => user_id,
3802: login_id => login_id,
3803: prog_appid => prog_appid,