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_AD_IMP_001

Line 45: l_enable_log := igs_ad_imp_001.g_enable_log;

41: l_felony_validation VARCHAR2(30);
42:
43: BEGIN
44:
45: l_enable_log := igs_ad_imp_001.g_enable_log;
46: l_prog_label := 'igs.plsql.igs_ad_imp_002.validate_oss_ext_attr';
47: l_label := 'igs.plsql.igs_ad_imp_002.validate_oss_ext_attr.';
48:
49: IF p_person_rec.PROOF_OF_INS NOT IN ('Y','N') THEN

Line 51: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E273','IGS_AD_INTERFACE_ALL');

47: l_label := 'igs.plsql.igs_ad_imp_002.validate_oss_ext_attr.';
48:
49: IF p_person_rec.PROOF_OF_INS NOT IN ('Y','N') THEN
50: IF l_enable_log = 'Y' THEN
51: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E273','IGS_AD_INTERFACE_ALL');
52: END IF;
53: l_error_code := 'E273';
54: RAISE validation_failed;
55: END IF;

Line 59: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E274','IGS_AD_INTERFACE_ALL');

55: END IF;
56:
57: IF p_person_rec.PROOF_OF_IMMU NOT IN ('Y','N') THEN
58: IF l_enable_log = 'Y' THEN
59: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E274','IGS_AD_INTERFACE_ALL');
60: END IF;
61: l_error_code := 'E274';
62: RAISE validation_failed;
63: END IF;

Line 67: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E275','IGS_AD_INTERFACE_ALL');

63: END IF;
64:
65: IF p_person_rec.MILITARY_SERVICE_REG NOT IN ('Y','N') THEN
66: IF l_enable_log = 'Y' THEN
67: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E275','IGS_AD_INTERFACE_ALL');
68: END IF;
69: l_error_code := 'E275';
70: RAISE validation_failed;
71: END IF;

Line 78: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E276','IGS_AD_INTERFACE_ALL');

74: OPEN level_of_qual_cur('LEVEL_OF_QUAL',p_person_rec.level_of_qual_id,'N');
75: FETCH level_of_qual_cur INTO l_var;
76: IF level_of_qual_cur%NOTFOUND THEN
77: IF l_enable_log = 'Y' THEN
78: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E276','IGS_AD_INTERFACE_ALL');
79: END IF;
80:
81: CLOSE level_of_qual_cur;
82: l_error_code := 'E276';

Line 93: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E576','IGS_AD_INTERFACE_ALL');

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;
95: l_error_code := 'E576';
96: RAISE validation_failed;
97: END IF;

Line 105: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E174','IGS_AD_INTERFACE_ALL');

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;
107: l_error_code := 'E174';
108: RAISE validation_failed;
109: END IF;

Line 114: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E164','IGS_AD_INTERFACE_ALL');

110: END IF;
111: IF (p_person_rec.felony_convicted_flag NOT IN ('Y','N',FND_API.G_MISS_CHAR)
112: AND p_person_rec.felony_convicted_flag IS NOT NULL ) THEN
113: IF l_enable_log = 'Y' THEN
114: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E164','IGS_AD_INTERFACE_ALL');
115: END IF;
116: l_error_code := 'E164';
117: RAISE validation_failed;
118: END IF;

Line 130: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E165','IGS_AD_INTERFACE_ALL');

126: END IF;
127:
128: IF l_felony_validation IS NOT NULL THEN
129: IF l_enable_log = 'Y' THEN
130: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E165','IGS_AD_INTERFACE_ALL');
131: END IF;
132: l_error_code := 'E165';
133: RAISE validation_failed;
134: END IF;

Line 268: l_enable_log := igs_ad_imp_001.g_enable_log;

