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 397: hr_utility.set_location('Entering:'|| l_proc, 5);

393:
394: l_capped_other_pay number;
395: l_assignment_id ghr_pa_requests.employee_assignment_id%type;
396: begin
397: hr_utility.set_location('Entering:'|| l_proc, 5);
398:
399: -- Issue a savepoint if operating in validation only mode.
400: -- if p_validate then
401: savepoint create_sf52;

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

633: end;
634: --
635: -- End of Before Process User Hook call
636: --
637: hr_utility.set_location(l_proc, 6);
638: -- Process Logic
639:
640: -- If the SF52 is processed for the person same as the user, then do not allow creation
641:

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

642: If p_person_id is not null then
643: -- get employee_id of the user
644: for user_id in c_user_emp_names loop
645: If user_id.employee_id = p_person_id then
646: hr_utility.set_message(8301,'GHR_38503_CANNOT_INIT_FOR_SELF');
647: hr_utility.raise_error;
648: End if;
649: end loop;
650: End if;

Line 647: hr_utility.raise_error;

643: -- get employee_id of the user
644: for user_id in c_user_emp_names loop
645: If user_id.employee_id = p_person_id then
646: hr_utility.set_message(8301,'GHR_38503_CANNOT_INIT_FOR_SELF');
647: hr_utility.raise_error;
648: End if;
649: end loop;
650: End if;
651:

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

655:
656: If nvl(p_1_approval_status,hr_api.g_varchar2) = 'APPROVE' then
657: If p_approval_date is null
658: then
659: hr_utility.set_location('approval date is not null',1);
660: l_effective_date := trunc(sysdate);
661: l_approval_date := sysdate;
662: -- get the full_name of the approver - format First Name MiddleName. Last Name -- p_user_name_acted_on
663: for user_emp_name in c_user_emp_names loop

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

718: -- Insert a row into pa_requests by calling the ins row handler
719:
720: l_pa_request_id := p_pa_request_id;
721: l_effective_date := trunc(nvl(p_effective_date,sysdate));
722: hr_utility.set_location('appr name ' || l_approving_official_full_name,1);
723: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);
724: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);
725:
726: ghr_par_ins.ins

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

719:
720: l_pa_request_id := p_pa_request_id;
721: l_effective_date := trunc(nvl(p_effective_date,sysdate));
722: hr_utility.set_location('appr name ' || l_approving_official_full_name,1);
723: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);
724: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);
725:
726: ghr_par_ins.ins
727: (

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

720: l_pa_request_id := p_pa_request_id;
721: l_effective_date := trunc(nvl(p_effective_date,sysdate));
722: hr_utility.set_location('appr name ' || l_approving_official_full_name,1);
723: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);
724: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);
725:
726: ghr_par_ins.ins
727: (
728: p_pa_request_id => l_pa_request_id,

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

946: p_award_salary => p_award_salary
947: -- Bug#4486823 RRR Changes
948: );
949: p_par_object_version_number := l_par_object_version_number ;
950: hr_utility.set_location(l_proc, 8);
951:
952:
953: --2) Write into pa_remarks all mandatory remarks for the specific nature_of_action (first and second)
954:

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

1081: end if;
1082:
1083: -- If action_taken is null then ,derive the action_taken
1084:
1085: hr_utility.set_location('passed action taken ' ||p_1_action_taken,1);
1086: l_action_taken := p_1_action_taken;
1087: if l_action_taken is null then
1088: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1089: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then

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

1091: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1092: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
1093: l_action_taken := 'REQUESTED';
1094: else
1095: hr_utility.set_location('Bef c_history_exists ' ||l_pa_request_id,2);
1096: for history_exists in C_history_exists loop
1097: l_exists := true;
1098: exit;
1099: end loop;

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

1108: -- added END_ROUTING to the following if stmt.
1109: if l_action_taken not in('NOT_ROUTED','INITIATED','REQUESTED','AUTHORIZED',
1110: 'NO_ACTION','REVIEWED','CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE', 'END_ROUTING')
1111: then
1112: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');
1113: hr_utility.raise_error;
1114: end if;
1115:
1116:

Line 1113: hr_utility.raise_error;

1109: if l_action_taken not in('NOT_ROUTED','INITIATED','REQUESTED','AUTHORIZED',
1110: 'NO_ACTION','REVIEWED','CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE', 'END_ROUTING')
1111: then
1112: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');
1113: hr_utility.raise_error;
1114: end if;
1115:
1116:
1117: ghr_sf52_api.get_par_status

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

1132:
1133: -- to check if there is any routing information, if required.
1134: /***dk***/
1135: -- added END_ROUTING to the following if stmt.
1136: hr_utility.set_location('check ' ||l_action_taken,3);
1137: hr_utility.set_location('p_2_user_name_routed_to ' ||p_2_user_name_routed_to,4);
1138: hr_utility.set_location('p_2_groupbox_id ' ||p_2_groupbox_id,5);
1139: hr_utility.set_location('p_2_routing_list_id ' ||p_2_routing_list_id,6);
1140: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','END_ROUTING') then

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

1133: -- to check if there is any routing information, if required.
1134: /***dk***/
1135: -- added END_ROUTING to the following if stmt.
1136: hr_utility.set_location('check ' ||l_action_taken,3);
1137: hr_utility.set_location('p_2_user_name_routed_to ' ||p_2_user_name_routed_to,4);
1138: hr_utility.set_location('p_2_groupbox_id ' ||p_2_groupbox_id,5);
1139: hr_utility.set_location('p_2_routing_list_id ' ||p_2_routing_list_id,6);
1140: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','END_ROUTING') then
1141: if p_2_user_name_routed_to is null and

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

1134: /***dk***/
1135: -- added END_ROUTING to the following if stmt.
1136: hr_utility.set_location('check ' ||l_action_taken,3);
1137: hr_utility.set_location('p_2_user_name_routed_to ' ||p_2_user_name_routed_to,4);
1138: hr_utility.set_location('p_2_groupbox_id ' ||p_2_groupbox_id,5);
1139: hr_utility.set_location('p_2_routing_list_id ' ||p_2_routing_list_id,6);
1140: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','END_ROUTING') then
1141: if p_2_user_name_routed_to is null and
1142: p_2_groupbox_id is null and

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

1135: -- added END_ROUTING to the following if stmt.
1136: hr_utility.set_location('check ' ||l_action_taken,3);
1137: hr_utility.set_location('p_2_user_name_routed_to ' ||p_2_user_name_routed_to,4);
1138: hr_utility.set_location('p_2_groupbox_id ' ||p_2_groupbox_id,5);
1139: hr_utility.set_location('p_2_routing_list_id ' ||p_2_routing_list_id,6);
1140: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','END_ROUTING') then
1141: if p_2_user_name_routed_to is null and
1142: p_2_groupbox_id is null and
1143: p_2_routing_list_id is null then

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

1140: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','END_ROUTING') then
1141: if p_2_user_name_routed_to is null and
1142: p_2_groupbox_id is null and
1143: p_2_routing_list_id is null then
1144: hr_utility.set_message(8301,'GHR_38115_ROUT_INFO_REQD');
1145: hr_utility.raise_error;
1146: end if;
1147: end if;
1148:

