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

Line 174: igs_ad_imp_001.logerrormessage(p_housing_rec.interface_housing_id,l_error_code);

170: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
171: END IF;
172:
173: IF l_enable_log = 'Y' THEN
174: igs_ad_imp_001.logerrormessage(p_housing_rec.interface_housing_id,l_error_code);
175: END IF;
176:
177: END crt_pe_house_status;
178: -- END OF LOCAL PROCEDURE crt_pe_house_status

Line 239: igs_ad_imp_001.logerrormessage(p_housing_rec.interface_housing_id,'E114');

235: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
236: END IF;
237:
238: IF l_enable_log = 'Y' THEN
239: igs_ad_imp_001.logerrormessage(p_housing_rec.interface_housing_id,'E114');
240: END IF;
241: END upd_pe_house_status; -- END OF LOCAL PROCEDURE upd_pe_priv_dtls
242:
243: -- Start Local function Validate_Record

Line 347: igs_ad_imp_001.logerrormessage(p_housing_rec.interface_housing_id,l_error_code);

343: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
344: END IF;
345:
346: IF l_enable_log = 'Y' THEN
347: igs_ad_imp_001.logerrormessage(p_housing_rec.interface_housing_id,l_error_code);
348: END IF;
349:
350: RETURN FALSE;
351: END Validate_Record;

Line 357: l_enable_log := igs_ad_imp_001.g_enable_log;

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: --
361: -- fetch the rule before the loop.

Line 358: l_interface_run_id :=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.

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: --
361: -- fetch the rule before the loop.
362:

Line 363: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id=>P_SOURCE_TYPE_ID,p_category=>'PERSON_HOUSING_STATUS');

359: -- Every child records needs to be updated with this value.
360: --
361: -- fetch the rule before the loop.
362:
363: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id=>P_SOURCE_TYPE_ID,p_category=>'PERSON_HOUSING_STATUS');
364:
365: -- 1. If the rule is E or I, and the match ind column is not null, update all the records to status 3 as they are invalids.
366:
367: IF ((l_rule='E') OR (l_rule='I')) THEN

