DBA Data[Home] [Help]

APPS.HR_CANCEL_HIRE_API dependencies on HR_UTILITY

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

253: -- code added by sathkris for the bug 8504597 ends here
254:
255: begin
256:
257: hr_utility.set_location('Entering:'|| l_proc, 10);
258: --
259: -- Issue a savepoint
260: --
261: savepoint cancel_hire;

Line 300: hr_utility.set_message(800,'HR_449773_POS_NOT_CRRNT');

296:
297: fnd_message.set_name('PER','HR_6346_EMP_ASS_NO_POS');
298: fnd_message.raise_error;
299: else
300: hr_utility.set_message(800,'HR_449773_POS_NOT_CRRNT');
301: hr_utility.raise_error;
302: end if;
303: --bug no 5105026 ends here
304: END IF;

Line 301: hr_utility.raise_error;

297: fnd_message.set_name('PER','HR_6346_EMP_ASS_NO_POS');
298: fnd_message.raise_error;
299: else
300: hr_utility.set_message(800,'HR_449773_POS_NOT_CRRNT');
301: hr_utility.raise_error;
302: end if;
303: --bug no 5105026 ends here
304: END IF;
305:

Line 337: hr_utility.set_location('cancel_hire '||p_person_id,100);

333: -- Validation in addition to Row Handlers. There is one loop
334: -- to the validation server side package per warning.
335: --
336: -- BUG 7001197
337: hr_utility.set_location('cancel_hire '||p_person_id,100);
338: hr_utility.set_location('cancel_hire ||p_effective_date '||p_effective_date,100);
339:
340: open csr_emp_apl_chk ;
341: fetch csr_emp_apl_chk into l_efd;

Line 338: hr_utility.set_location('cancel_hire ||p_effective_date '||p_effective_date,100);

334: -- to the validation server side package per warning.
335: --
336: -- BUG 7001197
337: hr_utility.set_location('cancel_hire '||p_person_id,100);
338: hr_utility.set_location('cancel_hire ||p_effective_date '||p_effective_date,100);
339:
340: open csr_emp_apl_chk ;
341: fetch csr_emp_apl_chk into l_efd;
342: if csr_emp_apl_chk%found and l_efd is not null then

Line 352: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');

348: if l_efd > p_effective_date then
349: -- user is trying to perform cancel hire before the hire was done
350: -- restricting this so that user changes the date to beyond any future
351: -- Person type changes.
352: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');
353: hr_utility.raise_error;
354: end if;
355:
356: hr_utility.set_location('cancel_hire || l_efd '||l_efd,101);

Line 353: hr_utility.raise_error;

349: -- user is trying to perform cancel hire before the hire was done
350: -- restricting this so that user changes the date to beyond any future
351: -- Person type changes.
352: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');
353: hr_utility.raise_error;
354: end if;
355:
356: hr_utility.set_location('cancel_hire || l_efd '||l_efd,101);
357:

Line 356: hr_utility.set_location('cancel_hire || l_efd '||l_efd,101);

352: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');
353: hr_utility.raise_error;
354: end if;
355:
356: hr_utility.set_location('cancel_hire || l_efd '||l_efd,101);
357:
358: -- to find out the from which person type the hire was made
359:
360: FOR l_person_type IN csr_person_types

Line 402: hr_utility.set_location('cancel_hire l_efd is null '||l_efd,104);

398: -- by retaining one application where he will still be an emp.apl after hire
399: -- so changing the logic accordingly to perfrom the cancel hire
400: close csr_emp_apl_chk;
401:
402: hr_utility.set_location('cancel_hire l_efd is null '||l_efd,104);
403:
404:
405:
406: hr_utility.set_location('cancel_hire l_efd is null '||l_efd,102);

Line 406: hr_utility.set_location('cancel_hire l_efd is null '||l_efd,102);

402: hr_utility.set_location('cancel_hire l_efd is null '||l_efd,104);
403:
404:
405:
406: hr_utility.set_location('cancel_hire l_efd is null '||l_efd,102);
407: open csr_rehired_date;
408: fetch csr_rehired_date into l_rehired_date;
409: close csr_rehired_date;
410:

Line 417: hr_utility.set_location('cancel_hire || l_efd '||l_efd,999);

413: fetch csr_fut_person_check into l_fut_exists;
414: if csr_fut_person_check%found then
415:
416: close csr_fut_person_check;
417: hr_utility.set_location('cancel_hire || l_efd '||l_efd,999);
418: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');
419: hr_utility.raise_error;
420: else
421: close csr_fut_person_check;

Line 418: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');

414: if csr_fut_person_check%found then
415:
416: close csr_fut_person_check;
417: hr_utility.set_location('cancel_hire || l_efd '||l_efd,999);
418: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');
419: hr_utility.raise_error;
420: else
421: close csr_fut_person_check;
422: end if;

Line 419: hr_utility.raise_error;

415:
416: close csr_fut_person_check;
417: hr_utility.set_location('cancel_hire || l_efd '||l_efd,999);
418: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');
419: hr_utility.raise_error;
420: else
421: close csr_fut_person_check;
422: end if;
423:

Line 446: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');

442: close csr_apl_date ;
443:
444: if l_apl_date > l_rehired_date then
445:
446: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');
447: hr_utility.raise_error;
448:
449: end if;
450: end if;

Line 447: hr_utility.raise_error;

443:
444: if l_apl_date > l_rehired_date then
445:
446: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');
447: hr_utility.raise_error;
448:
449: end if;
450: end if;
451:

Line 471: hr_utility.set_location('l_last_person_type '||l_last_person_type,101);

467: if csr_person_types%isopen then
468: close csr_person_types;
469: end if;
470:
471: hr_utility.set_location('l_last_person_type '||l_last_person_type,101);
472:
473: if l_last_person_type in ('EMP_APL','EMP_APL_EX_CWK') then
474:
475: -- cancelling back to EMP_APL from EMP_EX-APL

Line 479: hr_utility.set_location('Perform the checks and cancel the hire ',101);

475: -- cancelling back to EMP_APL from EMP_EX-APL
476: -- NEW CODE TO FIX THE BUG 7001197
477:
478:
479: hr_utility.set_location('Perform the checks and cancel the hire ',101);
480:
481: hr_utility.set_location('l_last_person_type '||l_last_person_type,101);
482: hr_utility.set_location('l_date_start '||l_date_start,101);
483: hr_utility.set_location('hr_api.g_eot '||hr_api.g_eot,101);

Line 481: hr_utility.set_location('l_last_person_type '||l_last_person_type,101);

477:
478:
479: hr_utility.set_location('Perform the checks and cancel the hire ',101);
480:
481: hr_utility.set_location('l_last_person_type '||l_last_person_type,101);
482: hr_utility.set_location('l_date_start '||l_date_start,101);
483: hr_utility.set_location('hr_api.g_eot '||hr_api.g_eot,101);
484: hr_utility.set_location(' l_period_of_service_id '||l_period_of_service_id,101);
485:

Line 482: hr_utility.set_location('l_date_start '||l_date_start,101);

478:
479: hr_utility.set_location('Perform the checks and cancel the hire ',101);
480:
481: hr_utility.set_location('l_last_person_type '||l_last_person_type,101);
482: hr_utility.set_location('l_date_start '||l_date_start,101);
483: hr_utility.set_location('hr_api.g_eot '||hr_api.g_eot,101);
484: hr_utility.set_location(' l_period_of_service_id '||l_period_of_service_id,101);
485:
486: per_cancel_hire_or_apl_pkg.cancel_emp_apl_hire

Line 483: hr_utility.set_location('hr_api.g_eot '||hr_api.g_eot,101);

