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.INV_EBI_ITEM_HELPER dependencies on INV_EBI_UTIL

Line 520: l_master_org_code := INV_EBI_UTIL.get_config_param_value(

516: OPEN c_master_org;
517: LOOP
518: FETCH c_master_org INTO l_master_org;
519: IF (c_master_org%ROWCOUNT > 1) THEN
520: l_master_org_code := INV_EBI_UTIL.get_config_param_value(
521: p_config_tbl => p_config
522: ,p_config_param_name => 'Default_Master_Organization_For_Item'
523: );
524: l_master_org := get_organization_id(

Line 1200: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_item_pvt ');

1196: WHERE concatenated_segments = p_item_number
1197: AND organization_id = p_organization_id;
1198: BEGIN
1199: SAVEPOINT inv_ebi_pvt_item_save_pnt;
1200: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_item_pvt ');
1201: l_item := p_item;
1202: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1203: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
1204: l_item_number := l_item.main_obj_type.item_number;

Line 1251: l_validate_revised_itm_rev := INV_EBI_UTIL.get_config_param_value(

1247: l_item.main_obj_type.item_number := l_item_number;
1248: END IF;
1249: initialize_item(x_item => l_item);
1250:
1251: l_validate_revised_itm_rev := INV_EBI_UTIL.get_config_param_value(
1252: p_config_tbl => l_item.name_value_tbl
1253: ,p_config_param_name => 'VALIDATE_REVISED_ITEM_REVISION'
1254: );
1255: IF (l_validate_revised_itm_rev = fnd_api.g_true ) AND (l_item.main_obj_type.revision_code IS NOT NULL)

Line 1311: l_is_master_org := INV_EBI_UTIL.is_master_org(l_item.main_obj_type.organization_id);

1307: IF(l_item.main_obj_type.item_catalog_group_id IS NOT NULL AND l_item.main_obj_type.item_catalog_group_id <> fnd_api.g_miss_num) THEN
1308: l_item_desc_gen_method := get_desc_gen_method(l_item.main_obj_type.item_catalog_group_id);
1309: END IF;
1310: IF(l_item_desc_gen_method = 'U' OR l_item_desc_gen_method IS NULL OR l_item.main_obj_type.item_catalog_group_id IS NULL OR l_item.main_obj_type.item_catalog_group_id = fnd_api.g_miss_num) THEN
1311: l_is_master_org := INV_EBI_UTIL.is_master_org(l_item.main_obj_type.organization_id);
1312: IF(l_is_master_org = fnd_api.g_true) THEN
1313: l_item.main_obj_type.description := l_item_number;
1314: ELSE
1315: l_master_org := INV_EBI_UTIL.get_master_organization(

Line 1315: l_master_org := INV_EBI_UTIL.get_master_organization(

1311: l_is_master_org := INV_EBI_UTIL.is_master_org(l_item.main_obj_type.organization_id);
1312: IF(l_is_master_org = fnd_api.g_true) THEN
1313: l_item.main_obj_type.description := l_item_number;
1314: ELSE
1315: l_master_org := INV_EBI_UTIL.get_master_organization(
1316: p_organization_id => l_item.main_obj_type.organization_id
1317: );
1318: OPEN c_item_description(
1319: p_item_number => l_item_number

Line 1346: l_apply_template_update := INV_EBI_UTIL.get_config_param_value(

1342:
1343:
1344:
1345: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_update ) THEN
1346: l_apply_template_update := INV_EBI_UTIL.get_config_param_value(
1347: p_config_tbl => l_item.name_value_tbl
1348: ,p_config_param_name => 'TEMPLATE_FOR_ITEM_UPDATE_ALLOWED'
1349: );
1350: IF( UPPER(l_apply_template_update ) = fnd_api.g_false ) THEN

Line 1413: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item ');

1409: END IF; -- Bug 7412466
1410: END IF; -- End of Bug 7601514
1411: END IF;
1412:
1413: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item ');
1414: EGO_ITEM_PUB.process_item(
1415: p_api_version => 1.0
1416: ,p_init_msg_list => l_item.main_obj_type.init_msg_list
1417: ,p_commit => FND_API.g_false

Line 1836: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item ');

1832: ,p_repair_program => l_item.mrp_obj_type.repair_program
1833: ,p_subcontracting_component => l_item.gplanning_obj_type.subcontracting_component
1834: ,p_outsourced_assembly => l_item.purchasing_obj_type.outsourced_assembly
1835: );
1836: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item ');
1837:
1838: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1839: RAISE FND_API.g_exc_unexpected_error;
1840: END IF;

Line 1905: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_item_pvt ');

1901: END IF;
1902: IF FND_API.to_boolean( p_commit ) THEN
1903: COMMIT;
1904: END IF;
1905: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_item_pvt ');
1906: EXCEPTION
1907: WHEN FND_API.g_exc_error THEN
1908: ROLLBACK TO inv_ebi_pvt_item_save_pnt;
1909: x_out.output_status.return_status := FND_API.g_ret_sts_error;

Line 1967: INV_EBI_UTIL.transform_uda (

1963: SAVEPOINT inv_ebi_item_uda_save_pnt;
1964: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
1965: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1966: x_uda_output_obj := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,l_uda_out,NULL,NULL,NULL,NULL);
1967: INV_EBI_UTIL.transform_uda (
1968: p_uda_input_obj => p_uda_input_obj
1969: ,x_attributes_row_table => l_attributes_row_table
1970: ,x_attributes_data_table => l_attributes_data_table
1971: ,x_return_status => x_uda_output_obj.output_status.return_status

Line 2105: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_org_id_assignments ');

2101: l_api_version NUMBER:=1.0;
2102: l_item_org_tbl_count NUMBER := 1;
2103: BEGIN
2104: SAVEPOINT inv_ebi_org_id_save_pnt;
2105: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2106: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2107: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
2108: IF p_org_id_tbl.COUNT > 0 THEN
2109: FOR i IN 1..p_org_id_tbl.COUNT LOOP

Line 2115: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_org_assignments ');

2111: l_item_org_assignment_rec.item_number := p_item_number;
2112: l_item_org_assignment_rec.organization_id := p_org_id_tbl(i).org_id;
2113: l_item_org_assignment_tbl(i) := l_item_org_assignment_rec;
2114: END LOOP;
2115: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_org_assignments ');
2116: EGO_ITEM_PUB.process_item_org_assignments(
2117: p_api_version => l_api_version --don't pass as of now
2118: ,p_init_msg_list => p_init_msg_list
2119: ,p_commit => FND_API.g_false

Line 2124: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item_org_assignments ');

2120: ,p_item_org_assignment_tbl => l_item_org_assignment_tbl
2121: ,x_return_status => x_out.output_status.return_status
2122: ,x_msg_count => x_out.output_status.msg_count
2123: );
2124: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item_org_assignments ');
2125: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2126: RAISE FND_API.g_exc_unexpected_error;
2127: END IF;
2128: END IF;

Line 2132: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_org_id_assignments ');

2128: END IF;
2129: IF FND_API.to_boolean( p_commit ) THEN
2130: COMMIT;
2131: END IF;
2132: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2133: EXCEPTION
2134: WHEN FND_API.g_exc_unexpected_error THEN
2135: ROLLBACK TO inv_ebi_org_id_save_pnt;
2136: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

Line 2174: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');

2170: l_category_output inv_ebi_category_output_obj;
2171: l_output_status inv_ebi_output_status;
2172: BEGIN
2173: SAVEPOINT inv_ebi_cat_id_save_pnt;
2174: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
2175: l_category_output := inv_ebi_category_output_obj(NULL);
2176: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2177: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_category_output,NULL,NULL,NULL);
2178: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_cat_assignment ');

Line 2178: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_cat_assignment ');

2174: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
2175: l_category_output := inv_ebi_category_output_obj(NULL);
2176: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2177: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_category_output,NULL,NULL,NULL);
2178: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_cat_assignment ');
2179: FOR i IN 1..p_category_id_tbl.COUNT LOOP
2180: EGO_ITEM_PUB.process_item_cat_assignment(
2181: p_api_version => p_api_version
2182: ,p_init_msg_list => p_init_msg_list

Line 2195: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item_cat_assignment ');

2191: ,x_msg_count => x_out.output_status.msg_count
2192: ,x_msg_data => x_out.output_status.msg_data
2193: );
2194: END LOOP;
2195: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item_cat_assignment ');
2196: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2197: RAISE FND_API.g_exc_unexpected_error;
2198: END IF;
2199: IF FND_API.to_boolean( p_commit ) THEN

Line 2202: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');

2198: END IF;
2199: IF FND_API.to_boolean( p_commit ) THEN
2200: COMMIT;
2201: END IF;
2202: INV_EBI_UTIL.debug_line('STEP: 40 '||'END INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
2203: EXCEPTION
2204: WHEN FND_API.g_exc_unexpected_error THEN
2205: ROLLBACK TO inv_ebi_cat_id_save_pnt;
2206: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

Line 2298: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_part_num_association ');

2294: AND organization_id = p_organization_id
2295: AND inventory_item_id = p_inventory_item_id;
2296: BEGIN
2297: SAVEPOINT inv_ebi_part_num_save_pnt;
2298: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_part_num_association ');
2299: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2300: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
2301: IF p_mfg_part_obj.mfg_part_num IS NOT NULL THEN
2302: OPEN c_mfg_part_num(

Line 2390: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');

2386: l_attribute15 := p_mfg_part_obj.attribute15;
2387: END IF;
2388:
2389: IF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_CREATE THEN
2390: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2391: MTL_MFG_PART_NUMBERS_PKG.insert_row(
2392: x_rowid => l_rowid
2393: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
2394: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num

Line 2420: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');

2416: ,x_attribute13 => p_mfg_part_obj.attribute13
2417: ,x_attribute14 => p_mfg_part_obj.attribute14
2418: ,x_attribute15 => p_mfg_part_obj.attribute15
2419: );
2420: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2421: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_UPDATE THEN
2422: INV_EBI_UTIL.debug_line('STEP: 40 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
2423: MTL_MFG_PART_NUMBERS_PKG.update_row(
2424: x_rowid => l_rowid

Line 2422: INV_EBI_UTIL.debug_line('STEP: 40 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');

2418: ,x_attribute15 => p_mfg_part_obj.attribute15
2419: );
2420: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2421: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_UPDATE THEN
2422: INV_EBI_UTIL.debug_line('STEP: 40 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
2423: MTL_MFG_PART_NUMBERS_PKG.update_row(
2424: x_rowid => l_rowid
2425: ,x_manufacturer_id => l_manufacturer_id
2426: ,x_mfg_part_num => l_mfg_part_num

Line 2450: INV_EBI_UTIL.debug_line('STEP: 50 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');

2446: ,x_attribute13 => l_attribute13
2447: ,x_attribute14 => l_attribute14
2448: ,x_attribute15 => l_attribute15
2449: );
2450: INV_EBI_UTIL.debug_line('STEP: 50 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
2451: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
2452: INV_EBI_UTIL.debug_line('STEP: 60 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2453: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
2454: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');

Line 2452: INV_EBI_UTIL.debug_line('STEP: 60 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');

2448: ,x_attribute15 => l_attribute15
2449: );
2450: INV_EBI_UTIL.debug_line('STEP: 50 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
2451: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
2452: INV_EBI_UTIL.debug_line('STEP: 60 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2453: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
2454: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2455: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
2456: IF (c_mfg_part_num%NOTFOUND) THEN

Line 2454: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');

2450: INV_EBI_UTIL.debug_line('STEP: 50 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
2451: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
2452: INV_EBI_UTIL.debug_line('STEP: 60 '||'START CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2453: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
2454: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2455: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
2456: IF (c_mfg_part_num%NOTFOUND) THEN
2457: INV_EBI_UTIL.debug_line('STEP: 80 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2458: MTL_MFG_PART_NUMBERS_PKG.insert_row(

Line 2457: INV_EBI_UTIL.debug_line('STEP: 80 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');

2453: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
2454: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
2455: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
2456: IF (c_mfg_part_num%NOTFOUND) THEN
2457: INV_EBI_UTIL.debug_line('STEP: 80 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2458: MTL_MFG_PART_NUMBERS_PKG.insert_row(
2459: x_rowid => l_rowid
2460: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
2461: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num

Line 2487: INV_EBI_UTIL.debug_line('STEP: 90 '||'END CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');

2483: ,x_attribute13 => p_mfg_part_obj.attribute13
2484: ,x_attribute14 => p_mfg_part_obj.attribute14
2485: ,x_attribute15 => p_mfg_part_obj.attribute15
2486: );
2487: INV_EBI_UTIL.debug_line('STEP: 90 '||'END CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2488: ELSE
2489: INV_EBI_UTIL.debug_line('STEP: 100 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
2490: MTL_MFG_PART_NUMBERS_PKG.update_row(
2491: x_rowid => l_rowid

Line 2489: INV_EBI_UTIL.debug_line('STEP: 100 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');

2485: ,x_attribute15 => p_mfg_part_obj.attribute15
2486: );
2487: INV_EBI_UTIL.debug_line('STEP: 90 '||'END CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
2488: ELSE
2489: INV_EBI_UTIL.debug_line('STEP: 100 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
2490: MTL_MFG_PART_NUMBERS_PKG.update_row(
2491: x_rowid => l_rowid
2492: ,x_manufacturer_id => l_manufacturer_id
2493: ,x_mfg_part_num => l_mfg_part_num

Line 2517: INV_EBI_UTIL.debug_line('STEP: 110 '||'END CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');

2513: ,x_attribute13 => l_attribute13
2514: ,x_attribute14 => l_attribute14
2515: ,x_attribute15 => l_attribute15
2516: );
2517: INV_EBI_UTIL.debug_line('STEP: 110 '||'END CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
2518: END IF;
2519: END IF;
2520: CLOSE c_mfg_part_num;
2521: ELSE

Line 2530: INV_EBI_UTIL.debug_line('STEP: 120 '||'END INSIDE INV_EBI_ITEM_HELPER.process_part_num_association ');

2526: END IF;
2527: IF FND_API.to_boolean( p_commit ) THEN
2528: COMMIT;
2529: END IF;
2530: INV_EBI_UTIL.debug_line('STEP: 120 '||'END INSIDE INV_EBI_ITEM_HELPER.process_part_num_association ');
2531: EXCEPTION
2532: WHEN FND_API.g_exc_error THEN
2533: ROLLBACK TO inv_ebi_part_num_save_pnt;
2534: x_out.output_status.return_status := FND_API.g_ret_sts_error;

Line 2599: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.sync_item '||

2595: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
2596: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
2597:
2598: --Create or update item
2599: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.sync_item '||
2600: 'ORGANIZATION CODE: '||p_item.main_obj_type.organization_code||
2601: 'Item Number: '||p_item.main_obj_type.item_number
2602: );
2603: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING INV_EBI_ITEM_HELPER.process_item_pvt ');

Line 2603: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING INV_EBI_ITEM_HELPER.process_item_pvt ');

2599: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.sync_item '||
2600: 'ORGANIZATION CODE: '||p_item.main_obj_type.organization_code||
2601: 'Item Number: '||p_item.main_obj_type.item_number
2602: );
2603: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING INV_EBI_ITEM_HELPER.process_item_pvt ');
2604: process_item_pvt (
2605: p_item => p_item
2606: ,p_operation => p_operation
2607: ,p_commit => FND_API.g_false

Line 2610: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING INV_EBI_ITEM_HELPER.process_item_pvt ');

2606: ,p_operation => p_operation
2607: ,p_commit => FND_API.g_false
2608: ,x_out => l_out
2609: );
2610: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING INV_EBI_ITEM_HELPER.process_item_pvt ');
2611: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
2612: x_out.output_status.msg_data := l_out.output_status.msg_data;
2613: RAISE fnd_api.g_exc_unexpected_error;
2614: END IF;

Line 2623: INV_EBI_UTIL.debug_line('STEP: 40 '||'START CALLING INV_EBI_ITEM_HELPER.process_org_id_assignments ');

2619: l_operating_unit := l_out.operating_unit;
2620: l_operating_unit_id := l_out.operating_unit_id;
2621: --Assign item to all the orgs sent in the list.
2622: IF (p_item.org_id_obj_type IS NOT NULL AND p_item.org_id_obj_type.COUNT > 0) THEN
2623: INV_EBI_UTIL.debug_line('STEP: 40 '||'START CALLING INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2624: process_org_id_assignments(
2625: p_init_msg_list => p_item.main_obj_type.init_msg_list
2626: ,p_commit => fnd_api.g_false
2627: ,p_inventory_item_id => l_inventory_item_id

Line 2632: INV_EBI_UTIL.debug_line('STEP: 40 '||'END CALLING INV_EBI_ITEM_HELPER.process_org_id_assignments ');

2628: ,p_item_number => p_item.main_obj_type.item_number
2629: ,p_org_id_tbl => p_item.org_id_obj_type
2630: ,x_out => l_out
2631: );
2632: INV_EBI_UTIL.debug_line('STEP: 40 '||'END CALLING INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2633: END IF;
2634: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2635: x_out.output_status.msg_data := l_out.output_status.msg_data;
2636: RAISE fnd_api.g_exc_unexpected_error;

Line 2640: INV_EBI_UTIL.debug_line('STEP: 50 '||'START CALLING INV_EBI_ITEM_HELPER.process_category_assignments ');

2636: RAISE fnd_api.g_exc_unexpected_error;
2637: END IF;
2638: --Catalog Category assignment
2639: IF (p_item.category_id_obj_tbl_type IS NOT NULL AND p_item.category_id_obj_tbl_type.COUNT > 0) THEN
2640: INV_EBI_UTIL.debug_line('STEP: 50 '||'START CALLING INV_EBI_ITEM_HELPER.process_category_assignments ');
2641: process_category_assignments(
2642: p_api_version => l_api_version
2643: ,p_init_msg_list => p_item.main_obj_type.init_msg_list
2644: ,p_commit => fnd_api.g_false

Line 2650: INV_EBI_UTIL.debug_line('STEP: 60 '||'END CALLING INV_EBI_ITEM_HELPER.process_category_assignments ');

2646: ,p_organization_id => p_item.main_obj_type.organization_id
2647: ,p_category_id_tbl => p_item.category_id_obj_tbl_type
2648: ,x_out => l_out
2649: );
2650: INV_EBI_UTIL.debug_line('STEP: 60 '||'END CALLING INV_EBI_ITEM_HELPER.process_category_assignments ');
2651: END IF;
2652: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2653: x_out.output_status.msg_data := l_out.output_status.msg_data;
2654: RAISE fnd_api.g_exc_unexpected_error;

Line 2657: l_master_org_id := INV_EBI_UTIL.get_master_organization(

2653: x_out.output_status.msg_data := l_out.output_status.msg_data;
2654: RAISE fnd_api.g_exc_unexpected_error;
2655: END IF;
2656: l_category_output := inv_ebi_category_output_obj(l_out.category_output.error_code);
2657: l_master_org_id := INV_EBI_UTIL.get_master_organization(
2658: p_organization_id => p_item.main_obj_type.organization_id
2659: );
2660:
2661: --Manufacturer Part Num association needs to be done for master org only.

Line 2664: INV_EBI_UTIL.debug_line('STEP: 70 '||'START CALLING INV_EBI_ITEM_HELPER.process_part_num_association');

2660:
2661: --Manufacturer Part Num association needs to be done for master org only.
2662: IF(l_master_org_id = p_item.main_obj_type.organization_id) THEN
2663: IF (p_item.part_num_obj_tbl_type IS NOT NULL AND p_item.part_num_obj_tbl_type.COUNT > 0) THEN
2664: INV_EBI_UTIL.debug_line('STEP: 70 '||'START CALLING INV_EBI_ITEM_HELPER.process_part_num_association');
2665: FOR i IN p_item.part_num_obj_tbl_type.FIRST..p_item.part_num_obj_tbl_type.LAST
2666: LOOP
2667: l_mfg_part_num_obj := p_item.part_num_obj_tbl_type(i);
2668: IF(l_mfg_part_num_obj.manufacturer_id IS NOT NULL AND l_mfg_part_num_obj.manufacturer_id <> fnd_api.g_miss_num) THEN

Line 2704: INV_EBI_UTIL.debug_line('STEP: 80 '||'END CALLING INV_EBI_ITEM_HELPER.process_part_num_association');

2700: x_out.output_status.msg_data := l_out.output_status.msg_data ;
2701: RAISE FND_API.g_exc_unexpected_error;
2702: END IF;
2703: END LOOP;
2704: INV_EBI_UTIL.debug_line('STEP: 80 '||'END CALLING INV_EBI_ITEM_HELPER.process_part_num_association');
2705: END IF;
2706: END IF;
2707: x_out := inv_ebi_item_output_obj(l_inventory_item_id,l_organization_id,l_organization_code,l_item_number,l_out.output_status,NULL,l_category_output,NULL,l_operating_unit,l_operating_unit_id);
2708:

Line 2714: INV_EBI_UTIL.debug_line('STEP: 90 '||'END INSIDE INV_EBI_ITEM_HELPER.sync_item '||

2710:
2711: IF fnd_api.to_boolean(p_commit) THEN
2712: COMMIT;
2713: END IF;
2714: INV_EBI_UTIL.debug_line('STEP: 90 '||'END INSIDE INV_EBI_ITEM_HELPER.sync_item '||
2715: 'ORGANIZATION CODE: '||p_item.main_obj_type.organization_code||
2716: 'Item Number: '||p_item.main_obj_type.item_number
2717: );
2718: EXCEPTION

Line 3159: IF(p_attr_group_type = INV_EBI_UTIL.G_EGO_ITEMMGMT_GROUP) THEN

3155:
3156:
3157: FOR i IN 1..p_attr_grp_id_tbl.COUNT LOOP
3158:
3159: IF(p_attr_group_type = INV_EBI_UTIL.G_EGO_ITEMMGMT_GROUP) THEN
3160:
3161: SELECT data_level_int_name INTO l_data_level
3162: FROM ego_obj_attr_grp_assocs_v
3163: WHERE attr_group_id = p_attr_grp_id_tbl(i)

Line 3244: INV_EBI_UTIL.transform_attr_rowdata_uda(

3240: IF(x_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3241: RAISE FND_API.g_exc_unexpected_error;
3242: END IF;
3243:
3244: INV_EBI_UTIL.transform_attr_rowdata_uda(
3245: p_attributes_row_table => l_attr_grp
3246: ,p_attributes_data_table => l_attr
3247: ,x_uda_input_obj => x_uda_obj
3248: ,x_return_status => x_uda_output_obj.output_status.return_status

Line 3359: l_application_id:= INV_EBI_UTIL.get_application_id(

3355: l_pkdata.extend(2);
3356: l_pkdata(1) := EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID',p_inventory_item_id);
3357: l_pkdata(2) := EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID',p_organization_id);
3358:
3359: l_application_id:= INV_EBI_UTIL.get_application_id(
3360: p_application_short_name => 'EGO'
3361: );
3362:
3363: IF(l_application_id IS NULL ) THEN

Line 3373: p_attr_group_type => INV_EBI_UTIL.G_EGO_ITEMMGMT_GROUP,

3369: END IF;
3370:
3371: get_uda_attributes(
3372: p_classification_id => p_item_classification_id,
3373: p_attr_group_type => INV_EBI_UTIL.G_EGO_ITEMMGMT_GROUP,
3374: p_application_id => l_application_id,
3375: p_attr_grp_id_tbl => l_attr_group_id_tbl,
3376: p_data_level => NULL,
3377: p_revision_id => p_revision_id,

Line 3378: p_object_name => INV_EBI_UTIL.G_EGO_ITEM,

3374: p_application_id => l_application_id,
3375: p_attr_grp_id_tbl => l_attr_group_id_tbl,
3376: p_data_level => NULL,
3377: p_revision_id => p_revision_id,
3378: p_object_name => INV_EBI_UTIL.G_EGO_ITEM,
3379: p_pk_data => l_pkdata,
3380: x_uda_obj => x_item_uda,
3381: x_uda_output_obj => l_uda_output_obj
3382: );

Line 5012: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');

5008: x_return_status := FND_API.g_ret_sts_success;
5009:
5010: --Getting the values for the parameters passed from CP
5011: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5012: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');
5013: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5014: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5015: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5016: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');

Line 5013: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');

5009:
5010: --Getting the values for the parameters passed from CP
5011: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5012: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');
5013: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5014: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5015: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5016: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');
5017:

Line 5014: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');

5010: --Getting the values for the parameters passed from CP
5011: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5012: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');
5013: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5014: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5015: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5016: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');
5017:
5018: IF l_from_date_str IS NOT NULL THEN

Line 5015: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');

5011: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5012: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');
5013: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5014: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5015: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5016: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');
5017:
5018: IF l_from_date_str IS NOT NULL THEN
5019: l_from_date := TO_DATE(l_from_date_str,'YYYY/MM/DD HH24:MI:SS');

Line 5016: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');

5012: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');
5013: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5014: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5015: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5016: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');
5017:
5018: IF l_from_date_str IS NOT NULL THEN
5019: l_from_date := TO_DATE(l_from_date_str,'YYYY/MM/DD HH24:MI:SS');
5020: END IF;

Line 5195: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');

5191: FND_MSG_PUB.initialize();
5192: x_return_status := FND_API.g_ret_sts_success;
5193:
5194: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5195: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');
5196: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5197: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5198: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5199: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');

Line 5196: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');

5192: x_return_status := FND_API.g_ret_sts_success;
5193:
5194: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5195: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');
5196: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5197: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5198: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5199: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');
5200:

Line 5197: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');

5193:
5194: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5195: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');
5196: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5197: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5198: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5199: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');
5200:
5201: IF l_from_date_str IS NOT NULL THEN

Line 5198: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');

5194: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5195: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');
5196: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5197: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5198: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5199: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');
5200:
5201: IF l_from_date_str IS NOT NULL THEN
5202: l_from_date := TO_DATE(l_from_date_str,'YYYY/MM/DD HH24:MI:SS');

Line 5199: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');

5195: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');
5196: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5197: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5198: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5199: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');
5200:
5201: IF l_from_date_str IS NOT NULL THEN
5202: l_from_date := TO_DATE(l_from_date_str,'YYYY/MM/DD HH24:MI:SS');
5203: END IF;