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.INVPOPIF dependencies on INVPUTLI

Line 274: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

270: l_schema VARCHAR2(30);
271: l_status VARCHAR2(1);
272: l_industry VARCHAR2(1);
273: l_records NUMBER(10);
274: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
275: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;
276: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;
277: l_items_bulk_rec_cnt NUMBER;
278:

Line 287: INVPUTLI.info('INVPOPIF: *** Starting a new IOI process: run_mode='|| TO_CHAR(run_mode) ||' all_org='|| TO_CHAR(all_org));

283: INVPOPIF.g_source_org := FALSE ;
284: END IF ;
285:
286: IF l_inv_debug_level IN(101, 102) THEN
287: INVPUTLI.info('INVPOPIF: *** Starting a new IOI process: run_mode='|| TO_CHAR(run_mode) ||' all_org='|| TO_CHAR(all_org));
288: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: org_id = '|| TO_CHAR(org_id) || 'Default flag=' || To_Char(default_flag) );
289: END IF;
290: /*
291: ** Make sure transaction type is in upper case

Line 288: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: org_id = '|| TO_CHAR(org_id) || 'Default flag=' || To_Char(default_flag) );

284: END IF ;
285:
286: IF l_inv_debug_level IN(101, 102) THEN
287: INVPUTLI.info('INVPOPIF: *** Starting a new IOI process: run_mode='|| TO_CHAR(run_mode) ||' all_org='|| TO_CHAR(all_org));
288: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: org_id = '|| TO_CHAR(org_id) || 'Default flag=' || To_Char(default_flag) );
289: END IF;
290: /*
291: ** Make sure transaction type is in upper case
292: */

Line 299: INVPUTLI.info('INVPOPIF: Gathering interface table stats');

295: --IF fnd_global.conc_program_id <> -1 THEN Bug:3547401
296: IF NVL(prog_id,-1) <> -1 THEN
297:
298: IF l_inv_debug_level IN(101, 102) THEN
299: INVPUTLI.info('INVPOPIF: Gathering interface table stats');
300: END IF;
301:
302: --3515652: Collect stats only if no. records > 50
303: SELECT count(*) INTO l_records

Line 319: INVPUTLI.info('INVPOPIF: Gathering interface table stats done');

315: END IF;
316: END IF;
317:
318: IF l_inv_debug_level IN(101, 102) THEN
319: INVPUTLI.info('INVPOPIF: Gathering interface table stats done');
320: END IF;
321:
322: END IF;
323: --End 2698140 : Gather stats before running the IOI

Line 552: INVPUTLI.info('INVPOPIF all_org=1: Calling create process for masters');

