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

Line 121: -- local variable to store the value of global variable igs_ad_imp_001.g_interface_run_id

117: l_check VARCHAR2(10);
118: l_contact_point_id igs_ad_contacts_int.dup_contact_point_id%TYPE;
119: rec_pc c_pc%ROWTYPE;
120: l_processed_records NUMBER(5) := 0 ;
121: -- local variable to store the value of global variable igs_ad_imp_001.g_interface_run_id
122: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
123: PROCEDURE crt_prsn_contacts(rec_pc c_pc%ROWTYPE ,
124: error_code OUT NOCOPY VARCHAR2,
125: status OUT NOCOPY VARCHAR2) AS

Line 225: igs_ad_imp_001.logerrormessage(rec_pc.interface_contacts_id,'E322');

221: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
222: END IF;
223:
224: IF l_enable_log = 'Y' THEN
225: igs_ad_imp_001.logerrormessage(rec_pc.interface_contacts_id,'E322');
226: END IF;
227:
228: UPDATE igs_ad_contacts_int_all
229: SET error_code='E322',status='3'

Line 267: igs_ad_imp_001.logerrormessage(rec_pc.interface_contacts_id,'E322');

263: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
264: END IF;
265:
266: IF l_enable_log = 'Y' THEN
267: igs_ad_imp_001.logerrormessage(rec_pc.interface_contacts_id,'E322');
268: END IF;
269:
270: UPDATE igs_ad_contacts_int_all
271: SET error_code='E322',status='3'

Line 310: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E246');

306: THEN
307: -- If the validation is not successful.
308:
309: IF l_enable_log = 'Y' THEN
310: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E246');
311: END IF;
312:
313: UPDATE igs_ad_contacts_int_all
314: SET status = cst_stat_val_3,

Line 326: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E450');

322: IF c_pc_rec.primary_flag IS NOT NULL THEN
323: IF c_pc_rec.primary_flag NOT IN ('N','Y') THEN
324:
325: IF l_enable_log = 'Y' THEN
326: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E450');
327: END IF;
328:
329: UPDATE igs_ad_contacts_int_all
330: SET error_code = 'E450',

Line 343: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E250');

339: -- Validation to check whether phone line type or phone number are null
340: IF c_pc_rec.phone_number IS NULL OR c_pc_rec.phone_line_type IS NULL THEN
341:
342: IF l_enable_log = 'Y' THEN
343: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E250');
344: END IF;
345:
346: UPDATE igs_ad_contacts_int_all
347: SET error_code = 'E250',

Line 360: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E247');

356: THEN
357: -- If the validation is not successful.
358:
359: IF l_enable_log = 'Y' THEN
360: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E247');
361: END IF;
362:
363: UPDATE igs_ad_contacts_int_all
364: SET status = '3',

Line 379: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E173');

375: IF c_ph_cntry_cd%NOTFOUND THEN
376: -- If the validation is not successful.
377:
378: IF l_enable_log = 'Y' THEN
379: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E173');
380: END IF;
381:
382: UPDATE igs_ad_contacts_int_all
383: SET status = '3',

Line 400: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E251');

396: -- Validation to check whether email address is null
397: IF c_pc_rec.email_address IS NULL THEN
398:
399: IF l_enable_log = 'Y' THEN
400: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E251');
401: END IF;
402:
403: UPDATE igs_ad_contacts_int_all
404: SET error_code = 'E251',

Line 416: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E248');

412: (igs_pe_pers_imp_001.validate_lookup_type_code('EMAIL_FORMAT',c_pc_rec.email_format,222))
413: THEN
414:
415: IF l_enable_log = 'Y' THEN
416: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E248');
417: END IF;
418:
419: UPDATE igs_ad_contacts_int_all
420: SET error_code = 'E248',

Line 435: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

431:
432: -- main procedure begins;
433: BEGIN
434:
435: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
436: l_prog_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls';
437: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.';
438: l_enable_log := igs_ad_imp_001.g_enable_log;
439:

Line 438: l_enable_log := igs_ad_imp_001.g_enable_log;

434:
435: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
436: l_prog_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls';
437: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.';
438: l_enable_log := igs_ad_imp_001.g_enable_log;
439:
440: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
441:
442: IF (l_request_id IS NULL) THEN

Line 455: l_rule :=igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_CONTACTS');

451: l_debug_str, NULL,
452: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
453: END IF;
454:
455: l_rule :=igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_CONTACTS');
456:
457: -- 1.If rule is E or I, then if the match_ind is not null, the combination is invalid
458: IF l_rule IN ('E','I') THEN
459: UPDATE igs_ad_contacts_int_all

Line 714: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E014');

710: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
711: END IF;
712:
713: IF l_enable_log = 'Y' THEN
714: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E014');
715: END IF;
716:
717:
718: UPDATE igs_ad_contacts_int_all

Line 754: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E014');

750: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
751: END IF;
752:
753: IF l_enable_log = 'Y' THEN
754: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E014');
755: END IF;
756:
757: UPDATE igs_ad_contacts_int_all
758: SET match_ind = cst_mi_val_18,

