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 MTL_MFG_PART_NUMBERS_PKG

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 2391: MTL_MFG_PART_NUMBERS_PKG.insert_row(

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
2395: ,x_inventory_item_id => p_inventory_item_id

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 2423: MTL_MFG_PART_NUMBERS_PKG.update_row(

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
2427: ,x_inventory_item_id => l_inventory_item_id

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 2453: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);

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
2457: INV_EBI_UTIL.debug_line('STEP: 80 '||'START CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');

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 2458: MTL_MFG_PART_NUMBERS_PKG.insert_row(

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
2462: ,x_inventory_item_id => p_inventory_item_id

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 2490: MTL_MFG_PART_NUMBERS_PKG.update_row(

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
2494: ,x_inventory_item_id => l_inventory_item_id

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