264: l_oss_ext_attr_val VARCHAR2(1);
265: l_preferred_given_name igs_ad_interface_all.PREFERRED_GIVEN_NAME%TYPE;
266: l_felony_convicted_flag VARCHAR2(1);
267: BEGIN
268: l_enable_log := igs_ad_imp_001.g_enable_log;
269: l_prog_label := 'igs.plsql.igs_ad_imp_002.create_person';
270: l_label := 'igs.plsql.igs_ad_imp_002.create_person.';
271: l_rowid := '';
272: l_oss_ext_attr_val := 'Y';

Line 298: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_id,'E201','IGS_AD_INTERFACE_ALL');

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;
300: UPDATE IGS_AD_INTERFACE_ALL
301: SET ERROR_CODE = 'E201',
302: STATUS = '3'

Line 314: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E202','IGS_AD_INTERFACE_ALL');

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;
316:
317: UPDATE IGS_AD_INTERFACE_ALL
318: SET ERROR_CODE = 'E202',

Line 327: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E203','IGS_AD_INTERFACE_ALL');

323: END IF;
324: -- Validate birth_dt
325: IF (((P_Person_Rec.birth_dt IS NOT NULL) AND (P_Person_Rec.birth_dt > SYSDATE)) ) THEN
326: IF l_enable_log = 'Y' THEN
327: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E203','IGS_AD_INTERFACE_ALL');
328: END IF;
329: UPDATE IGS_AD_INTERFACE_ALL
330: SET ERROR_CODE = 'E203',
331: STATUS = '3'

Line 346: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E204','IGS_AD_INTERFACE_ALL');

342: ERROR_CODE = 'E204'
343: WHERE INTERFACE_ID = P_person_rec.INTERFACE_ID;
344: P_PERSON_ID := NULL;
345: IF l_enable_log = 'Y' THEN
346: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E204','IGS_AD_INTERFACE_ALL');
347: END IF;
348: RETURN;
349: ELSE
350: l_person_number := p_person_rec.person_number;

Line 364: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E285','IGS_AD_INTERFACE_ALL');

360: l_pref_altid := NULL;
361:
362: -- (pathipat) For Bug: 2485638
363: IF l_enable_log = 'Y' THEN
364: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E285','IGS_AD_INTERFACE_ALL');
365: END IF;
366:
367: UPDATE IGS_AD_INTERFACE_ALL
368: SET ERROR_CODE = 'E285', STATUS = '3'

Line 383: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E268','IGS_AD_INTERFACE_ALL');

379: -- Validate the format mask
380: IF api_type_rec.format_mask IS NOT NULL THEN
381: IF NOT igs_en_val_api.fm_equal(p_person_rec.PREF_ALTERNATE_ID,api_type_rec.format_mask) THEN
382: IF l_enable_log = 'Y' THEN
383: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E268','IGS_AD_INTERFACE_ALL');
384: END IF;
385:
386: UPDATE IGS_AD_INTERFACE_ALL
387: SET ERROR_CODE = 'E268',

Line 554: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E322','IGS_AD_INTERFACE_ALL');

550: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
551: END IF;
552:
553: IF l_enable_log = 'Y' THEN
554: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E322','IGS_AD_INTERFACE_ALL');
555: END IF;
556: RETURN;
557: ELSE
558: UPDATE IGS_AD_INTERFACE_all

Line 603: igs_ad_imp_001.logerrormessage(p_person_rec.interface_id,l_error_code,'IGS_AD_INTERFACE_ALL');

599: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
600: END IF;
601:
602: IF l_enable_log = 'Y' THEN
603: igs_ad_imp_001.logerrormessage(p_person_rec.interface_id,l_error_code,'IGS_AD_INTERFACE_ALL');
604: END IF;
605:
606: P_PERSON_ID := NULL;
607:

Line 656: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E205','IGS_AD_STAT_INT_ALL');

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;
658: l_error_code := 'E205' ;
659: RAISE NO_DATA_FOUND;
660: END IF;

Line 669: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E206','IGS_AD_STAT_INT_ALL');

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;
671: l_error_code :='E206';
672: RAISE NO_DATA_FOUND;
673: END IF;

Line 695: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E277','IGS_AD_STAT_INT_ALL');

