DBA Data[Home] [Help]

APPS.HR_AE_CONTRACT_API dependencies on HR_UTILITY

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

78: WHERE pbg.business_group_id = l_business_group_id;
79: --
80: BEGIN
81: --
82: hr_utility.set_location('Entering:'|| l_proc, 10);
83: --
84: -- Issue a savepoint if operating in validation only mode
85: --
86: SAVEPOINT create_ae_contract;

Line 88: hr_utility.set_location(l_proc, 20);

84: -- Issue a savepoint if operating in validation only mode
85: --
86: SAVEPOINT create_ae_contract;
87: --
88: hr_utility.set_location(l_proc, 20);
89: --
90: -- Process Logic
91: --
92: -- Get person details.

Line 102: hr_utility.set_location(l_proc, 30);

98: IF csr_get_business_group_id%NOTFOUND THEN
99: --
100: CLOSE csr_get_business_group_id;
101: --
102: hr_utility.set_location(l_proc, 30);
103: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
104: hr_utility.raise_error;
105: --
106: END IF;

Line 103: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');

99: --
100: CLOSE csr_get_business_group_id;
101: --
102: hr_utility.set_location(l_proc, 30);
103: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
104: hr_utility.raise_error;
105: --
106: END IF;
107: --

Line 104: hr_utility.raise_error;

100: CLOSE csr_get_business_group_id;
101: --
102: hr_utility.set_location(l_proc, 30);
103: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
104: hr_utility.raise_error;
105: --
106: END IF;
107: --
108: CLOSE csr_get_business_group_id;

Line 110: hr_utility.set_location(l_proc, 40);

106: END IF;
107: --
108: CLOSE csr_get_business_group_id;
109: --
110: hr_utility.set_location(l_proc, 40);
111: --
112: -- Check that the specified business group IS valid.
113: --
114: OPEN csr_bg;

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

117: IF csr_bg%NOTFOUND THEN
118: --
119: CLOSE csr_bg;
120: --
121: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
122: hr_utility.raise_error;
123: --
124: END IF;
125: --

Line 122: hr_utility.raise_error;

118: --
119: CLOSE csr_bg;
120: --
121: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
122: hr_utility.raise_error;
123: --
124: END IF;
125: --
126: CLOSE csr_bg;

Line 128: hr_utility.set_location(l_proc, 50);

124: END IF;
125: --
126: CLOSE csr_bg;
127: --
128: hr_utility.set_location(l_proc, 50);
129: --
130: -- Check that the legislation of the specified business group is 'AE'.
131: --
132: IF l_legislation_code <> 'AE' THEN

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

130: -- Check that the legislation of the specified business group is 'AE'.
131: --
132: IF l_legislation_code <> 'AE' THEN
133: --
134: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
135: hr_utility.set_message_token('LEG_CODE','AE');
136: hr_utility.raise_error;
137: --
138: END IF;

Line 135: hr_utility.set_message_token('LEG_CODE','AE');

131: --
132: IF l_legislation_code <> 'AE' THEN
133: --
134: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
135: hr_utility.set_message_token('LEG_CODE','AE');
136: hr_utility.raise_error;
137: --
138: END IF;
139: --

Line 136: hr_utility.raise_error;

132: IF l_legislation_code <> 'AE' THEN
133: --
134: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
135: hr_utility.set_message_token('LEG_CODE','AE');
136: hr_utility.raise_error;
137: --
138: END IF;
139: --
140: hr_utility.set_location(l_proc, 60);

Line 140: hr_utility.set_location(l_proc, 60);

136: hr_utility.raise_error;
137: --
138: END IF;
139: --
140: hr_utility.set_location(l_proc, 60);
141: --
142: -- Call the contract business process
143: --
144: hr_contract_api.create_contract

Line 194: hr_utility.set_location(' Leaving:'||l_proc, 999);

190: ,p_attribute19 => p_attribute19
191: ,p_attribute20 => p_attribute20
192: ,p_effective_date => p_effective_date);
193: --
194: hr_utility.set_location(' Leaving:'||l_proc, 999);
195: --
196: END create_ae_contract;
197: --
198: -- ----------------------------------------------------------------------

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

