DBA Data[Home] [Help]

APPS.GHR_MTO_PKG dependencies on GHR_MTO_INT

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

544: l_ind := 10;
545: --7186094
546: l_insert_log := 'Y';
547: pr('Before set log');
548: --ghr_mto_int.set_log_program_name('Mass Transfer OUT');
549: pr('After set log');
550:
551: BEGIN
552: FOR mto IN ghr_mto (p_mass_transfer_id)

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

585: raise mass_error;
586: END;
587:
588: IF upper(p_action) = 'CREATE' then
589: ghr_mto_int.set_log_program_name('GHR_MTO_PKG');
590: ELSE
591: ghr_mto_int.set_log_program_name('MTO_'||p_mass_transfer_name);
592: END IF;
593:

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

587:
588: IF upper(p_action) = 'CREATE' then
589: ghr_mto_int.set_log_program_name('GHR_MTO_PKG');
590: ELSE
591: ghr_mto_int.set_log_program_name('MTO_'||p_mass_transfer_name);
592: END IF;
593:
594: IF upper(p_action) = 'CREATE' then
595: if l_pa_request_id is null then

Line 758: ghr_mto_int.mass_transfer_out (

754: p_mass_transfer_id,
755: l_sel_flg) then
756: begin
757: l_errbuf := null;
758: ghr_mto_int.mass_transfer_out (
759: l_errbuf,
760: l_retcode,
761: p_mass_transfer_id,
762: per.person_id);

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

761: p_mass_transfer_id,
762: per.person_id);
763:
764: if l_errbuf is not null then
765: pr('Error in ghr_mto_int.mass_transfer_out'||l_errbuf);
766: hr_utility.set_location
767: ('Error in ghr_mto_int.mass_transfer_out'||
768: 'Err is '||l_errbuf,20);
769: l_mass_errbuf := 'Error in ghr_mto_int.mass_transfer_out'||

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

763:
764: if l_errbuf is not null then
765: pr('Error in ghr_mto_int.mass_transfer_out'||l_errbuf);
766: hr_utility.set_location
767: ('Error in ghr_mto_int.mass_transfer_out'||
768: 'Err is '||l_errbuf,20);
769: l_mass_errbuf := 'Error in ghr_mto_int.mass_transfer_out'||
770: ' Err is '|| l_errbuf;
771: raise mass_error;

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

765: pr('Error in ghr_mto_int.mass_transfer_out'||l_errbuf);
766: hr_utility.set_location
767: ('Error in ghr_mto_int.mass_transfer_out'||
768: 'Err is '||l_errbuf,20);
769: l_mass_errbuf := 'Error in ghr_mto_int.mass_transfer_out'||
770: ' Err is '|| l_errbuf;
771: raise mass_error;
772: end if;
773: exception

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

775: when others then null;
776: pr('Error in create sf52 - Err is '||
777: l_errbuf||' '||to_char(l_retcode));
778: pr('Err is '||sqlerrm(sqlcode));
779: l_mass_errbuf := 'Error in ghr_mto_int.mass_transfer_out'||
780: ' Sql Err is '|| sqlerrm(sqlcode);
781: raise mass_error;
782: end;
783: end if;

Line 984: ghr_mto_int.mass_transfer_out (

980:
981: elsif upper(p_action) = 'DUMP OUT' then
982: begin
983: l_errbuf := null;
984: ghr_mto_int.mass_transfer_out (
985: l_errbuf,
986: l_retcode,
987: p_mass_transfer_id,
988: per.person_id);

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

987: p_mass_transfer_id,
988: per.person_id);
989:
990: if l_errbuf is not null then
991: pr('Error in ghr_mto_int.mass_transfer_out'||
992: l_errbuf);
993: hr_utility.set_location
994: ('Error in ghr_mto_int.mass_transfer_out'||
995: 'Err is '||l_errbuf,20);

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

990: if l_errbuf is not null then
991: pr('Error in ghr_mto_int.mass_transfer_out'||
992: l_errbuf);
993: hr_utility.set_location
994: ('Error in ghr_mto_int.mass_transfer_out'||
995: 'Err is '||l_errbuf,20);
996: l_mass_errbuf :=
997: 'Error in ghr_mto_int.mass_transfer_out'||
998: ' Err is '|| l_errbuf;

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

