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

Line 209: ret_code := INVPUOPI.mtl_log_interface_err(

205: ** Check if Org ID null
206: */
207: IF (c1rec.OI is null
208: AND (c1rec.BSI is null OR c1rec.CII is null)) THEN
209: ret_code := INVPUOPI.mtl_log_interface_err(
210: org_id => NULL,
211: user_id => user_id,
212: login_id => login_id,
213: prog_appid => prog_appid,

Line 234: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

230: ** Get Assembly Id
231: */
232: stmt_num := 5;
233: IF (c1rec.AII is null AND c1rec.BSI is null) THEN
234: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
235: org_id => c1rec.OI,
236: flex_code => 'MSTK',
237: flex_name => c1rec.AIN,
238: flex_id => c1rec.AII,

Line 242: ret_code := INVPUOPI.mtl_log_interface_err(

238: flex_id => c1rec.AII,
239: set_id => -1,
240: err_text => err_text);
241: IF (ret_code <> 0) THEN
242: ret_code := INVPUOPI.mtl_log_interface_err(
243: org_id => NULL,
244: user_id => user_id,
245: login_id => login_id,
246: prog_appid => prog_appid,

Line 284: ret_code := INVPUOPI.mtl_log_interface_err(

280: AND msi.organization_id = bom.organization_id
281: AND msi.inventory_item_id = bom.assembly_item_id;
282: EXCEPTION
283: WHEN no_data_found THEN
284: ret_code := INVPUOPI.mtl_log_interface_err(
285: org_id => c1rec.OI,
286: user_id => user_id,
287: login_id => login_id,
288: prog_appid => prog_appid,

Line 323: ret_code := INVPUOPI.mtl_log_interface_err(

319: AND msi.organization_id = bom.organization_id
320: AND msi.inventory_item_id = bom.assembly_item_id;
321: EXCEPTION
322: WHEN no_data_found THEN
323: ret_code := INVPUOPI.mtl_log_interface_err(
324: org_id => NULL,
325: user_id => user_id,
326: login_id => login_id,
327: prog_appid => prog_appid,

Line 350: ret_code := INVPUOPI.mtl_pr_trans_prod_item(

346: ** Get Component Id
347: */
348: stmt_num := 9;
349: IF (c1rec.CII is null) THEN
350: ret_code := INVPUOPI.mtl_pr_trans_prod_item(
351: c1rec.CIN,
352: c1rec.OI,
353: c1rec.CII,
354: err_text);

Line 356: ret_code := INVPUOPI.mtl_log_interface_err(

352: c1rec.OI,
353: c1rec.CII,
354: err_text);
355: IF (ret_code <> 0) THEN
356: ret_code := INVPUOPI.mtl_log_interface_err(
357: org_id => NULL,
358: user_id => user_id,
359: login_id => login_id,
360: prog_appid => prog_appid,

Line 407: ret_code := INVPUOPI.mtl_log_interface_err(

403: AND inventory_item_id = c1rec.CII;
404:
405: EXCEPTION
406: WHEN NO_DATA_FOUND THEN
407: ret_code := INVPUOPI.mtl_log_interface_err(
408: org_id => NULL,
409: user_id => user_id,
410: login_id => login_id,
411: prog_appid => prog_appid,

Line 452: ret_code := INVPUOPI.mtl_log_interface_err(

448: WHERE organization_id = c1rec.OI
449: AND inventory_item_id = c1rec.CII;
450: EXCEPTION
451: WHEN no_data_found THEN
452: ret_code := INVPUOPI.mtl_log_interface_err(
453: org_id => NULL,
454: user_id => user_id,
455: login_id => login_id,
456: prog_appid => prog_appid,

Line 488: ret_code := INVPUOPI.mtl_log_interface_err(

484: /*
485: ** Check if Effective Date null
486: */
487: IF (c1rec.ED is null) THEN
488: ret_code := INVPUOPI.mtl_log_interface_err(
489: org_id => NULL,
490: user_id => user_id,
491: login_id => login_id,
492: prog_appid => prog_appid,

Line 511: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

507: ** Get Supply Locator Id
508: */
509: stmt_num := 10.1;
510: IF (c1rec.SLI is null AND c1rec.LN is not null) THEN
511: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
512: org_id => c1rec.OI,
513: flex_code => 'MTLL',
514: flex_name => c1rec.LN,
515: flex_id => c1rec.SLI,

Line 519: ret_code := INVPUOPI.mtl_log_interface_err(

515: flex_id => c1rec.SLI,
516: set_id => -1,
517: err_text => err_text);
518: IF (ret_code <> 0) THEN
519: ret_code := INVPUOPI.mtl_log_interface_err(
520: org_id => NULL,
521: user_id => user_id,
522: login_id => login_id,
523: prog_appid => prog_appid,

Line 700: ret_code := INVPUOPI.mtl_log_interface_err(

696: IF (c2rec.CSI is null) THEN
697: IF (c2rec.BSI is null) THEN
698: -- Check if Org Id is null
699: IF (c2rec.OI is null) THEN
700: ret_code := INVPUOPI.mtl_log_interface_err(
701: org_id => NULL,
702: user_id => user_id,
703: login_id => login_id,
704: prog_appid => prog_appid,

Line 727: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

723: */
724: -- Get Assembly Item Id
725: stmt_num := 3;
726: IF (c2rec.AII is null) THEN
727: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
728: org_id => c2rec.OI,
729: flex_code => 'MSTK',
730: flex_name => c2rec.AIN,
731: flex_id => c2rec.AII,

Line 735: ret_code := INVPUOPI.mtl_log_interface_err(

731: flex_id => c2rec.AII,
732: set_id => -1,
733: err_text => err_text);
734: IF (ret_code <> 0) THEN
735: ret_code := INVPUOPI.mtl_log_interface_err(
736: org_id => c2rec.OI,
737: user_id => user_id,
738: login_id => login_id,
739: prog_appid => prog_appid,

Line 775: ret_code := INVPUOPI.mtl_log_interface_err(

771: AND msi.organization_id = bom.organization_id
772: AND msi.inventory_item_id = bom.assembly_item_id;
773: EXCEPTION
774: WHEN no_data_found THEN
775: ret_code := INVPUOPI.mtl_log_interface_err(
776: org_id => c2rec.OI,
777: user_id => user_id,
778: login_id => login_id,
779: prog_appid => prog_appid,

Line 814: ret_code := INVPUOPI.mtl_log_interface_err(

810: AND msi.organization_id = bom.organization_id
811: AND msi.inventory_item_id = bom.assembly_item_id;
812: EXCEPTION
813: WHEN no_data_found THEN
814: ret_code := INVPUOPI.mtl_log_interface_err(
815: org_id => NULL,
816: user_id => user_id,
817: login_id => login_id,
818: prog_appid => prog_appid,

Line 841: ret_code := INVPUOPI.mtl_pr_trans_prod_item(

837: ** Get Component Id
838: */
839: stmt_num := 9;
840: IF (c2rec.CII is null) THEN
841: ret_code := INVPUOPI.mtl_pr_trans_prod_item(
842: c2rec.CIN,
843: c2rec.OI,
844: c2rec.CII,
845: err_text);

Line 847: ret_code := INVPUOPI.mtl_log_interface_err(

843: c2rec.OI,
844: c2rec.CII,
845: err_text);
846: IF (ret_code <> 0) THEN
847: ret_code := INVPUOPI.mtl_log_interface_err(
848: org_id => NULL,
849: user_id => user_id,
850: login_id => login_id,
851: prog_appid => prog_appid,

Line 885: ret_code := INVPUOPI.mtl_log_interface_err(

881: AND effectivity_date = to_date(c2rec.ED,
882: 'YYYY/MM/DD HH24:MI:SS');
883: EXCEPTION
884: WHEN no_data_found THEN
885: ret_code := INVPUOPI.mtl_log_interface_err(
886: org_id => NULL,
887: user_id => user_id,
888: login_id => login_id,
889: prog_appid => prog_appid,

Line 926: ret_code := INVPUOPI.mtl_log_interface_err(

922: AND msi.organization_id = bbom.organization_id
923: AND msi.inventory_item_id = bbom.assembly_item_id;
924: EXCEPTION
925: WHEN no_data_found THEN
926: ret_code := INVPUOPI.mtl_log_interface_err(
927: org_id => NULL,
928: user_id => user_id,
929: login_id => login_id,
930: prog_appid => prog_appid,

Line 988: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

984: ** Get Supply Locator Id
985: */
986: stmt_num := 6;
987: IF (c2rec.SLI is null AND c2rec.LN is not null) THEN
988: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
989: org_id => c2rec.OI,
990: flex_code => 'MTLL',
991: flex_name => c2rec.LN,
992: flex_id => c2rec.SLI,

Line 996: ret_code := INVPUOPI.mtl_log_interface_err(

992: flex_id => c2rec.SLI,
993: set_id => -1,
994: err_text => err_text);
995: IF (ret_code <> 0) THEN
996: ret_code := INVPUOPI.mtl_log_interface_err(
997: org_id => NULL,
998: user_id => user_id,
999: login_id => login_id,
1000: prog_appid => prog_appid,

Line 2097: ret_code := INVPUOPI.mtl_log_interface_err(

2093: WHERE component_sequence_id = c2rec.CSI
2094: AND implementation_date is NOT NULL;
2095: EXCEPTION
2096: WHEN No_Data_Found THEN
2097: ret_code := INVPUOPI.mtl_log_interface_err(
2098: org_id => c2rec.OI,
2099: user_id => user_id,
2100: login_id => login_id,
2101: prog_appid => prog_appid,

Line 2140: ret_code := INVPUOPI.mtl_log_interface_err(

2136: Added validation check for Item Number
2137: Maximum allowed is 9999
2138: */
2139: IF (c2rec.INUM > 9999) then
2140: ret_code := INVPUOPI.mtl_log_interface_err(
2141: org_id => NULL,
2142: user_id => user_id,
2143: login_id => login_id,
2144: prog_appid => prog_appid,

Line 2205: ret_code := INVPUOPI.mtl_log_interface_err(

2201: OR c2rec.WST is not null -- wip supply type
2202: OR c2rec.SS is not null -- supply subinventory
2203: OR c2rec.SLI is not null -- supply locator id
2204: ) THEN
2205: ret_code := INVPUOPI.mtl_log_interface_err(
2206: org_id => c2rec.OI,
2207: user_id => user_id,
2208: login_id => login_id,
2209: prog_appid => prog_appid,

Line 2334: ret_code := INVPUOPI.mtl_log_interface_err(

2330: OR c2rec.OLTP is not null -- op lead time percent
2331: OR c2rec.RISI is not null -- rev item seq id
2332: OR c2rec.BIT is not null -- bom item type
2333: OR c2rec.ACD is not null) THEN -- acd type
2334: ret_code := INVPUOPI.mtl_log_interface_err(
2335: org_id => c2rec.OI,
2336: user_id => user_id,
2337: login_id => login_id,
2338: prog_appid => prog_appid,

Line 2492: ret_code := INVPUOPI.mtl_log_interface_err(

2488: act => c3rec.A,
2489: comp_seq_id => c3rec.CSI,
2490: err_text => err_text);
2491: IF (ret_code <> 0) THEN
2492: ret_code := INVPUOPI.mtl_log_interface_err(
2493: org_id => c3rec.OI,
2494: user_id => user_id,
2495: login_id => login_id,
2496: prog_appid => prog_appid,

Line 2519: ret_code := INVPUOPI.mtl_log_interface_err(

2515: Added validation check for Item Number
2516: Maximum allowed is 9999
2517: */
2518: IF (c3rec.INUM > 9999) then
2519: ret_code := INVPUOPI.mtl_log_interface_err(
2520: org_id => NULL,
2521: user_id => user_id,
2522: login_id => login_id,
2523: prog_appid => prog_appid,

Line 2557: ret_code := INVPUOPI.mtl_log_interface_err(

2553: act => c3rec.A,
2554: comp_seq_id => c3rec.CSI,
2555: err_text => err_text);
2556: IF (ret_code <> 0) THEN
2557: ret_code := INVPUOPI.mtl_log_interface_err(
2558: org_id => c3rec.OI,
2559: user_id => user_id,
2560: login_id => login_id,
2561: prog_appid => prog_appid,

Line 2585: ret_code := INVPUOPI.mtl_log_interface_err(

2581: */
2582: stmt_num := 5;
2583: IF (to_date(c3rec.ED,'YYYY/MM/DD HH24:MI:SS') >
2584: to_date(c3rec.DD,'YYYY/MM/DD HH24:MI:SS')) THEN
2585: ret_code := INVPUOPI.mtl_log_interface_err(
2586: org_id => c3rec.OI,
2587: user_id => user_id,
2588: login_id => login_id,
2589: prog_appid => prog_appid,

Line 2612: ret_code := INVPUOPI.mtl_log_interface_err(

2608: /*
2609: ** Planning factor cannot be zero for Members
2610: */
2611: IF (c3rec.PF = 0) THEN
2612: ret_code := INVPUOPI.mtl_log_interface_err(
2613: org_id => c3rec.OI,
2614: user_id => user_id,
2615: login_id => login_id,
2616: prog_appid => prog_appid,

Line 2675: ret_code := INVPUOPI.mtl_log_interface_err(

2671: end if; -- Code for bug 1804509 ends here
2672:
2673:
2674: IF (ret_code <> 0) THEN
2675: ret_code := INVPUOPI.mtl_log_interface_err(
2676: org_id => c3rec.OI,
2677: user_id => user_id,
2678: login_id => login_id,
2679: prog_appid => prog_appid,

Line 2713: ret_code := INVPUOPI.mtl_log_interface_err(

2709: c3rec.AFC = 2)) THEN
2710: null;
2711: ELSE
2712: err_text := 'Planning percentage must be 100';
2713: ret_code := INVPUOPI.mtl_log_interface_err(
2714: org_id => c3rec.OI,
2715: user_id => user_id,
2716: login_id => login_id,
2717: prog_appid => prog_appid,

Line 2742: ret_code := INVPUOPI.mtl_log_interface_err(

2738: */
2739: stmt_num := 12;
2740: IF (c3rec.BITC = 4 AND c3rec.RTOFC = 'Y' AND c3rec.BITA in (1,2)
2741: AND c3rec.PCFA = 'Y' AND c3rec.O = 2) THEN
2742: ret_code := INVPUOPI.mtl_log_interface_err(
2743: org_id => c3rec.OI,
2744: user_id => user_id,
2745: login_id => login_id,
2746: prog_appid => prog_appid,

Line 2916: ret_code := INVPUOPI.mtl_log_interface_err(

2912: null;
2913: END;
2914:
2915: IF (err_text is not null) THEN
2916: ret_code := INVPUOPI.mtl_log_interface_err(
2917: org_id => c3rec.OI,
2918: user_id => user_id,
2919: login_id => login_id,
2920: prog_appid => prog_appid,

Line 3276: ret_code := INVPUOPI.mtl_log_interface_err(

3272: AND transaction_type = G_Insert
3273: AND process_flag = 4;
3274:
3275: IF (ref_qty + int_ref_qty <> c3rec.CQ) THEN
3276: ret_code := INVPUOPI.mtl_log_interface_err(
3277: org_id => c3rec.OI,
3278: user_id => user_id,
3279: login_id => login_id,
3280: prog_appid => prog_appid,

Line 3309: ret_code := INVPUOPI.mtl_log_interface_err(

3305: END IF;
3306:
3307: EXCEPTION
3308: WHEN Write_Loc_Error THEN
3309: ret_code := INVPUOPI.mtl_log_interface_err(
3310: org_id => org_id,
3311: user_id => user_id,
3312: login_id => login_id,
3313: prog_appid => prog_appid,

Line 3330: ret_code := INVPUOPI.mtl_log_interface_err(

3326: RAISE ret_code_error;
3327: END IF;
3328:
3329: WHEN Write_Subinv_Error THEN
3330: ret_code := INVPUOPI.mtl_log_interface_err(
3331: org_id => org_id,
3332: user_id => user_id,
3333: login_id => login_id,
3334: prog_appid => prog_appid,

Line 3384: ret_code := INVPUOPI.mtl_log_interface_err(

3380: ret_code := Verify_Component_Count (
3381: bill_seq_id => c1rec.BSI,
3382: err_text => err_text);
3383: IF (ret_code <> 0) THEN
3384: ret_code := INVPUOPI.mtl_log_interface_err(
3385: org_id => c1rec.OI,
3386: user_id => user_id,
3387: login_id => login_id,
3388: prog_appid => prog_appid,

Line 3413: ret_code := INVPUOPI.mtl_log_interface_err(

3409: cmp_seq_id => c1rec.CSI,
3410: exist_flag => 2,
3411: err_text => err_text);
3412: IF (ret_code <> 0) THEN
3413: ret_code := INVPUOPI.mtl_log_interface_err(
3414: org_id => c1rec.OI,
3415: user_id => user_id,
3416: login_id => login_id,
3417: prog_appid => prog_appid,

Line 3447: ret_code := INVPUOPI.mtl_log_interface_err(

3443: act => c1rec.A,
3444: comp_seq_id => 1,
3445: err_text => err_text);
3446: IF (ret_code <> 0) THEN
3447: ret_code := INVPUOPI.mtl_log_interface_err(
3448: org_id => c1rec.OI,
3449: user_id => user_id,
3450: login_id => login_id,
3451: prog_appid => prog_appid,

Line 3484: ret_code := INVPUOPI.mtl_log_interface_err(

3480: act => c1rec.A,
3481: comp_seq_id => 1,
3482: err_text => err_text);
3483: IF (ret_code <> 0) THEN
3484: ret_code := INVPUOPI.mtl_log_interface_err(
3485: org_id => c1rec.OI,
3486: user_id => user_id,
3487: login_id => login_id,
3488: prog_appid => prog_appid,

Line 3512: ret_code := INVPUOPI.mtl_log_interface_err(

3508: */
3509: stmt_num := 4.1;
3510: IF (to_date(c1rec.ED,'YYYY/MM/DD HH24:MI:SS') >
3511: to_date(c1rec.DD,'YYYY/MM/DD HH24:MI:SS')) THEN
3512: ret_code := INVPUOPI.mtl_log_interface_err(
3513: org_id => c1rec.OI,
3514: user_id => user_id,
3515: login_id => login_id,
3516: prog_appid => prog_appid,

Line 3553: ret_code := INVPUOPI.mtl_log_interface_err(

3549: x_assembly_item_id := c1.assembly_item_id;
3550: END LOOP;
3551:
3552: IF (x_bill_type is null) THEN
3553: ret_code := INVPUOPI.mtl_log_interface_err(
3554: org_id => NULL,
3555: user_id => user_id,
3556: login_id => login_id,
3557: prog_appid => prog_appid,

Line 3582: ret_code := INVPUOPI.mtl_log_interface_err(

3578: /***************** This check is not required *****************************
3579: * Fixed Bug: 916428
3580: *
3581: IF (c1rec.PF = 0) THEN
3582: ret_code := INVPUOPI.mtl_log_interface_err(
3583: org_id => c1rec.OI,
3584: user_id => user_id,
3585: login_id => login_id,
3586: prog_appid => prog_appid,

Line 3627: ret_code := INVPUOPI.mtl_log_interface_err(

3623: x_valid_comp := c1.inventory_item_id;
3624: END LOOP;
3625:
3626: IF (x_valid_comp is null) THEN
3627: ret_code := INVPUOPI.mtl_log_interface_err(
3628: org_id => NULL,
3629: user_id => user_id,
3630: login_id => login_id,
3631: prog_appid => prog_appid,

Line 3665: ret_code := INVPUOPI.mtl_log_interface_err(

3661: FROM bom_bill_of_materials
3662: WHERE bill_sequence_id = c1rec.BSI
3663: AND common_bill_sequence_id <> c1rec.BSI;
3664:
3665: ret_code := INVPUOPI.mtl_log_interface_err(
3666: org_id => c1rec.OI,
3667: user_id => user_id,
3668: login_id => login_id,
3669: prog_appid => prog_appid,

Line 3714: ret_code := INVPUOPI.mtl_log_interface_err(

3710: AND msi.eng_item_flag = 'N')))
3711: AND rownum < 2;
3712:
3713: err_text := 'Component item does not exist in common organizations or has incorrect attributes';
3714: ret_code := INVPUOPI.mtl_log_interface_err(
3715: org_id => c1rec.OI,
3716: user_id => user_id,
3717: login_id => login_id,
3718: prog_appid => prog_appid,

Line 3763: ret_code := INVPUOPI.mtl_log_interface_err(

3759: eng_bill => eng_bill,
3760: assy_id => c1rec.AII,
3761: err_text => err_text);
3762: IF (ret_code <> 0) THEN
3763: ret_code := INVPUOPI.mtl_log_interface_err(
3764: org_id => c1rec.OI,
3765: user_id => user_id,
3766: login_id => login_id,
3767: prog_appid => prog_appid,

Line 3824: ret_code := INVPUOPI.mtl_log_interface_err(

3820: end if;
3821: --bugFix 1851537 End
3822:
3823: IF (ret_code <> 0) THEN
3824: ret_code := INVPUOPI.mtl_log_interface_err(
3825: org_id => c1rec.OI,
3826: user_id => user_id,
3827: login_id => login_id,
3828: prog_appid => prog_appid,

Line 3862: ret_code := INVPUOPI.mtl_log_interface_err(

3858: c1rec.AFC = 2)) THEN
3859: null;
3860: ELSE
3861: err_text := 'Planning percentage must be 100';
3862: ret_code := INVPUOPI.mtl_log_interface_err(
3863: org_id => c1rec.OI,
3864: user_id => user_id,
3865: login_id => login_id,
3866: prog_appid => prog_appid,

Line 3899: ret_code := INVPUOPI.mtl_log_interface_err(

3895: WHERE organization_id = c1rec.OI
3896: AND change_notice = c1rec.CN;
3897: EXCEPTION
3898: WHEN no_data_found THEN
3899: ret_code := INVPUOPI.mtl_log_interface_err(
3900: org_id => c1rec.OI,
3901: user_id => user_id,
3902: login_id => login_id,
3903: prog_appid => prog_appid,

Line 3930: ret_code := INVPUOPI.mtl_log_interface_err(

3926: */
3927: stmt_num := 12;
3928: IF (c1rec.BITC = 4 AND c1rec.RTOFC = 'Y' AND c1rec.BITA in (1,2)
3929: AND c1rec.PCFA = 'Y' AND c1rec.O = 2) THEN
3930: ret_code := INVPUOPI.mtl_log_interface_err(
3931: org_id => c1rec.OI,
3932: user_id => user_id,
3933: login_id => login_id,
3934: prog_appid => prog_appid,

Line 4106: ret_code := INVPUOPI.mtl_log_interface_err(

4102: null;
4103: END;
4104:
4105: IF (err_text is not null) THEN
4106: ret_code := INVPUOPI.mtl_log_interface_err(
4107: org_id => c1rec.OI,
4108: user_id => user_id,
4109: login_id => login_id,
4110: prog_appid => prog_appid,

Line 4448: ret_code := INVPUOPI.mtl_log_interface_err(

4444: END IF;
4445:
4446: EXCEPTION
4447: WHEN Write_Loc_Error THEN
4448: ret_code := INVPUOPI.mtl_log_interface_err(
4449: org_id => org_id,
4450: user_id => user_id,
4451: login_id => login_id,
4452: prog_appid => prog_appid,

Line 4469: ret_code := INVPUOPI.mtl_log_interface_err(

4465: RAISE ret_code_error;
4466: END IF;
4467:
4468: WHEN Write_Subinv_Error THEN
4469: ret_code := INVPUOPI.mtl_log_interface_err(
4470: org_id => org_id,
4471: user_id => user_id,
4472: login_id => login_id,
4473: prog_appid => prog_appid,