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.IGI_IMP_IAC_PURGE_IAC_PKG dependencies on IGI_IMP_IAC_INTERFACE_CTRL

Line 27: FROM igi_imp_iac_interface_ctrl ic

23:
24: -- Cursor to fetch the interface control record
25: CURSOR c_ctrl IS
26: SELECT *
27: FROM igi_imp_iac_interface_ctrl ic
28: WHERE ic.book_type_code = p_book_type_code
29: AND ic.category_id = nvl(p_Category_id,ic.category_id);
30:
31: -- Cursor to fetch the assets from the interface table

Line 261: p_string => 'Updating igi_imp_iac_interface_ctrl status to Not transferred ...');

257: p_string => SQL%rowcount || ' rows deleted.');
258:
259: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
260: p_full_path => l_path_name,
261: p_string => 'Updating igi_imp_iac_interface_ctrl status to Not transferred ...');
262: Update igi_imp_iac_interface_ctrl c
263: set c.transfer_status = 'N'
264: where c.book_type_code = p_book_type_code
265: and c.category_id = nvl(p_category_id,c.category_id) ;

Line 262: Update igi_imp_iac_interface_ctrl c

258:
259: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
260: p_full_path => l_path_name,
261: p_string => 'Updating igi_imp_iac_interface_ctrl status to Not transferred ...');
262: Update igi_imp_iac_interface_ctrl c
263: set c.transfer_status = 'N'
264: where c.book_type_code = p_book_type_code
265: and c.category_id = nvl(p_category_id,c.category_id) ;
266: IF ( SQL%rowcount = 0 ) THEN

Line 269: p_string => 'ERROR : Could not set igi_imp_iac_interface_ctrl status to NOT TRANSFERRED');

265: and c.category_id = nvl(p_category_id,c.category_id) ;
266: IF ( SQL%rowcount = 0 ) THEN
267: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
268: p_full_path => l_path_name,
269: p_string => 'ERROR : Could not set igi_imp_iac_interface_ctrl status to NOT TRANSFERRED');
270: fnd_message.set_name ('IGI','IGI_IAC_PURGE_IAC_ERROR');
271: fnd_message.set_token('ERROR', 'igi_imp_iac_interface_ctrl table does not contain anyrows for given book and category');
272: fnd_message.set_token('OPERATION', 'update transfer status to Not Transferred');
273: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

Line 271: fnd_message.set_token('ERROR', 'igi_imp_iac_interface_ctrl table does not contain anyrows for given book and category');

267: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
268: p_full_path => l_path_name,
269: p_string => 'ERROR : Could not set igi_imp_iac_interface_ctrl status to NOT TRANSFERRED');
270: fnd_message.set_name ('IGI','IGI_IAC_PURGE_IAC_ERROR');
271: fnd_message.set_token('ERROR', 'igi_imp_iac_interface_ctrl table does not contain anyrows for given book and category');
272: fnd_message.set_token('OPERATION', 'update transfer status to Not Transferred');
273: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
274: p_full_path => l_path_name,
275: p_remove_from_stack => FALSE);