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_002 dependencies on IGS_AD_IMP_002

Line 1: PACKAGE BODY Igs_Ad_Imp_002 AS

1: PACKAGE BODY Igs_Ad_Imp_002 AS
2: /* $Header: IGSAD80B.pls 120.21 2006/06/23 05:50:10 gmaheswa ship $ */
3:
4: cst_mi_val_18 CONSTANT VARCHAR2(2) := '18';
5: cst_mi_val_19 CONSTANT VARCHAR2(2) := '19';

Line 46: l_prog_label := 'igs.plsql.igs_ad_imp_002.validate_oss_ext_attr';

42:
43: BEGIN
44:
45: l_enable_log := igs_ad_imp_001.g_enable_log;
46: l_prog_label := 'igs.plsql.igs_ad_imp_002.validate_oss_ext_attr';
47: l_label := 'igs.plsql.igs_ad_imp_002.validate_oss_ext_attr.';
48:
49: IF p_person_rec.PROOF_OF_INS NOT IN ('Y','N') THEN
50: IF l_enable_log = 'Y' THEN

Line 47: l_label := 'igs.plsql.igs_ad_imp_002.validate_oss_ext_attr.';

43: BEGIN
44:
45: l_enable_log := igs_ad_imp_001.g_enable_log;
46: l_prog_label := 'igs.plsql.igs_ad_imp_002.validate_oss_ext_attr';
47: l_label := 'igs.plsql.igs_ad_imp_002.validate_oss_ext_attr.';
48:
49: IF p_person_rec.PROOF_OF_INS NOT IN ('Y','N') THEN
50: IF l_enable_log = 'Y' THEN
51: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E273','IGS_AD_INTERFACE_ALL');

Line 269: l_prog_label := 'igs.plsql.igs_ad_imp_002.create_person';

265: l_preferred_given_name igs_ad_interface_all.PREFERRED_GIVEN_NAME%TYPE;
266: l_felony_convicted_flag VARCHAR2(1);
267: BEGIN
268: l_enable_log := igs_ad_imp_001.g_enable_log;
269: l_prog_label := 'igs.plsql.igs_ad_imp_002.create_person';
270: l_label := 'igs.plsql.igs_ad_imp_002.create_person.';
271: l_rowid := '';
272: l_oss_ext_attr_val := 'Y';
273:

Line 270: l_label := 'igs.plsql.igs_ad_imp_002.create_person.';

266: l_felony_convicted_flag VARCHAR2(1);
267: BEGIN
268: l_enable_log := igs_ad_imp_001.g_enable_log;
269: l_prog_label := 'igs.plsql.igs_ad_imp_002.create_person';
270: l_label := 'igs.plsql.igs_ad_imp_002.create_person.';
271: l_rowid := '';
272: l_oss_ext_attr_val := 'Y';
273:
274: -- Call Log header

Line 281: l_label := 'igs.plsql.igs_ad_imp_002.create_person.begin';