Line 850: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E014');

846: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
847: END IF;
848:
849: IF l_enable_log = 'Y' THEN
850: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E014');
851: END IF;
852:
853: UPDATE igs_ad_contacts_int_all
854: SET error_code = 'E014',

Line 887: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E014');

883: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
884: END IF;
885:
886: IF l_enable_log = 'Y' THEN
887: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E014');
888: END IF;
889:
890: UPDATE igs_ad_contacts_int_all
891: SET status = '3'

Line 923: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E518');

919: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
920: END IF;
921:
922: IF l_enable_log = 'Y' THEN
923: igs_ad_imp_001.logerrormessage(rec_pc1.interface_contacts_id,'E518');
924: END IF;
925:
926: UPDATE igs_ad_contacts_int_all
927: SET status = '3',error_code='E518'

Line 1060: igs_ad_imp_001.logerrormessage(p_person_language_rec.interface_language_id,l_error_code);

1056: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1057: END IF;
1058:
1059: IF l_enable_log = 'Y' THEN
1060: igs_ad_imp_001.logerrormessage(p_person_language_rec.interface_language_id,l_error_code);
1061: END IF;
1062:
1063: RETURN FALSE;
1064: END validate_lang;

Line 1157: igs_ad_imp_001.logerrormessage(p_person_language_rec.interface_language_id,'E322');

1153: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1154: END IF;
1155:
1156: IF l_enable_log = 'Y' THEN
1157: igs_ad_imp_001.logerrormessage(p_person_language_rec.interface_language_id,'E322');
1158: END IF;
1159:
1160: ELSE
1161:

Line 1198: igs_ad_imp_001.logerrormessage(p_person_language_rec.interface_language_id,'E322');

1194: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1195: END IF;
1196:
1197: IF l_enable_log = 'Y' THEN
1198: igs_ad_imp_001.logerrormessage(p_person_language_rec.interface_language_id,'E322');
1199: END IF;
1200:
1201: END crt_prsn_language;
1202: -- end of local procedure crt_prsn_lang

Line 1206: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

1202: -- end of local procedure crt_prsn_lang
1203: -- start of main procedure prc_pe_lang
1204: BEGIN
1205:
1206: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1207: l_prog_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language';
1208: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.';
1209: l_enable_log := igs_ad_imp_001.g_enable_log;
1210:

Line 1209: l_enable_log := igs_ad_imp_001.g_enable_log;

1205:
1206: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1207: l_prog_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language';
1208: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.';
1209: l_enable_log := igs_ad_imp_001.g_enable_log;
1210:
1211: l_rule :=igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_LANGUAGES');
1212:
1213: -- 1.If rule is E or I, then if the match_ind is not null, the combination is invalid

Line 1211: l_rule :=igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_LANGUAGES');

1207: l_prog_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language';
1208: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.';
1209: l_enable_log := igs_ad_imp_001.g_enable_log;
1210:
1211: l_rule :=igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_LANGUAGES');
1212:
1213: -- 1.If rule is E or I, then if the match_ind is not null, the combination is invalid
1214: IF l_rule IN ('E','I') THEN
1215: UPDATE igs_ad_language_int_all

Line 1398: igs_ad_imp_001.logerrormessage(person_language_rec.interface_language_id,'E014');

1394: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1395: END IF;
1396:
1397: IF l_enable_log = 'Y' THEN
1398: igs_ad_imp_001.logerrormessage(person_language_rec.interface_language_id,'E014');
1399: END IF;
1400:
1401:
1402: ELSE

Line 1434: igs_ad_imp_001.logerrormessage(person_language_rec.interface_language_id,'E014');

1430: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1431: END IF;
1432:
1433: IF l_enable_log = 'Y' THEN
1434: igs_ad_imp_001.logerrormessage(person_language_rec.interface_language_id,'E014');
1435: END IF;
1436:
1437: UPDATE igs_ad_language_int_all
1438: SET match_ind = NULL,

Line 1520: igs_ad_imp_001.logerrormessage(person_language_rec.interface_language_id,'E014');

1516: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1517: END IF;
1518:
1519: IF l_enable_log = 'Y' THEN
1520: igs_ad_imp_001.logerrormessage(person_language_rec.interface_language_id,'E014');
1521: END IF;
1522:
1523: ELSE
1524: UPDATE igs_ad_language_int_all

Line 1554: igs_ad_imp_001.logerrormessage(person_language_rec.interface_language_id,'E014');

1550: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1551: END IF;
1552:
1553: IF l_enable_log = 'Y' THEN
1554: igs_ad_imp_001.logerrormessage(person_language_rec.interface_language_id,'E014');
1555: END IF;
1556:
1557: UPDATE igs_ad_language_int_all
1558: SET match_ind = NULL,

Line 1718: igs_ad_imp_001.logerrormessage(p_ath_dtl_rec.interface_athletic_dtls_id,'E093','IGS_PE_ATH_DTL_INT');

