DBA Data[Home] [Help]

APPS.HR_NZ_ASSIGNMENT_LEG_HOOK dependencies on HR_UTILITY

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

61: l_business_group_id per_business_groups.business_group_id%TYPE;
62: l_proc VARCHAR2(72) := g_package||'set_bus_grp_id';
63:
64: BEGIN
65: hr_utility.set_location('Entering:'|| l_proc, 10);
66: OPEN csr_get_business_group_id(p_assignment_id,p_effective_date);
67: FETCH csr_get_business_group_id INTO l_business_group_id;
68: IF (csr_get_business_group_id%NOTFOUND)
69: THEN

Line 72: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

68: IF (csr_get_business_group_id%NOTFOUND)
69: THEN
70: -- Assignment not valid for current legislation
71: CLOSE csr_get_business_group_id;
72: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
73: hr_utility.set_message_token('LEG_CODE','NZ');
74: hr_utility.raise_error;
75: END IF;
76: CLOSE csr_get_business_group_id;

Line 73: hr_utility.set_message_token('LEG_CODE','NZ');

69: THEN
70: -- Assignment not valid for current legislation
71: CLOSE csr_get_business_group_id;
72: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
73: hr_utility.set_message_token('LEG_CODE','NZ');
74: hr_utility.raise_error;
75: END IF;
76: CLOSE csr_get_business_group_id;
77: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_business_group_id);

Line 74: hr_utility.raise_error;

70: -- Assignment not valid for current legislation
71: CLOSE csr_get_business_group_id;
72: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
73: hr_utility.set_message_token('LEG_CODE','NZ');
74: hr_utility.raise_error;
75: END IF;
76: CLOSE csr_get_business_group_id;
77: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_business_group_id);
78: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

74: hr_utility.raise_error;
75: END IF;
76: CLOSE csr_get_business_group_id;
77: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_business_group_id);
78: hr_utility.set_location(' Leaving:'||l_proc, 20);
79: END set_upd_bus_grp_id;
80: --
81: PROCEDURE set_cre_bus_grp_id( p_person_id NUMBER, p_effective_date DATE ) IS
82: --

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

93: l_business_group_id per_business_groups.business_group_id%TYPE;
94: l_proc VARCHAR2(72) := g_package||'set_bus_grp_id';
95: --
96: BEGIN
97: hr_utility.set_location('Entering:'|| l_proc, 10);
98: OPEN csr_get_business_group_id(p_person_id, p_effective_date);
99: FETCH csr_get_business_group_id INTO l_business_group_id;
100: IF (csr_get_business_group_id%NOTFOUND)
101: THEN

Line 104: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

100: IF (csr_get_business_group_id%NOTFOUND)
101: THEN
102: -- Person not valid for current legislation
103: CLOSE csr_get_business_group_id;
104: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
105: hr_utility.set_message_token('LEG_CODE','NZ');
106: hr_utility.raise_error;
107: END IF;
108: CLOSE csr_get_business_group_id;

Line 105: hr_utility.set_message_token('LEG_CODE','NZ');

101: THEN
102: -- Person not valid for current legislation
103: CLOSE csr_get_business_group_id;
104: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
105: hr_utility.set_message_token('LEG_CODE','NZ');
106: hr_utility.raise_error;
107: END IF;
108: CLOSE csr_get_business_group_id;
109: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_business_group_id);

Line 106: hr_utility.raise_error;

102: -- Person not valid for current legislation
103: CLOSE csr_get_business_group_id;
104: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
105: hr_utility.set_message_token('LEG_CODE','NZ');
106: hr_utility.raise_error;
107: END IF;
108: CLOSE csr_get_business_group_id;
109: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_business_group_id);
110: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

106: hr_utility.raise_error;
107: END IF;
108: CLOSE csr_get_business_group_id;
109: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_business_group_id);
110: hr_utility.set_location(' Leaving:'||l_proc, 20);
111: END set_cre_bus_grp_id;
112: --
113: END hr_nz_assignment_leg_hook;