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.HR_APPLICANT_API dependencies on HR_API

Line 428: when hr_api.cannot_find_prog_unit then

424: ,p_party_id => p_party_id
425: ,p_vacancy_id => p_vacancy_id
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'CREATE_APPLICANT'
431: ,p_hook_type => 'BP'
432: );

Line 429: hr_api.cannot_find_prog_unit_error

425: ,p_vacancy_id => p_vacancy_id
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'CREATE_APPLICANT'
431: ,p_hook_type => 'BP'
432: );
433: --

Line 768: when hr_api.cannot_find_prog_unit then

764: ,p_name_combination_warning => l_name_combination_warning
765: ,p_orig_hire_warning => l_orig_hire_warning
766: );
767: exception
768: when hr_api.cannot_find_prog_unit then
769: hr_api.cannot_find_prog_unit_error
770: (p_module_name => 'CREATE_APPLICANT'
771: ,p_hook_type => 'AP'
772: );

Line 769: hr_api.cannot_find_prog_unit_error

765: ,p_orig_hire_warning => l_orig_hire_warning
766: );
767: exception
768: when hr_api.cannot_find_prog_unit then
769: hr_api.cannot_find_prog_unit_error
770: (p_module_name => 'CREATE_APPLICANT'
771: ,p_hook_type => 'AP'
772: );
773: --

Line 781: raise hr_api.validate_enabled;

777: --
778: -- When in validation only mode raise the Validate_Enabled exception
779: --
780: if p_validate then
781: raise hr_api.validate_enabled;
782: end if;
783: --
784: -- Set OUT parameters
785: --

Line 815: when hr_api.validate_enabled then

811: p_applicant_number := l_applicant_number;
812:
813: hr_utility.set_location(' Leaving:'||l_proc, 50);
814: exception
815: when hr_api.validate_enabled then
816: --
817: -- As the Validate_Enabled exception has been raised
818: -- we must rollback to the savepoint
819: --

Line 1482: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,

1478: p_hire_date in date,
1479: p_person_id in per_all_people_f.person_id%TYPE,
1480: p_assignment_id in number, --default null,
1481: p_person_type_id in number, --default null,
1482: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,
1483: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1484: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1485: p_per_effective_start_date out nocopy date,
1486: p_per_effective_end_date out nocopy date,

Line 1626: and nvl(pap.date_end,hr_api.g_eot);

1622: and per.person_id = p_person_id
1623: and l_hire_date between per.effective_start_date
1624: and per.effective_end_date
1625: and l_hire_date between pap.date_received
1626: and nvl(pap.date_end,hr_api.g_eot);
1627: --
1628: cursor csr_chk_asg_status is
1629: select count(asg.assignment_id)
1630: from per_assignments_f asg,

Line 1896: hr_api.mandatory_arg_error

1892: -- End bug 2833630
1893: begin
1894: hr_utility.set_location('Entering:'|| l_proc, 10);
1895: --
1896: hr_api.mandatory_arg_error
1897: (p_api_name => l_proc
1898: ,p_argument => 'person_id'
1899: ,p_argument_value => p_person_id
1900: );

Line 1902: hr_api.mandatory_arg_error

1898: ,p_argument => 'person_id'
1899: ,p_argument_value => p_person_id
1900: );
1901: --
1902: hr_api.mandatory_arg_error
1903: (p_api_name => l_proc
1904: ,p_argument => 'hire_date'
1905: ,p_argument_value => p_hire_date
1906: );

Line 1989: when hr_api.cannot_find_prog_unit then

1985: p_employee_number => p_employee_number,
1986: p_original_date_of_hire => l_original_date_of_hire
1987: );
1988: exception
1989: when hr_api.cannot_find_prog_unit then
1990: hr_api.cannot_find_prog_unit_error
1991: (p_module_name => 'HIRE_APPLICANT'
1992: ,p_hook_type => 'BP'
1993: );

Line 1990: hr_api.cannot_find_prog_unit_error

1986: p_original_date_of_hire => l_original_date_of_hire
1987: );
1988: exception
1989: when hr_api.cannot_find_prog_unit then
1990: hr_api.cannot_find_prog_unit_error
1991: (p_module_name => 'HIRE_APPLICANT'
1992: ,p_hook_type => 'BP'
1993: );
1994: --

Line 2100: hr_api.mandatory_arg_error

2096: hr_utility.set_location(l_proc,100);
2097: --
2098: --close csr_chk_asg_status;
2099: --
2100: hr_api.mandatory_arg_error
2101: (p_api_name => l_proc
2102: ,p_argument => 'assignment_id'
2103: ,p_argument_value => p_assignment_id
2104: );

Line 2504: l_assignment_status_type_id := hr_api.g_number;

2500: -- 3) When the accepted assignments are multiple, the primary flag of the
2501: -- record not specified by P_ASSIGNMENT_ID is set to 'N'.
2502: --
2503: -- reset l_assignment_status_type_id for updating the accepted assignments
2504: l_assignment_status_type_id := hr_api.g_number;
2505: --
2506: per_asg_bus1.chk_assignment_status_type
2507: (p_assignment_status_type_id => l_assignment_status_type_id
2508: ,p_business_group_id => l_business_group_id

Line 2562: l_soft_coding_keyflex_id := hr_api.g_number;

2558:
2559: if l_soft_coding_keyflex_id is null and l_payroll_id is not null and p_source=true then
2560: l_soft_coding_keyflex_id := l_dummy_soft_coding_keyflex_id;
2561: else
2562: l_soft_coding_keyflex_id := hr_api.g_number;
2563: end if;
2564:
2565: --Fix For Bug 5749371 Ends
2566:

Line 2699: l_soft_coding_keyflex_id := hr_api.g_number;

2695:
2696: if l_soft_coding_keyflex_id is null and l_payroll_id is not null and p_source=true then
2697: l_soft_coding_keyflex_id := l_dummy_soft_coding_keyflex_id;
2698: else
2699: l_soft_coding_keyflex_id := hr_api.g_number;
2700: end if;
2701:
2702: --Fix For Bug 5749371 Ends
2703:

Line 2960: when hr_api.cannot_find_prog_unit then

2956: p_oversubscribed_vacancy_id => l_oversubscribed_vacancy_id,
2957: p_original_date_of_hire => l_original_date_of_hire
2958: );
2959: exception
2960: when hr_api.cannot_find_prog_unit then
2961: hr_api.cannot_find_prog_unit_error
2962: (p_module_name => 'HIRE_APPLICANT'
2963: ,p_hook_type => 'AP'
2964: );

Line 2961: hr_api.cannot_find_prog_unit_error

2957: p_original_date_of_hire => l_original_date_of_hire
2958: );
2959: exception
2960: when hr_api.cannot_find_prog_unit then
2961: hr_api.cannot_find_prog_unit_error
2962: (p_module_name => 'HIRE_APPLICANT'
2963: ,p_hook_type => 'AP'
2964: );
2965: --

Line 2973: raise hr_api.validate_enabled;

2969: --
2970: -- When in validation only mode raise the Validate_Enabled exception
2971: --
2972: if p_validate then
2973: raise hr_api.validate_enabled;
2974: end if;
2975: --
2976: --
2977: p_employee_number := l_employee_number;

Line 2988: when hr_api.validate_enabled then

2984: --
2985: hr_utility.set_location(' Leaving:'||l_proc, 250);
2986: --
2987: exception
2988: when hr_api.validate_enabled then
2989: --
2990: -- As the Validate_Enabled exception has been raised
2991: -- we must rollback to the savepoint
2992: --

Line 3044: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT hr_api.g_number

3040: (p_validate IN BOOLEAN --DEFAULT FALSE
3041: ,p_effective_date IN DATE
3042: ,p_person_id IN per_all_people_f.person_id%TYPE
3043: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
3044: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT hr_api.g_number
3045: ,p_termination_reason IN per_applications.termination_reason%TYPE --DEFAULT NULL
3046: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
3047: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
3048: )

Line 3284: hr_api.mandatory_arg_error

3280: hr_utility.set_location('Entering:'||l_proc,10);
3281: --
3282: -- Ensure mandatory arguments have been passed
3283: --
3284: hr_api.mandatory_arg_error
3285: (p_api_name => l_proc
3286: ,p_argument => 'person_id'
3287: ,p_argument_value => p_person_id
3288: );

Line 3290: hr_api.mandatory_arg_error

