DBA Data[Home] [Help]

APPS.HR_PARTICIPANTS_API dependencies on HR_UTILITY

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

56: l_proc varchar2(72) := g_package||'create_participant';
57: l_participant_id per_participants.participant_id%TYPE;
58: l_object_version_number per_participants.object_version_number%TYPE;
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 5);
61: --
62: -- Issue a savepoint.
63: --
64: savepoint create_participant;

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

61: --
62: -- Issue a savepoint.
63: --
64: savepoint create_participant;
65: hr_utility.set_location(l_proc, 6);
66: --
67: -- Call Before Process User Hook
68: --
69: begin

Line 118: hr_utility.set_location(l_proc, 7);

114: -- End of Before Process User Hook call
115: --
116: -- Validation in addition to Table Handlers
117: --
118: hr_utility.set_location(l_proc, 7);
119: --
120: -- Process Logic
121: --
122: per_par_ins.ins

Line 162: hr_utility.set_location(l_proc, 8);

158: p_participant_id => l_participant_id,
159: p_object_version_number => l_object_version_number
160: );
161: --
162: hr_utility.set_location(l_proc, 8);
163: --
164: -- Call After Process User Hook
165: --
166: begin

Line 226: hr_utility.set_location(' Leaving:'||l_proc, 11);

222: --
223: p_participant_id := l_participant_id;
224: p_object_version_number := l_object_version_number;
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 11);
227: exception
228: when hr_api.validate_enabled then
229: --
230: -- As the Validate_Enabled exception has been raised

Line 258: hr_utility.set_location(' Leaving:'||l_proc, 12);

254: raise;
255: --
256: -- End of fix.
257: --
258: hr_utility.set_location(' Leaving:'||l_proc, 12);
259: end create_participant;
260: --
261: --
262: -- ---------------------------------------------------------------------------

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

305: l_proc varchar2(72) := g_package||'update_participant';
306: l_object_version_number per_participants.object_version_number%TYPE;
307: l_ovn per_participants.object_version_number%TYPE := p_object_version_number;
308: begin
309: hr_utility.set_location('Entering:'|| l_proc, 5);
310: --
311: -- Issue a savepoint.
312: --
313: savepoint update_participant;

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

310: --
311: -- Issue a savepoint.
312: --
313: savepoint update_participant;
314: hr_utility.set_location(l_proc, 6);
315: --
316: -- Call Before Process User Hook
317: --
318: begin

Line 365: hr_utility.set_location(l_proc, 7);

361: -- End of Before Process User Hook call
362: --
363: -- Validation in addition to Table Handlers
364: --
365: hr_utility.set_location(l_proc, 7);
366: --
367: -- Process Logic
368: --
369: l_object_version_number := p_object_version_number;

Line 408: hr_utility.set_location(l_proc, 8);

404: p_participant_usage_status => p_participant_usage_status
405: );
406: --
407: --
408: hr_utility.set_location(l_proc, 8);
409: --
410: -- Call After Process User Hook
411: --
412: begin

Line 468: hr_utility.set_location(' Leaving:'||l_proc, 11);

464: -- object version number as the update was successful
465: --
466: p_object_version_number := l_object_version_number;
467: --
468: hr_utility.set_location(' Leaving:'||l_proc, 11);
469: exception
470: when hr_api.validate_enabled then
471: --
472: -- As the Validate_Enabled exception has been raised

Line 499: hr_utility.set_location(' Leaving:'||l_proc, 12);

495: raise;
496: --
497: -- End of fix.
498: --
499: hr_utility.set_location(' Leaving:'||l_proc, 12);
500: --
501: end update_participant;
502: --
503: --

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

527: l_quest_ans_id hr_quest_answers.questionnaire_answer_id%type;
528:
529: --
530: begin
531: hr_utility.set_location('Entering:'|| l_proc, 5);
532: --
533: -- Issue a savepoint.
534: --
535: savepoint delete_participant;

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

532: --
533: -- Issue a savepoint.
534: --
535: savepoint delete_participant;
536: hr_utility.set_location(l_proc, 6);
537: --
538: -- Call Before Process User Hook
539: --
540: begin

Line 558: hr_utility.set_location(l_proc, 7);

554: -- End of Before Process User hook
555: --
556: -- Validation in addition to Table Handlers
557: --
558: hr_utility.set_location(l_proc, 7);
559:
560: open c_quest_ans_id;
561: fetch c_quest_ans_id into l_quest_ans_id;
562: if c_quest_ans_id%found then

Line 581: hr_utility.set_location(l_proc, 8);

577: ,p_participant_id => p_participant_id
578: ,p_object_version_number => p_object_version_number
579: );
580: --
581: hr_utility.set_location(l_proc, 8);
582: --
583: -- Call After Process User Hook
584: --
585: begin

Line 606: hr_utility.set_location(' Leaving:'||l_proc, 11);

602: if p_validate then
603: raise hr_api.validate_enabled;
604: end if;
605: --
606: hr_utility.set_location(' Leaving:'||l_proc, 11);
607: exception
608: when hr_api.validate_enabled then
609: --
610: -- As the Validate_Enabled exception has been raised

Line 627: hr_utility.set_location(' Leaving:'||l_proc, 12);

623: raise;
624: --
625: -- End of fix.
626: --
627: hr_utility.set_location(' Leaving:'||l_proc, 12);
628: end delete_participant;
629: --
630: end hr_participants_api;