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

Line 194: igs_ad_imp_001.logerrormessage(military_rec.Interface_military_Id,'E322');

190: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
191: END IF;
192:
193: IF l_enable_log = 'Y' THEN
194: igs_ad_imp_001.logerrormessage(military_rec.Interface_military_Id,'E322');
195: END IF;
196:
197: END crt_pr_mil;
198:

Line 311: igs_ad_imp_001.logerrormessage(military_rec.Interface_military_Id,p_error_code);

307: status = '3'
308: WHERE interface_military_id = military_rec.interface_military_id ;
309:
310: IF l_enable_log = 'Y' THEN
311: igs_ad_imp_001.logerrormessage(military_rec.Interface_military_Id,p_error_code);
312: END IF;
313:
314: END;
315:

Line 317: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

313:
314: END;
315:
316: BEGIN
317: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
318: l_enable_log := igs_ad_imp_001.g_enable_log;
319: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls';
320: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls.';
321: l_check := 'FALSE' ;

Line 318: l_enable_log := igs_ad_imp_001.g_enable_log;

314: END;
315:
316: BEGIN
317: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
318: l_enable_log := igs_ad_imp_001.g_enable_log;
319: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls';
320: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls.';
321: l_check := 'FALSE' ;
322:

Line 324: l_rule :=Igs_Ad_Imp_001.FIND_SOURCE_CAT_RULE(P_SOURCE_TYPE_ID,'PERSON_MILITARY_DETAILS');

320: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls.';
321: l_check := 'FALSE' ;
322:
323:
324: l_rule :=Igs_Ad_Imp_001.FIND_SOURCE_CAT_RULE(P_SOURCE_TYPE_ID,'PERSON_MILITARY_DETAILS');
325:
326: -- If rule is E or I, then if the match_ind is not null, the combination is invalid
327: IF l_rule IN ('E','I') THEN
328: UPDATE igs_ad_military_int_all

Line 533: igs_ad_imp_001.logerrormessage(MILITARY_REC.INTERFACE_MILITARY_ID,'E014');

529: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
530: END IF;
531:
532: IF l_enable_log = 'Y' THEN
533: igs_ad_imp_001.logerrormessage(MILITARY_REC.INTERFACE_MILITARY_ID,'E014');
534: END IF;
535:
536: END;
537: ELSIF l_rule = 'R' THEN

Line 604: igs_ad_imp_001.logerrormessage(MILITARY_REC.INTERFACE_MILITARY_ID,'E014');

600: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
601: END IF;
602:
603: IF l_enable_log = 'Y' THEN
604: igs_ad_imp_001.logerrormessage(MILITARY_REC.INTERFACE_MILITARY_ID,'E014');
605: END IF;
606:
607: END;
608: END IF;

Line 769: igs_ad_imp_001.logerrormessage(p_health_insur_rec.interface_immu_dtls_id,p_error_code,'IGS_PE_IMMU_DTL_INT');

765: error_code = p_error_code
766: WHERE interface_immu_dtls_id = p_health_insur_rec.interface_immu_dtls_id;
767:
768: IF l_enable_log = 'Y' THEN
769: igs_ad_imp_001.logerrormessage(p_health_insur_rec.interface_immu_dtls_id,p_error_code,'IGS_PE_IMMU_DTL_INT');
770: END IF;
771:
772: END validate_record_health; -- End of Local Procedure validate_record_health
773:

Line 844: igs_ad_imp_001.logerrormessage(health_insur_rec.INTERFACE_IMMU_DTLS_ID,'E255','IGS_PE_IMMU_DTL_INT');

840:
841: p_status:='3';
842: p_error_code:='E255';
843: IF l_enable_log = 'Y' THEN
844: igs_ad_imp_001.logerrormessage(health_insur_rec.INTERFACE_IMMU_DTLS_ID,'E255','IGS_PE_IMMU_DTL_INT');
845: END IF;
846: ELSE
847: igs_pe_immu_dtls_pkg.INSERT_ROW (
848: x_rowid => l_rowid,

Line 919: igs_ad_imp_001.logerrormessage(health_insur_rec.interface_immu_dtls_id,'E159','IGS_PE_IMMU_DTL_INT');

915: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
916: END IF;
917:
918: IF l_enable_log = 'Y' THEN
919: igs_ad_imp_001.logerrormessage(health_insur_rec.interface_immu_dtls_id,'E159','IGS_PE_IMMU_DTL_INT');
920: END IF;
921:
922: END crt_health_ins;
923:

Line 926: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

922: END crt_health_ins;
923:
924: BEGIN
925: -- Initialize variables for logging (as per logging framework)
926: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
927: l_enable_log := igs_ad_imp_001.g_enable_log;
928: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls';
929: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.';
930:

Line 927: l_enable_log := igs_ad_imp_001.g_enable_log;

923:
924: BEGIN
925: -- Initialize variables for logging (as per logging framework)
926: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
927: l_enable_log := igs_ad_imp_001.g_enable_log;
928: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls';
929: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.';
930:
931: -- Pick up all the records in the table for the P_INTERFACE_ID and

Line 949: l_rule := igs_ad_imp_001.find_source_cat_rule(

945: l_debug_str, NULL,
946: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
947: END IF;
948:
949: l_rule := igs_ad_imp_001.find_source_cat_rule(
950: p_source_type_id => P_SOURCE_TYPE_ID,
951: p_category => 'PERSON_HEALTH_INSURANCE');
952:
953: -- If rule is E or I, then if the match_ind is not null, the combination is invalid

Line 1088: igs_ad_imp_001.logerrormessage(pe_health_rec.interface_immu_dtls_id,'E255','IGS_PE_IMMU_DTL_INT');

1084: p_attribute20 =>pe_health_rec.attribute20 ,
1085: p_desc_flex_name =>'IGS_PE_IMMU_DTLS_FLEX' ) THEN
1086:
1087: IF l_enable_log = 'Y' THEN
1088: igs_ad_imp_001.logerrormessage(pe_health_rec.interface_immu_dtls_id,'E255','IGS_PE_IMMU_DTL_INT');
1089: END IF;
1090:
1091: UPDATE igs_pe_immu_dtl_int
1092: SET ERROR_CODE ='E255',

Line 1167: igs_ad_imp_001.logerrormessage(pe_health_rec.interface_immu_dtls_id,l_error_code,'IGS_PE_IMMU_DTL_INT');

1163: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1164: END IF;
1165:
1166: IF l_enable_log = 'Y' THEN
1167: igs_ad_imp_001.logerrormessage(pe_health_rec.interface_immu_dtls_id,l_error_code,'IGS_PE_IMMU_DTL_INT');
1168: END IF;
1169:
1170: END;
1171: END IF;

Line 1204: igs_ad_imp_001.logerrormessage(pe_health_rec.INTERFACE_IMMU_DTLS_ID,'E255','IGS_PE_IMMU_DTL_INT');

1200: p_attribute20 =>pe_health_rec.attribute20 ,
1201: p_desc_flex_name =>'IGS_PE_IMMU_DTLS_FLEX' ) THEN
1202:
1203: IF l_enable_log = 'Y' THEN
1204: igs_ad_imp_001.logerrormessage(pe_health_rec.INTERFACE_IMMU_DTLS_ID,'E255','IGS_PE_IMMU_DTL_INT');
1205: END IF;
1206:
1207: UPDATE igs_pe_immu_dtl_int
1208: SET ERROR_CODE ='E255',

Line 1281: igs_ad_imp_001.logerrormessage(pe_health_rec.interface_immu_dtls_id,l_error_code,'IGS_PE_IMMU_DTL_INT');

1277: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1278: END IF;
1279:
1280: IF l_enable_log = 'Y' THEN
1281: igs_ad_imp_001.logerrormessage(pe_health_rec.interface_immu_dtls_id,l_error_code,'IGS_PE_IMMU_DTL_INT');
1282: END IF;
1283: END;
1284: END IF; -- if error_code = null (of validate record)
1285: END IF; -- pe_health_rec.MATCH_IND check

Line 1435: igs_ad_imp_001.logerrormessage(HLTH_INS_REC.Interface_hlth_Id,'E322','IGS_AD_HLTH_INS_INT_ALL');

1431: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1432: END IF;
1433:
1434: IF l_enable_log = 'Y' THEN
1435: igs_ad_imp_001.logerrormessage(HLTH_INS_REC.Interface_hlth_Id,'E322','IGS_AD_HLTH_INS_INT_ALL');
1436: END IF;
1437:
1438: END Crt_Pe_hlth_ins;
1439:

Line 1515: igs_ad_imp_001.logerrormessage(hlth_ins_rec.Interface_hlth_Id,p_error_code,'IGS_AD_HLTH_INS_INT_ALL');

1511: status = '3'
1512: WHERE interface_hlth_id = hlth_ins_rec.interface_hlth_id;
1513:
1514: IF l_enable_log = 'Y' THEN
1515: igs_ad_imp_001.logerrormessage(hlth_ins_rec.Interface_hlth_Id,p_error_code,'IGS_AD_HLTH_INS_INT_ALL');
1516: END IF;
1517:
1518: l_check := 'TRUE';
1519: END;

Line 1522: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

1518: l_check := 'TRUE';
1519: END;
1520:
1521: BEGIN
1522: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1523: l_enable_log := igs_ad_imp_001.g_enable_log;
1524: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls';
1525: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.';
1526:

Line 1523: l_enable_log := igs_ad_imp_001.g_enable_log;

1519: END;
1520:
1521: BEGIN
1522: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1523: l_enable_log := igs_ad_imp_001.g_enable_log;
1524: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls';
1525: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.';
1526:
1527: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 1542: l_rule := Igs_Ad_Imp_001.FIND_SOURCE_CAT_RULE(p_source_type_id, 'PERSON_HEALTH_INSURANCE');

1538: l_debug_str, NULL,
1539: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1540: END IF;
1541:
1542: l_rule := Igs_Ad_Imp_001.FIND_SOURCE_CAT_RULE(p_source_type_id, 'PERSON_HEALTH_INSURANCE');
1543:
1544: -- If rule is E or I, then if the match_ind is not null, the combination is invalid
1545: IF l_rule IN ('E','I') THEN
1546: UPDATE igs_ad_hlth_ins_int_all

Line 1749: igs_ad_imp_001.logerrormessage(hlth_ins_rec.INTERFACE_HLTH_ID,'E014','IGS_AD_HLTH_INS_INT_ALL');

1745: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1746: END IF;
1747:
1748: IF l_enable_log = 'Y' THEN
1749: igs_ad_imp_001.logerrormessage(hlth_ins_rec.INTERFACE_HLTH_ID,'E014','IGS_AD_HLTH_INS_INT_ALL');
1750: END IF;
1751:
1752:
1753: END;

Line 1818: igs_ad_imp_001.logerrormessage(hlth_ins_rec.INTERFACE_HLTH_ID,'E014','IGS_AD_HLTH_INS_INT_ALL');

1814: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1815: END IF;
1816:
1817: IF l_enable_log = 'Y' THEN
1818: igs_ad_imp_001.logerrormessage(hlth_ins_rec.INTERFACE_HLTH_ID,'E014','IGS_AD_HLTH_INS_INT_ALL');
1819: END IF;
1820: END;
1821: END IF; -- if match_ind
1822: END IF; -- if rule

Line 2076: igs_ad_imp_001.logerrormessage(p_api_rec.Interface_api_Id,l_error_code);

2072: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2073: END IF;
2074:
2075: IF l_enable_log = 'Y' THEN
2076: igs_ad_imp_001.logerrormessage(p_api_rec.Interface_api_Id,l_error_code);
2077: END IF;
2078:
2079: RETURN FALSE;
2080: END validate_api;

Line 2197: igs_ad_imp_001.logerrormessage(p_api_rec.interface_api_id,p_error_code);

2193: l_debug_str, NULL,
2194: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2195: END IF;
2196: IF l_enable_log = 'Y' THEN
2197: igs_ad_imp_001.logerrormessage(p_api_rec.interface_api_id,p_error_code);
2198: END IF;
2199:
2200: END crt_person_id_types;
2201:

Line 2204: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

2200: END crt_person_id_types;
2201:
2202:
2203: BEGIN
2204: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
2205: l_enable_log := igs_ad_imp_001.g_enable_log;
2206: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types';
2207: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types.';
2208:

Line 2205: l_enable_log := igs_ad_imp_001.g_enable_log;

2201:
2202:
2203: BEGIN
2204: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
2205: l_enable_log := igs_ad_imp_001.g_enable_log;
2206: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types';
2207: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types.';
2208:
2209: -- Check whether UCAS user hook needs to be called. It is to be called only for UCAS PER and UCAS APPL source categories.

Line 2222: l_rule := IGS_AD_IMP_001.FIND_SOURCE_CAT_RULE(

2218: IF ((l_source_type_id1 = p_source_type_id) OR (l_source_type_id2 = p_source_type_id ))THEN
2219: l_call_ucas_user_hook := TRUE;
2220: END IF;
2221:
2222: l_rule := IGS_AD_IMP_001.FIND_SOURCE_CAT_RULE(
2223: P_SOURCE_TYPE_ID => P_SOURCE_TYPE_ID,
2224: P_CATEGORY => 'PERSON_ID_TYPES');
2225:
2226: -- If rule is E or I, then if the match_ind is not null, the combination is invalid

Line 2473: igs_ad_imp_001.logerrormessage(api_rec.interface_api_id,l_error_code);

2469: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2470: END IF;
2471:
2472: IF l_enable_log = 'Y' THEN
2473: igs_ad_imp_001.logerrormessage(api_rec.interface_api_id,l_error_code);
2474: END IF;
2475:
2476: UPDATE IGS_AD_API_INT_ALL
2477: SET ERROR_CODE = l_error_code,

Line 2562: igs_ad_imp_001.logerrormessage(api_rec.interface_api_id,l_error_code);

2558: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2559: END IF;
2560:
2561: IF l_enable_log = 'Y' THEN
2562: igs_ad_imp_001.logerrormessage(api_rec.interface_api_id,l_error_code);
2563: END IF;
2564:
2565: UPDATE IGS_AD_API_INT_ALL
2566: SET ERROR_CODE = l_error_code,

Line 2822: igs_ad_imp_001.logerrormessage(pcz_rec.interface_citizenship_id,'E127','IGS_PE_CITIZEN_INT');

2818: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2819: END IF;
2820:
2821: IF l_enable_log = 'Y' THEN
2822: igs_ad_imp_001.logerrormessage(pcz_rec.interface_citizenship_id,'E127','IGS_PE_CITIZEN_INT');
2823: END IF;
2824:
2825: ELSE
2826: status := '1';

Line 2864: igs_ad_imp_001.logerrormessage(pcz_rec.interface_citizenship_id,l_error,'IGS_PE_CITIZEN_INT');

2860: error_code :='E127' ;
2861: END IF;
2862:
2863: IF l_enable_log = 'Y' THEN
2864: igs_ad_imp_001.logerrormessage(pcz_rec.interface_citizenship_id,l_error,'IGS_PE_CITIZEN_INT');
2865: END IF;
2866:
2867: UPDATE igs_pe_citizen_int
2868: SET error_code = l_error, status ='3'

Line 3070: igs_ad_imp_001.logerrormessage(pcz_rec.interface_citizenship_id,'E128','IGS_PE_CITIZEN_INT');

3066: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3067: END IF;
3068:
3069: IF l_enable_log = 'Y' THEN
3070: igs_ad_imp_001.logerrormessage(pcz_rec.interface_citizenship_id,'E128','IGS_PE_CITIZEN_INT');
3071: END IF;
3072:
3073: ELSE
3074: status := '1';

Line 3106: igs_ad_imp_001.logerrormessage(pcz_rec.interface_citizenship_id,l_error,'IGS_PE_CITIZEN_INT');

3102: error_Code:= 'E128';
3103: END IF;
3104:
3105: IF l_enable_log = 'Y' THEN
3106: igs_ad_imp_001.logerrormessage(pcz_rec.interface_citizenship_id,l_error,'IGS_PE_CITIZEN_INT');
3107: END IF;
3108:
3109: IF c_valid_country%ISOPEN THEN
3110: CLOSE c_valid_country;

Line 3117: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

3113: END upd_pe_citizenship;
3114: --end local proc for updating existing records based on discrepancy rule
3115:
3116: BEGIN
3117: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
3118: l_enable_log := igs_ad_imp_001.g_enable_log;
3119: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hz_citizenship';
3120: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hz_citizenship.';
3121:

Line 3118: l_enable_log := igs_ad_imp_001.g_enable_log;

3114: --end local proc for updating existing records based on discrepancy rule
3115:
3116: BEGIN
3117: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
3118: l_enable_log := igs_ad_imp_001.g_enable_log;
3119: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hz_citizenship';
3120: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hz_citizenship.';
3121:
3122: l_rule :=igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_INTERNATIONAL_DETAILS');

Line 3122: l_rule :=igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_INTERNATIONAL_DETAILS');

3118: l_enable_log := igs_ad_imp_001.g_enable_log;
3119: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hz_citizenship';
3120: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hz_citizenship.';
3121:
3122: l_rule :=igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_INTERNATIONAL_DETAILS');
3123:
3124: l_default_date := igs_ge_date.igsdate('9999/01/01');
3125:
3126: --1. If rule is E or I, then if the match_ind is not null, the combination is invalid

Line 3375: igs_ad_imp_001.logerrormessage(pfs_rec.interface_fund_source_id,'E133','IGS_PE_FUND_SRC_INT');

3371: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3372: END IF;
3373:
3374: IF l_enable_log = 'Y' THEN
3375: igs_ad_imp_001.logerrormessage(pfs_rec.interface_fund_source_id,'E133','IGS_PE_FUND_SRC_INT');
3376: END IF;
3377:
3378: END crt_pe_fund_source; -- end local proc to create new record
3379:

Line 3454: igs_ad_imp_001.logerrormessage(pfs_rec.interface_fund_source_id,l_error,'IGS_PE_FUND_SRC_INT');

3450: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3451: END IF;
3452:
3453: IF l_enable_log = 'Y' THEN
3454: igs_ad_imp_001.logerrormessage(pfs_rec.interface_fund_source_id,l_error,'IGS_PE_FUND_SRC_INT');
3455: END IF;
3456: RETURN FALSE ;
3457:
3458: END Validate_Record; -- End Local function Validate_Record

Line 3462: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

3458: END Validate_Record; -- End Local function Validate_Record
3459:
3460: -- start the main processing from HERE.
3461: BEGIN -- Start the prc_pe_fund_source Now.
3462: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
3463: l_enable_log := igs_ad_imp_001.g_enable_log;
3464: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_fund_source';
3465: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_fund_source.';
3466:

Line 3463: l_enable_log := igs_ad_imp_001.g_enable_log;

3459:
3460: -- start the main processing from HERE.
3461: BEGIN -- Start the prc_pe_fund_source Now.
3462: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
3463: l_enable_log := igs_ad_imp_001.g_enable_log;
3464: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_fund_source';
3465: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_fund_source.';
3466:
3467: -- Logic of Fund Source is different.