691: END IF;
692: EXCEPTION
693: WHEN NO_DATA_FOUND THEN
694: IF l_enable_log = 'Y' THEN
695: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E277','IGS_AD_STAT_INT_ALL');
696: END IF;
697: l_error_code :='E277';
698: RAISE NO_DATA_FOUND;
699: END;

Line 709: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E207','IGS_AD_STAT_INT_ALL');

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;
711: l_error_code := 'E207' ;
712: RAISE NO_DATA_FOUND;
713: END IF;

Line 837: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E005','IGS_AD_STAT_INT_ALL');

833: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
834: END IF;
835:
836: IF l_enable_log = 'Y' THEN
837: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E005','IGS_AD_STAT_INT_ALL');
838: END IF;
839:
840: ELSE
841: UPDATE IGS_AD_STAT_INT_ALL

Line 897: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E005','IGS_AD_STAT_INT_ALL');

893: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
894: END IF;
895:
896: IF l_enable_log = 'Y' THEN
897: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E005','IGS_AD_STAT_INT_ALL');
898: END IF;
899:
900: END;
901: END IF;

Line 969: igs_ad_imp_001.logerrormessage(P_person_rec.INTERFACE_ID,'E006','IGS_AD_INTERFACE_ALL');

965: error_code = 'E006'
966: WHERE interface_id = p_person_rec.interface_id;
967:
968: IF l_enable_log = 'Y' THEN
969: igs_ad_imp_001.logerrormessage(P_person_rec.INTERFACE_ID,'E006','IGS_AD_INTERFACE_ALL');
970: END IF;
971: END IF;
972: END LOOP;
973: CLOSE ADDR_CUR;

Line 1004: igs_ad_imp_001.logerrormessage(P_person_rec.INTERFACE_ID,'E007','IGS_AD_INTERFACE_ALL');

1000: SET status = '4',
1001: error_code = 'E007'
1002: WHERE interface_id = p_person_rec.interface_id;
1003: IF l_enable_log = 'Y' THEN
1004: igs_ad_imp_001.logerrormessage(P_person_rec.INTERFACE_ID,'E007','IGS_AD_INTERFACE_ALL');
1005: END IF;
1006:
1007: ELSIF l_status = '1' THEN
1008:

Line 1203: l_enable_log := igs_ad_imp_001.g_enable_log;

1199: l_preferred_given_name igs_ad_interface_all.PREFERRED_GIVEN_NAME%TYPE;
1200: l_felony_convicted_flag VARCHAR2(1);
1201: BEGIN
1202:
1203: l_enable_log := igs_ad_imp_001.g_enable_log;
1204: l_prog_label := 'igs.plsql.igs_ad_imp_002.update_person';
1205: l_label := 'igs.plsql.igs_ad_imp_002.update_person.';
1206: l_oss_ext_attr_val := 'Y';
1207:

Line 1232: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E201','IGS_AD_INTERFACE_ALL');

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;
1234:
1235: UPDATE IGS_AD_INTERFACE_ALL
1236: SET ERROR_CODE = 'E201',

Line 1249: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E202','IGS_AD_INTERFACE_ALL');

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;
1251:
1252: UPDATE IGS_AD_INTERFACE_ALL
1253: SET ERROR_CODE = 'E202',

Line 1263: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E203','IGS_AD_INTERFACE_ALL');

1259:
1260: -- Validate birth_dt
1261: IF ( ((P_Person_Rec.birth_dt IS NOT NULL) AND (P_Person_Rec.birth_dt > SYSDATE)) ) THEN
1262: IF l_enable_log = 'Y' THEN
1263: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E203','IGS_AD_INTERFACE_ALL');
1264: END IF;
1265:
1266: UPDATE IGS_AD_INTERFACE_ALL
1267: SET ERROR_CODE = 'E203',

Line 1283: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E285','IGS_AD_INTERFACE_ALL');