1714: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1715: END IF;
1716:
1717: IF l_enable_log = 'Y' THEN
1718: igs_ad_imp_001.logerrormessage(p_ath_dtl_rec.interface_athletic_dtls_id,'E093','IGS_PE_ATH_DTL_INT');
1719: END IF;
1720:
1721: END crt_apcnt_ath_dtl;
1722: -- END OF LOCAL PROCEDURE crt_apcnt_ath_dtl

Line 1830: igs_ad_imp_001.logerrormessage(p_ath_dtl_rec.interface_athletic_dtls_id,l_error_code,'IGS_PE_ATH_DTL_INT');

1826: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1827: END IF;
1828:
1829: IF l_enable_log = 'Y' THEN
1830: igs_ad_imp_001.logerrormessage(p_ath_dtl_rec.interface_athletic_dtls_id,l_error_code,'IGS_PE_ATH_DTL_INT');
1831: END IF;
1832: RETURN FALSE;
1833: END validate_record;
1834: -- End Local function Validate_Record

Line 1839: l_enable_log := igs_ad_imp_001.g_enable_log;

1835:
1836: BEGIN
1837:
1838: -- Call Log header
1839: l_enable_log := igs_ad_imp_001.g_enable_log;
1840: l_prog_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_dtls';
1841: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_dtls.';
1842:
1843: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

Line 1843: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

1839: l_enable_log := igs_ad_imp_001.g_enable_log;
1840: l_prog_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_dtls';
1841: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_dtls.';
1842:
1843: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1844:
1845: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1846:
1847: IF (l_request_id IS NULL) THEN

Line 1860: l_rule := igs_ad_imp_001.find_source_cat_rule(

1856: l_debug_str, NULL,
1857: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1858: END IF;
1859:
1860: l_rule := igs_ad_imp_001.find_source_cat_rule(
1861: p_source_type_id => P_SOURCE_TYPE_ID,
1862: p_category => 'PERSON_ATHLETICS');
1863:
1864:

Line 2029: igs_ad_imp_001.logerrormessage(ath_dtl_rec.interface_athletic_dtls_id,l_error_code,'IGS_PE_ATH_DTL_INT');

2025: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2026: END IF;
2027:
2028: IF l_enable_log = 'Y' THEN
2029: igs_ad_imp_001.logerrormessage(ath_dtl_rec.interface_athletic_dtls_id,l_error_code,'IGS_PE_ATH_DTL_INT');
2030: END IF;
2031:
2032: END;
2033:

Line 2091: igs_ad_imp_001.logerrormessage(ath_dtl_rec.interface_athletic_dtls_id,l_error_code,'IGS_PE_ATH_DTL_INT');

2087: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2088: END IF;
2089:
2090: IF l_enable_log = 'Y' THEN
2091: igs_ad_imp_001.logerrormessage(ath_dtl_rec.interface_athletic_dtls_id,l_error_code,'IGS_PE_ATH_DTL_INT');
2092: END IF;
2093:
2094: END;
2095: END IF; -- ath_dtl_rec.MATCH_IND check

Line 2255: igs_ad_imp_001.logerrormessage(p_ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');

2251: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2252: END IF;
2253:
2254: IF l_enable_log = 'Y' THEN
2255: igs_ad_imp_001.logerrormessage(p_ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');
2256: END IF;
2257: END crt_apcnt_ath_prg;
2258: -- END OF LOCAL PROCEDURE crt_apcnt_ath_prg
2259:

Line 2355: igs_ad_imp_001.logerrormessage(p_ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');

2351: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2352: END IF;
2353:
2354: IF l_enable_log = 'Y' THEN
2355: igs_ad_imp_001.logerrormessage(p_ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');
2356: END IF;
2357:
2358: RETURN FALSE;
2359: END validate_record;

Line 2364: l_enable_log := igs_ad_imp_001.g_enable_log;

2360: -- End Local function Validate_Record
2361: -- Start of main procedure
2362: BEGIN
2363:
2364: l_enable_log := igs_ad_imp_001.g_enable_log;
2365: l_prog_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_prg';
2366: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_prg.';
2367:
2368: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

Line 2368: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

2364: l_enable_log := igs_ad_imp_001.g_enable_log;
2365: l_prog_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_prg';
2366: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_prg.';
2367:
2368: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
2369:
2370: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2371:
2372: IF (l_request_id IS NULL) THEN

Line 2385: l_rule := igs_ad_imp_001.find_source_cat_rule(

2381: l_debug_str, NULL,
2382: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2383: END IF;
2384:
2385: l_rule := igs_ad_imp_001.find_source_cat_rule(
2386: p_source_type_id => P_SOURCE_TYPE_ID,
2387: p_category => 'PERSON_ATHLETICS');
2388:
2389:

Line 2564: igs_ad_imp_001.logerrormessage(ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');

2560: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2561: END IF;
2562:
2563: IF l_enable_log = 'Y' THEN
2564: igs_ad_imp_001.logerrormessage(ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');
2565: END IF;
2566:
2567: END;
2568:

Line 2627: igs_ad_imp_001.logerrormessage(ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');

2623: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2624: END IF;
2625:
2626: IF l_enable_log = 'Y' THEN
2627: igs_ad_imp_001.logerrormessage(ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');
2628: END IF;
2629:
2630: END;
2631: