DBA Data[Home] [Help]

APPS.PER_PERIODS_OF_SERVICE_PKG dependencies on HR_UTILITY

Line 379: hr_utility.trace_on(1,'james');

375: for update nowait;
376: pps_rec pps%rowtype;
377: begin
378: /*
379: hr_utility.trace_on(1,'james');
380: */
381: open pps;
382: fetch pps into pps_rec;
383: close pps;

Line 658: hr_utility.trace_off;

654: ) then
655: return;
656: end if;
657: /*
658: hr_utility.trace_off;
659: */
660: -- Record chaged by anothers user.
661: fnd_message.set_name('FND','FORM_RECORD_CHANGED');
662: app_exception.raise_exception ;

Line 1006: hr_utility.set_location('Entering '||l_proc,0);

1002: begin
1003: --
1004: -- PRE-UPDATE processing
1005: --
1006: hr_utility.set_location('Entering '||l_proc,0);
1007: --
1008: -- Get the current values for the PDS so that we can
1009: -- maintain the PTU information.
1010: --

Line 1023: hr_utility.set_location('Localization Action - True',99);

1019: if (nvl(p_leaving_reason , hr_api.g_varchar2) = nvl(l_old_leaving_reason,hr_api.g_varchar2))
1020: and (nvl(p_actual_termination_date,hr_api.g_date) = nvl(l_old_actual_termination_date,hr_api.g_date))
1021: and (nvl(p_final_process_date,hr_api.g_date) = nvl(l_old_final_process_date,hr_api.g_date))
1022: and nvl(p_initiate_cancellation,'N') <> 'Y' then
1023: hr_utility.set_location('Localization Action - True',99);
1024: l_localization_action := TRUE;
1025:
1026: else
1027: hr_utility.set_location('Localization Action - False',99);

Line 1027: hr_utility.set_location('Localization Action - False',99);

1023: hr_utility.set_location('Localization Action - True',99);
1024: l_localization_action := TRUE;
1025:
1026: else
1027: hr_utility.set_location('Localization Action - False',99);
1028: l_localization_action := FALSE;
1029: end if;
1030: --
1031: -- Localization do not want this processing to take place.

Line 1244: hr_utility.set_location('Entering: hrempter.cancel_termination'|| l_proc, 5);

1240:
1241: -- fix bug 1234721
1242: -- parameter should remain null
1243: -- p_s_final_process_date := p_final_process_date;
1244: hr_utility.set_location('Entering: hrempter.cancel_termination'|| l_proc, 5);
1245: if p_initiate_cancellation ='Y' then
1246: hrempter.cancel_termination(p_person_id
1247: ,p_actual_termination_date
1248: ,p_clear_details);

Line 1250: hr_utility.set_location('After: hrempter.cancel_termination'|| l_proc, 10);