548: where miri.organization_id = mp1.master_organization_id);
549:
550: --Creating Master Items
551: IF l_inv_debug_level IN(101, 102) THEN
552: INVPUTLI.info('INVPOPIF all_org=1: Calling create process for masters');
553: END IF;
554: ret_code_create := INVPOPIF.inopinp_OI_process_create (
555: NULL
556: ,1

Line 622: INVPUTLI.info('INVPOPIF all_org=1: Calling create process for childs');

618: from mtl_parameters mp1
619: where miri.organization_id = mp1.master_organization_id);
620:
621: IF l_inv_debug_level IN(101, 102) THEN
622: INVPUTLI.info('INVPOPIF all_org=1: Calling create process for childs');
623: END IF;
624: --Creating Child Items
625: ret_code_create := INVPOPIF.inopinp_OI_process_create (
626: NULL,

Line 668: INVPUTLI.info('INVPOPIF all_org<>1: Calling create process');

664: FETCH c_interface_revs INTO mtli_count;
665: CLOSE c_interface_revs;
666:
667: IF l_inv_debug_level IN(101, 102) THEN
668: INVPUTLI.info('INVPOPIF all_org<>1: Calling create process');
669: END IF;
670:
671: IF (mtl_count <> 0 or mtli_count <> 0) THEN
672: ret_code_create := INVPOPIF.inopinp_OI_process_create (

Line 928: INVPUTLI.info('Calling EGO_IMPORT_PVT.Demerge_Batch_After_Import');

924: IF NOT(l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y') THEN
925:
926: --Calling Demerge_Batch_After_Import
927: IF l_inv_debug_level IN(101, 102) THEN
928: INVPUTLI.info('Calling EGO_IMPORT_PVT.Demerge_Batch_After_Import');
929: END IF;
930: EGO_IMPORT_PVT.Demerge_Batch_After_Import(
931: ERRBUF => err_text
932: ,RETCODE => ret_code

Line 935: INVPUTLI.info('Returned EGO_IMPORT_PVT.Demerge_Batch_After_Import '||ret_code);

931: ERRBUF => err_text
932: ,RETCODE => ret_code
933: ,p_batch_id => xset_id);
934: IF l_inv_debug_level IN(101, 102) THEN
935: INVPUTLI.info('Returned EGO_IMPORT_PVT.Demerge_Batch_After_Import '||ret_code);
936: INVPUTLI.info(err_text);
937: END IF;
938:
939: --Calling source system xref bulkloader

Line 936: INVPUTLI.info(err_text);

932: ,RETCODE => ret_code
933: ,p_batch_id => xset_id);
934: IF l_inv_debug_level IN(101, 102) THEN
935: INVPUTLI.info('Returned EGO_IMPORT_PVT.Demerge_Batch_After_Import '||ret_code);
936: INVPUTLI.info(err_text);
937: END IF;
938:
939: --Calling source system xref bulkloader
940: IF l_inv_debug_level IN(101, 102) THEN

Line 941: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_SSXref_Intf_Rows');

937: END IF;
938:
939: --Calling source system xref bulkloader
940: IF l_inv_debug_level IN(101, 102) THEN
941: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_SSXref_Intf_Rows');
942: END IF;
943:
944: EGO_IMPORT_PVT.Process_SSXref_Intf_Rows(
945: ERRBUF => err_text

Line 950: INVPUTLI.info('Returned EGO_IMPORT_PVT.Process_SSXref_Intf_Rows '||ret_code);

946: ,RETCODE => ret_code
947: ,p_data_set_id => xset_id);
948:
949: IF l_inv_debug_level IN(101, 102) THEN
950: INVPUTLI.info('Returned EGO_IMPORT_PVT.Process_SSXref_Intf_Rows '||ret_code);
951: INVPUTLI.info(err_text);
952: END IF;
953:
954: END IF;

Line 951: INVPUTLI.info(err_text);

947: ,p_data_set_id => xset_id);
948:
949: IF l_inv_debug_level IN(101, 102) THEN
950: INVPUTLI.info('Returned EGO_IMPORT_PVT.Process_SSXref_Intf_Rows '||ret_code);
951: INVPUTLI.info(err_text);
952: END IF;
953:
954: END IF;
955:

Line 968: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Before Sync IM Index');

964: ret_code := 1;
965: END IF;
966:
967: IF l_inv_debug_level IN(101, 102) THEN
968: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Before Sync IM Index');
969: END IF;
970:
971: --Start : Sync iM index changes
972: IF pro_item_flag = 1 --Bug 4667985

Line 983: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INV_ENI_ITEMS_STAR_PKG.Sync_Star_Items_From_IOI');

979: --
980: -- Sync processed rows with item star table
981: --
982: IF l_inv_debug_level IN(101, 102) THEN
983: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INV_ENI_ITEMS_STAR_PKG.Sync_Star_Items_From_IOI');
984: END IF;
985:
986: --Bug: 2718703 checking for ENI product before calling their package
987: --This check has been moved to INV_ENI_ITEMS_STAR_PKG

Line 999: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Synch Up of ENI tables failed');

995: ,x_msg_data => l_msg_data);
996:
997:
998: IF NOT ( l_return_status = FND_API.g_RET_STS_SUCCESS ) THEN
999: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Synch Up of ENI tables failed');
1000: dumm_status := INVPUOPI.mtl_log_interface_err (
1001: ORG_ID => -1,
1002: USER_ID =>user_id,
1003: LOGIN_ID =>login_id,

Line 1015: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Logging Error');

1011: MSG_NAME =>'INV_IOI_ERR',
1012: ERR_TEXT =>err_text);
1013:
1014: if ( dumm_status < 0 ) then
1015: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Logging Error');
1016: end if;
1017: END IF; --l_return_status
1018: EXCEPTION
1019: WHEN OTHERS THEN

