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_BILL_API dependencies on INVPUOPI

Line 168: ret_code := INVPUOPI.mtl_log_interface_err(

164: /*
165: ** Check if Org Id is null
166: */
167: IF (c1rec.OI is null) THEN
168: ret_code := INVPUOPI.mtl_log_interface_err(
169: org_id => NULL,
170: user_id => user_id,
171: login_id => login_id,
172: prog_appid => prog_appid,

Line 191: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

187: ** Set assembly item ids
188: */
189: stmt_num := 5;
190: IF (c1rec.AII is null) THEN
191: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
192: org_id => c1rec.OI,
193: flex_code => 'MSTK',
194: flex_name => c1rec.AIN,
195: flex_id => c1rec.AII,

Line 199: ret_code := INVPUOPI.mtl_log_interface_err(

195: flex_id => c1rec.AII,
196: set_id => -1,
197: err_text => err_text);
198: IF (ret_code <> 0) THEN
199: ret_code := INVPUOPI.mtl_log_interface_err(
200: org_id => NULL,
201: user_id => user_id,
202: login_id => login_id,
203: prog_appid => prog_appid,

Line 237: ret_code := INVPUOPI.mtl_log_interface_err(

233: x_bom_item_type := c1.bom_item_type;
234: END LOOP;
235:
236: IF (x_bom_item_type is null) THEN
237: ret_code := INVPUOPI.mtl_log_interface_err(
238: org_id => NULL,
239: user_id => user_id,
240: login_id => login_id,
241: prog_appid => prog_appid,

Line 332: ret_code := INVPUOPI.mtl_pr_trans_org_id(

328: END;
329:
330: IF (c1rec.COI is null) AND (c1rec.COC is not null) AND
331: (c1rec.CBSI is null) THEN
332: ret_code := INVPUOPI.mtl_pr_trans_org_id(
333: org_code => c1rec.COC,
334: org_id => c1rec.COI,
335: err_text => err_text);
336: IF (ret_code <> 0) THEN

Line 337: ret_code := INVPUOPI.mtl_log_interface_err(

333: org_code => c1rec.COC,
334: org_id => c1rec.COI,
335: err_text => err_text);
336: IF (ret_code <> 0) THEN
337: ret_code := INVPUOPI.mtl_log_interface_err(
338: org_id => NULL,
339: user_id => user_id,
340: login_id => login_id,
341: prog_appid => prog_appid,

Line 366: ret_code := INVPUOPI.mtl_pr_trans_org_id(

362: */
363: stmt_num := 6;
364: If (c1rec.COI is null) AND (c1rec.COC is not null) AND
365: (c1rec.CBSI is null) THEN
366: ret_code := INVPUOPI.mtl_pr_trans_org_id(
367: org_code => c1rec.COC,
368: org_id => c1rec.COI,
369: err_text => err_text);
370: IF (ret_code <> 0) THEN

Line 371: ret_code := INVPUOPI.mtl_log_interface_err(

367: org_code => c1rec.COC,
368: org_id => c1rec.COI,
369: err_text => err_text);
370: IF (ret_code <> 0) THEN
371: ret_code := INVPUOPI.mtl_log_interface_err(
372: org_id => NULL,
373: user_id => user_id,
374: login_id => login_id,
375: prog_appid => prog_appid,

Line 402: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

398: c1rec.CBSI is null) THEN
399: IF (c1rec.COI is null) THEN
400: c1rec.COI := c1rec.OI;
401: END IF;
402: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
403: org_id => c1rec.COI,
404: flex_code => 'MSTK',
405: flex_name => c1rec.CAIN,
406: flex_id => c1rec.CAII,

Line 410: ret_code := INVPUOPI.mtl_log_interface_err(

406: flex_id => c1rec.CAII,
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 469: ret_code := INVPUOPI.mtl_log_interface_err(

465: AND process_flag not in (3,7)
466: AND rownum = 1;
467: EXCEPTION
468: WHEN no_data_found THEN
469: ret_code := INVPUOPI.mtl_log_interface_err(
470: org_id => NULL,
471: user_id => user_id,
472: login_id => login_id,
473: prog_appid => prog_appid,

Line 516: ret_code := INVPUOPI.mtl_log_interface_err(

512: AND process_flag not in (3,7)
513: AND rownum = 1;
514: EXCEPTION
515: WHEN no_data_found THEN
516: ret_code := INVPUOPI.mtl_log_interface_err(
517: org_id => NULL,
518: user_id => user_id,
519: login_id => login_id,
520: prog_appid => prog_appid,

Line 641: ret_code := INVPUOPI.mtl_log_interface_err(

637: */
638: IF (c2rec.BSI is null) THEN
639: -- Check if Org Id is null
640: IF (c2rec.OI is null) THEN
641: ret_code := INVPUOPI.mtl_log_interface_err(
642: org_id => NULL,
643: user_id => user_id,
644: login_id => login_id,
645: prog_appid => prog_appid,

Line 666: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

662:
663: -- Get Assembly Item Id
664: stmt_num := 16;
665: IF (c2rec.AII is null) THEN
666: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
667: org_id => c2rec.OI,
668: flex_code => 'MSTK',
669: flex_name => c2rec.AIN,
670: flex_id => c2rec.AII,

Line 674: ret_code := INVPUOPI.mtl_log_interface_err(

670: flex_id => c2rec.AII,
671: set_id => -1,
672: err_text => err_text);
673: IF (ret_code <> 0) THEN
674: ret_code := INVPUOPI.mtl_log_interface_err(
675: org_id => c2rec.OI,
676: user_id => user_id,
677: login_id => login_id,
678: prog_appid => prog_appid,

Line 714: ret_code := INVPUOPI.mtl_log_interface_err(

710: AND msi.organization_id = bom.organization_id
711: AND msi.inventory_item_id = bom.assembly_item_id;
712: EXCEPTION
713: WHEN no_data_found THEN
714: ret_code := INVPUOPI.mtl_log_interface_err(
715: org_id => c2rec.OI,
716: user_id => user_id,
717: login_id => login_id,
718: prog_appid => prog_appid,

Line 753: ret_code := INVPUOPI.mtl_log_interface_err(

749: AND msi.organization_id = bom.organization_id
750: AND msi.inventory_item_id = bom.assembly_item_id;
751: EXCEPTION
752: WHEN no_data_found THEN
753: ret_code := INVPUOPI.mtl_log_interface_err(
754: org_id => c2rec.OI,
755: user_id => user_id,
756: login_id => login_id,
757: prog_appid => prog_appid,

Line 812: ret_code := INVPUOPI.mtl_pr_trans_org_id(

808: */
809: stmt_num := 19;
810: IF (c2rec.COI is null) AND (c2rec.COC is not null) AND
811: (c2rec.CBSI is null) THEN
812: ret_code := INVPUOPI.mtl_pr_trans_org_id(
813: org_code => c2rec.COC,
814: org_id => c2rec.COI,
815: err_text => err_text);
816: IF (ret_code <> 0) THEN

Line 817: ret_code := INVPUOPI.mtl_log_interface_err(

813: org_code => c2rec.COC,
814: org_id => c2rec.COI,
815: err_text => err_text);
816: IF (ret_code <> 0) THEN
817: ret_code := INVPUOPI.mtl_log_interface_err(
818: org_id => NULL,
819: user_id => user_id,
820: login_id => login_id,
821: prog_appid => prog_appid,

Line 849: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

845: c2rec.CBSI is null) THEN
846: IF (c2rec.COI is null) THEN
847: c2rec.COI := c2rec.OI;
848: END IF;
849: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
850: org_id => c2rec.COI,
851: flex_code => 'MSTK',
852: flex_name => c2rec.CAIN,
853: flex_id => c2rec.CAII,

Line 857: ret_code := INVPUOPI.mtl_log_interface_err(

853: flex_id => c2rec.CAII,
854: set_id => -1,
855: err_text => err_text);
856: IF (ret_code <> 0) THEN
857: ret_code := INVPUOPI.mtl_log_interface_err(
858: org_id => NULL,
859: user_id => user_id,
860: login_id => login_id,
861: prog_appid => prog_appid,

Line 915: ret_code := INVPUOPI.mtl_log_interface_err(

911: AND process_flag not in (3,7)
912: AND rownum = 1;
913: EXCEPTION
914: WHEN no_data_found THEN
915: ret_code := INVPUOPI.mtl_log_interface_err(
916: org_id => NULL,
917: user_id => user_id,
918: login_id => login_id,
919: prog_appid => prog_appid,

Line 965: ret_code := INVPUOPI.mtl_log_interface_err(

961: AND process_flag not in (3,7)
962: AND rownum = 1;
963: EXCEPTION
964: WHEN no_data_found THEN
965: ret_code := INVPUOPI.mtl_log_interface_err(
966: org_id => NULL,
967: user_id => user_id,
968: login_id => login_id,
969: prog_appid => prog_appid,

Line 1657: ret_code := INVPUOPI.mtl_log_interface_err(

1653: FROM mtl_parameters
1654: WHERE organization_id = c1rec.OI;
1655: EXCEPTION
1656: WHEN no_data_found THEN
1657: ret_code := INVPUOPI.mtl_log_interface_err(
1658: org_id => c1rec.OI,
1659: user_id => user_id,
1660: login_id => login_id,
1661: prog_appid => prog_appid,

Line 1694: ret_code := INVPUOPI.mtl_log_interface_err(

1690: x_bom_item_type := c1.bom_item_type;
1691: END LOOP;
1692:
1693: IF (x_bom_item_type is null) THEN
1694: ret_code := INVPUOPI.mtl_log_interface_err(
1695: org_id => NULL,
1696: user_id => user_id,
1697: login_id => login_id,
1698: prog_appid => prog_appid,

Line 1732: ret_code := INVPUOPI.mtl_log_interface_err(

1728: WHERE organization_id = c1rec.OI
1729: AND alternate_designator_code = c1rec.ABD;
1730: EXCEPTION
1731: WHEN no_data_found THEN
1732: ret_code := INVPUOPI.mtl_log_interface_err(
1733: org_id => c1rec.OI,
1734: user_id => user_id,
1735: login_id => login_id,
1736: prog_appid => prog_appid,

Line 1766: ret_code := INVPUOPI.mtl_log_interface_err(

1762: WHERE organization_id = c1rec.OI
1763: AND inventory_item_id = c1rec.AII;
1764: EXCEPTION
1765: WHEN no_data_found THEN
1766: ret_code := INVPUOPI.mtl_log_interface_err(
1767: org_id => c1rec.OI,
1768: user_id => user_id,
1769: login_id => login_id,
1770: prog_appid => prog_appid,

Line 1801: ret_code := INVPUOPI.mtl_log_interface_err(

1797: WHERE organization_id = c1rec.OI
1798: AND change_notice = c1rec.PFE;
1799: EXCEPTION
1800: WHEN no_data_found THEN
1801: ret_code := INVPUOPI.mtl_log_interface_err(
1802: org_id => c1rec.OI,
1803: user_id => user_id,
1804: login_id => login_id,
1805: prog_appid => prog_appid,

Line 1829: ret_code := INVPUOPI.mtl_log_interface_err(

1825: ** Bill must be mfg or eng
1826: */
1827: stmt_num := 4;
1828: IF (c1rec.AST <> 1) AND (c1rec.AST <> 2) THEN
1829: ret_code := INVPUOPI.mtl_log_interface_err(
1830: org_id => c1rec.OI,
1831: user_id => user_id,
1832: login_id => login_id,
1833: prog_appid => prog_appid,

Line 1860: ret_code := INVPUOPI.mtl_log_interface_err(

1856: bom_seq_id => c1rec.BSI,
1857: mode_type => 1,
1858: err_text => err_text);
1859: IF (ret_code <> 0) THEN
1860: ret_code := INVPUOPI.mtl_log_interface_err(
1861: org_id => c1rec.OI,
1862: user_id => user_id,
1863: login_id => login_id,
1864: prog_appid => prog_appid,

Line 1894: ret_code := INVPUOPI.mtl_log_interface_err(

1890: alt_desg => c1rec.ABD,
1891: assy_type => c1rec.AST,
1892: err_text => err_text);
1893: IF (ret_code <> 0) THEN
1894: ret_code := INVPUOPI.mtl_log_interface_err(
1895: org_id => c1rec.OI,
1896: user_id => user_id,
1897: login_id => login_id,
1898: prog_appid => prog_appid,

Line 1939: ret_code := INVPUOPI.mtl_log_interface_err(

1935: (c1rec.AST = 1 AND
1936: eng_item_flag = 'N'));
1937: EXCEPTION
1938: WHEN no_data_found THEN
1939: ret_code := INVPUOPI.mtl_log_interface_err(
1940: org_id => c1rec.OI,
1941: user_id => user_id,
1942: login_id => login_id,
1943: prog_appid => prog_appid,

Line 1972: ret_code := INVPUOPI.mtl_log_interface_err(

1968: bom_seq_id => c1rec.CBSI,
1969: mode_type => 2,
1970: err_text => err_text);
1971: IF (ret_code <> 0) THEN
1972: ret_code := INVPUOPI.mtl_log_interface_err(
1973: org_id => c1rec.OI,
1974: user_id => user_id,
1975: login_id => login_id,
1976: prog_appid => prog_appid,

Line 2008: ret_code := INVPUOPI.mtl_log_interface_err(

2004: cmn_org_id => c1rec.COI,
2005: alt_desg => c1rec.ABD,
2006: err_text => err_text);
2007: IF (ret_code <> 0) THEN
2008: ret_code := INVPUOPI.mtl_log_interface_err(
2009: org_id => c1rec.OI,
2010: user_id => user_id,
2011: login_id => login_id,
2012: prog_appid => prog_appid,

Line 2102: ret_code := INVPUOPI.mtl_log_interface_err(

2098: AND msi.organization_id = bom.organization_id
2099: AND msi.inventory_item_id = bom.assembly_item_id;
2100: EXCEPTION
2101: WHEN No_Data_Found THEN
2102: ret_code := INVPUOPI.mtl_log_interface_err(
2103: org_id => c2rec.OI,
2104: user_id => user_id,
2105: login_id => login_id,
2106: prog_appid => prog_appid,

Line 2138: ret_code := INVPUOPI.mtl_log_interface_err(

2134: OR c2rec.CB is not null
2135: OR c2rec.PFE is not null
2136: OR c2rec.AST is not null
2137: OR c2rec.NED is not null) THEN
2138: ret_code := INVPUOPI.mtl_log_interface_err(
2139: org_id => c2rec.OI,
2140: user_id => user_id,
2141: login_id => login_id,
2142: prog_appid => prog_appid,

Line 2237: ret_code := INVPUOPI.mtl_log_interface_err(

2233: OR c2rec.SAC is not null
2234: OR c2rec.PFE is not null
2235: OR c2rec.AST is not null
2236: OR c2rec.NED is not null) THEN
2237: ret_code := INVPUOPI.mtl_log_interface_err(
2238: org_id => c2rec.OI,
2239: user_id => user_id,
2240: login_id => login_id,
2241: prog_appid => prog_appid,

Line 2360: ret_code := INVPUOPI.mtl_log_interface_err(

2356: bom_seq_id => c3rec.CBSI,
2357: mode_type => 2,
2358: err_text => err_text);
2359: IF (ret_code <> 0) THEN
2360: ret_code := INVPUOPI.mtl_log_interface_err(
2361: org_id => c3rec.OI,
2362: user_id => user_id,
2363: login_id => login_id,
2364: prog_appid => prog_appid,

Line 2396: ret_code := INVPUOPI.mtl_log_interface_err(

2392: cmn_org_id => c3rec.COI,
2393: alt_desg => c3rec.ABD,
2394: err_text => err_text);
2395: IF (ret_code <> 0) THEN
2396: ret_code := INVPUOPI.mtl_log_interface_err(
2397: org_id => c3rec.OI,
2398: user_id => user_id,
2399: login_id => login_id,
2400: prog_appid => prog_appid,