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: -- Begin bug# 12572750
19: -- Removed Detail start date and end date so passing null values to error free for previous records
20: IF r_rei.information_type = 'GHR_US_PAR_DET_INFO' AND

Line 22: hr_utility.set_location('Nullify rei_information1 and rei_information2 '|| l_proc ,11);

18: -- Begin bug# 12572750
19: -- Removed Detail start date and end date so passing null values to error free for previous records
20: IF r_rei.information_type = 'GHR_US_PAR_DET_INFO' AND
21: (r_rei.rei_information1 IS NOT NULL OR r_rei.rei_information2 IS NOT NULL) THEN
22: hr_utility.set_location('Nullify rei_information1 and rei_information2 '|| l_proc ,11);
23: r_rei.rei_information1 := NULL;
24: r_rei.rei_information2 := NULL;
25: END IF;
26: -- End bug# 12572750

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

82: ,p_pa_request_extra_info_id => v_pa_request_extra_info_id
83: ,p_object_version_number => v_ovn
84: );
85: END LOOP;
86: hr_utility.set_location('Exiting '|| l_proc, 100);
87: end;
88: -- -------------------------------------------------
89: PROCEDURE get_roles
90: -- -------------------------------------------------

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

128: l_personnelist_flag := p_personnelist_flag;
129: l_approver_flag := p_approver_flag;
130: l_reviewer_flag := p_reviewer_flag;
131:
132: hr_utility.set_location('Entering '|| l_proc, 5);
133:
134: OPEN c_user_roles;
135: FETCH c_user_roles INTO
136: p_initiator_flag

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

140: ,p_approver_flag
141: ,p_reviewer_flag;
142:
143: CLOSE c_user_roles;
144: hr_utility.set_location('Exiting '|| l_proc, 15);
145:
146: EXCEPTION
147: WHEN OTHERS THEN
148: p_initiator_flag := l_initiator_flag;

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

224: l_total_actions number;
225: l_corrections number;
226: l_rpas number;
227: BEGIN
228: hr_utility.set_location('Entering '|| l_proc, 5);
229: l_total_actions := p_total_actions;
230: l_corrections := p_corrections;
231: l_rpas := p_rpas;
232: p_total_actions := 0;

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

290: fnd_message.set_token('CORRECT', p_corrections);
291: END IF;
292: */
293:
294: hr_utility.set_location(l_proc || ' First Pa Request ID : ' || to_char(l_first_pa_request_rec.pa_request_id), 10);
295: hr_utility.set_location(l_proc || ' Last Pa Request ID : ' || to_char(l_last_pa_request_rec.pa_request_id), 20);
296: hr_utility.set_location('Exiting '|| l_proc, 500);
297: EXCEPTION
298: WHEN OTHERS THEN

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

291: END IF;
292: */
293:
294: hr_utility.set_location(l_proc || ' First Pa Request ID : ' || to_char(l_first_pa_request_rec.pa_request_id), 10);
295: hr_utility.set_location(l_proc || ' Last Pa Request ID : ' || to_char(l_last_pa_request_rec.pa_request_id), 20);
296: hr_utility.set_location('Exiting '|| l_proc, 500);
297: EXCEPTION
298: WHEN OTHERS THEN
299: p_total_actions := l_total_actions;

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

292: */
293:
294: hr_utility.set_location(l_proc || ' First Pa Request ID : ' || to_char(l_first_pa_request_rec.pa_request_id), 10);
295: hr_utility.set_location(l_proc || ' Last Pa Request ID : ' || to_char(l_last_pa_request_rec.pa_request_id), 20);
296: hr_utility.set_location('Exiting '|| l_proc, 500);
297: EXCEPTION
298: WHEN OTHERS THEN
299: p_total_actions := l_total_actions;
300: p_corrections := l_corrections;

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

