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_SF52_API dependencies on HR_UTILITY

Line 421: hr_utility.set_location('Entering:'|| l_proc, 5);

417: --Bug# 6127620
418: -- l_curr_sess_date fnd_sessions.effective_date%type;
419:
420: begin
421: hr_utility.set_location('Entering:'|| l_proc, 5);
422:
423: -- Issue a savepoint if operating in validation only mode.
424: -- if p_validate then
425: savepoint create_sf52;

Line 661: hr_utility.set_location(l_proc, 6);

657: end;
658: --
659: -- End of Before Process User Hook call
660: --
661: hr_utility.set_location(l_proc, 6);
662: -- Process Logic
663:
664: -- If the SF52 is processed for the person same as the user, then do not allow creation
665:

Line 670: hr_utility.set_message(8301,'GHR_38503_CANNOT_INIT_FOR_SELF');

666: If p_person_id is not null then
667: -- get employee_id of the user
668: for user_id in c_user_emp_names loop
669: If user_id.employee_id = p_person_id then
670: hr_utility.set_message(8301,'GHR_38503_CANNOT_INIT_FOR_SELF');
671: hr_utility.raise_error;
672: End if;
673: end loop;
674: End if;

Line 671: hr_utility.raise_error;

667: -- get employee_id of the user
668: for user_id in c_user_emp_names loop
669: If user_id.employee_id = p_person_id then
670: hr_utility.set_message(8301,'GHR_38503_CANNOT_INIT_FOR_SELF');
671: hr_utility.raise_error;
672: End if;
673: end loop;
674: End if;
675:

Line 683: hr_utility.set_location('approval date is not null',1);

679:
680: If nvl(p_1_approval_status,hr_api.g_varchar2) = 'APPROVE' then
681: If p_approval_date is null
682: then
683: hr_utility.set_location('approval date is not null',1);
684: l_effective_date := trunc(sysdate);
685: l_approval_date := sysdate;
686: -- get the full_name of the approver - format First Name MiddleName. Last Name -- p_user_name_acted_on
687: for user_emp_name in c_user_emp_names loop

Line 746: hr_utility.set_location('appr name ' || l_approving_official_full_name,1);

742: -- Insert a row into pa_requests by calling the ins row handler
743:
744: l_pa_request_id := p_pa_request_id;
745: l_effective_date := trunc(nvl(p_effective_date,sysdate));
746: hr_utility.set_location('appr name ' || l_approving_official_full_name,1);
747: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);
748: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);
749:
750: ghr_par_ins.ins

Line 747: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);

743:
744: l_pa_request_id := p_pa_request_id;
745: l_effective_date := trunc(nvl(p_effective_date,sysdate));
746: hr_utility.set_location('appr name ' || l_approving_official_full_name,1);
747: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);
748: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);
749:
750: ghr_par_ins.ins
751: (

Line 748: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);

744: l_pa_request_id := p_pa_request_id;
745: l_effective_date := trunc(nvl(p_effective_date,sysdate));
746: hr_utility.set_location('appr name ' || l_approving_official_full_name,1);
747: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);
748: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);
749:
750: ghr_par_ins.ins
751: (
752: p_pa_request_id => l_pa_request_id,

Line 974: hr_utility.set_location(l_proc, 8);

970: p_award_salary => p_award_salary
971: -- Bug#4486823 RRR Changes
972: );
973: p_par_object_version_number := l_par_object_version_number ;
974: hr_utility.set_location(l_proc, 8);
975:
976:
977: --2) Write into pa_remarks all mandatory remarks for the specific nature_of_action (first and second)
978:

Line 1145: hr_utility.set_location('passed action taken ' ||p_1_action_taken,1);

1141: end if;
1142:
1143: -- If action_taken is null then ,derive the action_taken
1144:
1145: hr_utility.set_location('passed action taken ' ||p_1_action_taken,1);
1146: l_action_taken := p_1_action_taken;
1147: if l_action_taken is null then
1148: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1149: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then

Line 1155: hr_utility.set_location('Bef c_history_exists ' ||l_pa_request_id,2);

1151: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1152: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
1153: l_action_taken := 'REQUESTED';
1154: else
1155: hr_utility.set_location('Bef c_history_exists ' ||l_pa_request_id,2);
1156: for history_exists in C_history_exists loop
1157: l_exists := true;
1158: exit;
1159: end loop;

Line 1172: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');

1168: -- added END_ROUTING to the following if stmt.
1169: if l_action_taken not in('NOT_ROUTED','INITIATED','REQUESTED','AUTHORIZED',
1170: 'NO_ACTION','REVIEWED','CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE', 'END_ROUTING')
1171: then
1172: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');
1173: hr_utility.raise_error;
1174: end if;
1175:
1176:

Line 1173: hr_utility.raise_error;

1169: if l_action_taken not in('NOT_ROUTED','INITIATED','REQUESTED','AUTHORIZED',
1170: 'NO_ACTION','REVIEWED','CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE', 'END_ROUTING')
1171: then
1172: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');
1173: hr_utility.raise_error;
1174: end if;
1175:
1176:
1177: ghr_sf52_api.get_par_status

Line 1198: hr_utility.set_location('check ' ||l_action_taken,3);

1194:
1195: -- to check if there is any routing information, if required.
1196: /***dk***/
1197: -- added END_ROUTING to the following if stmt.
1198: hr_utility.set_location('check ' ||l_action_taken,3);
1199: hr_utility.set_location('p_2_user_name_routed_to ' ||p_2_user_name_routed_to,4);
1200: hr_utility.set_location('p_2_groupbox_id ' ||p_2_groupbox_id,5);
1201: hr_utility.set_location('p_2_routing_list_id ' ||p_2_routing_list_id,6);
1202: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','END_ROUTING') then

Line 1199: hr_utility.set_location('p_2_user_name_routed_to ' ||p_2_user_name_routed_to,4);

1195: -- to check if there is any routing information, if required.
1196: /***dk***/
1197: -- added END_ROUTING to the following if stmt.
1198: hr_utility.set_location('check ' ||l_action_taken,3);
1199: hr_utility.set_location('p_2_user_name_routed_to ' ||p_2_user_name_routed_to,4);
1200: hr_utility.set_location('p_2_groupbox_id ' ||p_2_groupbox_id,5);
1201: hr_utility.set_location('p_2_routing_list_id ' ||p_2_routing_list_id,6);
1202: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','END_ROUTING') then
1203: if p_2_user_name_routed_to is null and

Line 1200: hr_utility.set_location('p_2_groupbox_id ' ||p_2_groupbox_id,5);

1196: /***dk***/
1197: -- added END_ROUTING to the following if stmt.
1198: hr_utility.set_location('check ' ||l_action_taken,3);
1199: hr_utility.set_location('p_2_user_name_routed_to ' ||p_2_user_name_routed_to,4);
1200: hr_utility.set_location('p_2_groupbox_id ' ||p_2_groupbox_id,5);
1201: hr_utility.set_location('p_2_routing_list_id ' ||p_2_routing_list_id,6);
1202: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','END_ROUTING') then
1203: if p_2_user_name_routed_to is null and
1204: p_2_groupbox_id is null and

Line 1201: hr_utility.set_location('p_2_routing_list_id ' ||p_2_routing_list_id,6);

1197: -- added END_ROUTING to the following if stmt.
1198: hr_utility.set_location('check ' ||l_action_taken,3);
1199: hr_utility.set_location('p_2_user_name_routed_to ' ||p_2_user_name_routed_to,4);
1200: hr_utility.set_location('p_2_groupbox_id ' ||p_2_groupbox_id,5);
1201: hr_utility.set_location('p_2_routing_list_id ' ||p_2_routing_list_id,6);
1202: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','END_ROUTING') then
1203: if p_2_user_name_routed_to is null and
1204: p_2_groupbox_id is null and
1205: p_2_routing_list_id is null then

Line 1206: hr_utility.set_message(8301,'GHR_38115_ROUT_INFO_REQD');

1202: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','END_ROUTING') then
1203: if p_2_user_name_routed_to is null and
1204: p_2_groupbox_id is null and
1205: p_2_routing_list_id is null then
1206: hr_utility.set_message(8301,'GHR_38115_ROUT_INFO_REQD');
1207: hr_utility.raise_error;
1208: end if;
1209: end if;
1210:

