DBA Data[Home] [Help]

APPS.GHR_MTO_PKG dependencies on GHR_MTO_INT

Line 507: --ghr_mto_int.set_log_program_name('Mass Transfer OUT');

503: pr('Mass Transfer id is '||p_mass_transfer_id,' Action is '|| p_action);
504: hr_utility.set_location('Entering ' || l_proc,5);
505: l_ind := 10;
506: pr('Before set log');
507: --ghr_mto_int.set_log_program_name('Mass Transfer OUT');
508: pr('After set log');
509:
510: BEGIN
511: FOR mto IN ghr_mto (p_mass_transfer_id)

Line 548: ghr_mto_int.set_log_program_name('GHR_MTO_PKG');

544: raise mass_error;
545: END;
546:
547: IF upper(p_action) = 'CREATE' then
548: ghr_mto_int.set_log_program_name('GHR_MTO_PKG');
549: ELSE
550: ghr_mto_int.set_log_program_name('MTO_'||p_mass_transfer_name);
551: END IF;
552:

Line 550: ghr_mto_int.set_log_program_name('MTO_'||p_mass_transfer_name);

546:
547: IF upper(p_action) = 'CREATE' then
548: ghr_mto_int.set_log_program_name('GHR_MTO_PKG');
549: ELSE
550: ghr_mto_int.set_log_program_name('MTO_'||p_mass_transfer_name);
551: END IF;
552:
553: IF upper(p_action) = 'CREATE' then
554: if l_pa_request_id is null then

Line 710: ghr_mto_int.mass_transfer_out (

706: p_mass_transfer_id,
707: l_sel_flg) then
708: begin
709: l_errbuf := null;
710: ghr_mto_int.mass_transfer_out (
711: l_errbuf,
712: l_retcode,
713: p_mass_transfer_id,
714: per.person_id);

Line 717: pr('Error in ghr_mto_int.mass_transfer_out'||l_errbuf);

713: p_mass_transfer_id,
714: per.person_id);
715:
716: if l_errbuf is not null then
717: pr('Error in ghr_mto_int.mass_transfer_out'||l_errbuf);
718: hr_utility.set_location
719: ('Error in ghr_mto_int.mass_transfer_out'||
720: 'Err is '||l_errbuf,20);
721: l_mass_errbuf := 'Error in ghr_mto_int.mass_transfer_out'||

