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.FV_IPAC_DISBURSEMENT_PKG dependencies on FV_IPAC_IMPORT_HISTORY

Line 3666: --* : table into fv_ipac_import_history table *--

3662: --****************************************************************************************--
3663: --* Name : move_data_to_history *--
3664: --* Type : Procedure *--
3665: --* Purpose : This procedure moves all the processsed records from fv_ipac_import *--
3666: --* : table into fv_ipac_import_history table *--
3667: --* Parameters : p_group_id IN The group id for which the data is processed *--
3668: --* : p_errbuf OUT Error returned to the concurrent process *--
3669: --* : p_retcode OUT Return Code to concurrent process *--
3670: --* Global Vars : g_module_name READ *--

Line 3682: --* Tables Used : fv_ipac_import_history INSERT *--

3678: --* : g_exit READ *--
3679: --* Called from : main *--
3680: --* Calls : fv_utility.debug_mesg *--
3681: --* : fv_utility.log_mesg *--
3682: --* Tables Used : fv_ipac_import_history INSERT *--
3683: --* : fv_ipac_import SELECT, DELETE *--
3684: --* Logic : 1. Insert into fv_ipac_import_history by selecting all processed *--
3685: --* : records from fv_ipac_import *--
3686: --* : 2. Delete all processed records from fv_ipac_import *--

Line 3684: --* Logic : 1. Insert into fv_ipac_import_history by selecting all processed *--

3680: --* Calls : fv_utility.debug_mesg *--
3681: --* : fv_utility.log_mesg *--
3682: --* Tables Used : fv_ipac_import_history INSERT *--
3683: --* : fv_ipac_import SELECT, DELETE *--
3684: --* Logic : 1. Insert into fv_ipac_import_history by selecting all processed *--
3685: --* : records from fv_ipac_import *--
3686: --* : 2. Delete all processed records from fv_ipac_import *--
3687: --****************************************************************************************--
3688: PROCEDURE move_data_to_history

Line 3709: INSERT INTO fv_ipac_import_history

3705: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_group_id = '||p_group_id);
3706: END IF;
3707:
3708: BEGIN
3709: INSERT INTO fv_ipac_import_history
3710: (
3711: ipac_import_id,
3712: batch_name,
3713: transaction_id,

Line 4027: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Inserted '||l_rowcount||' rows into fv_ipac_import_history.');

4023: WHERE group_id = p_group_id
4024: AND record_status = g_status_processed;
4025: l_rowcount := SQL%ROWCOUNT;
4026: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4027: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Inserted '||l_rowcount||' rows into fv_ipac_import_history.');
4028: END IF;
4029: EXCEPTION
4030: WHEN OTHERS THEN
4031: p_error_code := g_FAILURE;

Line 4033: l_location := l_module_name||'.insert_fv_ipac_import_history';

4029: EXCEPTION
4030: WHEN OTHERS THEN
4031: p_error_code := g_FAILURE;
4032: p_error_desc := SQLERRM;
4033: l_location := l_module_name||'.insert_fv_ipac_import_history';
4034: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
4035: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
4036: END;
4037: