APPS.IGI_IMP_IAC_TRANSFER_PKG dependencies on IGI_IAC_CATEGORY_BOOKS

Line 2737: p_string => 'Updating igi_iac_category_books run details...');

2733: END LOOP ;
2734:
2735: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2736: p_full_path => g_path||'transfer_data',
2737: p_string => 'Updating igi_iac_category_books run details...');
2738: -- Updating igi_iac_category_books run details...
2739: --
2740: UPDATE igi_iac_category_books c
2741: SET c.imp_run_number = nvl(c.imp_run_number ,0) + 1 ,

Line 2738: -- Updating igi_iac_category_books run details...

2734:
2735: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2736: p_full_path => g_path||'transfer_data',
2737: p_string => 'Updating igi_iac_category_books run details...');
2738: -- Updating igi_iac_category_books run details...
2739: --
2740: UPDATE igi_iac_category_books c
2741: SET c.imp_run_number = nvl(c.imp_run_number ,0) + 1 ,
2742: c.imp_period_counter = l_prd_rec.period_counter ,

Line 2740: UPDATE igi_iac_category_books c

2736: p_full_path => g_path||'transfer_data',
2737: p_string => 'Updating igi_iac_category_books run details...');
2738: -- Updating igi_iac_category_books run details...
2739: --
2740: UPDATE igi_iac_category_books c
2741: SET c.imp_run_number = nvl(c.imp_run_number ,0) + 1 ,
2742: c.imp_period_counter = l_prd_rec.period_counter ,
2743: c.imp_date = sysdate
2744: WHERE c.book_type_code = l_corporate_book

Line 2750: p_string => ' ERROR -> Updating igi_iac_category_books ...'|| sqlerrm );

2746:
2747: IF ( SQL%ROWCOUNT = 0 ) THEN
2748: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2749: p_full_path => g_path||'transfer_data',
2750: p_string => ' ERROR -> Updating igi_iac_category_books ...'|| sqlerrm );
2751: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
2752: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2753: p_full_path => g_path||'transfer_data',
2754: p_remove_from_stack => FALSE);