465: l_number_of_requests number;
466:
467: BEGIN
468:
469: hr_utility.set_location('Entering '|| l_proc, 5);
470: l_first_pa_request_rec := p_first_pa_request_rec;
471: l_last_pa_request_rec := p_last_pa_request_rec;
472: l_number_of_requests := p_number_of_requests;
473:

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

473:
474: OPEN c_pa_request(chartorowid(p_row_id));
475: FETCH c_pa_request INTO p_first_pa_request_rec;
476: CLOSE c_pa_request;
477: hr_utility.set_location(l_proc || ' First PA Request id ' || p_first_pa_request_rec.pa_request_id, 15);
478: hr_utility.set_location(l_proc || ' First Family Code ' || p_first_pa_request_rec.noa_family_code, 25);
479: hr_utility.set_location(l_proc || ' First Person Id ' || p_first_pa_request_rec.person_id, 35);
480: hr_utility.set_location(l_proc || ' First ROW Id ' || rowidtochar(p_row_id), 40);
481: hr_utility.set_location(l_proc || ' Which NOA ' || p_which_noa, 43);

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

474: OPEN c_pa_request(chartorowid(p_row_id));
475: FETCH c_pa_request INTO p_first_pa_request_rec;
476: CLOSE c_pa_request;
477: hr_utility.set_location(l_proc || ' First PA Request id ' || p_first_pa_request_rec.pa_request_id, 15);
478: hr_utility.set_location(l_proc || ' First Family Code ' || p_first_pa_request_rec.noa_family_code, 25);
479: hr_utility.set_location(l_proc || ' First Person Id ' || p_first_pa_request_rec.person_id, 35);
480: hr_utility.set_location(l_proc || ' First ROW Id ' || rowidtochar(p_row_id), 40);
481: hr_utility.set_location(l_proc || ' Which NOA ' || p_which_noa, 43);
482:

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

475: FETCH c_pa_request INTO p_first_pa_request_rec;
476: CLOSE c_pa_request;
477: hr_utility.set_location(l_proc || ' First PA Request id ' || p_first_pa_request_rec.pa_request_id, 15);
478: hr_utility.set_location(l_proc || ' First Family Code ' || p_first_pa_request_rec.noa_family_code, 25);
479: hr_utility.set_location(l_proc || ' First Person Id ' || p_first_pa_request_rec.person_id, 35);
480: hr_utility.set_location(l_proc || ' First ROW Id ' || rowidtochar(p_row_id), 40);
481: hr_utility.set_location(l_proc || ' Which NOA ' || p_which_noa, 43);
482:
483: p_number_of_requests := -1;

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