Line 1145: hr_utility.raise_error;

1141: if p_2_user_name_routed_to is null and
1142: p_2_groupbox_id is null and
1143: p_2_routing_list_id is null then
1144: hr_utility.set_message(8301,'GHR_38115_ROUT_INFO_REQD');
1145: hr_utility.raise_error;
1146: end if;
1147: end if;
1148:
1149: -- write the first record into the routing history (actions done by the user)

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

1199: exit;
1200: end loop;
1201:
1202: if l_2_routing_seq_number is null then
1203: hr_utility.set_message(8301,'GHR_38114_NO_MORE_SEQ_NUMBER' );
1204: hr_utility.raise_error;
1205: end if;
1206:
1207: end if;

Line 1204: hr_utility.raise_error;

1200: end loop;
1201:
1202: if l_2_routing_seq_number is null then
1203: hr_utility.set_message(8301,'GHR_38114_NO_MORE_SEQ_NUMBER' );
1204: hr_utility.raise_error;
1205: end if;
1206:
1207: end if;
1208:

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

1224: p_message_set => l_message
1225: );
1226:
1227: if l_message then
1228: hr_utility.set_message(8301,'GHR_38592_OPEN_EVENTS_EXIST');
1229: hr_utility.raise_error;
1230: end if;
1231:
1232:

Line 1229: hr_utility.raise_error;

1225: );
1226:
1227: if l_message then
1228: hr_utility.set_message(8301,'GHR_38592_OPEN_EVENTS_EXIST');
1229: hr_utility.raise_error;
1230: end if;
1231:
1232:
1233: --Insert 2nd record into routing_history for routing details

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

1487:
1488:
1489:
1490: IF l_rec.effective_date is null THEN
1491: hr_utility.set_message(8301,'GHR_38185_EFF_DATE_REQUIRED');
1492: ghr_upd_hr_validation.form_item_name := 'PAR.EFFECTIVE_DATE';
1493: hr_utility.raise_error;
1494: END IF;
1495: if (l_action_taken <> 'END_ROUTING') then

Line 1493: hr_utility.raise_error;

1489:
1490: IF l_rec.effective_date is null THEN
1491: hr_utility.set_message(8301,'GHR_38185_EFF_DATE_REQUIRED');
1492: ghr_upd_hr_validation.form_item_name := 'PAR.EFFECTIVE_DATE';
1493: hr_utility.raise_error;
1494: END IF;
1495: if (l_action_taken <> 'END_ROUTING') then
1496: ghr_process_sf52.process_sf52
1497: (p_sf52_data => l_rec

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

1514: );
1515: for ovn_rec in c_ovn loop
1516: l_rec.object_version_number := ovn_rec.object_version_number;
1517: end loop;
1518: hr_utility.set_location('to pos id is '|| l_rec.to_position_id,1);
1519: hr_utility.set_location('first noa code is '|| l_rec.first_noa_code,1);
1520: IF nvl(l_rec.first_noa_code,'9999') <> '002' THEN
1521: ghr_par_upd.upd
1522: (p_pa_request_id => l_pa_request_id,

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

1515: for ovn_rec in c_ovn loop
1516: l_rec.object_version_number := ovn_rec.object_version_number;
1517: end loop;
1518: hr_utility.set_location('to pos id is '|| l_rec.to_position_id,1);
1519: hr_utility.set_location('first noa code is '|| l_rec.first_noa_code,1);
1520: IF nvl(l_rec.first_noa_code,'9999') <> '002' THEN
1521: ghr_par_upd.upd
1522: (p_pa_request_id => l_pa_request_id,
1523: p_object_version_number => l_rec.object_version_number,

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

1614: );
1615: end if;
1616: End if; -- Do not create routing history row for Mass Award Template
1617: Else
1618: hr_utility.set_message(8301,'GHR_38112_INVALID_API');
1619: hr_utility.raise_error;
1620: End if;
1621:
1622: If p_print_sf50_flag = 'Y' then

Line 1619: hr_utility.raise_error;

1615: end if;
1616: End if; -- Do not create routing history row for Mass Award Template
1617: Else
1618: hr_utility.set_message(8301,'GHR_38112_INVALID_API');
1619: hr_utility.raise_error;
1620: End if;
1621:
1622: If p_print_sf50_flag = 'Y' then
1623: -- Make sure that it only is valid while update_hr

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

1621:
1622: If p_print_sf50_flag = 'Y' then
1623: -- Make sure that it only is valid while update_hr
1624: If l_action_taken <> 'UPDATE_HR' then
1625: hr_utility.set_message(8301,'GHR_38399_52_NOT_PROCESSED');
1626: hr_utility.raise_error;
1627: End if;
1628: --Bug#3757201 Added p_back_page parameter
1629: submit_request_to_print_50

Line 1626: hr_utility.raise_error;

1622: If p_print_sf50_flag = 'Y' then
1623: -- Make sure that it only is valid while update_hr
1624: If l_action_taken <> 'UPDATE_HR' then
1625: hr_utility.set_message(8301,'GHR_38399_52_NOT_PROCESSED');
1626: hr_utility.raise_error;
1627: End if;
1628: --Bug#3757201 Added p_back_page parameter
1629: submit_request_to_print_50
1630: (p_printer_name => p_printer_name,

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

1883: -- Set all output arguments
1884: --
1885: p_pa_request_id := l_pa_request_id;
1886:
1887: hr_utility.set_location(' Leaving:'||l_proc, 11);
1888: exception
1889: when hr_api.validate_enabled then
1890: -- As the Validate_Enabled exception has been raised
1891: -- we must rollback to the savepoint

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

1915: p_2_pa_routing_history_id := null;
1916: p_2_prh_object_version_number := null;
1917: raise;
1918:
1919: hr_utility.set_location(' Leaving:'||l_proc, 12);
1920: end create_sf52;
1921:
1922: -- ----------------------------------------------------------------------------
1923: -- |--------------------------< update_sf52>--------------------------|

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

2370: FROM ghr_pa_requests par
2371: WHERE par.pa_request_id = p_pa_request_id;
2372:
2373: begin
2374: hr_utility.set_location('Entering:'|| l_proc, 5);
2375: --
2376: -- Issue a savepoint
2377: --
2378: savepoint update_sf52;

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

2607: end;
2608: --
2609: -- End of Before Process User Hook call
2610: --
2611: hr_utility.set_location(l_proc, 6);
2612: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 7);
2613: --
2614: -- Validation in addition to Row Handlers
2615:

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

2608: --
2609: -- End of Before Process User Hook call
2610: --
2611: hr_utility.set_location(l_proc, 6);
2612: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 7);
2613: --
2614: -- Validation in addition to Row Handlers
2615:
2616: -- If the SF52 is processed for the person same as the user, then do not allow creation

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

2618: If nvl(p_person_id,hr_api.g_number) <> hr_api.g_number then
2619: -- get employee_id of the user
2620: for user_id in c_names loop
2621: If user_id.employee_id = p_person_id then
2622: hr_utility.set_message(8301,'GHR_38503_CANNOT_INIT_FOR_SELF');
2623: hr_utility.raise_error;
2624: End if;
2625: end loop;
2626: End if;

