DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_MTO_INT

Line 271: ghr_mto_int.set_log_program_name('GHR_MLC_PKG');

267:
268: g_effective_date := l_effective_date;
269:
270: IF upper(p_action) = 'CREATE' then
271: ghr_mto_int.set_log_program_name('GHR_MLC_PKG');
272: ELSE
273: ghr_mto_int.set_log_program_name('MLC_'||p_mass_salary);
274: END IF;
275:

Line 273: ghr_mto_int.set_log_program_name('MLC_'||p_mass_salary);

269:
270: IF upper(p_action) = 'CREATE' then
271: ghr_mto_int.set_log_program_name('GHR_MLC_PKG');
272: ELSE
273: ghr_mto_int.set_log_program_name('MLC_'||p_mass_salary);
274: END IF;
275:
276: get_lac_dtls(l_pa_request_id,
277: l_lac_sf52_rec);

Line 910: ghr_mto_int.log_message(

906: IF l_errbuf is null then
907: pr('No error in create sf52 ');
908: hr_utility.set_location('Before commiting',2);
909:
910: ghr_mto_int.log_message(
911: p_procedure => 'Successful Completion',
912: p_message => 'Name: '||per.full_name ||
913: ' SSN: '|| per.national_identifier|| ' Mass Salary : '||
914: p_mass_salary ||' SF52 Successfully completed');

Line 997: ghr_mto_int.log_message(

993: l_mlcerrbuf;
994: hr_utility.set_location('before creating entry in log file',10);
995: l_recs_failed := l_recs_failed + 1;
996: begin
997: ghr_mto_int.log_message(
998: p_procedure => g_proc,
999: p_message => l_log_text);
1000:
1001: exception

Line 1020: ghr_mto_int.log_message(

1016: ' Sql Err is '||sqlerrm(sqlcode);
1017: hr_utility.set_location('before creating entry in log file',20);
1018: l_recs_failed := l_recs_failed + 1;
1019: begin
1020: ghr_mto_int.log_message(
1021: p_procedure => g_proc,
1022: p_message => l_log_text);
1023: exception
1024: when others then

Line 1090: ghr_mto_int.log_message(

1086: commit;
1087: END IF;
1088:
1089: begin
1090: ghr_mto_int.log_message(
1091: p_procedure => g_proc,
1092: p_message => l_log_text);
1093: exception
1094: when others then

Line 2092: ghr_mto_int.log_message(

2088: if l_errbuf is null then
2089: pr('No error in create sf52 ');
2090: hr_utility.set_location('Before commiting',2);
2091:
2092: ghr_mto_int.log_message(
2093: p_procedure => 'Successful Completion',
2094: p_message => 'Name: '||p_full_name ||
2095: ' SSN: '|| p_national_identifier|| ' Mass Salary : '||
2096: p_mass_salary ||' SF52 Successfully completed');

Line 2175: ghr_mto_int.log_message(

2171: l_mtcerrbuf;
2172: hr_utility.set_location('before creating entry in log file',10);
2173: l_recs_failed := l_recs_failed + 1;
2174: begin
2175: ghr_mto_int.log_message(
2176: p_procedure => g_proc,
2177: p_message => l_log_text);
2178:
2179: exception

Line 2198: ghr_mto_int.log_message(

2194: ' Sql Err is '||sqlerrm(sqlcode);
2195: hr_utility.set_location('before creating entry in log file',20);
2196: l_recs_failed := l_recs_failed + 1;
2197: begin
2198: ghr_mto_int.log_message(
2199: p_procedure => g_proc,
2200: p_message => l_log_text);
2201:
2202: exception

Line 2277: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');

2273: rec_pp_prd_per_gr(1).grade := null;
2274: end if;
2275:
2276: IF upper(p_action) = 'CREATE' then
2277: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
2278: ELSE
2279: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
2280: END IF;
2281:

Line 2279: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);

2275:
2276: IF upper(p_action) = 'CREATE' then
2277: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
2278: ELSE
2279: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
2280: END IF;
2281:
2282: get_lac_dtls(l_pa_request_id,
2283: l_lac_sf52_rec);

Line 2583: ghr_mto_int.log_message(

2579:
2580: ghr_validate_perwsdpo.validate_perwsdpo(l_position_id,l_effective_date);
2581: ghr_validate_perwsdpo.update_posn_status(l_position_id,l_effective_date);
2582:
2583: ghr_mto_int.log_message(
2584: p_procedure => 'Successful Completion',
2585: p_message => 'Vacant Position : '||l_pos_name ||
2586: ' Mass Table Change : '||
2587: p_mass_salary ||' Vacant pos Successfully completed');

Line 2607: ghr_mto_int.log_message(

2603: **************************/
2604: exception when others then
2605: l_mtcerrbuf := 'Error in ghr_sf52_pos_UPDATE.UPDATE_position_info' ||
2606: ' Sql Err is '|| sqlerrm(sqlcode);
2607: ghr_mto_int.log_message(
2608: p_procedure => 'Failed',
2609: p_message => 'Vacant Position : '||l_pos_name ||
2610: ' Mass Table Change : '||
2611: p_mass_salary || l_mtcerrbuf);

Line 2672: ghr_mto_int.log_message(

2668: commit;
2669: END IF;
2670:
2671: begin
2672: ghr_mto_int.log_message(
2673: p_procedure => g_proc,
2674: p_message => l_log_text);
2675:
2676: exception

Line 3587: ghr_mto_int.log_message(

3583: l_action_taken := pa_hist_rec.action_taken;
3584: exit;
3585: end loop;
3586: if l_action_taken <> 'CANCELED' then
3587: ghr_mto_int.log_message(
3588: p_procedure => 'RPA Exists Already',
3589: p_message => 'Name: '|| l_name || ' - Salary Change ' ||
3590: ' RPA Exists for the given FWS pay_lan and effective date' );
3591: return true;

Line 3609: ghr_mto_int.log_message(

3605: l_action_taken := pa_hist_rec.action_taken;
3606: exit;
3607: end loop;
3608: if l_action_taken <> 'CANCELED' then
3609: ghr_mto_int.log_message(
3610: p_procedure => 'RPA Exists Already',
3611: p_message => 'Name: '|| l_name || ' - Salary Change ' ||
3612: ' RPA Exists for the given effective date ' );
3613: return true;

Line 3761: ghr_mto_int.log_message(

3757: l_action_taken := pa_hist_rec.action_taken;
3758: exit;
3759: end loop;
3760: if l_action_taken <> 'CANCELED' then
3761: ghr_mto_int.log_message(
3762: p_procedure => 'RPA Exists Already',
3763: p_message => 'Name: '|| l_name || ' - Mass Table Change ' ||
3764: ' RPA Exists for the given FWS pay_lan and effective date' );
3765: return true;

Line 3783: ghr_mto_int.log_message(

3779: l_action_taken := pa_hist_rec.action_taken;
3780: exit;
3781: end loop;
3782: if l_action_taken <> 'CANCELED' then
3783: ghr_mto_int.log_message(
3784: p_procedure => 'RPA Exists Already',
3785: p_message => 'Name: '|| l_name || ' - Mass Table Change ' ||
3786: ' RPA Exists for the given effective date ' );
3787: return true;

Line 5436: ghr_mto_int.put_line(msg||'-'||par1||' -'||par2||'-');

5432: -- g_no := g_no +1;
5433: -- insert into l_tmp values (g_no,substr(msg||'-'||par1||' -'||par2||'-',1,199));
5434: -- DBMS_OUTPUT.PUT_LINE(msg||'-'||par1||' -'||par2||'-');
5435:
5436: ghr_mto_int.put_line(msg||'-'||par1||' -'||par2||'-');
5437: exception
5438: when others then
5439: hr_utility.set_location('Error in pr '||' Err is '||sqlerrm(sqlcode),20);
5440: l_mlcerrbuf := 'Error in pr Sql Err is '|| sqlerrm(sqlcode);