Line 1039: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Start Raising Business Events');

1035:
1036: END;
1037:
1038: IF l_inv_debug_level IN(101, 102) THEN
1039: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Start Raising Business Events');
1040: END IF;
1041:
1042: --R12: Business Event Enhancement:
1043: --Raise events for EGO Bulk Load and Excel Import

Line 1049: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Insert in to bulkloadrecs for Item');

1045:
1046: --Populate Item Bulkload Recs for items and revisions
1047: BEGIN
1048: IF l_inv_debug_level IN(101, 102) THEN
1049: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Insert in to bulkloadrecs for Item');
1050: END IF;
1051:
1052: INSERT INTO MTL_ITEM_BULKLOAD_RECS(
1053: REQUEST_ID

Line 1094: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Raised Item Bulkload Event');

1090: ,p_event_name => 'EGO_WF_WRAPPER_PVT.G_ITEM_BULKLOAD_EVENT'
1091: ,p_dml_type => 'BULK');
1092:
1093: IF l_inv_debug_level IN(101, 102) THEN
1094: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Raised Item Bulkload Event');
1095: END IF;
1096:
1097: EXCEPTION
1098: WHEN OTHERS THEN

Line 1101: INVPUTLI.info(err_msg);

1097: EXCEPTION
1098: WHEN OTHERS THEN
1099: err_msg := SUBSTR('INVPOPIF: Error:' ||SQLERRM ||' while raising Item Change Event',1,240);
1100: IF l_inv_debug_level IN(101, 102) THEN
1101: INVPUTLI.info(err_msg);
1102: END IF;
1103: END;
1104: END IF;
1105:

Line 1108: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Insert in to bulkloadrecs for Revision.');

1104: END IF;
1105:
1106:
1107: IF l_inv_debug_level IN(101, 102) THEN
1108: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Insert in to bulkloadrecs for Revision.');
1109: END IF;
1110:
1111: INSERT INTO MTL_ITEM_BULKLOAD_RECS(
1112: REQUEST_ID

Line 1150: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Raised Revision Bulkload Event');

1146: ,p_event_name => 'EGO_WF_WRAPPER_PVT.G_REV_CHANGE_EVENT'
1147: ,p_dml_type => 'BULK');
1148:
1149: IF l_inv_debug_level IN(101, 102) THEN
1150: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Raised Revision Bulkload Event');
1151: END IF;
1152:
1153: EXCEPTION
1154: WHEN OTHERS THEN

Line 1157: INVPUTLI.info(err_msg);

1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: err_msg := SUBSTR('INVPOPIF: Error:' ||SQLERRM ||' while raising REV Change Event',1,240);
1156: IF l_inv_debug_level IN(101, 102) THEN
1157: INVPUTLI.info(err_msg);
1158: END IF;
1159: END;
1160:
1161: END IF;

Line 1168: INVPUTLI.info(err_msg);

1164: EXCEPTION
1165: WHEN OTHERS THEN
1166: err_msg := SUBSTR('INVPOPIF: Error:' ||SQLERRM ||' while inserting records in MTL_ITEM_BULKLOAD_RECS',1,240);
1167: IF l_inv_debug_level IN(101, 102) THEN
1168: INVPUTLI.info(err_msg);
1169: END IF;
1170: END;
1171:
1172:

Line 1181: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Calling ICX Bulkload Event');