Line 2623: hr_utility.raise_error;

2619: -- get employee_id of the user
2620: for user_id in c_names loop
2621: If user_id.employee_id = p_person_id then
2622: hr_utility.set_message(8301,'GHR_38503_CANNOT_INIT_FOR_SELF');
2623: hr_utility.raise_error;
2624: End if;
2625: end loop;
2626: End if;
2627:

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

2639: l_cnt_history := cnt_of_history.cnt;
2640: exit;
2641: end loop;
2642: if nvl(l_cnt_history,0) > 1 then
2643: hr_utility.set_message(8301,'GHR_38113_ROUT_GROUP_NON_UPD');
2644: hr_utility.raise_error;
2645: end if;
2646: end if;
2647: end if;

Line 2644: hr_utility.raise_error;

2640: exit;
2641: end loop;
2642: if nvl(l_cnt_history,0) > 1 then
2643: hr_utility.set_message(8301,'GHR_38113_ROUT_GROUP_NON_UPD');
2644: hr_utility.raise_error;
2645: end if;
2646: end if;
2647: end if;
2648:

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

2646: end if;
2647: end if;
2648:
2649:
2650: hr_utility.set_location('approval date ' || to_char(l_approval_date),1);
2651: l_approval_date := p_approval_date;
2652: l_approving_official_work_titl := p_approving_official_work_titl;
2653: l_approving_official_full_name := p_approving_official_full_name;
2654:

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

2651: l_approval_date := p_approval_date;
2652: l_approving_official_work_titl := p_approving_official_work_titl;
2653: l_approving_official_full_name := p_approving_official_full_name;
2654:
2655: hr_utility.set_location('approval_stat ' || p_u_approval_Status,1);
2656: If nvl(p_u_approval_status,hr_api.g_varchar2) = 'APPROVE' then
2657: If p_approval_date is null or p_approval_date = hr_api.g_date
2658: then
2659: hr_utility.set_location('approval date is not null',1);

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

2655: hr_utility.set_location('approval_stat ' || p_u_approval_Status,1);
2656: If nvl(p_u_approval_status,hr_api.g_varchar2) = 'APPROVE' then
2657: If p_approval_date is null or p_approval_date = hr_api.g_date
2658: then
2659: hr_utility.set_location('approval date is not null',1);
2660: l_effective_date := trunc(sysdate);
2661: l_approval_date := sysdate;
2662: -- get the full_name of the approver - format First Name MiddleName. Last Name -- p_user_name_acted_on
2663: for user_emp_name in c_names loop

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

2721: End if;
2722: End if;
2723:
2724:
2725: hr_utility.set_location(l_proc, 7);
2726:
2727: l_par_object_version_number := p_par_object_version_number;
2728: l_effective_date := trunc(nvl(p_effective_date,sysdate));
2729:

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

2731:
2732: -- Insert a row into pa_requests by calling the ins row handler
2733: l_object_version_number := p_par_object_version_number;
2734:
2735: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 8);
2736: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);
2737: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);
2738: -- Bug 2542417
2739: -- In some cases like Mass actions/Cancellation actions the assignment id and

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

2732: -- Insert a row into pa_requests by calling the ins row handler
2733: l_object_version_number := p_par_object_version_number;
2734:
2735: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 8);
2736: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);
2737: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);
2738: -- Bug 2542417
2739: -- In some cases like Mass actions/Cancellation actions the assignment id and
2740: -- and effective_date are not available to fetch the capped other pay

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

2733: l_object_version_number := p_par_object_version_number;
2734:
2735: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 8);
2736: hr_utility.set_location('l_effective_date : ' ||l_effective_date, 8);
2737: hr_utility.set_location('p_noa_family_code : ' ||p_noa_family_code, 8);
2738: -- Bug 2542417
2739: -- In some cases like Mass actions/Cancellation actions the assignment id and
2740: -- and effective_date are not available to fetch the capped other pay
2741: -- Below code fetches the effective_date and assignment id to be passed to

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

2741: -- Below code fetches the effective_date and assignment id to be passed to
2742: -- ghr_pa_requests_pkg2.get_cop function
2743:
2744: for c_par in c_get_det_for_cop loop
2745: hr_utility.set_location('c_par.employee_assignment_id : '
2746: ||c_par.employee_assignment_id, 8);
2747: hr_utility.set_location('c_par.effective_date : '
2748: ||c_par.effective_date, 8);
2749: l_from_cop := nvl(ghr_pa_requests_pkg2.get_cop

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

2743:
2744: for c_par in c_get_det_for_cop loop
2745: hr_utility.set_location('c_par.employee_assignment_id : '
2746: ||c_par.employee_assignment_id, 8);
2747: hr_utility.set_location('c_par.effective_date : '
2748: ||c_par.effective_date, 8);
2749: l_from_cop := nvl(ghr_pa_requests_pkg2.get_cop
2750: (nvl(p_employee_assignment_id,c_par.employee_assignment_id)
2751: ,c_par.effective_date)

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

2971: p_mass_action_comments => p_mass_action_comments,
2972: p_payment_option => p_payment_option,
2973: p_award_salary => p_award_salary
2974: );
2975: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 1);
2976:
2977: hr_utility.set_location(l_proc || 'l_ovn' || to_char(l_par_object_version_number),2);
2978: p_par_object_version_number := l_par_object_version_number;
2979: hr_utility.set_location(l_proc, 8);

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

2973: p_award_salary => p_award_salary
2974: );
2975: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 1);
2976:
2977: hr_utility.set_location(l_proc || 'l_ovn' || to_char(l_par_object_version_number),2);
2978: p_par_object_version_number := l_par_object_version_number;
2979: hr_utility.set_location(l_proc, 8);
2980:
2981: --2)Write into pa_remarks all mandatory remarks for the specific nature_of_action,

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

2975: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||p_first_action_la_code1, 1);
2976:
2977: hr_utility.set_location(l_proc || 'l_ovn' || to_char(l_par_object_version_number),2);
2978: p_par_object_version_number := l_par_object_version_number;
2979: hr_utility.set_location(l_proc, 8);
2980:
2981: --2)Write into pa_remarks all mandatory remarks for the specific nature_of_action,
2982: -- in case of either a) first_nature_of_action is input for the first_time or (just insert new recds)
2983: -- b) first nature_of_action has changed (delete and then insert new records)

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

2984: --
2985:
2986: if nvl(p_first_noa_id,hr_api.g_number)
2987: <> nvl(ghr_par_shd.g_old_rec.first_noa_id,hr_api.g_number) then
2988: hr_utility.set_location(l_proc, 9);
2989:
2990: -- delete the existing remarks
2991: delete from ghr_pa_remarks pre
2992: where pre.pa_request_id = p_pa_request_id

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

