DBA Data[Home] [Help]

APPS.PQP_PL_VEHICLE_ALLOCATIONS_API dependencies on HR_UTILITY

Line 79: hr_utility.set_location('Entering:'|| l_proc, 5);

75: begin
76: g_package :='pqp_pl_vehicle_allocations_api.';
77: l_proc := g_package||'create_pl_vehicle_allocation';
78:
79: hr_utility.set_location('Entering:'|| l_proc, 5);
80: --
81: -- Validation in addition to Row Handlers
82: --
83: -- Check that the specified business group is valid.

Line 90: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

86: fetch csr_bg
87: into l_legislation_code;
88: if csr_bg%notfound then
89: close csr_bg;
90: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
91: hr_utility.raise_error;
92: end if;
93: close csr_bg;
94: --

Line 91: hr_utility.raise_error;

87: into l_legislation_code;
88: if csr_bg%notfound then
89: close csr_bg;
90: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
91: hr_utility.raise_error;
92: end if;
93: close csr_bg;
94: --
95: -- Check that the legislation of the specified business group is 'PL'.

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

94: --
95: -- Check that the legislation of the specified business group is 'PL'.
96: --
97: if l_legislation_code <> 'PL' then
98: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
99: hr_utility.set_message_token('LEG_CODE','PL');
100: hr_utility.raise_error;
101: end if;
102:

Line 99: hr_utility.set_message_token('LEG_CODE','PL');

95: -- Check that the legislation of the specified business group is 'PL'.
96: --
97: if l_legislation_code <> 'PL' then
98: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
99: hr_utility.set_message_token('LEG_CODE','PL');
100: hr_utility.raise_error;
101: end if;
102:
103:

Line 100: hr_utility.raise_error;

96: --
97: if l_legislation_code <> 'PL' then
98: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
99: hr_utility.set_message_token('LEG_CODE','PL');
100: hr_utility.raise_error;
101: end if;
102:
103:
104: hr_utility.set_location(l_proc, 6);

Line 104: hr_utility.set_location(l_proc, 6);

100: hr_utility.raise_error;
101: end if;
102:
103:
104: hr_utility.set_location(l_proc, 6);
105:
106:
107: --
108: -- Call the Vehicle Allocation business process

Line 252: hr_utility.set_location('Entering:'|| l_proc, 5);

248: begin
249: g_package :='pqp_pl_vehicle_allocations_api.';
250: l_proc := g_package||'update_pl_vehicle_allocation';
251:
252: hr_utility.set_location('Entering:'|| l_proc, 5);
253: --
254: -- Validation in addition to Row Handlers
255: --
256: -- Check that the specified business group is valid.

Line 263: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

259: fetch csr_bg into l_legislation_code;
260:
261: if csr_bg%notfound then
262: close csr_bg;
263: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
264: hr_utility.raise_error;
265: end if;
266: close csr_bg;
267: --

Line 264: hr_utility.raise_error;

260:
261: if csr_bg%notfound then
262: close csr_bg;
263: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
264: hr_utility.raise_error;
265: end if;
266: close csr_bg;
267: --
268: -- Check that the legislation of the specified business group is 'PL'.

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

267: --
268: -- Check that the legislation of the specified business group is 'PL'.
269: --
270: if l_legislation_code <> 'PL' then
271: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
272: hr_utility.set_message_token('LEG_CODE','PL');
273: hr_utility.raise_error;
274: end if;
275:

Line 272: hr_utility.set_message_token('LEG_CODE','PL');

268: -- Check that the legislation of the specified business group is 'PL'.
269: --
270: if l_legislation_code <> 'PL' then
271: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
272: hr_utility.set_message_token('LEG_CODE','PL');
273: hr_utility.raise_error;
274: end if;
275:
276:

Line 273: hr_utility.raise_error;

269: --
270: if l_legislation_code <> 'PL' then
271: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
272: hr_utility.set_message_token('LEG_CODE','PL');
273: hr_utility.raise_error;
274: end if;
275:
276:
277: hr_utility.set_location(l_proc, 6);

Line 277: hr_utility.set_location(l_proc, 6);

273: hr_utility.raise_error;
274: end if;
275:
276:
277: hr_utility.set_location(l_proc, 6);
278: -- Call for Update Vehicle allocation business process
279: PQP_VEHICLE_ALLOCATIONS_API.update_vehicle_allocation
280: (p_validate => p_validate
281: ,p_effective_date => p_effective_date