1177: ,p_xset_id => xset_id
1178: ,p_entity_type => 'ITEM'
1179: ,p_dml_type => 'BULK');
1180: IF l_inv_debug_level IN(101, 102) THEN
1181: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Calling ICX Bulkload Event');
1182: END IF;
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: err_msg := SUBSTR('INVPOPIF: Error:' ||SQLERRM ||'while invoking ICX APIs',1,240);

Line 1187: INVPUTLI.info(err_msg);

1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: err_msg := SUBSTR('INVPOPIF: Error:' ||SQLERRM ||'while invoking ICX APIs',1,240);
1186: IF l_inv_debug_level IN(101, 102) THEN
1187: INVPUTLI.info(err_msg);
1188: END IF;
1189: END;
1190: END IF; --l_items_bulk_rec_cnt
1191:

Line 1202: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVPOPIF.indelitm_delete_item_oi');

1198: --Delete processed records from IOI tables.
1199: --Bug: 5473976 Rows will not be deleted if control is coming from Import Workbench
1200: IF (del_rec_flag = 1 AND (NVL(INV_EGO_REVISION_VALIDATE.Get_Process_Control,'!') <> 'EGO_ITEM_BULKLOAD')) THEN
1201: IF l_inv_debug_level IN(101, 102) THEN
1202: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVPOPIF.indelitm_delete_item_oi');
1203: END IF;
1204:
1205: ret_code := INVPOPIF.indelitm_delete_item_oi (err_text => err_msg,
1206: com_flag => commit_flag,

Line 1210: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: done INVPOPIF.indelitm_delete_item_oi: ret_code=' || ret_code);

1206: com_flag => commit_flag,
1207: xset_id => xset_id);
1208:
1209: IF l_inv_debug_level IN(101, 102) THEN
1210: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: done INVPOPIF.indelitm_delete_item_oi: ret_code=' || ret_code);
1211: END IF;
1212:
1213: ELSE
1214: /****Added for bug 5194369

Line 1238: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: calling INV_ITEM_CATEGORY_OI.process_Item_Category_records '||pro_item_flag);

1234: -- Process Item Category Open Interface records
1235: --
1236:
1237: IF l_inv_debug_level IN(101, 102) THEN
1238: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: calling INV_ITEM_CATEGORY_OI.process_Item_Category_records '||pro_item_flag);
1239: END IF;
1240:
1241: SELECT COUNT(1) INTO mtl_count
1242: FROM mtl_item_categories_interface mici

Line 1263: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: done INV_ITEM_CATEGORY_OI.process_Item_Category_records: ret_code=' || ret_code);

1259: , p_login_id => login_id);
1260: END IF;
1261:
1262: IF l_inv_debug_level IN(101, 102) THEN
1263: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: done INV_ITEM_CATEGORY_OI.process_Item_Category_records: ret_code=' || ret_code);
1264: END IF;
1265:
1266: /* SET return code to that of last error, IF any */
1267:

Line 1280: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: calling INV_ITEM_CATALOG_ELEM_PUB.process_Item_Catalog_grp_recs');

1276: --
1277: -- Process Item Catalog group element values open Interface records
1278: --
1279: IF l_inv_debug_level IN(101, 102) THEN
1280: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: calling INV_ITEM_CATALOG_ELEM_PUB.process_Item_Catalog_grp_recs');
1281: END IF;
1282:
1283: SELECT COUNT(1) INTO mtl_count
1284: FROM mtl_desc_elem_val_interface mdei

Line 1306: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: done INV_ITEM_CATALOG_ELEM_PUB.process_Item_Catalog_grp_recs: ret_code=' || ret_code_grp);

1302: ret_code_grp := 0;
1303: END IF;
1304:
1305: IF l_inv_debug_level IN(101, 102) THEN
1306: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: done INV_ITEM_CATALOG_ELEM_PUB.process_Item_Catalog_grp_recs: ret_code=' || ret_code_grp);
1307: END IF;
1308:
1309: IF (ret_code_grp <> 0) THEN
1310: ret_code := ret_code_grp;

Line 1347: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