2994: (select remark_id
2995: from ghr_noac_remarks
2996: where nature_of_action_id = ghr_par_shd.g_old_rec.first_noa_id);
2997: if p_first_noa_id is not null then
2998: hr_utility.set_location(l_proc, 10);
2999:
3000: insert into ghr_pa_remarks
3001: (pa_remark_id
3002: ,pa_request_id

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

3140: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3141: (nvl(p_to_position_id,hr_api.g_number)
3142: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3143: then
3144: hr_utility.set_location('update/ delete extra info',1);
3145:
3146:
3147: GHR_NON_SF52_EXTRA_INFO.populate_noa_spec_extra_info
3148: (p_pa_request_id => p_pa_request_id,

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

3164: --3)Derive all parmeters required to insert routing_history records.
3165:
3166:
3167: l_action_taken := p_u_action_taken;
3168: hr_utility.set_location(l_proc, 11);
3169: if l_action_taken is null then
3170: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3171: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3172: l_action_taken := 'AUTHORIZED';

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

3195: end if;
3196: if l_action_taken not in('NOT_ROUTED','INITIATED','REQUESTED','AUTHORIZED','END_ROUTING','ENDED',
3197: 'NO_ACTION','REVIEWED','CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NONE')
3198: then
3199: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');
3200: hr_utility.raise_error;
3201: end if;
3202: -- Bug #1285393 Modified to add the if condition as not to update the status
3203: -- if action taken parameter is passed as NONE. (NONE is passed during the call made

Line 3200: hr_utility.raise_error;

3196: if l_action_taken not in('NOT_ROUTED','INITIATED','REQUESTED','AUTHORIZED','END_ROUTING','ENDED',
3197: 'NO_ACTION','REVIEWED','CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NONE')
3198: then
3199: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');
3200: hr_utility.raise_error;
3201: end if;
3202: -- Bug #1285393 Modified to add the if condition as not to update the status
3203: -- if action taken parameter is passed as NONE. (NONE is passed during the call made
3204: -- in Cancellation of APPT Sf52 to cancel the RPA's made after Appointment)

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

3212: p_action_taken => p_u_action_taken,
3213: p_status => l_status
3214: );
3215:
3216: hr_utility.set_location('befor upd of status' ,1);
3217: ghr_par_upd.upd
3218: (p_pa_request_id => p_pa_request_id,
3219: p_status => l_status,
3220: p_object_version_number => l_par_object_version_number

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

3219: p_status => l_status,
3220: p_object_version_number => l_par_object_version_number
3221: );
3222: end if;
3223: hr_utility.set_location('l_status : ' || l_status,1);
3224: hr_utility.set_location('after upd of status' ,1);
3225: p_par_object_version_number := l_par_object_version_number;
3226: hr_utility.set_location('check ' ||l_action_taken,1);
3227: hr_utility.set_location('p_i_user_name_routed_to ' ||p_i_user_name_routed_to,1);

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

3220: p_object_version_number => l_par_object_version_number
3221: );
3222: end if;
3223: hr_utility.set_location('l_status : ' || l_status,1);
3224: hr_utility.set_location('after upd of status' ,1);
3225: p_par_object_version_number := l_par_object_version_number;
3226: hr_utility.set_location('check ' ||l_action_taken,1);
3227: hr_utility.set_location('p_i_user_name_routed_to ' ||p_i_user_name_routed_to,1);
3228: hr_utility.set_location('p_i_groupbox_id ' ||p_i_groupbox_id,1);

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

3222: end if;
3223: hr_utility.set_location('l_status : ' || l_status,1);
3224: hr_utility.set_location('after upd of status' ,1);
3225: p_par_object_version_number := l_par_object_version_number;
3226: hr_utility.set_location('check ' ||l_action_taken,1);
3227: hr_utility.set_location('p_i_user_name_routed_to ' ||p_i_user_name_routed_to,1);
3228: hr_utility.set_location('p_i_groupbox_id ' ||p_i_groupbox_id,1);
3229: hr_utility.set_location('p_i_routing_list_id ' ||p_i_routing_list_id,1);
3230:

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

3223: hr_utility.set_location('l_status : ' || l_status,1);
3224: hr_utility.set_location('after upd of status' ,1);
3225: p_par_object_version_number := l_par_object_version_number;
3226: hr_utility.set_location('check ' ||l_action_taken,1);
3227: hr_utility.set_location('p_i_user_name_routed_to ' ||p_i_user_name_routed_to,1);
3228: hr_utility.set_location('p_i_groupbox_id ' ||p_i_groupbox_id,1);
3229: hr_utility.set_location('p_i_routing_list_id ' ||p_i_routing_list_id,1);
3230:
3231: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','NONE','ENDED','END_ROUTING') then

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

3224: hr_utility.set_location('after upd of status' ,1);
3225: p_par_object_version_number := l_par_object_version_number;
3226: hr_utility.set_location('check ' ||l_action_taken,1);
3227: hr_utility.set_location('p_i_user_name_routed_to ' ||p_i_user_name_routed_to,1);
3228: hr_utility.set_location('p_i_groupbox_id ' ||p_i_groupbox_id,1);
3229: hr_utility.set_location('p_i_routing_list_id ' ||p_i_routing_list_id,1);
3230:
3231: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','NONE','ENDED','END_ROUTING') then
3232: if p_i_user_name_routed_to is null and

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

3225: p_par_object_version_number := l_par_object_version_number;
3226: hr_utility.set_location('check ' ||l_action_taken,1);
3227: hr_utility.set_location('p_i_user_name_routed_to ' ||p_i_user_name_routed_to,1);
3228: hr_utility.set_location('p_i_groupbox_id ' ||p_i_groupbox_id,1);
3229: hr_utility.set_location('p_i_routing_list_id ' ||p_i_routing_list_id,1);
3230:
3231: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','NONE','ENDED','END_ROUTING') then
3232: if p_i_user_name_routed_to is null and
3233: p_i_groupbox_id is null and

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

3231: if l_action_taken not in ('CANCELED','UPDATE_HR','UPDATE_HR_COMPLETE','NOT_ROUTED','NONE','ENDED','END_ROUTING') then
3232: if p_i_user_name_routed_to is null and
3233: p_i_groupbox_id is null and
3234: p_i_routing_list_id is null then
3235: hr_utility.set_message(8301,'GHR_38115_ROUT_INFO_REQD');
3236: hr_utility.raise_error;
3237: end if;
3238: end if;
3239:

Line 3236: hr_utility.raise_error;

3232: if p_i_user_name_routed_to is null and
3233: p_i_groupbox_id is null and
3234: p_i_routing_list_id is null then
3235: hr_utility.set_message(8301,'GHR_38115_ROUT_INFO_REQD');
3236: hr_utility.raise_error;
3237: end if;
3238: end if;
3239:
3240: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','UPDATE_HR_COMPLETE','NONE','ENDED')then

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

3237: end if;
3238: end if;
3239:
3240: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','UPDATE_HR_COMPLETE','NONE','ENDED')then
3241: hr_utility.set_location('check ' ||l_action_taken,1);
3242: hr_utility.set_location('check ' ||l_mass_action_id,1);
3243: hr_utility.set_location('Check ' || l_rpa_type,1);
3244: -- Do not routing history if Template record for Mass Actions.
3245:

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

3238: end if;
3239:
3240: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','UPDATE_HR_COMPLETE','NONE','ENDED')then
3241: hr_utility.set_location('check ' ||l_action_taken,1);
3242: hr_utility.set_location('check ' ||l_mass_action_id,1);
3243: hr_utility.set_location('Check ' || l_rpa_type,1);
3244: -- Do not routing history if Template record for Mass Actions.
3245:
3246: -- If (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is not null --AVR

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

3239:
3240: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','UPDATE_HR_COMPLETE','NONE','ENDED')then
3241: hr_utility.set_location('check ' ||l_action_taken,1);
3242: hr_utility.set_location('check ' ||l_mass_action_id,1);
3243: hr_utility.set_location('Check ' || l_rpa_type,1);
3244: -- Do not routing history if Template record for Mass Actions.
3245:
3246: -- If (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is not null --AVR
3247: -- and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA') or --AVR

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

3248: -- (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null) then --AVR
3249:
3250: if nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' then --AVR
3251: if (nvl(l_rpa_type,hr_api.g_varchar2) = 'A' and l_action_taken = 'NOT_ROUTED' ) then --AVR
3252: hr_utility.set_location('Form Folder Updation ..Do not route ' ,1); --AVR
3253: else --AVR
3254:
3255: for cur_routing_history_id in C_routing_history_id loop
3256: l_u_pa_routing_history_id := cur_routing_history_id.pa_routing_history_id;

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

3256: l_u_pa_routing_history_id := cur_routing_history_id.pa_routing_history_id;
3257: l_u_prh_object_version_number := cur_routing_history_id.object_version_number;
3258: exit;
3259: end loop;
3260: hr_utility.set_location('in update sf52 api , user acted on is ' || p_u_user_name_acted_on,1);
3261: if p_u_user_name_acted_on is not null
3262: -- RP
3263: and p_u_user_name_acted_on <> hr_api.g_varchar2 then
3264: hr_utility.set_location(l_proc, 12);

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

3260: hr_utility.set_location('in update sf52 api , user acted on is ' || p_u_user_name_acted_on,1);
3261: if p_u_user_name_acted_on is not null
3262: -- RP
3263: and p_u_user_name_acted_on <> hr_api.g_varchar2 then
3264: hr_utility.set_location(l_proc, 12);
3265:
3266: ghr_pa_requests_pkg.get_roles
3267: (p_pa_request_id,
3268: p_routing_group_id,

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

3273: l_personnelist_flag,
3274: l_approver_flag,
3275: l_reviewer_flag
3276: );
3277: hr_utility.set_location(l_proc, 13);
3278:
3279: for name_rec in C_names loop
3280: l_user_name_employee_id := name_rec.employee_id ;
3281: l_user_name_emp_first_name := name_rec.first_name;

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

3285: end loop;
3286: end if;
3287: -- Update the latest record in the routing history for the specific request_id
3288:
3289: hr_utility.set_location(l_proc, 14);
3290:
3291: If l_action_taken = 'UPDATE_HR' and
3292: trunc(p_effective_date) > sysdate then
3293: l_action_taken := 'FUTURE_ACTION';

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

3352: if l_next_groupbox_id is null then
3353: l_next_groupbox_id := p_i_groupbox_id;
3354: end if;
3355: if l_next_seq_numb is null then
3356: hr_utility.set_message(8301, 'GHR_38114_NO_MORE_SEQ_NUMBER');
3357: hr_utility.raise_error;
3358: end if;
3359: end if;
3360:

Line 3357: hr_utility.raise_error;

3353: l_next_groupbox_id := p_i_groupbox_id;
3354: end if;
3355: if l_next_seq_numb is null then
3356: hr_utility.set_message(8301, 'GHR_38114_NO_MORE_SEQ_NUMBER');
3357: hr_utility.raise_error;
3358: end if;
3359: end if;
3360:
3361: hr_utility.set_location(l_proc, 20);

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

3357: hr_utility.raise_error;
3358: end if;
3359: end if;
3360:
3361: hr_utility.set_location(l_proc, 20);
3362: -- check for open events before attempting to route / Update HR
3363: hr_utility.set_location('Before check Open Events',1);
3364: ghr_sf52_api.check_for_open_events
3365: (

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

3359: end if;
3360:
3361: hr_utility.set_location(l_proc, 20);
3362: -- check for open events before attempting to route / Update HR
3363: hr_utility.set_location('Before check Open Events',1);
3364: ghr_sf52_api.check_for_open_events
3365: (
3366: p_pa_request_id => p_pa_request_id,
3367: p_message => l_message,

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

3377: p_message_set => l_message
3378: );
3379:
3380: if l_message then
3381: hr_utility.set_message(8301,'GHR_38592_OPEN_EVENTS_EXIST');
3382: hr_utility.raise_error;
3383: end if;
3384:
3385: -- Insert 2nd record into routing_history for routing details (with exceptions )

Line 3382: hr_utility.raise_error;

3378: );
3379:
3380: if l_message then
3381: hr_utility.set_message(8301,'GHR_38592_OPEN_EVENTS_EXIST');
3382: hr_utility.raise_error;
3383: end if;
3384:
3385: -- Insert 2nd record into routing_history for routing details (with exceptions )
3386:

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

3411: );
3412:
3413: end if;
3414:
3415: hr_utility.set_location('pAR' || to_char(l_par_object_version_number),1);
3416:
3417: if l_action_taken in ('UPDATE_HR','FUTURE_ACTION','END_ROUTING') then
3418: hr_utility.set_location(l_proc || p_award_amount,1);
3419: hr_utility.set_location(l_proc || p_award_percentage,1);

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

3414:
3415: hr_utility.set_location('pAR' || to_char(l_par_object_version_number),1);
3416:
3417: if l_action_taken in ('UPDATE_HR','FUTURE_ACTION','END_ROUTING') then
3418: hr_utility.set_location(l_proc || p_award_amount,1);
3419: hr_utility.set_location(l_proc || p_award_percentage,1);
3420:
3421: hr_utility.set_location(l_proc, 21);
3422: l_rec.pa_request_id := p_pa_request_id;

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

3415: hr_utility.set_location('pAR' || to_char(l_par_object_version_number),1);
3416:
3417: if l_action_taken in ('UPDATE_HR','FUTURE_ACTION','END_ROUTING') then
3418: hr_utility.set_location(l_proc || p_award_amount,1);
3419: hr_utility.set_location(l_proc || p_award_percentage,1);
3420:
3421: hr_utility.set_location(l_proc, 21);
3422: l_rec.pa_request_id := p_pa_request_id;
3423: l_rec.noa_family_code := p_noa_family_code;

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

3417: if l_action_taken in ('UPDATE_HR','FUTURE_ACTION','END_ROUTING') then
3418: hr_utility.set_location(l_proc || p_award_amount,1);
3419: hr_utility.set_location(l_proc || p_award_percentage,1);
3420:
3421: hr_utility.set_location(l_proc, 21);
3422: l_rec.pa_request_id := p_pa_request_id;
3423: l_rec.noa_family_code := p_noa_family_code;
3424: l_rec.routing_group_id := p_routing_group_id;
3425: If p_proposed_effective_asap_flag = hr_api.g_varchar2 then

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

3463: l_rec.employee_middle_names := p_employee_middle_names;
3464: l_rec.employee_national_identifier := p_employee_national_identifier;
3465: l_rec.fegli := p_fegli;
3466: l_rec.fegli_desc := p_fegli_desc;
3467: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 22);
3468: l_rec.first_action_la_code1 := p_first_action_la_code1;
3469: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 23);
3470: l_rec.first_action_la_code2 := p_first_action_la_code2;
3471: l_rec.first_action_la_desc1 := p_first_action_la_desc1;

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

3465: l_rec.fegli := p_fegli;
3466: l_rec.fegli_desc := p_fegli_desc;
3467: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 22);
3468: l_rec.first_action_la_code1 := p_first_action_la_code1;
3469: hr_utility.set_location('First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 23);
3470: l_rec.first_action_la_code2 := p_first_action_la_code2;
3471: l_rec.first_action_la_desc1 := p_first_action_la_desc1;
3472: l_rec.first_action_la_desc2 := p_first_action_la_desc2;
3473: l_rec.first_noa_cancel_or_correct := p_first_noa_cancel_or_correct;

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

3690: End if;
3691:
3692: l_rec.mass_action_comments := p_mass_action_comments;
3693: -- Bug# RRR Changes
3694: hr_utility.set_location('p_payment_option: '||p_payment_option,1);
3695: l_rec.pa_incentive_payment_option := p_payment_option;
3696: hr_utility.set_location('p_award_salary: '||p_award_salary,2);
3697: l_rec.award_salary := p_award_salary;
3698: hr_utility.set_location('After p_award_salary: ',3);

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

3692: l_rec.mass_action_comments := p_mass_action_comments;
3693: -- Bug# RRR Changes
3694: hr_utility.set_location('p_payment_option: '||p_payment_option,1);
3695: l_rec.pa_incentive_payment_option := p_payment_option;
3696: hr_utility.set_location('p_award_salary: '||p_award_salary,2);
3697: l_rec.award_salary := p_award_salary;
3698: hr_utility.set_location('After p_award_salary: ',3);
3699: -- Bug# RRR Changes
3700:

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

3694: hr_utility.set_location('p_payment_option: '||p_payment_option,1);
3695: l_rec.pa_incentive_payment_option := p_payment_option;
3696: hr_utility.set_location('p_award_salary: '||p_award_salary,2);
3697: l_rec.award_salary := p_award_salary;
3698: hr_utility.set_location('After p_award_salary: ',3);
3699: -- Bug# RRR Changes
3700:
3701: -- Convert the default values
3702: hr_utility.set_location('after l_rec assignment ',2);

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

3698: hr_utility.set_location('After p_award_salary: ',3);
3699: -- Bug# RRR Changes
3700:
3701: -- Convert the default values
3702: hr_utility.set_location('after l_rec assignment ',2);
3703: hr_utility.set_location('Before First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 3);
3704: ghr_par_bus.convert_defaults(l_rec);
3705: hr_utility.set_location('After First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 4);
3706:

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

3699: -- Bug# RRR Changes
3700:
3701: -- Convert the default values
3702: hr_utility.set_location('after l_rec assignment ',2);
3703: hr_utility.set_location('Before First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 3);
3704: ghr_par_bus.convert_defaults(l_rec);
3705: hr_utility.set_location('After First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 4);
3706:
3707: --

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

3701: -- Convert the default values
3702: hr_utility.set_location('after l_rec assignment ',2);
3703: hr_utility.set_location('Before First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 3);
3704: ghr_par_bus.convert_defaults(l_rec);
3705: hr_utility.set_location('After First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 4);
3706:
3707: --
3708: -- call update-hr
3709: hr_utility.set_location('l_ovn' || to_char(l_rec.object_version_number),2);

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

3705: hr_utility.set_location('After First LAC CODE is : ' ||l_proc || ' ' ||l_rec.first_action_la_code1, 4);
3706:
3707: --
3708: -- call update-hr
3709: hr_utility.set_location('l_ovn' || to_char(l_rec.object_version_number),2);
3710:
3711: If l_rec.effective_date is null then
3712: hr_utility.set_message(8301,'GHR_38185_EFF_DATE_REQUIRED');
3713: ghr_upd_hr_validation.form_item_name := 'PAR.EFFECTIVE_DATE';

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

3708: -- call update-hr
3709: hr_utility.set_location('l_ovn' || to_char(l_rec.object_version_number),2);
3710:
3711: If l_rec.effective_date is null then
3712: hr_utility.set_message(8301,'GHR_38185_EFF_DATE_REQUIRED');
3713: ghr_upd_hr_validation.form_item_name := 'PAR.EFFECTIVE_DATE';
3714: hr_utility.raise_error;
3715: End if;
3716: if (l_action_taken <> 'END_ROUTING') then

Line 3714: hr_utility.raise_error;

3710:
3711: If l_rec.effective_date is null then
3712: hr_utility.set_message(8301,'GHR_38185_EFF_DATE_REQUIRED');
3713: ghr_upd_hr_validation.form_item_name := 'PAR.EFFECTIVE_DATE';
3714: hr_utility.raise_error;
3715: End if;
3716: if (l_action_taken <> 'END_ROUTING') then
3717: ghr_process_sf52.process_sf52
3718: (p_sf52_data => l_rec

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

3735: );
3736: for ovn_rec in c_ovn loop
3737: l_rec.object_version_number := ovn_rec.object_version_number;
3738: end loop;
3739: hr_utility.set_location('to pos id is '|| l_rec.to_position_id,1);
3740: hr_utility.set_location('first noa code is '|| l_rec.first_noa_code,1);
3741: IF nvl(l_rec.first_noa_code,'9999') <> '002' THEN
3742: ghr_par_upd.upd
3743: (p_pa_request_id => p_pa_request_id,

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

3736: for ovn_rec in c_ovn loop
3737: l_rec.object_version_number := ovn_rec.object_version_number;
3738: end loop;
3739: hr_utility.set_location('to pos id is '|| l_rec.to_position_id,1);
3740: hr_utility.set_location('first noa code is '|| l_rec.first_noa_code,1);
3741: IF nvl(l_rec.first_noa_code,'9999') <> '002' THEN
3742: ghr_par_upd.upd
3743: (p_pa_request_id => p_pa_request_id,
3744: p_object_version_number => l_rec.object_version_number,

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

3837: end if; -- If template record for mass Award --- AVR
3838: elsif l_action_taken = 'NONE' then
3839: null;
3840: else
3841: hr_utility.set_message(8301,'GHR_38112_INVALID_API');
3842: hr_utility.raise_error;
3843: end if;
3844:
3845: If p_print_sf50_flag = 'Y' then

Line 3842: hr_utility.raise_error;

3838: elsif l_action_taken = 'NONE' then
3839: null;
3840: else
3841: hr_utility.set_message(8301,'GHR_38112_INVALID_API');
3842: hr_utility.raise_error;
3843: end if;
3844:
3845: If p_print_sf50_flag = 'Y' then
3846:

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

3844:
3845: If p_print_sf50_flag = 'Y' then
3846:
3847: If l_action_taken <> 'UPDATE_HR' then
3848: hr_utility.set_message(8301,'GHR_38399_52_NOT_PROCESSED');
3849: hr_utility.raise_error;
3850: End if;
3851: --Bug#3757201 Added p_back_page parameter
3852: submit_request_to_print_50

Line 3849: hr_utility.raise_error;

3845: If p_print_sf50_flag = 'Y' then
3846:
3847: If l_action_taken <> 'UPDATE_HR' then
3848: hr_utility.set_message(8301,'GHR_38399_52_NOT_PROCESSED');
3849: hr_utility.raise_error;
3850: End if;
3851: --Bug#3757201 Added p_back_page parameter
3852: submit_request_to_print_50
3853: (p_printer_name => p_printer_name,

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

4103: p_i_pa_routing_history_id := l_i_pa_routing_history_id;
4104: p_i_prh_object_version_number := l_i_prh_object_version_number;
4105: p_par_object_version_number := l_par_object_version_number;
4106: --
4107: hr_utility.set_location(' Leaving:'||l_proc, 11);
4108: exception
4109: when hr_api.validate_enabled then
4110: --
4111: -- As the Validate_Enabled exception has been raised

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

4131: p_i_pa_routing_history_id := null;
4132: p_i_prh_object_version_number := l_i_prh_object_version_number;
4133: Raise;
4134:
4135: hr_utility.set_location(' Leaving:'||l_proc, 12);
4136:
4137: end update_sf52;
4138:
4139: -- ----------------------------------------------------------------------------

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

4255: AND effective_end_date;
4256:
4257:
4258: begin
4259: hr_utility.set_location('Entering:'|| l_proc, 5);
4260: --
4261: -- Issue a savepoint
4262: --
4263: savepoint end_sf52;

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

4283: end;
4284: --
4285: -- End of Before Process User Hook call
4286: --
4287: hr_utility.set_location(l_proc, 6);
4288: l_par_object_version_number := p_par_object_version_number;
4289:
4290:
4291: If p_first_noa_code in ('001','002') then

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

4296: );
4297: End if;
4298:
4299: If not l_result then
4300: hr_utility.set_message(8301,'GHR_38264_INV_PA_REQ_CAN_COR');
4301: hr_utility.raise_error;
4302: End if;
4303:
4304: /***dk***/

Line 4301: hr_utility.raise_error;

4297: End if;
4298:
4299: If not l_result then
4300: hr_utility.set_message(8301,'GHR_38264_INV_PA_REQ_CAN_COR');
4301: hr_utility.raise_error;
4302: End if;
4303:
4304: /***dk***/
4305: -- Added ENDED to the following if.

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

4393:
4394: -- The foll. was Removed on 08/16 as per Vikram
4395:
4396: /* If l_user_name is null then
4397: hr_utility.set_message(8301,'GHR_38111_USER_NAME_REQD');
4398: hr_utility.raise_error;
4399: End if;
4400: */
4401:

Line 4398: hr_utility.raise_error;

4394: -- The foll. was Removed on 08/16 as per Vikram
4395:
4396: /* If l_user_name is null then
4397: hr_utility.set_message(8301,'GHR_38111_USER_NAME_REQD');
4398: hr_utility.raise_error;
4399: End if;
4400: */
4401:
4402:

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

4421: exit;
4422: end loop;
4423: end if;
4424:
4425: hr_utility.set_location('before upd to prh',1);
4426: hr_utility.set_location('emp id ' || to_char(l_user_name_employee_id),1);
4427:
4428: ghr_prh_upd.upd
4429: (p_pa_routing_history_id => l_pa_routing_history_id

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

4422: end loop;
4423: end if;
4424:
4425: hr_utility.set_location('before upd to prh',1);
4426: hr_utility.set_location('emp id ' || to_char(l_user_name_employee_id),1);
4427:
4428: ghr_prh_upd.upd
4429: (p_pa_routing_history_id => l_pa_routing_history_id
4430: ,p_user_name => l_user_name

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

4451: p_old_action_taken => l_old_action_taken
4452: );
4453:
4454: else
4455: hr_utility.set_location('action_taken: ' || p_action_taken ,1);
4456: hr_utility.set_message(8301,'GH_38112_INVALID_API');
4457: hr_utility.raise_error;
4458: end if;
4459:

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

4452: );
4453:
4454: else
4455: hr_utility.set_location('action_taken: ' || p_action_taken ,1);
4456: hr_utility.set_message(8301,'GH_38112_INVALID_API');
4457: hr_utility.raise_error;
4458: end if;
4459:
4460: --

Line 4457: hr_utility.raise_error;

4453:
4454: else
4455: hr_utility.set_location('action_taken: ' || p_action_taken ,1);
4456: hr_utility.set_message(8301,'GH_38112_INVALID_API');
4457: hr_utility.raise_error;
4458: end if;
4459:
4460: --
4461: -- Call After Process User Hook

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

4487:
4488: -- Set all output arguments
4489: --
4490:
4491: hr_utility.set_location(' Leaving:'||l_proc, 11);
4492: exception
4493: when hr_api.validate_enabled then
4494: --
4495: -- As the Validate_Enabled exception has been raised

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

4510: --
4511: p_par_object_version_number := l_par_object_version_number;
4512: Raise;
4513:
4514: hr_utility.set_location(' Leaving:'||l_proc, 12);
4515: end end_sf52;
4516:
4517:
4518:

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

4540: l_proc varchar2(30):='Cancel_corcan';
4541: l_object_version_number number;
4542:
4543: Begin
4544: hr_utility.set_location( 'entering :' || l_proc , 10);
4545: for get_req in c_get_req(p_altered_pa_request_id) loop
4546: l_req.first_noa_code := get_Req.first_noa_code;
4547: l_req.second_noa_code := get_req.second_noa_code;
4548: l_object_version_number := get_req.object_version_number;

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

4546: l_req.first_noa_code := get_Req.first_noa_code;
4547: l_req.second_noa_code := get_req.second_noa_code;
4548: l_object_version_number := get_req.object_version_number;
4549: if l_object_version_number is null then
4550: hr_utility.set_location( 'not found ' || l_proc, 20);
4551: p_result := FALSE;
4552: else
4553: if l_req.first_noa_code = p_noa_code_correct then
4554: hr_utility.set_location( 'first noa ' || l_proc, 30);

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

4550: hr_utility.set_location( 'not found ' || l_proc, 20);
4551: p_result := FALSE;
4552: else
4553: if l_req.first_noa_code = p_noa_code_correct then
4554: hr_utility.set_location( 'first noa ' || l_proc, 30);
4555: ghr_par_upd.upd
4556: (p_pa_request_id => p_altered_pa_request_id,
4557: p_object_version_number => l_object_version_number,
4558: -- p_first_noa_cancel_or_correct => null,

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

4559: p_first_noa_canc_pa_request_id => null
4560: );
4561:
4562: elsif l_req.second_noa_code = p_noa_code_correct then
4563: hr_utility.set_location( '2nd NOA ' || l_proc, 60);
4564: ghr_par_upd.upd
4565: (p_pa_request_id => p_altered_pa_request_id,
4566: p_object_version_number => l_object_version_number,
4567: -- p_second_noa_cancel_or_correct => null,

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

4567: -- p_second_noa_cancel_or_correct => null,
4568: p_second_noa_canc_pa_request_i=> null
4569: );
4570: else
4571: hr_utility.set_location( 'not found ' || l_proc, 90);
4572: p_result := FALSE;
4573: end if;
4574: end if;
4575: end loop;

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

4572: p_result := FALSE;
4573: end if;
4574: end if;
4575: end loop;
4576: hr_utility.set_location( 'Leaving :' || l_proc, 100);
4577: Exception when others then
4578: --
4579: -- Reset IN OUT parameters and set OUT parameters
4580: --

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

4603: where user_name = p_user_name;
4604:
4605: begin
4606: If trunc(p_effective_date) > trunc(sysdate) then
4607: hr_utility.set_message(8301,'GHR_38400_NO_50_FOR_FUT_ACT');
4608: hr_utility.raise_error;
4609: End if;
4610:
4611: If p_printer_name is null then

Line 4608: hr_utility.raise_error;

4604:
4605: begin
4606: If trunc(p_effective_date) > trunc(sysdate) then
4607: hr_utility.set_message(8301,'GHR_38400_NO_50_FOR_FUT_ACT');
4608: hr_utility.raise_error;
4609: End if;
4610:
4611: If p_printer_name is null then
4612: hr_utility.set_message(8301,'GHR_38394_NO_PRINTER');

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

4608: hr_utility.raise_error;
4609: End if;
4610:
4611: If p_printer_name is null then
4612: hr_utility.set_message(8301,'GHR_38394_NO_PRINTER');
4613: hr_utility.raise_error;
4614: Else
4615: l_set_print_options_status := fnd_request.set_print_options
4616: (PRINTER => p_printer_name

Line 4613: hr_utility.raise_error;

4609: End if;
4610:
4611: If p_printer_name is null then
4612: hr_utility.set_message(8301,'GHR_38394_NO_PRINTER');
4613: hr_utility.raise_error;
4614: Else
4615: l_set_print_options_status := fnd_request.set_print_options
4616: (PRINTER => p_printer_name
4617: ,STYLE => null

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

4619: ,SAVE_OUTPUT => TRUE
4620: ,PRINT_TOGETHER => 'N'
4621: );
4622: If not l_set_print_options_status THEN
4623: hr_utility.set_message(8301,'GHR_38190_FAIL_SET_PRINT_OPT');
4624: hr_utility.raise_error;
4625: Else
4626: for user_id in c_user_id loop
4627: l_user_id := user_id.user_id;

Line 4624: hr_utility.raise_error;

4620: ,PRINT_TOGETHER => 'N'
4621: );
4622: If not l_set_print_options_status THEN
4623: hr_utility.set_message(8301,'GHR_38190_FAIL_SET_PRINT_OPT');
4624: hr_utility.raise_error;
4625: Else
4626: for user_id in c_user_id loop
4627: l_user_id := user_id.user_id;
4628: end loop;

Line 4644: -- hr_utility.raise_error;

4640: );
4641: IF l_request_status = 0 THEN
4642: null;
4643: --hr_utiltity.set_message('error submitting the request');
4644: -- hr_utility.raise_error;
4645: Else
4646: commit;
4647: End if;
4648: End if;

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

4708:
4709:
4710: begin
4711:
4712: hr_utility.set_location('Entering ' || l_proc,5);
4713: hr_utility.set_location('PAR ' || to_char(p_pa_request_id),1);
4714: hr_utility.set_location('GB ' || to_char(p_groupbox_routed_to),1);
4715: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4716: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);

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

4709:
4710: begin
4711:
4712: hr_utility.set_location('Entering ' || l_proc,5);
4713: hr_utility.set_location('PAR ' || to_char(p_pa_request_id),1);
4714: hr_utility.set_location('GB ' || to_char(p_groupbox_routed_to),1);
4715: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4716: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4717: hr_utility.set_location('Action ' || (p_action_taken),1);

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

4710: begin
4711:
4712: hr_utility.set_location('Entering ' || l_proc,5);
4713: hr_utility.set_location('PAR ' || to_char(p_pa_request_id),1);
4714: hr_utility.set_location('GB ' || to_char(p_groupbox_routed_to),1);
4715: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4716: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4717: hr_utility.set_location('Action ' || (p_action_taken),1);
4718: If

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

4711:
4712: hr_utility.set_location('Entering ' || l_proc,5);
4713: hr_utility.set_location('PAR ' || to_char(p_pa_request_id),1);
4714: hr_utility.set_location('GB ' || to_char(p_groupbox_routed_to),1);
4715: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4716: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4717: hr_utility.set_location('Action ' || (p_action_taken),1);
4718: If
4719: ( nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' or

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

4712: hr_utility.set_location('Entering ' || l_proc,5);
4713: hr_utility.set_location('PAR ' || to_char(p_pa_request_id),1);
4714: hr_utility.set_location('GB ' || to_char(p_groupbox_routed_to),1);
4715: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4716: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4717: hr_utility.set_location('Action ' || (p_action_taken),1);
4718: If
4719: ( nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' or
4720: nvl(p_action_taken,hr_api.g_varchar2) = 'FUTURE_ACTION'

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

4713: hr_utility.set_location('PAR ' || to_char(p_pa_request_id),1);
4714: hr_utility.set_location('GB ' || to_char(p_groupbox_routed_to),1);
4715: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4716: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4717: hr_utility.set_location('Action ' || (p_action_taken),1);
4718: If
4719: ( nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' or
4720: nvl(p_action_taken,hr_api.g_varchar2) = 'FUTURE_ACTION'
4721: --**dk

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

4728: nvl(p_user_name_acted_on,hr_api.g_varchar2) <> p_user_name_routed_to
4729: ) or
4730: (p_groupbox_routed_to is not null )*/
4731:
4732: hr_utility.set_location(l_proc,10);
4733: for open_events in c_open_events loop
4734: hr_utility.set_location(l_proc,15);
4735: l_exists := TRUE;
4736: exit;

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

4730: (p_groupbox_routed_to is not null )*/
4731:
4732: hr_utility.set_location(l_proc,10);
4733: for open_events in c_open_events loop
4734: hr_utility.set_location(l_proc,15);
4735: l_exists := TRUE;
4736: exit;
4737: end loop;
4738: If l_exists then

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

4735: l_exists := TRUE;
4736: exit;
4737: end loop;
4738: If l_exists then
4739: hr_utility.set_location(l_proc,20);
4740: p_message := TRUE;
4741: Else
4742: hr_utility.set_location(l_proc,25);
4743: p_message := FALSE;

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

4738: If l_exists then
4739: hr_utility.set_location(l_proc,20);
4740: p_message := TRUE;
4741: Else
4742: hr_utility.set_location(l_proc,25);
4743: p_message := FALSE;
4744: End if;
4745: End if;
4746: hr_utility.set_location('Leaving ' || l_proc,30);

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

4742: hr_utility.set_location(l_proc,25);
4743: p_message := FALSE;
4744: End if;
4745: End if;
4746: hr_utility.set_location('Leaving ' || l_proc,30);
4747: Exception when others then
4748: --
4749: -- Reset IN OUT parameters and set OUT parameters
4750: --