268: WHERE pbg.business_group_id = l_business_group_id;
269: --
270: BEGIN
271: --
272: hr_utility.set_location('Entering:'|| l_proc, 10);
273: --
274: -- Issue a savepoint if operating in validation only mode
275: --
276: SAVEPOINT update_ae_contract;

Line 278: hr_utility.set_location(l_proc, 20);

274: -- Issue a savepoint if operating in validation only mode
275: --
276: SAVEPOINT update_ae_contract;
277: --
278: hr_utility.set_location(l_proc, 20);
279: --
280: -- Process Logic
281: --
282: -- Get person details.

Line 292: hr_utility.set_location(l_proc, 30);

288: IF csr_get_business_group_id%NOTFOUND THEN
289: --
290: CLOSE csr_get_business_group_id;
291: --
292: hr_utility.set_location(l_proc, 30);
293: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
294: hr_utility.raise_error;
295: --
296: END IF;

Line 293: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');

289: --
290: CLOSE csr_get_business_group_id;
291: --
292: hr_utility.set_location(l_proc, 30);
293: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
294: hr_utility.raise_error;
295: --
296: END IF;
297: --

Line 294: hr_utility.raise_error;

290: CLOSE csr_get_business_group_id;
291: --
292: hr_utility.set_location(l_proc, 30);
293: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
294: hr_utility.raise_error;
295: --
296: END IF;
297: --
298: CLOSE csr_get_business_group_id;

Line 300: hr_utility.set_location(l_proc, 40);

296: END IF;
297: --
298: CLOSE csr_get_business_group_id;
299: --
300: hr_utility.set_location(l_proc, 40);
301: --
302: -- Check that the specified business group is valid.
303: --
304: OPEN csr_bg;

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

307: IF csr_bg%NOTFOUND THEN
308: --
309: CLOSE csr_bg;
310: --
311: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
312: hr_utility.raise_error;
313: --
314: END IF;
315: --

Line 312: hr_utility.raise_error;

308: --
309: CLOSE csr_bg;
310: --
311: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
312: hr_utility.raise_error;
313: --
314: END IF;
315: --
316: CLOSE csr_bg;

Line 318: hr_utility.set_location(l_proc, 50);

314: END IF;
315: --
316: CLOSE csr_bg;
317: --
318: hr_utility.set_location(l_proc, 50);
319: --
320: -- Check that the legislation of the specified business group IS 'AE'.
321: --
322: IF l_legislation_code <> 'AE' THEN

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

320: -- Check that the legislation of the specified business group IS 'AE'.
321: --
322: IF l_legislation_code <> 'AE' THEN
323: --
324: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
325: hr_utility.set_message_token('LEG_CODE','AE');
326: hr_utility.raise_error;
327: --
328: END IF;

Line 325: hr_utility.set_message_token('LEG_CODE','AE');

321: --
322: IF l_legislation_code <> 'AE' THEN
323: --
324: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
325: hr_utility.set_message_token('LEG_CODE','AE');
326: hr_utility.raise_error;
327: --
328: END IF;
329: --

Line 326: hr_utility.raise_error;

322: IF l_legislation_code <> 'AE' THEN
323: --
324: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
325: hr_utility.set_message_token('LEG_CODE','AE');
326: hr_utility.raise_error;
327: --
328: END IF;
329: --
330: hr_utility.set_location(l_proc, 60);

Line 330: hr_utility.set_location(l_proc, 60);

326: hr_utility.raise_error;
327: --
328: END IF;
329: --
330: hr_utility.set_location(l_proc, 60);
331: --
332: -- Call the contract business process
333: --
334: hr_contract_api.update_contract

Line 385: hr_utility.set_location(' Leaving:'||l_proc, 999);

381: ,p_attribute20 => p_attribute20
382: ,p_effective_date => p_effective_date
383: ,p_datetrack_mode => p_datetrack_mode);
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 999);
386: --
387: END update_ae_contract;
388: --
389: END hr_ae_contract_api;