1279: l_pref_altid := NULL;
1280:
1281: -- (pathipat) For Bug: 2485638
1282: IF l_enable_log = 'Y' THEN
1283: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E285','IGS_AD_INTERFACE_ALL');
1284: END IF;
1285:
1286: UPDATE IGS_AD_INTERFACE_ALL
1287: SET ERROR_CODE = 'E285',

Line 1303: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E268','IGS_AD_INTERFACE_ALL');

1299: -- Validate the format mask
1300: IF api_type_rec.format_mask IS NOT NULL THEN
1301: IF NOT igs_en_val_api.fm_equal(p_person_rec.PREF_ALTERNATE_ID,api_type_rec.format_mask) THEN
1302: IF l_enable_log = 'Y' THEN
1303: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E268','IGS_AD_INTERFACE_ALL');
1304: END IF;
1305:
1306: UPDATE IGS_AD_INTERFACE_ALL
1307: SET ERROR_CODE = 'E268',

Line 1328: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E019','IGS_AD_INTERFACE_ALL');

1324: OPEN hz_parties_cur(p_person_id);
1325: FETCH hz_parties_cur INTO l_last_update_date, l_rowid;
1326: IF hz_parties_cur%NOTFOUND THEN
1327: IF l_enable_log = 'Y' THEN
1328: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E019','IGS_AD_INTERFACE_ALL');
1329: END IF;
1330:
1331: UPDATE IGS_AD_INTERFACE_ALL
1332: SET ERROR_CODE = 'E019',

Line 1529: igs_ad_imp_001.logerrormessage(p_person_rec.interface_id,l_error_code,'IGS_AD_INTERFACE_ALL');

1525: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1526: END IF;
1527:
1528: IF l_enable_log = 'Y' THEN
1529: igs_ad_imp_001.logerrormessage(p_person_rec.interface_id,l_error_code,'IGS_AD_INTERFACE_ALL');
1530: END IF;
1531: RETURN;
1532: END;
1533:

Line 1564: igs_ad_imp_001.logerrormessage(P_person_rec.INTERFACE_ID,'E014','IGS_AD_INTERFACE_ALL');

1560: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1561: END IF;
1562:
1563: IF l_enable_log = 'Y' THEN
1564: igs_ad_imp_001.logerrormessage(P_person_rec.INTERFACE_ID,'E014','IGS_AD_INTERFACE_ALL');
1565: END IF;
1566: RETURN;
1567:
1568: ELSE

Line 1690: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E007','IGS_AD_INTERFACE_ALL');

1686: ERROR_CODE = 'E007'
1687: WHERE interface_id = p_person_rec.interface_id;
1688:
1689: IF l_enable_log = 'Y' THEN
1690: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E007','IGS_AD_INTERFACE_ALL');
1691: END IF;
1692:
1693: ELSIF l_status = '1' THEN
1694:

Line 1875: igs_ad_imp_001.logerrormessage(p_api_rec.Interface_api_Id,p_error_code,'IGS_AD_API_INT_ALL');

1871: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1872: END IF;
1873:
1874: IF l_enable_log = 'Y' THEN
1875: igs_ad_imp_001.logerrormessage(p_api_rec.Interface_api_Id,p_error_code,'IGS_AD_API_INT_ALL');
1876: END IF;
1877:
1878: RETURN FALSE;
1879: END validate_api;

Line 1883: l_enable_log := igs_ad_imp_001.g_enable_log;

1879: END validate_api;
1880:
1881: BEGIN
1882:
1883: l_enable_log := igs_ad_imp_001.g_enable_log;
1884: l_prog_label := 'igs.plsql.igs_ad_imp_002.create_api';
1885: l_label := 'igs.plsql.igs_ad_imp_002.create_api.';
1886:
1887: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 2036: igs_ad_imp_001.logerrormessage(p_api_rec.interface_api_id,p_error_code,'IGS_AD_API_INT_ALL');

2032: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2033: END IF;
2034:
2035: IF l_enable_log = 'Y' THEN
2036: igs_ad_imp_001.logerrormessage(p_api_rec.interface_api_id,p_error_code,'IGS_AD_API_INT_ALL');
2037: END IF;
2038: RETURN;
2039: END;
2040: ELSE

