DBA Data[Home] [Help]

APPS.PQH_RULE_SETS_API dependencies on HR_UTILITY

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

38: l_object_version_number pqh_rule_sets.object_version_number%TYPE;
39: --
40: begin
41: --
42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --
44: -- Issue a savepoint if operating in validation only mode
45: --
46: savepoint create_RULE_SET;

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

44: -- Issue a savepoint if operating in validation only mode
45: --
46: savepoint create_RULE_SET;
47: --
48: hr_utility.set_location(l_proc, 20);
49: --
50: -- Process Logic
51: --
52: begin

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

144: -- End of API User Hook for the after hook of create_RULE_SET
145: --
146: end;
147: --
148: hr_utility.set_location(l_proc, 60);
149: --
150: -- When in validation only mode raise the Validate_Enabled exception
151: --
152: if p_validate then

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

157: --
158: p_rule_set_id := l_rule_set_id;
159: p_object_version_number := l_object_version_number;
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 70);
162: --
163: exception
164: --
165: when hr_api.validate_enabled then

Line 178: hr_utility.set_location(' Leaving:'||l_proc, 80);

174: -- when validation only mode is being used.)
175: --
176: p_rule_set_id := null;
177: p_object_version_number := null;
178: hr_utility.set_location(' Leaving:'||l_proc, 80);
179: --
180: when others then
181: p_rule_set_id := null;
182: p_object_version_number := null;

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

218: l_object_version_number pqh_rule_sets.object_version_number%TYPE;
219: --
220: begin
221: --
222: hr_utility.set_location('Entering:'|| l_proc, 10);
223: --
224: -- Issue a savepoint if operating in validation only mode
225: --
226: savepoint update_RULE_SET;

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

224: -- Issue a savepoint if operating in validation only mode
225: --
226: savepoint update_RULE_SET;
227: --
228: hr_utility.set_location(l_proc, 20);
229: hr_utility.set_location('description passed is'||p_description, 20);
230: hr_utility.set_location('rule_set_name passed is'||p_rule_set_name, 30);
231: --
232: -- Process Logic

Line 229: hr_utility.set_location('description passed is'||p_description, 20);

225: --
226: savepoint update_RULE_SET;
227: --
228: hr_utility.set_location(l_proc, 20);
229: hr_utility.set_location('description passed is'||p_description, 20);
230: hr_utility.set_location('rule_set_name passed is'||p_rule_set_name, 30);
231: --
232: -- Process Logic
233: --

Line 230: hr_utility.set_location('rule_set_name passed is'||p_rule_set_name, 30);

226: savepoint update_RULE_SET;
227: --
228: hr_utility.set_location(l_proc, 20);
229: hr_utility.set_location('description passed is'||p_description, 20);
230: hr_utility.set_location('rule_set_name passed is'||p_rule_set_name, 30);
231: --
232: -- Process Logic
233: --
234: l_object_version_number := p_object_version_number;

Line 289: hr_utility.set_location('description passed is'||p_description, 70);

285: ,p_seeded_rule_flag => p_seeded_rule_flag
286: ,p_status => p_status
287: );
288: --
289: hr_utility.set_location('description passed is'||p_description, 70);
290: hr_utility.set_location('rule_set_name passed is'||p_rule_set_name, 80);
291: --
292: pqh_rtl_upd.upd_tl(
293: p_language_code => p_language_code,

Line 290: hr_utility.set_location('rule_set_name passed is'||p_rule_set_name, 80);

286: ,p_status => p_status
287: );
288: --
289: hr_utility.set_location('description passed is'||p_description, 70);
290: hr_utility.set_location('rule_set_name passed is'||p_rule_set_name, 80);
291: --
292: pqh_rtl_upd.upd_tl(
293: p_language_code => p_language_code,
294: p_rule_set_id => p_rule_set_id ,

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

329: -- End of API User Hook for the after hook of update_RULE_SET
330: --
331: end;
332: --
333: hr_utility.set_location(l_proc, 60);
334: --
335: -- When in validation only mode raise the Validate_Enabled exception
336: --
337: if p_validate then

Line 346: hr_utility.set_location('description passed is'||p_description, 170);

342: --
343: p_object_version_number := l_object_version_number;
344: --
345: --
346: hr_utility.set_location('description passed is'||p_description, 170);
347: hr_utility.set_location('rule_set_name passed is'||p_rule_set_name, 180);
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 70);
350: --

Line 347: hr_utility.set_location('rule_set_name passed is'||p_rule_set_name, 180);

343: p_object_version_number := l_object_version_number;
344: --
345: --
346: hr_utility.set_location('description passed is'||p_description, 170);
347: hr_utility.set_location('rule_set_name passed is'||p_rule_set_name, 180);
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 70);
350: --
351: exception

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

345: --
346: hr_utility.set_location('description passed is'||p_description, 170);
347: hr_utility.set_location('rule_set_name passed is'||p_rule_set_name, 180);
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 70);
350: --
351: exception
352: --
353: when hr_api.validate_enabled then

Line 364: hr_utility.set_location(' Leaving:'||l_proc, 80);

360: -- Only set output warning arguments
361: -- (Any key or derived arguments must be set to null
362: -- when validation only mode is being used.)
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 80);
365: --
366: when others then
367: p_object_version_number := l_object_version_number;
368: --

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

395: from pqh_rule_attributes where rule_set_id = p_rule_set_id;
396:
397: begin
398: --
399: hr_utility.set_location('Entering:'|| l_proc, 10);
400: --
401: -- Issue a savepoint if operating in validation only mode
402: --
403: savepoint delete_RULE_SET;

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

401: -- Issue a savepoint if operating in validation only mode
402: --
403: savepoint delete_RULE_SET;
404: --
405: hr_utility.set_location(l_proc, 20);
406: --
407: -- Process Logic
408: --
409: l_object_version_number := p_object_version_number;

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

477: -- End of API User Hook for the after hook of delete_RULE_SET
478: --
479: end;
480: --
481: hr_utility.set_location(l_proc, 60);
482: --
483: -- When in validation only mode raise the Validate_Enabled exception
484: --
485: if p_validate then

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

485: if p_validate then
486: raise hr_api.validate_enabled;
487: end if;
488: --
489: hr_utility.set_location(' Leaving:'||l_proc, 70);
490: --
491: exception
492: --
493: when hr_api.validate_enabled then

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

527: l_proc varchar2(72) := g_package||'lck';
528: --
529: begin
530: --
531: hr_utility.set_location('Entering:'|| l_proc, 10);
532: --
533: pqh_rst_shd.lck
534: (
535: p_rule_set_id => p_rule_set_id

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

535: p_rule_set_id => p_rule_set_id
536: ,p_object_version_number => p_object_version_number
537: );
538: --
539: hr_utility.set_location(' Leaving:'||l_proc, 70);
540: --
541: end lck;
542: --
543: end pqh_RULE_SETS_api;