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

Line 150: igs_ad_imp_001.logerrormessage(acadhonor_rec.interface_acadhonor_id,'E052');

146:
147: IF acadhonor_rec.honor_date > SYSDATE OR acadhonor_rec.honor_date < l_bdate THEN
148: l_return_val := 'H';
149: IF l_enable_log = 'Y' THEN
150: igs_ad_imp_001.logerrormessage(acadhonor_rec.interface_acadhonor_id,'E052');
151: END IF;
152: END IF;
153:
154: END IF;

Line 158: igs_ad_imp_001.logerrormessage(acadhonor_rec.interface_acadhonor_id,'E421');

154: END IF;
155: ELSE
156: l_return_val := 'N';
157: IF l_enable_log = 'Y' THEN
158: igs_ad_imp_001.logerrormessage(acadhonor_rec.interface_acadhonor_id,'E421');
159: END IF;
160: END IF;
161:
162: RETURN l_return_val;

Line 241: igs_ad_imp_001.logerrormessage(acadhonor_rec.INTERFACE_ACADHONOR_ID,l_error_code);

237: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
238: END IF;
239:
240: IF l_enable_log = 'Y' THEN
241: igs_ad_imp_001.logerrormessage(acadhonor_rec.INTERFACE_ACADHONOR_ID,l_error_code);
242: END IF;
243:
244:
245: END crt_apcnt_acad_hnr;

Line 250: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

246: -- End Local Procedure
247:
248: -- Start of the Main Procedure PRC_APCNT_ACADHNR_DTLS
249: BEGIN
250: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
251: l_enable_log := igs_ad_imp_001.g_enable_log;
252: l_prog_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls';
253: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.';
254:

Line 251: l_enable_log := igs_ad_imp_001.g_enable_log;

247:
248: -- Start of the Main Procedure PRC_APCNT_ACADHNR_DTLS
249: BEGIN
250: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
251: l_enable_log := igs_ad_imp_001.g_enable_log;
252: l_prog_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls';
253: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.';
254:
255: --

Line 258: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_ACAD_HONORS');

254:
255: --
256: -- dld ref 2. Put them in a record called ACADHONOR_REC.
257: --
258: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_ACAD_HONORS');
259:
260: -- If rule is E or I, then if the match_ind is not null, the combination is invalid
261: IF l_rule IN ('E','I') THEN
262: UPDATE igs_ad_acadhonor_int_all

Line 407: igs_ad_imp_001.logerrormessage(acadhonor_rec.interface_acadhonor_id,'E014');

403: WHEN OTHERS THEN
404: l_status := '3';
405: l_error_code := 'E014';
406: IF l_enable_log = 'Y' THEN
407: igs_ad_imp_001.logerrormessage(acadhonor_rec.interface_acadhonor_id,'E014');
408: END IF;
409:
410: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
411:

Line 462: igs_ad_imp_001.logerrormessage(acadhonor_rec.interface_acadhonor_id,'E014');

458: WHEN OTHERS THEN
459: l_status := '3';
460: l_error_code := 'E014';
461: IF l_enable_log = 'Y' THEN
462: igs_ad_imp_001.logerrormessage(acadhonor_rec.interface_acadhonor_id,'E014');
463: END IF;
464:
465: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
466:

Line 551: igs_ad_imp_001.logerrormessage(acadhonor_rec.interface_acadhonor_id,'E518');

547: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
548: END IF;
549:
550: IF l_enable_log = 'Y' THEN
551: igs_ad_imp_001.logerrormessage(acadhonor_rec.interface_acadhonor_id,'E518');
552: END IF;
553:
554: END;
555:

Line 744: igs_ad_imp_001.logerrormessage(res_dtls_rec.Interface_res_Id,p_error_code);

740: SET status = '3',
741: error_code = p_error_code
742: WHERE interface_res_id = res_dtls_rec.interface_res_id;
743: IF l_enable_log = 'Y' THEN
744: igs_ad_imp_001.logerrormessage(res_dtls_rec.Interface_res_Id,p_error_code);
745: END IF;
746:
747: END validate_record;
748: -- End Local Function