993: hr_utility.set_location
994: ('Error in ghr_mto_int.mass_transfer_out'||
995: 'Err is '||l_errbuf,20);
996: l_mass_errbuf :=
997: 'Error in ghr_mto_int.mass_transfer_out'||
998: ' Err is '|| l_errbuf;
999: raise mass_error;
1000: end if;
1001: exception

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

1004: pr('Error in create sf52 - Err is '||
1005: l_errbuf||' '||to_char(l_retcode));
1006: pr('Err is '||sqlerrm(sqlcode));
1007: l_mass_errbuf :=
1008: 'Error in ghr_mto_int.mass_transfer_out'||
1009: ' Sql Err is '|| sqlerrm(sqlcode);
1010: raise mass_error;
1011: end;
1012: l_ind := 180;

Line 1161: ghr_mto_int.log_message(

1157: pr('No error in create sf52 sel flg is '||l_sel_flg);
1158: hr_utility.set_location('Before commiting',2);
1159:
1160: --Bug # 9329643 Modified SSN to Emp No
1161: ghr_mto_int.log_message(
1162: p_procedure => 'Successful Completion',
1163: p_message =>
1164: 'Name: '||per.full_name ||' Emp No: '||
1165: per.employee_number|| ' Mass Transfer : '||

Line 1234: ghr_mto_int.log_message(

1230: l_mass_errbuf;
1231: hr_utility.set_location('before creating entry in log file',10);
1232: l_recs_failed := l_recs_failed + 1;
1233: begin
1234: ghr_mto_int.log_message(
1235: p_procedure => g_proc,
1236: p_message => l_log_text);
1237: end;
1238: end if;

Line 1258: ghr_mto_int.log_message(

1254: ' Sql Err is '||sqlerrm(sqlcode);
1255: hr_utility.set_location('before creating entry in log file',20);
1256: l_recs_failed := l_recs_failed + 1;
1257: begin
1258: ghr_mto_int.log_message(
1259: p_procedure => g_proc,
1260: p_message => l_log_text);
1261: end;
1262: END;

Line 1532: ghr_mto_int.log_message(

1528: (l_position_data_rec);
1529:
1530: upd_ext_info_to_null(per_vacant.position_id);
1531:
1532: ghr_mto_int.log_message(
1533: p_procedure => 'Successful Completion',
1534: p_message =>
1535: 'Vacant Position : '||l_position_title
1536: || ' Mass Transfer : '||

Line 1587: ghr_mto_int.log_message(

1583:
1584: l_log_text := ' Error(s) occurred during creation of the Interface Records for few employees.'||
1585: ' To process the Mass Transfer Out for that employees, correct the error(s) reported' ||
1586: ' in the Process Log ';
1587: ghr_mto_int.log_message(
1588: p_procedure => 'Interface Generation Failed',
1589: p_message => l_log_text);
1590:
1591: ELSE

Line 1606: ghr_mto_int.log_message(

1602: l_log_text := ' Error(s) occurred during creation of the Interface Records.'||
1603: ' To process the Mass Transfer Out, correct the error(s) reported' ||
1604: ' in the Process Log or deselect the employees from the' ||
1605: ' Mass Transfer Out Preview before executing.';
1606: ghr_mto_int.log_message(
1607: p_procedure => 'Interface Generation Failed',
1608: p_message => l_log_text);
1609: END IF;
1610: END IF;

Line 1638: ghr_mto_int.log_message(

1634: IF l_mass_errbuf NOT LIKE 'DUMP OUT Failed%' THEN
1635: l_log_text := 'Error in '||l_proc||' '||
1636: ' For Mass Transfer Name : '||p_mass_transfer_name||
1637: l_mass_errbuf;
1638: ghr_mto_int.log_message(
1639: p_procedure => g_proc,
1640: p_message => l_log_text);
1641: END IF;
1642: when others then

Line 1662: ghr_mto_int.log_message(

1658: p_errbuf := 'Error in '||l_proc || 'Details in GHR_PROCESS_LOG';
1659: p_retcode := 2;
1660: hr_utility.set_location('before creating entry in log file',30);
1661: begin
1662: ghr_mto_int.log_message(
1663: p_procedure => g_proc,
1664: p_message => l_log_text);
1665: end;
1666: END EXECUTE_MTO;