1343: Logging_Err EXCEPTION;
1344: l_return_status VARCHAR2(1);
1345: l_msg_count NUMBER;
1346: l_msg_data VARCHAR2(2000);
1347: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1348:
1349: BEGIN
1350:
1351: IF l_inv_debug_level IN(101, 102) THEN

Line 1352: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update : begin org_id: ' || TO_CHAR(org_id));

1348:
1349: BEGIN
1350:
1351: IF l_inv_debug_level IN(101, 102) THEN
1352: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update : begin org_id: ' || TO_CHAR(org_id));
1353: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling UPDATE_ITEM_CATALOG_ID');
1354: END IF;
1355:
1356: --Validate Catalog_Group_name

Line 1353: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling UPDATE_ITEM_CATALOG_ID');

1349: BEGIN
1350:
1351: IF l_inv_debug_level IN(101, 102) THEN
1352: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update : begin org_id: ' || TO_CHAR(org_id));
1353: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling UPDATE_ITEM_CATALOG_ID');
1354: END IF;
1355:
1356: --Validate Catalog_Group_name
1357: UPDATE_ITEM_CATALOG_ID(

Line 1368: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INVNIRIS.change_policy_check');

1364: ,x_err_text => err_text);
1365:
1366:
1367: IF l_inv_debug_level IN(101, 102) THEN
1368: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INVNIRIS.change_policy_check');
1369: END IF;
1370:
1371: ret_code := INVNIRIS.change_policy_check (
1372: org_id => org_id,

Line 1383: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INVNIRIS.change_policy_check RETURN'||ret_code);

1379: err_text => err_msg,
1380: xset_id => xset_id);
1381:
1382: IF l_inv_debug_level IN(101, 102) THEN
1383: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INVNIRIS.change_policy_check RETURN'||ret_code);
1384: INVPUTLI.info('INVNIRIS.change_policy_check->l'||err_msg);
1385: END IF;
1386:
1387: IF (ret_code <> 0) THEN

Line 1384: INVPUTLI.info('INVNIRIS.change_policy_check->l'||err_msg);

1380: xset_id => xset_id);
1381:
1382: IF l_inv_debug_level IN(101, 102) THEN
1383: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INVNIRIS.change_policy_check RETURN'||ret_code);
1384: INVPUTLI.info('INVNIRIS.change_policy_check->l'||err_msg);
1385: END IF;
1386:
1387: IF (ret_code <> 0) THEN
1388: err_msg := 'INVNIRIS.change_policy_check: error in policy phase of UPDATE;' ||

Line 1395: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INVUPD1B.mtl_pr_assign_item_data_update');

1391: END IF;
1392:
1393: IF default_flag = 1 THEN
1394: IF l_inv_debug_level IN(101, 102) THEN
1395: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INVUPD1B.mtl_pr_assign_item_data_update');
1396: END IF;
1397:
1398:
1399:

Line 1422: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVNIRIS.mtl_validate_nir_item');

1418: END IF;
1419:
1420: --Bug:3777954 added call to new pkg/processing for NIR required items (for EGO)
1421: IF l_inv_debug_level IN(101, 102) THEN
1422: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVNIRIS.mtl_validate_nir_item');
1423: END IF;
1424:
1425: ret_code := INVNIRIS.mtl_validate_nir_item (
1426: org_id => org_id,

Line 1438: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVNIRIS.mtl_validate_nir_item: ret_code=' || ret_code || ' err_msg=' || err_msg);

1434: xset_id => xset_id);
1435:
1436:
1437: IF l_inv_debug_level IN(101, 102) THEN
1438: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVNIRIS.mtl_validate_nir_item: ret_code=' || ret_code || ' err_msg=' || err_msg);
1439: END IF;
1440:
1441: IF (ret_code <> 0) THEN
1442: err_msg := 'INVPOPIF.inopinp_OI_process_create: error in NIR ASSIGN phase of UPDATE;' ||

Line 1450: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INVUPD1B.mtl_pr_validate_item_update');