Line 2132: igs_ad_imp_001.logerrormessage(p_api_rec.interface_api_id,p_error_code,'IGS_AD_API_INT_ALL');

2128: l_debug_str, NULL,
2129: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2130: END IF;
2131: IF l_enable_log = 'Y' THEN
2132: igs_ad_imp_001.logerrormessage(p_api_rec.interface_api_id,p_error_code,'IGS_AD_API_INT_ALL');
2133: END IF;
2134: p_status := '3';
2135: RETURN;
2136: END;

Line 2305: igs_ad_imp_001.logerrormessage(l_interface_addrusage_id,l_error_code,'IGS_AD_ADDRUSAGE_INT_ALL');

2301: ERROR_CODE = l_error_code
2302: WHERE interface_addrusage_id = c_usage_rec.interface_addrusage_id;
2303:
2304: IF l_enable_log = 'Y' THEN
2305: igs_ad_imp_001.logerrormessage(l_interface_addrusage_id,l_error_code,'IGS_AD_ADDRUSAGE_INT_ALL');
2306: END IF;
2307:
2308: END;
2309:

Line 2353: igs_ad_imp_001.logerrormessage(l_interface_addrusage_id,'E244','IGS_AD_ADDRUSAGE_INT_ALL');

2349: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2350: END IF;
2351:
2352: IF l_enable_log = 'Y' THEN
2353: igs_ad_imp_001.logerrormessage(l_interface_addrusage_id,'E244','IGS_AD_ADDRUSAGE_INT_ALL');
2354: END IF;
2355:
2356: END process_addrusage;
2357:

Line 2360: l_enable_log := igs_ad_imp_001.g_enable_log;

2356: END process_addrusage;
2357:
2358: BEGIN
2359:
2360: l_enable_log := igs_ad_imp_001.g_enable_log;
2361: l_prog_label := 'igs.plsql.igs_ad_imp_002.create_address';
2362: l_label := 'igs.plsql.igs_ad_imp_002.create_address.';
2363:
2364: -- Call Log header

Line 2455: igs_ad_imp_001.logerrormessage(p_addr_rec.interface_addr_id,'E006','IGS_AD_ADDR_INT_ALL');

2451: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2452: END IF;
2453:
2454: IF l_enable_log = 'Y' THEN
2455: igs_ad_imp_001.logerrormessage(p_addr_rec.interface_addr_id,'E006','IGS_AD_ADDR_INT_ALL');
2456: END IF;
2457: ELSE
2458: IF l_return_status = 'W' THEN
2459: UPDATE IGS_AD_ADDR_INT_ALL

Line 2483: igs_ad_imp_001.logerrormessage(p_addr_rec.interface_addr_id,'E073','IGS_AD_ADDR_INT_ALL');

2479: l_debug_str, NULL,
2480: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2481: END IF;
2482: IF l_enable_log = 'Y' THEN
2483: igs_ad_imp_001.logerrormessage(p_addr_rec.interface_addr_id,'E073','IGS_AD_ADDR_INT_ALL');
2484: END IF;
2485: ELSE
2486: UPDATE IGS_AD_ADDR_INT_ALL
2487: SET STATUS = '1',

Line 2510: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_addr_ID,'E006','IGS_AD_ADDR_INT_ALL');

2506: error_code = 'E006'
2507: WHERE interface_id = p_addr_rec.interface_id;
2508:
2509: IF l_enable_log = 'Y' THEN
2510: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_addr_ID,'E006','IGS_AD_ADDR_INT_ALL');
2511: END IF;
2512: p_status := '3';
2513: END IF;
2514: EXCEPTION

Line 2550: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_addr_ID,'E006','IGS_AD_ADDR_INT_ALL');

2546: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2547: END IF;
2548:
2549: IF l_enable_log = 'Y' THEN
2550: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_addr_ID,'E006','IGS_AD_ADDR_INT_ALL');
2551: END IF;
2552:
2553: END CREATE_ADDRESS;
2554:

