DBA Data[Home] [Help]

APPS.HR_HK_PEOPLE_LEG_HOOK dependencies on HR_UTILITY

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

15: l_proc VARCHAR2(200) := g_package||'check_hkid_passport';
16: l_system_person_type per_person_types.system_person_type%type;
17:
18: BEGIN
19: hr_utility.set_location('Entering:'|| l_proc, 10);
20:
21: /*Bug 8457005 - Removed the condition and modified the existing check such that the validation of
22: national identifier and passport number is performed,only if Payroll for HK Legislation
23: is installed ,otherwise the validation is skipped */

Line 25: IF NOT hr_utility.chk_product_install('Oracle Payroll', 'HK') THEN

21: /*Bug 8457005 - Removed the condition and modified the existing check such that the validation of
22: national identifier and passport number is performed,only if Payroll for HK Legislation
23: is installed ,otherwise the validation is skipped */
24:
25: IF NOT hr_utility.chk_product_install('Oracle Payroll', 'HK') THEN
26: hr_utility.trace ('HK Legislation not installed. Not performing the validations');
27: RETURN;
28: END IF;
29:

Line 26: hr_utility.trace ('HK Legislation not installed. Not performing the validations');

22: national identifier and passport number is performed,only if Payroll for HK Legislation
23: is installed ,otherwise the validation is skipped */
24:
25: IF NOT hr_utility.chk_product_install('Oracle Payroll', 'HK') THEN
26: hr_utility.trace ('HK Legislation not installed. Not performing the validations');
27: RETURN;
28: END IF;
29:
30: OPEN csr_val_person_type(p_person_type_id);

Line 44: hr_utility.set_message(800,'HR_HK_HKID_OR_PASSPORT_INFO');

40: OR (p_per_information2 IS NULL)
41: OR (p_per_information3 IS NULL)
42: OR (p_per_information4 IS NULL)) THEN
43: -- Error
44: hr_utility.set_message(800,'HR_HK_HKID_OR_PASSPORT_INFO');
45: hr_utility.raise_error;
46: END IF;
47: END IF;
48: END IF;

Line 45: hr_utility.raise_error;

41: OR (p_per_information3 IS NULL)
42: OR (p_per_information4 IS NULL)) THEN
43: -- Error
44: hr_utility.set_message(800,'HR_HK_HKID_OR_PASSPORT_INFO');
45: hr_utility.raise_error;
46: END IF;
47: END IF;
48: END IF;
49: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 49: hr_utility.set_location(' Leaving:'||l_proc, 20);

45: hr_utility.raise_error;
46: END IF;
47: END IF;
48: END IF;
49: hr_utility.set_location(' Leaving:'||l_proc, 20);
50: END check_hkid_passport;
51:
52:
53:

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

59: l_proc VARCHAR2(200) := g_package|| 'check_hongkong_name';
60: l_system_person_type per_person_types.system_person_type%type;
61:
62: BEGIN
63: hr_utility.set_location('Entering:'|| l_proc, 10);
64: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'HK') THEN
65: hr_utility.trace ('HK Legislation not installed. Not performing the validations');
66: RETURN;
67: END IF;

Line 64: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'HK') THEN

60: l_system_person_type per_person_types.system_person_type%type;
61:
62: BEGIN
63: hr_utility.set_location('Entering:'|| l_proc, 10);
64: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'HK') THEN
65: hr_utility.trace ('HK Legislation not installed. Not performing the validations');
66: RETURN;
67: END IF;
68:

Line 65: hr_utility.trace ('HK Legislation not installed. Not performing the validations');

61:
62: BEGIN
63: hr_utility.set_location('Entering:'|| l_proc, 10);
64: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'HK') THEN
65: hr_utility.trace ('HK Legislation not installed. Not performing the validations');
66: RETURN;
67: END IF;
68:
69: OPEN csr_val_person_type(p_person_type_id);

Line 76: hr_utility.set_message('800', 'HR_HK_HONGKONG_NAME');

72: CLOSE csr_val_person_type;
73:
74: IF l_system_person_type like 'EMP%' THEN
75: IF (p_per_information6 IS NULL) THEN
76: hr_utility.set_message('800', 'HR_HK_HONGKONG_NAME');
77: hr_utility.raise_error;
78: END IF;
79: END IF;
80:

Line 77: hr_utility.raise_error;

73:
74: IF l_system_person_type like 'EMP%' THEN
75: IF (p_per_information6 IS NULL) THEN
76: hr_utility.set_message('800', 'HR_HK_HONGKONG_NAME');
77: hr_utility.raise_error;
78: END IF;
79: END IF;
80:
81: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 81: hr_utility.set_location(' Leaving:'||l_proc, 20);

77: hr_utility.raise_error;
78: END IF;
79: END IF;
80:
81: hr_utility.set_location(' Leaving:'||l_proc, 20);
82: EXCEPTION
83: WHEN OTHERS THEN
84: hr_utility.trace('Error in ' || l_proc );
85: raise;

Line 84: hr_utility.trace('Error in ' || l_proc );

80:
81: hr_utility.set_location(' Leaving:'||l_proc, 20);
82: EXCEPTION
83: WHEN OTHERS THEN
84: hr_utility.trace('Error in ' || l_proc );
85: raise;
86: END check_hongkong_name;
87:
88: