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_007

Line 1: PACKAGE BODY IGS_AD_IMP_007 AS

1: PACKAGE BODY IGS_AD_IMP_007 AS
2: /* $Header: IGSAD85B.pls 120.3 2006/02/01 02:30:00 pfotedar noship $ */
3:
4: /*
5: || Created By :

Line 124: l_label := 'igs.plsql.igs_ad_imp_007.crt_pr_mil.begin';

120: IF (l_request_id IS NULL) THEN
121: l_request_id := fnd_global.conc_request_id;
122: END IF;
123:
124: l_label := 'igs.plsql.igs_ad_imp_007.crt_pr_mil.begin';
125: l_debug_str := 'Interface military Id : ' || MILITARY_REC.Interface_military_Id;
126:
127: fnd_log.string_with_context( fnd_log.level_procedure,
128: l_label,

Line 181: l_label := 'igs.plsql.igs_ad_imp_007.crt_pr_mil.exception';

177: IF (l_request_id IS NULL) THEN
178: l_request_id := fnd_global.conc_request_id;
179: END IF;
180:
181: l_label := 'igs.plsql.igs_ad_imp_007.crt_pr_mil.exception';
182:
183: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_MLTRY_DTLS.crt_pr_mil ' ||
184: 'Interface_military_Id: ' ||military_rec.Interface_military_Id
185: || 'Status : 3' || 'ErrorCode : E322' || SQLERRM;

Line 183: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_MLTRY_DTLS.crt_pr_mil ' ||

179: END IF;
180:
181: l_label := 'igs.plsql.igs_ad_imp_007.crt_pr_mil.exception';
182:
183: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_MLTRY_DTLS.crt_pr_mil ' ||
184: 'Interface_military_Id: ' ||military_rec.Interface_military_Id
185: || 'Status : 3' || 'ErrorCode : E322' || SQLERRM;
186:
187: fnd_log.string_with_context( fnd_log.level_exception,

Line 319: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls';

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:
323:

Line 320: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls.';

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:
323:
324: l_rule :=Igs_Ad_Imp_001.FIND_SOURCE_CAT_RULE(P_SOURCE_TYPE_ID,'PERSON_MILITARY_DETAILS');

Line 520: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls.exception: '|| 'E014';

516: IF (l_request_id IS NULL) THEN
517: l_request_id := fnd_global.conc_request_id;
518: END IF;
519:
520: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls.exception: '|| 'E014';
521:
522: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_MLTRY_DTLS ' ||
523: 'Interface Military Id : ' || (MILITARY_REC.INTERFACE_MILITARY_ID)
524: || 'Status : 3' || 'ErrorCode : E014' || SQLERRM;

Line 522: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_MLTRY_DTLS ' ||

518: END IF;
519:
520: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls.exception: '|| 'E014';
521:
522: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_MLTRY_DTLS ' ||
523: 'Interface Military Id : ' || (MILITARY_REC.INTERFACE_MILITARY_ID)
524: || 'Status : 3' || 'ErrorCode : E014' || SQLERRM;
525:
526: fnd_log.string_with_context( fnd_log.level_exception,

Line 591: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls.exception: '|| 'E014';

587: IF (l_request_id IS NULL) THEN
588: l_request_id := fnd_global.conc_request_id;
589: END IF;
590:
591: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls.exception: '|| 'E014';
592:
593: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_MLTRY_DTLS ' ||
594: 'Military Type Cd : ' || MILITARY_REC.MILITARY_TYPE_CD
595: || ' Status : 3 ' || 'ErrorCode : E014' || SQLERRM;

Line 593: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_MLTRY_DTLS ' ||

589: END IF;
590:
591: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_mltry_dtls.exception: '|| 'E014';
592:
593: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_MLTRY_DTLS ' ||
594: 'Military Type Cd : ' || MILITARY_REC.MILITARY_TYPE_CD
595: || ' Status : 3 ' || 'ErrorCode : E014' || SQLERRM;
596:
597: fnd_log.string_with_context( fnd_log.level_exception,

Line 805: l_label := 'igs.plsql.igs_ad_imp_007.crt_health_ins.begin';

801: IF (l_request_id IS NULL) THEN
802: l_request_id := fnd_global.conc_request_id;
803: END IF;
804:
805: l_label := 'igs.plsql.igs_ad_imp_007.crt_health_ins.begin';
806: l_debug_str := 'INTERFACE_IMMU_DTLS_ID:'||health_insur_rec.INTERFACE_IMMU_DTLS_ID;
807:
808: fnd_log.string_with_context( fnd_log.level_procedure,
809: l_label,

Line 904: l_label := 'igs.plsql.igs_ad_imp_007.crt_health_ins.exception';

900: IF (l_request_id IS NULL) THEN
901: l_request_id := fnd_global.conc_request_id;
902: END IF;
903:
904: l_label := 'igs.plsql.igs_ad_imp_007.crt_health_ins.exception';
905:
906: l_debug_str := 'Igs_Ad_Imp_007.PRC_PE_IMMU_DLTS.CRT_HEALTH_INS'
907: || ' Exception from IGS_PE_IMMU_DTLS_PKG.INSERT_ROW '
908: || ' Interface Id : '

Line 906: l_debug_str := 'Igs_Ad_Imp_007.PRC_PE_IMMU_DLTS.CRT_HEALTH_INS'

902: END IF;
903:
904: l_label := 'igs.plsql.igs_ad_imp_007.crt_health_ins.exception';
905:
906: l_debug_str := 'Igs_Ad_Imp_007.PRC_PE_IMMU_DLTS.CRT_HEALTH_INS'
907: || ' Exception from IGS_PE_IMMU_DTLS_PKG.INSERT_ROW '
908: || ' Interface Id : '
909: || (health_insur_rec.interface_immu_dtls_id)
910: || ' Status : 3'|| ' ErrorCode : E159' ||SQLERRM;

Line 928: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls';

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
932: -- store them into a Record variable pe_health_rec.

Line 929: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.';

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
932: -- store them into a Record variable pe_health_rec.
933: -- Perform validations for the columns

Line 940: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.begin';

936: IF (l_request_id IS NULL) THEN
937: l_request_id := fnd_global.conc_request_id;
938: END IF;
939:
940: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.begin';
941: l_debug_str := 'igs_ad_imp_007.prc_pe_immu_dtls.begin';
942:
943: fnd_log.string_with_context( fnd_log.level_procedure,
944: l_label,

Line 941: l_debug_str := 'igs_ad_imp_007.prc_pe_immu_dtls.begin';

937: l_request_id := fnd_global.conc_request_id;
938: END IF;
939:
940: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.begin';
941: l_debug_str := 'igs_ad_imp_007.prc_pe_immu_dtls.begin';
942:
943: fnd_log.string_with_context( fnd_log.level_procedure,
944: l_label,
945: l_debug_str, NULL,

Line 1153: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.exception';

1149: IF (l_request_id IS NULL) THEN
1150: l_request_id := fnd_global.conc_request_id;
1151: END IF;
1152:
1153: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.exception';
1154:
1155: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_IMMU_DTLS'
1156: || 'INTERFACE_IMMU_DTLS_ID : ' ||
1157: pe_health_rec.interface_immu_dtls_id ||

Line 1155: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_IMMU_DTLS'

1151: END IF;
1152:
1153: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.exception';
1154:
1155: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_IMMU_DTLS'
1156: || 'INTERFACE_IMMU_DTLS_ID : ' ||
1157: pe_health_rec.interface_immu_dtls_id ||
1158: 'Status : ' || l_status || 'ErrorCode : ' || l_error_code || SQLERRM;
1159:

Line 1267: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.exception: '|| l_error_code;

1263: IF (l_request_id IS NULL) THEN
1264: l_request_id := fnd_global.conc_request_id;
1265: END IF;
1266:
1267: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.exception: '|| l_error_code;
1268:
1269: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_IMMU_DTLS'
1270: || 'INTERFACE_IMMU_DTLS_ID : ' ||
1271: IGS_GE_NUMBER.TO_CANN(pe_health_rec.interface_immu_dtls_id) ||

Line 1269: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_IMMU_DTLS'

1265: END IF;
1266:
1267: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_immu_dtls.exception: '|| l_error_code;
1268:
1269: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_IMMU_DTLS'
1270: || 'INTERFACE_IMMU_DTLS_ID : ' ||
1271: IGS_GE_NUMBER.TO_CANN(pe_health_rec.interface_immu_dtls_id) ||
1272: 'Status : ' || l_status || 'ErrorCode : ' || l_error_code || SQLERRM;
1273:

Line 1364: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_hlth_ins.begin';

1360: IF (l_request_id IS NULL) THEN
1361: l_request_id := fnd_global.conc_request_id;
1362: END IF;
1363:
1364: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_hlth_ins.begin';
1365: l_debug_str := 'Interface_hlth_Id: '||(hlth_ins_rec.Interface_hlth_Id);
1366:
1367: fnd_log.string_with_context( fnd_log.level_procedure,
1368: l_label,

Line 1423: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_hlth_ins.exception';

1419: IF (l_request_id IS NULL) THEN
1420: l_request_id := fnd_global.conc_request_id;
1421: END IF;
1422:
1423: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_hlth_ins.exception';
1424:
1425: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_HLTH_INS_DTLS.Crt_Pe_hlth_ins ' ||
1426: 'Status : 3' || 'ErrorCode : E322 insert failed ' || SQLERRM;
1427:

Line 1425: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_HLTH_INS_DTLS.Crt_Pe_hlth_ins ' ||

1421: END IF;
1422:
1423: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_hlth_ins.exception';
1424:
1425: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_HLTH_INS_DTLS.Crt_Pe_hlth_ins ' ||
1426: 'Status : 3' || 'ErrorCode : E322 insert failed ' || SQLERRM;
1427:
1428: fnd_log.string_with_context( fnd_log.level_exception,
1429: l_label,

Line 1524: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls';

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
1528:

Line 1525: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.';

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
1528:
1529: IF (l_request_id IS NULL) THEN

Line 1533: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.begin';

1529: IF (l_request_id IS NULL) THEN
1530: l_request_id := fnd_global.conc_request_id;
1531: END IF;
1532:
1533: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.begin';
1534: l_debug_str := 'igs_ad_imp_007.prc_pe_hlth_ins_dtls.begin';
1535:
1536: fnd_log.string_with_context( fnd_log.level_procedure,
1537: l_label,

Line 1534: l_debug_str := 'igs_ad_imp_007.prc_pe_hlth_ins_dtls.begin';

1530: l_request_id := fnd_global.conc_request_id;
1531: END IF;
1532:
1533: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.begin';
1534: l_debug_str := 'igs_ad_imp_007.prc_pe_hlth_ins_dtls.begin';
1535:
1536: fnd_log.string_with_context( fnd_log.level_procedure,
1537: l_label,
1538: l_debug_str, NULL,

Line 1736: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.exception1';

1732: IF (l_request_id IS NULL) THEN
1733: l_request_id := fnd_global.conc_request_id;
1734: END IF;
1735:
1736: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.exception1';
1737:
1738: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_HLTH_INS_DTLS ' ||
1739: 'Interface Health Id : ' || hlth_ins_rec.INTERFACE_HLTH_ID ||
1740: ' Status : 3 ' || 'ErrorCode : E014 Update Failed ' || SQLERRM;

Line 1738: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_HLTH_INS_DTLS ' ||

1734: END IF;
1735:
1736: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.exception1';
1737:
1738: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_HLTH_INS_DTLS ' ||
1739: 'Interface Health Id : ' || hlth_ins_rec.INTERFACE_HLTH_ID ||
1740: ' Status : 3 ' || 'ErrorCode : E014 Update Failed ' || SQLERRM;
1741:
1742: fnd_log.string_with_context( fnd_log.level_exception,

Line 1805: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.exception2';

1801: IF (l_request_id IS NULL) THEN
1802: l_request_id := fnd_global.conc_request_id;
1803: END IF;
1804:
1805: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.exception2';
1806:
1807: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_HLTH_INS_DTLS ' ||
1808: 'Interface Health Id : ' || (hlth_ins_rec.INTERFACE_HLTH_ID) ||
1809: 'Status : 3' || 'ErrorCode : E014 update Failed ' || SQLERRM;

Line 1807: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_HLTH_INS_DTLS ' ||

1803: END IF;
1804:
1805: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hlth_ins_dtls.exception2';
1806:
1807: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_HLTH_INS_DTLS ' ||
1808: 'Interface Health Id : ' || (hlth_ins_rec.INTERFACE_HLTH_ID) ||
1809: 'Status : 3' || 'ErrorCode : E014 update Failed ' || SQLERRM;
1810:
1811: fnd_log.string_with_context( fnd_log.level_exception,

Line 2060: l_label := 'igs.plsql.igs_ad_imp_007.validate_api.exception';

2056: IF (l_request_id IS NULL) THEN
2057: l_request_id := fnd_global.conc_request_id;
2058: END IF;
2059:
2060: l_label := 'igs.plsql.igs_ad_imp_007.validate_api.exception';
2061:
2062: l_debug_str := 'Igs_Ad_Imp_007.PRC_PE_ID_TYPES.validate_api '
2063: ||'Validation Failed '
2064: ||'Interface_Api_Id:'

Line 2062: l_debug_str := 'Igs_Ad_Imp_007.PRC_PE_ID_TYPES.validate_api '

2058: END IF;
2059:
2060: l_label := 'igs.plsql.igs_ad_imp_007.validate_api.exception';
2061:
2062: l_debug_str := 'Igs_Ad_Imp_007.PRC_PE_ID_TYPES.validate_api '
2063: ||'Validation Failed '
2064: ||'Interface_Api_Id:'
2065: ||IGS_GE_NUMBER.TO_CANN(p_api_rec.Interface_api_Id)
2066: ||' Status:3 '

Line 2113: l_label := 'igs.plsql.igs_ad_imp_007.crt_person_id_types.begin';

2109: IF (l_request_id IS NULL) THEN
2110: l_request_id := fnd_global.conc_request_id;
2111: END IF;
2112:
2113: l_label := 'igs.plsql.igs_ad_imp_007.crt_person_id_types.begin';
2114: l_debug_str := 'Interface Api Id : '|| p_api_rec.interface_api_id ;
2115:
2116: fnd_log.string_with_context( fnd_log.level_procedure,
2117: l_label,

Line 2185: l_label := 'igs.plsql.igs_ad_imp_007.crt_person_id_types.exception ' || p_error_code;

2181: IF (l_request_id IS NULL) THEN
2182: l_request_id := fnd_global.conc_request_id;
2183: END IF;
2184:
2185: l_label := 'igs.plsql.igs_ad_imp_007.crt_person_id_types.exception ' || p_error_code;
2186:
2187: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_ID_TYPES.crt_person_id_types, Interface Api Id : '
2188: || p_api_rec.interface_api_id ||' Status : '|| p_status || ' ErrorCode : '||
2189: p_error_code|| ' SQLERRM: '||SQLERRM;

Line 2187: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_ID_TYPES.crt_person_id_types, Interface Api Id : '

2183: END IF;
2184:
2185: l_label := 'igs.plsql.igs_ad_imp_007.crt_person_id_types.exception ' || p_error_code;
2186:
2187: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_ID_TYPES.crt_person_id_types, Interface Api Id : '
2188: || p_api_rec.interface_api_id ||' Status : '|| p_status || ' ErrorCode : '||
2189: p_error_code|| ' SQLERRM: '||SQLERRM;
2190:
2191: fnd_log.string_with_context( fnd_log.level_exception,

Line 2206: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types';

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.
2210: OPEN source_type_cur('UCAS PER');

Line 2207: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types.';

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.
2210: OPEN source_type_cur('UCAS PER');
2211: FETCH source_type_cur INTO l_source_type_id1;

Line 2460: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types.exception ' || l_error_code;

2456: IF (l_request_id IS NULL) THEN
2457: l_request_id := fnd_global.conc_request_id;
2458: END IF;
2459:
2460: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types.exception ' || l_error_code;
2461:
2462: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_ID_TYPES ' || 'Interface Api Id : '
2463: || api_rec.interface_api_id || 'SQLERRM '||SQLERRM ||' Status : 3 ' ||
2464: 'ErrorCode : '|| l_error_code;

Line 2462: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_ID_TYPES ' || 'Interface Api Id : '

2458: END IF;
2459:
2460: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types.exception ' || l_error_code;
2461:
2462: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_ID_TYPES ' || 'Interface Api Id : '
2463: || api_rec.interface_api_id || 'SQLERRM '||SQLERRM ||' Status : 3 ' ||
2464: 'ErrorCode : '|| l_error_code;
2465:
2466: fnd_log.string_with_context( fnd_log.level_exception,

Line 2549: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types.exception ' || l_error_code;

2545: IF (l_request_id IS NULL) THEN
2546: l_request_id := fnd_global.conc_request_id;
2547: END IF;
2548:
2549: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types.exception ' || l_error_code;
2550:
2551: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_ID_TYPES ' || 'Interface Api Id : '
2552: || api_rec.interface_api_id || ' SQLERRM '||SQLERRM ||' Status : 3 ' ||
2553: 'ErrorCode : '|| l_error_code;

Line 2551: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_ID_TYPES ' || 'Interface Api Id : '

2547: END IF;
2548:
2549: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_id_types.exception ' || l_error_code;
2550:
2551: l_debug_str := 'IGS_AD_IMP_007.PRC_PE_ID_TYPES ' || 'Interface Api Id : '
2552: || api_rec.interface_api_id || ' SQLERRM '||SQLERRM ||' Status : 3 ' ||
2553: 'ErrorCode : '|| l_error_code;
2554:
2555: fnd_log.string_with_context( fnd_log.level_exception,

Line 2698: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_citizenship.begin';

2694: IF (l_request_id IS NULL) THEN
2695: l_request_id := fnd_global.conc_request_id;
2696: END IF;
2697:
2698: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_citizenship.begin';
2699: l_debug_str := 'Interface Citizen Id : ' ||(pcz_rec.interface_citizenship_id) ;
2700:
2701: fnd_log.string_with_context( fnd_log.level_procedure,
2702: l_label,

Line 2808: l_label := 'igs.plsql.IGS_AD_IMP_007.crt_pe_citizenship.exception: '||'E127';

2804: IF (l_request_id IS NULL) THEN
2805: l_request_id := fnd_global.conc_request_id;
2806: END IF;
2807:
2808: l_label := 'igs.plsql.IGS_AD_IMP_007.crt_pe_citizenship.exception: '||'E127';
2809:
2810: l_debug_str := 'IGS_AD_IMP_007.crt_pe_citizenship Insert into HZ table failed. '
2811: || 'Interface Citizen Id : '
2812: || (pcz_rec.interface_citizenship_id)

Line 2810: l_debug_str := 'IGS_AD_IMP_007.crt_pe_citizenship Insert into HZ table failed. '

2806: END IF;
2807:
2808: l_label := 'igs.plsql.IGS_AD_IMP_007.crt_pe_citizenship.exception: '||'E127';
2809:
2810: l_debug_str := 'IGS_AD_IMP_007.crt_pe_citizenship Insert into HZ table failed. '
2811: || 'Interface Citizen Id : '
2812: || (pcz_rec.interface_citizenship_id)
2813: || 'Status : 3' || 'ErrorCode : E127'|| l_msg_data;
2814:

Line 2848: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_citizenship.exception';

2844: IF (l_request_id IS NULL) THEN
2845: l_request_id := fnd_global.conc_request_id;
2846: END IF;
2847:
2848: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_citizenship.exception';
2849:
2850: l_debug_str := 'IGS_AD_IMP_007.crt_pe_citizenship Create Row failed'
2851: || 'Interface Citizen Id : '
2852: || (pcz_rec.interface_citizenship_id)

Line 2850: l_debug_str := 'IGS_AD_IMP_007.crt_pe_citizenship Create Row failed'

2846: END IF;
2847:
2848: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_citizenship.exception';
2849:
2850: l_debug_str := 'IGS_AD_IMP_007.crt_pe_citizenship Create Row failed'
2851: || 'Interface Citizen Id : '
2852: || (pcz_rec.interface_citizenship_id)
2853: || 'Status : 3' || ' SQLERRM:' || SQLERRM;
2854:

Line 3056: l_label := 'igs.plsql.IGS_AD_IMP_007.upd_pe_citizenship.exception: '||'E128';

3052: IF (l_request_id IS NULL) THEN
3053: l_request_id := fnd_global.conc_request_id;
3054: END IF;
3055:
3056: l_label := 'igs.plsql.IGS_AD_IMP_007.upd_pe_citizenship.exception: '||'E128';
3057:
3058: l_debug_str := 'IGS_AD_IMP_007.upd_pe_citizenship Update into HZ table failed. '
3059: || 'Interface Citizen Id : '
3060: || (pcz_rec.interface_citizenship_id)

Line 3058: l_debug_str := 'IGS_AD_IMP_007.upd_pe_citizenship Update into HZ table failed. '

3054: END IF;
3055:
3056: l_label := 'igs.plsql.IGS_AD_IMP_007.upd_pe_citizenship.exception: '||'E128';
3057:
3058: l_debug_str := 'IGS_AD_IMP_007.upd_pe_citizenship Update into HZ table failed. '
3059: || 'Interface Citizen Id : '
3060: || (pcz_rec.interface_citizenship_id)
3061: || ' Status : 3 ' || 'ErrorCode : E128 msg_data: ' || l_msg_data;
3062:

Line 3090: l_label := 'igs.plsql.igs_ad_imp_007.upd_pe_citizenship.exception';

3086: IF (l_request_id IS NULL) THEN
3087: l_request_id := fnd_global.conc_request_id;
3088: END IF;
3089:
3090: l_label := 'igs.plsql.igs_ad_imp_007.upd_pe_citizenship.exception';
3091:
3092: l_debug_str := 'IGS_AD_IMP_007.upd_pe_citizenship '
3093: || 'Interface Citizen Id : '
3094: || (pcz_rec.interface_citizenship_id)

Line 3092: l_debug_str := 'IGS_AD_IMP_007.upd_pe_citizenship '

3088: END IF;
3089:
3090: l_label := 'igs.plsql.igs_ad_imp_007.upd_pe_citizenship.exception';
3091:
3092: l_debug_str := 'IGS_AD_IMP_007.upd_pe_citizenship '
3093: || 'Interface Citizen Id : '
3094: || (pcz_rec.interface_citizenship_id)
3095: || 'Status : 3' || ' SQLERRM:' || SQLERRM;
3096:

Line 3119: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hz_citizenship';

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');
3123:

Line 3120: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_hz_citizenship.';

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');
3123:
3124: l_default_date := igs_ge_date.igsdate('9999/01/01');

Line 3360: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_fund_source.exception '||'E133';

3356: IF (l_request_id IS NULL) THEN
3357: l_request_id := fnd_global.conc_request_id;
3358: END IF;
3359:
3360: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_fund_source.exception '||'E133';
3361:
3362: l_debug_str := 'IGS_AD_IMP_007.crt_pe_fund_source '
3363: || ' Exception from Igs_Pe_Fund_Source_Pkg.Insert_Row '
3364: || 'Interface Fund Source Id : '

Line 3362: l_debug_str := 'IGS_AD_IMP_007.crt_pe_fund_source '

3358: END IF;
3359:
3360: l_label := 'igs.plsql.igs_ad_imp_007.crt_pe_fund_source.exception '||'E133';
3361:
3362: l_debug_str := 'IGS_AD_IMP_007.crt_pe_fund_source '
3363: || ' Exception from Igs_Pe_Fund_Source_Pkg.Insert_Row '
3364: || 'Interface Fund Source Id : '
3365: || (pfs_rec.interface_fund_source_id)
3366: || 'Status : 3' || 'ErrorCode : E133 SQLERRM:' || SQLERRM;

Line 3441: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_fund_source.exception '||l_error;

3437: IF (l_request_id IS NULL) THEN
3438: l_request_id := fnd_global.conc_request_id;
3439: END IF;
3440:
3441: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_fund_source.exception '||l_error;
3442:
3443: l_debug_str := 'Igs_Ad_Imp_007.prc_pe_fund_source.Validate_Record '
3444: ||' Interface Fund Source Id : ' || (pfs_rec.interface_fund_source_id) ||'Status : 3'
3445: || 'ErrorCode :' || l_error || ' SQLERRM: ' || SQLERRM;

Line 3443: l_debug_str := 'Igs_Ad_Imp_007.prc_pe_fund_source.Validate_Record '

3439: END IF;
3440:
3441: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_fund_source.exception '||l_error;
3442:
3443: l_debug_str := 'Igs_Ad_Imp_007.prc_pe_fund_source.Validate_Record '
3444: ||' Interface Fund Source Id : ' || (pfs_rec.interface_fund_source_id) ||'Status : 3'
3445: || 'ErrorCode :' || l_error || ' SQLERRM: ' || SQLERRM;
3446:
3447: fnd_log.string_with_context( fnd_log.level_exception,

Line 3464: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_fund_source';

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.
3468: -- There will BE DUPLICATE RECORDS, so no check for duplicacy and

Line 3465: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_fund_source.';

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.
3468: -- There will BE DUPLICATE RECORDS, so no check for duplicacy and
3469: -- no check for discrepency rule.

Line 3537: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_intl_dtls';

3533: l_debug_str VARCHAR2(4000);
3534: l_request_id NUMBER(10);
3535:
3536: BEGIN
3537: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_intl_dtls';
3538: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_intl_dtls.';
3539:
3540: -- start the main parent import.
3541: prc_pe_hz_citizenship ( p_source_type_id, p_batch_id) ;

Line 3538: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_intl_dtls.';

3534: l_request_id NUMBER(10);
3535:
3536: BEGIN
3537: l_prog_label := 'igs.plsql.igs_ad_imp_007.prc_pe_intl_dtls';
3538: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_intl_dtls.';
3539:
3540: -- start the main parent import.
3541: prc_pe_hz_citizenship ( p_source_type_id, p_batch_id) ;
3542:

Line 3560: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_int_dtls.exception ';

3556: IF (l_request_id IS NULL) THEN
3557: l_request_id := fnd_global.conc_request_id;
3558: END IF;
3559:
3560: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_int_dtls.exception ';
3561:
3562: l_debug_str := 'Igs_Ad_Imp_007.prc_pe_int_dtls Unhandled Exception'
3563: || ' Source Id : '
3564: || (p_source_type_id)

Line 3562: l_debug_str := 'Igs_Ad_Imp_007.prc_pe_int_dtls Unhandled Exception'

3558: END IF;
3559:
3560: l_label := 'igs.plsql.igs_ad_imp_007.prc_pe_int_dtls.exception ';
3561:
3562: l_debug_str := 'Igs_Ad_Imp_007.prc_pe_int_dtls Unhandled Exception'
3563: || ' Source Id : '
3564: || (p_source_type_id)
3565: || 'Batch Id : ' || IGS_GE_NUMBER.TO_CANN(p_batch_id)|| ' SQLERRM: ' || SQLERRM;
3566:

Line 3576: END IGS_AD_IMP_007;

3572: END prc_pe_intl_dtls ;
3573:
3574:
3575:
3576: END IGS_AD_IMP_007;