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

Line 16: hr_utility.set_location('Entering '|| l_proc, 10);

12: v_ovn NUMBER;
13: v_pa_request_extra_info_id NUMBER;
14: l_proc varchar2(61) := g_package_name || 'CREATE_PA_REQUEST_EXTRA_INFO';
15: BEGIN
16: hr_utility.set_location('Entering '|| l_proc, 10);
17: FOR r_rei IN c_rei LOOP
18: ghr_par_extra_info_api.create_pa_request_extra_info(
19: p_pa_request_id => p_new_pa_request_id
20: ,p_information_type => r_rei.information_type

Line 77: hr_utility.set_location('Exiting '|| l_proc, 100);

73: ,p_pa_request_extra_info_id => v_pa_request_extra_info_id
74: ,p_object_version_number => v_ovn
75: );
76: END LOOP;
77: hr_utility.set_location('Exiting '|| l_proc, 100);
78: end;
79: -- -------------------------------------------------
80: PROCEDURE get_roles
81: -- -------------------------------------------------

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

119: l_personnelist_flag := p_personnelist_flag;
120: l_approver_flag := p_approver_flag;
121: l_reviewer_flag := p_reviewer_flag;
122:
123: hr_utility.set_location('Entering '|| l_proc, 5);
124:
125: OPEN c_user_roles;
126: FETCH c_user_roles INTO
127: p_initiator_flag

Line 135: hr_utility.set_location('Exiting '|| l_proc, 15);

131: ,p_approver_flag
132: ,p_reviewer_flag;
133:
134: CLOSE c_user_roles;
135: hr_utility.set_location('Exiting '|| l_proc, 15);
136:
137: EXCEPTION
138: WHEN OTHERS THEN
139: p_initiator_flag := l_initiator_flag;

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

215: l_total_actions number;
216: l_corrections number;
217: l_rpas number;
218: BEGIN
219: hr_utility.set_location('Entering '|| l_proc, 5);
220: l_total_actions := p_total_actions;
221: l_corrections := p_corrections;
222: l_rpas := p_rpas;
223: p_total_actions := 0;

Line 285: hr_utility.set_location(l_proc || ' First Pa Request ID : ' || to_char(l_first_pa_request_rec.pa_request_id), 10);

281: fnd_message.set_token('CORRECT', p_corrections);
282: END IF;
283: */
284:
285: hr_utility.set_location(l_proc || ' First Pa Request ID : ' || to_char(l_first_pa_request_rec.pa_request_id), 10);
286: hr_utility.set_location(l_proc || ' Last Pa Request ID : ' || to_char(l_last_pa_request_rec.pa_request_id), 20);
287: hr_utility.set_location('Exiting '|| l_proc, 500);
288: EXCEPTION
289: WHEN OTHERS THEN

Line 286: hr_utility.set_location(l_proc || ' Last Pa Request ID : ' || to_char(l_last_pa_request_rec.pa_request_id), 20);

282: END IF;
283: */
284:
285: hr_utility.set_location(l_proc || ' First Pa Request ID : ' || to_char(l_first_pa_request_rec.pa_request_id), 10);
286: hr_utility.set_location(l_proc || ' Last Pa Request ID : ' || to_char(l_last_pa_request_rec.pa_request_id), 20);
287: hr_utility.set_location('Exiting '|| l_proc, 500);
288: EXCEPTION
289: WHEN OTHERS THEN
290: p_total_actions := l_total_actions;

Line 287: hr_utility.set_location('Exiting '|| l_proc, 500);

283: */
284:
285: hr_utility.set_location(l_proc || ' First Pa Request ID : ' || to_char(l_first_pa_request_rec.pa_request_id), 10);
286: hr_utility.set_location(l_proc || ' Last Pa Request ID : ' || to_char(l_last_pa_request_rec.pa_request_id), 20);
287: hr_utility.set_location('Exiting '|| l_proc, 500);
288: EXCEPTION
289: WHEN OTHERS THEN
290: p_total_actions := l_total_actions;
291: p_corrections := l_corrections;

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

456: l_number_of_requests number;
457:
458: BEGIN
459:
460: hr_utility.set_location('Entering '|| l_proc, 5);
461: l_first_pa_request_rec := p_first_pa_request_rec;
462: l_last_pa_request_rec := p_last_pa_request_rec;
463: l_number_of_requests := p_number_of_requests;
464:

Line 468: hr_utility.set_location(l_proc || ' First PA Request id ' || p_first_pa_request_rec.pa_request_id, 15);