3286: ,p_argument => 'person_id'
3287: ,p_argument_value => p_person_id
3288: );
3289: --
3290: hr_api.mandatory_arg_error
3291: (p_api_name => l_proc
3292: ,p_argument => 'effective_date'
3293: ,p_argument_value => p_effective_date
3294: );

Line 3317: WHEN hr_api.cannot_find_prog_unit

3313: ,p_person_type_id => p_person_type_id
3314: ,p_termination_reason => p_termination_reason
3315: );
3316: EXCEPTION
3317: WHEN hr_api.cannot_find_prog_unit
3318: THEN
3319: hr_api.cannot_find_prog_unit_error
3320: (p_module_name => 'TERMINATE_APPLICANT'
3321: ,p_hook_type => 'B'

Line 3319: hr_api.cannot_find_prog_unit_error

3315: );
3316: EXCEPTION
3317: WHEN hr_api.cannot_find_prog_unit
3318: THEN
3319: hr_api.cannot_find_prog_unit_error
3320: (p_module_name => 'TERMINATE_APPLICANT'
3321: ,p_hook_type => 'B'
3322: );
3323: END;

Line 3393: ,p_datetrack_mode => hr_api.g_update

3389: close csr_lock_ptu;
3390: /*
3391: per_per_shd.lck
3392: (p_effective_date => l_effective_date + 1
3393: ,p_datetrack_mode => hr_api.g_update
3394: ,p_person_id => p_person_id
3395: ,p_object_version_number => p_object_version_number
3396: ,p_validation_start_date => l_validation_start_date
3397: ,p_validation_end_date => l_validation_end_date

Line 3425: ,p_datetrack_mode => hr_api.g_zap

3421: per_asg_del.del
3422: (p_assignment_id => l_fut_asg.assignment_id
3423: ,p_object_version_number => l_fut_asg.object_version_number
3424: ,p_effective_date => l_fut_asg.effective_start_date
3425: ,p_datetrack_mode => hr_api.g_zap
3426: ,p_effective_start_date => l_effective_start_date
3427: ,p_effective_end_date => l_effective_end_date
3428: ,p_business_group_id => l_business_group_id
3429: ,p_validation_start_date => l_validation_start_date

Line 3441: if l_assignment.effective_end_date <> hr_api.g_eot then

3437: (p_effective_date => l_effective_date
3438: ,p_person_id => p_person_id
3439: )
3440: LOOP
3441: if l_assignment.effective_end_date <> hr_api.g_eot then
3442: -- delete future DT updates
3443: per_asg_del.del
3444: (p_assignment_id => l_assignment.assignment_id
3445: ,p_object_version_number => l_assignment.object_version_number

Line 3447: ,p_datetrack_mode => hr_api.g_future_change

3443: per_asg_del.del
3444: (p_assignment_id => l_assignment.assignment_id
3445: ,p_object_version_number => l_assignment.object_version_number
3446: ,p_effective_date => l_effective_date
3447: ,p_datetrack_mode => hr_api.g_future_change
3448: ,p_effective_start_date => l_effective_start_date
3449: ,p_effective_end_date => l_effective_end_date
3450: ,p_business_group_id => l_business_group_id
3451: ,p_validation_start_date => l_validation_start_date

Line 3460: ,p_datetrack_mode => hr_api.g_delete

3456: per_asg_del.del
3457: (p_assignment_id => l_assignment.assignment_id
3458: ,p_object_version_number => l_assignment.object_version_number
3459: ,p_effective_date => l_effective_date
3460: ,p_datetrack_mode => hr_api.g_delete
3461: ,p_effective_start_date => l_effective_start_date
3462: ,p_effective_end_date => l_effective_end_date
3463: ,p_business_group_id => l_business_group_id
3464: ,p_validation_start_date => l_validation_start_date

Line 3475: ,p_datetrack_mode => hr_api.g_delete

3471: per_asg_del.del
3472: (p_assignment_id => l_assignment.assignment_id
3473: ,p_object_version_number => l_assignment.object_version_number
3474: ,p_effective_date => l_effective_date
3475: ,p_datetrack_mode => hr_api.g_delete
3476: ,p_effective_start_date => l_effective_start_date
3477: ,p_effective_end_date => l_effective_end_date
3478: ,p_business_group_id => l_business_group_id
3479: ,p_validation_start_date => l_validation_start_date

Line 3621: -- ,p_datetrack_mode => hr_api.g_update

3617: -- ,p_object_version_number => p_object_version_number
3618: -- ,p_effective_date => l_effective_date + 1
3619: -- ,p_applicant_number => l_application.applicant_number
3620: -- ,p_employee_number => l_application.employee_number
3621: -- ,p_datetrack_mode => hr_api.g_update
3622: -- ,p_person_type_id => l_person_type_id1
3623: -- ,p_effective_start_date => l_effective_start_date
3624: -- ,p_effective_end_date => l_effective_end_date
3625: -- ,p_comment_id => l_comment_id

Line 3676: WHEN hr_api.cannot_find_prog_unit

3672: ,p_effective_end_date => l_effective_end_date
3673: ,p_remove_fut_asg_warning => l_remove_future_asg_warning
3674: );
3675: EXCEPTION
3676: WHEN hr_api.cannot_find_prog_unit
3677: THEN
3678: hr_api.cannot_find_prog_unit_error
3679: (p_module_name => 'TERMINATE_APPLICANT'
3680: ,p_hook_type => 'A'

Line 3678: hr_api.cannot_find_prog_unit_error

3674: );
3675: EXCEPTION
3676: WHEN hr_api.cannot_find_prog_unit
3677: THEN
3678: hr_api.cannot_find_prog_unit_error
3679: (p_module_name => 'TERMINATE_APPLICANT'
3680: ,p_hook_type => 'A'
3681: );
3682: END;

Line 3690: RAISE hr_api.validate_enabled;

3686: -- When in validation only mode raise validate enabled exception
3687: --
3688: IF p_validate
3689: THEN
3690: RAISE hr_api.validate_enabled;
3691: END IF;
3692: --
3693: -- Set OUT parameters
3694: --

Line 3702: WHEN hr_api.validate_enabled

3698: --
3699: hr_utility.set_location(' Leaving:'||l_proc,1000);
3700: --
3701: EXCEPTION
3702: WHEN hr_api.validate_enabled
3703: THEN
3704: --
3705: -- In validation only mode
3706: -- Rollback to savepoint

Line 3853: hr_api.mandatory_arg_error

3849: hr_utility.set_location('Entering:'||l_proc,10);
3850: --
3851: -- Ensure mandatory arguments have been passed
3852: --
3853: hr_api.mandatory_arg_error
3854: (p_api_name => l_proc
3855: ,p_argument => 'person_id'
3856: ,p_argument_value => p_person_id
3857: );

Line 3859: hr_api.mandatory_arg_error

3855: ,p_argument => 'person_id'
3856: ,p_argument_value => p_person_id
3857: );
3858: --
3859: hr_api.mandatory_arg_error
3860: (p_api_name => l_proc
3861: ,p_argument => 'effective_date'
3862: ,p_argument_value => p_effective_date
3863: );

Line 3904: WHEN hr_api.cannot_find_prog_unit

3900: ,p_applicant_number => p_applicant_number
3901: ,p_person_type_id => p_person_type_id
3902: );
3903: EXCEPTION
3904: WHEN hr_api.cannot_find_prog_unit
3905: THEN
3906: hr_api.cannot_find_prog_unit_error
3907: (p_module_name => 'APPLY_FOR_VACANCY'
3908: ,p_hook_type => 'BP'

Line 3906: hr_api.cannot_find_prog_unit_error

3902: );
3903: EXCEPTION
3904: WHEN hr_api.cannot_find_prog_unit
3905: THEN
3906: hr_api.cannot_find_prog_unit_error
3907: (p_module_name => 'APPLY_FOR_VACANCY'
3908: ,p_hook_type => 'BP'
3909: );
3910: END;

Line 3928: AND NVL(p_applicant_number,hr_api.g_number) <> l_per_details_rec.applicant_number

3924: --
3925: -- Ensure the applicant number will not be changed if it exists
3926: --
3927: IF l_per_details_rec.applicant_number IS NOT NULL
3928: AND NVL(p_applicant_number,hr_api.g_number) <> l_per_details_rec.applicant_number
3929: THEN
3930: hr_utility.set_location(l_proc,70);
3931: p_applicant_number := l_per_details_rec.applicant_number;
3932: END IF;

Line 3979: WHEN hr_api.cannot_find_prog_unit

3975: ,p_effective_end_date => l_effective_end_date
3976: ,p_appl_override_warning => l_appl_override_warning
3977: );
3978: EXCEPTION
3979: WHEN hr_api.cannot_find_prog_unit
3980: THEN
3981: hr_api.cannot_find_prog_unit_error
3982: (p_module_name => 'APPLY_FOR_VACANCY'
3983: ,p_hook_type => 'AP'

Line 3981: hr_api.cannot_find_prog_unit_error

3977: );
3978: EXCEPTION
3979: WHEN hr_api.cannot_find_prog_unit
3980: THEN
3981: hr_api.cannot_find_prog_unit_error
3982: (p_module_name => 'APPLY_FOR_VACANCY'
3983: ,p_hook_type => 'AP'
3984: );
3985: END;

Line 3993: RAISE hr_api.validate_enabled;

3989: -- When in validation only mode raise validate_enabled exception
3990: --
3991: IF p_validate
3992: THEN
3993: RAISE hr_api.validate_enabled;
3994: END IF;
3995: --
3996: -- Set OUT parameters
3997: --

Line 4006: WHEN hr_api.validate_enabled

4002: hr_utility.set_location(' Leaving:'||l_proc,1000);
4003: --
4004: EXCEPTION
4005: --
4006: WHEN hr_api.validate_enabled
4007: THEN
4008: --
4009: -- In validation only mode
4010: -- Rollback to savepoint

Line 4063: and nvl(date_end,hr_api.g_eot) >= p_effective_date;

4059: select application_id
4060: from per_applications
4061: where person_id = p_person_id
4062: and date_received < p_effective_date
4063: and nvl(date_end,hr_api.g_eot) >= p_effective_date;
4064:
4065: cursor csr_apl_yesterday is
4066: select application_id
4067: from per_applications

Line 4217: hr_api.mandatory_arg_error

4213: --
4214: -- Ensure that the mandatory parameter, p_person_id
4215: -- is not null
4216: --
4217: hr_api.mandatory_arg_error
4218: (p_api_name => l_proc
4219: ,p_argument => 'person id'
4220: ,p_argument_value => p_person_id);
4221: --

Line 4269: when hr_api.cannot_find_prog_unit then

4265: ,p_person_type_id => p_person_type_id
4266: ,p_assignment_status_type_id => p_assignment_status_type_id
4267: );
4268: exception
4269: when hr_api.cannot_find_prog_unit then
4270: hr_api.cannot_find_prog_unit_error
4271: (p_module_name => 'apply_for_job_anytime'
4272: ,p_hook_type => 'BP'
4273: );

Line 4270: hr_api.cannot_find_prog_unit_error

4266: ,p_assignment_status_type_id => p_assignment_status_type_id
4267: );
4268: exception
4269: when hr_api.cannot_find_prog_unit then
4270: hr_api.cannot_find_prog_unit_error
4271: (p_module_name => 'apply_for_job_anytime'
4272: ,p_hook_type => 'BP'
4273: );
4274: --

Line 4345: when hr_api.cannot_find_prog_unit then

4341: ,p_appl_override_warning => l_appl_override_warning
4342: );
4343: --
4344: exception
4345: when hr_api.cannot_find_prog_unit then
4346: hr_api.cannot_find_prog_unit_error
4347: (p_module_name => 'apply_for_job_anytime'
4348: ,p_hook_type => 'AP'
4349: );

Line 4346: hr_api.cannot_find_prog_unit_error

4342: );
4343: --
4344: exception
4345: when hr_api.cannot_find_prog_unit then
4346: hr_api.cannot_find_prog_unit_error
4347: (p_module_name => 'apply_for_job_anytime'
4348: ,p_hook_type => 'AP'
4349: );
4350: --

Line 4374: raise hr_api.validate_enabled;

4370: -- when in validation only mode raise the Validate_Enabled exception
4371: --
4372:
4373: if p_validate then
4374: raise hr_api.validate_enabled;
4375: end if;
4376: --
4377: if g_debug then
4378: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 4381: when hr_api.validate_enabled then

4377: if g_debug then
4378: hr_utility.set_location(' Leaving:'||l_proc, 50);
4379: end if;
4380: exception
4381: when hr_api.validate_enabled then
4382: --
4383: -- As the Validate_Enabled exception has been raised
4384: -- we must rollback to the savepoint
4385: --