DBA Data[Home] [Help]

APPS.BOMPASGB dependencies on INVPUOPI

Line 221: ret_code := INVPUOPI.mtl_log_interface_err(

217: for c1rec in c1 loop
218: commit_cnt := commit_cnt + 1;
219: stmt_num := 1;
220: if (c1rec.OI is null) then
221: ret_code := INVPUOPI.mtl_log_interface_err(
222: org_id => NULL,
223: user_id => user_id,
224: login_id => login_id,
225: prog_appid => prog_appid,

Line 242: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

238: end if;
239:
240: stmt_num := 2;
241: if (c1rec.III is null) then
242: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
243: org_id => c1rec.OI,
244: flex_code => 'MSTK',
245: flex_name => c1rec.IIN,
246: flex_id => c1rec.III,

Line 250: ret_code := INVPUOPI.mtl_log_interface_err(

246: flex_id => c1rec.III,
247: set_id => -1,
248: err_text => err_text);
249: if (ret_code <> 0) then
250: ret_code := INVPUOPI.mtl_log_interface_err(
251: org_id => c1rec.OI,
252: user_id => user_id,
253: login_id => login_id,
254: prog_appid => prog_appid,

Line 424: ret_code := INVPUOPI.mtl_log_interface_err(

420: for c1rec in c1 loop
421: commit_cnt := commit_cnt + 1;
422: stmt_num := 2;
423: if (c1rec.OI is null) then
424: ret_code := INVPUOPI.mtl_log_interface_err(
425: org_id => NULL,
426: user_id => user_id,
427: login_id => login_id,
428: prog_appid => prog_appid,

Line 448: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

444: ** set assembly item ids
445: */
446: stmt_num := 3;
447: if (c1rec.AII is null) then
448: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
449: org_id => c1rec.OI,
450: flex_code => 'MSTK',
451: flex_name => c1rec.AIN,
452: flex_id => c1rec.AII,

Line 456: ret_code := INVPUOPI.mtl_log_interface_err(

452: flex_id => c1rec.AII,
453: set_id => -1,
454: err_text => err_text);
455: if (ret_code <> 0) then
456: ret_code := INVPUOPI.mtl_log_interface_err(
457: org_id => NULL,
458: user_id => user_id,
459: login_id => login_id,
460: prog_appid => prog_appid,

Line 485: ret_code := INVPUOPI.mtl_pr_trans_org_id(

481: */
482: stmt_num := 4;
483: if (c1rec.COI is null) and (c1rec.COC is not null) and
484: (c1rec.CBSI is null) then
485: ret_code := INVPUOPI.mtl_pr_trans_org_id(
486: org_code => c1rec.COC,
487: org_id => c1rec.COI,
488: err_text => err_text);
489: if (ret_code <> 0) then

Line 490: ret_code := INVPUOPI.mtl_log_interface_err(

486: org_code => c1rec.COC,
487: org_id => c1rec.COI,
488: err_text => err_text);
489: if (ret_code <> 0) then
490: ret_code := INVPUOPI.mtl_log_interface_err(
491: org_id => NULL,
492: user_id => user_id,
493: login_id => login_id,
494: prog_appid => prog_appid,

Line 522: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

518: c1rec.CBSI is null) then
519: if (c1rec.COI is null) then
520: c1rec.COI := c1rec.OI;
521: end if;
522: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
523: org_id => c1rec.COI,
524: flex_code => 'MSTK',
525: flex_name => c1rec.CAIN,
526: flex_id => c1rec.CAII,

Line 530: ret_code := INVPUOPI.mtl_log_interface_err(

526: flex_id => c1rec.CAII,
527: set_id => -1,
528: err_text => err_text);
529: if (ret_code <> 0) then
530: ret_code := INVPUOPI.mtl_log_interface_err(
531: org_id => NULL,
532: user_id => user_id,
533: login_id => login_id,
534: prog_appid => prog_appid,

Line 688: ret_code := INVPUOPI.mtl_log_interface_err(

684: alt_desg => c2rec.ABD,
685: bill_seq_id => c2rec.CBSI,
686: err_text => err_text);
687: if (ret_code <> 0) then
688: ret_code := INVPUOPI.mtl_log_interface_err(
689: org_id => NULL,
690: user_id => user_id,
691: login_id => login_id,
692: prog_appid => prog_appid,

Line 711: ret_code := INVPUOPI.mtl_log_interface_err(

707: alt_desg => dummy_alt,
708: bill_seq_id => c2rec.CBSI,
709: err_text => err_text);
710: if (ret_code <> 0) then
711: ret_code := INVPUOPI.mtl_log_interface_err(
712: org_id => NULL,
713: user_id => user_id,
714: login_id => login_id,
715: prog_appid => prog_appid,

Line 834: ret_code := INVPUOPI.mtl_log_interface_err(

830: for c1rec in c1 loop
831: commit_cnt := commit_cnt + 1;
832: stmt_num := 1;
833: if (c1rec.OI is null and (c1rec.BSI is null or c1rec.CII is null)) then
834: ret_code := INVPUOPI.mtl_log_interface_err(
835: org_id => NULL,
836: user_id => user_id,
837: login_id => login_id,
838: prog_appid => prog_appid,

Line 855: ret_code := INVPUOPI.mtl_log_interface_err(

851: end if;
852:
853: stmt_num := 1.5;
854: if (c1rec.ED is null) then
855: ret_code := INVPUOPI.mtl_log_interface_err(
856: org_id => NULL,
857: user_id => user_id,
858: login_id => login_id,
859: prog_appid => prog_appid,

Line 876: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

872: end if;
873:
874: stmt_num := 2;
875: if (c1rec.AII is null and c1rec.BSI is null) then
876: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
877: org_id => c1rec.OI,
878: flex_code => 'MSTK',
879: flex_name => c1rec.AIN,
880: flex_id => c1rec.AII,

Line 884: ret_code := INVPUOPI.mtl_log_interface_err(

880: flex_id => c1rec.AII,
881: set_id => -1,
882: err_text => err_text);
883: if (ret_code <> 0) then
884: ret_code := INVPUOPI.mtl_log_interface_err(
885: org_id => NULL,
886: user_id => user_id,
887: login_id => login_id,
888: prog_appid => prog_appid,

Line 909: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

905: end if;
906:
907: stmt_num := 3;
908: if (c1rec.SLI is null and c1rec.LN is not null) then
909: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
910: org_id => c1rec.OI,
911: flex_code => 'MTLL',
912: flex_name => c1rec.LN,
913: flex_id => c1rec.SLI,

Line 917: ret_code := INVPUOPI.mtl_log_interface_err(

913: flex_id => c1rec.SLI,
914: set_id => -1,
915: err_text => err_text);
916: if (ret_code <> 0) then
917: ret_code := INVPUOPI.mtl_log_interface_err(
918: org_id => NULL,
919: user_id => user_id,
920: login_id => login_id,
921: prog_appid => prog_appid,

Line 949: ret_code := INVPUOPI.mtl_log_interface_err(

945: alt_desg => c1rec.ABD,
946: bill_seq_id => c1rec.BSI,
947: err_text => err_text);
948: if (ret_code <> 0) then
949: ret_code := INVPUOPI.mtl_log_interface_err(
950: org_id => c1rec.OI,
951: user_id => user_id,
952: login_id => login_id,
953: prog_appid => prog_appid,

Line 978: ret_code := INVPUOPI.mtl_log_interface_err(

974: alt_desg => c1rec.ABD,
975: bill_seq_id => c1rec.BSI,
976: err_text => err_text);
977: if (ret_code <> 0) then
978: ret_code := INVPUOPI.mtl_log_interface_err(
979: org_id => NULL,
980: user_id => user_id,
981: login_id => login_id,
982: prog_appid => prog_appid,

Line 1003: ret_code := INVPUOPI.mtl_pr_trans_prod_item(

999: end if;
1000:
1001: stmt_num := 5;
1002: if (c1rec.CII is null) then
1003: ret_code := INVPUOPI.mtl_pr_trans_prod_item(
1004: c1rec.CIN,
1005: c1rec.OI,
1006: c1rec.CII,
1007: err_text);

Line 1009: ret_code := INVPUOPI.mtl_log_interface_err(

1005: c1rec.OI,
1006: c1rec.CII,
1007: err_text);
1008: if (ret_code <> 0) then
1009: ret_code := INVPUOPI.mtl_log_interface_err(
1010: org_id => NULL,
1011: user_id => user_id,
1012: login_id => login_id,
1013: prog_appid => prog_appid,

Line 1042: ret_code := INVPUOPI.mtl_log_interface_err(

1038: and inventory_item_id = c1rec.CII;
1039: goto default_op_seq;
1040: EXCEPTION
1041: when NO_DATA_FOUND then
1042: ret_code := INVPUOPI.mtl_log_interface_err(
1043: org_id => NULL,
1044: user_id => user_id,
1045: login_id => login_id,
1046: prog_appid => prog_appid,

Line 1792: ret_code := INVPUOPI.mtl_log_interface_err(

1788: commit_cnt := 0;
1789: for c1rec in c1 loop
1790: commit_cnt := commit_cnt + 1;
1791: if (c1rec.OI is null and (c1rec.BSI is null or c1rec.CII is null)) then
1792: ret_code := INVPUOPI.mtl_log_interface_err(
1793: org_id => NULL,
1794: user_id => user_id,
1795: login_id => login_id,
1796: prog_appid => prog_appid,

Line 1818: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

1814: /*
1815: ** Set assembly item id
1816: */
1817: if (c1rec.AII is null and c1rec.BSI is null) then
1818: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
1819: org_id=> c1rec.OI,
1820: flex_code => 'MSTK',
1821: flex_name => c1rec.AIN,
1822: flex_id => c1rec.AII,

Line 1826: ret_code := INVPUOPI.mtl_log_interface_err(

1822: flex_id => c1rec.AII,
1823: set_id => -1,
1824: err_text => err_text);
1825: if (ret_code <> 0) then
1826: ret_code := INVPUOPI.mtl_log_interface_err(
1827: org_id => NULL,
1828: user_id => user_id,
1829: login_id => login_id,
1830: prog_appid => prog_appid,

Line 1861: ret_code := INVPUOPI.mtl_log_interface_err(

1857: alt_desg => c1rec.ABD,
1858: bill_seq_id => c1rec.BSI,
1859: err_text => err_text);
1860: if (ret_code <> 0) then
1861: ret_code := INVPUOPI.mtl_log_interface_err(
1862: org_id => NULL,
1863: user_id => user_id,
1864: login_id => login_id,
1865: prog_appid => prog_appid,

Line 1890: ret_code := INVPUOPI.mtl_log_interface_err(

1886: alt_desg => c1rec.ABD,
1887: bill_seq_id => c1rec.BSI,
1888: err_text => err_text);
1889: if (ret_code <> 0) then
1890: ret_code := INVPUOPI.mtl_log_interface_err(
1891: org_id => NULL,
1892: user_id => user_id,
1893: login_id => login_id,
1894: prog_appid => prog_appid,

Line 1918: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

1914: ** Set component item id
1915: */
1916:
1917: if (c1rec.CII is null) then
1918: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
1919: org_id=> c1rec.OI,
1920: flex_code => 'MSTK',
1921: flex_name => c1rec.CIN,
1922: flex_id => c1rec.CII,

Line 1926: ret_code := INVPUOPI.mtl_log_interface_err(

1922: flex_id => c1rec.CII,
1923: set_id => -1,
1924: err_text => err_text);
1925: if (ret_code <> 0) then
1926: ret_code := INVPUOPI.mtl_log_interface_err(
1927: org_id => NULL,
1928: user_id => user_id,
1929: login_id => login_id,
1930: prog_appid => prog_appid,

Line 1960: ret_code := INVPUOPI.mtl_log_interface_err(

1956: eff_date => c1rec.ED,
1957: cmp_seq_id => c1rec.CSI,
1958: err_text => err_text);
1959: if (ret_code <> 0) then
1960: ret_code := INVPUOPI.mtl_log_interface_err(
1961: org_id => NULL,
1962: user_id => user_id,
1963: login_id => login_id,
1964: prog_appid => prog_appid,

Line 2226: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

2222: while continue_loop loop
2223: commit_cnt := 0;
2224: for c0rec in c0 loop
2225: commit_cnt := commit_cnt + 1;
2226: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
2227: org_id => c0rec.OI,
2228: flex_code => 'MSTK',
2229: flex_name => c0rec.SCN,
2230: flex_id => c0rec.SCI,

Line 2234: ret_code := INVPUOPI.mtl_log_interface_err(

2230: flex_id => c0rec.SCI,
2231: set_id => -1,
2232: err_text => err_text);
2233: if (ret_code <> 0) then
2234: ret_code := INVPUOPI.mtl_log_interface_err(
2235: org_id => NULL,
2236: user_id => user_id,
2237: login_id => login_id,
2238: prog_appid => prog_appid,

Line 2276: ret_code := INVPUOPI.mtl_log_interface_err(

2272: commit_cnt := 0;
2273: for c1rec in c1 loop
2274: commit_cnt := commit_cnt + 1;
2275: if (c1rec.OI is null and (c1rec.BSI is null or c1rec.CII is null)) then
2276: ret_code := INVPUOPI.mtl_log_interface_err(
2277: org_id => NULL,
2278: user_id => user_id,
2279: login_id => login_id,
2280: prog_appid => prog_appid,

Line 2302: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

2298: /*
2299: ** Set assembly item id
2300: */
2301: if (c1rec.AII is null and c1rec.BSI is null) then
2302: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
2303: org_id=> c1rec.OI,
2304: flex_code => 'MSTK',
2305: flex_name => c1rec.AIN,
2306: flex_id => c1rec.AII,

Line 2310: ret_code := INVPUOPI.mtl_log_interface_err(

2306: flex_id => c1rec.AII,
2307: set_id => -1,
2308: err_text => err_text);
2309: if (ret_code <> 0) then
2310: ret_code := INVPUOPI.mtl_log_interface_err(
2311: org_id => NULL,
2312: user_id => user_id,
2313: login_id => login_id,
2314: prog_appid => prog_appid,

Line 2345: ret_code := INVPUOPI.mtl_log_interface_err(

2341: alt_desg => c1rec.ABD,
2342: bill_seq_id => c1rec.BSI,
2343: err_text => err_text);
2344: if (ret_code <> 0) then
2345: ret_code := INVPUOPI.mtl_log_interface_err(
2346: org_id => NULL,
2347: user_id => user_id,
2348: login_id => login_id,
2349: prog_appid => prog_appid,

Line 2373: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

2369: ** Set component item id
2370: */
2371:
2372: if (c1rec.CII is null) then
2373: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
2374: org_id=> c1rec.OI,
2375: flex_code => 'MSTK',
2376: flex_name => c1rec.CIN,
2377: flex_id => c1rec.CII,

Line 2381: ret_code := INVPUOPI.mtl_log_interface_err(

2377: flex_id => c1rec.CII,
2378: set_id => -1,
2379: err_text => err_text);
2380: if (ret_code <> 0) then
2381: ret_code := INVPUOPI.mtl_log_interface_err(
2382: org_id => NULL,
2383: user_id => user_id,
2384: login_id => login_id,
2385: prog_appid => prog_appid,

Line 2415: ret_code := INVPUOPI.mtl_log_interface_err(

2411: eff_date => c1rec.ED,
2412: cmp_seq_id => c1rec.CSI,
2413: err_text => err_text);
2414: if (ret_code <> 0) then
2415: ret_code := INVPUOPI.mtl_log_interface_err(
2416: org_id => NULL,
2417: user_id => user_id,
2418: login_id => login_id,
2419: prog_appid => prog_appid,

Line 2470: ret_code := INVPUOPI.mtl_log_interface_err(

2466: comp_seq_id => c2rec.CSI,
2467: comp_qty => c2rec.SIQ,
2468: err_text => err_text);
2469: if (ret_code <> 0) then
2470: ret_code := INVPUOPI.mtl_log_interface_err(
2471: org_id => NULL,
2472: user_id => user_id,
2473: login_id => login_id,
2474: prog_appid => prog_appid,