DBA Data[Home] [Help]

APPS.BOMPVALR dependencies on INVPUOPI

Line 94: ret_code := INVPUOPI.mtl_log_interface_err(

90: from mtl_parameters
91: where organization_id = c1rec.OI;
92: EXCEPTION
93: when NO_DATA_FOUND then
94: ret_code := INVPUOPI.mtl_log_interface_err(
95: org_id => c1rec.OI,
96: user_id => user_id,
97: login_id => login_id,
98: prog_appid => prog_appid,

Line 125: ret_code := INVPUOPI.mtl_log_interface_err(

121: where organization_id = c1rec.OI
122: and alternate_designator_code = c1rec.ARD;
123: EXCEPTION
124: when NO_DATA_FOUND then
125: ret_code := INVPUOPI.mtl_log_interface_err(
126: org_id => c1rec.OI,
127: user_id => user_id,
128: login_id => login_id,
129: prog_appid => prog_appid,

Line 154: ret_code := INVPUOPI.mtl_log_interface_err(

150: org_id => c1rec.OI,
151: assy_id => c1rec.AII,
152: err_text => err_text);
153: if (ret_code <> 0) then
154: ret_code := INVPUOPI.mtl_log_interface_err(
155: org_id => c1rec.OI,
156: user_id => user_id,
157: login_id => login_id,
158: prog_appid => prog_appid,

Line 178: ret_code := INVPUOPI.mtl_log_interface_err(

174: end if;
175:
176: stmt_num := 4; /* routing_type must be 1 or 2 */
177: if (c1rec.RT <> 1) and (c1rec.RT <> 2) then
178: ret_code := INVPUOPI.mtl_log_interface_err(
179: org_id => c1rec.OI,
180: user_id => user_id,
181: login_id => login_id,
182: prog_appid => prog_appid,

Line 206: ret_code := INVPUOPI.mtl_log_interface_err(

202: rtg_seq_id => c1rec.RSI,
203: mode_type => 1,
204: err_text => err_text);
205: if (ret_code <> 0) then
206: ret_code := INVPUOPI.mtl_log_interface_err(
207: org_id => NULL,
208: user_id => user_id,
209: login_id => login_id,
210: prog_appid => prog_appid,

Line 241: ret_code := INVPUOPI.mtl_log_interface_err(

237: alt_desg => c1rec.ARD,
238: rtg_type => c1rec.RT,
239: err_text => err_text);
240: if (ret_code <> 0) then
241: ret_code := INVPUOPI.mtl_log_interface_err(
242: org_id => c1rec.OI,
243: user_id => user_id,
244: login_id => login_id,
245: prog_appid => prog_appid,

Line 271: ret_code := INVPUOPI.mtl_log_interface_err(

267: assy_id => c1rec.AII,
268: rtg_type => c1rec.RT,
269: err_text => err_text);
270: if (ret_code <> 0) then
271: ret_code := INVPUOPI.mtl_log_interface_err(
272: org_id => NULL,
273: user_id => user_id,
274: login_id => login_id,
275: prog_appid => prog_appid,

Line 303: ret_code := INVPUOPI.mtl_log_interface_err(

299: rtg_seq_id => c1rec.CRSI,
300: mode_type => 2,
301: err_text => err_text);
302: if (ret_code <> 0) then
303: ret_code := INVPUOPI.mtl_log_interface_err(
304: org_id => c1rec.OI,
305: user_id => user_id,
306: login_id => login_id,
307: prog_appid => prog_appid,

Line 336: ret_code := INVPUOPI.mtl_log_interface_err(

332: org_id => c1rec.OI,
333: alt_desg => c1rec.ARD,
334: err_text => err_text);
335: if (ret_code <> 0) then
336: ret_code := INVPUOPI.mtl_log_interface_err(
337: org_id => NULL,
338: user_id => user_id,
339: login_id => login_id,
340: prog_appid => prog_appid,

Line 650: ret_code := INVPUOPI.mtl_log_interface_err(

646:
647: goto update_comp;
648:
649: <>
650: ret_code := INVPUOPI.mtl_log_interface_err(
651: org_id => org_id,
652: user_id => user_id,
653: login_id => login_id,
654: prog_appid => prog_appid,

Line 672: ret_code := INVPUOPI.mtl_log_interface_err(

668: end if;
669: goto continue_loop;
670:
671: <>
672: ret_code := INVPUOPI.mtl_log_interface_err(
673: org_id => org_id,
674: user_id => user_id,
675: login_id => login_id,
676: prog_appid => prog_appid,

Line 777: ret_code := INVPUOPI.mtl_log_interface_err(

773: */
774: commit_cnt := commit_cnt + 1;
775: stmt_num := 1;
776: if (c1rec.OSN is null) then
777: ret_code := INVPUOPI.mtl_log_interface_err(
778: org_id => NULL,
779: user_id => user_id,
780: login_id => login_id,
781: prog_appid => prog_appid,

Line 807: ret_code := INVPUOPI.mtl_log_interface_err(

803: op_seq_id => c1rec.OSI,
804: exist_flag => 2,
805: err_text => err_text);
806: if (ret_code <> 0) then
807: ret_code := INVPUOPI.mtl_log_interface_err(
808: org_id => NULL,
809: user_id => user_id,
810: login_id => login_id,
811: prog_appid => prog_appid,

Line 838: ret_code := INVPUOPI.mtl_log_interface_err(

834: eff_date => c1rec.ED,
835: op_seq => c1rec.OSN,
836: err_text => err_text);
837: if (ret_code <> 0) then
838: ret_code := INVPUOPI.mtl_log_interface_err(
839: org_id => c1rec.OI,
840: user_id => user_id,
841: login_id => login_id,
842: prog_appid => prog_appid,

Line 868: ret_code := INVPUOPI.mtl_log_interface_err(

864: rtg_seq_id => c1rec.RSI,
865: mode_type => 2,
866: err_text => err_text);
867: if (ret_code <> 0) then
868: ret_code := INVPUOPI.mtl_log_interface_err(
869: org_id => NULL,
870: user_id => user_id,
871: login_id => login_id,
872: prog_appid => prog_appid,

Line 900: ret_code := INVPUOPI.mtl_log_interface_err(

896: eff_date => c1rec.ED,
897: dis_date => c1rec.DD,
898: err_text => err_text);
899: if (ret_code <> 0) then
900: ret_code := INVPUOPI.mtl_log_interface_err(
901: org_id => NULL,
902: user_id => user_id,
903: login_id => login_id,
904: prog_appid => prog_appid,

Line 931: ret_code := INVPUOPI.mtl_log_interface_err(

927: dept_id => c1rec.DI,
928: eff_date => c1rec.ED,
929: err_text => err_text);
930: if (ret_code <> 0) then
931: ret_code := INVPUOPI.mtl_log_interface_err(
932: org_id => NULL,
933: user_id => user_id,
934: login_id => login_id,
935: prog_appid => prog_appid,

Line 964: ret_code := INVPUOPI.mtl_log_interface_err(

960: from bom_operational_routings
961: where routing_sequence_id = c1rec.RSI
962: and common_routing_sequence_id <> c1rec.RSI;
963:
964: ret_code := INVPUOPI.mtl_log_interface_err(
965: org_id => c1rec.OI,
966: user_id => user_id,
967: login_id => login_id,
968: prog_appid => prog_appid,

Line 996: ret_code := INVPUOPI.mtl_log_interface_err(

992: where routing_sequence_id = c1rec.RSI
993: and process_flag = 4
994: and common_routing_sequence_id <> c1rec.RSI;
995:
996: ret_code := INVPUOPI.mtl_log_interface_err(
997: org_id => c1rec.OI,
998: user_id => user_id,
999: login_id => login_id,
1000: prog_appid => prog_appid,

Line 1058: ret_code := INVPUOPI.mtl_log_interface_err(

1054: err_text := 'OPERATION_LEAD_TIME_PERCENT must be between 0 and 100';
1055: end if;
1056:
1057: if (err_text is not null) then
1058: ret_code := INVPUOPI.mtl_log_interface_err(
1059: org_id => c1rec.OI,
1060: user_id => user_id,
1061: login_id => login_id,
1062: prog_appid => prog_appid,

Line 1188: ret_code := INVPUOPI.mtl_log_interface_err(

1184:
1185: if (dummy = 0) then
1186: NULL;
1187: else
1188: ret_code := INVPUOPI.mtl_log_interface_err(
1189: org_id => org_id,
1190: user_id => user_id,
1191: login_id => login_id,
1192: prog_appid => prog_appid,

Line 1218: ret_code := INVPUOPI.mtl_log_interface_err(

1214: op_seq_id => c1rec.OSI,
1215: exist_flag => 1,
1216: err_text => err_text);
1217: if (ret_code <> 0) then
1218: ret_code := INVPUOPI.mtl_log_interface_err(
1219: org_id => NULL,
1220: user_id => user_id,
1221: login_id => login_id,
1222: prog_appid => prog_appid,

Line 1275: ret_code := INVPUOPI.mtl_log_interface_err(

1271: and nvl(br.disable_date, dummy_eff + 1) > dummy_eff
1272: and bdr.department_id = dept_id
1273: and bdr.resource_id = ori.resource_id);
1274: if (res_cnt <> 0) then
1275: ret_code := INVPUOPI.mtl_log_interface_err(
1276: org_id => NULL,
1277: user_id => user_id,
1278: login_id => login_id,
1279: prog_appid => prog_appid,

Line 1312: ret_code := INVPUOPI.mtl_log_interface_err(

1308: and nvl(ca.organization_id, ori.organization_id)
1309: = ori.organization_id
1310: and nvl(ca.disable_date, dummy_eff + 1) > dummy_eff);
1311: if (res_cnt <> 0) then
1312: ret_code := INVPUOPI.mtl_log_interface_err(
1313: org_id => NULL,
1314: user_id => user_id,
1315: login_id => login_id,
1316: prog_appid => prog_appid,

Line 1340: ret_code := INVPUOPI.mtl_log_interface_err(

1336: ret_code := bmvunres_verify_unique_res (
1337: trans_id => c1rec.TI,
1338: err_text => err_text);
1339: if (ret_code <> 0) then
1340: ret_code := INVPUOPI.mtl_log_interface_err(
1341: org_id => NULL,
1342: user_id => user_id,
1343: login_id => login_id,
1344: prog_appid => prog_appid,

Line 1426: ret_code := INVPUOPI.mtl_log_interface_err(

1422: and b.uom_class = hr_uom_class ))
1423: );
1424:
1425: if (res_cnt > 0) then
1426: ret_code := INVPUOPI.mtl_log_interface_err(
1427: org_id => NULL,
1428: user_id => user_id,
1429: login_id => login_id,
1430: prog_appid => prog_appid,

Line 1457: ret_code := INVPUOPI.mtl_log_interface_err(

1453: op_seq => c1rec.OSI,
1454: sched_type => 3, /* Prior */
1455: err_text => err_text);
1456: if (ret_code <> 0) then
1457: ret_code := INVPUOPI.mtl_log_interface_err(
1458: org_id => NULL,
1459: user_id => user_id,
1460: login_id => login_id,
1461: prog_appid => prog_appid,

Line 1484: ret_code := INVPUOPI.mtl_log_interface_err(

1480: op_seq => c1rec.OSI,
1481: sched_type => 4, /* Next */
1482: err_text => err_text);
1483: if (ret_code <> 0) then
1484: ret_code := INVPUOPI.mtl_log_interface_err(
1485: org_id => NULL,
1486: user_id => user_id,
1487: login_id => login_id,
1488: prog_appid => prog_appid,

Line 1526: ret_code := INVPUOPI.mtl_log_interface_err(

1522: where br.resource_id = bori.resource_id
1523: and mum.uom_code = br.unit_of_measure))
1524: );
1525: if (res_cnt <> 0) then
1526: ret_code := INVPUOPI.mtl_log_interface_err(
1527: org_id => NULL,
1528: user_id => user_id,
1529: login_id => login_id,
1530: prog_appid => prog_appid,

Line 1560: ret_code := INVPUOPI.mtl_log_interface_err(

1556: where operation_sequence_id = c1rec.OSI
1557: and assigned_units <= .00001;
1558:
1559: if (res_cnt <> 0) then
1560: ret_code := INVPUOPI.mtl_log_interface_err(
1561: org_id => NULL,
1562: user_id => user_id,
1563: login_id => login_id,
1564: prog_appid => prog_appid,

Line 1599: ret_code := INVPUOPI.mtl_log_interface_err(

1595: or
1596: (autocharge_type not in (1,2,3,4))
1597: );
1598: if (res_cnt <> 0) then
1599: ret_code := INVPUOPI.mtl_log_interface_err(
1600: org_id => NULL,
1601: user_id => user_id,
1602: login_id => login_id,
1603: prog_appid => prog_appid,

Line 1630: ret_code := INVPUOPI.mtl_log_interface_err(

1626: op_seq => c1rec.OSI,
1627: dept_id => dept_id,
1628: err_text => err_text);
1629: if (ret_code <> 0) then
1630: ret_code := INVPUOPI.mtl_log_interface_err(
1631: org_id => NULL,
1632: user_id => user_id,
1633: login_id => login_id,
1634: prog_appid => prog_appid,

Line 1661: ret_code := INVPUOPI.mtl_log_interface_err(

1657: and resource_offset_percent not between 0 and 100
1658: and resource_offset_percent is not null;
1659:
1660: if (res_cnt <> 0) then
1661: ret_code := INVPUOPI.mtl_log_interface_err(
1662: org_id => NULL,
1663: user_id => user_id,
1664: login_id => login_id,
1665: prog_appid => prog_appid,

Line 1695: ret_code := INVPUOPI.mtl_log_interface_err(

1691: round((1/usage_rate_or_amount_inverse),G_round_off_val)
1692: );
1693:
1694: if (res_cnt <> 0) then
1695: ret_code := INVPUOPI.mtl_log_interface_err(
1696: org_id => NULL,
1697: user_id => user_id,
1698: login_id => login_id,
1699: prog_appid => prog_appid,

Line 1895: ret_code := INVPUOPI.mtl_log_interface_err(

1891: for c0rec in c0 loop
1892: commit_cnt := commit_cnt + 1;
1893: stmt_num := 1;
1894: if (c0rec.PR is null) then
1895: ret_code := INVPUOPI.mtl_log_interface_err(
1896: org_id => org_id,
1897: user_id => user_id,
1898: login_id => login_id,
1899: prog_appid => prog_appid,

Line 1927: ret_code := INVPUOPI.mtl_log_interface_err(

1923: from mtl_parameters
1924: where organization_id = c0rec.OI;
1925: EXCEPTION
1926: when NO_DATA_FOUND then
1927: ret_code := INVPUOPI.mtl_log_interface_err(
1928: org_id => c0rec.OI,
1929: user_id => user_id,
1930: login_id => login_id,
1931: prog_appid => prog_appid,

Line 1955: ret_code := INVPUOPI.mtl_log_interface_err(

1951: org_id => c0rec.OI,
1952: assy_id => c0rec.AII,
1953: err_text => err_text);
1954: if (ret_code <> 0) then
1955: ret_code := INVPUOPI.mtl_log_interface_err(
1956: org_id => c0rec.OI,
1957: user_id => user_id,
1958: login_id => login_id,
1959: prog_appid => prog_appid,

Line 1996: ret_code := INVPUOPI.mtl_log_interface_err(

1992: and organization_id = c0rec.OI
1993: and assembly_item_id = c0rec.AII;
1994:
1995: if (dummy_rtg = 0) then
1996: ret_code := INVPUOPI.mtl_log_interface_err(
1997: org_id => c0rec.OI,
1998: user_id => user_id,
1999: login_id => login_id,
2000: prog_appid => prog_appid,

Line 2173: ret_code := INVPUOPI.mtl_log_interface_err(

2169: where transaction_id = c1rec.TI;
2170: goto continue_loop;
2171:
2172: <>
2173: ret_code := INVPUOPI.mtl_log_interface_err(
2174: org_id => org_id,
2175: user_id => user_id,
2176: login_id => login_id,
2177: prog_appid => prog_appid,