479: hr_utility.set_location('Perform the checks and cancel the hire ',101);
480:
481: hr_utility.set_location('l_last_person_type '||l_last_person_type,101);
482: hr_utility.set_location('l_date_start '||l_date_start,101);
483: hr_utility.set_location('hr_api.g_eot '||hr_api.g_eot,101);
484: hr_utility.set_location(' l_period_of_service_id '||l_period_of_service_id,101);
485:
486: per_cancel_hire_or_apl_pkg.cancel_emp_apl_hire
487: (

Line 484: hr_utility.set_location(' l_period_of_service_id '||l_period_of_service_id,101);

480:
481: hr_utility.set_location('l_last_person_type '||l_last_person_type,101);
482: hr_utility.set_location('l_date_start '||l_date_start,101);
483: hr_utility.set_location('hr_api.g_eot '||hr_api.g_eot,101);
484: hr_utility.set_location(' l_period_of_service_id '||l_period_of_service_id,101);
485:
486: per_cancel_hire_or_apl_pkg.cancel_emp_apl_hire
487: (
488: p_person_id => p_person_id

Line 496: hr_utility.set_location('after performing cancel hire ',102);

492: ,p_period_of_service_id => l_period_of_service_id
493: );
494:
495:
496: hr_utility.set_location('after performing cancel hire ',102);
497:
498: -- the foll piece of code is to handle the case
499: -- when any cancel hire returns in data corruption
500: -- the basic intention of the cancel hire is to revert back to

Line 518: hr_utility.set_location('after performing cancel hire ',103);

514: l_curr_person_type := l_curr_person_type||'_'||l_person_type.system_person_type;
515: END IF;
516: END LOOP;
517:
518: hr_utility.set_location('after performing cancel hire ',103);
519: hr_utility.set_location('l_curr_person_type '||l_curr_person_type,102);
520:
521: if l_curr_person_type not in ('EMP_APL','EMP_APL_EX_CWK') then
522:

Line 519: hr_utility.set_location('l_curr_person_type '||l_curr_person_type,102);

515: END IF;
516: END LOOP;
517:
518: hr_utility.set_location('after performing cancel hire ',103);
519: hr_utility.set_location('l_curr_person_type '||l_curr_person_type,102);
520:
521: if l_curr_person_type not in ('EMP_APL','EMP_APL_EX_CWK') then
522:
523: hr_utility.set_location('raise the error',102);

Line 523: hr_utility.set_location('raise the error',102);

519: hr_utility.set_location('l_curr_person_type '||l_curr_person_type,102);
520:
521: if l_curr_person_type not in ('EMP_APL','EMP_APL_EX_CWK') then
522:
523: hr_utility.set_location('raise the error',102);
524: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');
525: hr_utility.raise_error;
526:
527: end if;

Line 524: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');

520:
521: if l_curr_person_type not in ('EMP_APL','EMP_APL_EX_CWK') then
522:
523: hr_utility.set_location('raise the error',102);
524: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');
525: hr_utility.raise_error;
526:
527: end if;
528:

Line 525: hr_utility.raise_error;

521: if l_curr_person_type not in ('EMP_APL','EMP_APL_EX_CWK') then
522:
523: hr_utility.set_location('raise the error',102);
524: hr_utility.set_message(801,'HR_7078_EMP_ENTER_CANCEL_TYPE');
525: hr_utility.raise_error;
526:
527: end if;
528:
529: open future_pay_proposals;

Line 631: hr_utility.set_location(' l_lastest_hire_date:'||l_lastest_hire_date, 79);

627: -- 115.3 (END)
628: --
629: -- Start changes for bug 9879782
630:
631: hr_utility.set_location(' l_lastest_hire_date:'||l_lastest_hire_date, 79);
632: per_fnd_attachment_pkg.adjust_irec_docs (
633: p_person_id => p_person_id,
634: p_assignment_id => null,
635: p_application_id => null,

Line 686: hr_utility.set_location(' Leaving:'||l_proc, 70);

682: p_requisition_warning := l_requisition_warning;
683: p_budget_warning := l_budget_warning;
684: p_payment_warning := l_payment_warning;
685:
686: hr_utility.set_location(' Leaving:'||l_proc, 70);
687:
688: exception
689: when hr_api.validate_enabled then
690: --

Line 700: hr_utility.set_location(' Leaving:'||l_proc, 80);

696: -- Only set output warning arguments
697: -- (Any key or derived arguments must be set to null
698: -- when validation only mode is being used.)
699: --
700: hr_utility.set_location(' Leaving:'||l_proc, 80);
701: when others then
702: --
703: -- A validation or unexpected error has occured
704: --

Line 706: hr_utility.set_location(' Leaving:'||l_proc, 90);

702: --
703: -- A validation or unexpected error has occured
704: --
705: rollback to cancel_hire;
706: hr_utility.set_location(' Leaving:'||l_proc, 90);
707: raise;
708:
709: end cancel_hire;
710: --