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_002 dependencies on IGS_PE_PERS_IMP_001

Line 90: (igs_pe_pers_imp_001.validate_country_code(p_person_rec.birth_country)) -- change for country code inconsistency bug 3738488

86: END IF;
87:
88: IF p_person_rec.birth_country IS NOT NULL THEN
89: IF NOT
90: (igs_pe_pers_imp_001.validate_country_code(p_person_rec.birth_country)) -- change for country code inconsistency bug 3738488
91: THEN
92: IF l_enable_log = 'Y' THEN
93: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E576','IGS_AD_INTERFACE_ALL');
94: END IF;

Line 102: (igs_pe_pers_imp_001.validate_lookup_type_code('VETERAN_STATUS',p_person_rec.veteran,8405))

98: END IF;
99:
100: IF p_person_rec.veteran IS NOT NULL THEN
101: IF NOT
102: (igs_pe_pers_imp_001.validate_lookup_type_code('VETERAN_STATUS',p_person_rec.veteran,8405))
103: THEN
104: IF l_enable_log = 'Y' THEN
105: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E174','IGS_AD_INTERFACE_ALL');
106: END IF;

Line 295: (igs_pe_pers_imp_001.validate_lookup_type_code('CONTACT_TITLE',P_Person_Rec.pre_name_adjunct,222))

291: BEGIN
292: -- Validate the title
293: IF P_Person_Rec.pre_name_adjunct IS NOT NULL THEN
294: IF NOT
295: (igs_pe_pers_imp_001.validate_lookup_type_code('CONTACT_TITLE',P_Person_Rec.pre_name_adjunct,222))
296: THEN
297: IF l_enable_log = 'Y' THEN
298: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_id,'E201','IGS_AD_INTERFACE_ALL');
299: END IF;

Line 311: (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_GENDER',P_Person_Rec.sex,222))

307:
308: -- Validate Sex.
309: IF P_Person_Rec.sex IS NOT NULL THEN
310: IF NOT
311: (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_GENDER',P_Person_Rec.sex,222))
312: THEN
313: IF l_enable_log = 'Y' THEN
314: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E202','IGS_AD_INTERFACE_ALL');
315: END IF;

Line 653: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_RELIGION',stat_rec.religion_cd,8405))

649: END IF;
650: IF stat_rec.RELIGION_CD IS NOT NULL THEN
651: BEGIN
652: IF NOT
653: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_RELIGION',stat_rec.religion_cd,8405))
654: THEN
655: IF l_enable_log = 'Y' THEN
656: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E205','IGS_AD_STAT_INT_ALL');
657: END IF;

Line 666: (igs_pe_pers_imp_001.validate_lookup_type_code('MARITAL_STATUS',stat_rec.MARITAL_STATUS,222))

662: END IF;
663: IF stat_rec.MARITAL_STATUS IS NOT NULL THEN
664: BEGIN
665: IF NOT
666: (igs_pe_pers_imp_001.validate_lookup_type_code('MARITAL_STATUS',stat_rec.MARITAL_STATUS,222))
667: THEN
668: IF l_enable_log = 'Y' THEN
669: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E206','IGS_AD_STAT_INT_ALL');
670: END IF;

Line 706: (igs_pe_pers_imp_001.validate_lookup_type_code('IGS_ETHNIC_ORIGIN',stat_rec.ETHNIC_ORIGIN,8405))

702: DECLARE
703: l_object_version_number NUMBER;
704: BEGIN
705: IF NOT
706: (igs_pe_pers_imp_001.validate_lookup_type_code('IGS_ETHNIC_ORIGIN',stat_rec.ETHNIC_ORIGIN,8405))
707: THEN
708: IF l_enable_log = 'Y' THEN
709: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E207','IGS_AD_STAT_INT_ALL');
710: END IF;

Line 1229: (igs_pe_pers_imp_001.validate_lookup_type_code('CONTACT_TITLE',P_Person_Rec.pre_name_adjunct,222))

1225:
1226: -- Validate the title
1227: IF P_Person_Rec.pre_name_adjunct IS NOT NULL THEN
1228: IF NOT
1229: (igs_pe_pers_imp_001.validate_lookup_type_code('CONTACT_TITLE',P_Person_Rec.pre_name_adjunct,222))
1230: THEN
1231: IF l_enable_log = 'Y' THEN
1232: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E201','IGS_AD_INTERFACE_ALL');
1233: END IF;

Line 1246: (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_GENDER',p_Person_Rec.sex,222))

1242:
1243: -- Validate Sex.
1244: IF P_Person_Rec.sex IS NOT NULL THEN
1245: IF NOT
1246: (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_GENDER',p_Person_Rec.sex,222))
1247: THEN
1248: IF l_enable_log = 'Y' THEN
1249: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E202','IGS_AD_INTERFACE_ALL');
1250: END IF;

Line 1917: igs_pe_pers_imp_001.validate_ucas_id(p_api_rec.alternate_id,p_person_id,p_api_rec.person_id_type,l_ucas_action,l_ucas_error_code);

1913: END IF;
1914:
1915: IF ((l_call_ucas_user_hook) AND (p_api_rec.person_id_type IN ('UCASID','NMASID','SWASID','GTTRID','UCASREGNO')))
1916: THEN
1917: igs_pe_pers_imp_001.validate_ucas_id(p_api_rec.alternate_id,p_person_id,p_api_rec.person_id_type,l_ucas_action,l_ucas_error_code);
1918:
1919: /* S - Skip record. P - Process record. E - Error out record. */
1920:
1921: IF (l_ucas_action = 'S')

Line 2229: (igs_pe_pers_imp_001.validate_lookup_type_code('PARTY_SITE_USE_CODE',c_usage_rec.site_use_code,222))

2225: BEGIN
2226: c_usage_rec.site_use_code := UPPER(c_usage_rec.site_use_code);
2227: l_interface_addrusage_id := c_usage_rec.interface_addrusage_id;
2228: IF NOT
2229: (igs_pe_pers_imp_001.validate_lookup_type_code('PARTY_SITE_USE_CODE',c_usage_rec.site_use_code,222))
2230: THEN
2231: l_error_code := 'E211';
2232: RAISE NO_DATA_FOUND;
2233: END IF;

Line 2657: (igs_pe_pers_imp_001.validate_lookup_type_code('PARTY_SITE_USE_CODE',c_usage_rec.site_use_code,222))

2653: BEGIN
2654: c_usage_rec.site_use_code := UPPER(c_usage_rec.site_use_code);
2655: l_interface_addrusage_id := c_usage_rec.interface_addrusage_id;
2656: IF NOT
2657: (igs_pe_pers_imp_001.validate_lookup_type_code('PARTY_SITE_USE_CODE',c_usage_rec.site_use_code,222))
2658: THEN
2659: l_error_code := 'E211';
2660: RAISE NO_DATA_FOUND;
2661: END IF;