Line 1207: hr_utility.raise_error;

1203: if p_2_user_name_routed_to is null and
1204: p_2_groupbox_id is null and
1205: p_2_routing_list_id is null then
1206: hr_utility.set_message(8301,'GHR_38115_ROUT_INFO_REQD');
1207: hr_utility.raise_error;
1208: end if;
1209: end if;
1210:
1211: -- write the first record into the routing history (actions done by the user)

Line 1265: hr_utility.set_message(8301,'GHR_38114_NO_MORE_SEQ_NUMBER' );

1261: exit;
1262: end loop;
1263:
1264: if l_2_routing_seq_number is null then
1265: hr_utility.set_message(8301,'GHR_38114_NO_MORE_SEQ_NUMBER' );
1266: hr_utility.raise_error;
1267: end if;
1268:
1269: end if;

Line 1266: hr_utility.raise_error;

1262: end loop;
1263:
1264: if l_2_routing_seq_number is null then
1265: hr_utility.set_message(8301,'GHR_38114_NO_MORE_SEQ_NUMBER' );
1266: hr_utility.raise_error;
1267: end if;
1268:
1269: end if;
1270:

Line 1290: hr_utility.set_message(8301,'GHR_38592_OPEN_EVENTS_EXIST');

1286: p_message_set => l_message
1287: );
1288:
1289: if l_message then
1290: hr_utility.set_message(8301,'GHR_38592_OPEN_EVENTS_EXIST');
1291: hr_utility.raise_error;
1292: end if;
1293:
1294: --Insert 2nd record into routing_history for routing details

Line 1291: hr_utility.raise_error;

1287: );
1288:
1289: if l_message then
1290: hr_utility.set_message(8301,'GHR_38592_OPEN_EVENTS_EXIST');
1291: hr_utility.raise_error;
1292: end if;
1293:
1294: --Insert 2nd record into routing_history for routing details
1295: -- (exception when routing_status = 'NOT_ROUTED' or 'UPDATE_HR','FUTURE_ACTION','END_ROUTING')

Line 1551: hr_utility.set_message(8301,'GHR_38185_EFF_DATE_REQUIRED');

1547:
1548:
1549:
1550: IF l_rec.effective_date is null THEN
1551: hr_utility.set_message(8301,'GHR_38185_EFF_DATE_REQUIRED');
1552: ghr_upd_hr_validation.form_item_name := 'PAR.EFFECTIVE_DATE';
1553: hr_utility.raise_error;
1554: END IF;
1555: if (l_action_taken <> 'END_ROUTING') then

Line 1553: hr_utility.raise_error;

1549:
1550: IF l_rec.effective_date is null THEN
1551: hr_utility.set_message(8301,'GHR_38185_EFF_DATE_REQUIRED');
1552: ghr_upd_hr_validation.form_item_name := 'PAR.EFFECTIVE_DATE';
1553: hr_utility.raise_error;
1554: END IF;
1555: if (l_action_taken <> 'END_ROUTING') then
1556: ghr_process_sf52.process_sf52
1557: (p_sf52_data => l_rec

Line 1585: hr_utility.set_location('to pos id is '|| l_rec.to_position_id,1);

1581: );
1582: for ovn_rec in c_ovn loop
1583: l_rec.object_version_number := ovn_rec.object_version_number;
1584: end loop;
1585: hr_utility.set_location('to pos id is '|| l_rec.to_position_id,1);
1586: hr_utility.set_location('first noa code is '|| l_rec.first_noa_code,1);
1587:
1588: IF nvl(l_rec.first_noa_code,'9999') <> '002' THEN
1589: ghr_par_upd.upd

Line 1586: hr_utility.set_location('first noa code is '|| l_rec.first_noa_code,1);

1582: for ovn_rec in c_ovn loop
1583: l_rec.object_version_number := ovn_rec.object_version_number;
1584: end loop;
1585: hr_utility.set_location('to pos id is '|| l_rec.to_position_id,1);
1586: hr_utility.set_location('first noa code is '|| l_rec.first_noa_code,1);
1587:
1588: IF nvl(l_rec.first_noa_code,'9999') <> '002' THEN
1589: ghr_par_upd.upd
1590: (p_pa_request_id => l_pa_request_id,

Line 1691: hr_utility.set_message(8301,'GHR_38112_INVALID_API');

1687: );
1688: end if;
1689: End if; -- Do not create routing history row for Mass Award Template
1690: Else
1691: hr_utility.set_message(8301,'GHR_38112_INVALID_API');
1692: hr_utility.raise_error;
1693: End if;
1694:
1695: If p_print_sf50_flag = 'Y' then

Line 1692: hr_utility.raise_error;

1688: end if;
1689: End if; -- Do not create routing history row for Mass Award Template
1690: Else
1691: hr_utility.set_message(8301,'GHR_38112_INVALID_API');
1692: hr_utility.raise_error;
1693: End if;
1694:
1695: If p_print_sf50_flag = 'Y' then
1696: -- Make sure that it only is valid while update_hr

Line 1698: hr_utility.set_message(8301,'GHR_38399_52_NOT_PROCESSED');

1694:
1695: If p_print_sf50_flag = 'Y' then
1696: -- Make sure that it only is valid while update_hr
1697: If l_action_taken <> 'UPDATE_HR' then
1698: hr_utility.set_message(8301,'GHR_38399_52_NOT_PROCESSED');
1699: hr_utility.raise_error;
1700: End if;
1701: --Bug#3757201 Added p_back_page parameter
1702: submit_request_to_print_50

Line 1699: hr_utility.raise_error;

1695: If p_print_sf50_flag = 'Y' then
1696: -- Make sure that it only is valid while update_hr
1697: If l_action_taken <> 'UPDATE_HR' then
1698: hr_utility.set_message(8301,'GHR_38399_52_NOT_PROCESSED');
1699: hr_utility.raise_error;
1700: End if;
1701: --Bug#3757201 Added p_back_page parameter
1702: submit_request_to_print_50
1703: (p_printer_name => p_printer_name,

Line 1961: hr_utility.set_location(' Leaving:'||l_proc, 11);

1957: -- Set all output arguments
1958: --
1959: p_pa_request_id := l_pa_request_id;
1960:
1961: hr_utility.set_location(' Leaving:'||l_proc, 11);
1962: exception
1963: when hr_api.validate_enabled then
1964: -- As the Validate_Enabled exception has been raised
1965: -- we must rollback to the savepoint

Line 1993: hr_utility.set_location(' Leaving:'||l_proc, 12);

1989: p_2_pa_routing_history_id := null;
1990: p_2_prh_object_version_number := null;
1991: raise;
1992:
1993: hr_utility.set_location(' Leaving:'||l_proc, 12);
1994: end create_sf52;
1995:
1996: -- ----------------------------------------------------------------------------
1997: -- |--------------------------< update_sf52>--------------------------|

Line 2518: hr_utility.set_location('Entering:'|| l_proc, 5);

2514: and nvl(noafam.end_date_active,to_date('4712/12/31','RRRR/MM/DD'));
2515: --End Bug# 7174094
2516:
2517: begin
2518: hr_utility.set_location('Entering:'|| l_proc, 5);
2519: --
2520: -- Issue a savepoint
2521: --
2522: savepoint update_sf52;

Line 2755: hr_utility.set_location(l_proc, 6);

2751: end;
2752: --
2753: -- End of Before Process User Hook call
2754: --
2755: hr_utility.set_location(l_proc, 6);
2756: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 7);
2757: --
2758: -- Validation in addition to Row Handlers
2759:

Line 2756: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 7);

2752: --
2753: -- End of Before Process User Hook call
2754: --
2755: hr_utility.set_location(l_proc, 6);
2756: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 7);
2757: --
2758: -- Validation in addition to Row Handlers
2759:
2760: -- If the SF52 is processed for the person same as the user, then do not allow creation

Line 2766: hr_utility.set_message(8301,'GHR_38503_CANNOT_INIT_FOR_SELF');

2762: If nvl(p_person_id,hr_api.g_number) <> hr_api.g_number then
2763: -- get employee_id of the user
2764: for user_id in c_names loop
2765: If user_id.employee_id = p_person_id then
2766: hr_utility.set_message(8301,'GHR_38503_CANNOT_INIT_FOR_SELF');
2767: hr_utility.raise_error;
2768: End if;
2769: end loop;
2770: End if;