464:
465: OPEN c_pa_request(chartorowid(p_row_id));
466: FETCH c_pa_request INTO p_first_pa_request_rec;
467: CLOSE c_pa_request;
468: hr_utility.set_location(l_proc || ' First PA Request id ' || p_first_pa_request_rec.pa_request_id, 15);
469: hr_utility.set_location(l_proc || ' First Family Code ' || p_first_pa_request_rec.noa_family_code, 25);
470: hr_utility.set_location(l_proc || ' First Person Id ' || p_first_pa_request_rec.person_id, 35);
471: hr_utility.set_location(l_proc || ' First ROW Id ' || rowidtochar(p_row_id), 40);
472: hr_utility.set_location(l_proc || ' Which NOA ' || p_which_noa, 43);

Line 469: hr_utility.set_location(l_proc || ' First Family Code ' || p_first_pa_request_rec.noa_family_code, 25);

465: OPEN c_pa_request(chartorowid(p_row_id));
466: FETCH c_pa_request INTO p_first_pa_request_rec;
467: CLOSE c_pa_request;
468: hr_utility.set_location(l_proc || ' First PA Request id ' || p_first_pa_request_rec.pa_request_id, 15);
469: hr_utility.set_location(l_proc || ' First Family Code ' || p_first_pa_request_rec.noa_family_code, 25);
470: hr_utility.set_location(l_proc || ' First Person Id ' || p_first_pa_request_rec.person_id, 35);
471: hr_utility.set_location(l_proc || ' First ROW Id ' || rowidtochar(p_row_id), 40);
472: hr_utility.set_location(l_proc || ' Which NOA ' || p_which_noa, 43);
473:

Line 470: hr_utility.set_location(l_proc || ' First Person Id ' || p_first_pa_request_rec.person_id, 35);

466: FETCH c_pa_request INTO p_first_pa_request_rec;
467: CLOSE c_pa_request;
468: hr_utility.set_location(l_proc || ' First PA Request id ' || p_first_pa_request_rec.pa_request_id, 15);
469: hr_utility.set_location(l_proc || ' First Family Code ' || p_first_pa_request_rec.noa_family_code, 25);
470: hr_utility.set_location(l_proc || ' First Person Id ' || p_first_pa_request_rec.person_id, 35);
471: hr_utility.set_location(l_proc || ' First ROW Id ' || rowidtochar(p_row_id), 40);
472: hr_utility.set_location(l_proc || ' Which NOA ' || p_which_noa, 43);
473:
474: p_number_of_requests := -1;

Line 471: hr_utility.set_location(l_proc || ' First ROW Id ' || rowidtochar(p_row_id), 40);