476: CLOSE c_pa_request;
477: hr_utility.set_location(l_proc || ' First PA Request id ' || p_first_pa_request_rec.pa_request_id, 15);
478: hr_utility.set_location(l_proc || ' First Family Code ' || p_first_pa_request_rec.noa_family_code, 25);
479: hr_utility.set_location(l_proc || ' First Person Id ' || p_first_pa_request_rec.person_id, 35);
480: hr_utility.set_location(l_proc || ' First ROW Id ' || rowidtochar(p_row_id), 40);
481: hr_utility.set_location(l_proc || ' Which NOA ' || p_which_noa, 43);
482:
483: p_number_of_requests := -1;
484: /*

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

477: hr_utility.set_location(l_proc || ' First PA Request id ' || p_first_pa_request_rec.pa_request_id, 15);
478: hr_utility.set_location(l_proc || ' First Family Code ' || p_first_pa_request_rec.noa_family_code, 25);
479: hr_utility.set_location(l_proc || ' First Person Id ' || p_first_pa_request_rec.person_id, 35);
480: hr_utility.set_location(l_proc || ' First ROW Id ' || rowidtochar(p_row_id), 40);
481: hr_utility.set_location(l_proc || ' Which NOA ' || p_which_noa, 43);
482:
483: p_number_of_requests := -1;
484: /*
485: FOR r_get_last_request IN c_get_last_request LOOP

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

504:
505: OPEN c_pa_request(l_last_row.row_id);
506: FETCH c_pa_request INTO p_last_pa_request_rec;
507: CLOSE c_pa_request;
508: hr_utility.set_location(l_proc || ' last PA Request id ' || p_last_pa_request_rec.pa_request_id, 45);
509: hr_utility.set_location(l_proc || ' Last ROW Id ' || rowidtochar(l_last_row.row_id), 55);
510: hr_utility.set_location('Exiting '|| l_proc, 500);
511: EXCEPTION
512: WHEN OTHERS THEN

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

505: OPEN c_pa_request(l_last_row.row_id);
506: FETCH c_pa_request INTO p_last_pa_request_rec;
507: CLOSE c_pa_request;
508: hr_utility.set_location(l_proc || ' last PA Request id ' || p_last_pa_request_rec.pa_request_id, 45);
509: hr_utility.set_location(l_proc || ' Last ROW Id ' || rowidtochar(l_last_row.row_id), 55);
510: hr_utility.set_location('Exiting '|| l_proc, 500);
511: EXCEPTION
512: WHEN OTHERS THEN
513: p_first_pa_request_rec := l_first_pa_request_rec;

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

506: FETCH c_pa_request INTO p_last_pa_request_rec;
507: CLOSE c_pa_request;
508: hr_utility.set_location(l_proc || ' last PA Request id ' || p_last_pa_request_rec.pa_request_id, 45);
509: hr_utility.set_location(l_proc || ' Last ROW Id ' || rowidtochar(l_last_row.row_id), 55);
510: hr_utility.set_location('Exiting '|| l_proc, 500);
511: EXCEPTION
512: WHEN OTHERS THEN
513: p_first_pa_request_rec := l_first_pa_request_rec;
514: p_last_pa_request_rec := l_last_pa_request_rec;

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

579: --
580: v_old_pa_request_id NUMBER;
581: --
582: begin
583: hr_utility.set_location('Entering '|| l_proc, 5);
584: l_par_object_version_number1 := p_par_object_version_number;
585:
586: -- Get PA Request
587: open c_pa_req;

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

628: Open c_noa_id(l_pa_req_rec.first_noa_code, l_pa_req_rec.effective_date);
629: fetch c_noa_id into l_pa_req_rec.first_noa_id, l_pa_req_rec.first_noa_desc;
630: close c_noa_id;
631: --
632: hr_utility.set_location('First NOA Id '|| to_char(l_pa_req_rec.first_noa_id), 10);
633: --
634: l_pa_req_rec.first_action_la_code1 := p_cancel_legal_authority;
635: l_pa_req_rec.first_action_la_code2 := null;
636: l_pa_req_rec.first_action_la_desc1 := null;

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

686: ---END Bug # 2951865
687:
688: l_pa_req_rec.custom_pay_calc_flag := 'N';
689: --
690: hr_utility.set_location('Creating SF52 - p_username '||p_username || '-'|| l_proc, 15);
691: --
692: Ghr_sf52_api.create_sf52(
693: p_noa_family_code => l_pa_req_rec.noa_family_code
694: , p_routing_group_id => l_pa_req_rec.routing_group_id

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

898: -- Bug#4486823 RRR Changes
899: , p_payment_option => l_pa_req_rec.pa_incentive_payment_option
900: );
901: --
902: hr_utility.set_location('Created SF52 - OVN '||to_char(l_par_object_version_number)|| '-'|| l_proc, 20);
903: --
904: create_pa_request_extra_info(
905: p_new_pa_request_id => l_pa_req_rec.pa_request_id
906: ,p_old_pa_request_id => v_old_pa_request_id);

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

1005: l_first_action_la_code2,
1006: l_second_action_la_code1,
1007: l_second_action_la_code2); --end Bug# 8344672
1008: --
1009: hr_utility.set_location('Created SF52 Shadow ' || l_proc, 22);
1010: --
1011: if l_pa_req_rec.first_noa_code = '002' then
1012: l_noa_cancel_or_correct := ghr_history_api.g_correct;
1013: else

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

1012: l_noa_cancel_or_correct := ghr_history_api.g_correct;
1013: else
1014: l_noa_cancel_or_correct := ghr_history_api.g_cancel;
1015: end if;
1016: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_pa_req_rec.pa_request_id)|| '-'|| l_proc, 22);
1017: hr_utility.set_location('Updating SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 25);
1018: hr_utility.set_location(l_proc || 'Which NOA and Action ' || to_char(p_which_noa) || ' '|| p_which_action, 35);
1019: if p_which_noa = 1 then
1020: IF p_which_action = 'ORIGINAL' THEN

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

1013: else
1014: l_noa_cancel_or_correct := ghr_history_api.g_cancel;
1015: end if;
1016: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_pa_req_rec.pa_request_id)|| '-'|| l_proc, 22);
1017: hr_utility.set_location('Updating SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 25);
1018: hr_utility.set_location(l_proc || 'Which NOA and Action ' || to_char(p_which_noa) || ' '|| p_which_action, 35);
1019: if p_which_noa = 1 then
1020: IF p_which_action = 'ORIGINAL' THEN
1021: ghr_par_upd.upd(

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

1014: l_noa_cancel_or_correct := ghr_history_api.g_cancel;
1015: end if;
1016: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_pa_req_rec.pa_request_id)|| '-'|| l_proc, 22);
1017: hr_utility.set_location('Updating SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 25);
1018: hr_utility.set_location(l_proc || 'Which NOA and Action ' || to_char(p_which_noa) || ' '|| p_which_action, 35);
1019: if p_which_noa = 1 then
1020: IF p_which_action = 'ORIGINAL' THEN
1021: ghr_par_upd.upd(
1022: P_PA_REQUEST_ID => p_pa_request_id

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

1046: , p_second_noa_cancel_or_correct => l_noa_cancel_or_correct
1047: );
1048: END IF;
1049: end if;
1050: hr_utility.set_location('Updated SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 45);
1051: -- commit;
1052: hr_utility.set_location('Exiting '|| l_proc, 50);
1053: return l_pa_req_rec.PA_REQUEST_ID;
1054: EXCEPTION

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

1048: END IF;
1049: end if;
1050: hr_utility.set_location('Updated SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 45);
1051: -- commit;
1052: hr_utility.set_location('Exiting '|| l_proc, 50);
1053: return l_pa_req_rec.PA_REQUEST_ID;
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: p_par_object_version_number := l_par_object_version_number1;

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

1189: -- End Bug 2681842 and 3191676
1190:
1191: begin
1192: --
1193: hr_utility.set_location('Entering '|| l_proc, 5);
1194:
1195: find_last_request(p_pa_request_id => p_pa_request_id
1196: , p_which_noa => p_which_noa
1197: , p_row_id => p_row_id

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

1197: , p_row_id => p_row_id
1198: , p_first_pa_request_rec => l_first_pa_request_rec
1199: , p_last_pa_request_rec => l_last_pa_request_rec
1200: , p_number_of_requests => l_corrections);
1201: hr_utility.set_location(l_proc || 'Last PA Request ID ' || to_char(l_last_pa_request_rec.pa_request_id), 15);
1202: IF l_last_pa_request_rec.pa_notification_id IS NULL THEN
1203: l_corrections := -1;
1204: fnd_message.set_name('GHR', 'GHR_CANCEL_INVALID');
1205: fnd_message.raise_error;

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

1295: -- Bug#3941541
1296: IF l_pa_req_rec.second_noa_code = '825' THEN
1297: l_noa_family_code := 'GHR_INCENTIVE';
1298: END IF;
1299: hr_utility.set_location('noa family code is' || l_noa_family_code ,20);
1300: IF nvl(l_noa_family_code,hr_api.g_varchar2) not in
1301: ('APP','APPT_TRANS','APPT_INFO') THEN
1302: hr_utility.set_location('notification id is' || l_pa_req_rec.pa_notification_id,22 );
1303: --BUG # 7216635 Added the parameter p_noa_id_correct

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

1298: END IF;
1299: hr_utility.set_location('noa family code is' || l_noa_family_code ,20);
1300: IF nvl(l_noa_family_code,hr_api.g_varchar2) not in
1301: ('APP','APPT_TRANS','APPT_INFO') THEN
1302: hr_utility.set_location('notification id is' || l_pa_req_rec.pa_notification_id,22 );
1303: --BUG # 7216635 Added the parameter p_noa_id_correct
1304: GHR_APPROVED_PA_REQUESTS.determine_ia(
1305: p_pa_request_id => p_pa_request_id,
1306: p_pa_notification_id => l_pa_notification_id,

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

1313: p_retro_second_noa => l_retro_second_noa);
1314:
1315: IF l_effective_date is NOT NULL THEN
1316: l_ia_flag := 'Y';
1317: hr_utility.set_location('Intervening Action '||l_effective_date,10);
1318: IF l_retro_first_noa = '866' then
1319: l_effective_date := l_effective_date + 1;
1320: END IF;
1321: END IF;

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

1329: l_retro_noa_family_code := c_noa_fam.noa_family_code;
1330: END LOOP;
1331: END IF;
1332: END LOOP;
1333: hr_utility.set_location('IA Action ',11);
1334: -- Bug 3381960
1335: -- If the retro action is cancellation action, then consider the RPA
1336: -- previous to this Cancellation RPA and use that for populating
1337: -- from side of this correction action.

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

1338:
1339: IF NVL(l_retro_first_noa,hr_api.g_varchar2) = '001' THEN
1340: -- Get the To side of the RPA previous to this cancellation action
1341: -- Need to modify the cursor. Need to add Order of processing too
1342: hr_utility.set_location('Cancellation RPA',11);
1343: FOR l_pa_before_retro IN c_pa_before_retro(l_effective_date,l_pa_req_rec.person_id) LOOP
1344: l_prev_retro_pa_rec := l_pa_before_retro;
1345: EXIT;
1346: END LOOP;

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

1381: 'AWARD',
1382: 'GHR_INCENTIVE'
1383: )
1384: THEN
1385: hr_utility.set_location('From Side data only MRPA',11);
1386: for c_ret_rec in c_retro_pa_req loop
1387: l_pa_req_rec.from_position_id := c_ret_rec.from_position_id;
1388: l_pa_req_rec.from_position_title := c_ret_rec.from_position_title;
1389: l_pa_req_rec.from_position_number := c_ret_rec.from_position_number;

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

1411: l_pa_req_rec.from_position_org_line6 := c_ret_rec.from_position_org_line6;
1412: exit;
1413: end loop;
1414: ELSE
1415: hr_utility.set_location('Non Cancel MRPA: ',11);
1416: for c_ret_rec in c_retro_pa_req loop
1417: l_pa_req_rec.from_position_id := c_ret_rec.to_position_id;
1418: l_pa_req_rec.from_position_title := c_ret_rec.to_position_title;
1419: l_pa_req_rec.from_position_number := c_ret_rec.to_position_number;

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

1441: exit;
1442: end loop;
1443: END IF;
1444: ELSE
1445: hr_utility.set_location('non IA : '||l_pa_req_rec.pay_rate_determinant,11);
1446: l_noa_id_correct := hr_api.g_number;
1447: l_altered_pa_request_id := l_pa_req_rec.altered_pa_request_id;
1448: GHR_API.sf52_from_data_elements(
1449: p_person_id => l_pa_req_rec.person_id

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

1609:
1610: );
1611:
1612: IF nvl(l_noa_family_code,hr_api.g_varchar2) = 'GHR_INCENTIVE' THEN
1613: hr_utility.set_location('Inserting incentive records',0);
1614: INSERT INTO ghr_pa_incentives( pa_incentive_id,
1615: pa_request_id ,
1616: pa_incentive_category,
1617: pa_incentive_category_percent ,

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

1627: pa_incentive_category_pmnt_dt ,
1628: pa_incentive_category_end_date
1629: FROM GHR_PA_INCENTIVES
1630: WHERE pa_request_id = l_pa_req_rec.altered_pa_request_id;
1631: hr_utility.set_location('After Inserting incentive records',10);
1632: END IF;
1633: -- Bug#4486823 RRR Changes
1634:
1635: hr_utility.set_location('Created SF52 - Altered PA Request ID '||to_char(l_pa_req_rec.altered_pa_request_id)|| '-'|| l_proc, 21);

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

1631: hr_utility.set_location('After Inserting incentive records',10);
1632: END IF;
1633: -- Bug#4486823 RRR Changes
1634:
1635: hr_utility.set_location('Created SF52 - Altered PA Request ID '||to_char(l_pa_req_rec.altered_pa_request_id)|| '-'|| l_proc, 21);
1636: hr_utility.set_location('Created SF52 - PA request ID '||to_char(l_pa_req_rec.pa_request_id)|| '-'|| l_proc, 22);
1637: insert into ghr_pa_request_shadow (
1638: pa_request_id,
1639: academic_discipline,

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

1632: END IF;
1633: -- Bug#4486823 RRR Changes
1634:
1635: hr_utility.set_location('Created SF52 - Altered PA Request ID '||to_char(l_pa_req_rec.altered_pa_request_id)|| '-'|| l_proc, 21);
1636: hr_utility.set_location('Created SF52 - PA request ID '||to_char(l_pa_req_rec.pa_request_id)|| '-'|| l_proc, 22);
1637: insert into ghr_pa_request_shadow (
1638: pa_request_id,
1639: academic_discipline,
1640: annuitant_indicator,

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

1736: l_first_action_la_code2,
1737: l_second_action_la_code1,
1738: l_second_action_la_code2);--end Bug# 8344672
1739: --
1740: hr_utility.set_location('Created SF52 Shadow ' || l_proc, 22);
1741: --
1742: if l_pa_req_rec.first_noa_code = '002' then
1743: l_noa_cancel_or_correct := ghr_history_api.g_correct;
1744: else

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

1743: l_noa_cancel_or_correct := ghr_history_api.g_correct;
1744: else
1745: l_noa_cancel_or_correct := ghr_history_api.g_cancel;
1746: end if;
1747: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 22);
1748: hr_utility.set_location(l_proc || ' Last rows object version # ' || to_char(l_last_pa_request_rec.object_version_number), 20);
1749: hr_utility.set_location('Updating SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1750: hr_utility.set_location('Updated SF52 - PA Request ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 26);
1751: if l_which_noa = 1 then

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

1744: else
1745: l_noa_cancel_or_correct := ghr_history_api.g_cancel;
1746: end if;
1747: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 22);
1748: hr_utility.set_location(l_proc || ' Last rows object version # ' || to_char(l_last_pa_request_rec.object_version_number), 20);
1749: hr_utility.set_location('Updating SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1750: hr_utility.set_location('Updated SF52 - PA Request ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 26);
1751: if l_which_noa = 1 then
1752: ghr_par_upd.upd(

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

1745: l_noa_cancel_or_correct := ghr_history_api.g_cancel;
1746: end if;
1747: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 22);
1748: hr_utility.set_location(l_proc || ' Last rows object version # ' || to_char(l_last_pa_request_rec.object_version_number), 20);
1749: hr_utility.set_location('Updating SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1750: hr_utility.set_location('Updated SF52 - PA Request ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 26);
1751: if l_which_noa = 1 then
1752: ghr_par_upd.upd(
1753: P_PA_REQUEST_ID => l_last_pa_request_rec.pa_request_id

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

1746: end if;
1747: hr_utility.set_location('Created SF52 - Pa REQUEST ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 22);
1748: hr_utility.set_location(l_proc || ' Last rows object version # ' || to_char(l_last_pa_request_rec.object_version_number), 20);
1749: hr_utility.set_location('Updating SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1750: hr_utility.set_location('Updated SF52 - PA Request ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 26);
1751: if l_which_noa = 1 then
1752: ghr_par_upd.upd(
1753: P_PA_REQUEST_ID => l_last_pa_request_rec.pa_request_id
1754: , P_OBJECT_VERSION_NUMBER => l_last_pa_request_rec.object_version_number

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

1762: , p_second_noa_pa_request_id => l_last_pa_request_rec.pa_request_id
1763: , p_second_noa_cancel_or_correct => l_noa_cancel_or_correct
1764: );
1765: end if;
1766: hr_utility.set_location('Updated SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1767: -- commit;
1768: --
1769: hr_utility.set_location('Exiting '|| l_proc, 15);
1770: --

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

1765: end if;
1766: hr_utility.set_location('Updated SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1767: -- commit;
1768: --
1769: hr_utility.set_location('Exiting '|| l_proc, 15);
1770: --
1771: return l_pa_req_rec.PA_REQUEST_ID;
1772:
1773: end;

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

1804: l_par_object_version_number1 number;
1805: --
1806: begin
1807: --
1808: hr_utility.set_location('Entering '|| l_proc, 5);
1809: l_par_object_version_number1 := p_par_object_version_number;
1810: --
1811: get_roles(
1812: P_ROUTING_GROUP_ID => P_ROUTING_GROUP_ID

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

1828: return FALSE;
1829: -- set this message here to retrieve the same under form
1830: END IF;
1831:
1832: hr_utility.set_location('after get_roles'||P_ROUTING_GROUP_ID ,123456);
1833: --
1834: l_return_value := (L_APPROVER_FLAG = 'Y' AND L_PERSONNELIST_FLAG = 'Y');
1835: --
1836: hr_utility.set_location('Roles Approver = ' || L_APPROVER_FLAG ||

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

1832: hr_utility.set_location('after get_roles'||P_ROUTING_GROUP_ID ,123456);
1833: --
1834: l_return_value := (L_APPROVER_FLAG = 'Y' AND L_PERSONNELIST_FLAG = 'Y');
1835: --
1836: hr_utility.set_location('Roles Approver = ' || L_APPROVER_FLAG ||
1837: ' PERSONNELIST= ' || L_PERSONNELIST_FLAG || l_proc, 10);
1838: --
1839: if l_return_value then
1840: hr_utility.set_location('l_return_value is TRUE',10);

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

1836: hr_utility.set_location('Roles Approver = ' || L_APPROVER_FLAG ||
1837: ' PERSONNELIST= ' || L_PERSONNELIST_FLAG || l_proc, 10);
1838: --
1839: if l_return_value then
1840: hr_utility.set_location('l_return_value is TRUE',10);
1841: ghr_api.call_workflow(p_pa_request_id, 'CONTINUE');
1842:
1843: hr_utility.set_location('Re routed '|| l_proc, 15);
1844: hr_utility.set_location('Updated PA Requests '|| l_proc, 20);

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

1839: if l_return_value then
1840: hr_utility.set_location('l_return_value is TRUE',10);
1841: ghr_api.call_workflow(p_pa_request_id, 'CONTINUE');
1842:
1843: hr_utility.set_location('Re routed '|| l_proc, 15);
1844: hr_utility.set_location('Updated PA Requests '|| l_proc, 20);
1845: else
1846: -- return false otherwise instead of throwing error mesg
1847: -- Fix for 4145758

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

1840: hr_utility.set_location('l_return_value is TRUE',10);
1841: ghr_api.call_workflow(p_pa_request_id, 'CONTINUE');
1842:
1843: hr_utility.set_location('Re routed '|| l_proc, 15);
1844: hr_utility.set_location('Updated PA Requests '|| l_proc, 20);
1845: else
1846: -- return false otherwise instead of throwing error mesg
1847: -- Fix for 4145758
1848: hr_utility.set_location('l_return_value is FALSE',10);

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

1844: hr_utility.set_location('Updated PA Requests '|| l_proc, 20);
1845: else
1846: -- return false otherwise instead of throwing error mesg
1847: -- Fix for 4145758
1848: hr_utility.set_location('l_return_value is FALSE',10);
1849: fnd_message.set_name('GHR', 'GHR_38550_REROUTE');
1850: return l_return_value;
1851: end if;
1852: --

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

1849: fnd_message.set_name('GHR', 'GHR_38550_REROUTE');
1850: return l_return_value;
1851: end if;
1852: --
1853: hr_utility.set_location('Exiting '|| l_proc, 25);
1854: --
1855: return l_return_value;
1856: EXCEPTION
1857: WHEN OTHERS THEN

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

1900: l_retro_first_noa ghr_nature_of_actions.code%type;
1901: l_retro_second_noa ghr_nature_of_actions.code%type;
1902: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
1903: BEGIN
1904: hr_utility.set_location('Entering '|| l_proc, 5);
1905: -- Determine Intervening Action
1906: --BUG # 7216635 Added the parameter p_noa_id_correct
1907: GHR_APPROVED_PA_REQUESTS.determine_ia(
1908: p_pa_request_id => p_pa_request_id,

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

1918: -- Check for the presence of multiple intervening actions
1919: FOR c_multi_ia_rec IN c_multi_ia
1920: LOOP
1921: -- Check for out of sequence
1922: hr_utility.set_location('Multiple IA action'|| l_proc, 15);
1923: FOR c_out_seq IN c_out_of_seq
1924: LOOP
1925: hr_utility.set_location('Out of Sequence Action'|| l_proc, 20);
1926: return 0;

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

1921: -- Check for out of sequence
1922: hr_utility.set_location('Multiple IA action'|| l_proc, 15);
1923: FOR c_out_seq IN c_out_of_seq
1924: LOOP
1925: hr_utility.set_location('Out of Sequence Action'|| l_proc, 20);
1926: return 0;
1927: END LOOP;
1928: exit;
1929: END LOOP;

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

1927: END LOOP;
1928: exit;
1929: END LOOP;
1930: END IF;
1931: hr_utility.set_location('Leaving '|| l_proc, 25);
1932: return 1;
1933: END;
1934:
1935: procedure determine_ia (

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

1999:
2000: l_ia_noac ghr_pa_requests.first_noa_code%type;
2001:
2002: BEGIN
2003: hr_utility.set_location('Entering '|| l_proc, 5);
2004:
2005: p_retro_eff_date := NULL;
2006: -- Determine Intervening Action
2007: FOR c_det_ia_rec IN c_determine_ia

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

2047: -- need to be exited once if chk_order is true
2048: exit;
2049: end if;
2050: --BUG # 7216635
2051: hr_utility.set_location('Intervening Action '|| c_det_ia_rec.pa_notification_id, 20);
2052:
2053: END LOOP;
2054: hr_utility.set_location('Leaving '|| l_proc, 25);
2055:

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

2050: --BUG # 7216635
2051: hr_utility.set_location('Intervening Action '|| c_det_ia_rec.pa_notification_id, 20);
2052:
2053: END LOOP;
2054: hr_utility.set_location('Leaving '|| l_proc, 25);
2055:
2056: EXCEPTION
2057: WHEN OTHERS THEN
2058: p_retro_pa_request_id := NULL;