Line 2767: hr_utility.raise_error;

2763: -- get employee_id of the user
2764: for user_id in c_names loop
2765: If user_id.employee_id = p_person_id then
2766: hr_utility.set_message(8301,'GHR_38503_CANNOT_INIT_FOR_SELF');
2767: hr_utility.raise_error;
2768: End if;
2769: end loop;
2770: End if;
2771:

Line 2787: hr_utility.set_message(8301,'GHR_38113_ROUT_GROUP_NON_UPD');

2783: l_cnt_history := cnt_of_history.cnt;
2784: exit;
2785: end loop;
2786: if nvl(l_cnt_history,0) > 1 then
2787: hr_utility.set_message(8301,'GHR_38113_ROUT_GROUP_NON_UPD');
2788: hr_utility.raise_error;
2789: end if;
2790: end if;
2791: end if;

Line 2788: hr_utility.raise_error;

2784: exit;
2785: end loop;
2786: if nvl(l_cnt_history,0) > 1 then
2787: hr_utility.set_message(8301,'GHR_38113_ROUT_GROUP_NON_UPD');
2788: hr_utility.raise_error;
2789: end if;
2790: end if;
2791: end if;
2792:

Line 2794: hr_utility.set_location('approval date ' || to_char(l_approval_date),1);

2790: end if;
2791: end if;
2792:
2793:
2794: hr_utility.set_location('approval date ' || to_char(l_approval_date),1);
2795: l_approval_date := p_approval_date;
2796: l_approving_official_work_titl := p_approving_official_work_titl;
2797: l_approving_official_full_name := p_approving_official_full_name;
2798:

Line 2799: hr_utility.set_location('approval_stat ' || p_u_approval_Status,1);

2795: l_approval_date := p_approval_date;
2796: l_approving_official_work_titl := p_approving_official_work_titl;
2797: l_approving_official_full_name := p_approving_official_full_name;
2798:
2799: hr_utility.set_location('approval_stat ' || p_u_approval_Status,1);
2800: If nvl(p_u_approval_status,hr_api.g_varchar2) = 'APPROVE' then
2801: If p_approval_date is null or p_approval_date = hr_api.g_date
2802: then
2803: hr_utility.set_location('approval date is not null',1);

Line 2803: hr_utility.set_location('approval date is not null',1);

2799: hr_utility.set_location('approval_stat ' || p_u_approval_Status,1);
2800: If nvl(p_u_approval_status,hr_api.g_varchar2) = 'APPROVE' then
2801: If p_approval_date is null or p_approval_date = hr_api.g_date
2802: then
2803: hr_utility.set_location('approval date is not null',1);
2804: l_effective_date := trunc(sysdate);
2805: l_approval_date := sysdate;
2806: -- get the full_name of the approver - format First Name MiddleName. Last Name -- p_user_name_acted_on
2807: for user_emp_name in c_names loop

Line 2869: hr_utility.set_location(l_proc, 7);

2865: End if;
2866: End if;
2867:
2868:
2869: hr_utility.set_location(l_proc, 7);
2870:
2871: l_par_object_version_number := p_par_object_version_number;
2872: l_effective_date := trunc(nvl(p_effective_date,sysdate));
2873:

Line 2879: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 8);

2875:
2876: -- Insert a row into pa_requests by calling the ins row handler
2877: l_object_version_number := p_par_object_version_number;
2878:
2879: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 8);
2880: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);
2881: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);
2882: -- Bug 2542417
2883: -- In some cases like Mass actions/Cancellation actions the assignment id and

Line 2880: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);

2876: -- Insert a row into pa_requests by calling the ins row handler
2877: l_object_version_number := p_par_object_version_number;
2878:
2879: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 8);
2880: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);
2881: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);
2882: -- Bug 2542417
2883: -- In some cases like Mass actions/Cancellation actions the assignment id and
2884: -- and effective_date are not available to fetch the capped other pay

Line 2881: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);

2877: l_object_version_number := p_par_object_version_number;
2878:
2879: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 8);
2880: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);
2881: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);
2882: -- Bug 2542417
2883: -- In some cases like Mass actions/Cancellation actions the assignment id and
2884: -- and effective_date are not available to fetch the capped other pay
2885: -- Below code fetches the effective_date and assignment id to be passed to

Line 2889: hr_utility.set_location('c_par.employee_assignment_id : '

2885: -- Below code fetches the effective_date and assignment id to be passed to
2886: -- ghr_pa_requests_pkg2.get_cop function
2887:
2888: for c_par in c_get_det_for_cop loop
2889: hr_utility.set_location('c_par.employee_assignment_id : '
2890: ||c_par.employee_assignment_id, 8);
2891: hr_utility.set_location('c_par.effective_date : '
2892: ||c_par.effective_date, 8);
2893: l_from_cop := nvl(ghr_pa_requests_pkg2.get_cop

Line 2891: hr_utility.set_location('c_par.effective_date : '

2887:
2888: for c_par in c_get_det_for_cop loop
2889: hr_utility.set_location('c_par.employee_assignment_id : '
2890: ||c_par.employee_assignment_id, 8);
2891: hr_utility.set_location('c_par.effective_date : '
2892: ||c_par.effective_date, 8);
2893: l_from_cop := nvl(ghr_pa_requests_pkg2.get_cop
2894: (nvl(p_employee_assignment_id,c_par.employee_assignment_id)
2895: ,c_par.effective_date)

Line 3119: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 1);

3115: p_mass_action_comments => p_mass_action_comments,
3116: p_payment_option => p_payment_option,
3117: p_award_salary => p_award_salary
3118: );
3119: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 1);
3120:
3121: hr_utility.set_location(l_proc || 'l_ovn' || to_char(l_par_object_version_number),2);
3122: p_par_object_version_number := l_par_object_version_number;
3123: hr_utility.set_location(l_proc, 8);

Line 3121: hr_utility.set_location(l_proc || 'l_ovn' || to_char(l_par_object_version_number),2);

3117: p_award_salary => p_award_salary
3118: );
3119: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 1);
3120:
3121: hr_utility.set_location(l_proc || 'l_ovn' || to_char(l_par_object_version_number),2);
3122: p_par_object_version_number := l_par_object_version_number;
3123: hr_utility.set_location(l_proc, 8);
3124:
3125: --2)Write into pa_remarks all mandatory remarks for the specific nature_of_action,

Line 3123: hr_utility.set_location(l_proc, 8);

3119: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 1);
3120:
3121: hr_utility.set_location(l_proc || 'l_ovn' || to_char(l_par_object_version_number),2);
3122: p_par_object_version_number := l_par_object_version_number;
3123: hr_utility.set_location(l_proc, 8);
3124:
3125: --2)Write into pa_remarks all mandatory remarks for the specific nature_of_action,
3126: -- in case of either a) first_nature_of_action is input for the first_time or (just insert new recds)
3127: -- b) first nature_of_action has changed (delete and then insert new records)

Line 3132: hr_utility.set_location(l_proc, 9);

3128: --
3129:
3130: if nvl(p_first_noa_id,hr_api.g_number)
3131: <> nvl(ghr_par_shd.g_old_rec.first_noa_id,hr_api.g_number) then
3132: hr_utility.set_location(l_proc, 9);
3133:
3134: -- delete the existing remarks
3135: delete from ghr_pa_remarks pre
3136: where pre.pa_request_id = p_pa_request_id

Line 3142: hr_utility.set_location(l_proc, 10);