Line 580: igs_ad_imp_001.logerrormessage(p_felony_dtls_cur.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');

576: RETURN TRUE;
577: EXCEPTION
578: WHEN NO_DATA_FOUND THEN
579: IF l_enable_log = 'Y' THEN
580: igs_ad_imp_001.logerrormessage(p_felony_dtls_cur.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');
581: END IF;
582:
583: UPDATE igs_pe_flny_dtl_int
584: SET status = '3',

Line 671: igs_ad_imp_001.logerrormessage(p_felony_dtls_rec.interface_felony_dtls_id,p_error_code,'IGS_PE_FLNY_DTL_INT');

667: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
668: END IF;
669: END IF;
670: IF l_enable_log = 'Y' THEN
671: igs_ad_imp_001.logerrormessage(p_felony_dtls_rec.interface_felony_dtls_id,p_error_code,'IGS_PE_FLNY_DTL_INT');
672: END IF;
673: END crt_pe_felony_dtls;
674: --
675: -- End of Local Procedure crt_pe_felony_dtls

Line 681: l_enable_log := igs_ad_imp_001.g_enable_log;

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:
685: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 682: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.

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:
685: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
686:

Line 702: l_rule :=Igs_Ad_Imp_001.find_source_cat_rule(p_source_type_id,'PERSON_DISCIPLINARY_DTLS');

698: END IF;
699:
700: --
701:
702: l_rule :=Igs_Ad_Imp_001.find_source_cat_rule(p_source_type_id,'PERSON_DISCIPLINARY_DTLS');
703:
704:
705: -- 1. If the rule is E or I, and the match ind column is not null, update all the records to status 3 as they are invalids.
706:

Line 880: igs_ad_imp_001.logerrormessage(felony_dtls_rec.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');

876: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
877: END IF;
878: END IF;
879: IF l_enable_log = 'Y' THEN
880: igs_ad_imp_001.logerrormessage(felony_dtls_rec.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');
881: END IF;
882:
883: UPDATE igs_pe_flny_dtl_int
884: SET status = l_status ,

Line 945: igs_ad_imp_001.logerrormessage(felony_dtls_rec.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');

941: END IF;
942: END IF;
943:
944: IF l_enable_log = 'Y' THEN
945: igs_ad_imp_001.logerrormessage(felony_dtls_rec.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');
946: END IF;
947:
948: UPDATE igs_pe_flny_dtl_int
949: SET status = l_status ,

Line 1064: igs_ad_imp_001.logerrormessage(p_hearing_dtls_cur.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');

1060: RETURN TRUE;
1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN
1063: IF l_enable_log = 'Y' THEN
1064: igs_ad_imp_001.logerrormessage(p_hearing_dtls_cur.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');
1065: END IF;
1066:
1067: UPDATE igs_pe_hear_dtl_int
1068: SET status = '3',

Line 1150: igs_ad_imp_001.logerrormessage(p_hearing_dtls_rec.interface_hearing_dtls_id,p_error_code,'IGS_PE_HEAR_DTL_INT');

1146: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1147: END IF;
1148: END IF;
1149: IF l_enable_log = 'Y' THEN
1150: igs_ad_imp_001.logerrormessage(p_hearing_dtls_rec.interface_hearing_dtls_id,p_error_code,'IGS_PE_HEAR_DTL_INT');
1151: END IF;
1152:
1153: END crt_pe_hearing_dtls;
1154: --

Line 1161: l_enable_log := igs_ad_imp_001.g_enable_log;

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:
1165: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 1162: l_interface_run_id := igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.

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:
1165: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1166:

Line 1183: l_rule :=Igs_Ad_Imp_001.find_source_cat_rule(p_source_type_id,'PERSON_DISCIPLINARY_DTLS');

1179:
1180:
1181: -- Fetching the Rule outside the loop.
1182:
1183: l_rule :=Igs_Ad_Imp_001.find_source_cat_rule(p_source_type_id,'PERSON_DISCIPLINARY_DTLS');
1184:
1185:
1186: -- 1. If the rule is E or I, and the match ind column is not null, update all the records to status 3 as they are invalids.
1187:

Line 1365: igs_ad_imp_001.logerrormessage(hearing_dtls_rec.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');

1361: END IF;
1362: END IF;
1363:
1364: IF l_enable_log = 'Y' THEN
1365: igs_ad_imp_001.logerrormessage(hearing_dtls_rec.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');
1366: END IF;
1367:
1368: UPDATE igs_pe_hear_dtl_int
1369: SET status = l_status,

Line 1432: igs_ad_imp_001.logerrormessage(hearing_dtls_rec.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');

1428:
1429: END IF;
1430:
1431: IF l_enable_log = 'Y' THEN
1432: igs_ad_imp_001.logerrormessage(hearing_dtls_rec.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');
1433: END IF;
1434:
1435:
1436: UPDATE igs_pe_hear_dtl_int

Line 1585: igs_ad_imp_001.logerrormessage(p_race_rec.interface_race_id,'E322','IGS_PE_RACE_INT');

1581: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1582: END IF;
1583:
1584: IF l_enable_log = 'Y' THEN
1585: igs_ad_imp_001.logerrormessage(p_race_rec.interface_race_id,'E322','IGS_PE_RACE_INT');
1586: END IF;
1587:
1588: END crt_pe_race;
1589:

Line 1640: igs_ad_imp_001.logerrormessage(p_race_rec.interface_race_id,l_error_code,'IGS_PE_RACE_INT');

1636: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1637: END IF;
1638:
1639: IF l_enable_log = 'Y' THEN
1640: igs_ad_imp_001.logerrormessage(p_race_rec.interface_race_id,l_error_code,'IGS_PE_RACE_INT');
1641: END IF;
1642:
1643: RETURN FALSE;
1644: END validate_race_record;

Line 1651: l_enable_log := igs_ad_imp_001.g_enable_log;

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:
1655: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 1652: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.

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:
1655: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1656:

Line 1673: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id, 'PERSON_TYPE');

1669:
1670: --
1671: -- Fetching the discrepency rule before the loop.
1672:
1673: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id, 'PERSON_TYPE');
1674:
1675: -- Update all the duplicate records with status 1 and match_ind 18
1676:
1677: UPDATE igs_pe_race_int pri

Line 1877: igs_ad_imp_001.logerrormessage(p_priv_rec.interface_privacy_id,l_error_code);

1873: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1874: END IF;
1875:
1876: IF l_enable_log = 'Y' THEN
1877: igs_ad_imp_001.logerrormessage(p_priv_rec.interface_privacy_id,l_error_code);
1878: END IF;
1879:
1880: END crt_pe_priv_dtls; -- End of local procedure to create privacy record.
1881:

Line 1963: igs_ad_imp_001.logerrormessage(p_int_rec.interface_privacy_id,l_error_code);

1959: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1960: END IF;
1961:
1962: IF l_enable_log = 'Y' THEN
1963: igs_ad_imp_001.logerrormessage(p_int_rec.interface_privacy_id,l_error_code);
1964: END IF;
1965: END upd_pe_priv_dtls;
1966:
1967: -- Local function to validate the record in the interfce table.

Line 2098: igs_ad_imp_001.logerrormessage(p_priv_rec.interface_privacy_id,l_error_code);

2094:
2095: END IF;
2096:
2097: IF l_enable_log = 'Y' THEN
2098: igs_ad_imp_001.logerrormessage(p_priv_rec.interface_privacy_id,l_error_code);
2099: END IF;
2100: RETURN FALSE;
2101:
2102: END validate_record; -- End of local function.

Line 2109: l_enable_log := igs_ad_imp_001.g_enable_log;

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');
2113:

Line 2110: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.

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');
2113:
2114: -- 1. If the rule is E or I, and the match ind column is not null, update all the records to status 3 as they are invalids.

Line 2112: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id=>P_SOURCE_TYPE_ID,p_category=>'PRIVACY_DETAILS');

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');
2113:
2114: -- 1. If the rule is E or I, and the match ind column is not null, update all the records to status 3 as they are invalids.
2115:
2116: IF ((l_rule='E') OR (l_rule='I')) THEN