DBA Data[Home] [Help]

APPS.IGS_AD_IMP_025 dependencies on IGS_AD_IMP_025

Line 1: PACKAGE BODY IGS_AD_IMP_025 AS

1: PACKAGE BODY IGS_AD_IMP_025 AS
2: /* $Header: IGSADB6B.pls 120.2 2005/07/15 06:32:06 appldev ship $ */
3: /*
4: || Created By : pkpatel
5: || Created On : 12-NOV-2001

Line 118: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status.begin_crt_pe_house_status';

114: IF (l_request_id IS NULL) THEN
115: l_request_id := fnd_global.conc_request_id;
116: END IF;
117:
118: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status.begin_crt_pe_house_status';
119: l_debug_str := 'igs_ad_imp_025.prc_pe_house_status.crt_pe_house_status';
120:
121: fnd_log.string_with_context( fnd_log.level_procedure,
122: l_label,

Line 119: l_debug_str := 'igs_ad_imp_025.prc_pe_house_status.crt_pe_house_status';

115: l_request_id := fnd_global.conc_request_id;
116: END IF;
117:
118: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status.begin_crt_pe_house_status';
119: l_debug_str := 'igs_ad_imp_025.prc_pe_house_status.crt_pe_house_status';
120:
121: fnd_log.string_with_context( fnd_log.level_procedure,
122: l_label,
123: l_debug_str, NULL,

Line 159: l_label := 'igs.plsql.igs_ad_imp_025.crt_pe_house_status.exception';

155: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
156: IF (l_request_id IS NULL) THEN
157: l_request_id := fnd_global.conc_request_id;
158: END IF;
159: l_label := 'igs.plsql.igs_ad_imp_025.crt_pe_house_status.exception';
160:
161: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
162: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
163: fnd_message.set_token('ERROR_CD',l_error_code);

Line 225: l_label := 'igs.plsql.igs_ad_imp_025.upd_pe_house_status.exception';

221: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
222: IF (l_request_id IS NULL) THEN
223: l_request_id := fnd_global.conc_request_id;
224: END IF;
225: l_label := 'igs.plsql.igs_ad_imp_025.upd_pe_house_status.exception';
226:
227: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
228: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
229: fnd_message.set_token('ERROR_CD','E114');

Line 332: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status.exception_validate_record';

328: IF (l_request_id IS NULL) THEN
329: l_request_id := fnd_global.conc_request_id;
330: END IF;
331:
332: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status.exception_validate_record';
333:
334: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
335: fnd_message.set_token('INTERFACE_ID',p_housing_rec.interface_housing_id);
336: fnd_message.set_token('ERROR_CD',l_error_code);

Line 355: l_prog_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status';

351: END Validate_Record;
352: -- End Local function Validate_Record
353:
354: BEGIN
355: l_prog_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status';
356: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status.';
357: l_enable_log := igs_ad_imp_001.g_enable_log;
358: l_interface_run_id :=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
359: -- Every child records needs to be updated with this value.

Line 356: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status.';

352: -- End Local function Validate_Record
353:
354: BEGIN
355: l_prog_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status';
356: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_house_status.';
357: l_enable_log := igs_ad_imp_001.g_enable_log;
358: l_interface_run_id :=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
359: -- Every child records needs to be updated with this value.
360: --

Line 610: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.begin_crt_pe_felony_dtls';

606: IF (l_request_id IS NULL) THEN
607: l_request_id := fnd_global.conc_request_id;
608: END IF;
609:
610: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.begin_crt_pe_felony_dtls';
611: l_debug_str := 'igs_ad_imp_025.crt_pe_felony_dtls';
612:
613: fnd_log.string_with_context( fnd_log.level_procedure,
614: l_label,

Line 611: l_debug_str := 'igs_ad_imp_025.crt_pe_felony_dtls';

607: l_request_id := fnd_global.conc_request_id;
608: END IF;
609:
610: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.begin_crt_pe_felony_dtls';
611: l_debug_str := 'igs_ad_imp_025.crt_pe_felony_dtls';
612:
613: fnd_log.string_with_context( fnd_log.level_procedure,
614: l_label,
615: l_debug_str, NULL,

Line 656: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception_crt_pe_felony_dtls';

652: IF (l_request_id IS NULL) THEN
653: l_request_id := fnd_global.conc_request_id;
654: END IF;
655:
656: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception_crt_pe_felony_dtls';
657:
658: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
659: fnd_message.set_token('INTERFACE_ID',p_felony_dtls_rec.interface_felony_dtls_id);
660: fnd_message.set_token('ERROR_CD',p_error_code);

Line 679: l_prog_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls';

675: -- End of Local Procedure crt_pe_felony_dtls
676: --Start of main procedure
677: BEGIN
678: -- Call Log header
679: l_prog_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls';
680: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.';
681: l_enable_log := igs_ad_imp_001.g_enable_log;
682: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
683: -- Every child records needs to be updated with this value.

Line 680: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.';

676: --Start of main procedure
677: BEGIN
678: -- Call Log header
679: l_prog_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls';
680: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.';
681: l_enable_log := igs_ad_imp_001.g_enable_log;
682: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
683: -- Every child records needs to be updated with this value.
684:

Line 691: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.begin';

687: IF (l_request_id IS NULL) THEN
688: l_request_id := fnd_global.conc_request_id;
689: END IF;
690:
691: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.begin';
692: l_debug_str := 'igs_ad_imp_025.prc_pe_felony_dtls';
693:
694: fnd_log.string_with_context( fnd_log.level_procedure,
695: l_label,

Line 692: l_debug_str := 'igs_ad_imp_025.prc_pe_felony_dtls';

688: l_request_id := fnd_global.conc_request_id;
689: END IF;
690:
691: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.begin';
692: l_debug_str := 'igs_ad_imp_025.prc_pe_felony_dtls';
693:
694: fnd_log.string_with_context( fnd_log.level_procedure,
695: l_label,
696: l_debug_str, NULL,

Line 865: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception';

861: IF (l_request_id IS NULL) THEN
862: l_request_id := fnd_global.conc_request_id;
863: END IF;
864:
865: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception';
866:
867: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
868: fnd_message.set_token('INTERFACE_ID',felony_dtls_rec.interface_felony_dtls_id);
869: fnd_message.set_token('ERROR_CD',l_error_code);

Line 929: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception1';

925: IF (l_request_id IS NULL) THEN
926: l_request_id := fnd_global.conc_request_id;
927: END IF;
928:
929: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_felony_dtls.exception1';
930:
931: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
932: fnd_message.set_token('INTERFACE_ID',felony_dtls_rec.interface_felony_dtls_id);
933: fnd_message.set_token('ERROR_CD',l_error_code);

Line 1091: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.begin_crt_pe_hearing_dtls';

1087: IF (l_request_id IS NULL) THEN
1088: l_request_id := fnd_global.conc_request_id;
1089: END IF;
1090:
1091: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.begin_crt_pe_hearing_dtls';
1092: l_debug_str := 'Igs_Ad_Imp_025.Prc_Pe_Hearing_Dtls.Crt_Pe_hearing_dtls';
1093:
1094: fnd_log.string_with_context( fnd_log.level_procedure,
1095: l_label,

Line 1092: l_debug_str := 'Igs_Ad_Imp_025.Prc_Pe_Hearing_Dtls.Crt_Pe_hearing_dtls';

1088: l_request_id := fnd_global.conc_request_id;
1089: END IF;
1090:
1091: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.begin_crt_pe_hearing_dtls';
1092: l_debug_str := 'Igs_Ad_Imp_025.Prc_Pe_Hearing_Dtls.Crt_Pe_hearing_dtls';
1093:
1094: fnd_log.string_with_context( fnd_log.level_procedure,
1095: l_label,
1096: l_debug_str, NULL,

Line 1135: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception_crt_pe_hearing_dtls';

1131: IF (l_request_id IS NULL) THEN
1132: l_request_id := fnd_global.conc_request_id;
1133: END IF;
1134:
1135: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception_crt_pe_hearing_dtls';
1136:
1137: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1138: fnd_message.set_token('INTERFACE_ID',p_hearing_dtls_rec.interface_hearing_dtls_id);
1139: fnd_message.set_token('ERROR_CD',p_error_code);

Line 1159: l_prog_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls';

1155: -- End of Local Procedure
1156: --
1157: BEGIN
1158: l_default_date := IGS_GE_DATE.IGSDATE('4712/12/31');
1159: l_prog_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls';
1160: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.';
1161: l_enable_log := igs_ad_imp_001.g_enable_log;
1162: l_interface_run_id := igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
1163: -- Every child records needs to be updated with this value.

Line 1160: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.';

1156: --
1157: BEGIN
1158: l_default_date := IGS_GE_DATE.IGSDATE('4712/12/31');
1159: l_prog_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls';
1160: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.';
1161: l_enable_log := igs_ad_imp_001.g_enable_log;
1162: l_interface_run_id := igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
1163: -- Every child records needs to be updated with this value.
1164:

Line 1171: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.begin';

1167: IF (l_request_id IS NULL) THEN
1168: l_request_id := fnd_global.conc_request_id;
1169: END IF;
1170:
1171: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.begin';
1172: l_debug_str := 'Igs_Ad_Imp_025.Prc_Pe_Hearing_Dtls';
1173:
1174: fnd_log.string_with_context( fnd_log.level_procedure,
1175: l_label,

Line 1172: l_debug_str := 'Igs_Ad_Imp_025.Prc_Pe_Hearing_Dtls';

1168: l_request_id := fnd_global.conc_request_id;
1169: END IF;
1170:
1171: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.begin';
1172: l_debug_str := 'Igs_Ad_Imp_025.Prc_Pe_Hearing_Dtls';
1173:
1174: fnd_log.string_with_context( fnd_log.level_procedure,
1175: l_label,
1176: l_debug_str, NULL,

Line 1349: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception1';

1345: IF (l_request_id IS NULL) THEN
1346: l_request_id := fnd_global.conc_request_id;
1347: END IF;
1348:
1349: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception1';
1350:
1351: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1352: fnd_message.set_token('INTERFACE_ID',hearing_dtls_rec.interface_hearing_dtls_id);
1353: fnd_message.set_token('ERROR_CD',l_error_code);

Line 1415: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception2';

1411: IF (l_request_id IS NULL) THEN
1412: l_request_id := fnd_global.conc_request_id;
1413: END IF;
1414:
1415: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_hearing_dtls.exception2';
1416:
1417: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1418: fnd_message.set_token('INTERFACE_ID',hearing_dtls_rec.interface_hearing_dtls_id);
1419: fnd_message.set_token('ERROR_CD',l_error_code);

Line 1536: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.begin_crt_pe_race';

1532: IF (l_request_id IS NULL) THEN
1533: l_request_id := fnd_global.conc_request_id;
1534: END IF;
1535:
1536: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.begin_crt_pe_race';
1537: l_debug_str := 'igs_ad_imp_025.prc_pe_race.crt_pe_race';
1538:
1539: fnd_log.string_with_context( fnd_log.level_procedure,
1540: l_label,

Line 1537: l_debug_str := 'igs_ad_imp_025.prc_pe_race.crt_pe_race';

1533: l_request_id := fnd_global.conc_request_id;
1534: END IF;
1535:
1536: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.begin_crt_pe_race';
1537: l_debug_str := 'igs_ad_imp_025.prc_pe_race.crt_pe_race';
1538:
1539: fnd_log.string_with_context( fnd_log.level_procedure,
1540: l_label,
1541: l_debug_str, NULL,

Line 1570: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.exception_crt_pe_race';

1566: IF (l_request_id IS NULL) THEN
1567: l_request_id := fnd_global.conc_request_id;
1568: END IF;
1569:
1570: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.exception_crt_pe_race';
1571:
1572: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1573: fnd_message.set_token('INTERFACE_ID',p_race_rec.interface_race_id);
1574: fnd_message.set_token('ERROR_CD','E322');

Line 1625: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.exception_validate_race_record';

1621: IF (l_request_id IS NULL) THEN
1622: l_request_id := fnd_global.conc_request_id;
1623: END IF;
1624:
1625: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.exception_validate_race_record';
1626:
1627: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1628: fnd_message.set_token('INTERFACE_ID',p_race_rec.interface_race_id);
1629: fnd_message.set_token('ERROR_CD',l_error_code);

Line 1649: l_prog_label := 'igs.plsql.igs_ad_imp_025.p_race_rec';

1645: -- end of local procedure
1646: -- start of main procedure prc_race
1647: BEGIN
1648:
1649: l_prog_label := 'igs.plsql.igs_ad_imp_025.p_race_rec';
1650: l_label := 'igs.plsql.igs_ad_imp_025.p_race_rec.';
1651: l_enable_log := igs_ad_imp_001.g_enable_log;
1652: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
1653: -- Every child records needs to be updated with this value.

Line 1650: l_label := 'igs.plsql.igs_ad_imp_025.p_race_rec.';

1646: -- start of main procedure prc_race
1647: BEGIN
1648:
1649: l_prog_label := 'igs.plsql.igs_ad_imp_025.p_race_rec';
1650: l_label := 'igs.plsql.igs_ad_imp_025.p_race_rec.';
1651: l_enable_log := igs_ad_imp_001.g_enable_log;
1652: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
1653: -- Every child records needs to be updated with this value.
1654:

Line 1661: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.begin';

1657: IF (l_request_id IS NULL) THEN
1658: l_request_id := fnd_global.conc_request_id;
1659: END IF;
1660:
1661: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.begin';
1662: l_debug_str := 'igs_ad_imp_025.prc_pe_race';
1663:
1664: fnd_log.string_with_context( fnd_log.level_procedure,
1665: l_label,

Line 1662: l_debug_str := 'igs_ad_imp_025.prc_pe_race';

1658: l_request_id := fnd_global.conc_request_id;
1659: END IF;
1660:
1661: l_label := 'igs.plsql.igs_ad_imp_025.prc_pe_race.begin';
1662: l_debug_str := 'igs_ad_imp_025.prc_pe_race';
1663:
1664: fnd_log.string_with_context( fnd_log.level_procedure,
1665: l_label,
1666: l_debug_str, NULL,

Line 1809: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.begin_crt_pe_priv_dtls';

1805: IF (l_request_id IS NULL) THEN
1806: l_request_id := fnd_global.conc_request_id;
1807: END IF;
1808:
1809: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.begin_crt_pe_priv_dtls';
1810: l_debug_str := 'igs_ad_imp_025.prc_priv_dtls.crt_pe_priv_dtls';
1811:
1812: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1813: END IF;

Line 1810: l_debug_str := 'igs_ad_imp_025.prc_priv_dtls.crt_pe_priv_dtls';

1806: l_request_id := fnd_global.conc_request_id;
1807: END IF;
1808:
1809: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.begin_crt_pe_priv_dtls';
1810: l_debug_str := 'igs_ad_imp_025.prc_priv_dtls.crt_pe_priv_dtls';
1811:
1812: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1813: END IF;
1814:

Line 1865: l_label := 'igs.plsql.igs_ad_imp_025.crt_pe_priv_dtls.exception';

1861: IF (l_request_id IS NULL) THEN
1862: l_request_id := fnd_global.conc_request_id;
1863: END IF;
1864:
1865: l_label := 'igs.plsql.igs_ad_imp_025.crt_pe_priv_dtls.exception';
1866:
1867: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1868: fnd_message.set_token('INTERFACE_ID',p_priv_rec.interface_privacy_id);
1869: fnd_message.set_token('ERROR_CD',l_error_code);

Line 1951: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.exception1';

1947: IF (l_request_id IS NULL) THEN
1948: l_request_id := fnd_global.conc_request_id;
1949: END IF;
1950:
1951: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.exception1';
1952:
1953: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1954: fnd_message.set_token('INTERFACE_ID',p_int_rec.interface_privacy_id);
1955: fnd_message.set_token('ERROR_CD',l_error_code);

Line 2088: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.exception_validate_record';

2084: IF (l_request_id IS NULL) THEN
2085: l_request_id := fnd_global.conc_request_id;
2086: END IF;
2087:
2088: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.exception_validate_record';
2089: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
2090: fnd_message.set_token('INTERFACE_ID',p_priv_rec.interface_privacy_id);
2091: fnd_message.set_token('ERROR_CD',l_error_code);
2092: l_debug_str := fnd_message.get || ' ' || SQLERRM;

Line 2107: l_prog_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls';

2103:
2104: BEGIN -- Main procedure for importing privacy details.
2105:
2106: l_default_date := IGS_GE_DATE.IGSDATE('4712/12/31');
2107: l_prog_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls';
2108: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.';
2109: l_enable_log := igs_ad_imp_001.g_enable_log;
2110: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
2111:

Line 2108: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.';

2104: BEGIN -- Main procedure for importing privacy details.
2105:
2106: l_default_date := IGS_GE_DATE.IGSDATE('4712/12/31');
2107: l_prog_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls';
2108: l_label := 'igs.plsql.igs_ad_imp_025.prc_priv_dtls.';
2109: l_enable_log := igs_ad_imp_001.g_enable_log;
2110: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
2111:
2112: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id=>P_SOURCE_TYPE_ID,p_category=>'PRIVACY_DETAILS');

Line 2255: END igs_ad_imp_025;

2251: END IF;
2252: END LOOP;
2253: END prc_priv_dtls;
2254:
2255: END igs_ad_imp_025;