277: IF (l_request_id IS NULL) THEN
278: l_request_id := fnd_global.conc_request_id;
279: END IF;
280:
281: l_label := 'igs.plsql.igs_ad_imp_002.create_person.begin';
282: l_debug_str := 'Interface Id : ' || P_person_rec.INTERFACE_ID;
283:
284: fnd_log.string_with_context( fnd_log.level_procedure,
285: l_label,

Line 546: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||'E322';

542: IF (l_request_id IS NULL) THEN
543: l_request_id := fnd_global.conc_request_id;
544: END IF;
545:
546: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||'E322';
547:
548: l_debug_str := 'Interface ID:'||p_person_rec.interface_id||' Person Creation Failed HZMessage: '||l_msg_data||' SQLERRM:' || SQLERRM;
549:
550: 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 594: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||l_error_code;

590: IF (l_request_id IS NULL) THEN
591: l_request_id := fnd_global.conc_request_id;
592: END IF;
593:
594: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||l_error_code;
595:
596: l_debug_str := 'IGS_AD_IMP_002.Create_Person' || ' Exception from IGS_PE_PERSON_PKG '|| ' Interface Id : ' || (P_person_rec.INTERFACE_ID) ||
597: ' Status : 3' || ' ErrorCode:'||l_error_code||' SQLERRM '|| SQLERRM ;
598:

Line 596: l_debug_str := 'IGS_AD_IMP_002.Create_Person' || ' Exception from IGS_PE_PERSON_PKG '|| ' Interface Id : ' || (P_person_rec.INTERFACE_ID) ||

592: END IF;
593:
594: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||l_error_code;
595:
596: l_debug_str := 'IGS_AD_IMP_002.Create_Person' || ' Exception from IGS_PE_PERSON_PKG '|| ' Interface Id : ' || (P_person_rec.INTERFACE_ID) ||
597: ' Status : 3' || ' ErrorCode:'||l_error_code||' SQLERRM '|| SQLERRM ;
598:
599: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
600: END IF;

Line 825: l_label := 'igs.plsql.IGS_AD_IMP_002.create_person.exception:E005';

821: IF (l_request_id IS NULL) THEN
822: l_request_id := fnd_global.conc_request_id;
823: END IF;
824:
825: l_label := 'igs.plsql.IGS_AD_IMP_002.create_person.exception:E005';
826:
827: l_debug_str := 'IGS_AD_IMP_002.Create_Person ' || 'Error from IGS_PE_STAT_PKG. HzMesg : '
828: || l_msg_data || ' Interface stat ID : ' || stat_rec.interface_stat_id||' Status : 3' || ' ErrorCode : E005';
829:

Line 827: l_debug_str := 'IGS_AD_IMP_002.Create_Person ' || 'Error from IGS_PE_STAT_PKG. HzMesg : '

823: END IF;
824:
825: l_label := 'igs.plsql.IGS_AD_IMP_002.create_person.exception:E005';
826:
827: l_debug_str := 'IGS_AD_IMP_002.Create_Person ' || 'Error from IGS_PE_STAT_PKG. HzMesg : '
828: || l_msg_data || ' Interface stat ID : ' || stat_rec.interface_stat_id||' Status : 3' || ' ErrorCode : E005';
829:
830: fnd_log.string_with_context( fnd_log.level_exception,
831: l_label,

Line 884: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||'E005';

880:
881: IF (l_request_id IS NULL) THEN
882: l_request_id := fnd_global.conc_request_id;
883: END IF;
884: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||'E005';
885:
886: l_debug_str := 'IGS_AD_IMP_002.Create_Person ' || 'Error from IGS_PE_STAT_PKG' || l_msg_data ||
887: ' Interface Stat Id : ' || stat_rec.interface_stat_id
888: || ' Status : 3' || ' ErrorCode: E005 SQLERRM:' || SQLERRM;

Line 886: l_debug_str := 'IGS_AD_IMP_002.Create_Person ' || 'Error from IGS_PE_STAT_PKG' || l_msg_data ||

882: l_request_id := fnd_global.conc_request_id;
883: END IF;
884: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||'E005';
885:
886: l_debug_str := 'IGS_AD_IMP_002.Create_Person ' || 'Error from IGS_PE_STAT_PKG' || l_msg_data ||
887: ' Interface Stat Id : ' || stat_rec.interface_stat_id
888: || ' Status : 3' || ' ErrorCode: E005 SQLERRM:' || SQLERRM;
889:
890: fnd_log.string_with_context( fnd_log.level_exception,

Line 1204: l_prog_label := 'igs.plsql.igs_ad_imp_002.update_person';

1200: l_felony_convicted_flag VARCHAR2(1);
1201: BEGIN
1202:
1203: l_enable_log := igs_ad_imp_001.g_enable_log;
1204: l_prog_label := 'igs.plsql.igs_ad_imp_002.update_person';
1205: l_label := 'igs.plsql.igs_ad_imp_002.update_person.';
1206: l_oss_ext_attr_val := 'Y';
1207:
1208: -- Call Log header

Line 1205: l_label := 'igs.plsql.igs_ad_imp_002.update_person.';

1201: BEGIN
1202:
1203: l_enable_log := igs_ad_imp_001.g_enable_log;
1204: l_prog_label := 'igs.plsql.igs_ad_imp_002.update_person';
1205: l_label := 'igs.plsql.igs_ad_imp_002.update_person.';
1206: l_oss_ext_attr_val := 'Y';
1207:
1208: -- Call Log header
1209: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 1215: l_label := 'igs.plsql.igs_ad_imp_002.update_person.begin';

1211: IF (l_request_id IS NULL) THEN
1212: l_request_id := fnd_global.conc_request_id;
1213: END IF;
1214:
1215: l_label := 'igs.plsql.igs_ad_imp_002.update_person.begin';
1216: l_debug_str := 'Interface Id : ' || P_person_rec.INTERFACE_ID;
1217:
1218: fnd_log.string_with_context( fnd_log.level_procedure,
1219: l_label,

Line 1519: l_label := 'igs.plsql.igs_ad_imp_002.update_person.exception'||l_error_code;

1515: IF (l_request_id IS NULL) THEN
1516: l_request_id := fnd_global.conc_request_id;
1517: END IF;
1518:
1519: l_label := 'igs.plsql.igs_ad_imp_002.update_person.exception'||l_error_code;
1520:
1521: l_debug_str := 'IGS_AD_IMP_002.Update_Person' || ' Exception from IGS_PE_PERSON_PKG ' ||
1522: ' Interface Id : ' || ( P_person_rec.INTERFACE_ID) ||
1523: ' Status : 3' || ' ErrorCode : '||l_error_code||' SQLERRM:' || SQLERRM;

Line 1521: l_debug_str := 'IGS_AD_IMP_002.Update_Person' || ' Exception from IGS_PE_PERSON_PKG ' ||

1517: END IF;
1518:
1519: l_label := 'igs.plsql.igs_ad_imp_002.update_person.exception'||l_error_code;
1520:
1521: l_debug_str := 'IGS_AD_IMP_002.Update_Person' || ' Exception from IGS_PE_PERSON_PKG ' ||
1522: ' Interface Id : ' || ( P_person_rec.INTERFACE_ID) ||
1523: ' Status : 3' || ' ErrorCode : '||l_error_code||' SQLERRM:' || SQLERRM;
1524:
1525: 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 1551: l_label := 'igs.plsql.igs_ad_imp_002.update_person.exception'||'E014';

1547: IF (l_request_id IS NULL) THEN
1548: l_request_id := fnd_global.conc_request_id;
1549: END IF;
1550:
1551: l_label := 'igs.plsql.igs_ad_imp_002.update_person.exception'||'E014';
1552:
1553: l_debug_str := 'IGS_AD_IMP_002.Update_Person ' || 'Error from IGS_PE_PERSON_PKG. HzMesg : ' || l_msg_data ||
1554: ' Interface Id : ' || (P_person_rec.INTERFACE_ID) ||
1555: ' Status : 3' || ' ErrorCode : E014';

Line 1553: l_debug_str := 'IGS_AD_IMP_002.Update_Person ' || 'Error from IGS_PE_PERSON_PKG. HzMesg : ' || l_msg_data ||

1549: END IF;
1550:
1551: l_label := 'igs.plsql.igs_ad_imp_002.update_person.exception'||'E014';
1552:
1553: l_debug_str := 'IGS_AD_IMP_002.Update_Person ' || 'Error from IGS_PE_PERSON_PKG. HzMesg : ' || l_msg_data ||
1554: ' Interface Id : ' || (P_person_rec.INTERFACE_ID) ||
1555: ' Status : 3' || ' ErrorCode : E014';
1556:
1557: fnd_log.string_with_context( fnd_log.level_exception,

Line 1621: l_label := 'igs.plsql.igs_ad_imp_002.update_person.duplicate_address_exists';

1617: IF (l_request_id IS NULL) THEN
1618: l_request_id := fnd_global.conc_request_id;
1619: END IF;
1620:
1621: l_label := 'igs.plsql.igs_ad_imp_002.update_person.duplicate_address_exists';
1622: l_debug_str := 'Interface Id : ' || P_person_rec.INTERFACE_ID;
1623:
1624: fnd_log.string_with_context( fnd_log.level_procedure,
1625: l_label,

Line 1642: l_label := 'igs.plsql.igs_ad_imp_002.update_person.duplicate_address_doesnot_exist';

1638: IF (l_request_id IS NULL) THEN
1639: l_request_id := fnd_global.conc_request_id;
1640: END IF;
1641:
1642: l_label := 'igs.plsql.igs_ad_imp_002.update_person.duplicate_address_doesnot_exist';
1643: l_debug_str := 'Interface Id : ' || P_person_rec.INTERFACE_ID;
1644:
1645: fnd_log.string_with_context( fnd_log.level_procedure,
1646: l_label,

Line 1860: l_label := 'igs.plsql.igs_ad_imp_002.validate_api.exception'||p_error_code;

1856:
1857: IF (l_request_id IS NULL) THEN
1858: l_request_id := fnd_global.conc_request_id;
1859: END IF;
1860: l_label := 'igs.plsql.igs_ad_imp_002.validate_api.exception'||p_error_code;
1861: l_debug_str := 'Igs_Ad_Imp_002.Create_Api.validate_api'
1862: ||'Validation Failed'
1863: ||'Interface_Api_Id:'
1864: ||(p_api_rec.Interface_api_Id)

Line 1861: l_debug_str := 'Igs_Ad_Imp_002.Create_Api.validate_api'

1857: IF (l_request_id IS NULL) THEN
1858: l_request_id := fnd_global.conc_request_id;
1859: END IF;
1860: l_label := 'igs.plsql.igs_ad_imp_002.validate_api.exception'||p_error_code;
1861: l_debug_str := 'Igs_Ad_Imp_002.Create_Api.validate_api'
1862: ||'Validation Failed'
1863: ||'Interface_Api_Id:'
1864: ||(p_api_rec.Interface_api_Id)
1865: ||' Status:3 '

Line 1884: l_prog_label := 'igs.plsql.igs_ad_imp_002.create_api';

1880:
1881: BEGIN
1882:
1883: l_enable_log := igs_ad_imp_001.g_enable_log;
1884: l_prog_label := 'igs.plsql.igs_ad_imp_002.create_api';
1885: l_label := 'igs.plsql.igs_ad_imp_002.create_api.';
1886:
1887: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1888:

Line 1885: l_label := 'igs.plsql.igs_ad_imp_002.create_api.';

1881: BEGIN
1882:
1883: l_enable_log := igs_ad_imp_001.g_enable_log;
1884: l_prog_label := 'igs.plsql.igs_ad_imp_002.create_api';
1885: l_label := 'igs.plsql.igs_ad_imp_002.create_api.';
1886:
1887: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1888:
1889: IF (l_request_id IS NULL) THEN

Line 1893: l_label := 'igs.plsql.igs_ad_imp_002.create_api.begin';

1889: IF (l_request_id IS NULL) THEN
1890: l_request_id := fnd_global.conc_request_id;
1891: END IF;
1892:
1893: l_label := 'igs.plsql.igs_ad_imp_002.create_api.begin';
1894: l_debug_str := 'start of create_api proc';
1895:
1896: fnd_log.string_with_context( fnd_log.level_procedure,
1897: l_label,

Line 2023: l_label := 'igs.plsql.igs_ad_imp_002.create_api.exception'||p_error_code;

2019: IF (l_request_id IS NULL) THEN
2020: l_request_id := fnd_global.conc_request_id;
2021: END IF;
2022:
2023: l_label := 'igs.plsql.igs_ad_imp_002.create_api.exception'||p_error_code;
2024:
2025: l_debug_str := 'IGS_AD_IMP_002.create_api ' ||'Interface Api Id : '
2026: || p_api_rec.interface_api_id ||' Status : 3 '
2027: || 'ErrorCode : '||p_error_code||' SQLERRM:' || SQLERRM;

Line 2025: l_debug_str := 'IGS_AD_IMP_002.create_api ' ||'Interface Api Id : '

2021: END IF;
2022:
2023: l_label := 'igs.plsql.igs_ad_imp_002.create_api.exception'||p_error_code;
2024:
2025: l_debug_str := 'IGS_AD_IMP_002.create_api ' ||'Interface Api Id : '
2026: || p_api_rec.interface_api_id ||' Status : 3 '
2027: || 'ErrorCode : '||p_error_code||' SQLERRM:' || SQLERRM;
2028:
2029: fnd_log.string_with_context( fnd_log.level_exception,

Line 2120: l_label := 'igs.plsql.igs_ad_imp_002.create_api.exception1'||p_error_code;

2116: IF (l_request_id IS NULL) THEN
2117: l_request_id := fnd_global.conc_request_id;
2118: END IF;
2119:
2120: l_label := 'igs.plsql.igs_ad_imp_002.create_api.exception1'||p_error_code;
2121:
2122: l_debug_str := 'IGS_AD_IMP_002.create_api (UPDATE) ' ||'Interface Api Id : '
2123: || p_api_rec.interface_api_id ||'Status : 3'
2124: || 'ErrorCode : '||p_error_code||' SQLERRM:' ||SQLERRM;

Line 2122: l_debug_str := 'IGS_AD_IMP_002.create_api (UPDATE) ' ||'Interface Api Id : '

2118: END IF;
2119:
2120: l_label := 'igs.plsql.igs_ad_imp_002.create_api.exception1'||p_error_code;
2121:
2122: l_debug_str := 'IGS_AD_IMP_002.create_api (UPDATE) ' ||'Interface Api Id : '
2123: || p_api_rec.interface_api_id ||'Status : 3'
2124: || 'ErrorCode : '||p_error_code||' SQLERRM:' ||SQLERRM;
2125:
2126: fnd_log.string_with_context( fnd_log.level_exception,

Line 2214: l_label := 'igs.plsql.igs_ad_imp_002.create_address.process_addrusage_begin';

2210: IF (l_request_id IS NULL) THEN
2211: l_request_id := fnd_global.conc_request_id;
2212: END IF;
2213:
2214: l_label := 'igs.plsql.igs_ad_imp_002.create_address.process_addrusage_begin';
2215: l_debug_str := 'Interface Addr Id : ' || l_interface_addr_id;
2216:
2217: fnd_log.string_with_context( fnd_log.level_procedure,
2218: l_label,

Line 2276: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E224';

2272: IF (l_request_id IS NULL) THEN
2273: l_request_id := fnd_global.conc_request_id;
2274: END IF;
2275:
2276: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E224';
2277:
2278: l_debug_str := 'Interface Address Usage ID: '||c_usage_rec.interface_addrusage_id||' HZMessage: '||l_msg_data||' SQLERRM:' || SQLERRM;
2279:
2280: fnd_log.string_with_context( fnd_log.level_exception,

Line 2340: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E244';

2336: IF (l_request_id IS NULL) THEN
2337: l_request_id := fnd_global.conc_request_id;
2338: END IF;
2339:
2340: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E244';
2341:
2342: l_debug_str := 'IGS_AD_IMP_002.Create_Address.process_addrusage ' ||
2343: 'Error from process_addrusage ' ||
2344: ' for Interface addrusage Id : ' || (l_interface_addrusage_id) ||' '|| SQLERRM ;

Line 2342: l_debug_str := 'IGS_AD_IMP_002.Create_Address.process_addrusage ' ||

2338: END IF;
2339:
2340: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E244';
2341:
2342: l_debug_str := 'IGS_AD_IMP_002.Create_Address.process_addrusage ' ||
2343: 'Error from process_addrusage ' ||
2344: ' for Interface addrusage Id : ' || (l_interface_addrusage_id) ||' '|| SQLERRM ;
2345:
2346: fnd_log.string_with_context( fnd_log.level_exception,

Line 2361: l_prog_label := 'igs.plsql.igs_ad_imp_002.create_address';

2357:
2358: BEGIN
2359:
2360: l_enable_log := igs_ad_imp_001.g_enable_log;
2361: l_prog_label := 'igs.plsql.igs_ad_imp_002.create_address';
2362: l_label := 'igs.plsql.igs_ad_imp_002.create_address.';
2363:
2364: -- Call Log header
2365: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 2362: l_label := 'igs.plsql.igs_ad_imp_002.create_address.';

2358: BEGIN
2359:
2360: l_enable_log := igs_ad_imp_001.g_enable_log;
2361: l_prog_label := 'igs.plsql.igs_ad_imp_002.create_address';
2362: l_label := 'igs.plsql.igs_ad_imp_002.create_address.';
2363:
2364: -- Call Log header
2365: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2366:

Line 2371: l_label := 'igs.plsql.igs_ad_imp_002.create_address.begin';

2367: IF (l_request_id IS NULL) THEN
2368: l_request_id := fnd_global.conc_request_id;
2369: END IF;
2370:
2371: l_label := 'igs.plsql.igs_ad_imp_002.create_address.begin';
2372: l_debug_str := 'Start of create_address proc';
2373:
2374: fnd_log.string_with_context( fnd_log.level_procedure,
2375: l_label,

Line 2441: l_label := 'igs.plsql.igs_ad_imp_002.create_address.exception'||'E006';

2437: IF (l_request_id IS NULL) THEN
2438: l_request_id := fnd_global.conc_request_id;
2439: END IF;
2440:
2441: l_label := 'igs.plsql.igs_ad_imp_002.create_address.exception'||'E006';
2442:
2443: l_debug_str := 'IGS_AD_IMP_002.Create_Address '
2444: || 'Error from IGS_PE_PERSON_ADDR_PKG.INSERT_ROW HzMesg : ' || l_msg_data
2445: || ' Interface Addr Id : ' || p_addr_rec.interface_addr_id

Line 2443: l_debug_str := 'IGS_AD_IMP_002.Create_Address '

2439: END IF;
2440:
2441: l_label := 'igs.plsql.igs_ad_imp_002.create_address.exception'||'E006';
2442:
2443: l_debug_str := 'IGS_AD_IMP_002.Create_Address '
2444: || 'Error from IGS_PE_PERSON_ADDR_PKG.INSERT_ROW HzMesg : ' || l_msg_data
2445: || ' Interface Addr Id : ' || p_addr_rec.interface_addr_id
2446: || ' Status : 3' || ' ErrorCode : E006';
2447:

Line 2470: l_label := 'igs.plsql.igs_ad_imp_002.create_address.warning'||'E073';

2466: IF (l_request_id IS NULL) THEN
2467: l_request_id := fnd_global.conc_request_id;
2468: END IF;
2469:
2470: l_label := 'igs.plsql.igs_ad_imp_002.create_address.warning'||'E073';
2471:
2472: l_debug_str := 'IGS_AD_IMP_002.Create_Address '
2473: || 'Warning from IGS_PE_PERSON_ADDR_PKG.INSERT_ROW HzMesg : ' || l_msg_data
2474: || ' Interface Addr Id : ' || p_addr_rec.interface_addr_id

Line 2472: l_debug_str := 'IGS_AD_IMP_002.Create_Address '

2468: END IF;
2469:
2470: l_label := 'igs.plsql.igs_ad_imp_002.create_address.warning'||'E073';
2471:
2472: l_debug_str := 'IGS_AD_IMP_002.Create_Address '
2473: || 'Warning from IGS_PE_PERSON_ADDR_PKG.INSERT_ROW HzMesg : ' || l_msg_data
2474: || ' Interface Addr Id : ' || p_addr_rec.interface_addr_id
2475: || ' Status : 4' || ' ErrorCode : E073';
2476:

Line 2536: l_label := 'igs.plsql.igs_ad_imp_002.create_address.exception'||'E006';

2532: IF (l_request_id IS NULL) THEN
2533: l_request_id := fnd_global.conc_request_id;
2534: END IF;
2535:
2536: l_label := 'igs.plsql.igs_ad_imp_002.create_address.exception'||'E006';
2537:
2538: l_debug_str := 'IGS_AD_IMP_002.Create_Address '
2539: || 'Error from IGS_PE_PERSON_ADDR_PKG .INSERT_ROW :' || l_msg_data
2540: || ' Interface addr Id : ' || P_addr_REC.INTERFACE_addr_ID

Line 2538: l_debug_str := 'IGS_AD_IMP_002.Create_Address '

2534: END IF;
2535:
2536: l_label := 'igs.plsql.igs_ad_imp_002.create_address.exception'||'E006';
2537:
2538: l_debug_str := 'IGS_AD_IMP_002.Create_Address '
2539: || 'Error from IGS_PE_PERSON_ADDR_PKG .INSERT_ROW :' || l_msg_data
2540: || ' Interface addr Id : ' || P_addr_REC.INTERFACE_addr_ID
2541: || ' Status : 3' || ' ErrorCode : E006';
2542:

Line 2704: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E244';

2700: IF (l_request_id IS NULL) THEN
2701: l_request_id := fnd_global.conc_request_id;
2702: END IF;
2703:
2704: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E244';
2705:
2706: l_debug_str := 'Interface Address Usage ID: '||c_usage_rec.interface_addrusage_id||'HZMess: '||l_msg_data||' SQLERRM: '|| SQLERRM;
2707:
2708: fnd_log.string_with_context( fnd_log.level_exception,

Line 2768: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E244';

2764: IF (l_request_id IS NULL) THEN
2765: l_request_id := fnd_global.conc_request_id;
2766: END IF;
2767:
2768: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E244';
2769:
2770: l_debug_str := 'IGS_AD_IMP_002.Create_Address.process_addrusage ' ||
2771: 'Error from process_addrusage ' ||
2772: ' for Interface addrusage Id : ' || (l_interface_addrusage_id) ||' '|| SQLERRM;

Line 2770: l_debug_str := 'IGS_AD_IMP_002.Create_Address.process_addrusage ' ||

2766: END IF;
2767:
2768: l_label := 'igs.plsql.igs_ad_imp_002.process_addrusage.exception'||'E244';
2769:
2770: l_debug_str := 'IGS_AD_IMP_002.Create_Address.process_addrusage ' ||
2771: 'Error from process_addrusage ' ||
2772: ' for Interface addrusage Id : ' || (l_interface_addrusage_id) ||' '|| SQLERRM;
2773:
2774: fnd_log.string_with_context( fnd_log.level_exception,

Line 2789: l_prog_label := 'igs.plsql.igs_ad_imp_002.update_address';

2785:
2786: BEGIN
2787:
2788: l_enable_log := igs_ad_imp_001.g_enable_log;
2789: l_prog_label := 'igs.plsql.igs_ad_imp_002.update_address';
2790: l_label := 'igs.plsql.igs_ad_imp_002.update_address.';
2791: l_location_id := p_location_id;
2792: l_party_site_id := p_party_site_id;
2793: p_status := '2';

Line 2790: l_label := 'igs.plsql.igs_ad_imp_002.update_address.';

2786: BEGIN
2787:
2788: l_enable_log := igs_ad_imp_001.g_enable_log;
2789: l_prog_label := 'igs.plsql.igs_ad_imp_002.update_address';
2790: l_label := 'igs.plsql.igs_ad_imp_002.update_address.';
2791: l_location_id := p_location_id;
2792: l_party_site_id := p_party_site_id;
2793: p_status := '2';
2794:

Line 2802: l_label := 'igs.plsql.igs_ad_imp_002.Update_Address.begin';

2798: IF (l_request_id IS NULL) THEN
2799: l_request_id := fnd_global.conc_request_id;
2800: END IF;
2801:
2802: l_label := 'igs.plsql.igs_ad_imp_002.Update_Address.begin';
2803: l_debug_str := 'start of update_address';
2804:
2805: fnd_log.string_with_context( fnd_log.level_procedure,
2806: l_label,

Line 2822: l_label := 'igs.plsql.igs_ad_imp_002.validate_address.exception'||p_error_code;

2818: IF (l_request_id IS NULL) THEN
2819: l_request_id := fnd_global.conc_request_id;
2820: END IF;
2821:
2822: l_label := 'igs.plsql.igs_ad_imp_002.validate_address.exception'||p_error_code;
2823:
2824: l_debug_str := 'p_status :'||p_status||'p_error_code :'||p_error_code;
2825:
2826: fnd_log.string_with_context( fnd_log.level_exception,

Line 2904: l_label := 'igs.plsql.igs_ad_imp_002.update_address.exception'||p_error_code;

2900: IF (l_request_id IS NULL) THEN
2901: l_request_id := fnd_global.conc_request_id;
2902: END IF;
2903:
2904: l_label := 'igs.plsql.igs_ad_imp_002.update_address.exception'||p_error_code;
2905:
2906: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Error from IGS_PE_PERSON_ADDRESS_PKG : HzMesg'
2907: || l_msg_data || ' Interface Addr Id : '
2908: || (P_addr_REC.INTERFACE_ADDR_ID) ||' Status : 3' || ' ErrorCode : E014 ';

Line 2906: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Error from IGS_PE_PERSON_ADDRESS_PKG : HzMesg'

2902: END IF;
2903:
2904: l_label := 'igs.plsql.igs_ad_imp_002.update_address.exception'||p_error_code;
2905:
2906: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Error from IGS_PE_PERSON_ADDRESS_PKG : HzMesg'
2907: || l_msg_data || ' Interface Addr Id : '
2908: || (P_addr_REC.INTERFACE_ADDR_ID) ||' Status : 3' || ' ErrorCode : E014 ';
2909:
2910: fnd_log.string_with_context( fnd_log.level_exception,

Line 2931: l_label := 'igs.plsql.igs_ad_imp_002.update_address.warning'||p_error_code;

2927: IF (l_request_id IS NULL) THEN
2928: l_request_id := fnd_global.conc_request_id;
2929: END IF;
2930:
2931: l_label := 'igs.plsql.igs_ad_imp_002.update_address.warning'||p_error_code;
2932:
2933: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Warning from IGS_PE_PERSON_ADDRESS_PKG : HzMesg'
2934: || l_msg_data || ' Interface Addr Id : '
2935: || (P_addr_REC.INTERFACE_ADDR_ID) ||' Status : 4' || ' ErrorCode : E073';

Line 2933: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Warning from IGS_PE_PERSON_ADDRESS_PKG : HzMesg'

2929: END IF;
2930:
2931: l_label := 'igs.plsql.igs_ad_imp_002.update_address.warning'||p_error_code;
2932:
2933: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Warning from IGS_PE_PERSON_ADDRESS_PKG : HzMesg'
2934: || l_msg_data || ' Interface Addr Id : '
2935: || (P_addr_REC.INTERFACE_ADDR_ID) ||' Status : 4' || ' ErrorCode : E073';
2936:
2937: fnd_log.string_with_context( fnd_log.level_exception,

Line 2976: l_label := 'igs.plsql.igs_ad_imp_002.update_address.exception'||'E014';

2972: IF (l_request_id IS NULL) THEN
2973: l_request_id := fnd_global.conc_request_id;
2974: END IF;
2975:
2976: l_label := 'igs.plsql.igs_ad_imp_002.update_address.exception'||'E014';
2977:
2978: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Exception from IGS_PE_PERSON_ADDRESS_PKG : HzMesg '
2979: || l_msg_data || ' Interface Addr Id : '
2980: || (P_addr_REC.INTERFACE_ADDR_ID) || ' Status : 3' ||

Line 2978: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Exception from IGS_PE_PERSON_ADDRESS_PKG : HzMesg '

2974: END IF;
2975:
2976: l_label := 'igs.plsql.igs_ad_imp_002.update_address.exception'||'E014';
2977:
2978: l_debug_str := 'IGS_AD_IMP_002.Update_Address ' || 'Exception from IGS_PE_PERSON_ADDRESS_PKG : HzMesg '
2979: || l_msg_data || ' Interface Addr Id : '
2980: || (P_addr_REC.INTERFACE_ADDR_ID) || ' Status : 3' ||
2981: ' ErrorCode : '||p_error_code;
2982:

Line 3157: l_prog_label := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls';

3153:
3154: BEGIN
3155:
3156: l_enable_log := igs_ad_imp_001.g_enable_log;
3157: l_prog_label := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls';
3158: l_label := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls.';
3159: -- populate global variables
3160: Igs_Pe_Identify_Dups.g_match_set_id := p_match_set_id;
3161: Igs_Pe_Identify_Dups.g_source_type_id := p_d_source_type_id;

Line 3158: l_label := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls.';

3154: BEGIN
3155:
3156: l_enable_log := igs_ad_imp_001.g_enable_log;
3157: l_prog_label := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls';
3158: l_label := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls.';
3159: -- populate global variables
3160: Igs_Pe_Identify_Dups.g_match_set_id := p_match_set_id;
3161: Igs_Pe_Identify_Dups.g_source_type_id := p_d_source_type_id;
3162: l_default_date := TRUNC(SYSDATE);

Line 3646: END Igs_Ad_Imp_002;

3642:
3643: p_status := 3;
3644:
3645: END validate_address;
3646: END Igs_Ad_Imp_002;