DBA Data[Home] [Help]

APPS.PER_PERIODS_OF_SERVICE_PKG dependencies on HR_UTILITY

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

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

Line 657: hr_utility.trace_off;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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