1446:
1447: --Bug:3777954 call ends
1448:
1449: IF l_inv_debug_level IN(101, 102) THEN
1450: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INVUPD1B.mtl_pr_validate_item_update');
1451: END IF;
1452:
1453: ret_code := INVUPD1B.mtl_pr_validate_item_update (
1454: org_id => org_id,

Line 1475: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INVUPD2B.inproit_process_item_update');

1471:
1472: IF (pro_item_flag = 1) THEN
1473:
1474: IF l_inv_debug_level IN(101, 102) THEN
1475: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INVUPD2B.inproit_process_item_update');
1476: END IF;
1477:
1478: ret_code := INVUPD2B.inproit_process_item_update (
1479: prg_appid => prog_appid,

Line 1490: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: done INVUPD2B.inproit_process_item_update: ret_code=' || ret_code);

1486: table_name => table_name,
1487: xset_id => xset_id);
1488:
1489: IF l_inv_debug_level IN(101, 102) THEN
1490: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: done INVUPD2B.inproit_process_item_update: ret_code=' || ret_code);
1491: END IF;
1492:
1493: IF (ret_code <> 0) THEN
1494: err_msg := 'INVPOPIF.inopinp_OI_process_update: error in PROCESS phase of UPDATE;' ||

Line 1504: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INV_ENI_ITEMS_STAR_PKG.Sync_Star_Items_From_IOI');

1500: -- Sync processed rows with item star table
1501: --
1502:
1503: IF l_inv_debug_level IN(101, 102) THEN
1504: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling INV_ENI_ITEMS_STAR_PKG.Sync_Star_Items_From_IOI');
1505: END IF;
1506:
1507: --Bug: 2718703 checking for ENI product before calling their package
1508: --This check has been moved to INV_ENI_ITEMS_STAR_PKG

Line 1526: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: About to rollback.');

1522:
1523: WHEN OTHERS THEN
1524: err_text := substr('INVPOPIF.inopinp_OI_process_update ' || SQLERRM , 1,240);
1525: IF l_inv_debug_level IN(101, 102) THEN
1526: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: About to rollback.');
1527: END IF;
1528: ROLLBACK;
1529: RETURN (ret_code);
1530: END inopinp_OI_process_update;

Line 1576: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

1572: l_return_status VARCHAR2(1);
1573: l_msg_count NUMBER;
1574: l_msg_data VARCHAR2(2000);
1575: l_child_records VARCHAR2(1);
1576: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1577: trans_id NUMBER;
1578:
1579: BEGIN
1580: IF l_inv_debug_level IN(101, 102) THEN

Line 1581: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create : begin org_id: ' || TO_CHAR(org_id));

1577: trans_id NUMBER;
1578:
1579: BEGIN
1580: IF l_inv_debug_level IN(101, 102) THEN
1581: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create : begin org_id: ' || TO_CHAR(org_id));
1582: END IF;
1583:
1584: IF l_inv_debug_level IN(101, 102) THEN
1585: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling UPDATE_ITEM_CATALOG_ID');

Line 1585: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling UPDATE_ITEM_CATALOG_ID');

1581: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create : begin org_id: ' || TO_CHAR(org_id));
1582: END IF;
1583:
1584: IF l_inv_debug_level IN(101, 102) THEN
1585: INVPUTLI.info('INVPOPIF.inopinp_OI_process_update: calling UPDATE_ITEM_CATALOG_ID');
1586: END IF;
1587:
1588: --Validate Catalog_Group_name
1589: UPDATE_ITEM_CATALOG_ID(

Line 1599: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVPASGI.mtl_pr_assign_item_data');

1595: ,p_login_id => login_id
1596: ,x_err_text => err_text);
1597:
1598: IF l_inv_debug_level IN(101, 102) THEN
1599: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVPASGI.mtl_pr_assign_item_data');
1600: END IF;
1601:
1602: ret_code := INVPASGI.mtl_pr_assign_item_data (
1603: org_id => org_id,

Line 1615: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: done INVPASGI.mtl_pr_assign_item_data: ret_code=' || ret_code || ' err_msg=' || err_msg);

1611: xset_id => xset_id,
1612: default_flag => default_flag);
1613:
1614: IF l_inv_debug_level IN(101, 102) THEN
1615: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: done INVPASGI.mtl_pr_assign_item_data: ret_code=' || ret_code || ' err_msg=' || err_msg);
1616: END IF;
1617:
1618: IF (ret_code <> 0) THEN
1619: err_msg := 'INVPOPIF.inopinp_OI_process_create: error in ASSIGN phase of CREATE;' ||

Line 1628: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVNIRIS.mtl_validate_nir_item');

1624: IF (val_item_flag = 1) THEN
1625: --Bug:3777954 added call to new pkg/processing for NIR required items (for EGO)
1626:
1627: IF l_inv_debug_level IN(101, 102) THEN
1628: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVNIRIS.mtl_validate_nir_item');
1629: END IF;
1630:
1631: ret_code := INVNIRIS.mtl_validate_nir_item (
1632: org_id => org_id,

Line 1643: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVNIRIS.mtl_validate_nir_item: ret_code=' || ret_code || ' err_msg=' || err_msg);

1639: err_text => err_msg,
1640: xset_id => xset_id);
1641:
1642: IF l_inv_debug_level IN(101, 102) THEN
1643: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVNIRIS.mtl_validate_nir_item: ret_code=' || ret_code || ' err_msg=' || err_msg);
1644: END IF;
1645:
1646: IF (ret_code <> 0) THEN
1647: err_msg := 'INVPOPIF.inopinp_OI_process_create: error in NIR ASSIGN phase of CREATE;' ||

Line 1655: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVPVALI.mtl_pr_validate_item');

1651:
1652: --Bug:3777954 call ends
1653:
1654: IF l_inv_debug_level IN(101, 102) THEN
1655: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVPVALI.mtl_pr_validate_item');
1656: END IF;
1657:
1658: ret_code := INVPVALI.mtl_pr_validate_item (
1659: org_id => org_id,

Line 1670: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: done INVPVALI.mtl_pr_validate_item: ret_code=' || ret_code || ' err_msg=' || err_msg);

1666: err_text => err_msg,
1667: xset_id => xset_id);
1668:
1669: IF l_inv_debug_level IN(101, 102) THEN
1670: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: done INVPVALI.mtl_pr_validate_item: ret_code=' || ret_code || ' err_msg=' || err_msg);
1671: END IF;
1672:
1673: IF (ret_code <> 0) THEN
1674: err_msg := 'INVPOPIF.inopinp_OI_process_create: error in VALIDATE phase of CREATE;'||

Line 1685: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVPPROC.inproit_process_item');

1681:
1682: IF (pro_item_flag = 1) THEN
1683:
1684: IF l_inv_debug_level IN(101, 102) THEN
1685: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INVPPROC.inproit_process_item');
1686: END IF;
1687:
1688: ret_code := INVPPROC.inproit_process_item (
1689: prg_appid => prog_appid,

Line 1700: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: done INVPPROC.inproit_process_item: ret_code=' || ret_code);

1696: table_name => table_name,
1697: xset_id => xset_id);
1698:
1699: IF l_inv_debug_level IN(101, 102) THEN
1700: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: done INVPPROC.inproit_process_item: ret_code=' || ret_code);
1701: END IF;
1702:
1703: IF (ret_code <> 0) THEN
1704:

Line 1740: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INV_ENI_ITEMS_STAR_PKG.Sync_Star_Items_From_IOI');

1736: --
1737: -- Sync processed rows with item star table
1738: --
1739: IF l_inv_debug_level IN(101, 102) THEN
1740: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: calling INV_ENI_ITEMS_STAR_PKG.Sync_Star_Items_From_IOI');
1741: END IF;
1742:
1743: --Bug: 2718703 checking for ENI product before calling their package
1744: --This check has been moved to INV_ENI_ITEMS_STAR_PKG

Line 1773: INVPUTLI.info(err_msg);

1769: NULL; --Child records not created, no need to call JAI api's
1770: WHEN OTHERS THEN
1771: err_msg := SUBSTR('INVPOPIF: Error:' ||SQLERRM ||' while IL API call ',1,240);
1772: IF l_inv_debug_level IN(101, 102) THEN
1773: INVPUTLI.info(err_msg);
1774: END IF;
1775: END;
1776:
1777: END IF; -- pro_item_flag = 1

Line 1794: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: About to rollback.');

1790:
1791: WHEN others THEN
1792: err_text := substr('INVPOPIF.inopinp_OI_process_create ' || SQLERRM , 1,240);
1793: IF l_inv_debug_level IN(101, 102) THEN
1794: INVPUTLI.info('INVPOPIF.inopinp_OI_process_create: About to rollback.');
1795: END IF;
1796: ROLLBACK;
1797: RETURN (ret_code);
1798: END inopinp_OI_process_create;

Line 1814: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667453

1810: IS
1811: stmt_num NUMBER;
1812: l_process_flag_7 NUMBER := 7;
1813: l_rownum NUMBER := 100000;
1814: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667453
1815: BEGIN
1816:
1817: IF l_inv_debug_level IN(101, 102) THEN
1818: INVPUTLI.info('INVPOPIF.indelitm_delete_item_oi: begin');

Line 1818: INVPUTLI.info('INVPOPIF.indelitm_delete_item_oi: begin');

1814: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667453
1815: BEGIN
1816:
1817: IF l_inv_debug_level IN(101, 102) THEN
1818: INVPUTLI.info('INVPOPIF.indelitm_delete_item_oi: begin');
1819: END IF;
1820:
1821: stmt_num := 1;
1822:

Line 1853: INVPUTLI.info('INVPOPIF.indelitm_delete_item_oi: end');

1849: END IF;
1850: END LOOP;
1851:
1852: IF l_inv_debug_level IN(101, 102) THEN
1853: INVPUTLI.info('INVPOPIF.indelitm_delete_item_oi: end');
1854: END IF;
1855:
1856:
1857: RETURN (0);

Line 1963: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;

1959: l_rev_exist NUMBER(10) := 0;
1960: l_status NUMBER(10):= 0;
1961: l_item_id mtl_system_items_b.inventory_item_id%TYPE;
1962: l_item_number MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS%TYPE;
1963: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
1964: dumm_status NUMBER;
1965: l_updateable_item_number varchar2(10);
1966: LOGGING_ERR EXCEPTION;
1967:

Line 2036: INVPUTLI.info('INVPOPIF.update sync records: Item Number update' || item_record.item_number || ' ' || l_item_number || ' ' || l_item_id);

2032: -- MSIBKFV item number fetched using MSII inventory_item_id
2033: -- Both l_item_number and item_record.item_number cannot be NULL, hence NVL is not used
2034:
2035: IF l_inv_debug_level IN(101, 102) THEN
2036: INVPUTLI.info('INVPOPIF.update sync records: Item Number update' || item_record.item_number || ' ' || l_item_number || ' ' || l_item_id);
2037: END IF;
2038:
2039: IF ( l_updateable_item_number <> 'Y' ) THEN
2040: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,

Line 2083: INVPUTLI.info('INVPOPIF.update sync records: Item Number update to duplicate case:' || item_record.item_number || ' ' || l_item_exist || ' ' || l_item_id);

2079: CLOSE c_fetch_by_item_number;
2080:
2081: IF (l_item_exist <> 0 AND l_item_exist <> l_item_id) THEN
2082: IF l_inv_debug_level IN(101, 102) THEN
2083: INVPUTLI.info('INVPOPIF.update sync records: Item Number update to duplicate case:' || item_record.item_number || ' ' || l_item_exist || ' ' || l_item_id);
2084: END IF;
2085: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2086: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2087: 'INVPOPIF: Update to Duplicate Item number',