DBA Data[Home] [Help]

APPS.HR_FR_CONTRACT_API dependencies on HR_UTILITY

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

91: where pbg.business_group_id = l_business_group_id;
92: --
93: begin
94:
95: hr_utility.set_location('Entering:'|| l_proc, 10);
96: --
97: -- Issue a savepoint if operating in validation only mode
98: --
99: savepoint create_fr_contract;

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

97: -- Issue a savepoint if operating in validation only mode
98: --
99: savepoint create_fr_contract;
100: --
101: hr_utility.set_location(l_proc, 20);
102: --
103: -- Process Logic
104: --
105: -- Get person details.

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

111: if csr_get_business_group_id%NOTFOUND then
112: --
113: close csr_get_business_group_id;
114: --
115: hr_utility.set_location(l_proc, 30);
116: --
117: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
118: hr_utility.raise_error;
119: end if;

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

113: close csr_get_business_group_id;
114: --
115: hr_utility.set_location(l_proc, 30);
116: --
117: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
118: hr_utility.raise_error;
119: end if;
120: --
121: close csr_get_business_group_id;

Line 118: hr_utility.raise_error;

114: --
115: hr_utility.set_location(l_proc, 30);
116: --
117: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
118: hr_utility.raise_error;
119: end if;
120: --
121: close csr_get_business_group_id;
122: --

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

119: end if;
120: --
121: close csr_get_business_group_id;
122: --
123: hr_utility.set_location(l_proc, 40);
124: --
125: -- Check that the specified business group is valid.
126: --
127: open csr_bg;

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

128: fetch csr_bg
129: into l_legislation_code;
130: if csr_bg%notfound then
131: close csr_bg;
132: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
133: hr_utility.raise_error;
134: end if;
135: close csr_bg;
136: hr_utility.set_location(l_proc, 50);

Line 133: hr_utility.raise_error;

129: into l_legislation_code;
130: if csr_bg%notfound then
131: close csr_bg;
132: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
133: hr_utility.raise_error;
134: end if;
135: close csr_bg;
136: hr_utility.set_location(l_proc, 50);
137: --

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

132: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
133: hr_utility.raise_error;
134: end if;
135: close csr_bg;
136: hr_utility.set_location(l_proc, 50);
137: --
138: -- Check that the legislation of the specified business group is 'FR'.
139: --
140: if l_legislation_code <> 'FR' then

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

137: --
138: -- Check that the legislation of the specified business group is 'FR'.
139: --
140: if l_legislation_code <> 'FR' then
141: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
142: hr_utility.set_message_token('LEG_CODE','FR');
143: hr_utility.raise_error;
144: end if;
145: hr_utility.set_location(l_proc, 60);

Line 142: hr_utility.set_message_token('LEG_CODE','FR');

138: -- Check that the legislation of the specified business group is 'FR'.
139: --
140: if l_legislation_code <> 'FR' then
141: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
142: hr_utility.set_message_token('LEG_CODE','FR');
143: hr_utility.raise_error;
144: end if;
145: hr_utility.set_location(l_proc, 60);
146: --

Line 143: hr_utility.raise_error;

139: --
140: if l_legislation_code <> 'FR' then
141: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
142: hr_utility.set_message_token('LEG_CODE','FR');
143: hr_utility.raise_error;
144: end if;
145: hr_utility.set_location(l_proc, 60);
146: --
147: -- Number to canonical conversion

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

141: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
142: hr_utility.set_message_token('LEG_CODE','FR');
143: hr_utility.raise_error;
144: end if;
145: hr_utility.set_location(l_proc, 60);
146: --
147: -- Number to canonical conversion
148: --
149: l_amount := fnd_number.number_to_canonical(p_amount);

Line 216: hr_utility.set_location(' Leaving:'||l_proc, 70);

212: ,p_attribute20 => p_attribute20
213: ,p_effective_date => p_effective_date
214: );
215: --
216: hr_utility.set_location(' Leaving:'||l_proc, 70);
217: end create_fr_contract;
218: --
219: -- ----------------------------------------------------------------------------
220: -- |------------------------< update_fr_contract >----------------------|

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

