DBA Data[Home] [Help]

APPS.PQH_WORKSHEET_DETAILS_API dependencies on HR_UTILITY

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

51: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;
52: --
53: begin
54: --
55: hr_utility.set_location('Entering:'|| l_proc, 10);
56: --
57: -- Issue a savepoint if operating in validation only mode
58: --
59: savepoint create_WORKSHEET_DETAIL;

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

57: -- Issue a savepoint if operating in validation only mode
58: --
59: savepoint create_WORKSHEET_DETAIL;
60: --
61: hr_utility.set_location(l_proc, 20);
62: --
63: -- Process Logic
64: --
65: begin

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

193: -- End of API User Hook for the after hook of create_WORKSHEET_DETAIL
194: --
195: end;
196: --
197: hr_utility.set_location(l_proc, 60);
198: --
199: -- When in validation only mode raise the Validate_Enabled exception
200: --
201: if p_validate then

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

206: --
207: p_worksheet_detail_id := l_worksheet_detail_id;
208: p_object_version_number := l_object_version_number;
209: --
210: hr_utility.set_location(' Leaving:'||l_proc, 70);
211: --
212: exception
213: --
214: when hr_api.validate_enabled then

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

223: -- when validation only mode is being used.)
224: --
225: p_worksheet_detail_id := null;
226: p_object_version_number := null;
227: hr_utility.set_location(' Leaving:'||l_proc, 80);
228: --
229: when others then
230: p_worksheet_detail_id := null;
231: p_object_version_number := null;

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

289: l_budget_unit3_available number;
290: --
291: begin
292: --
293: hr_utility.set_location('Entering:'|| l_proc, 10);
294: --
295: if nvl(p_action_cd,'D') = 'B' then
296: l_budget_unit1_available := 0;
297: l_budget_unit2_available := 0;

Line 343: hr_utility.set_location('Created WKS Dtl : '|| l_worksheet_detail_id, 100);

339: ,p_effective_date => trunc(p_effective_date)
340: );
341: --
342: --
343: hr_utility.set_location('Created WKS Dtl : '|| l_worksheet_detail_id, 100);
344: --
345: --
346: --
347: if nvl(p_action_cd,'D') ='B' then

Line 369: hr_utility.set_location('Created WKS Period : '|| l_worksheet_period_id, 200);

365: ,p_wpr_ovn => l_wpr_ovn
366: );
367: end if;
368: --
369: hr_utility.set_location('Created WKS Period : '|| l_worksheet_period_id, 200);
370: --
371: end if;
372: p_object_version_number := l_wkd_ovn;
373: p_worksheet_detail_id := l_worksheet_detail_id;

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

423: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;
424: --
425: begin
426: --
427: hr_utility.set_location('Entering:'|| l_proc, 10);
428: --
429: -- Issue a savepoint if operating in validation only mode
430: --
431: savepoint update_WORKSHEET_DETAIL;

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

429: -- Issue a savepoint if operating in validation only mode
430: --
431: savepoint update_WORKSHEET_DETAIL;
432: --
433: hr_utility.set_location(l_proc, 20);
434: --
435: -- Process Logic
436: --
437: l_object_version_number := p_object_version_number;

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

568: -- End of API User Hook for the after hook of update_WORKSHEET_DETAIL
569: --
570: end;
571: --
572: hr_utility.set_location(l_proc, 60);
573: --
574: -- When in validation only mode raise the Validate_Enabled exception
575: --
576: if p_validate then

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

580: -- Set all output arguments
581: --
582: p_object_version_number := l_object_version_number;
583: --
584: hr_utility.set_location(' Leaving:'||l_proc, 70);
585: --
586: exception
587: --
588: when hr_api.validate_enabled then

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

595: -- Only set output warning arguments
596: -- (Any key or derived arguments must be set to null
597: -- when validation only mode is being used.)
598: --
599: hr_utility.set_location(' Leaving:'||l_proc, 80);
600: --
601: when others then
602: p_object_version_number := l_object_version_number;
603: --

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

624: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;
625: --
626: begin
627: --
628: hr_utility.set_location('Entering:'|| l_proc, 10);
629: --
630: -- Issue a savepoint if operating in validation only mode
631: --
632: savepoint delete_WORKSHEET_DETAIL;

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

630: -- Issue a savepoint if operating in validation only mode
631: --
632: savepoint delete_WORKSHEET_DETAIL;
633: --
634: hr_utility.set_location(l_proc, 20);
635: --
636: -- Process Logic
637: --
638: l_object_version_number := p_object_version_number;

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

686: -- End of API User Hook for the after hook of delete_WORKSHEET_DETAIL
687: --
688: end;
689: --
690: hr_utility.set_location(l_proc, 60);
691: --
692: -- When in validation only mode raise the Validate_Enabled exception
693: --
694: if p_validate then

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

694: if p_validate then
695: raise hr_api.validate_enabled;
696: end if;
697: --
698: hr_utility.set_location(' Leaving:'||l_proc, 70);
699: --
700: exception
701: --
702: when hr_api.validate_enabled then

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

736: l_proc varchar2(72) := g_package||'lck';
737: --
738: begin
739: --
740: hr_utility.set_location('Entering:'|| l_proc, 10);
741: --
742: pqh_wdt_shd.lck
743: (
744: p_worksheet_detail_id => p_worksheet_detail_id

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

744: p_worksheet_detail_id => p_worksheet_detail_id
745: ,p_object_version_number => p_object_version_number
746: );
747: --
748: hr_utility.set_location(' Leaving:'||l_proc, 70);
749: --
750: end lck;
751: --
752: end pqh_WORKSHEET_DETAILS_api;