DBA Data[Home] [Help]

APPS.BOMPASGR dependencies on INVPUOPI

Line 202: ret_code := INVPUOPI.mtl_log_interface_err(

198: for c1rec in c1 loop
199: commit_cnt := commit_cnt + 1;
200: stmt_num := 1;
201: if (c1rec.OI is null) then
202: ret_code := INVPUOPI.mtl_log_interface_err(
203: org_id => NULL,
204: user_id => user_id,
205: login_id => login_id,
206: prog_appid => prog_appid,

Line 223: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

219: end if;
220:
221: stmt_num := 2;
222: if (c1rec.III is null) then
223: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
224: org_id => c1rec.OI,
225: flex_code => 'MSTK',
226: flex_name => c1rec.IIN,
227: flex_id => c1rec.III,

Line 231: ret_code := INVPUOPI.mtl_log_interface_err(

227: flex_id => c1rec.III,
228: set_id => -1,
229: err_text => err_text);
230: if (ret_code <> 0) then
231: ret_code := INVPUOPI.mtl_log_interface_err(
232: org_id => c1rec.OI,
233: user_id => user_id,
234: login_id => login_id,
235: prog_appid => prog_appid,

Line 398: ret_code := INVPUOPI.mtl_log_interface_err(

394: for c1rec in c1 loop
395: commit_cnt := commit_cnt + 1;
396: stmt_num := 2;
397: if (c1rec.OI is null) then
398: ret_code := INVPUOPI.mtl_log_interface_err(
399: org_id => NULL,
400: user_id => user_id,
401: login_id => login_id,
402: prog_appid => prog_appid,

Line 422: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

418: ** set assembly item ids
419: */
420: stmt_num := 3;
421: if (c1rec.AII is null) then
422: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
423: org_id => c1rec.OI,
424: flex_code => 'MSTK',
425: flex_name => c1rec.AIN,
426: flex_id => c1rec.AII,

Line 430: ret_code := INVPUOPI.mtl_log_interface_err(

426: flex_id => c1rec.AII,
427: set_id => -1,
428: err_text => err_text);
429: if (ret_code <> 0) then
430: ret_code := INVPUOPI.mtl_log_interface_err(
431: org_id => NULL,
432: user_id => user_id,
433: login_id => login_id,
434: prog_appid => prog_appid,

Line 458: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

454: ** set locator id
455: */
456: stmt_num := 4;
457: if (c1rec.CLI is null and c1rec.LN is not null) then
458: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
459: org_id => c1rec.OI,
460: flex_code => 'MTLL',
461: flex_name => c1rec.LN,
462: flex_id => c1rec.CLI,

Line 466: ret_code := INVPUOPI.mtl_log_interface_err(

462: flex_id => c1rec.CLI,
463: set_id => -1,
464: err_text => err_text);
465: if (ret_code <> 0) then
466: ret_code := INVPUOPI.mtl_log_interface_err(
467: org_id => NULL,
468: user_id => user_id,
469: login_id => login_id,
470: prog_appid => prog_appid,

Line 495: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

491: */
492: stmt_num := 5;
493: if (c1rec.CAII is null and c1rec.CAIN is not null and
494: c1rec.CRSI is null) then
495: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
496: org_id => c1rec.OI,
497: flex_code => 'MSTK',
498: flex_name => c1rec.CAIN,
499: flex_id => c1rec.CAII,

Line 503: ret_code := INVPUOPI.mtl_log_interface_err(

499: flex_id => c1rec.CAII,
500: set_id => -1,
501: err_text => err_text);
502: if (ret_code <> 0) then
503: ret_code := INVPUOPI.mtl_log_interface_err(
504: org_id => NULL,
505: user_id => user_id,
506: login_id => login_id,
507: prog_appid => prog_appid,

Line 712: ret_code := INVPUOPI.mtl_log_interface_err(

708: alt_desg => c2rec.ARD,
709: routing_seq_id => c2rec.CRSI,
710: err_text => err_text);
711: if (ret_code <> 0) then
712: ret_code := INVPUOPI.mtl_log_interface_err(
713: org_id => NULL,
714: user_id => user_id,
715: login_id => login_id,
716: prog_appid => prog_appid,

Line 735: ret_code := INVPUOPI.mtl_log_interface_err(

731: alt_desg => dummy_alt,
732: rtg_seq_id => c2rec.CRSI,
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 892: ret_code := INVPUOPI.mtl_log_interface_err(

888: stmt_num := 1;
889: if (c1rec.OI is null and (c1rec.RSI is null or
890: c1rec.DI is null or (c1rec.SOI is null and
891: c1rec.SOC is not null))) then
892: ret_code := INVPUOPI.mtl_log_interface_err(
893: org_id => NULL,
894: user_id => user_id,
895: login_id => login_id,
896: prog_appid => prog_appid,

Line 913: ret_code := INVPUOPI.mtl_log_interface_err(

909: end if;
910:
911: stmt_num := 1.5;
912: if (c1rec.ED is null) then
913: ret_code := INVPUOPI.mtl_log_interface_err(
914: org_id => NULL,
915: user_id => user_id,
916: login_id => login_id,
917: prog_appid => prog_appid,

Line 935: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

931:
932:
933: stmt_num := 2;
934: if (c1rec.AII is null and c1rec.RSI is null) then
935: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
936: org_id => c1rec.OI,
937: flex_code => 'MSTK',
938: flex_name => c1rec.AIN,
939: flex_id => c1rec.AII,

Line 943: ret_code := INVPUOPI.mtl_log_interface_err(

939: flex_id => c1rec.AII,
940: set_id => -1,
941: err_text => err_text);
942: if (ret_code <> 0) then
943: ret_code := INVPUOPI.mtl_log_interface_err(
944: org_id => c1rec.OI,
945: user_id => user_id,
946: login_id => login_id,
947: prog_appid => prog_appid,

Line 975: ret_code := INVPUOPI.mtl_log_interface_err(

971: alt_desg => c1rec.ARD,
972: routing_seq_id => c1rec.RSI,
973: err_text => err_text);
974: if (ret_code <> 0) then
975: ret_code := INVPUOPI.mtl_log_interface_err(
976: org_id => c1rec.OI,
977: user_id => user_id,
978: login_id => login_id,
979: prog_appid => prog_appid,

Line 1004: ret_code := INVPUOPI.mtl_log_interface_err(

1000: alt_desg => c1rec.ARD,
1001: rtg_seq_id => c1rec.RSI,
1002: err_text => err_text);
1003: if (ret_code <> 0) then
1004: ret_code := INVPUOPI.mtl_log_interface_err(
1005: org_id => NULL,
1006: user_id => user_id,
1007: login_id => login_id,
1008: prog_appid => prog_appid,

Line 1035: ret_code := INVPUOPI.mtl_log_interface_err(

1031: stdop_code => c1rec.SOC,
1032: stdop_id => c1rec.SOI,
1033: err_text => err_text);
1034: if (ret_code <> 0) then
1035: ret_code := INVPUOPI.mtl_log_interface_err(
1036: org_id => c1rec.OI,
1037: user_id => user_id,
1038: login_id => login_id,
1039: prog_appid => prog_appid,

Line 1066: ret_code := INVPUOPI.mtl_log_interface_err(

1062: dept_code => c1rec.DC,
1063: dept_id => c1rec.DI,
1064: err_text => err_text);
1065: if (ret_code <> 0) then
1066: ret_code := INVPUOPI.mtl_log_interface_err(
1067: org_id => c1rec.OI,
1068: user_id => user_id,
1069: login_id => login_id,
1070: prog_appid => prog_appid,

Line 1112: ret_code := INVPUOPI.mtl_log_interface_err(

1108: where organization_id = c1rec.OI
1109: and standard_operation_id = c1rec.SOI;
1110: exception
1111: when NO_DATA_FOUND then
1112: ret_code := INVPUOPI.mtl_log_interface_err(
1113: org_id => c1rec.OI,
1114: user_id => user_id,
1115: login_id => login_id,
1116: prog_appid => prog_appid,

Line 1596: ret_code := INVPUOPI.mtl_log_interface_err(

1592: commit_cnt := 0;
1593: for c1rec in c1 loop
1594: commit_cnt := commit_cnt + 1;
1595: if (c1rec.OI is null and c1rec.RSI is null) then
1596: ret_code := INVPUOPI.mtl_log_interface_err(
1597: org_id => NULL,
1598: user_id => user_id,
1599: login_id => login_id,
1600: prog_appid => prog_appid,

Line 1623: ret_code := INVPUOPI.mtl_pr_parse_flex_name(

1619: ** Set assembly item id
1620: */
1621: stmt_num := 5;
1622: if (c1rec.AII is null and c1rec.RSI is null) then
1623: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
1624: org_id=> c1rec.OI,
1625: flex_code => 'MSTK',
1626: flex_name => c1rec.AIN,
1627: flex_id => c1rec.AII,

Line 1631: ret_code := INVPUOPI.mtl_log_interface_err(

1627: flex_id => c1rec.AII,
1628: set_id => -1,
1629: err_text => err_text);
1630: if (ret_code <> 0) then
1631: ret_code := INVPUOPI.mtl_log_interface_err(
1632: org_id => c1rec.OI,
1633: user_id => user_id,
1634: login_id => login_id,
1635: prog_appid => prog_appid,

Line 1666: ret_code := INVPUOPI.mtl_log_interface_err(

1662: alt_desg => c1rec.ARD,
1663: routing_seq_id => c1rec.RSI,
1664: err_text => err_text);
1665: if (ret_code <> 0) then
1666: ret_code := INVPUOPI.mtl_log_interface_err(
1667: org_id => c1rec.OI,
1668: user_id => user_id,
1669: login_id => login_id,
1670: prog_appid => prog_appid,

Line 1700: ret_code := INVPUOPI.mtl_log_interface_err(

1696: eff_date => c1rec.ED,
1697: op_seq_id => c1rec.OSI,
1698: err_text => err_text);
1699: if (ret_code <> 0) then
1700: ret_code := INVPUOPI.mtl_log_interface_err(
1701: org_id => NULL,
1702: user_id => user_id,
1703: login_id => login_id,
1704: prog_appid => prog_appid,

Line 1791: ret_code := INVPUOPI.mtl_log_interface_err(

1787: and rownum = 1;
1788: goto get_resource;
1789: exception
1790: when NO_DATA_FOUND then
1791: ret_code := INVPUOPI.mtl_log_interface_err(
1792: org_id => NULL,
1793: user_id => user_id,
1794: login_id => login_id,
1795: prog_appid => prog_appid,

Line 1830: ret_code := INVPUOPI.mtl_log_interface_err(

1826: where resource_code = c2rec.RC
1827: and organization_id = c2rec.OI;
1828: EXCEPTION
1829: when NO_DATA_FOUND then
1830: ret_code := INVPUOPI.mtl_log_interface_err(
1831: org_id => NULL,
1832: user_id => user_id,
1833: login_id => login_id,
1834: prog_appid => prog_appid,

Line 1865: ret_code := INVPUOPI.mtl_log_interface_err(

1861: where activity = c2rec.A
1862: and nvl(organization_id,c2rec.OI) = c2rec.OI;
1863: EXCEPTION
1864: when NO_DATA_FOUND then
1865: ret_code := INVPUOPI.mtl_log_interface_err(
1866: org_id => NULL,
1867: user_id => user_id,
1868: login_id => login_id,
1869: prog_appid => prog_appid,

Line 1936: ret_code := INVPUOPI.mtl_log_interface_err(

1932: and rownum = 1;
1933:
1934: EXCEPTION
1935: when NO_DATA_FOUND then
1936: ret_code := INVPUOPI.mtl_log_interface_err(
1937: org_id => NULL,
1938: user_id => user_id,
1939: login_id => login_id,
1940: prog_appid => prog_appid,

Line 1975: ret_code := INVPUOPI.mtl_log_interface_err(

1971: end if;
1972:
1973: EXCEPTION
1974: when NO_DATA_FOUND then
1975: ret_code := INVPUOPI.mtl_log_interface_err(
1976: org_id => NULL,
1977: user_id => user_id,
1978: login_id => login_id,
1979: prog_appid => prog_appid,