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 FND_LOG

Line 275: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

271: l_rowid := '';
272: l_oss_ext_attr_val := 'Y';
273:
274: -- Call Log header
275: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
276:
277: IF (l_request_id IS NULL) THEN
278: l_request_id := fnd_global.conc_request_id;
279: END IF;

Line 284: fnd_log.string_with_context( fnd_log.level_procedure,

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,
286: l_debug_str, NULL,
287: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
288: END IF;

Line 540: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

536: WHERE interface_id = p_person_rec.interface_id;
537:
538: -- Call Log detail
539:
540: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
541:
542: IF (l_request_id IS NULL) THEN
543: l_request_id := fnd_global.conc_request_id;
544: END IF;

Line 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));

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));
551: END IF;
552:
553: IF l_enable_log = 'Y' THEN
554: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E322','IGS_AD_INTERFACE_ALL');

Line 588: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

584: error_code = l_error_code
585: WHERE interface_id = p_person_rec.interface_id;
586:
587: -- Call Log detail
588: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
589:
590: IF (l_request_id IS NULL) THEN
591: l_request_id := fnd_global.conc_request_id;
592: END IF;

Line 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));

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;
601:
602: IF l_enable_log = 'Y' THEN
603: igs_ad_imp_001.logerrormessage(p_person_rec.interface_id,l_error_code,'IGS_AD_INTERFACE_ALL');

Line 819: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

815: error_code = 'E005'
816: WHERE interface_id = p_person_rec.interface_id;
817:
818: -- Call Log detail
819: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
820:
821: IF (l_request_id IS NULL) THEN
822: l_request_id := fnd_global.conc_request_id;
823: END IF;

Line 830: fnd_log.string_with_context( fnd_log.level_exception,

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,
832: l_debug_str, NULL,
833: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
834: END IF;

Line 879: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

875: error_code = 'E005'
876: WHERE interface_id = p_person_rec.interface_id;
877:
878: -- Call Log detail
879: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
880:
881: IF (l_request_id IS NULL) THEN
882: l_request_id := fnd_global.conc_request_id;
883: END IF;

Line 890: fnd_log.string_with_context( fnd_log.level_exception,

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,
891: l_label,
892: l_debug_str, NULL,
893: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
894: END IF;

Line 1209: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

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
1210:
1211: IF (l_request_id IS NULL) THEN
1212: l_request_id := fnd_global.conc_request_id;
1213: END IF;

Line 1218: fnd_log.string_with_context( fnd_log.level_procedure,

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,
1220: l_debug_str, NULL,
1221: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1222: END IF;

Line 1513: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

1509: error_code = l_error_code
1510: WHERE interface_id = p_person_rec.interface_id;
1511:
1512:
1513: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1514: l_msg_data := SQLERRM ; --ssomani, added this 3/15/01
1515: IF (l_request_id IS NULL) THEN
1516: l_request_id := fnd_global.conc_request_id;
1517: END IF;

Line 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));

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));
1526: END IF;
1527:
1528: IF l_enable_log = 'Y' THEN
1529: igs_ad_imp_001.logerrormessage(p_person_rec.interface_id,l_error_code,'IGS_AD_INTERFACE_ALL');

Line 1545: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

1541: SET STATUS = '3',
1542: ERROR_CODE = 'E014'
1543: WHERE INTERFACE_ID = P_person_rec.INTERFACE_ID;
1544:
1545: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1546:
1547: IF (l_request_id IS NULL) THEN
1548: l_request_id := fnd_global.conc_request_id;
1549: END IF;