467: CLOSE c_pa_request;
468: hr_utility.set_location(l_proc || ' First PA Request id ' || p_first_pa_request_rec.pa_request_id, 15);
469: hr_utility.set_location(l_proc || ' First Family Code ' || p_first_pa_request_rec.noa_family_code, 25);
470: hr_utility.set_location(l_proc || ' First Person Id ' || p_first_pa_request_rec.person_id, 35);
471: hr_utility.set_location(l_proc || ' First ROW Id ' || rowidtochar(p_row_id), 40);
472: hr_utility.set_location(l_proc || ' Which NOA ' || p_which_noa, 43);
473:
474: p_number_of_requests := -1;
475: /*

Line 472: hr_utility.set_location(l_proc || ' Which NOA ' || p_which_noa, 43);

468: hr_utility.set_location(l_proc || ' First PA Request id ' || p_first_pa_request_rec.pa_request_id, 15);
469: hr_utility.set_location(l_proc || ' First Family Code ' || p_first_pa_request_rec.noa_family_code, 25);
470: hr_utility.set_location(l_proc || ' First Person Id ' || p_first_pa_request_rec.person_id, 35);
471: hr_utility.set_location(l_proc || ' First ROW Id ' || rowidtochar(p_row_id), 40);
472: hr_utility.set_location(l_proc || ' Which NOA ' || p_which_noa, 43);
473:
474: p_number_of_requests := -1;
475: /*
476: FOR r_get_last_request IN c_get_last_request LOOP

Line 499: hr_utility.set_location(l_proc || ' last PA Request id ' || p_last_pa_request_rec.pa_request_id, 45);

495:
496: OPEN c_pa_request(l_last_row.row_id);
497: FETCH c_pa_request INTO p_last_pa_request_rec;
498: CLOSE c_pa_request;
499: hr_utility.set_location(l_proc || ' last PA Request id ' || p_last_pa_request_rec.pa_request_id, 45);
500: hr_utility.set_location(l_proc || ' Last ROW Id ' || rowidtochar(l_last_row.row_id), 55);
501: hr_utility.set_location('Exiting '|| l_proc, 500);
502: EXCEPTION
503: WHEN OTHERS THEN

Line 500: hr_utility.set_location(l_proc || ' Last ROW Id ' || rowidtochar(l_last_row.row_id), 55);

496: OPEN c_pa_request(l_last_row.row_id);
497: FETCH c_pa_request INTO p_last_pa_request_rec;
498: CLOSE c_pa_request;
499: hr_utility.set_location(l_proc || ' last PA Request id ' || p_last_pa_request_rec.pa_request_id, 45);
500: hr_utility.set_location(l_proc || ' Last ROW Id ' || rowidtochar(l_last_row.row_id), 55);
501: hr_utility.set_location('Exiting '|| l_proc, 500);
502: EXCEPTION
503: WHEN OTHERS THEN
504: p_first_pa_request_rec := l_first_pa_request_rec;

Line 501: hr_utility.set_location('Exiting '|| l_proc, 500);

497: FETCH c_pa_request INTO p_last_pa_request_rec;
498: CLOSE c_pa_request;
499: hr_utility.set_location(l_proc || ' last PA Request id ' || p_last_pa_request_rec.pa_request_id, 45);
500: hr_utility.set_location(l_proc || ' Last ROW Id ' || rowidtochar(l_last_row.row_id), 55);
501: hr_utility.set_location('Exiting '|| l_proc, 500);
502: EXCEPTION
503: WHEN OTHERS THEN
504: p_first_pa_request_rec := l_first_pa_request_rec;
505: p_last_pa_request_rec := l_last_pa_request_rec;

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

559: --
560: v_old_pa_request_id NUMBER;
561: --
562: begin
563: hr_utility.set_location('Entering '|| l_proc, 5);
564: l_par_object_version_number1 := p_par_object_version_number;
565:
566: -- Get PA Request
567: open c_pa_req;

Line 597: hr_utility.set_location('First NOA Id '|| to_char(l_pa_req_rec.first_noa_id), 10);

593: Open c_noa_id(l_pa_req_rec.first_noa_code, l_pa_req_rec.effective_date);
594: fetch c_noa_id into l_pa_req_rec.first_noa_id, l_pa_req_rec.first_noa_desc;
595: close c_noa_id;
596: --
597: hr_utility.set_location('First NOA Id '|| to_char(l_pa_req_rec.first_noa_id), 10);
598: --
599: l_pa_req_rec.first_action_la_code1 := p_cancel_legal_authority;
600: l_pa_req_rec.first_action_la_code2 := null;
601: l_pa_req_rec.first_action_la_desc1 := null;

Line 651: hr_utility.set_location('Creating SF52 - p_username '||p_username || '-'|| l_proc, 15);

647: ---END Bug # 2951865
648:
649: l_pa_req_rec.custom_pay_calc_flag := 'N';
650: --
651: hr_utility.set_location('Creating SF52 - p_username '||p_username || '-'|| l_proc, 15);
652: --
653: Ghr_sf52_api.create_sf52(
654: p_noa_family_code => l_pa_req_rec.noa_family_code
655: , p_routing_group_id => l_pa_req_rec.routing_group_id

Line 863: hr_utility.set_location('Created SF52 - OVN '||to_char(l_par_object_version_number)|| '-'|| l_proc, 20);

859: -- Bug#4486823 RRR Changes
860: , p_payment_option => l_pa_req_rec.pa_incentive_payment_option
861: );
862: --
863: hr_utility.set_location('Created SF52 - OVN '||to_char(l_par_object_version_number)|| '-'|| l_proc, 20);
864: --
865: create_pa_request_extra_info(
866: p_new_pa_request_id => l_pa_req_rec.pa_request_id
867: ,p_old_pa_request_id => v_old_pa_request_id);

Line 964: hr_utility.set_location('Created SF52 Shadow ' || l_proc, 22);

960: l_pa_req_rec.employee_national_identifier,
961: l_pa_req_rec.employee_date_of_birth
962: );
963: --
964: hr_utility.set_location('Created SF52 Shadow ' || l_proc, 22);
965: --
966: if l_pa_req_rec.first_noa_code = '002' then
967: l_noa_cancel_or_correct := ghr_history_api.g_correct;
968: else

Line 971: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_pa_req_rec.pa_request_id)|| '-'|| l_proc, 22);

967: l_noa_cancel_or_correct := ghr_history_api.g_correct;
968: else
969: l_noa_cancel_or_correct := ghr_history_api.g_cancel;
970: end if;
971: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_pa_req_rec.pa_request_id)|| '-'|| l_proc, 22);
972: hr_utility.set_location('Updating SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 25);
973: hr_utility.set_location(l_proc || 'Which NOA and Action ' || to_char(p_which_noa) || ' '|| p_which_action, 35);
974: if p_which_noa = 1 then
975: IF p_which_action = 'ORIGINAL' THEN

Line 972: hr_utility.set_location('Updating SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 25);

968: else
969: l_noa_cancel_or_correct := ghr_history_api.g_cancel;
970: end if;
971: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_pa_req_rec.pa_request_id)|| '-'|| l_proc, 22);
972: hr_utility.set_location('Updating SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 25);
973: hr_utility.set_location(l_proc || 'Which NOA and Action ' || to_char(p_which_noa) || ' '|| p_which_action, 35);
974: if p_which_noa = 1 then
975: IF p_which_action = 'ORIGINAL' THEN
976: ghr_par_upd.upd(

Line 973: hr_utility.set_location(l_proc || 'Which NOA and Action ' || to_char(p_which_noa) || ' '|| p_which_action, 35);

969: l_noa_cancel_or_correct := ghr_history_api.g_cancel;
970: end if;
971: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_pa_req_rec.pa_request_id)|| '-'|| l_proc, 22);
972: hr_utility.set_location('Updating SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 25);
973: hr_utility.set_location(l_proc || 'Which NOA and Action ' || to_char(p_which_noa) || ' '|| p_which_action, 35);
974: if p_which_noa = 1 then
975: IF p_which_action = 'ORIGINAL' THEN
976: ghr_par_upd.upd(
977: P_PA_REQUEST_ID => p_pa_request_id

Line 1005: hr_utility.set_location('Updated SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 45);

1001: , p_second_noa_cancel_or_correct => l_noa_cancel_or_correct
1002: );
1003: END IF;
1004: end if;
1005: hr_utility.set_location('Updated SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 45);
1006: -- commit;
1007: hr_utility.set_location('Exiting '|| l_proc, 50);
1008: return l_pa_req_rec.PA_REQUEST_ID;
1009: EXCEPTION

Line 1007: hr_utility.set_location('Exiting '|| l_proc, 50);

1003: END IF;
1004: end if;
1005: hr_utility.set_location('Updated SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 45);
1006: -- commit;
1007: hr_utility.set_location('Exiting '|| l_proc, 50);
1008: return l_pa_req_rec.PA_REQUEST_ID;
1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: p_par_object_version_number := l_par_object_version_number1;

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

1133: -- End Bug 2681842 and 3191676
1134:
1135: begin
1136: --
1137: hr_utility.set_location('Entering '|| l_proc, 5);
1138:
1139: find_last_request(p_pa_request_id => p_pa_request_id
1140: , p_which_noa => p_which_noa
1141: , p_row_id => p_row_id

Line 1145: hr_utility.set_location(l_proc || 'Last PA Request ID ' || to_char(l_last_pa_request_rec.pa_request_id), 15);

1141: , p_row_id => p_row_id
1142: , p_first_pa_request_rec => l_first_pa_request_rec
1143: , p_last_pa_request_rec => l_last_pa_request_rec
1144: , p_number_of_requests => l_corrections);
1145: hr_utility.set_location(l_proc || 'Last PA Request ID ' || to_char(l_last_pa_request_rec.pa_request_id), 15);
1146: IF l_last_pa_request_rec.pa_notification_id IS NULL THEN
1147: l_corrections := -1;
1148: fnd_message.set_name('GHR', 'GHR_CANCEL_INVALID');
1149: fnd_message.raise_error;

Line 1224: hr_utility.set_location('noa family code is' || l_noa_family_code ,20);

1220: -- Bug#3941541
1221: IF l_pa_req_rec.second_noa_code = '825' THEN
1222: l_noa_family_code := 'GHR_INCENTIVE';
1223: END IF;
1224: hr_utility.set_location('noa family code is' || l_noa_family_code ,20);
1225: IF nvl(l_noa_family_code,hr_api.g_varchar2) not in
1226: ('APP','APPT_TRANS','APPT_INFO') THEN
1227: hr_utility.set_location('notification id is' || l_pa_req_rec.pa_notification_id,22 );
1228: --BUG # 7216635 Added the parameter p_noa_id_correct

Line 1227: hr_utility.set_location('notification id is' || l_pa_req_rec.pa_notification_id,22 );

1223: END IF;
1224: hr_utility.set_location('noa family code is' || l_noa_family_code ,20);
1225: IF nvl(l_noa_family_code,hr_api.g_varchar2) not in
1226: ('APP','APPT_TRANS','APPT_INFO') THEN
1227: hr_utility.set_location('notification id is' || l_pa_req_rec.pa_notification_id,22 );
1228: --BUG # 7216635 Added the parameter p_noa_id_correct
1229: GHR_APPROVED_PA_REQUESTS.determine_ia(
1230: p_pa_request_id => p_pa_request_id,
1231: p_pa_notification_id => l_pa_notification_id,

Line 1242: hr_utility.set_location('Intervening Action '||l_effective_date,10);

1238: p_retro_second_noa => l_retro_second_noa);
1239:
1240: IF l_effective_date is NOT NULL THEN
1241: l_ia_flag := 'Y';
1242: hr_utility.set_location('Intervening Action '||l_effective_date,10);
1243: IF l_retro_first_noa = '866' then
1244: l_effective_date := l_effective_date + 1;
1245: END IF;
1246: END IF;

Line 1258: hr_utility.set_location('IA Action ',11);

1254: l_retro_noa_family_code := c_noa_fam.noa_family_code;
1255: END LOOP;
1256: END IF;
1257: END LOOP;
1258: hr_utility.set_location('IA Action ',11);
1259: -- Bug 3381960
1260: -- If the retro action is cancellation action, then consider the RPA
1261: -- previous to this Cancellation RPA and use that for populating
1262: -- from side of this correction action.

Line 1267: hr_utility.set_location('Cancellation RPA',11);

1263:
1264: IF NVL(l_retro_first_noa,hr_api.g_varchar2) = '001' THEN
1265: -- Get the To side of the RPA previous to this cancellation action
1266: -- Need to modify the cursor. Need to add Order of processing too
1267: hr_utility.set_location('Cancellation RPA',11);
1268: FOR l_pa_before_retro IN c_pa_before_retro(l_effective_date,l_pa_req_rec.person_id) LOOP
1269: l_prev_retro_pa_rec := l_pa_before_retro;
1270: EXIT;
1271: END LOOP;

Line 1306: hr_utility.set_location('From Side data only MRPA',11);

1302: 'AWARD',
1303: 'GHR_INCENTIVE'
1304: )
1305: THEN
1306: hr_utility.set_location('From Side data only MRPA',11);
1307: for c_ret_rec in c_retro_pa_req loop
1308: l_pa_req_rec.from_position_id := c_ret_rec.from_position_id;
1309: l_pa_req_rec.from_position_title := c_ret_rec.from_position_title;
1310: l_pa_req_rec.from_position_number := c_ret_rec.from_position_number;

Line 1336: hr_utility.set_location('Non Cancel MRPA: ',11);

1332: l_pa_req_rec.from_position_org_line6 := c_ret_rec.from_position_org_line6;
1333: exit;
1334: end loop;
1335: ELSE
1336: hr_utility.set_location('Non Cancel MRPA: ',11);
1337: for c_ret_rec in c_retro_pa_req loop
1338: l_pa_req_rec.from_position_id := c_ret_rec.to_position_id;
1339: l_pa_req_rec.from_position_title := c_ret_rec.to_position_title;
1340: l_pa_req_rec.from_position_number := c_ret_rec.to_position_number;

Line 1366: hr_utility.set_location('non IA : '||l_pa_req_rec.pay_rate_determinant,11);

1362: exit;
1363: end loop;
1364: END IF;
1365: ELSE
1366: hr_utility.set_location('non IA : '||l_pa_req_rec.pay_rate_determinant,11);
1367: l_noa_id_correct := hr_api.g_number;
1368: l_altered_pa_request_id := l_pa_req_rec.altered_pa_request_id;
1369: GHR_API.sf52_from_data_elements(
1370: p_person_id => l_pa_req_rec.person_id

Line 1532: hr_utility.set_location('Inserting incentive records',0);

1528:
1529: );
1530:
1531: IF nvl(l_noa_family_code,hr_api.g_varchar2) = 'GHR_INCENTIVE' THEN
1532: hr_utility.set_location('Inserting incentive records',0);
1533: INSERT INTO ghr_pa_incentives( pa_incentive_id,
1534: pa_request_id ,
1535: pa_incentive_category,
1536: pa_incentive_category_percent ,

Line 1550: hr_utility.set_location('After Inserting incentive records',10);

1546: pa_incentive_category_pmnt_dt ,
1547: pa_incentive_category_end_date
1548: FROM GHR_PA_INCENTIVES
1549: WHERE pa_request_id = l_pa_req_rec.altered_pa_request_id;
1550: hr_utility.set_location('After Inserting incentive records',10);
1551: END IF;
1552: -- Bug#4486823 RRR Changes
1553:
1554: hr_utility.set_location('Created SF52 - Altered PA Request ID '||to_char(l_pa_req_rec.altered_pa_request_id)|| '-'|| l_proc, 21);

Line 1554: hr_utility.set_location('Created SF52 - Altered PA Request ID '||to_char(l_pa_req_rec.altered_pa_request_id)|| '-'|| l_proc, 21);

1550: hr_utility.set_location('After Inserting incentive records',10);
1551: END IF;
1552: -- Bug#4486823 RRR Changes
1553:
1554: hr_utility.set_location('Created SF52 - Altered PA Request ID '||to_char(l_pa_req_rec.altered_pa_request_id)|| '-'|| l_proc, 21);
1555: hr_utility.set_location('Created SF52 - PA request ID '||to_char(l_pa_req_rec.pa_request_id)|| '-'|| l_proc, 22);
1556: insert into ghr_pa_request_shadow (
1557: pa_request_id,
1558: academic_discipline,

Line 1555: hr_utility.set_location('Created SF52 - PA request ID '||to_char(l_pa_req_rec.pa_request_id)|| '-'|| l_proc, 22);

1551: END IF;
1552: -- Bug#4486823 RRR Changes
1553:
1554: hr_utility.set_location('Created SF52 - Altered PA Request ID '||to_char(l_pa_req_rec.altered_pa_request_id)|| '-'|| l_proc, 21);
1555: hr_utility.set_location('Created SF52 - PA request ID '||to_char(l_pa_req_rec.pa_request_id)|| '-'|| l_proc, 22);
1556: insert into ghr_pa_request_shadow (
1557: pa_request_id,
1558: academic_discipline,
1559: annuitant_indicator,

Line 1652: hr_utility.set_location('Created SF52 Shadow ' || l_proc, 22);

1648: l_pa_req_rec.employee_national_identifier,
1649: l_pa_req_rec.employee_date_of_birth
1650: );
1651: --
1652: hr_utility.set_location('Created SF52 Shadow ' || l_proc, 22);
1653: --
1654: if l_pa_req_rec.first_noa_code = '002' then
1655: l_noa_cancel_or_correct := ghr_history_api.g_correct;
1656: else

Line 1659: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 22);

1655: l_noa_cancel_or_correct := ghr_history_api.g_correct;
1656: else
1657: l_noa_cancel_or_correct := ghr_history_api.g_cancel;
1658: end if;
1659: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 22);
1660: hr_utility.set_location(l_proc || ' Last rows object version # ' || to_char(l_last_pa_request_rec.object_version_number), 20);
1661: hr_utility.set_location('Updating SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1662: hr_utility.set_location('Updated SF52 - PA Request ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 26);
1663: if l_which_noa = 1 then

Line 1660: hr_utility.set_location(l_proc || ' Last rows object version # ' || to_char(l_last_pa_request_rec.object_version_number), 20);

1656: else
1657: l_noa_cancel_or_correct := ghr_history_api.g_cancel;
1658: end if;
1659: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 22);
1660: hr_utility.set_location(l_proc || ' Last rows object version # ' || to_char(l_last_pa_request_rec.object_version_number), 20);
1661: hr_utility.set_location('Updating SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1662: hr_utility.set_location('Updated SF52 - PA Request ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 26);
1663: if l_which_noa = 1 then
1664: ghr_par_upd.upd(

Line 1661: hr_utility.set_location('Updating SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);

1657: l_noa_cancel_or_correct := ghr_history_api.g_cancel;
1658: end if;
1659: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 22);
1660: hr_utility.set_location(l_proc || ' Last rows object version # ' || to_char(l_last_pa_request_rec.object_version_number), 20);
1661: hr_utility.set_location('Updating SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1662: hr_utility.set_location('Updated SF52 - PA Request ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 26);
1663: if l_which_noa = 1 then
1664: ghr_par_upd.upd(
1665: P_PA_REQUEST_ID => l_last_pa_request_rec.pa_request_id

Line 1662: hr_utility.set_location('Updated SF52 - PA Request ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 26);

1658: end if;
1659: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 22);
1660: hr_utility.set_location(l_proc || ' Last rows object version # ' || to_char(l_last_pa_request_rec.object_version_number), 20);
1661: hr_utility.set_location('Updating SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1662: hr_utility.set_location('Updated SF52 - PA Request ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 26);
1663: if l_which_noa = 1 then
1664: ghr_par_upd.upd(
1665: P_PA_REQUEST_ID => l_last_pa_request_rec.pa_request_id
1666: , P_OBJECT_VERSION_NUMBER => l_last_pa_request_rec.object_version_number

Line 1678: hr_utility.set_location('Updated SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);

1674: , p_second_noa_pa_request_id => l_last_pa_request_rec.pa_request_id
1675: , p_second_noa_cancel_or_correct => l_noa_cancel_or_correct
1676: );
1677: end if;
1678: hr_utility.set_location('Updated SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1679: -- commit;
1680: --
1681: hr_utility.set_location('Exiting '|| l_proc, 15);
1682: --

Line 1681: hr_utility.set_location('Exiting '|| l_proc, 15);

1677: end if;
1678: hr_utility.set_location('Updated SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1679: -- commit;
1680: --
1681: hr_utility.set_location('Exiting '|| l_proc, 15);
1682: --
1683: return l_pa_req_rec.PA_REQUEST_ID;
1684:
1685: end;

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

1716: l_par_object_version_number1 number;
1717: --
1718: begin
1719: --
1720: hr_utility.set_location('Entering '|| l_proc, 5);
1721: l_par_object_version_number1 := p_par_object_version_number;
1722: --
1723: get_roles(
1724: P_ROUTING_GROUP_ID => P_ROUTING_GROUP_ID

Line 1744: hr_utility.set_location('after get_roles'||P_ROUTING_GROUP_ID ,123456);

1740: return FALSE;
1741: -- set this message here to retrieve the same under form
1742: END IF;
1743:
1744: hr_utility.set_location('after get_roles'||P_ROUTING_GROUP_ID ,123456);
1745: --
1746: l_return_value := (L_APPROVER_FLAG = 'Y' AND L_PERSONNELIST_FLAG = 'Y');
1747: --
1748: hr_utility.set_location('Roles Approver = ' || L_APPROVER_FLAG ||

Line 1748: hr_utility.set_location('Roles Approver = ' || L_APPROVER_FLAG ||

1744: hr_utility.set_location('after get_roles'||P_ROUTING_GROUP_ID ,123456);
1745: --
1746: l_return_value := (L_APPROVER_FLAG = 'Y' AND L_PERSONNELIST_FLAG = 'Y');
1747: --
1748: hr_utility.set_location('Roles Approver = ' || L_APPROVER_FLAG ||
1749: ' PERSONNELIST= ' || L_PERSONNELIST_FLAG || l_proc, 10);
1750: --
1751: if l_return_value then
1752: hr_utility.set_location('l_return_value is TRUE',10);

Line 1752: hr_utility.set_location('l_return_value is TRUE',10);

1748: hr_utility.set_location('Roles Approver = ' || L_APPROVER_FLAG ||
1749: ' PERSONNELIST= ' || L_PERSONNELIST_FLAG || l_proc, 10);
1750: --
1751: if l_return_value then
1752: hr_utility.set_location('l_return_value is TRUE',10);
1753: ghr_api.call_workflow(p_pa_request_id, 'CONTINUE');
1754:
1755: hr_utility.set_location('Re routed '|| l_proc, 15);
1756: hr_utility.set_location('Updated PA Requests '|| l_proc, 20);

Line 1755: hr_utility.set_location('Re routed '|| l_proc, 15);

1751: if l_return_value then
1752: hr_utility.set_location('l_return_value is TRUE',10);
1753: ghr_api.call_workflow(p_pa_request_id, 'CONTINUE');
1754:
1755: hr_utility.set_location('Re routed '|| l_proc, 15);
1756: hr_utility.set_location('Updated PA Requests '|| l_proc, 20);
1757: else
1758: -- return false otherwise instead of throwing error mesg
1759: -- Fix for 4145758

Line 1756: hr_utility.set_location('Updated PA Requests '|| l_proc, 20);

1752: hr_utility.set_location('l_return_value is TRUE',10);
1753: ghr_api.call_workflow(p_pa_request_id, 'CONTINUE');
1754:
1755: hr_utility.set_location('Re routed '|| l_proc, 15);
1756: hr_utility.set_location('Updated PA Requests '|| l_proc, 20);
1757: else
1758: -- return false otherwise instead of throwing error mesg
1759: -- Fix for 4145758
1760: hr_utility.set_location('l_return_value is FALSE',10);

Line 1760: hr_utility.set_location('l_return_value is FALSE',10);

1756: hr_utility.set_location('Updated PA Requests '|| l_proc, 20);
1757: else
1758: -- return false otherwise instead of throwing error mesg
1759: -- Fix for 4145758
1760: hr_utility.set_location('l_return_value is FALSE',10);
1761: fnd_message.set_name('GHR', 'GHR_38550_REROUTE');
1762: return l_return_value;
1763: end if;
1764: --

Line 1765: hr_utility.set_location('Exiting '|| l_proc, 25);

1761: fnd_message.set_name('GHR', 'GHR_38550_REROUTE');
1762: return l_return_value;
1763: end if;
1764: --
1765: hr_utility.set_location('Exiting '|| l_proc, 25);
1766: --
1767: return l_return_value;
1768: EXCEPTION
1769: WHEN OTHERS THEN

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

1810: l_retro_first_noa ghr_nature_of_actions.code%type;
1811: l_retro_second_noa ghr_nature_of_actions.code%type;
1812: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
1813: BEGIN
1814: hr_utility.set_location('Entering '|| l_proc, 5);
1815: -- Determine Intervening Action
1816: --BUG # 7216635 Added the parameter p_noa_id_correct
1817: GHR_APPROVED_PA_REQUESTS.determine_ia(
1818: p_pa_request_id => p_pa_request_id,

Line 1832: hr_utility.set_location('Multiple IA action'|| l_proc, 15);

1828: -- Check for the presence of multiple intervening actions
1829: FOR c_multi_ia_rec IN c_multi_ia
1830: LOOP
1831: -- Check for out of sequence
1832: hr_utility.set_location('Multiple IA action'|| l_proc, 15);
1833: FOR c_out_seq IN c_out_of_seq
1834: LOOP
1835: hr_utility.set_location('Out of Sequence Action'|| l_proc, 20);
1836: return 0;

Line 1835: hr_utility.set_location('Out of Sequence Action'|| l_proc, 20);

1831: -- Check for out of sequence
1832: hr_utility.set_location('Multiple IA action'|| l_proc, 15);
1833: FOR c_out_seq IN c_out_of_seq
1834: LOOP
1835: hr_utility.set_location('Out of Sequence Action'|| l_proc, 20);
1836: return 0;
1837: END LOOP;
1838: exit;
1839: END LOOP;

Line 1841: hr_utility.set_location('Leaving '|| l_proc, 25);

1837: END LOOP;
1838: exit;
1839: END LOOP;
1840: END IF;
1841: hr_utility.set_location('Leaving '|| l_proc, 25);
1842: return 1;
1843: END;
1844:
1845: procedure determine_ia (

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

1893: l_proc varchar2(61) := g_package_name || 'determine_ia';
1894: chk_order boolean;
1895:
1896: BEGIN
1897: hr_utility.set_location('Entering '|| l_proc, 5);
1898:
1899: p_retro_eff_date := NULL;
1900: -- Determine Intervening Action
1901: FOR c_det_ia_rec IN c_determine_ia

Line 1921: hr_utility.set_location('Intervening Action '|| c_det_ia_rec.pa_notification_id, 20);

1917: p_retro_first_noa := c_det_ia_rec.first_noa_code;
1918: p_retro_second_noa := c_det_ia_rec.second_noa_code;
1919: end if;
1920: --BUG # 7216635
1921: hr_utility.set_location('Intervening Action '|| c_det_ia_rec.pa_notification_id, 20);
1922: exit;
1923: END LOOP;
1924: hr_utility.set_location('Leaving '|| l_proc, 25);
1925:

Line 1924: hr_utility.set_location('Leaving '|| l_proc, 25);

1920: --BUG # 7216635
1921: hr_utility.set_location('Intervening Action '|| c_det_ia_rec.pa_notification_id, 20);
1922: exit;
1923: END LOOP;
1924: hr_utility.set_location('Leaving '|| l_proc, 25);
1925:
1926: EXCEPTION
1927: WHEN OTHERS THEN
1928: p_retro_pa_request_id := NULL;