303: where pbg.business_group_id = l_business_group_id;
304: --
305: begin
306:
307: hr_utility.set_location('Entering:'|| l_proc, 10);
308: --
309: -- Issue a savepoint if operating in validation only mode
310: --
311: savepoint update_fr_contract;

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

309: -- Issue a savepoint if operating in validation only mode
310: --
311: savepoint update_fr_contract;
312: --
313: hr_utility.set_location(l_proc, 20);
314: --
315: -- Process Logic
316: --
317: -- Get person details.

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

323: if csr_get_business_group_id%NOTFOUND then
324: --
325: close csr_get_business_group_id;
326: --
327: hr_utility.set_location(l_proc, 30);
328: --
329: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
330: hr_utility.raise_error;
331: end if;

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

325: close csr_get_business_group_id;
326: --
327: hr_utility.set_location(l_proc, 30);
328: --
329: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
330: hr_utility.raise_error;
331: end if;
332: --
333: close csr_get_business_group_id;

Line 330: hr_utility.raise_error;

326: --
327: hr_utility.set_location(l_proc, 30);
328: --
329: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
330: hr_utility.raise_error;
331: end if;
332: --
333: close csr_get_business_group_id;
334: --

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

331: end if;
332: --
333: close csr_get_business_group_id;
334: --
335: hr_utility.set_location(l_proc, 40);
336: --
337: -- Check that the specified business group is valid.
338: --
339: open csr_bg;

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

340: fetch csr_bg
341: into l_legislation_code;
342: if csr_bg%notfound then
343: close csr_bg;
344: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
345: hr_utility.raise_error;
346: end if;
347: close csr_bg;
348: hr_utility.set_location(l_proc, 50);

Line 345: hr_utility.raise_error;

341: into l_legislation_code;
342: if csr_bg%notfound then
343: close csr_bg;
344: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
345: hr_utility.raise_error;
346: end if;
347: close csr_bg;
348: hr_utility.set_location(l_proc, 50);
349: --

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

344: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
345: hr_utility.raise_error;
346: end if;
347: close csr_bg;
348: hr_utility.set_location(l_proc, 50);
349: --
350: -- Check that the legislation of the specified business group is 'FR'.
351: --
352: if l_legislation_code <> 'FR' then

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

349: --
350: -- Check that the legislation of the specified business group is 'FR'.
351: --
352: if l_legislation_code <> 'FR' then
353: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
354: hr_utility.set_message_token('LEG_CODE','FR');
355: hr_utility.raise_error;
356: end if;
357: hr_utility.set_location(l_proc, 60);

Line 354: hr_utility.set_message_token('LEG_CODE','FR');

350: -- Check that the legislation of the specified business group is 'FR'.
351: --
352: if l_legislation_code <> 'FR' then
353: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
354: hr_utility.set_message_token('LEG_CODE','FR');
355: hr_utility.raise_error;
356: end if;
357: hr_utility.set_location(l_proc, 60);
358: --

Line 355: hr_utility.raise_error;

351: --
352: if l_legislation_code <> 'FR' then
353: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
354: hr_utility.set_message_token('LEG_CODE','FR');
355: hr_utility.raise_error;
356: end if;
357: hr_utility.set_location(l_proc, 60);
358: --
359: -- Check that valid value for l_amount.

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

353: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
354: hr_utility.set_message_token('LEG_CODE','FR');
355: hr_utility.raise_error;
356: end if;
357: hr_utility.set_location(l_proc, 60);
358: --
359: -- Check that valid value for l_amount.
360: --
361: if p_amount = hr_api.g_number then

Line 433: hr_utility.set_location(' Leaving:'||l_proc, 70);

429: ,p_effective_date => p_effective_date
430: ,p_datetrack_mode => p_datetrack_mode
431: );
432: --
433: hr_utility.set_location(' Leaving:'||l_proc, 70);
434: --
435: end update_fr_contract;
436: end hr_fr_contract_api;