Line 1557: fnd_log.string_with_context( fnd_log.level_exception,

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,
1558: l_label,
1559: l_debug_str, NULL,
1560: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1561: END IF;

Line 1615: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1611: FETCH check_addr_dup_cur INTO l_location_id,l_party_site_id;
1612: CLOSE check_addr_dup_cur;
1613:
1614: IF l_location_id IS NOT NULL THEN
1615: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1616:
1617: IF (l_request_id IS NULL) THEN
1618: l_request_id := fnd_global.conc_request_id;
1619: END IF;

Line 1624: fnd_log.string_with_context( fnd_log.level_procedure,

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,
1626: l_debug_str, NULL,
1627: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1628: END IF;

Line 1636: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1632: P_LOCATION_ID => l_location_id,
1633: p_party_site_id => l_party_site_id);
1634: ELSE
1635: -- Address not exists. Create it.
1636: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1637:
1638: IF (l_request_id IS NULL) THEN
1639: l_request_id := fnd_global.conc_request_id;
1640: END IF;

Line 1645: fnd_log.string_with_context( fnd_log.level_procedure,

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,
1647: l_debug_str, NULL,
1648: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1649: END IF;

Line 1855: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

1851:
1852: EXCEPTION
1853: WHEN OTHERS THEN
1854: p_status := '3';
1855: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1856:
1857: IF (l_request_id IS NULL) THEN
1858: l_request_id := fnd_global.conc_request_id;
1859: END IF;

Line 1868: fnd_log.string_with_context( fnd_log.level_exception,

1864: ||(p_api_rec.Interface_api_Id)
1865: ||' Status:3 '
1866: ||'Error Code: '||p_error_code ||' SQLERRM: '|| SQLERRM;
1867:
1868: fnd_log.string_with_context( fnd_log.level_exception,
1869: l_label,
1870: l_debug_str, NULL,
1871: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1872: END IF;

Line 1887: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

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
1890: l_request_id := fnd_global.conc_request_id;
1891: END IF;

Line 1896: fnd_log.string_with_context( fnd_log.level_procedure,

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,
1898: l_debug_str, NULL,
1899: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1900: END IF;

Line 2017: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2013: p_error_code := 'E007';
2014: p_status := '3';
2015: END IF;
2016:
2017: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2018:
2019: IF (l_request_id IS NULL) THEN
2020: l_request_id := fnd_global.conc_request_id;
2021: END IF;

Line 2029: fnd_log.string_with_context( fnd_log.level_exception,

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,
2030: l_label,
2031: l_debug_str, NULL,
2032: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2033: END IF;

Line 2115: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2111: p_error_code := 'E208';
2112: ELSE
2113: p_error_code := 'E014';
2114: END IF;
2115: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2116: IF (l_request_id IS NULL) THEN
2117: l_request_id := fnd_global.conc_request_id;
2118: END IF;
2119:

Line 2126: fnd_log.string_with_context( fnd_log.level_exception,

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,
2127: l_label,
2128: l_debug_str, NULL,
2129: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2130: END IF;

Line 2208: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2204: l_object_version_number NUMBER;
2205: BEGIN
2206:
2207: l_failure_child := 0;
2208: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2209:
2210: IF (l_request_id IS NULL) THEN
2211: l_request_id := fnd_global.conc_request_id;
2212: END IF;

Line 2217: fnd_log.string_with_context( fnd_log.level_procedure,

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,
2219: l_debug_str, NULL,
2220: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2221: END IF;

Line 2270: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2266:
2267: IF (l_return_status IN ('E','U') ) THEN
2268:
2269: l_error_code := 'E244';
2270: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2271:
2272: IF (l_request_id IS NULL) THEN
2273: l_request_id := fnd_global.conc_request_id;
2274: END IF;

Line 2280: fnd_log.string_with_context( fnd_log.level_exception,

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,
2281: l_label,
2282: l_debug_str, NULL,
2283: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2284: END IF;

Line 2334: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2330: SET status = '4',
2331: error_code = 'E244'
2332: WHERE interface_addr_id = l_interface_addr_id;
2333:
2334: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2335:
2336: IF (l_request_id IS NULL) THEN
2337: l_request_id := fnd_global.conc_request_id;
2338: END IF;

Line 2346: fnd_log.string_with_context( fnd_log.level_exception,

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,
2347: l_label,
2348: l_debug_str, NULL,
2349: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2350: END IF;

Line 2365: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

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:
2367: IF (l_request_id IS NULL) THEN
2368: l_request_id := fnd_global.conc_request_id;
2369: END IF;

Line 2374: fnd_log.string_with_context( fnd_log.level_procedure,

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,
2376: l_debug_str, NULL,
2377: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2378: END IF;

Line 2435: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2431: SET status = '4',
2432: error_code = 'E006'
2433: WHERE interface_id = p_addr_rec.interface_id;
2434:
2435: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2436:
2437: IF (l_request_id IS NULL) THEN
2438: l_request_id := fnd_global.conc_request_id;
2439: END IF;

Line 2448: fnd_log.string_with_context( fnd_log.level_exception,

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:
2448: fnd_log.string_with_context( fnd_log.level_exception,
2449: l_label,
2450: l_debug_str, NULL,
2451: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2452: END IF;

Line 2464: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2460: SET STATUS = '4',
2461: ERROR_CODE = 'E073'
2462: WHERE INTERFACE_ADDR_ID = p_ADDR_REC.INTERFACE_ADDR_ID;
2463:
2464: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2465:
2466: IF (l_request_id IS NULL) THEN
2467: l_request_id := fnd_global.conc_request_id;
2468: END IF;

Line 2477: fnd_log.string_with_context( fnd_log.level_exception,

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:
2477: fnd_log.string_with_context( fnd_log.level_exception,
2478: l_label,
2479: l_debug_str, NULL,
2480: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2481: END IF;

Line 2530: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2526: SET status = '4',
2527: error_code = 'E006'
2528: WHERE interface_id = p_addr_rec.interface_id;
2529:
2530: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2531:
2532: IF (l_request_id IS NULL) THEN
2533: l_request_id := fnd_global.conc_request_id;
2534: END IF;

Line 2543: fnd_log.string_with_context( fnd_log.level_exception,

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:
2543: fnd_log.string_with_context( fnd_log.level_exception,
2544: l_label,
2545: l_debug_str, NULL,
2546: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2547: END IF;

Line 2635: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2631: l_failure_child NUMBER(3);
2632: l_object_version_number NUMBER;
2633: BEGIN
2634: l_failure_child := 0;
2635: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2636:
2637: IF (l_request_id IS NULL) THEN
2638: l_request_id := fnd_global.conc_request_id;
2639: END IF;

Line 2644: fnd_log.string_with_context( fnd_log.level_procedure,

2640:
2641: l_label := 'igs.plsql.igs_ad_imp_006.update_address.process_addrusage_begin';
2642: l_debug_str := 'Interface addr Id : ' || l_interface_addr_id;
2643:
2644: fnd_log.string_with_context( fnd_log.level_procedure,
2645: l_label,
2646: l_debug_str, NULL,
2647: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2648: END IF;

Line 2698: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2694:
2695: IF (l_return_status IN ('E','U') ) THEN
2696:
2697: l_error_code := 'E244';
2698: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2699:
2700: IF (l_request_id IS NULL) THEN
2701: l_request_id := fnd_global.conc_request_id;
2702: END IF;

Line 2708: fnd_log.string_with_context( fnd_log.level_exception,

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,
2709: l_label,
2710: l_debug_str, NULL,
2711: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2712: END IF;

Line 2762: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2758: SET status = '4',
2759: error_code = 'E244'
2760: WHERE interface_addr_id = l_interface_addr_id;
2761:
2762: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2763:
2764: IF (l_request_id IS NULL) THEN
2765: l_request_id := fnd_global.conc_request_id;
2766: END IF;

Line 2774: fnd_log.string_with_context( fnd_log.level_exception,

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,
2775: l_label,
2776: l_debug_str, NULL,
2777: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2778: END IF;

Line 2796: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2792: l_party_site_id := p_party_site_id;
2793: p_status := '2';
2794:
2795: -- Call Log header
2796: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2797:
2798: IF (l_request_id IS NULL) THEN
2799: l_request_id := fnd_global.conc_request_id;
2800: END IF;

Line 2805: fnd_log.string_with_context( fnd_log.level_procedure,

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,
2807: l_debug_str, NULL,
2808: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2809: END IF;

Line 2816: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2812: p_person_id => p_person_id,
2813: p_status => p_status,
2814: p_error_code => p_error_code);
2815:
2816: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2817:
2818: IF (l_request_id IS NULL) THEN
2819: l_request_id := fnd_global.conc_request_id;
2820: END IF;

Line 2826: fnd_log.string_with_context( fnd_log.level_exception,

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,
2827: l_label,
2828: l_debug_str, NULL,
2829: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2830: END IF;

Line 2898: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2894: SET status = '4', error_code = 'E014'
2895: WHERE interface_id = p_addr_rec.interface_id;
2896:
2897: p_error_code := 'E014';
2898: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2899:
2900: IF (l_request_id IS NULL) THEN
2901: l_request_id := fnd_global.conc_request_id;
2902: END IF;

Line 2910: fnd_log.string_with_context( fnd_log.level_exception,

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,
2911: l_label,
2912: l_debug_str, NULL,
2913: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2914: END IF;

Line 2926: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2922: SET status = '4', error_code = 'E073'
2923: WHERE interface_addr_id = p_addr_rec.interface_addr_id;
2924:
2925: p_error_code := 'E073';
2926: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2927: IF (l_request_id IS NULL) THEN
2928: l_request_id := fnd_global.conc_request_id;
2929: END IF;
2930:

Line 2937: fnd_log.string_with_context( fnd_log.level_exception,

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,
2938: l_label,
2939: l_debug_str, NULL,
2940: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2941: END IF;

Line 2970: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

2966: UPDATE igs_ad_interface_all
2967: SET status = '4', error_code = 'E014'
2968: WHERE interface_id = p_addr_rec.interface_id;
2969:
2970: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2971:
2972: IF (l_request_id IS NULL) THEN
2973: l_request_id := fnd_global.conc_request_id;
2974: END IF;

Line 2983: fnd_log.string_with_context( fnd_log.level_exception,

2979: || l_msg_data || ' Interface Addr Id : '
2980: || (P_addr_REC.INTERFACE_ADDR_ID) || ' Status : 3' ||
2981: ' ErrorCode : '||p_error_code;
2982:
2983: fnd_log.string_with_context( fnd_log.level_exception,
2984: l_label,
2985: l_debug_str, NULL,
2986: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2987: END IF;