1246: hrempter.cancel_termination(p_person_id
1247: ,p_actual_termination_date
1248: ,p_clear_details);
1249: p_requery_required := 'Y';
1250: hr_utility.set_location('After: hrempter.cancel_termination'|| l_proc, 10);
1251: /* This code is added to raise BE on reverse termination of employee */
1252:
1253: hr_ex_employee_be4.reverse_terminate_employee_a(p_person_id
1254: ,p_actual_termination_date

Line 1256: hr_utility.set_location('After: hr_ex_employee_be4.reverse_terminate_employee_a'|| l_proc, 15);

1252:
1253: hr_ex_employee_be4.reverse_terminate_employee_a(p_person_id
1254: ,p_actual_termination_date
1255: ,p_clear_details);
1256: hr_utility.set_location('After: hr_ex_employee_be4.reverse_terminate_employee_a'|| l_proc, 15);
1257: /* End of code added to raise BE */
1258: elsif p_actual_termination_date is not null then
1259: if p_s_actual_termination_date is null then
1260: -- fix bug 1234721

Line 1375: hr_utility.set_location(l_proc,40);

1371: -- This is required for OAB BD1/BD2 work and will
1372: -- be required in 11.5 of HR until the new person
1373: -- type model gets fully incorporated.
1374: --
1375: hr_utility.set_location(l_proc,40);
1376: hr_utility.set_location('Cancel? : '||p_initiate_cancellation,07);
1377: -- hr_per_type_usage_internal.maintain_ptu(
1378: -- p_person_id => p_person_id,
1379: -- p_action => l_action,

Line 1376: hr_utility.set_location('Cancel? : '||p_initiate_cancellation,07);

1372: -- be required in 11.5 of HR until the new person
1373: -- type model gets fully incorporated.
1374: --
1375: hr_utility.set_location(l_proc,40);
1376: hr_utility.set_location('Cancel? : '||p_initiate_cancellation,07);
1377: -- hr_per_type_usage_internal.maintain_ptu(
1378: -- p_person_id => p_person_id,
1379: -- p_action => l_action,
1380: -- p_period_of_service_id => p_period_of_service_id,

Line 1387: hr_utility.set_location('Leaving '||l_proc,60);

1383: -- p_date_start => p_date_start,
1384: -- p_leaving_reason => p_leaving_reason,
1385: -- p_old_date_start => l_old_date_start,
1386: -- p_old_leaving_reason => l_old_leaving_reason);
1387: hr_utility.set_location('Leaving '||l_proc,60);
1388: --
1389: -- Fix for bug 3889294 starts here.
1390: -- Moved the PTU changes code to procedure hrempter.cancel_termination
1391: -- for reverse termination case.

Line 1397: hr_utility.set_location('REV_TERM '||l_proc,65);

1393: /*
1394: -- start of PTU Changes
1395: if l_action = 'REV_TERM'
1396: then -- Cancel Person Type Usage record
1397: hr_utility.set_location('REV_TERM '||l_proc,65);
1398: if p_leaving_reason = 'R' then
1399: hr_utility.set_location('REV_TERM '||l_proc,67);
1400: hr_per_type_usage_internal.cancel_person_type_usage
1401: (p_effective_date => p_actual_termination_date+1

Line 1399: hr_utility.set_location('REV_TERM '||l_proc,67);

1395: if l_action = 'REV_TERM'
1396: then -- Cancel Person Type Usage record
1397: hr_utility.set_location('REV_TERM '||l_proc,65);
1398: if p_leaving_reason = 'R' then
1399: hr_utility.set_location('REV_TERM '||l_proc,67);
1400: hr_per_type_usage_internal.cancel_person_type_usage
1401: (p_effective_date => p_actual_termination_date+1
1402: ,p_person_id => p_person_id
1403: ,p_system_person_type => 'RETIREE');

Line 1406: hr_utility.set_location('REV_TERM '||l_proc,68);

1402: ,p_person_id => p_person_id
1403: ,p_system_person_type => 'RETIREE');
1404: -- end if; fix Bug 2048953
1405: else
1406: hr_utility.set_location('REV_TERM '||l_proc,68);
1407: hr_per_type_usage_internal.cancel_person_type_usage
1408: (p_effective_date => p_actual_termination_date+1
1409: ,p_person_id => p_person_id
1410: ,p_system_person_type => 'EX_EMP');

Line 1421: hr_utility.set_location('TERM '||l_proc,70);

1417: if (l_action = 'TERM'
1418: and l_old_actual_termination_date is null
1419: and p_actual_termination_date is not null ) -- Bug 2189611
1420: then -- terminate
1421: hr_utility.set_location('TERM '||l_proc,70);
1422: hr_per_type_usage_internal.maintain_person_type_usage
1423: (p_effective_date => p_actual_termination_date+1
1424: ,p_person_id => p_person_id
1425: ,p_person_type_id =>

Line 1450: hr_utility.set_location('LEAV_REAS '||l_proc,75);

1446: and p_actual_termination_date is not null ) -- Bug 2189611
1447: -- then if l_old_leaving_reason 'R' the remove Retiree record for the person
1448: -- else if p_leaving_reason is 'R' the create a Retiree record for the person
1449: then
1450: hr_utility.set_location('LEAV_REAS '||l_proc,75);
1451: if l_old_leaving_reason = 'R' then
1452: hr_utility.set_location('LEAV_REAS '||l_proc,80);
1453: hr_per_type_usage_internal.maintain_person_type_usage
1454: (p_effective_date => p_actual_termination_date+1

Line 1452: hr_utility.set_location('LEAV_REAS '||l_proc,80);

1448: -- else if p_leaving_reason is 'R' the create a Retiree record for the person
1449: then
1450: hr_utility.set_location('LEAV_REAS '||l_proc,75);
1451: if l_old_leaving_reason = 'R' then
1452: hr_utility.set_location('LEAV_REAS '||l_proc,80);
1453: hr_per_type_usage_internal.maintain_person_type_usage
1454: (p_effective_date => p_actual_termination_date+1
1455: ,p_person_id => p_person_id
1456: ,p_person_type_id =>