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_011

Line 1: PACKAGE BODY igs_ad_imp_011 AS

1: PACKAGE BODY igs_ad_imp_011 AS
2: /* $Header: IGSAD89B.pls 120.5 2006/09/21 08:57:53 gmaheswa ship $ */
3:
4: /*
5: || Created By :

Line 190: l_label := 'igs.plsql.igs_ad_imp_011.crt_apcnt_acad_hnr.begin';

186: IF (l_request_id IS NULL) THEN
187: l_request_id := fnd_global.conc_request_id;
188: END IF;
189:
190: l_label := 'igs.plsql.igs_ad_imp_011.crt_apcnt_acad_hnr.begin';
191: l_debug_str := 'start of proc crt_apcnt_acad_hnr';
192:
193: fnd_log.string_with_context( fnd_log.level_procedure,
194: l_label,

Line 229: l_label := 'igs.plsql.igs_ad_imp_011.crt_apcnt_acad_hnr.exception'||l_error_code;

225: IF (l_request_id IS NULL) THEN
226: l_request_id := fnd_global.conc_request_id;
227: END IF;
228:
229: l_label := 'igs.plsql.igs_ad_imp_011.crt_apcnt_acad_hnr.exception'||l_error_code;
230:
231: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS.CRT_APCNT_ACAD_HNR ' ||
232: 'STATUS : 3' || 'ERRORCODE : E322 SQLERRM:' || SQLERRM;
233:

Line 231: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS.CRT_APCNT_ACAD_HNR ' ||

227: END IF;
228:
229: l_label := 'igs.plsql.igs_ad_imp_011.crt_apcnt_acad_hnr.exception'||l_error_code;
230:
231: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS.CRT_APCNT_ACAD_HNR ' ||
232: 'STATUS : 3' || 'ERRORCODE : E322 SQLERRM:' || SQLERRM;
233:
234: fnd_log.string_with_context( fnd_log.level_exception,
235: l_label,

Line 252: l_prog_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls';

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: --
256: -- dld ref 2. Put them in a record called ACADHONOR_REC.

Line 253: l_label := 'igs.plsql.igs_ad_imp_011.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: --
256: -- dld ref 2. Put them in a record called ACADHONOR_REC.
257: --

Line 416: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.exception_update1'||'E014';

412: IF (l_request_id IS NULL) THEN
413: l_request_id := fnd_global.conc_request_id;
414: END IF;
415:
416: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.exception_update1'||'E014';
417:
418: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS ' ||
419: 'INTERFACE ACADHONOR ID : ' || (acadhonor_rec.interface_acadhonor_id) ||
420: 'STATUS : 3' || 'ERRORCODE : E014 SQLERRM:' || SQLERRM;

Line 418: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS ' ||

414: END IF;
415:
416: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.exception_update1'||'E014';
417:
418: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS ' ||
419: 'INTERFACE ACADHONOR ID : ' || (acadhonor_rec.interface_acadhonor_id) ||
420: 'STATUS : 3' || 'ERRORCODE : E014 SQLERRM:' || SQLERRM;
421:
422: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

Line 471: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.exception_update2'||'E014';

467: IF (l_request_id IS NULL) THEN
468: l_request_id := fnd_global.conc_request_id;
469: END IF;
470:
471: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.exception_update2'||'E014';
472:
473: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS ' ||
474: 'INTERFACE ACADHONOR ID : ' || (acadhonor_rec.interface_acadhonor_id) ||
475: 'STATUS : 3' || 'ERRORCODE : E014 SQLERRM:' || SQLERRM;

Line 473: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS ' ||

469: END IF;
470:
471: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.exception_update2'||'E014';
472:
473: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS ' ||
474: 'INTERFACE ACADHONOR ID : ' || (acadhonor_rec.interface_acadhonor_id) ||
475: 'STATUS : 3' || 'ERRORCODE : E014 SQLERRM:' || SQLERRM;
476:
477: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

Line 538: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.exception'||'E518';

534: IF (l_request_id IS NULL) THEN
535: l_request_id := fnd_global.conc_request_id;
536: END IF;
537:
538: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.exception'||'E518';
539:
540: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS ' ||
541: 'INTERFACE ACADHONOR ID : ' || (acadhonor_rec.interface_acadhonor_id) ||
542: 'STATUS : 3' || 'ERRORCODE : E518 SQLERRM:' || SQLERRM;

Line 540: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS ' ||

536: END IF;
537:
538: l_label := 'igs.plsql.igs_ad_imp_011.prc_apcnt_acadhnr_dtls.exception'||'E518';
539:
540: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS ' ||
541: 'INTERFACE ACADHONOR ID : ' || (acadhonor_rec.interface_acadhonor_id) ||
542: 'STATUS : 3' || 'ERRORCODE : E518 SQLERRM:' || SQLERRM;
543:
544: fnd_log.string_with_context( fnd_log.level_exception,

Line 767: l_label := 'igs.plsql.igs_ad_imp_011.crt_res_dtls.begin';

763: IF (l_request_id IS NULL) THEN
764: l_request_id := fnd_global.conc_request_id;
765: END IF;
766:
767: l_label := 'igs.plsql.igs_ad_imp_011.crt_res_dtls.begin';
768: l_debug_str := 'Interface Res Id : ' || res_dtl_rec.interface_res_id;
769:
770: fnd_log.string_with_context( fnd_log.level_procedure,
771: l_label,

Line 833: l_label := 'igs.plsql.igs_ad_imp_011.crt_apcnt_acad_hnr.exception'||'E322';

829: IF (l_request_id IS NULL) THEN
830: l_request_id := fnd_global.conc_request_id;
831: END IF;
832:
833: l_label := 'igs.plsql.igs_ad_imp_011.crt_apcnt_acad_hnr.exception'||'E322';
834:
835: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS.CRT_APCNT_ACAD_HNR ' ||
836: 'STATUS : 3' || 'ERRORCODE : E322 SQLERRM:' || SQLERRM;
837:

Line 835: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS.CRT_APCNT_ACAD_HNR ' ||

831: END IF;
832:
833: l_label := 'igs.plsql.igs_ad_imp_011.crt_apcnt_acad_hnr.exception'||'E322';
834:
835: l_debug_str := 'IGS_AD_IMP_011.PRC_APCNT_ACADHNR_DTLS.CRT_APCNT_ACAD_HNR ' ||
836: 'STATUS : 3' || 'ERRORCODE : E322 SQLERRM:' || SQLERRM;
837:
838: fnd_log.string_with_context( fnd_log.level_exception,
839: l_label,

Line 907: l_label := 'igs.plsql.igs_ad_imp_011.update_res.exception'||'E014';

903: IF (l_request_id IS NULL) THEN
904: l_request_id := fnd_global.conc_request_id;
905: END IF;
906:
907: l_label := 'igs.plsql.igs_ad_imp_011.update_res.exception'||'E014';
908: l_debug_str := 'IGS_AD_IMP_011.PRC_PE_RES_DTLS.UPDATE_RES ' ||
909: 'STATUS : 3' || 'ERROR CODE : E014 SQLERRM:' || SQLERRM;
910:
911: fnd_log.string_with_context( fnd_log.level_exception,

Line 908: l_debug_str := 'IGS_AD_IMP_011.PRC_PE_RES_DTLS.UPDATE_RES ' ||

904: l_request_id := fnd_global.conc_request_id;
905: END IF;
906:
907: l_label := 'igs.plsql.igs_ad_imp_011.update_res.exception'||'E014';
908: l_debug_str := 'IGS_AD_IMP_011.PRC_PE_RES_DTLS.UPDATE_RES ' ||
909: 'STATUS : 3' || 'ERROR CODE : E014 SQLERRM:' || SQLERRM;
910:
911: fnd_log.string_with_context( fnd_log.level_exception,
912: l_label,

Line 929: l_prog_label := 'igs.plsql.igs_ad_imp_011.prc_pe_res_dtls';

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

Line 930: l_label := 'igs.plsql.igs_ad_imp_011.prc_pe_res_dtls.';

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');
933:
934: -- If rule is E or I, then if the match_ind is not null, the combination is invalid

Line 1124: l_label := 'igs.plsql.igs_ad_imp_011.prc_pe_res_dtls.exception'||'E518';

1120: IF (l_request_id IS NULL) THEN
1121: l_request_id := fnd_global.conc_request_id;
1122: END IF;
1123:
1124: l_label := 'igs.plsql.igs_ad_imp_011.prc_pe_res_dtls.exception'||'E518';
1125:
1126: l_debug_str := 'IGS_AD_IMP_011.PRC_PE_RES_DTLS ' ||
1127: 'INTERFACE RES ID : ' || TO_CHAR(res_dtl_rec.interface_res_id) ||
1128: 'STATUS : 3' || 'ERRORCODE : E518 SQLERRM:' || SQLERRM;

Line 1126: l_debug_str := 'IGS_AD_IMP_011.PRC_PE_RES_DTLS ' ||

1122: END IF;
1123:
1124: l_label := 'igs.plsql.igs_ad_imp_011.prc_pe_res_dtls.exception'||'E518';
1125:
1126: l_debug_str := 'IGS_AD_IMP_011.PRC_PE_RES_DTLS ' ||
1127: 'INTERFACE RES ID : ' || TO_CHAR(res_dtl_rec.interface_res_id) ||
1128: 'STATUS : 3' || 'ERRORCODE : E518 SQLERRM:' || SQLERRM;
1129:
1130: fnd_log.string_with_context( fnd_log.level_exception,

Line 1658: l_label := 'igs.plsql.igs_ad_imp_011.create_disability.begin';

1654: IF (l_request_id IS NULL) THEN
1655: l_request_id := fnd_global.conc_request_id;
1656: END IF;
1657:
1658: l_label := 'igs.plsql.igs_ad_imp_011.create_disability.begin';
1659: l_debug_str := 'Interface Disability Id : ' || p_disability_rec.interface_disablty_id;
1660:
1661: fnd_log.string_with_context( fnd_log.level_procedure,
1662: l_label,

Line 1741: l_label := 'igs.plsql.igs_ad_imp_011.create_disability.exception'||'E145';

1737: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1738: IF (l_request_id IS NULL) THEN
1739: l_request_id := fnd_global.conc_request_id;
1740: END IF;
1741: l_label := 'igs.plsql.igs_ad_imp_011.create_disability.exception'||'E145';
1742: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_Disability '||'Unhandled Exception'
1743: ||' for INTERFACE DISABLTY ID :'|| p_disability_rec.interface_disablty_id|| ' Status : 3'||
1744: ' ErrorCode :'|| p_error_code||' SQLERRM :'|| SQLERRM;
1745: fnd_log.string_with_context( fnd_log.level_exception,

Line 1742: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_Disability '||'Unhandled Exception'

1738: IF (l_request_id IS NULL) THEN
1739: l_request_id := fnd_global.conc_request_id;
1740: END IF;
1741: l_label := 'igs.plsql.igs_ad_imp_011.create_disability.exception'||'E145';
1742: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_Disability '||'Unhandled Exception'
1743: ||' for INTERFACE DISABLTY ID :'|| p_disability_rec.interface_disablty_id|| ' Status : 3'||
1744: ' ErrorCode :'|| p_error_code||' SQLERRM :'|| SQLERRM;
1745: fnd_log.string_with_context( fnd_log.level_exception,
1746: l_label,

Line 1758: l_label := 'igs.plsql.igs_ad_imp_011.create_disability.exception'||p_error_code;

1754: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1755: IF (l_request_id IS NULL) THEN
1756: l_request_id := fnd_global.conc_request_id;
1757: END IF;
1758: l_label := 'igs.plsql.igs_ad_imp_011.create_disability.exception'||p_error_code;
1759: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_Disability '||'Ovelapping records exist'
1760: ||' for INTERFACE DISABLTY ID :'|| p_disability_rec.interface_disablty_id|| ' Status : 3'
1761: || ' ErrorCode :'|| p_error_code|| SQLERRM;
1762: fnd_log.string_with_context( fnd_log.level_exception,

Line 1759: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_Disability '||'Ovelapping records exist'

1755: IF (l_request_id IS NULL) THEN
1756: l_request_id := fnd_global.conc_request_id;
1757: END IF;
1758: l_label := 'igs.plsql.igs_ad_imp_011.create_disability.exception'||p_error_code;
1759: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_Disability '||'Ovelapping records exist'
1760: ||' for INTERFACE DISABLTY ID :'|| p_disability_rec.interface_disablty_id|| ' Status : 3'
1761: || ' ErrorCode :'|| p_error_code|| SQLERRM;
1762: fnd_log.string_with_context( fnd_log.level_exception,
1763: l_label,

Line 1864: l_label := 'igs.plsql.igs_ad_imp_011.update_disability.exception'||l_error_code;

1860: IF (l_request_id IS NULL) THEN
1861: l_request_id := fnd_global.conc_request_id;
1862: END IF;
1863:
1864: l_label := 'igs.plsql.igs_ad_imp_011.update_disability.exception'||l_error_code;
1865:
1866: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.update_disability '||'Unhandled Exception'
1867: ||' for INTERFACE DISABLTY ID :'
1868: || p_disability_rec.interface_disablty_id|| ' Status : 3'|| ' ErrorCode :' ||

Line 1866: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.update_disability '||'Unhandled Exception'

1862: END IF;
1863:
1864: l_label := 'igs.plsql.igs_ad_imp_011.update_disability.exception'||l_error_code;
1865:
1866: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.update_disability '||'Unhandled Exception'
1867: ||' for INTERFACE DISABLTY ID :'
1868: || p_disability_rec.interface_disablty_id|| ' Status : 3'|| ' ErrorCode :' ||
1869: l_error_code||' SQLERRM: '|| SQLERRM;
1870:

Line 1888: l_label := 'igs.plsql.igs_ad_imp_011.update_disability.exception'||l_error_code;

1884: IF (l_request_id IS NULL) THEN
1885: l_request_id := fnd_global.conc_request_id;
1886: END IF;
1887:
1888: l_label := 'igs.plsql.igs_ad_imp_011.update_disability.exception'||l_error_code;
1889:
1890: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.update_disability '||
1891: ' for INTERFACE DISABLTY ID :'
1892: || p_disability_rec.interface_disablty_id|| ' Status : 3'||

Line 1890: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.update_disability '||

1886: END IF;
1887:
1888: l_label := 'igs.plsql.igs_ad_imp_011.update_disability.exception'||l_error_code;
1889:
1890: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.update_disability '||
1891: ' for INTERFACE DISABLTY ID :'
1892: || p_disability_rec.interface_disablty_id|| ' Status : 3'||
1893: ' ErrorCode :' || l_error_code ||' SQLERRM:'|| SQLERRM;
1894:

Line 1941: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_service.begin';

1937: IF (l_request_id IS NULL) THEN
1938: l_request_id := fnd_global.conc_request_id;
1939: END IF;
1940:
1941: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_service.begin';
1942: l_debug_str := 'Interface sn service Id : ' || p_sn_service_rec.interface_sn_service_id;
1943:
1944: fnd_log.string_with_context( fnd_log.level_procedure,
1945: l_label,

Line 1992: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_service.exception'||l_error_code;

1988: IF (l_request_id IS NULL) THEN
1989: l_request_id := fnd_global.conc_request_id;
1990: END IF;
1991:
1992: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_service.exception'||l_error_code;
1993:
1994: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_SN_Service '
1995: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.insert_row'
1996: ||' for INTERFACE SN SERVICE ID :'

Line 1994: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_SN_Service '

1990: END IF;
1991:
1992: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_service.exception'||l_error_code;
1993:
1994: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_SN_Service '
1995: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.insert_row'
1996: ||' for INTERFACE SN SERVICE ID :'
1997: || p_sn_service_rec.interface_sn_service_id
1998: || ' Status : 3'

Line 2046: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_contact.begin';

2042: IF (l_request_id IS NULL) THEN
2043: l_request_id := fnd_global.conc_request_id;
2044: END IF;
2045:
2046: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_contact.begin';
2047: l_debug_str := 'Interface sn contact Id : ' || p_sn_contact_rec.interface_sn_contact_id;
2048:
2049: fnd_log.string_with_context( fnd_log.level_procedure,
2050: l_label,

Line 2097: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_contact.exception'||l_error_code;

2093: IF (l_request_id IS NULL) THEN
2094: l_request_id := fnd_global.conc_request_id;
2095: END IF;
2096:
2097: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_contact.exception'||l_error_code;
2098:
2099: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_SN_Contact '
2100: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.insert_row'
2101: ||' for INTERFACE SN CONTACT ID :'

Line 2099: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_SN_Contact '

2095: END IF;
2096:
2097: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_contact.exception'||l_error_code;
2098:
2099: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_SN_Contact '
2100: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.insert_row'
2101: ||' for INTERFACE SN CONTACT ID :'
2102: || p_sn_contact_rec.interface_sn_contact_id
2103: || 'Status : 3'

Line 2151: l_label := 'igs.plsql.igs_ad_imp_011.prcess_sn_service.begin';

2147: IF (l_request_id IS NULL) THEN
2148: l_request_id := fnd_global.conc_request_id;
2149: END IF;
2150:
2151: l_label := 'igs.plsql.igs_ad_imp_011.prcess_sn_service.begin';
2152: l_debug_str := 'Interface sn service Id : ' || sn_service_rec.interface_sn_service_id;
2153:
2154: fnd_log.string_with_context( fnd_log.level_procedure,
2155: l_label,

Line 2302: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_service.exception'||l_error_code;

2298: IF (l_request_id IS NULL) THEN
2299: l_request_id := fnd_global.conc_request_id;
2300: END IF;
2301:
2302: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_service.exception'||l_error_code;
2303:
2304: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Service '
2305: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.update_row'
2306: ||' for INTERFACE SN SERVICE ID :'

Line 2304: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Service '

2300: END IF;
2301:
2302: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_service.exception'||l_error_code;
2303:
2304: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Service '
2305: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.update_row'
2306: ||' for INTERFACE SN SERVICE ID :'
2307: || sn_service_rec.interface_sn_service_id
2308: || ' Status : 3'

Line 2367: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_service.exception'||l_error_code;

2363: IF (l_request_id IS NULL) THEN
2364: l_request_id := fnd_global.conc_request_id;
2365: END IF;
2366:
2367: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_service.exception'||l_error_code;
2368:
2369: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Service '
2370: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.update_row'
2371: ||' for INTERFACE SN SERVICE ID :'

Line 2369: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Service '

2365: END IF;
2366:
2367: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_service.exception'||l_error_code;
2368:
2369: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Service '
2370: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.update_row'
2371: ||' for INTERFACE SN SERVICE ID :'
2372: || sn_service_rec.interface_sn_service_id
2373: || ' Status : 3'

Line 2428: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.begin';

2424: IF (l_request_id IS NULL) THEN
2425: l_request_id := fnd_global.conc_request_id;
2426: END IF;
2427:
2428: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.begin';
2429: l_debug_str := 'Interface Disability Id : ' || p_interface_disability_id;
2430:
2431: fnd_log.string_with_context( fnd_log.level_procedure,
2432: l_label,

Line 2573: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.exception'||l_error_code;

2569: IF (l_request_id IS NULL) THEN
2570: l_request_id := fnd_global.conc_request_id;
2571: END IF;
2572:
2573: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.exception'||l_error_code;
2574:
2575: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Contact '
2576: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.update_row'
2577: ||' for INTERFACE SN CONTACT ID :'

Line 2575: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Contact '

2571: END IF;
2572:
2573: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.exception'||l_error_code;
2574:
2575: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Contact '
2576: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.update_row'
2577: ||' for INTERFACE SN CONTACT ID :'
2578: || sn_contact_rec.interface_sn_contact_id
2579: || ' Status : 3'

Line 2639: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.exception'||l_error_code;

2635: IF (l_request_id IS NULL) THEN
2636: l_request_id := fnd_global.conc_request_id;
2637: END IF;
2638:
2639: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.exception'||l_error_code;
2640:
2641: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Contact '
2642: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.update_row'
2643: ||' for INTERFACE SN CONTACT ID :'

Line 2641: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Contact '

2637: END IF;
2638:
2639: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.exception'||l_error_code;
2640:
2641: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Contact '
2642: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.update_row'
2643: ||' for INTERFACE SN CONTACT ID :'
2644: || sn_contact_rec.interface_sn_contact_id
2645: || ' Status : 3'

Line 2708: l_label := 'igs.plsql.igs_ad_imp_011.process_disability.begin';

2704: IF (l_request_id IS NULL) THEN
2705: l_request_id := fnd_global.conc_request_id;
2706: END IF;
2707:
2708: l_label := 'igs.plsql.igs_ad_imp_011.process_disability.begin';
2709: l_debug_str := 'igs_ad_imp_011.process_disability begin';
2710:
2711: fnd_log.string_with_context( fnd_log.level_procedure,
2712: l_label,

Line 2709: l_debug_str := 'igs_ad_imp_011.process_disability begin';

2705: l_request_id := fnd_global.conc_request_id;
2706: END IF;
2707:
2708: l_label := 'igs.plsql.igs_ad_imp_011.process_disability.begin';
2709: l_debug_str := 'igs_ad_imp_011.process_disability begin';
2710:
2711: fnd_log.string_with_context( fnd_log.level_procedure,
2712: l_label,
2713: l_debug_str, NULL,

Line 3049: l_prog_label := 'igs.plsql.igs_ad_imp_011.prc_special_needs';

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;
3053: END prc_special_needs;

Line 3050: l_label := 'igs.plsql.igs_ad_imp_011.prc_special_needs.';

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;
3053: END prc_special_needs;
3054:

Line 3055: END IGS_AD_IMP_011;

3051:
3052: process_disability;
3053: END prc_special_needs;
3054:
3055: END IGS_AD_IMP_011;