Line 2733: igs_ad_imp_001.logerrormessage(l_interface_addrusage_id,l_error_code,'IGS_AD_ADDRUSAGE_INT_ALL');

2729: ERROR_CODE = l_error_code
2730: WHERE interface_addrusage_id = c_usage_rec.interface_addrusage_id;
2731:
2732: IF l_enable_log = 'Y' THEN
2733: igs_ad_imp_001.logerrormessage(l_interface_addrusage_id,l_error_code,'IGS_AD_ADDRUSAGE_INT_ALL');
2734: END IF;
2735:
2736: END;
2737:

Line 2781: igs_ad_imp_001.logerrormessage(l_interface_addrusage_id,'E244','IGS_AD_ADDRUSAGE_INT_ALL');

2777: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2778: END IF;
2779:
2780: IF l_enable_log = 'Y' THEN
2781: igs_ad_imp_001.logerrormessage(l_interface_addrusage_id,'E244','IGS_AD_ADDRUSAGE_INT_ALL');
2782: END IF;
2783:
2784: END process_addrusage;
2785:

Line 2788: l_enable_log := igs_ad_imp_001.g_enable_log;

2784: END process_addrusage;
2785:
2786: BEGIN
2787:
2788: l_enable_log := igs_ad_imp_001.g_enable_log;
2789: l_prog_label := 'igs.plsql.igs_ad_imp_002.update_address';
2790: l_label := 'igs.plsql.igs_ad_imp_002.update_address.';
2791: l_location_id := p_location_id;
2792: l_party_site_id := p_party_site_id;

Line 2917: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,p_error_code,'IGS_AD_ADDR_INT_ALL');

2913: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2914: END IF;
2915:
2916: IF l_enable_log = 'Y' THEN
2917: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,p_error_code,'IGS_AD_ADDR_INT_ALL');
2918: END IF;
2919: ELSE
2920: IF l_return_status = 'W' THEN
2921: UPDATE igs_ad_addr_int_all

Line 2944: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,p_error_code,'IGS_AD_ADDR_INT_ALL');

2940: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2941: END IF;
2942:
2943: IF l_enable_log = 'Y' THEN
2944: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,p_error_code,'IGS_AD_ADDR_INT_ALL');
2945: END IF;
2946: ELSE
2947: UPDATE igs_ad_addr_int_all
2948: SET status = '1',

Line 2990: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,'E014','IGS_AD_ADDR_INT_ALL');

2986: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2987: END IF;
2988:
2989: IF l_enable_log = 'Y' THEN
2990: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,'E014','IGS_AD_ADDR_INT_ALL');
2991: END IF;
2992:
2993: END UPDATE_ADDRESS;
2994:

Line 3156: l_enable_log := igs_ad_imp_001.g_enable_log;

3152: l_match_ind igs_ad_interface.match_ind%TYPE;
3153:
3154: BEGIN
3155:
3156: l_enable_log := igs_ad_imp_001.g_enable_log;
3157: l_prog_label := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls';
3158: l_label := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls.';
3159: -- populate global variables
3160: Igs_Pe_Identify_Dups.g_match_set_id := p_match_set_id;

Line 3206: l_lvcAction := Igs_Ad_Imp_001.FIND_SOURCE_CAT_RULE(p_d_source_type_id,'PERSON');

3202: OPEN addr_personid_type_cur(p_match_set_id,'PERSON_ID_TYPE');
3203: FETCH addr_personid_type_cur INTO l_personidtype;
3204: CLOSE addr_personid_type_cur;
3205:
3206: l_lvcAction := Igs_Ad_Imp_001.FIND_SOURCE_CAT_RULE(p_d_source_type_id,'PERSON');
3207: IF l_lvcAction = 'D' THEN
3208: -- Get the attribute level discrepancy rule.
3209: l_attribute_action := Igs_Ad_Imp_023.find_attribute_rule(
3210: p_source_type_id => p_d_source_type_id,