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 559: ghr_wgi_pkg.create_ghr_errorlog (p_program_name => l_program_name

555: --hr_utility.set_location('Error Occured while processing Person ID',75);
556: get_person_name_ssn(l_current_person_id,l_new_effective_date,l_full_name,l_ssn);
557: l_log_text := 'System unable to create Benefits EIT for the Person: '||l_full_name||
558: '; SSN: '||l_ssn||'; Error: '||sqlerrm;
559: ghr_wgi_pkg.create_ghr_errorlog (p_program_name => l_program_name
560: ,p_log_text => l_log_text
561: ,p_message_name => 'Benefits EIT Creation Error'
562: ,p_log_date => SYSDATE
563: );

Line 956: ghr_wgi_pkg.create_ghr_errorlog(

952: for l_cur_ssn in cur_ssn loop
953: l_ssn := l_cur_ssn.national_identifier;
954: exit;
955: end loop;
956: ghr_wgi_pkg.create_ghr_errorlog(
957: p_program_name => l_program_name,
958: p_message_name => 'A. Upgrade for HB1-ERROR',
959: p_log_text => 'Error : Upgrade of Health Benefits Error Processing ' ||
960: ' For SSN ' || l_ssn ||

Line 972: ghr_wgi_pkg.create_ghr_errorlog(

968: l_effective_date := to_date('2009/01/04','YYYY/MM/DD');
969: end loop;
970: BEGIN --A3
971: if l_health_plan_mod <> 0 then
972: ghr_wgi_pkg.create_ghr_errorlog(
973: p_program_name => l_program_name,
974: p_message_name => 'A. Upgrade Script for HB1',
975: p_log_text => 'Health Benefits Data Modified successfully....'
976: || to_char(l_health_plan_mod) || ' rows',

Line 979: ghr_wgi_pkg.create_ghr_errorlog(

975: p_log_text => 'Health Benefits Data Modified successfully....'
976: || to_char(l_health_plan_mod) || ' rows',
977: p_log_date => sysdate);
978: else
979: ghr_wgi_pkg.create_ghr_errorlog(
980: p_program_name => l_program_name,
981: p_message_name => 'A. Upgrade Script for HB1',
982: p_log_text => 'Health Benefits Data Not required to modify...',
983: p_log_date => sysdate);

Line 988: ghr_wgi_pkg.create_ghr_errorlog(

984: end if;
985: commit;
986: exception
987: when others then
988: ghr_wgi_pkg.create_ghr_errorlog(
989: p_program_name => l_program_name,
990: p_message_name => 'A. Upgrade Script for HB1',
991: p_log_text => 'Error : Upgrade of Health Benefits Error Processing ' ||
992: ' Element ' || to_char(l_element_entry_id) ||

Line 1092: ghr_wgi_pkg.create_ghr_errorlog(

1088: for l_cur_ssn in cur_ssn loop
1089: l_ssn := l_cur_ssn.national_identifier;
1090: exit;
1091: end loop;
1092: ghr_wgi_pkg.create_ghr_errorlog(
1093: p_program_name => l_program_name,
1094: p_message_name => 'A. Upgrade for HBPT1-ERROR',
1095: p_log_text => 'Error : Upgrade of Health Benefits Error Processing ' ||
1096: ' For SSN ' || l_ssn ||

Line 1108: ghr_wgi_pkg.create_ghr_errorlog(

1104: l_effective_date := to_date('2009/01/04','YYYY/MM/DD');
1105: end loop;--Loop1
1106: BEGIN --B3
1107: if l_health_plan_mod <> 0 then
1108: ghr_wgi_pkg.create_ghr_errorlog(
1109: p_program_name => l_program_name,
1110: p_message_name => 'A. Upgrade Script HBPT1',
1111: p_log_text => 'Health Benefits Pre tax Data Modified successfully....'
1112: || to_char(l_health_plan_mod) || ' rows',

Line 1115: ghr_wgi_pkg.create_ghr_errorlog(

1111: p_log_text => 'Health Benefits Pre tax Data Modified successfully....'
1112: || to_char(l_health_plan_mod) || ' rows',
1113: p_log_date => sysdate);
1114: else
1115: ghr_wgi_pkg.create_ghr_errorlog(
1116: p_program_name => l_program_name,
1117: p_message_name => 'A. Upgrade Script HBPT1',
1118: p_log_text => 'Health Benefits Pre tax Data Not required to modify...',
1119: p_log_date => sysdate);

Line 1125: ghr_wgi_pkg.create_ghr_errorlog(

1121: end if;
1122: commit;
1123: exception
1124: when others then
1125: ghr_wgi_pkg.create_ghr_errorlog(
1126: p_program_name => l_program_name,
1127: p_message_name => 'A. Upgrade Script HBPT1',
1128: p_log_text => 'Error : Upgrade of Health Benefits Pre tax Error Processing ' ||
1129: ' Element ' || to_char(l_element_entry_id) ||

Line 1399: ghr_wgi_pkg.create_ghr_errorlog(

1395: for l_cur_ssn in cur_ssn loop
1396: l_ssn := l_cur_ssn.national_identifier;
1397: exit;
1398: end loop;
1399: ghr_wgi_pkg.create_ghr_errorlog(
1400: p_program_name => l_program_name,
1401: p_message_name => 'A. Upgrade for HB2-ERROR',
1402: p_log_text => 'Error : Upgrade of Health Benefits Error Processing ' ||
1403: ' For SSN ' || l_ssn ||

Line 1415: ghr_wgi_pkg.create_ghr_errorlog(

1411: l_effective_date := to_date('2009/01/04','YYYY/MM/DD');
1412: end loop;
1413: BEGIN --D3
1414: if l_health_plan_mod <> 0 then
1415: ghr_wgi_pkg.create_ghr_errorlog(
1416: p_program_name => l_program_name,
1417: p_message_name => 'A. Upgrade Script for HB2',
1418: p_log_text => 'Health Benefits Data Modified successfully....'
1419: || to_char(l_health_plan_mod) || ' rows',

Line 1423: ghr_wgi_pkg.create_ghr_errorlog(

1419: || to_char(l_health_plan_mod) || ' rows',
1420: p_log_date => sysdate);
1421:
1422: else
1423: ghr_wgi_pkg.create_ghr_errorlog(
1424: p_program_name => l_program_name,
1425: p_message_name => 'A. Upgrade Script for HB2',
1426: p_log_text => 'Health Benefits Data Not required to modify...',
1427: p_log_date => sysdate);

Line 1432: ghr_wgi_pkg.create_ghr_errorlog(

1428: end if;
1429: commit;
1430: exception
1431: when others then
1432: ghr_wgi_pkg.create_ghr_errorlog(
1433: p_program_name => l_program_name,
1434: p_message_name => 'A. Upgrade Script for HB2',
1435: p_log_text => 'Error : Upgrade of Health Benefits Error Processing ' ||
1436: ' Element ' || to_char(l_element_entry_id) ||

Line 1523: ghr_wgi_pkg.create_ghr_errorlog(

1519: for l_cur_ssn in cur_ssn loop
1520: l_ssn := l_cur_ssn.national_identifier;
1521: exit;
1522: end loop;
1523: ghr_wgi_pkg.create_ghr_errorlog(
1524: p_program_name => l_program_name,
1525: p_message_name => 'A. Upgrade for HBPT3-ERROR',
1526: p_log_text => 'Error : Upgrade of Health Benefits Pre tax Error Processing '||
1527: ' For SSN ' || l_ssn ||

Line 1539: ghr_wgi_pkg.create_ghr_errorlog(

1535: l_effective_date := to_date('2009/01/04','YYYY/MM/DD');
1536: end loop;
1537: BEGIN --D6
1538: if l_health_plan_mod <> 0 then
1539: ghr_wgi_pkg.create_ghr_errorlog(
1540: p_program_name => l_program_name,
1541: p_message_name => 'A. Upgrade Script HBPT3',
1542: p_log_text => 'Health Benefits Pre tax Data Modified successfully....'
1543: || to_char(l_health_plan_mod) || ' rows',

Line 1546: ghr_wgi_pkg.create_ghr_errorlog(

1542: p_log_text => 'Health Benefits Pre tax Data Modified successfully....'
1543: || to_char(l_health_plan_mod) || ' rows',
1544: p_log_date => sysdate);
1545: else
1546: ghr_wgi_pkg.create_ghr_errorlog(
1547: p_program_name => l_program_name,
1548: p_message_name => 'A. Upgrade Script HBPT3',
1549: p_log_text => 'Health Benefits Pre tax Data Not required to modify...',
1550: p_log_date => sysdate);

Line 1556: ghr_wgi_pkg.create_ghr_errorlog(

1552: end if;
1553: commit;
1554: exception
1555: when others then
1556: ghr_wgi_pkg.create_ghr_errorlog(
1557: p_program_name => l_program_name,
1558: p_message_name => 'A. Upgrade Script HBPT3',
1559: p_log_text => 'Error : Upgrade of Health Benefits Pre tax Error Processing ' ||
1560: ' Element ' || to_char(l_element_entry_id) ||