Line 845: igs_ad_imp_001.logerrormessage(res_dtl_rec.interface_res_id,'E322');

841: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
842: END IF;
843:
844: IF l_enable_log = 'Y' THEN
845: igs_ad_imp_001.logerrormessage(res_dtl_rec.interface_res_id,'E322');
846: END IF;
847:
848: END crt_res_dtls;
849: -- End Local Procedure

Line 918: igs_ad_imp_001.logerrormessage(res_dtl_rec.interface_res_id,'E014');

914: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
915: END IF;
916:
917: IF l_enable_log = 'Y' THEN
918: igs_ad_imp_001.logerrormessage(res_dtl_rec.interface_res_id,'E014');
919: END IF;
920:
921: END update_res;
922:

Line 927: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

923: -- Start of the Main Procedure PRC_PE_RES_DTLS
924:
925: BEGIN
926:
927: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
928: l_enable_log := igs_ad_imp_001.g_enable_log;
929: l_prog_label := 'igs.plsql.igs_ad_imp_011.prc_pe_res_dtls';
930: l_label := 'igs.plsql.igs_ad_imp_011.prc_pe_res_dtls.';
931:

Line 928: l_enable_log := igs_ad_imp_001.g_enable_log;

924:
925: BEGIN
926:
927: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
928: l_enable_log := igs_ad_imp_001.g_enable_log;
929: l_prog_label := 'igs.plsql.igs_ad_imp_011.prc_pe_res_dtls';
930: l_label := 'igs.plsql.igs_ad_imp_011.prc_pe_res_dtls.';
931:
932: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_RESIDENCY_DETAILS');

Line 932: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_RESIDENCY_DETAILS');

928: l_enable_log := igs_ad_imp_001.g_enable_log;
929: l_prog_label := 'igs.plsql.igs_ad_imp_011.prc_pe_res_dtls';
930: l_label := 'igs.plsql.igs_ad_imp_011.prc_pe_res_dtls.';
931:
932: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_RESIDENCY_DETAILS');
933:
934: -- If rule is E or I, then if the match_ind is not null, the combination is invalid
935: IF l_rule IN ('E','I') THEN
936: UPDATE igs_pe_res_dtls_int

Line 1137: igs_ad_imp_001.logerrormessage(res_dtl_rec.interface_res_id,'E518');

1133: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1134: END IF;
1135:
1136: IF l_enable_log = 'Y' THEN
1137: igs_ad_imp_001.logerrormessage(res_dtl_rec.interface_res_id,'E518');
1138: END IF;
1139:
1140: END ;
1141: IF l_processed_records = 100 THEN

Line 1461: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,l_error_code,'IGS_AD_DISABLTY_INT_ALL');

1457: EXCEPTION
1458: WHEN NO_DATA_FOUND THEN
1459:
1460: IF l_enable_log = 'Y' THEN
1461: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,l_error_code,'IGS_AD_DISABLTY_INT_ALL');
1462: END IF;
1463:
1464: UPDATE igs_ad_disablty_int_all
1465: SET status = '3',

Line 1566: igs_ad_imp_001.logerrormessage(p_sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');

1562: EXCEPTION
1563:
1564: WHEN NO_DATA_FOUND THEN
1565: IF l_enable_log = 'Y' THEN
1566: igs_ad_imp_001.logerrormessage(p_sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');
1567: END IF;
1568:
1569:
1570: UPDATE igs_pe_sn_srvce_int

Line 1617: igs_ad_imp_001.logerrormessage(p_sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');

1613:
1614: EXCEPTION
1615: WHEN NO_DATA_FOUND THEN
1616: IF l_enable_log = 'Y' THEN
1617: igs_ad_imp_001.logerrormessage(p_sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');
1618: END IF;
1619:
1620: UPDATE igs_pe_sn_conct_int
1621: SET status = '3',

Line 1751: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,'E145','IGS_AD_DISABLTY_INT_ALL');

1747: l_debug_str, NULL,
1748: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1749: END IF;
1750: IF l_enable_log = 'Y' THEN
1751: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,'E145','IGS_AD_DISABLTY_INT_ALL');
1752: END IF;
1753: ELSE
1754: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1755: IF (l_request_id IS NULL) THEN

Line 1768: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,p_error_code,'IGS_AD_DISABLTY_INT_ALL');

1764: l_debug_str, NULL,
1765: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1766: END IF;
1767: IF l_enable_log = 'Y' THEN
1768: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,p_error_code,'IGS_AD_DISABLTY_INT_ALL');
1769: END IF;
1770: END IF;
1771:
1772:

Line 1878: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,l_error_code,'IGS_AD_DISABLTY_INT_ALL');

1874: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1875: END IF;
1876:
1877: IF l_enable_log = 'Y' THEN
1878: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,l_error_code,'IGS_AD_DISABLTY_INT_ALL');
1879: END IF;
1880:
1881: ELSE
1882: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

Line 1902: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,l_error_code,'IGS_AD_DISABLTY_INT_ALL');

1898: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1899: END IF;
1900:
1901: IF l_enable_log = 'Y' THEN
1902: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,l_error_code,'IGS_AD_DISABLTY_INT_ALL');
1903: END IF;
1904:
1905: END IF;
1906:

Line 2009: igs_ad_imp_001.logerrormessage(p_sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');

2005: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2006: END IF;
2007:
2008: IF l_enable_log = 'Y' THEN
2009: igs_ad_imp_001.logerrormessage(p_sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');
2010: END IF;
2011:
2012: END create_sn_service;
2013:

Line 2114: igs_ad_imp_001.logerrormessage(p_sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');

2110: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2111: END IF;
2112:
2113: IF l_enable_log = 'Y' THEN
2114: igs_ad_imp_001.logerrormessage(p_sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');
2115: END IF;
2116:
2117: END create_sn_contact;
2118:

Line 2319: igs_ad_imp_001.logerrormessage(sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');

2315: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2316: END IF;
2317:
2318: IF l_enable_log = 'Y' THEN
2319: igs_ad_imp_001.logerrormessage(sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');
2320: END IF;
2321:
2322: END;
2323: ELSIF l_rule = 'R' THEN

Line 2384: igs_ad_imp_001.logerrormessage(sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');

2380: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2381: END IF;
2382:
2383: IF l_enable_log = 'Y' THEN
2384: igs_ad_imp_001.logerrormessage(sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');
2385: END IF;
2386:
2387: END;
2388: END IF; -- service_rec.MATCH_IND check

Line 2590: igs_ad_imp_001.logerrormessage(sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');

2586: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2587: END IF;
2588:
2589: IF l_enable_log = 'Y' THEN
2590: igs_ad_imp_001.logerrormessage(sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');
2591: END IF;
2592:
2593:
2594: END;

Line 2656: igs_ad_imp_001.logerrormessage(sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');

2652: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2653: END IF;
2654:
2655: IF l_enable_log = 'Y' THEN
2656: igs_ad_imp_001.logerrormessage(sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');
2657: END IF;
2658:
2659:
2660: END;

Line 2717: l_rule := igs_ad_imp_001.find_source_cat_rule(

2713: l_debug_str, NULL,
2714: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2715: END IF;
2716:
2717: l_rule := igs_ad_imp_001.find_source_cat_rule(
2718: p_source_type_id => p_source_type_id,
2719: p_category => 'PERSON_SPECIAL_NEEDS');
2720:
2721:

Line 2915: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E347','IGS_AD_DISABLTY_INT_ALL');

2911:
2912: IF ((l_enable_log = 'Y') and (SQL%FOUND)) THEN
2913: fnd_message.set_name('IGS','IGS_EN_CONIND_NOTSET_NONE');
2914: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
2915: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E347','IGS_AD_DISABLTY_INT_ALL');
2916: END IF;
2917:
2918: ELSE
2919: process_sn_service(disability_rec.interface_disablty_id, l_disability_id, disability_rec.person_id,l_contact_status);

Line 2928: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E155','IGS_AD_DISABLTY_INT_ALL');

2924: error_code = 'E155'
2925: WHERE interface_disablty_id = disability_rec.interface_disablty_id;
2926:
2927: IF l_enable_log = 'Y' THEN
2928: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E155','IGS_AD_DISABLTY_INT_ALL');
2929: END IF;
2930:
2931: ELSIF l_contact_status = '3' THEN
2932:

Line 2939: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E148','IGS_AD_DISABLTY_INT_ALL');

2935: error_code = 'E148'
2936: WHERE interface_disablty_id = disability_rec.interface_disablty_id;
2937:
2938: IF l_enable_log = 'Y' THEN
2939: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E148','IGS_AD_DISABLTY_INT_ALL');
2940: END IF;
2941:
2942: ELSIF l_service_status = '3' THEN
2943:

Line 2950: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E147','IGS_AD_DISABLTY_INT_ALL');

2946: error_code = 'E147'
2947: WHERE interface_disablty_id = disability_rec.interface_disablty_id;
2948:
2949: IF l_enable_log = 'Y' THEN
2950: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E147','IGS_AD_DISABLTY_INT_ALL');
2951: END IF;
2952:
2953: END IF;
2954: END IF;

Line 3000: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E347','IGS_AD_DISABLTY_INT_ALL');

2996:
2997: IF ((l_enable_log = 'Y') and (SQL%FOUND)) THEN
2998: fnd_message.set_name('IGS','IGS_EN_CONIND_NOTSET_NONE');
2999: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
3000: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E347','IGS_AD_DISABLTY_INT_ALL');
3001: END IF;
3002:
3003: ELSE
3004: process_sn_service(sp_disability_rec.interface_disablty_id, l_disability_id, sp_disability_rec.person_id,l_contact_status);

Line 3013: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E155','IGS_AD_DISABLTY_INT_ALL');

3009: error_code = 'E155'
3010: WHERE interface_disablty_id = sp_disability_rec.interface_disablty_id;
3011:
3012: IF l_enable_log = 'Y' THEN
3013: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E155','IGS_AD_DISABLTY_INT_ALL');
3014: END IF;
3015:
3016: ELSIF l_contact_status = '3' THEN
3017:

Line 3023: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E148','IGS_AD_DISABLTY_INT_ALL');

3019: SET status = '4',
3020: error_code = 'E148'
3021: WHERE interface_disablty_id = sp_disability_rec.interface_disablty_id;
3022: IF l_enable_log = 'Y' THEN
3023: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E148','IGS_AD_DISABLTY_INT_ALL');
3024: END IF;
3025:
3026: ELSIF l_service_status = '3' THEN
3027:

Line 3033: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E147','IGS_AD_DISABLTY_INT_ALL');

3029: SET status = '4',
3030: error_code = 'E147'
3031: WHERE interface_disablty_id = sp_disability_rec.interface_disablty_id;
3032: IF l_enable_log = 'Y' THEN
3033: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E147','IGS_AD_DISABLTY_INT_ALL');
3034: END IF;
3035: END IF;
3036: END IF;
3037: END;

Line 3047: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

3043: END process_disability;
3044:
3045: --Start of the Main Processing
3046: BEGIN
3047: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
3048: l_enable_log := igs_ad_imp_001.g_enable_log;
3049: l_prog_label := 'igs.plsql.igs_ad_imp_011.prc_special_needs';
3050: l_label := 'igs.plsql.igs_ad_imp_011.prc_special_needs.';
3051:

Line 3048: l_enable_log := igs_ad_imp_001.g_enable_log;

3044:
3045: --Start of the Main Processing
3046: BEGIN
3047: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
3048: l_enable_log := igs_ad_imp_001.g_enable_log;
3049: l_prog_label := 'igs.plsql.igs_ad_imp_011.prc_special_needs';
3050: l_label := 'igs.plsql.igs_ad_imp_011.prc_special_needs.';
3051:
3052: process_disability;