DBA Data[Home] [Help]

APPS.PQP_SHP_API dependencies on HR_UTILITY

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

82: l_start_date date;
83: l_end_date date;
84:
85: begin
86: hr_utility.set_location('Entering:'|| l_proc, 10);
87: --
88: -- Issue a savepoint
89: --
90: savepoint create_service_history_period;

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

92: -- Truncate the time portion from all IN date parameters
93: --
94: l_start_date := trunc(p_start_date);
95: l_end_date := trunc(p_end_date);
96: hr_utility.set_location(l_proc, 20);
97: --
98: -- Call Before Process User Hook
99: --
100: begin

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

161: (p_module_name => 'create_service_history_period'
162: ,p_hook_type => 'BP'
163: );
164: end;
165: hr_utility.set_location(l_proc, 30);
166: --
167: -- Validation in addition to Row Handlers
168: --
169:

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

168: --
169:
170:
171:
172: hr_utility.set_location(l_proc, 40);
173: --
174: -- Process Logic
175: --
176:

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

234: ,p_shp_information19 => p_shp_information19
235: ,p_shp_information20 => p_shp_information20
236: );
237:
238: hr_utility.set_location(l_proc, 50);
239: --
240: -- Call After Process User Hook
241: --
242: begin

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

305: (p_module_name => 'create_service_history_period'
306: ,p_hook_type => 'AP'
307: );
308: end;
309: hr_utility.set_location(l_proc, 60);
310: --
311: -- When in validation only mode raise the Validate_Enabled exception
312: --
313: if p_validate then

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

318: --
319: p_service_history_period_id := l_service_history_period_id;
320: p_object_version_number := l_object_version_number;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 70);
323: exception
324: when hr_api.validate_enabled then
325: --
326: -- As the Validate_Enabled exception has been raised

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

333: -- when validation only mode is being used.)
334: --
335: p_service_history_period_id := null;
336: p_object_version_number := null;
337: hr_utility.set_location(' Leaving:'||l_proc, 80);
338: when others then
339: --
340: -- A validation or unexpected error has occured
341: --

Line 345: hr_utility.set_location(' Leaving:'||l_proc, 90);

341: --
342: rollback to create_service_history_period;
343: p_service_history_period_id := null;
344: p_object_version_number := null;
345: hr_utility.set_location(' Leaving:'||l_proc, 90);
346: raise;
347: end create_service_history_period;
348: --
349: -- ----------------------------------------------------------------------------

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

419: l_start_date date;
420: l_end_date date;
421:
422: begin
423: hr_utility.set_location('Entering:'|| l_proc, 10);
424: --
425: -- Issue a savepoint
426: --
427: savepoint update_service_history_period;

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

429: -- Truncate the time portion from all IN date parameters
430: --
431: l_start_date := trunc(p_start_date);
432: l_end_date := trunc(p_end_date);
433: hr_utility.set_location(l_proc, 20);
434: --
435: -- Call Before Process User Hook
436: --
437: begin

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

499: (p_module_name => 'update_service_history_period'
500: ,p_hook_type => 'BP'
501: );
502: end;
503: hr_utility.set_location(l_proc, 30);
504: --
505: -- Validation in addition to Row Handlers
506: --
507:

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

506: --
507:
508:
509:
510: hr_utility.set_location(l_proc, 40);
511: --
512: -- Process Logic
513: --
514: l_object_version_number := p_object_version_number;

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

572: ,p_shp_information19 => p_shp_information19
573: ,p_shp_information20 => p_shp_information20
574: );
575:
576: hr_utility.set_location(l_proc, 50);
577: --
578: -- Call After Process User Hook
579: --
580: begin

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

642: (p_module_name => 'update_service_history_period'
643: ,p_hook_type => 'AP'
644: );
645: end;
646: hr_utility.set_location(l_proc, 60);
647: --
648: -- When in validation only mode raise the Validate_Enabled exception
649: --
650: if p_validate then

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

654: -- Set all output arguments
655: --
656: p_object_version_number := l_object_version_number;
657: --
658: hr_utility.set_location(' Leaving:'||l_proc, 70);
659: exception
660: when hr_api.validate_enabled then
661: --
662: -- As the Validate_Enabled exception has been raised

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

668: -- (Any key or derived arguments must be set to null
669: -- when validation only mode is being used.)
670: --
671: p_object_version_number := null;
672: hr_utility.set_location(' Leaving:'||l_proc, 80);
673: when others then
674: --
675: -- A validation or unexpected error has occured
676: --

Line 679: hr_utility.set_location(' Leaving:'||l_proc, 90);

675: -- A validation or unexpected error has occured
676: --
677: rollback to update_service_history_period;
678: p_object_version_number := l_object_version_number;
679: hr_utility.set_location(' Leaving:'||l_proc, 90);
680: raise;
681: end update_service_history_period;
682: --
683: -- ----------------------------------------------------------------------------

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

696:
697: l_proc varchar2(72) := g_package||'delete_service_history_period';
698:
699: begin
700: hr_utility.set_location('Entering:'|| l_proc, 10);
701: --
702: -- Issue a savepoint
703: --
704: savepoint delete_service_history_period;

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

702: -- Issue a savepoint
703: --
704: savepoint delete_service_history_period;
705: --
706: hr_utility.set_location(l_proc, 20);
707: --
708: -- Call Before Process User Hook
709: --
710: begin

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

718: (p_module_name => 'delete_service_history_period'
719: ,p_hook_type => 'BP'
720: );
721: end;
722: hr_utility.set_location(l_proc, 30);
723: --
724: -- Validation in addition to Row Handlers
725: --
726:

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

725: --
726:
727:
728:
729: hr_utility.set_location(l_proc, 40);
730: --
731: -- Process Logic
732: --
733:

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

736: p_service_history_period_id => p_service_history_period_id
737: ,p_object_version_number => p_object_version_number
738: );
739:
740: hr_utility.set_location(l_proc, 50);
741: --
742: -- Call After Process User Hook
743: --
744: begin

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

752: (p_module_name => 'delete_service_history_period'
753: ,p_hook_type => 'AP'
754: );
755: end;
756: hr_utility.set_location(l_proc, 60);
757: --
758: -- When in validation only mode raise the Validate_Enabled exception
759: --
760: if p_validate then

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

763: --
764: -- Set all output arguments
765: --
766: --
767: hr_utility.set_location(' Leaving:'||l_proc, 70);
768: exception
769: when hr_api.validate_enabled then
770: --
771: -- As the Validate_Enabled exception has been raised

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

776: -- Only set output warning arguments
777: -- (Any key or derived arguments must be set to null
778: -- when validation only mode is being used.)
779: --
780: hr_utility.set_location(' Leaving:'||l_proc, 80);
781: when others then
782: --
783: -- A validation or unexpected error has occured
784: --

Line 786: hr_utility.set_location(' Leaving:'||l_proc, 90);

782: --
783: -- A validation or unexpected error has occured
784: --
785: rollback to delete_service_history_period;
786: hr_utility.set_location(' Leaving:'||l_proc, 90);
787: raise;
788: end delete_service_history_period;
789: --
790: end pqp_shp_api;