3138: (select remark_id
3139: from ghr_noac_remarks
3140: where nature_of_action_id = ghr_par_shd.g_old_rec.first_noa_id);
3141: if p_first_noa_id is not null then
3142: hr_utility.set_location(l_proc, 10);
3143:
3144: insert into ghr_pa_remarks
3145: (pa_remark_id
3146: ,pa_request_id

Line 3308: hr_utility.set_location('update/ delete extra info',1);

3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3305: (nvl(p_to_position_id,hr_api.g_number)
3306: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3307: then
3308: hr_utility.set_location('update/ delete extra info',1);
3309:
3310:
3311: GHR_NON_SF52_EXTRA_INFO.populate_noa_spec_extra_info
3312: (p_pa_request_id => p_pa_request_id,

Line 3345: hr_utility.set_location(l_proc, 11);

3341: --3)Derive all parmeters required to insert routing_history records.
3342:
3343:
3344: l_action_taken := p_u_action_taken;
3345: hr_utility.set_location(l_proc, 11);
3346: if l_action_taken is null then
3347: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3348: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3349: l_action_taken := 'AUTHORIZED';

Line 3376: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');

3372: end if;
3373: if l_action_taken not in('NOT_ROUTED','INITIATED','REQUESTED','AUTHORIZED','END_ROUTING','ENDED',
3374: 'NO_ACTION','REVIEWED','CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NONE')
3375: then
3376: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');
3377: hr_utility.raise_error;
3378: end if;
3379: -- Bug #1285393 Modified to add the if condition as not to update the status
3380: -- if action taken parameter is passed as NONE. (NONE is passed during the call made

Line 3377: hr_utility.raise_error;

3373: if l_action_taken not in('NOT_ROUTED','INITIATED','REQUESTED','AUTHORIZED','END_ROUTING','ENDED',
3374: 'NO_ACTION','REVIEWED','CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NONE')
3375: then
3376: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');
3377: hr_utility.raise_error;
3378: end if;
3379: -- Bug #1285393 Modified to add the if condition as not to update the status
3380: -- if action taken parameter is passed as NONE. (NONE is passed during the call made
3381: -- in Cancellation of APPT Sf52 to cancel the RPA's made after Appointment)

Line 3395: hr_utility.set_location('befor upd of status' ,1);

3391: p_pa_request_id => p_pa_request_id,
3392: p_status => l_status
3393: );
3394:
3395: hr_utility.set_location('befor upd of status' ,1);
3396: ghr_par_upd.upd
3397: (p_pa_request_id => p_pa_request_id,
3398: p_status => l_status,
3399: p_object_version_number => l_par_object_version_number

Line 3402: hr_utility.set_location('l_status : ' || l_status,1);

3398: p_status => l_status,
3399: p_object_version_number => l_par_object_version_number
3400: );
3401: end if;
3402: hr_utility.set_location('l_status : ' || l_status,1);
3403: hr_utility.set_location('after upd of status' ,1);
3404: p_par_object_version_number := l_par_object_version_number;
3405: hr_utility.set_location('check ' ||l_action_taken,1);
3406: hr_utility.set_location('p_i_user_name_routed_to ' ||p_i_user_name_routed_to,1);

Line 3403: hr_utility.set_location('after upd of status' ,1);

3399: p_object_version_number => l_par_object_version_number
3400: );
3401: end if;
3402: hr_utility.set_location('l_status : ' || l_status,1);
3403: hr_utility.set_location('after upd of status' ,1);
3404: p_par_object_version_number := l_par_object_version_number;
3405: hr_utility.set_location('check ' ||l_action_taken,1);
3406: hr_utility.set_location('p_i_user_name_routed_to ' ||p_i_user_name_routed_to,1);
3407: hr_utility.set_location('p_i_groupbox_id ' ||p_i_groupbox_id,1);

Line 3405: hr_utility.set_location('check ' ||l_action_taken,1);

3401: end if;
3402: hr_utility.set_location('l_status : ' || l_status,1);
3403: hr_utility.set_location('after upd of status' ,1);
3404: p_par_object_version_number := l_par_object_version_number;
3405: hr_utility.set_location('check ' ||l_action_taken,1);
3406: hr_utility.set_location('p_i_user_name_routed_to ' ||p_i_user_name_routed_to,1);
3407: hr_utility.set_location('p_i_groupbox_id ' ||p_i_groupbox_id,1);
3408: hr_utility.set_location('p_i_routing_list_id ' ||p_i_routing_list_id,1);
3409:

Line 3406: hr_utility.set_location('p_i_user_name_routed_to ' ||p_i_user_name_routed_to,1);

3402: hr_utility.set_location('l_status : ' || l_status,1);
3403: hr_utility.set_location('after upd of status' ,1);
3404: p_par_object_version_number := l_par_object_version_number;
3405: hr_utility.set_location('check ' ||l_action_taken,1);
3406: hr_utility.set_location('p_i_user_name_routed_to ' ||p_i_user_name_routed_to,1);
3407: hr_utility.set_location('p_i_groupbox_id ' ||p_i_groupbox_id,1);
3408: hr_utility.set_location('p_i_routing_list_id ' ||p_i_routing_list_id,1);
3409:
3410: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','NONE','ENDED','END_ROUTING') then

Line 3407: hr_utility.set_location('p_i_groupbox_id ' ||p_i_groupbox_id,1);

3403: hr_utility.set_location('after upd of status' ,1);
3404: p_par_object_version_number := l_par_object_version_number;
3405: hr_utility.set_location('check ' ||l_action_taken,1);
3406: hr_utility.set_location('p_i_user_name_routed_to ' ||p_i_user_name_routed_to,1);
3407: hr_utility.set_location('p_i_groupbox_id ' ||p_i_groupbox_id,1);
3408: hr_utility.set_location('p_i_routing_list_id ' ||p_i_routing_list_id,1);
3409:
3410: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','NONE','ENDED','END_ROUTING') then
3411: if p_i_user_name_routed_to is null and

Line 3408: hr_utility.set_location('p_i_routing_list_id ' ||p_i_routing_list_id,1);

3404: p_par_object_version_number := l_par_object_version_number;
3405: hr_utility.set_location('check ' ||l_action_taken,1);
3406: hr_utility.set_location('p_i_user_name_routed_to ' ||p_i_user_name_routed_to,1);
3407: hr_utility.set_location('p_i_groupbox_id ' ||p_i_groupbox_id,1);
3408: hr_utility.set_location('p_i_routing_list_id ' ||p_i_routing_list_id,1);
3409:
3410: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','NONE','ENDED','END_ROUTING') then
3411: if p_i_user_name_routed_to is null and
3412: p_i_groupbox_id is null and

Line 3414: hr_utility.set_message(8301,'GHR_38115_ROUT_INFO_REQD');

3410: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','NONE','ENDED','END_ROUTING') then
3411: if p_i_user_name_routed_to is null and
3412: p_i_groupbox_id is null and
3413: p_i_routing_list_id is null then
3414: hr_utility.set_message(8301,'GHR_38115_ROUT_INFO_REQD');
3415: hr_utility.raise_error;
3416: end if;
3417: end if;
3418:

Line 3415: hr_utility.raise_error;

3411: if p_i_user_name_routed_to is null and
3412: p_i_groupbox_id is null and
3413: p_i_routing_list_id is null then
3414: hr_utility.set_message(8301,'GHR_38115_ROUT_INFO_REQD');
3415: hr_utility.raise_error;
3416: end if;
3417: end if;
3418:
3419: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','UPDATE_HR_COMPLETE','NONE','ENDED')then

Line 3420: hr_utility.set_location('check ' ||l_action_taken,1);

3416: end if;
3417: end if;
3418:
3419: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','UPDATE_HR_COMPLETE','NONE','ENDED')then
3420: hr_utility.set_location('check ' ||l_action_taken,1);
3421: hr_utility.set_location('check ' ||l_mass_action_id,1);
3422: hr_utility.set_location('Check ' || l_rpa_type,1);
3423: -- Do not routing history if Template record for Mass Actions.
3424:

Line 3421: hr_utility.set_location('check ' ||l_mass_action_id,1);

3417: end if;
3418:
3419: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','UPDATE_HR_COMPLETE','NONE','ENDED')then
3420: hr_utility.set_location('check ' ||l_action_taken,1);
3421: hr_utility.set_location('check ' ||l_mass_action_id,1);
3422: hr_utility.set_location('Check ' || l_rpa_type,1);
3423: -- Do not routing history if Template record for Mass Actions.
3424:
3425: -- If (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is not null --AVR

Line 3422: hr_utility.set_location('Check ' || l_rpa_type,1);

3418:
3419: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','UPDATE_HR_COMPLETE','NONE','ENDED')then
3420: hr_utility.set_location('check ' ||l_action_taken,1);
3421: hr_utility.set_location('check ' ||l_mass_action_id,1);
3422: hr_utility.set_location('Check ' || l_rpa_type,1);
3423: -- Do not routing history if Template record for Mass Actions.
3424:
3425: -- If (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is not null --AVR
3426: -- and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA') or --AVR

Line 3431: hr_utility.set_location('Form Folder Updation ..Do not route ' ,1); --AVR

3427: -- (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null) then --AVR
3428:
3429: if nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' then --AVR
3430: if (nvl(l_rpa_type,hr_api.g_varchar2) = 'A' and l_action_taken = 'NOT_ROUTED' ) then --AVR
3431: hr_utility.set_location('Form Folder Updation ..Do not route ' ,1); --AVR
3432: else --AVR
3433:
3434: for cur_routing_history_id in C_routing_history_id loop
3435: l_u_pa_routing_history_id := cur_routing_history_id.pa_routing_history_id;

Line 3439: hr_utility.set_location('in update sf52 api , user acted on is ' || p_u_user_name_acted_on,1);

3435: l_u_pa_routing_history_id := cur_routing_history_id.pa_routing_history_id;
3436: l_u_prh_object_version_number := cur_routing_history_id.object_version_number;
3437: exit;
3438: end loop;
3439: hr_utility.set_location('in update sf52 api , user acted on is ' || p_u_user_name_acted_on,1);
3440: if p_u_user_name_acted_on is not null
3441: -- RP
3442: and p_u_user_name_acted_on <> hr_api.g_varchar2 then
3443: hr_utility.set_location(l_proc, 12);

Line 3443: hr_utility.set_location(l_proc, 12);

3439: hr_utility.set_location('in update sf52 api , user acted on is ' || p_u_user_name_acted_on,1);
3440: if p_u_user_name_acted_on is not null
3441: -- RP
3442: and p_u_user_name_acted_on <> hr_api.g_varchar2 then
3443: hr_utility.set_location(l_proc, 12);
3444:
3445: ghr_pa_requests_pkg.get_roles
3446: (p_pa_request_id,
3447: p_routing_group_id,

Line 3456: hr_utility.set_location(l_proc, 13);

3452: l_personnelist_flag,
3453: l_approver_flag,
3454: l_reviewer_flag
3455: );
3456: hr_utility.set_location(l_proc, 13);
3457:
3458: for name_rec in C_names loop
3459: l_user_name_employee_id := name_rec.employee_id ;
3460: l_user_name_emp_first_name := name_rec.first_name;

Line 3468: hr_utility.set_location(l_proc, 14);

3464: end loop;
3465: end if;
3466: -- Update the latest record in the routing history for the specific request_id
3467:
3468: hr_utility.set_location(l_proc, 14);
3469:
3470: If l_action_taken = 'UPDATE_HR' and
3471: trunc(p_effective_date) > sysdate then
3472: l_action_taken := 'FUTURE_ACTION';

Line 3535: hr_utility.set_message(8301, 'GHR_38114_NO_MORE_SEQ_NUMBER');

3531: if l_next_groupbox_id is null then
3532: l_next_groupbox_id := p_i_groupbox_id;
3533: end if;
3534: if l_next_seq_numb is null then
3535: hr_utility.set_message(8301, 'GHR_38114_NO_MORE_SEQ_NUMBER');
3536: hr_utility.raise_error;
3537: end if;
3538: end if;
3539:

Line 3536: hr_utility.raise_error;

3532: l_next_groupbox_id := p_i_groupbox_id;
3533: end if;
3534: if l_next_seq_numb is null then
3535: hr_utility.set_message(8301, 'GHR_38114_NO_MORE_SEQ_NUMBER');
3536: hr_utility.raise_error;
3537: end if;
3538: end if;
3539:
3540: hr_utility.set_location(l_proc, 20);

Line 3540: hr_utility.set_location(l_proc, 20);

3536: hr_utility.raise_error;
3537: end if;
3538: end if;
3539:
3540: hr_utility.set_location(l_proc, 20);
3541: -- check for open events before attempting to route / Update HR
3542: hr_utility.set_location('Before check Open Events',1);
3543: ghr_sf52_api.check_for_open_events
3544: (

Line 3542: hr_utility.set_location('Before check Open Events',1);

3538: end if;
3539:
3540: hr_utility.set_location(l_proc, 20);
3541: -- check for open events before attempting to route / Update HR
3542: hr_utility.set_location('Before check Open Events',1);
3543: ghr_sf52_api.check_for_open_events
3544: (
3545: p_pa_request_id => p_pa_request_id,
3546: p_message => l_message,

Line 3560: hr_utility.set_message(8301,'GHR_38592_OPEN_EVENTS_EXIST');

3556: p_message_set => l_message
3557: );
3558:
3559: if l_message then
3560: hr_utility.set_message(8301,'GHR_38592_OPEN_EVENTS_EXIST');
3561: hr_utility.raise_error;
3562: end if;
3563:
3564: -- Insert 2nd record into routing_history for routing details (with exceptions )

Line 3561: hr_utility.raise_error;

3557: );
3558:
3559: if l_message then
3560: hr_utility.set_message(8301,'GHR_38592_OPEN_EVENTS_EXIST');
3561: hr_utility.raise_error;
3562: end if;
3563:
3564: -- Insert 2nd record into routing_history for routing details (with exceptions )
3565:

Line 3594: hr_utility.set_location('pAR' || to_char(l_par_object_version_number),1);

3590: );
3591:
3592: end if;
3593:
3594: hr_utility.set_location('pAR' || to_char(l_par_object_version_number),1);
3595:
3596: if l_action_taken in ('UPDATE_HR','FUTURE_ACTION','END_ROUTING') then
3597: hr_utility.set_location(l_proc || p_award_amount,1);
3598: hr_utility.set_location(l_proc || p_award_percentage,1);

Line 3597: hr_utility.set_location(l_proc || p_award_amount,1);

3593:
3594: hr_utility.set_location('pAR' || to_char(l_par_object_version_number),1);
3595:
3596: if l_action_taken in ('UPDATE_HR','FUTURE_ACTION','END_ROUTING') then
3597: hr_utility.set_location(l_proc || p_award_amount,1);
3598: hr_utility.set_location(l_proc || p_award_percentage,1);
3599:
3600: hr_utility.set_location(l_proc, 21);
3601: l_rec.pa_request_id := p_pa_request_id;

Line 3598: hr_utility.set_location(l_proc || p_award_percentage,1);

3594: hr_utility.set_location('pAR' || to_char(l_par_object_version_number),1);
3595:
3596: if l_action_taken in ('UPDATE_HR','FUTURE_ACTION','END_ROUTING') then
3597: hr_utility.set_location(l_proc || p_award_amount,1);
3598: hr_utility.set_location(l_proc || p_award_percentage,1);
3599:
3600: hr_utility.set_location(l_proc, 21);
3601: l_rec.pa_request_id := p_pa_request_id;
3602: l_rec.noa_family_code := p_noa_family_code;

Line 3600: hr_utility.set_location(l_proc, 21);

3596: if l_action_taken in ('UPDATE_HR','FUTURE_ACTION','END_ROUTING') then
3597: hr_utility.set_location(l_proc || p_award_amount,1);
3598: hr_utility.set_location(l_proc || p_award_percentage,1);
3599:
3600: hr_utility.set_location(l_proc, 21);
3601: l_rec.pa_request_id := p_pa_request_id;
3602: l_rec.noa_family_code := p_noa_family_code;
3603: l_rec.routing_group_id := p_routing_group_id;
3604: If p_proposed_effective_asap_flag = hr_api.g_varchar2 then

Line 3646: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 22);

3642: l_rec.employee_middle_names := p_employee_middle_names;
3643: l_rec.employee_national_identifier := p_employee_national_identifier;
3644: l_rec.fegli := p_fegli;
3645: l_rec.fegli_desc := p_fegli_desc;
3646: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 22);
3647: l_rec.first_action_la_code1 := p_first_action_la_code1;
3648: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 23);
3649: l_rec.first_action_la_code2 := p_first_action_la_code2;
3650: l_rec.first_action_la_desc1 := p_first_action_la_desc1;

