DBA Data[Home] [Help]

APPS.INVPVHDR dependencies on INVPUOPI

Line 599: dumm_status := INVPUOPI.mtl_pr_parse_item_segments

595: end loop; /* Finished populating the bindvals1() plsql table*/
596:
597: --Start 3360280:KFV validation using fnd_flex_keyval
598: if cr.item_number IS NULL then
599: dumm_status := INVPUOPI.mtl_pr_parse_item_segments
600: (p_row_id => cr.rowid
601: ,item_number => l_item_number
602: ,item_id => l_item_id
603: ,err_text => err_text);

Line 607: dumm_status := INVPUOPI.mtl_pr_parse_item_number(l_item_number

603: ,err_text => err_text);
604:
605: --Bug: 5512333
606: if cr.item_number IS NOT NULL THEN
607: dumm_status := INVPUOPI.mtl_pr_parse_item_number(l_item_number
608: ,cr.inventory_item_id
609: ,cr.transaction_id
610: ,cr.organization_id
611: ,err_text

Line 615: dumm_status := INVPUOPI.mtl_log_interface_err(

611: ,err_text
612: ,cr.rowid);
613: if dumm_status < 0 THEN
614: status := 1;
615: dumm_status := INVPUOPI.mtl_log_interface_err(
616: cr.organization_id
617: ,user_id
618: ,login_id
619: ,prog_appid

Line 664: dumm_status := INVPUOPI.mtl_log_interface_err(

660: concat_segments => l_item_number);
661:
662: IF NOT l_valid_segments THEN
663: status := 1;
664: dumm_status := INVPUOPI.mtl_log_interface_err(
665: cr.organization_id,
666: user_id,
667: login_id,
668: prog_appid,

Line 688: dumm_status := INVPUOPI.mtl_log_interface_err(

684: FND_MESSAGE.SET_NAME ('INV', 'INV_ITEM_SEGMENTS_INVALID');
685: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', l_item_number);
686: error_msg := FND_MESSAGE.GET;
687:
688: dumm_status := INVPUOPI.mtl_log_interface_err(
689: cr.organization_id,
690: user_id,
691: login_id,
692: prog_appid,

Line 1041: dumm_status := INVPUOPI.mtl_log_interface_err(

1037: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_ITEM_MSI');
1038: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1039: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1040: error_msg := FND_MESSAGE.GET;
1041: dumm_status := INVPUOPI.mtl_log_interface_err(
1042: cr.organization_id,
1043: user_id,
1044: login_id,
1045: prog_appid,

Line 1090: dumm_status := INVPUOPI.mtl_log_interface_err(

1086: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_REC_MSII');
1087: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1088: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1089: error_msg := FND_MESSAGE.GET;
1090: dumm_status := INVPUOPI.mtl_log_interface_err(
1091: cr.organization_id,
1092: user_id,
1093: login_id,
1094: prog_appid,

Line 1205: dumm_status := INVPUOPI.mtl_log_interface_err(

1201: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_ITEM_MSI');
1202: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1203: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1204: error_msg := FND_MESSAGE.GET;
1205: dumm_status := INVPUOPI.mtl_log_interface_err(
1206: cr.organization_id,
1207: user_id,
1208: login_id,
1209: prog_appid,

Line 1330: dumm_status := INVPUOPI.mtl_log_interface_err(

1326: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_REC_MSII');
1327: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1328: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1329: error_msg := FND_MESSAGE.GET;
1330: dumm_status := INVPUOPI.mtl_log_interface_err(
1331: cr.organization_id,
1332: user_id,
1333: login_id,
1334: prog_appid,

Line 1353: dumm_status := INVPUOPI.mtl_log_interface_err(

1349: END IF; /* Crucial If*/
1350:
1351: /* R12C Desc Null chk, since check in Defaulting phase is bypassed for func generated ICC catalog items */
1352: IF cr.description IS NULL THEN
1353: dumm_status := INVPUOPI.mtl_log_interface_err(
1354: cr.organization_id,
1355: user_id,
1356: login_id,
1357: prog_appid,

Line 1388: dumm_status := INVPUOPI.mtl_log_interface_err(

1384: ** if either exists then INVPVDR5 handles it later.
1385: */
1386: if cr.PRIMARY_UOM_CODE is NULL
1387: and cr.PRIMARY_UNIT_OF_MEASURE is NULL then
1388: dumm_status := INVPUOPI.mtl_log_interface_err(
1389: cr.organization_id,
1390: user_id,
1391: login_id,
1392: prog_appid,

Line 1411: dumm_status := INVPUOPI.mtl_log_interface_err(

1407: -- validate INTERNAL_ORDER_FLAG
1408: -- Added for bug 4260213
1409: if cr.INTERNAL_ORDER_FLAG = 'Y' AND cr.SHIPPABLE_ITEM_FLAG = 'N'
1410: then
1411: dumm_status := INVPUOPI.mtl_log_interface_err(
1412: cr.organization_id,
1413: user_id,
1414: login_id,
1415: prog_appid,

Line 1433: dumm_status := INVPUOPI.mtl_log_interface_err(

1429:
1430: -- validate BOM_ITEM_TYPE
1431: --Added for bug 3436384
1432: if cr.BOM_ITEM_TYPE = 5 AND cr.CUSTOMER_ORDER_FLAG <> 'N' then
1433: dumm_status := INVPUOPI.mtl_log_interface_err(
1434: cr.organization_id,
1435: user_id,
1436: login_id,
1437: prog_appid,

Line 1454: dumm_status := INVPUOPI.mtl_log_interface_err(

1450: end if;
1451:
1452: if cr.BOM_ITEM_TYPE = 3 then
1453: if cr.CUSTOMER_ORDER_FLAG <> 'N' then
1454: dumm_status := INVPUOPI.mtl_log_interface_err(
1455: cr.organization_id,
1456: user_id,
1457: login_id,
1458: prog_appid,

Line 1473: dumm_status := INVPUOPI.mtl_log_interface_err(

1469: raise LOGGING_ERR;
1470: end if;
1471: end if;
1472: if cr.SHIPPABLE_ITEM_FLAG <> 'N' then
1473: dumm_status := INVPUOPI.mtl_log_interface_err(
1474: cr.organization_id,
1475: user_id,
1476: login_id,
1477: prog_appid,

Line 1495: dumm_status := INVPUOPI.mtl_log_interface_err(

1491: if cr.INTERNAL_ORDER_FLAG <> 'N' or
1492: cr.CUSTOMER_ORDER_FLAG <> 'N' or
1493: cr.PICK_COMPONENTS_FLAG <> 'N' or
1494: cr.REPLENISH_TO_ORDER_FLAG <> 'N' then
1495: dumm_status := INVPUOPI.mtl_log_interface_err(
1496: cr.organization_id,
1497: user_id,
1498: login_id,
1499: prog_appid,

Line 1517: dumm_status := INVPUOPI.mtl_log_interface_err(

1513: end if;
1514: if cr.BOM_ITEM_TYPE <> 4 then
1515: if cr.BUILD_IN_WIP_FLAG <> 'N' or
1516: cr.BASE_ITEM_ID is not NULL then
1517: dumm_status := INVPUOPI.mtl_log_interface_err(
1518: cr.organization_id,
1519: user_id,
1520: login_id,
1521: prog_appid,

Line 1545: dumm_status := INVPUOPI.mtl_log_interface_err(

1541: l_msg_name := 'INV_INTERNAL_OPTION_CLASS' ;
1542: elsif cr.BOM_ITEM_TYPE = 5 then
1543: l_msg_name := 'INV_INTERNAL_PRODUCT_FAMILY' ;
1544: end if;
1545: dumm_status := INVPUOPI.mtl_log_interface_err(
1546: cr.organization_id,
1547: user_id,
1548: login_id,
1549: prog_appid,

Line 1569: dumm_status := INVPUOPI.mtl_log_interface_err(

1565:
1566: -- validate stock_enabled_flag
1567: if cr.stock_enabled_flag = 'Y' and
1568: cr.INVENTORY_ITEM_FLAG <> 'Y' then
1569: dumm_status := INVPUOPI.mtl_log_interface_err(
1570: cr.organization_id,
1571: user_id,
1572: login_id,
1573: prog_appid,

Line 1598: dumm_status := INVPUOPI.mtl_log_interface_err(

1594:
1595: if cr.inventory_item_flag = 'Y' and
1596: --Bug: 2731125 cr.service_item_flag = 'Y' then
1597: cr.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE','WARRANTY','USAGE') then
1598: dumm_status := INVPUOPI.mtl_log_interface_err(
1599: cr.organization_id,
1600: user_id,
1601: login_id,
1602: prog_appid,

Line 1630: dumm_status := INVPUOPI.mtl_log_interface_err(

1626: then
1627: null; -- need not check BOM_ENABLED_FLAG
1628: else
1629: if cr.BOM_ENABLED_FLAG = 'Y' then
1630: dumm_status := INVPUOPI.mtl_log_interface_err(
1631: cr.organization_id,
1632: user_id,
1633: login_id,
1634: prog_appid,

Line 1652: dumm_status := INVPUOPI.mtl_log_interface_err(

1648: end if;
1649: **/
1650: if cr.inventory_item_flag = 'N' and
1651: cr.BUILD_IN_WIP_FLAG <> 'N' then
1652: dumm_status := INVPUOPI.mtl_log_interface_err(
1653: cr.organization_id,
1654: user_id,
1655: login_id,
1656: prog_appid,

Line 1674: dumm_status := INVPUOPI.mtl_log_interface_err(

1670:
1671: -- validate purchasing_item_flag
1672: if cr.purchasing_item_flag = 'N' and
1673: cr.PURCHASING_ENABLED_FLAG <> 'N' then
1674: dumm_status := INVPUOPI.mtl_log_interface_err(
1675: cr.organization_id,
1676: user_id,
1677: login_id,
1678: prog_appid,

Line 1696: dumm_status := INVPUOPI.mtl_log_interface_err(

1692:
1693: -- validate customer_order_flag
1694: if cr.customer_order_flag = 'N' and
1695: cr.CUSTOMER_ORDER_ENABLED_FLAG <> 'N' then
1696: dumm_status := INVPUOPI.mtl_log_interface_err(
1697: cr.organization_id,
1698: user_id,
1699: login_id,
1700: prog_appid,

Line 1718: dumm_status := INVPUOPI.mtl_log_interface_err(

1714:
1715: -- validate invoiceable_item_flag
1716: if cr.invoiceable_item_flag = 'N' and
1717: cr.INVOICE_ENABLED_FLAG <> 'N' then
1718: dumm_status := INVPUOPI.mtl_log_interface_err(
1719: cr.organization_id,
1720: user_id,
1721: login_id,
1722: prog_appid,

Line 1740: dumm_status := INVPUOPI.mtl_log_interface_err(

1736: /*** Bug: 2731125 SERVICEABLE_COMPONENT_FLAG got obsoleted
1737: -- validate service_item_flag
1738: if cr.service_item_flag = 'Y' and
1739: cr.SERVICEABLE_COMPONENT_FLAG <> 'N'then
1740: dumm_status := INVPUOPI.mtl_log_interface_err(
1741: cr.organization_id,
1742: user_id,
1743: login_id,
1744: prog_appid,

Line 1762: dumm_status := INVPUOPI.mtl_log_interface_err(

1758: ***/
1759: -- if cr.service_item_flag = 'Y' and
1760: if cr.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE','USAGE','WARRANTY') and
1761: cr.SERVICEABLE_PRODUCT_FLAG <> 'N' then
1762: dumm_status := INVPUOPI.mtl_log_interface_err(
1763: cr.organization_id,
1764: user_id,
1765: login_id,
1766: prog_appid,

Line 1796: dumm_status := INVPUOPI.mtl_log_interface_err(

1792: or cr.SHIPPABLE_ITEM_FLAG <> 'N'
1793: or cr.RETURNABLE_FLAG <> 'N'
1794: or cr.material_billable_flag is not NULL
1795: or cr.ATP_FLAG <> 'N') then
1796: dumm_status := INVPUOPI.mtl_log_interface_err(
1797: cr.organization_id,
1798: user_id,
1799: login_id,
1800: prog_appid,

Line 1830: dumm_status := INVPUOPI.mtl_log_interface_err(

1826: or **/
1827: ( cr.coverage_schedule_id is not NULL
1828: or cr.service_duration <> 0
1829: or cr.service_duration_period_code is not NULL) then
1830: dumm_status := INVPUOPI.mtl_log_interface_err(
1831: cr.organization_id,
1832: user_id,
1833: login_id,
1834: prog_appid,

Line 1861: dumm_status := INVPUOPI.mtl_log_interface_err(

1857: **/
1858: -- Bug: 2811878 This validation will be in 11.5.10 in IOI
1859: if cr.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE','WARRANTY') and
1860: cr.service_duration_period_code is NULL then
1861: dumm_status := INVPUOPI.mtl_log_interface_err(
1862: cr.organization_id,
1863: user_id,
1864: login_id,
1865: prog_appid,

Line 1886: dumm_status := INVPUOPI.mtl_log_interface_err(

1882: /*Bug:3697824 removed this validation
1883: -- validate seviceable_product_flag
1884: if cr.SERVICEABLE_PRODUCT_FLAG = 'N'
1885: and cr.service_starting_delay <> 0 then
1886: dumm_status := INVPUOPI.mtl_log_interface_err(
1887: cr.organization_id,
1888: user_id,
1889: login_id,
1890: prog_appid,

Line 1909: dumm_status := INVPUOPI.mtl_log_interface_err(

1905: -- validate pick_components_flag
1906: if cr.pick_components_flag='Y' then
1907: if cr.REPLENISH_TO_ORDER_FLAG <> 'N' or
1908: cr.BASE_ITEM_ID is not NULL then
1909: dumm_status := INVPUOPI.mtl_log_interface_err(
1910: cr.organization_id,
1911: user_id,
1912: login_id,
1913: prog_appid,

Line 1928: dumm_status := INVPUOPI.mtl_log_interface_err(

1924: end if;
1925: status := 1;
1926: end if;
1927: if cr.MRP_PLANNING_CODE <> 6 then
1928: dumm_status := INVPUOPI.mtl_log_interface_err(
1929: cr.organization_id,
1930: user_id,
1931: login_id,
1932: prog_appid,

Line 1952: dumm_status := INVPUOPI.mtl_log_interface_err(

1948: -- validate replenish_to_order_flag
1949: if cr.replenish_to_order_flag ='Y' and (
1950: cr.PICK_COMPONENTS_FLAG = 'Y' or
1951: cr.BOM_ITEM_TYPE = 3 ) then
1952: dumm_status := INVPUOPI.mtl_log_interface_err(
1953: cr.organization_id,
1954: user_id,
1955: login_id,
1956: prog_appid,

Line 1982: dumm_status := INVPUOPI.mtl_log_interface_err(

1978: -- Bug 3333917 : Message name corrected - Anmurali
1979: if cr.lot_control_code = 2 and
1980: lot_num_generation_val = 2 and
1981: cr.AUTO_LOT_ALPHA_PREFIX is NULL then
1982: dumm_status := INVPUOPI.mtl_log_interface_err(
1983: cr.organization_id,
1984: user_id,
1985: login_id,
1986: prog_appid,

Line 2019: dumm_status := INVPUOPI.mtl_log_interface_err(

2015:
2016: exception
2017: when others then
2018: --Catch ORA-01722: invalid number and raise a error message.
2019: dumm_status := INVPUOPI.mtl_log_interface_err(
2020: cr.organization_id,
2021: user_id,
2022: login_id,
2023: prog_appid,

Line 2043: dumm_status := INVPUOPI.mtl_log_interface_err(

2039: -- Bug 3333917 : Message name corrected - Anmurali
2040: if cr.lot_control_code = 2 and
2041: lot_num_generation_val = 2 and
2042: cr.START_AUTO_LOT_NUMBER is NULL then
2043: dumm_status := INVPUOPI.mtl_log_interface_err(
2044: cr.organization_id,
2045: user_id,
2046: login_id,
2047: prog_appid,

Line 2072: dumm_status := INVPUOPI.mtl_log_interface_err(

2068:
2069: if cr.serial_number_control_code = 2 and
2070: ser_num_generation_val = 2 and
2071: cr.START_AUTO_SERIAL_NUMBER is NULL then
2072: dumm_status := INVPUOPI.mtl_log_interface_err(
2073: cr.organization_id,
2074: user_id,
2075: login_id,
2076: prog_appid,

Line 2101: dumm_status := INVPUOPI.mtl_log_interface_err(

2097:
2098: if cr.serial_number_control_code = 2 and
2099: ser_num_generation_val = 2 and
2100: cr.AUTO_SERIAL_ALPHA_PREFIX is NULL then
2101: dumm_status := INVPUOPI.mtl_log_interface_err(
2102: cr.organization_id,
2103: user_id,
2104: login_id,
2105: prog_appid,

Line 2123: dumm_status := INVPUOPI.mtl_log_interface_err(

2119:
2120: -- validate shelf_life_code
2121: if cr.shelf_life_code = 2 and
2122: cr.SHELF_LIFE_DAYS is NULL then
2123: dumm_status := INVPUOPI.mtl_log_interface_err(
2124: cr.organization_id,
2125: user_id,
2126: login_id,
2127: prog_appid,

Line 2145: dumm_status := INVPUOPI.mtl_log_interface_err(

2141:
2142: -- validate OUTSIDE_OPERATION_FLAG
2143: if cr.OUTSIDE_OPERATION_FLAG = 'Y' then
2144: if cr.purchasing_item_flag ='N' then
2145: dumm_status := INVPUOPI.mtl_log_interface_err(
2146: cr.organization_id,
2147: user_id,
2148: login_id,
2149: prog_appid,

Line 2164: dumm_status := INVPUOPI.mtl_log_interface_err(

2160: end if;
2161: status := 1;
2162: end if;
2163: if cr.OUTSIDE_OPERATION_UOM_TYPE is NULL then
2164: dumm_status := INVPUOPI.mtl_log_interface_err(
2165: cr.organization_id,
2166: user_id,
2167: login_id,
2168: prog_appid,

Line 2205: dumm_status := INVPUOPI.mtl_log_interface_err(

2201: and organization_id = cr.source_organization_id;
2202:
2203: exception
2204: when no_data_found then
2205: dumm_status := INVPUOPI.mtl_log_interface_err(
2206: cr.organization_id,
2207: user_id,
2208: login_id,
2209: prog_appid,

Line 2233: dumm_status := INVPUOPI.mtl_log_interface_err(

2229: and from_organization_id = cr.source_organization_id;
2230:
2231: exception
2232: when no_data_found then
2233: dumm_status := INVPUOPI.mtl_log_interface_err(
2234: cr.organization_id,
2235: user_id,
2236: login_id,
2237: prog_appid,

Line 2264: dumm_status := INVPUOPI.mtl_log_interface_err(

2260: nvl(cr.source_subinventory,
2261: secondary_inventory_name)
2262: and availability_type = 1
2263: and rownum < 2 ;
2264: dumm_status := INVPUOPI.mtl_log_interface_err(
2265: cr.organization_id,
2266: user_id,
2267: login_id,
2268: prog_appid,

Line 2295: dumm_status := INVPUOPI.mtl_log_interface_err(

2291: -- 15-APR-98, Source Org/Sub Should be Null if source_type <> 1
2292: IF (cr.source_type = 2 OR
2293: cr.source_type IS NULL) AND
2294: (cr.SOURCE_ORGANIZATION_ID is NOT NULL) THEN
2295: dumm_status := INVPUOPI.mtl_log_interface_err(
2296: cr.organization_id,
2297: user_id,
2298: login_id,
2299: prog_appid,

Line 2320: dumm_status := INVPUOPI.mtl_log_interface_err(

2316: -- validate MINIMUM_ORDER_QUANTITY
2317: if cr.MINIMUM_ORDER_QUANTITY < 0 or
2318: cr.MINIMUM_ORDER_QUANTITY >
2319: nvl(cr.maximum_order_quantity, cr.MINIMUM_ORDER_QUANTITY) then
2320: dumm_status := INVPUOPI.mtl_log_interface_err(
2321: cr.organization_id,
2322: user_id,
2323: login_id,
2324: prog_appid,

Line 2344: dumm_status := INVPUOPI.mtl_log_interface_err(

2340:
2341: if cr.MAXIMUM_ORDER_QUANTITY < 0 or
2342: cr.MAXIMUM_ORDER_QUANTITY <
2343: nvl(cr.minimum_order_quantity, cr.MAXIMUM_ORDER_QUANTITY) then
2344: dumm_status := INVPUOPI.mtl_log_interface_err(
2345: cr.organization_id,
2346: user_id,
2347: login_id,
2348: prog_appid,

Line 2367: dumm_status := INVPUOPI.mtl_log_interface_err(

2363: -- validate MIN_MINMAX_QUANTITY
2364: if cr.MIN_MINMAX_QUANTITY < 0 or
2365: cr.MIN_MINMAX_QUANTITY >
2366: nvl(cr.max_minmax_quantity, cr.MIN_MINMAX_QUANTITY +1 ) then
2367: dumm_status := INVPUOPI.mtl_log_interface_err(
2368: cr.organization_id,
2369: user_id,
2370: login_id,
2371: prog_appid,

Line 2388: dumm_status := INVPUOPI.mtl_log_interface_err(

2384: end if;
2385:
2386: -- validate MAX_MINMAX_QUANTITY
2387: if cr.MAX_MINMAX_QUANTITY < nvl(cr.min_minmax_quantity,0) then
2388: dumm_status := INVPUOPI.mtl_log_interface_err(
2389: cr.organization_id,
2390: user_id,
2391: login_id,
2392: prog_appid,

Line 2410: dumm_status := INVPUOPI.mtl_log_interface_err(

2406:
2407: -- validate check_shortages_flag
2408: if cr.CHECK_SHORTAGES_FLAG = 'Y' and
2409: cr.MTL_TRANSACTIONS_ENABLED_FLAG <> 'Y' then
2410: dumm_status := INVPUOPI.mtl_log_interface_err(
2411: cr.organization_id,
2412: user_id,
2413: login_id,
2414: prog_appid,

Line 2430: dumm_status := INVPUOPI.mtl_log_interface_err(

2426: status := 1;
2427: end if;
2428: if cr.CONTRACT_ITEM_TYPE_CODE ='WARRANTY' and
2429: cr.CUSTOMER_ORDER_FLAG = 'Y' then
2430: dumm_status := INVPUOPI.mtl_log_interface_err(
2431: cr.organization_id,
2432: user_id,
2433: login_id,
2434: prog_appid,

Line 2457: dumm_status := INVPUOPI.mtl_log_interface_err(

2453: FROM MTL_UNITS_OF_MEASURE
2454: WHERE UOM_CODE = cr.WEIGHT_UOM_CODE;
2455: EXCEPTION
2456: WHEN NO_DATA_FOUND THEN
2457: dumm_status := INVPUOPI.mtl_log_interface_err(
2458: cr.organization_id,
2459: user_id,
2460: login_id,
2461: prog_appid,

Line 2499: dumm_status := INVPUOPI.mtl_log_interface_err

2495: l_msg_name := 'INV_IOI_DIMENSION_UOM_MISSING';
2496: END IF;
2497:
2498: IF l_col_name IS NOT NULL THEN
2499: dumm_status := INVPUOPI.mtl_log_interface_err
2500: (cr.organization_id,
2501: user_id,
2502: login_id,
2503: prog_appid,

Line 2551: dumm_status := INVPUOPI.mtl_log_interface_err(

2547: exception
2548: when LOGGING_ERR then
2549: return(dumm_status);
2550: when VALIDATE_ERR then
2551: dumm_status := INVPUOPI.mtl_log_interface_err(
2552: l_org_id,
2553: user_id,
2554: login_id,
2555: prog_appid,