DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_MTO_INT

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

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

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

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

Line 924: ghr_mto_int.log_message(

920: IF l_errbuf is null then
921: pr('No error in create sf52 ');
922: hr_utility.set_location('Before commiting',2);
923: --Bug # 9329643 Modified SSN to Emp No
924: ghr_mto_int.log_message(
925: p_procedure => 'Successful Completion',
926: p_message => 'Name: '||per.full_name ||
927: ' Emp No: '|| per.employee_number|| ' Mass Salary : '||
928: p_mass_salary ||' SF52 Successfully completed');

Line 1015: ghr_mto_int.log_message(

1011: l_mlcerrbuf;
1012: hr_utility.set_location('before creating entry in log file',10);
1013: l_recs_failed := l_recs_failed + 1;
1014: begin
1015: ghr_mto_int.log_message(
1016: p_procedure => g_proc,
1017: p_message => l_log_text);
1018:
1019: exception

Line 1040: ghr_mto_int.log_message(

1036: ' Sql Err is '||sqlerrm(sqlcode);
1037: hr_utility.set_location('before creating entry in log file',20);
1038: l_recs_failed := l_recs_failed + 1;
1039: begin
1040: ghr_mto_int.log_message(
1041: p_procedure => g_proc,
1042: p_message => l_log_text);
1043: exception
1044: when others then

Line 1110: ghr_mto_int.log_message(

1106: commit;
1107: END IF;
1108:
1109: begin
1110: ghr_mto_int.log_message(
1111: p_procedure => g_proc,
1112: p_message => l_log_text);
1113: exception
1114: when others then

Line 2127: ghr_mto_int.log_message(

2123: pr('No error in create sf52 ');
2124: hr_utility.set_location('Before commiting',2);
2125:
2126: --Bug # 9329643 Modified SSN to Emp No
2127: ghr_mto_int.log_message(
2128: p_procedure => 'Successful Completion',
2129: p_message => 'Name: '||p_full_name ||
2130: ' Emp No: ' || p_employee_number|| ' Mass Salary : '||
2131: p_mass_salary ||' SF52 Successfully completed');

Line 2211: ghr_mto_int.log_message(

2207: l_mtcerrbuf;
2208: hr_utility.set_location('before creating entry in log file',10);
2209: l_recs_failed := l_recs_failed + 1;
2210: begin
2211: ghr_mto_int.log_message(
2212: p_procedure => g_proc,
2213: p_message => l_log_text);
2214:
2215: exception

Line 2235: ghr_mto_int.log_message(

2231: ' Sql Err is '||sqlerrm(sqlcode);
2232: hr_utility.set_location('before creating entry in log file',20);
2233: l_recs_failed := l_recs_failed + 1;
2234: begin
2235: ghr_mto_int.log_message(
2236: p_procedure => g_proc,
2237: p_message => l_log_text);
2238:
2239: exception

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

2310: rec_pp_prd_per_gr(1).grade := null;
2311: end if;
2312:
2313: IF upper(p_action) = 'CREATE' then
2314: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
2315: ELSE
2316: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
2317: END IF;
2318:

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

2312:
2313: IF upper(p_action) = 'CREATE' then
2314: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
2315: ELSE
2316: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
2317: END IF;
2318:
2319: get_lac_dtls(l_pa_request_id,
2320: l_lac_sf52_rec);

Line 2625: ghr_mto_int.log_message(

2621:
2622: ghr_validate_perwsdpo.validate_perwsdpo(l_position_id,l_effective_date);
2623: ghr_validate_perwsdpo.update_posn_status(l_position_id,l_effective_date);
2624:
2625: ghr_mto_int.log_message(
2626: p_procedure => 'Successful Completion',
2627: p_message => 'Vacant Position : '||l_pos_name ||
2628: ' Mass Table Change : '||
2629: p_mass_salary ||' Vacant pos Successfully completed');

Line 2649: ghr_mto_int.log_message(

2645: **************************/
2646: exception when others then
2647: l_mtcerrbuf := 'Error in ghr_sf52_pos_UPDATE.UPDATE_position_info' ||
2648: ' Sql Err is '|| sqlerrm(sqlcode);
2649: ghr_mto_int.log_message(
2650: p_procedure => 'Failed',
2651: p_message => 'Vacant Position : '||l_pos_name ||
2652: ' Mass Table Change : '||
2653: p_mass_salary || l_mtcerrbuf);

Line 2714: ghr_mto_int.log_message(

2710: commit;
2711: END IF;
2712:
2713: begin
2714: ghr_mto_int.log_message(
2715: p_procedure => g_proc,
2716: p_message => l_log_text);
2717:
2718: exception

Line 3633: ghr_mto_int.log_message(

3629: l_action_taken := pa_hist_rec.action_taken;
3630: exit;
3631: end loop;
3632: if l_action_taken <> 'CANCELED' then
3633: ghr_mto_int.log_message(
3634: p_procedure => 'RPA Exists Already',
3635: p_message => 'Name: '|| l_name || ' - Salary Change ' ||
3636: ' RPA Exists for the given FWS pay_lan and effective date' );
3637: return true;

Line 3655: ghr_mto_int.log_message(

3651: l_action_taken := pa_hist_rec.action_taken;
3652: exit;
3653: end loop;
3654: if l_action_taken <> 'CANCELED' then
3655: ghr_mto_int.log_message(
3656: p_procedure => 'RPA Exists Already',
3657: p_message => 'Name: '|| l_name || ' - Salary Change ' ||
3658: ' RPA Exists for the given effective date ' );
3659: return true;

Line 3807: ghr_mto_int.log_message(

3803: l_action_taken := pa_hist_rec.action_taken;
3804: exit;
3805: end loop;
3806: if l_action_taken <> 'CANCELED' then
3807: ghr_mto_int.log_message(
3808: p_procedure => 'RPA Exists Already',
3809: p_message => 'Name: '|| l_name || ' - Mass Table Change ' ||
3810: ' RPA Exists for the given FWS pay_lan and effective date' );
3811: return true;

Line 3829: ghr_mto_int.log_message(

3825: l_action_taken := pa_hist_rec.action_taken;
3826: exit;
3827: end loop;
3828: if l_action_taken <> 'CANCELED' then
3829: ghr_mto_int.log_message(
3830: p_procedure => 'RPA Exists Already',
3831: p_message => 'Name: '|| l_name || ' - Mass Table Change ' ||
3832: ' RPA Exists for the given effective date ' );
3833: return true;

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

5490: -- g_no := g_no +1;
5491: -- insert into l_tmp values (g_no,substr(msg||'-'||par1||' -'||par2||'-',1,199));
5492: -- DBMS_OUTPUT.PUT_LINE(msg||'-'||par1||' -'||par2||'-');
5493:
5494: ghr_mto_int.put_line(msg||'-'||par1||' -'||par2||'-');
5495: exception
5496: when others then
5497: hr_utility.set_location('Error in pr '||' Err is '||sqlerrm(sqlcode),20);
5498: l_mlcerrbuf := 'Error in pr Sql Err is '|| sqlerrm(sqlcode);

Line 5557: ghr_mto_int.log_message(

5553: end loop;
5554:
5555: if l_action_taken <> 'CANCELED' then
5556: IF upper(p_action) IN ('SHOW','REPORT') THEN
5557: ghr_mto_int.log_message(
5558: p_procedure => 'RPA Exists Already',
5559: p_message => 'Name: '|| l_name || ' - Salary Change ' ||
5560: ' RPA Exists for the given effective date ' );
5561: END IF;