Line 3648: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 23);

3644: l_rec.fegli := p_fegli;
3645: l_rec.fegli_desc := p_fegli_desc;
3646: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 22);
3647: l_rec.first_action_la_code1 := p_first_action_la_code1;
3648: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 23);
3649: l_rec.first_action_la_code2 := p_first_action_la_code2;
3650: l_rec.first_action_la_desc1 := p_first_action_la_desc1;
3651: l_rec.first_action_la_desc2 := p_first_action_la_desc2;
3652: l_rec.first_noa_cancel_or_correct := p_first_noa_cancel_or_correct;

Line 3873: hr_utility.set_location('p_payment_option: '||p_payment_option,1);

3869: End if;
3870:
3871: l_rec.mass_action_comments := p_mass_action_comments;
3872: -- Bug# RRR Changes
3873: hr_utility.set_location('p_payment_option: '||p_payment_option,1);
3874: l_rec.pa_incentive_payment_option := p_payment_option;
3875: hr_utility.set_location('p_award_salary: '||p_award_salary,2);
3876: l_rec.award_salary := p_award_salary;
3877: hr_utility.set_location('After p_award_salary: ',3);

Line 3875: hr_utility.set_location('p_award_salary: '||p_award_salary,2);

3871: l_rec.mass_action_comments := p_mass_action_comments;
3872: -- Bug# RRR Changes
3873: hr_utility.set_location('p_payment_option: '||p_payment_option,1);
3874: l_rec.pa_incentive_payment_option := p_payment_option;
3875: hr_utility.set_location('p_award_salary: '||p_award_salary,2);
3876: l_rec.award_salary := p_award_salary;
3877: hr_utility.set_location('After p_award_salary: ',3);
3878: -- Bug# RRR Changes
3879:

