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 3411: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');

3407: l_attribute15 := p_mfg_part_obj.attribute15;
3408: END IF;
3409:
3410: IF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_CREATE THEN
3411: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3412: MTL_MFG_PART_NUMBERS_PKG.insert_row(
3413: x_rowid => l_rowid
3414: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
3415: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num

Line 3412: MTL_MFG_PART_NUMBERS_PKG.insert_row(

3408: END IF;
3409:
3410: IF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_CREATE THEN
3411: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3412: MTL_MFG_PART_NUMBERS_PKG.insert_row(
3413: x_rowid => l_rowid
3414: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
3415: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num
3416: ,x_inventory_item_id => p_inventory_item_id

Line 3441: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');

3437: ,x_attribute13 => p_mfg_part_obj.attribute13
3438: ,x_attribute14 => p_mfg_part_obj.attribute14
3439: ,x_attribute15 => p_mfg_part_obj.attribute15
3440: );
3441: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3442: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_UPDATE THEN
3443: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3444: MTL_MFG_PART_NUMBERS_PKG.update_row(
3445: x_rowid => l_rowid

Line 3443: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');

3439: ,x_attribute15 => p_mfg_part_obj.attribute15
3440: );
3441: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3442: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_UPDATE THEN
3443: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3444: MTL_MFG_PART_NUMBERS_PKG.update_row(
3445: x_rowid => l_rowid
3446: ,x_manufacturer_id => l_manufacturer_id
3447: ,x_mfg_part_num => l_mfg_part_num

Line 3444: MTL_MFG_PART_NUMBERS_PKG.update_row(

3440: );
3441: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3442: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_UPDATE THEN
3443: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3444: MTL_MFG_PART_NUMBERS_PKG.update_row(
3445: x_rowid => l_rowid
3446: ,x_manufacturer_id => l_manufacturer_id
3447: ,x_mfg_part_num => l_mfg_part_num
3448: ,x_inventory_item_id => l_inventory_item_id

Line 3471: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');

3467: ,x_attribute13 => l_attribute13
3468: ,x_attribute14 => l_attribute14
3469: ,x_attribute15 => l_attribute15
3470: );
3471: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3472: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
3473: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3474: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');

Line 3473: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');

3469: ,x_attribute15 => l_attribute15
3470: );
3471: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3472: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
3473: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3474: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3476: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
3477: IF (c_mfg_part_num%NOTFOUND) THEN

Line 3474: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);

3470: );
3471: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3472: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
3473: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3474: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3476: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
3477: IF (c_mfg_part_num%NOTFOUND) THEN
3478: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');

Line 3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');

3471: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.update_row ');
3472: ELSIF UPPER(p_mfg_part_obj.transaction_type) = ENG_GLOBALS.G_OPR_DELETE THEN
3473: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3474: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3476: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
3477: IF (c_mfg_part_num%NOTFOUND) THEN
3478: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3479: MTL_MFG_PART_NUMBERS_PKG.insert_row(

Line 3478: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');

3474: MTL_MFG_PART_NUMBERS_PKG.Delete_Row(l_Rowid);
3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3476: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
3477: IF (c_mfg_part_num%NOTFOUND) THEN
3478: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3479: MTL_MFG_PART_NUMBERS_PKG.insert_row(
3480: x_rowid => l_rowid
3481: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
3482: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num

Line 3479: MTL_MFG_PART_NUMBERS_PKG.insert_row(

3475: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING MTL_MFG_PART_NUMBERS_PKG.delete_row ');
3476: ELSIF (p_mfg_part_obj.transaction_type IS NULL) THEN
3477: IF (c_mfg_part_num%NOTFOUND) THEN
3478: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3479: MTL_MFG_PART_NUMBERS_PKG.insert_row(
3480: x_rowid => l_rowid
3481: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
3482: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num
3483: ,x_inventory_item_id => p_inventory_item_id

Line 3508: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');

3504: ,x_attribute13 => p_mfg_part_obj.attribute13
3505: ,x_attribute14 => p_mfg_part_obj.attribute14
3506: ,x_attribute15 => p_mfg_part_obj.attribute15
3507: );
3508: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3509: ELSE
3510: INV_EBI_UTIL.debug_line('STEP 110: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
3511: MTL_MFG_PART_NUMBERS_PKG.update_row(
3512: x_rowid => l_rowid

Line 3510: INV_EBI_UTIL.debug_line('STEP 110: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');

3506: ,x_attribute15 => p_mfg_part_obj.attribute15
3507: );
3508: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3509: ELSE
3510: INV_EBI_UTIL.debug_line('STEP 110: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
3511: MTL_MFG_PART_NUMBERS_PKG.update_row(
3512: x_rowid => l_rowid
3513: ,x_manufacturer_id => l_manufacturer_id
3514: ,x_mfg_part_num => l_mfg_part_num

Line 3511: MTL_MFG_PART_NUMBERS_PKG.update_row(

3507: );
3508: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.insert_row ');
3509: ELSE
3510: INV_EBI_UTIL.debug_line('STEP 110: BEFORE CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
3511: MTL_MFG_PART_NUMBERS_PKG.update_row(
3512: x_rowid => l_rowid
3513: ,x_manufacturer_id => l_manufacturer_id
3514: ,x_mfg_part_num => l_mfg_part_num
3515: ,x_inventory_item_id => l_inventory_item_id

Line 3538: INV_EBI_UTIL.debug_line('STEP 120: AFTER CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');

3534: ,x_attribute13 => l_attribute13
3535: ,x_attribute14 => l_attribute14
3536: ,x_attribute15 => l_attribute15
3537: );
3538: INV_EBI_UTIL.debug_line('STEP 120: AFTER CALLING Sync Mode MTL_MFG_PART_NUMBERS_PKG.update_row ');
3539: END IF;
3540: END IF;
3541: CLOSE c_mfg_part_num;
3542: ELSE