Line 719: ('Error in ghr_mto_int.mass_transfer_out'||

715:
716: if l_errbuf is not null then
717: pr('Error in ghr_mto_int.mass_transfer_out'||l_errbuf);
718: hr_utility.set_location
719: ('Error in ghr_mto_int.mass_transfer_out'||
720: 'Err is '||l_errbuf,20);
721: l_mass_errbuf := 'Error in ghr_mto_int.mass_transfer_out'||
722: ' Err is '|| l_errbuf;
723: raise mass_error;

Line 721: l_mass_errbuf := 'Error in ghr_mto_int.mass_transfer_out'||

717: pr('Error in ghr_mto_int.mass_transfer_out'||l_errbuf);
718: hr_utility.set_location
719: ('Error in ghr_mto_int.mass_transfer_out'||
720: 'Err is '||l_errbuf,20);
721: l_mass_errbuf := 'Error in ghr_mto_int.mass_transfer_out'||
722: ' Err is '|| l_errbuf;
723: raise mass_error;
724: end if;
725: exception

Line 731: l_mass_errbuf := 'Error in ghr_mto_int.mass_transfer_out'||

727: when others then null;
728: pr('Error in create sf52 - Err is '||
729: l_errbuf||' '||to_char(l_retcode));
730: pr('Err is '||sqlerrm(sqlcode));
731: l_mass_errbuf := 'Error in ghr_mto_int.mass_transfer_out'||
732: ' Sql Err is '|| sqlerrm(sqlcode);
733: raise mass_error;
734: end;
735: end if;

Line 917: ghr_mto_int.mass_transfer_out (

913:
914: elsif upper(p_action) = 'DUMP OUT' then
915: begin
916: l_errbuf := null;
917: ghr_mto_int.mass_transfer_out (
918: l_errbuf,
919: l_retcode,
920: p_mass_transfer_id,
921: per.person_id);

Line 924: pr('Error in ghr_mto_int.mass_transfer_out'||

920: p_mass_transfer_id,
921: per.person_id);
922:
923: if l_errbuf is not null then
924: pr('Error in ghr_mto_int.mass_transfer_out'||
925: l_errbuf);
926: hr_utility.set_location
927: ('Error in ghr_mto_int.mass_transfer_out'||
928: 'Err is '||l_errbuf,20);

Line 927: ('Error in ghr_mto_int.mass_transfer_out'||

923: if l_errbuf is not null then
924: pr('Error in ghr_mto_int.mass_transfer_out'||
925: l_errbuf);
926: hr_utility.set_location
927: ('Error in ghr_mto_int.mass_transfer_out'||
928: 'Err is '||l_errbuf,20);
929: l_mass_errbuf :=
930: 'Error in ghr_mto_int.mass_transfer_out'||
931: ' Err is '|| l_errbuf;

Line 930: 'Error in ghr_mto_int.mass_transfer_out'||

926: hr_utility.set_location
927: ('Error in ghr_mto_int.mass_transfer_out'||
928: 'Err is '||l_errbuf,20);
929: l_mass_errbuf :=
930: 'Error in ghr_mto_int.mass_transfer_out'||
931: ' Err is '|| l_errbuf;
932: raise mass_error;
933: end if;
934: exception

Line 941: 'Error in ghr_mto_int.mass_transfer_out'||

937: pr('Error in create sf52 - Err is '||
938: l_errbuf||' '||to_char(l_retcode));
939: pr('Err is '||sqlerrm(sqlcode));
940: l_mass_errbuf :=
941: 'Error in ghr_mto_int.mass_transfer_out'||
942: ' Sql Err is '|| sqlerrm(sqlcode);
943: raise mass_error;
944: end;
945: l_ind := 180;

Line 1093: ghr_mto_int.log_message(

1089: if l_errbuf is null then
1090: pr('No error in create sf52 sel flg is '||l_sel_flg);
1091: hr_utility.set_location('Before commiting',2);
1092:
1093: ghr_mto_int.log_message(
1094: p_procedure => 'Successful Completion',
1095: p_message =>
1096: 'Name: '||per.full_name ||' SSN: '||
1097: per.national_identifier|| ' Mass Transfer : '||

Line 1162: ghr_mto_int.log_message(

1158: l_mass_errbuf;
1159: hr_utility.set_location('before creating entry in log file',10);
1160: l_recs_failed := l_recs_failed + 1;
1161: begin
1162: ghr_mto_int.log_message(
1163: p_procedure => g_proc,
1164: p_message => l_log_text);
1165: end;
1166: WHEN others then

Line 1184: ghr_mto_int.log_message(

1180: ' Sql Err is '||sqlerrm(sqlcode);
1181: hr_utility.set_location('before creating entry in log file',20);
1182: l_recs_failed := l_recs_failed + 1;
1183: begin
1184: ghr_mto_int.log_message(
1185: p_procedure => g_proc,
1186: p_message => l_log_text);
1187: end;
1188: END;

Line 1427: ghr_mto_int.log_message(

1423: (l_position_data_rec);
1424:
1425: upd_ext_info_to_null(per_vacant.position_id);
1426:
1427: ghr_mto_int.log_message(
1428: p_procedure => 'Successful Completion',
1429: p_message =>
1430: 'Vacant Position : '||l_position_title
1431: || ' Mass Transfer : '||

Line 1482: ghr_mto_int.log_message(

1478:
1479: l_log_text := ' Error(s) occurred during creation of the Interface Records for few employees.'||
1480: ' To process the Mass Transfer Out for that employees, correct the error(s) reported' ||
1481: ' in the Process Log ';
1482: ghr_mto_int.log_message(
1483: p_procedure => 'Interface Generation Failed',
1484: p_message => l_log_text);
1485:
1486: ELSE

Line 1501: ghr_mto_int.log_message(

1497: l_log_text := ' Error(s) occurred during creation of the Interface Records.'||
1498: ' To process the Mass Transfer Out, correct the error(s) reported' ||
1499: ' in the Process Log or deselect the employees from the' ||
1500: ' Mass Transfer Out Preview before executing.';
1501: ghr_mto_int.log_message(
1502: p_procedure => 'Interface Generation Failed',
1503: p_message => l_log_text);
1504: END IF;
1505: END IF;

Line 1533: ghr_mto_int.log_message(

1529: IF l_mass_errbuf NOT LIKE 'DUMP OUT Failed%' THEN
1530: l_log_text := 'Error in '||l_proc||' '||
1531: ' For Mass Transfer Name : '||p_mass_transfer_name||
1532: l_mass_errbuf;
1533: ghr_mto_int.log_message(
1534: p_procedure => g_proc,
1535: p_message => l_log_text);
1536: END IF;
1537: when others then

Line 1557: ghr_mto_int.log_message(

1553: p_errbuf := 'Error in '||l_proc || 'Details in GHR_PROCESS_LOG';
1554: p_retcode := 2;
1555: hr_utility.set_location('before creating entry in log file',30);
1556: begin
1557: ghr_mto_int.log_message(
1558: p_procedure => g_proc,
1559: p_message => l_log_text);
1560: end;
1561: END EXECUTE_MTO;