Line 3877: hr_utility.set_location('After p_award_salary: ',3);

3873: hr_utility.set_location('p_payment_option: '||p_payment_option,1);
3874: l_rec.pa_incentive_payment_option := p_payment_option;
3875: hr_utility.set_location('p_award_salary: '||p_award_salary,2);
3876: l_rec.award_salary := p_award_salary;
3877: hr_utility.set_location('After p_award_salary: ',3);
3878: -- Bug# RRR Changes
3879:
3880: -- Convert the default values
3881: hr_utility.set_location('after l_rec assignment ',2);

Line 3881: hr_utility.set_location('after l_rec assignment ',2);

3877: hr_utility.set_location('After p_award_salary: ',3);
3878: -- Bug# RRR Changes
3879:
3880: -- Convert the default values
3881: hr_utility.set_location('after l_rec assignment ',2);
3882: hr_utility.set_location('Before First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 3);
3883: ghr_par_bus.convert_defaults(l_rec);
3884: hr_utility.set_location('After First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 4);
3885:

Line 3882: hr_utility.set_location('Before First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 3);

3878: -- Bug# RRR Changes
3879:
3880: -- Convert the default values
3881: hr_utility.set_location('after l_rec assignment ',2);
3882: hr_utility.set_location('Before First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 3);
3883: ghr_par_bus.convert_defaults(l_rec);
3884: hr_utility.set_location('After First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 4);
3885:
3886: --

Line 3884: hr_utility.set_location('After First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 4);

3880: -- Convert the default values
3881: hr_utility.set_location('after l_rec assignment ',2);
3882: hr_utility.set_location('Before First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 3);
3883: ghr_par_bus.convert_defaults(l_rec);
3884: hr_utility.set_location('After First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 4);
3885:
3886: --
3887: -- call update-hr
3888: hr_utility.set_location('l_ovn' || to_char(l_rec.object_version_number),2);

Line 3888: hr_utility.set_location('l_ovn' || to_char(l_rec.object_version_number),2);

3884: hr_utility.set_location('After First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 4);
3885:
3886: --
3887: -- call update-hr
3888: hr_utility.set_location('l_ovn' || to_char(l_rec.object_version_number),2);
3889:
3890: If l_rec.effective_date is null then
3891: hr_utility.set_message(8301,'GHR_38185_EFF_DATE_REQUIRED');
3892: ghr_upd_hr_validation.form_item_name := 'PAR.EFFECTIVE_DATE';

Line 3891: hr_utility.set_message(8301,'GHR_38185_EFF_DATE_REQUIRED');

3887: -- call update-hr
3888: hr_utility.set_location('l_ovn' || to_char(l_rec.object_version_number),2);
3889:
3890: If l_rec.effective_date is null then
3891: hr_utility.set_message(8301,'GHR_38185_EFF_DATE_REQUIRED');
3892: ghr_upd_hr_validation.form_item_name := 'PAR.EFFECTIVE_DATE';
3893: hr_utility.raise_error;
3894: End if;
3895: if (l_action_taken <> 'END_ROUTING') then

Line 3893: hr_utility.raise_error;

3889:
3890: If l_rec.effective_date is null then
3891: hr_utility.set_message(8301,'GHR_38185_EFF_DATE_REQUIRED');
3892: ghr_upd_hr_validation.form_item_name := 'PAR.EFFECTIVE_DATE';
3893: hr_utility.raise_error;
3894: End if;
3895: if (l_action_taken <> 'END_ROUTING') then
3896: ghr_process_sf52.process_sf52
3897: (p_sf52_data => l_rec

Line 3934: hr_utility.set_location('to pos id is '|| l_rec.to_position_id,1);

3930: );
3931: for ovn_rec in c_ovn loop
3932: l_rec.object_version_number := ovn_rec.object_version_number;
3933: end loop;
3934: hr_utility.set_location('to pos id is '|| l_rec.to_position_id,1);
3935: hr_utility.set_location('first noa code is '|| l_rec.first_noa_code,1);
3936: IF nvl(l_rec.first_noa_code,'9999') <> '002' THEN
3937: ghr_par_upd.upd
3938: (p_pa_request_id => p_pa_request_id,

Line 3935: hr_utility.set_location('first noa code is '|| l_rec.first_noa_code,1);

3931: for ovn_rec in c_ovn loop
3932: l_rec.object_version_number := ovn_rec.object_version_number;
3933: end loop;
3934: hr_utility.set_location('to pos id is '|| l_rec.to_position_id,1);
3935: hr_utility.set_location('first noa code is '|| l_rec.first_noa_code,1);
3936: IF nvl(l_rec.first_noa_code,'9999') <> '002' THEN
3937: ghr_par_upd.upd
3938: (p_pa_request_id => p_pa_request_id,
3939: p_object_version_number => l_rec.object_version_number,

Line 4040: hr_utility.set_message(8301,'GHR_38112_INVALID_API');

4036: end if; -- If template record for mass Award --- AVR
4037: elsif l_action_taken = 'NONE' then
4038: null;
4039: else
4040: hr_utility.set_message(8301,'GHR_38112_INVALID_API');
4041: hr_utility.raise_error;
4042: end if;
4043:
4044: If p_print_sf50_flag = 'Y' then

Line 4041: hr_utility.raise_error;

4037: elsif l_action_taken = 'NONE' then
4038: null;
4039: else
4040: hr_utility.set_message(8301,'GHR_38112_INVALID_API');
4041: hr_utility.raise_error;
4042: end if;
4043:
4044: If p_print_sf50_flag = 'Y' then
4045:

Line 4047: hr_utility.set_message(8301,'GHR_38399_52_NOT_PROCESSED');

4043:
4044: If p_print_sf50_flag = 'Y' then
4045:
4046: If l_action_taken <> 'UPDATE_HR' then
4047: hr_utility.set_message(8301,'GHR_38399_52_NOT_PROCESSED');
4048: hr_utility.raise_error;
4049: End if;
4050: --Bug#3757201 Added p_back_page parameter
4051: -- Bug #8286910 Need to handle for dual correction

Line 4048: hr_utility.raise_error;

4044: If p_print_sf50_flag = 'Y' then
4045:
4046: If l_action_taken <> 'UPDATE_HR' then
4047: hr_utility.set_message(8301,'GHR_38399_52_NOT_PROCESSED');
4048: hr_utility.raise_error;
4049: End if;
4050: --Bug#3757201 Added p_back_page parameter
4051: -- Bug #8286910 Need to handle for dual correction
4052: if not(p_first_noa_code = '002' and p_rpa_type = 'DUAL' and p_mass_action_id is not null) then

Line 4350: hr_utility.set_location(' Leaving:'||l_proc, 11);

4346: p_i_pa_routing_history_id := l_i_pa_routing_history_id;
4347: p_i_prh_object_version_number := l_i_prh_object_version_number;
4348: p_par_object_version_number := l_par_object_version_number;
4349: --
4350: hr_utility.set_location(' Leaving:'||l_proc, 11);
4351: exception
4352: when hr_api.validate_enabled then
4353: --
4354: -- As the Validate_Enabled exception has been raised

Line 4378: hr_utility.set_location(' Leaving:'||l_proc, 12);

4374: p_i_pa_routing_history_id := null;
4375: p_i_prh_object_version_number := l_i_prh_object_version_number;
4376: Raise;
4377:
4378: hr_utility.set_location(' Leaving:'||l_proc, 12);
4379:
4380: end update_sf52;
4381:
4382: -- ----------------------------------------------------------------------------

Line 4502: hr_utility.set_location('Entering:'|| l_proc, 5);

4498: AND effective_end_date;
4499:
4500:
4501: begin
4502: hr_utility.set_location('Entering:'|| l_proc, 5);
4503: --
4504: -- Issue a savepoint
4505: --
4506: savepoint end_sf52;

Line 4530: hr_utility.set_location(l_proc, 6);

4526: end;
4527: --
4528: -- End of Before Process User Hook call
4529: --
4530: hr_utility.set_location(l_proc, 6);
4531: l_par_object_version_number := p_par_object_version_number;
4532:
4533:
4534: If p_first_noa_code in ('001','002') then

Line 4543: hr_utility.set_message(8301,'GHR_38264_INV_PA_REQ_CAN_COR');

4539: );
4540: End if;
4541:
4542: If not l_result then
4543: hr_utility.set_message(8301,'GHR_38264_INV_PA_REQ_CAN_COR');
4544: hr_utility.raise_error;
4545: End if;
4546:
4547: /***dk***/

Line 4544: hr_utility.raise_error;

4540: End if;
4541:
4542: If not l_result then
4543: hr_utility.set_message(8301,'GHR_38264_INV_PA_REQ_CAN_COR');
4544: hr_utility.raise_error;
4545: End if;
4546:
4547: /***dk***/
4548: -- Added ENDED to the following if.

Line 4640: hr_utility.set_message(8301,'GHR_38111_USER_NAME_REQD');

4636:
4637: -- The foll. was Removed on 08/16 as per Vikram
4638:
4639: /* If l_user_name is null then
4640: hr_utility.set_message(8301,'GHR_38111_USER_NAME_REQD');
4641: hr_utility.raise_error;
4642: End if;
4643: */
4644:

Line 4641: hr_utility.raise_error;

4637: -- The foll. was Removed on 08/16 as per Vikram
4638:
4639: /* If l_user_name is null then
4640: hr_utility.set_message(8301,'GHR_38111_USER_NAME_REQD');
4641: hr_utility.raise_error;
4642: End if;
4643: */
4644:
4645:

Line 4668: hr_utility.set_location('before upd to prh',1);

4664: exit;
4665: end loop;
4666: end if;
4667:
4668: hr_utility.set_location('before upd to prh',1);
4669: hr_utility.set_location('emp id ' || to_char(l_user_name_employee_id),1);
4670:
4671: ghr_prh_upd.upd
4672: (p_pa_routing_history_id => l_pa_routing_history_id

Line 4669: hr_utility.set_location('emp id ' || to_char(l_user_name_employee_id),1);

4665: end loop;
4666: end if;
4667:
4668: hr_utility.set_location('before upd to prh',1);
4669: hr_utility.set_location('emp id ' || to_char(l_user_name_employee_id),1);
4670:
4671: ghr_prh_upd.upd
4672: (p_pa_routing_history_id => l_pa_routing_history_id
4673: ,p_user_name => l_user_name

Line 4698: hr_utility.set_location('action_taken: ' || p_action_taken ,1);

4694: p_old_action_taken => l_old_action_taken
4695: );
4696:
4697: else
4698: hr_utility.set_location('action_taken: ' || p_action_taken ,1);
4699: hr_utility.set_message(8301,'GH_38112_INVALID_API');
4700: hr_utility.raise_error;
4701: end if;
4702:

Line 4699: hr_utility.set_message(8301,'GH_38112_INVALID_API');

4695: );
4696:
4697: else
4698: hr_utility.set_location('action_taken: ' || p_action_taken ,1);
4699: hr_utility.set_message(8301,'GH_38112_INVALID_API');
4700: hr_utility.raise_error;
4701: end if;
4702:
4703: --

Line 4700: hr_utility.raise_error;

4696:
4697: else
4698: hr_utility.set_location('action_taken: ' || p_action_taken ,1);
4699: hr_utility.set_message(8301,'GH_38112_INVALID_API');
4700: hr_utility.raise_error;
4701: end if;
4702:
4703: --
4704: -- Call After Process User Hook

Line 4734: hr_utility.set_location(' Leaving:'||l_proc, 11);

4730:
4731: -- Set all output arguments
4732: --
4733:
4734: hr_utility.set_location(' Leaving:'||l_proc, 11);
4735: exception
4736: when hr_api.validate_enabled then
4737: --
4738: -- As the Validate_Enabled exception has been raised

Line 4757: hr_utility.set_location(' Leaving:'||l_proc, 12);

4753: --
4754: p_par_object_version_number := l_par_object_version_number;
4755: Raise;
4756:
4757: hr_utility.set_location(' Leaving:'||l_proc, 12);
4758: end end_sf52;
4759:
4760:
4761:

Line 4787: hr_utility.set_location( 'entering :' || l_proc , 10);

4783: l_proc varchar2(30):='Cancel_corcan';
4784: l_object_version_number number;
4785:
4786: Begin
4787: hr_utility.set_location( 'entering :' || l_proc , 10);
4788: for get_req in c_get_req(p_altered_pa_request_id) loop
4789: l_req.first_noa_code := get_Req.first_noa_code;
4790: l_req.second_noa_code := get_req.second_noa_code;
4791: l_object_version_number := get_req.object_version_number;

Line 4793: hr_utility.set_location( 'not found ' || l_proc, 20);

4789: l_req.first_noa_code := get_Req.first_noa_code;
4790: l_req.second_noa_code := get_req.second_noa_code;
4791: l_object_version_number := get_req.object_version_number;
4792: if l_object_version_number is null then
4793: hr_utility.set_location( 'not found ' || l_proc, 20);
4794: p_result := FALSE;
4795: else
4796: if l_req.first_noa_code = p_noa_code_correct then
4797: hr_utility.set_location( 'first noa ' || l_proc, 30);

Line 4797: hr_utility.set_location( 'first noa ' || l_proc, 30);

4793: hr_utility.set_location( 'not found ' || l_proc, 20);
4794: p_result := FALSE;
4795: else
4796: if l_req.first_noa_code = p_noa_code_correct then
4797: hr_utility.set_location( 'first noa ' || l_proc, 30);
4798: ghr_par_upd.upd
4799: (p_pa_request_id => p_altered_pa_request_id,
4800: p_object_version_number => l_object_version_number,
4801: -- p_first_noa_cancel_or_correct => null,

Line 4806: hr_utility.set_location( '2nd NOA ' || l_proc, 60);

4802: p_first_noa_canc_pa_request_id => null
4803: );
4804:
4805: elsif l_req.second_noa_code = p_noa_code_correct then
4806: hr_utility.set_location( '2nd NOA ' || l_proc, 60);
4807: ghr_par_upd.upd
4808: (p_pa_request_id => p_altered_pa_request_id,
4809: p_object_version_number => l_object_version_number,
4810: -- p_second_noa_cancel_or_correct => null,

Line 4814: hr_utility.set_location( 'not found ' || l_proc, 90);

4810: -- p_second_noa_cancel_or_correct => null,
4811: p_second_noa_canc_pa_request_i=> null
4812: );
4813: else
4814: hr_utility.set_location( 'not found ' || l_proc, 90);
4815: p_result := FALSE;
4816: end if;
4817: end if;
4818: end loop;

Line 4819: hr_utility.set_location( 'Leaving :' || l_proc, 100);

4815: p_result := FALSE;
4816: end if;
4817: end if;
4818: end loop;
4819: hr_utility.set_location( 'Leaving :' || l_proc, 100);
4820: Exception when others then
4821: --
4822: -- Reset IN OUT parameters and set OUT parameters
4823: --

Line 4850: hr_utility.set_message(8301,'GHR_38400_NO_50_FOR_FUT_ACT');

4846: where user_name = p_user_name;
4847:
4848: begin
4849: If trunc(p_effective_date) > trunc(sysdate) then
4850: hr_utility.set_message(8301,'GHR_38400_NO_50_FOR_FUT_ACT');
4851: hr_utility.raise_error;
4852: End if;
4853:
4854: If p_printer_name is null then

Line 4851: hr_utility.raise_error;

4847:
4848: begin
4849: If trunc(p_effective_date) > trunc(sysdate) then
4850: hr_utility.set_message(8301,'GHR_38400_NO_50_FOR_FUT_ACT');
4851: hr_utility.raise_error;
4852: End if;
4853:
4854: If p_printer_name is null then
4855: hr_utility.set_message(8301,'GHR_38394_NO_PRINTER');

Line 4855: hr_utility.set_message(8301,'GHR_38394_NO_PRINTER');

4851: hr_utility.raise_error;
4852: End if;
4853:
4854: If p_printer_name is null then
4855: hr_utility.set_message(8301,'GHR_38394_NO_PRINTER');
4856: hr_utility.raise_error;
4857: Else
4858: l_set_print_options_status := fnd_request.set_print_options
4859: (PRINTER => p_printer_name

Line 4856: hr_utility.raise_error;

4852: End if;
4853:
4854: If p_printer_name is null then
4855: hr_utility.set_message(8301,'GHR_38394_NO_PRINTER');
4856: hr_utility.raise_error;
4857: Else
4858: l_set_print_options_status := fnd_request.set_print_options
4859: (PRINTER => p_printer_name
4860: ,STYLE => null

Line 4866: hr_utility.set_message(8301,'GHR_38190_FAIL_SET_PRINT_OPT');

4862: ,SAVE_OUTPUT => TRUE
4863: ,PRINT_TOGETHER => 'N'
4864: );
4865: If not l_set_print_options_status THEN
4866: hr_utility.set_message(8301,'GHR_38190_FAIL_SET_PRINT_OPT');
4867: hr_utility.raise_error;
4868: Else
4869: for user_id in c_user_id loop
4870: l_user_id := user_id.user_id;

Line 4867: hr_utility.raise_error;

4863: ,PRINT_TOGETHER => 'N'
4864: );
4865: If not l_set_print_options_status THEN
4866: hr_utility.set_message(8301,'GHR_38190_FAIL_SET_PRINT_OPT');
4867: hr_utility.raise_error;
4868: Else
4869: for user_id in c_user_id loop
4870: l_user_id := user_id.user_id;
4871: end loop;

Line 4887: -- hr_utility.raise_error;

4883: );
4884: IF l_request_status = 0 THEN
4885: null;
4886: --hr_utiltity.set_message('error submitting the request');
4887: -- hr_utility.raise_error;
4888: Else
4889: commit;
4890: End if;
4891: End if;

Line 4959: hr_utility.set_location('Entering ' || l_proc,5);

4955:
4956:
4957: begin
4958:
4959: hr_utility.set_location('Entering ' || l_proc,5);
4960: hr_utility.set_location('PAR ' || to_char(p_pa_request_id),1);
4961: hr_utility.set_location('GB ' || to_char(p_groupbox_routed_to),1);
4962: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4963: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);

Line 4960: hr_utility.set_location('PAR ' || to_char(p_pa_request_id),1);

4956:
4957: begin
4958:
4959: hr_utility.set_location('Entering ' || l_proc,5);
4960: hr_utility.set_location('PAR ' || to_char(p_pa_request_id),1);
4961: hr_utility.set_location('GB ' || to_char(p_groupbox_routed_to),1);
4962: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4963: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4964: hr_utility.set_location('Action ' || (p_action_taken),1);

Line 4961: hr_utility.set_location('GB ' || to_char(p_groupbox_routed_to),1);

4957: begin
4958:
4959: hr_utility.set_location('Entering ' || l_proc,5);
4960: hr_utility.set_location('PAR ' || to_char(p_pa_request_id),1);
4961: hr_utility.set_location('GB ' || to_char(p_groupbox_routed_to),1);
4962: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4963: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4964: hr_utility.set_location('Action ' || (p_action_taken),1);
4965: If

Line 4962: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);

4958:
4959: hr_utility.set_location('Entering ' || l_proc,5);
4960: hr_utility.set_location('PAR ' || to_char(p_pa_request_id),1);
4961: hr_utility.set_location('GB ' || to_char(p_groupbox_routed_to),1);
4962: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4963: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4964: hr_utility.set_location('Action ' || (p_action_taken),1);
4965: If
4966: ( nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' or

Line 4963: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);

4959: hr_utility.set_location('Entering ' || l_proc,5);
4960: hr_utility.set_location('PAR ' || to_char(p_pa_request_id),1);
4961: hr_utility.set_location('GB ' || to_char(p_groupbox_routed_to),1);
4962: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4963: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4964: hr_utility.set_location('Action ' || (p_action_taken),1);
4965: If
4966: ( nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' or
4967: nvl(p_action_taken,hr_api.g_varchar2) = 'FUTURE_ACTION'

Line 4964: hr_utility.set_location('Action ' || (p_action_taken),1);

4960: hr_utility.set_location('PAR ' || to_char(p_pa_request_id),1);
4961: hr_utility.set_location('GB ' || to_char(p_groupbox_routed_to),1);
4962: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4963: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4964: hr_utility.set_location('Action ' || (p_action_taken),1);
4965: If
4966: ( nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' or
4967: nvl(p_action_taken,hr_api.g_varchar2) = 'FUTURE_ACTION'
4968: --**dk

Line 4979: hr_utility.set_location(l_proc,10);

4975: nvl(p_user_name_acted_on,hr_api.g_varchar2) <> p_user_name_routed_to
4976: ) or
4977: (p_groupbox_routed_to is not null )*/
4978:
4979: hr_utility.set_location(l_proc,10);
4980: for open_events in c_open_events loop
4981: hr_utility.set_location(l_proc,15);
4982: l_exists := TRUE;
4983: exit;

Line 4981: hr_utility.set_location(l_proc,15);

4977: (p_groupbox_routed_to is not null )*/
4978:
4979: hr_utility.set_location(l_proc,10);
4980: for open_events in c_open_events loop
4981: hr_utility.set_location(l_proc,15);
4982: l_exists := TRUE;
4983: exit;
4984: end loop;
4985: If l_exists then

Line 4986: hr_utility.set_location(l_proc,20);

4982: l_exists := TRUE;
4983: exit;
4984: end loop;
4985: If l_exists then
4986: hr_utility.set_location(l_proc,20);
4987: p_message := TRUE;
4988: Else
4989: hr_utility.set_location(l_proc,25);
4990: p_message := FALSE;

Line 4989: hr_utility.set_location(l_proc,25);

4985: If l_exists then
4986: hr_utility.set_location(l_proc,20);
4987: p_message := TRUE;
4988: Else
4989: hr_utility.set_location(l_proc,25);
4990: p_message := FALSE;
4991: End if;
4992: End if;
4993: hr_utility.set_location('Leaving ' || l_proc,30);

Line 4993: hr_utility.set_location('Leaving ' || l_proc,30);

4989: hr_utility.set_location(l_proc,25);
4990: p_message := FALSE;
4991: End if;
4992: End if;
4993: hr_utility.set_location('Leaving ' || l_proc,30);
4994: Exception when others then
4995: --
4996: -- Reset IN OUT parameters and set OUT parameters
4997: --

Line 5064: hr_utility.set_location('Entering ' || l_proc,55);

5060: l_detail_location varchar2(200);
5061: l_record_found BOOLEAN default FALSE;
5062:
5063: BEGIN
5064: hr_utility.set_location('Entering ' || l_proc,55);
5065: FOR cur_get_detail_info_rec IN cur_get_detail_info LOOP
5066: l_detail_position_id := cur_get_detail_info_rec.position_id;
5067: l_detail_grade_id := cur_get_detail_info_rec.grade_id;
5068: l_detail_job_id := cur_get_detail_info_rec.job_id;

Line 5335: hr_utility.set_location('Leaving ' || l_proc,55);

5331: );
5332: END IF;
5333: END;
5334: END IF;
5335: hr_utility.set_location('Leaving ' || l_proc,55);
5336: END update_detail_remarks;
5337: --End Bug# 8653508
5338:
5339: end ghr_sf52_api;