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.GHR_ELT_TO_BEN_PKG dependencies on GHR_WGI_PKG

Line 129: ghr_wgi_pkg.create_ghr_errorlog(

125: COMMIT;
126:
127: -- Call child concurrent programs for each and every thread
128: l_log_text := 'Total number of employees: ' || l_count || ' : Number of Batches ' || l_batch_no || ' : Batch size ' || l_batch_size;
129: ghr_wgi_pkg.create_ghr_errorlog(
130: p_program_name => g_proc_name,
131: p_log_text => l_log_text,
132: p_message_name => 'Number of Batches',
133: p_log_date => sysdate

Line 566: ghr_wgi_pkg.create_ghr_errorlog (p_program_name => l_program_name

562: (p_person_id => l_current_person_id,
563: p_effective_date => l_new_effective_date);
564: l_log_text := 'System unable to create Benefits EIT for the Person: '||l_full_name||
565: '; Emp No: '||l_emp_num||'; Error: '||sqlerrm;
566: ghr_wgi_pkg.create_ghr_errorlog (p_program_name => l_program_name
567: ,p_log_text => l_log_text
568: ,p_message_name => 'Benefits EIT Creation Error'
569: ,p_log_date => SYSDATE
570: );

Line 981: ghr_wgi_pkg.create_ghr_errorlog(

977: l_log_text := 'For '||'Employee Name: '|| l_full_name ||
978: ' Emp No: '|| l_emp_num ||' Health Benefit conversion Script1 Successfully completed';
979: p_errbuf := l_log_text;
980:
981: ghr_wgi_pkg.create_ghr_errorlog(
982: p_program_name => l_program_name,
983: p_message_name => substr('HB conversion Successful',1,30),
984: p_log_text => substr(l_log_text,1,2000),
985: p_log_date => sysdate);

Line 989: ghr_wgi_pkg.create_ghr_errorlog(

985: p_log_date => sysdate);
986: --End Bug# 10419074
987: exception
988: when others then
989: ghr_wgi_pkg.create_ghr_errorlog(
990: p_program_name => l_program_name,
991: p_message_name => 'HB conversion - ERROR',
992: p_log_text => 'Error : Health Benefits Conversion script1 Errored out' ||
993: ' For Emp Name ' || l_full_name ||

Line 1006: ghr_wgi_pkg.create_ghr_errorlog(

1002: l_effective_date := to_date('2013/01/13','YYYY/MM/DD');
1003: end loop;
1004: BEGIN --A3
1005: if l_health_plan_mod = 0 then --bug# 10419074
1006: ghr_wgi_pkg.create_ghr_errorlog(
1007: p_program_name => l_program_name,
1008: p_message_name => substr('No HB conversion',1,30),
1009: p_log_text => 'No Health Benefits Data Modified with Conversion Script1...',
1010: p_log_date => sysdate);

Line 1015: ghr_wgi_pkg.create_ghr_errorlog(

1011: end if;
1012: commit;
1013: exception
1014: when others then
1015: ghr_wgi_pkg.create_ghr_errorlog(
1016: p_program_name => l_program_name,
1017: p_message_name => 'HB conversion - ERROR',
1018: p_log_text => 'Error : Health Benefits Conversion script1 Errored out' ||
1019: ' Element ' || to_char(l_element_entry_id) ||

Line 1113: ghr_wgi_pkg.create_ghr_errorlog(

1109: l_log_text := 'For '||'Employee Name: '|| l_full_name ||
1110: ' Emp No: '|| l_emp_num ||' Health Benefit Pre Tax Conversion Script1 Successfully completed';
1111: p_errbuf := l_log_text;
1112:
1113: ghr_wgi_pkg.create_ghr_errorlog(
1114: p_program_name => l_program_name,
1115: p_message_name => substr('HBPT conversion Successful',1,30),
1116: p_log_text => substr(l_log_text,1,2000),
1117: p_log_date => sysdate);

Line 1121: ghr_wgi_pkg.create_ghr_errorlog(

1117: p_log_date => sysdate);
1118: --End Bug# 10419074
1119: exception
1120: when others then
1121: ghr_wgi_pkg.create_ghr_errorlog(
1122: p_program_name => l_program_name,
1123: p_message_name => 'HBPT conversion - ERROR',
1124: p_log_text => 'Error : Health Benefits Pre Tax Conversion Script1 Errored out' ||
1125: ' For Emp No ' || l_emp_num ||

Line 1137: ghr_wgi_pkg.create_ghr_errorlog(

1133: l_effective_date := to_date('2013/01/13','YYYY/MM/DD');
1134: end loop;--Loop1
1135: BEGIN --B3
1136: if l_health_plan_mod = 0 then --bug# 10419074
1137: ghr_wgi_pkg.create_ghr_errorlog(
1138: p_program_name => l_program_name,
1139: p_message_name => substr('No HBPT conversion',1,30),
1140: p_log_text => 'No Health Benefits Pre Tax Data Modified with Conversion Script1...',
1141: p_log_date => sysdate);

Line 1147: ghr_wgi_pkg.create_ghr_errorlog(

1143: end if;
1144: commit;
1145: exception
1146: when others then
1147: ghr_wgi_pkg.create_ghr_errorlog(
1148: p_program_name => l_program_name,
1149: p_message_name => 'HBPT conversion - ERROR',
1150: p_log_text => 'Error : Health Benefits Pre Tax Conversion Script1 Errored out' ||
1151: ' Element ' || to_char(l_element_entry_id) ||

Line 1434: ghr_wgi_pkg.create_ghr_errorlog(

1430: l_log_text := 'For '||'Employee Name: '|| l_full_name ||
1431: ' Emp No: '|| l_emp_num ||' Health Benefit conversion Script2 Successfully completed';
1432: p_errbuf := l_log_text;
1433:
1434: ghr_wgi_pkg.create_ghr_errorlog(
1435: p_program_name => l_program_name,
1436: p_message_name => substr('HB conversion Successful',1,30),
1437: p_log_text => substr(l_log_text,1,2000),
1438: p_log_date => sysdate);

Line 1442: ghr_wgi_pkg.create_ghr_errorlog(

1438: p_log_date => sysdate);
1439: --End Bug# 10419074
1440: exception
1441: when others then
1442: ghr_wgi_pkg.create_ghr_errorlog(
1443: p_program_name => l_program_name,
1444: p_message_name => 'HB conversion - ERROR',
1445: p_log_text => 'Error : Health Benefits Conversion Script2 Errored out' ||
1446: ' For Emp No ' || l_emp_num ||

Line 1458: ghr_wgi_pkg.create_ghr_errorlog(

1454: l_effective_date := to_date('2013/01/13','YYYY/MM/DD');
1455: end loop;
1456: BEGIN --C3
1457: if l_health_plan_mod = 0 then --bug# 10419074
1458: ghr_wgi_pkg.create_ghr_errorlog(
1459: p_program_name => l_program_name,
1460: p_message_name => substr('No HB conversion',1,30),
1461: p_log_text => 'No Health Benefits Data Modified with Conversion Script2...',
1462: p_log_date => sysdate);

Line 1467: ghr_wgi_pkg.create_ghr_errorlog(

1463: end if;
1464: commit;
1465: exception
1466: when others then
1467: ghr_wgi_pkg.create_ghr_errorlog(
1468: p_program_name => l_program_name,
1469: p_message_name => 'HB conversion - ERROR',
1470: p_log_text => 'Error : Health Benefits Conversion Script2 Errored out' ||
1471: ' Element ' || to_char(l_element_entry_id) ||

Line 1566: ghr_wgi_pkg.create_ghr_errorlog(

1562: l_log_text := 'For '||'Employee Name: '|| l_full_name ||
1563: ' Emp No: '|| l_emp_num ||' Health Benefit Pre Tax conversion Script2 Successfully completed';
1564: p_errbuf := l_log_text;
1565:
1566: ghr_wgi_pkg.create_ghr_errorlog(
1567: p_program_name => l_program_name,
1568: p_message_name => substr('HBPT conversion Successful',1,30),
1569: p_log_text => substr(l_log_text,1,2000),
1570: p_log_date => sysdate);

Line 1574: ghr_wgi_pkg.create_ghr_errorlog(

1570: p_log_date => sysdate);
1571: --End Bug# 10419074
1572: exception
1573: when others then
1574: ghr_wgi_pkg.create_ghr_errorlog(
1575: p_program_name => l_program_name,
1576: p_message_name => 'HBPT conversion - ERROR',
1577: p_log_text => 'Error : Health Benefits Pre Tax Conversion Script2 Errored out' ||
1578: ' For Emp No ' || l_emp_num ||

Line 1590: ghr_wgi_pkg.create_ghr_errorlog(

1586: l_effective_date := to_date('2013/01/13','YYYY/MM/DD');
1587: end loop;
1588: BEGIN --C6
1589: if l_health_plan_mod = 0 then --bug# 10419074
1590: ghr_wgi_pkg.create_ghr_errorlog(
1591: p_program_name => l_program_name,
1592: p_message_name => substr('No HBPT conversion',1,30),
1593: p_log_text => 'No Health Benefits Pre Tax Data Modified with Conversion Script2...',
1594: p_log_date => sysdate);

Line 1600: ghr_wgi_pkg.create_ghr_errorlog(

1596: end if;
1597: commit;
1598: exception
1599: when others then
1600: ghr_wgi_pkg.create_ghr_errorlog(
1601: p_program_name => l_program_name,
1602: p_message_name => 'HBPT conversion - ERROR',
1603: p_log_text => 'Error : Health Benefits Pre Tax Conversion Script2 Errored out' ||
1604: ' Element ' || to_char(l_element_entry_id) ||

Line 1879: ghr_wgi_pkg.create_ghr_errorlog(

1875: l_log_text := 'For '||'Employee Name: '|| l_full_name ||
1876: ' Emp No: '|| l_emp_num ||' Health Benefit conversion Script3 Successfully completed';
1877: p_errbuf := l_log_text;
1878:
1879: ghr_wgi_pkg.create_ghr_errorlog(
1880: p_program_name => l_program_name,
1881: p_message_name => substr('HB conversion Successful',1,30),
1882: p_log_text => substr(l_log_text,1,2000),
1883: p_log_date => sysdate);

Line 1887: ghr_wgi_pkg.create_ghr_errorlog(

1883: p_log_date => sysdate);
1884: --End Bug# 10419074
1885: exception
1886: when others then
1887: ghr_wgi_pkg.create_ghr_errorlog(
1888: p_program_name => l_program_name,
1889: p_message_name => 'HB conversion - ERROR',
1890: p_log_text => 'Error : Health Benefits Conversion Script3 Errored out' ||
1891: ' For Emp No ' || l_emp_num ||

Line 1903: ghr_wgi_pkg.create_ghr_errorlog(

1899: l_effective_date := to_date('2013/01/13','YYYY/MM/DD');
1900: end loop;
1901: BEGIN --D3
1902: if l_health_plan_mod = 0 then --bug# 10419074
1903: ghr_wgi_pkg.create_ghr_errorlog(
1904: p_program_name => l_program_name,
1905: p_message_name => substr('No HB conversion',1,30),
1906: p_log_text => 'No Health Benefits Data Modified with Conversion Script3...',
1907: p_log_date => sysdate);

Line 1912: ghr_wgi_pkg.create_ghr_errorlog(

1908: end if;
1909: commit;
1910: exception
1911: when others then
1912: ghr_wgi_pkg.create_ghr_errorlog(
1913: p_program_name => l_program_name,
1914: p_message_name => 'HB conversion - ERROR',
1915: p_log_text => 'Error : Health Benefits Conversion Script3 Errored out' ||
1916: ' Element ' || to_char(l_element_entry_id) ||

Line 2006: ghr_wgi_pkg.create_ghr_errorlog(

2002: l_log_text := 'For '||'Employee Name: '|| l_full_name ||
2003: ' Emp No: '|| l_emp_num ||' Health Benefit Pre Tax conversion Script3 Successfully completed';
2004: p_errbuf := l_log_text;
2005:
2006: ghr_wgi_pkg.create_ghr_errorlog(
2007: p_program_name => l_program_name,
2008: p_message_name => substr('HBPT conversion Successful',1,30),
2009: p_log_text => substr(l_log_text,1,2000),
2010: p_log_date => sysdate);

Line 2014: ghr_wgi_pkg.create_ghr_errorlog(

2010: p_log_date => sysdate);
2011: --End Bug# 10419074
2012: exception
2013: when others then
2014: ghr_wgi_pkg.create_ghr_errorlog(
2015: p_program_name => l_program_name,
2016: p_message_name => 'HBPT conversion - ERROR',
2017: p_log_text => 'Error : Health Benefits Pre Tax Conversion Script3 Errored out'||
2018: ' For Emp No ' || l_emp_num ||

Line 2030: ghr_wgi_pkg.create_ghr_errorlog(

2026: l_effective_date := to_date('2013/01/13','YYYY/MM/DD');
2027: end loop;
2028: BEGIN --D6
2029: if l_health_plan_mod = 0 then --bug# 10419074
2030: ghr_wgi_pkg.create_ghr_errorlog(
2031: p_program_name => l_program_name,
2032: p_message_name => substr('No HBPT conversion',1,30),
2033: p_log_text => 'No Health Benefits Pre Tax Data Modified with Conversion Script3...',
2034: p_log_date => sysdate);

Line 2040: ghr_wgi_pkg.create_ghr_errorlog(

2036: end if;
2037: commit;
2038: exception
2039: when others then
2040: ghr_wgi_pkg.create_ghr_errorlog(
2041: p_program_name => l_program_name,
2042: p_message_name => 'HBPT conversion - ERROR',
2043: p_log_text => 'Error : Health Benefits Pre Tax Conversion script3 Errored out' ||
2044: ' Element ' || to_char(l_element_entry_id) ||

Line 2352: ghr_wgi_pkg.create_ghr_errorlog(

2348: EXIT;
2349: END LOOP;
2350: l_process_log_upd_flag:=1;
2351: --Bug # 9329643 Modified SSN to Emp No
2352: ghr_wgi_pkg.create_ghr_errorlog(
2353: p_program_name => l_program_name,
2354: p_message_name => 'Upgrade for TSP-Warning',
2355: p_log_text => 'Warning : Please verify the TSP Status Start Date ' ||
2356: ' For Person Name ' || l_employee_name ||

Line 2368: ghr_wgi_pkg.create_ghr_errorlog(

2364: END IF;
2365: exception
2366: when others then
2367: --Bug # 9329643 Modified SSN to Emp No
2368: ghr_wgi_pkg.create_ghr_errorlog(
2369: p_program_name => l_program_name,
2370: p_message_name => 'Upgrade for TSP-ERROR',
2371: p_log_text => 'Error : Upgrade of TSP Error Processing ' ||
2372: ' For Emp No ' || l_employee_number ||

Line 2504: ghr_wgi_pkg.create_ghr_errorlog(

2500: l_tsp_start_date := l_get_tsp_date.screen_entry_value;
2501: EXIT;
2502: END LOOP;
2503: --Bug # 9329643 Modified SSN to Emp No
2504: ghr_wgi_pkg.create_ghr_errorlog(
2505: p_program_name => l_program_name,
2506: p_message_name => 'Upgrade for TSP-Warning',
2507: p_log_text => 'Warning : Please verify the TSP Status Start Date ' ||
2508: ' For Person Name ' || l_employee_name ||

Line 2525: ghr_wgi_pkg.create_ghr_errorlog(

2521: END IF;--IF fnd_date.canonical_to_date(l_peopleei_data.pei_information14)
2522: Exception
2523: When Others then
2524: --Bug # 9329643 Modified SSN to Emp No
2525: ghr_wgi_pkg.create_ghr_errorlog(
2526: p_program_name => l_program_name,
2527: p_message_name => 'B.Person for TSP-ERROR',
2528: p_log_text => 'Error : Upgrade of TSP Person EIT Error ' ||
2529: ' For Emp No ' || l_employee_number ||

Line 2545: ghr_wgi_pkg.create_ghr_errorlog(

2541: END LOOP;--for l_tsp_agncy_date
2542: BEGIN --B4
2543: if l_tsp_abv_agcy_rec_cnt <> 0 then
2544:
2545: ghr_wgi_pkg.create_ghr_errorlog(
2546: p_program_name => l_program_name,
2547: p_message_name => 'Upgrade Script for TSP',
2548: p_log_text => 'TSP Data Modified successfully....'
2549: || to_char(l_tsp_abv_agcy_rec_cnt) || ' rows',

Line 2552: ghr_wgi_pkg.create_ghr_errorlog(

2548: p_log_text => 'TSP Data Modified successfully....'
2549: || to_char(l_tsp_abv_agcy_rec_cnt) || ' rows',
2550: p_log_date => sysdate);
2551: else
2552: ghr_wgi_pkg.create_ghr_errorlog(
2553: p_program_name => l_program_name,
2554: p_message_name => 'Upgrade Script for TSP',
2555: p_log_text => 'TSP Data Not required to modify...',
2556: p_log_date => sysdate);

Line 2607: ghr_wgi_pkg.create_ghr_errorlog(

2603: END IF;
2604: END IF;
2605: EXCEPTION
2606: WHEN OTHERS THEN
2607: ghr_wgi_pkg.create_ghr_errorlog(
2608: p_program_name => l_program_name,
2609: p_message_name => 'TSP Future act ERROR: ',
2610: p_log_text => 'Error : Upgrade of TSP Errored ' ||
2611: ' Pa Request Id ' || to_char(l_pa_request_id) ||

Line 2620: ghr_wgi_pkg.create_ghr_errorlog(

2616:
2617: END;--C2
2618: END LOOP;
2619: IF l_tsp_future_rec_cnt <> 0 THEN
2620: ghr_wgi_pkg.create_ghr_errorlog(
2621: p_program_name => l_program_name,
2622: p_message_name => 'Update Script for Future TSP',
2623: p_log_text => 'Total Future Action records Modified successfully.... ' || to_char(l_tsp_future_rec_cnt) || ' rows',
2624: p_log_date => sysdate);

Line 2626: ghr_wgi_pkg.create_ghr_errorlog(

2622: p_message_name => 'Update Script for Future TSP',
2623: p_log_text => 'Total Future Action records Modified successfully.... ' || to_char(l_tsp_future_rec_cnt) || ' rows',
2624: p_log_date => sysdate);
2625: ELSE
2626: ghr_wgi_pkg.create_ghr_errorlog(
2627: p_program_name => l_program_name,
2628: p_message_name => 'Update Script for Future TSP',
2629: p_log_text => 'TSP(Future Actions) Data Not required to modify...',
2630: p_log_date => sysdate);