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.IGS_AD_IMP_001 dependencies on IGS_AD_IMP_001

Line 1: PACKAGE BODY Igs_Ad_Imp_001 AS

1: PACKAGE BODY Igs_Ad_Imp_001 AS
2: /* $Header: IGSAD79B.pls 120.3 2006/02/21 22:50:38 arvsrini noship $ */
3: /* ------------------------------------------------------------------------------------------------------------------------
4: || Created By :
5: || Created On :

Line 182: l_prog_label := 'igs.plsql.igs_ad_imp_001.update_parent_record_status';

178: l_stmt VARCHAR2(2000);
179:
180: BEGIN
181:
182: l_prog_label := 'igs.plsql.igs_ad_imp_001.update_parent_record_status';
183: l_label := 'igs.plsql.igs_ad_imp_001.update_parent_record_status.';
184:
185: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
186:

Line 183: l_label := 'igs.plsql.igs_ad_imp_001.update_parent_record_status.';

179:
180: BEGIN
181:
182: l_prog_label := 'igs.plsql.igs_ad_imp_001.update_parent_record_status';
183: l_label := 'igs.plsql.igs_ad_imp_001.update_parent_record_status.';
184:
185: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
186:
187: IF (l_request_id IS NULL) THEN

Line 191: l_label := 'igs.plsql.igs_ad_imp_001.update_parent_record_status.begin';

187: IF (l_request_id IS NULL) THEN
188: l_request_id := fnd_global.conc_request_id;
189: END IF;
190:
191: l_label := 'igs.plsql.igs_ad_imp_001.update_parent_record_status.begin';
192: l_debug_str := 'Source Type Id : ' || p_source_type_id || ' Batch ID : ' || p_batch_id;
193:
194: fnd_log.string_with_context (fnd_log.level_procedure,
195: l_label,

Line 357: l_prog_label := 'igs.plsql.igs_ad_imp_001.store_stats';

353: l_total_rec NUMBER;
354:
355: BEGIN
356:
357: l_prog_label := 'igs.plsql.igs_ad_imp_001.store_stats';
358: l_label := 'igs.plsql.igs_ad_imp_001.store_stats.';
359:
360: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
361:

Line 358: l_label := 'igs.plsql.igs_ad_imp_001.store_stats.';

354:
355: BEGIN
356:
357: l_prog_label := 'igs.plsql.igs_ad_imp_001.store_stats';
358: l_label := 'igs.plsql.igs_ad_imp_001.store_stats.';
359:
360: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
361:
362: IF (l_request_id IS NULL) THEN

Line 366: l_label := 'igs.plsql.igs_ad_imp_001.store_stats.begin';

362: IF (l_request_id IS NULL) THEN
363: l_request_id := fnd_global.conc_request_id;
364: END IF;
365:
366: l_label := 'igs.plsql.igs_ad_imp_001.store_stats.begin';
367: l_debug_str := 'Source Type Id : ' || p_source_type_id || ' Batch ID : ' || p_batch_id;
368:
369: fnd_log.string_with_context (fnd_log.level_procedure,
370: l_label,

Line 611: l_prog_label := 'igs.plsql.igs_ad_imp_001.imp_adm_data';

607: l_rowid VARCHAR2(100);
608: l_cnt_dup_process_run NUMBER;
609: l_err_msg VARCHAR2(4000);
610: BEGIN
611: l_prog_label := 'igs.plsql.igs_ad_imp_001.imp_adm_data';
612: l_label := 'igs.plsql.igs_ad_imp_001.imp_adm_data.';
613:
614: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
615:

Line 612: l_label := 'igs.plsql.igs_ad_imp_001.imp_adm_data.';

608: l_cnt_dup_process_run NUMBER;
609: l_err_msg VARCHAR2(4000);
610: BEGIN
611: l_prog_label := 'igs.plsql.igs_ad_imp_001.imp_adm_data';
612: l_label := 'igs.plsql.igs_ad_imp_001.imp_adm_data.';
613:
614: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
615:
616: IF (l_request_id IS NULL) THEN

Line 620: l_label := 'igs.plsql.igs_ad_imp_001.imp_adm_data.begin';

616: IF (l_request_id IS NULL) THEN
617: l_request_id := fnd_global.conc_request_id;
618: END IF;
619:
620: l_label := 'igs.plsql.igs_ad_imp_001.imp_adm_data.begin';
621: l_debug_str := 'Source Type Id : ' || p_source_type_id || ' Batch ID : ' || p_batch_id;
622:
623: fnd_log.string_with_context (fnd_log.level_procedure,
624: l_label,

Line 701: igs_ad_imp_001.g_interface_run_id := l_interface_run_id;

697: IF l_cnt_dup_process_run > 1 THEN
698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Another import process with same batch and source type is currently under execution hence aborting.');
699: APP_EXCEPTION.RAISE_EXCEPTION;
700: ELSE
701: igs_ad_imp_001.g_interface_run_id := l_interface_run_id;
702: igs_ad_imp_001.g_enable_log := p_enable_log;
703:
704: IF p_legacy_ind = 'N' THEN
705: IF import_legacy_data (

Line 702: igs_ad_imp_001.g_enable_log := p_enable_log;

698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Another import process with same batch and source type is currently under execution hence aborting.');
699: APP_EXCEPTION.RAISE_EXCEPTION;
700: ELSE
701: igs_ad_imp_001.g_interface_run_id := l_interface_run_id;
702: igs_ad_imp_001.g_enable_log := p_enable_log;
703:
704: IF p_legacy_ind = 'N' THEN
705: IF import_legacy_data (
706: p_batch_id => p_batch_id,

Line 762: igs_ad_imp_001.update_parent_record_status (p_source_type_id => p_source_type_id,

758:
759: -- Update category entities if child has failure (traverse parent to super parent)
760: -- Update parent based on p_interface_run_id
761: -- Select child based on FK link and not p_interface_run_id
762: igs_ad_imp_001.update_parent_record_status (p_source_type_id => p_source_type_id,
763: p_batch_id => p_batch_id,
764: p_interface_run_id => l_interface_run_id);
765:
766: -- Create process statistics

Line 788: igs_ad_imp_001.print_stats (l_interface_run_id);

784: WHERE interface_run_id = l_interface_run_id
785: AND status <> '1';
786: COMMIT;
787: -- Write process statistics to logfile
788: igs_ad_imp_001.print_stats (l_interface_run_id);
789: -------------------------------------------------------
790: -- enable HZ security policy if abnormal termination
791: -------------------------------------------------------
792: HZ_COMMON_PUB.ENABLE_CONT_SOURCE_SECURITY ;

Line 870: END Igs_Ad_Imp_001;

866: RETURN l_disp_rule;
867:
868: END find_source_cat_rule;
869:
870: END Igs_Ad_Imp_001;