DBA Data[Home] [Help]

APPS.PSP_EXTERNAL_EFFORT_LINES_API dependencies on HR_UTILITY

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

55: l_object_version_number number(9);
56: l_external_effort_line_id number;
57: l_return_status boolean;
58: begin
59: hr_utility.set_location('Entering:'|| l_proc, 10);
60: --
61: -- Issue a savepoint
62: --
63: savepoint insert_external_effort_line;

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

221: p_object_version_number := l_object_version_number;
222: p_external_effort_line_id := l_external_effort_line_id;
223: p_return_status := l_return_status;
224:
225: hr_utility.set_location(' Leaving:'||l_proc, 70);
226: exception
227: when hr_api.validate_enabled then
228: --
229: -- As the Validate_Enabled exception has been raised

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

237: --
238: p_object_version_number := null;
239: p_external_effort_line_id := null;
240: p_return_status := l_return_status;
241: hr_utility.set_location(' Leaving:'||l_proc, 80);
242: when others then
243: --
244: -- A validation or unexpected error has occured
245: --

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

250: --
251: p_object_version_number := null;
252: p_external_effort_line_id := null;
253: p_return_status := null;
254: hr_utility.set_location(' Leaving:'||l_proc, 90);
255: raise;
256: end insert_external_effort_line;
257:
258:

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

309: l_proc varchar2(72) := g_package||'update_external_effort_line';
310: l_object_version_number number(9);
311: l_return_status boolean;
312: begin
313: hr_utility.set_location('Entering:'|| l_proc, 10);
314: --
315: -- Issue a savepoint
316: --
317: savepoint update_external_effort_line;

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

473: -- Set all IN OUT and OUT parameters with out values
474: --
475: p_object_version_number := l_object_version_number;
476: p_return_status := l_return_status;
477: hr_utility.set_location(' Leaving:'||l_proc, 70);
478: exception
479: when hr_api.validate_enabled then
480: --
481: -- As the Validate_Enabled exception has been raised

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

488: -- when validation only mode is being used.)
489: --
490: p_object_version_number := null;
491: p_return_status := l_return_status;
492: hr_utility.set_location(' Leaving:'||l_proc, 80);
493: when others then
494: --
495: -- A validation or unexpected error has occured
496: --

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

500: -- OUT parameters, including warnings, to null
501: --
502: p_object_version_number := null;
503: p_return_status := null;
504: hr_utility.set_location(' Leaving:'||l_proc, 90);
505: raise;
506: end update_external_effort_line;
507:
508:

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

525: l_proc varchar2(72) := g_package||'delete_effort_interface_line';
526: l_object_version_number number(9);
527:
528: begin
529: hr_utility.set_location('Entering:'|| l_proc, 10);
530: --
531: -- Issue a savepoint
532: --
533: savepoint delete_external_effort_line;

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

596: --
597: -- Set all IN OUT and OUT parameters with out values
598: --
599: p_object_version_number := l_object_version_number;
600: hr_utility.set_location(' Leaving:'||l_proc, 70);
601: exception
602: when hr_api.validate_enabled then
603: --
604: -- As the Validate_Enabled exception has been raised

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

610: -- (Any key or derived arguments must be set to null
611: -- when validation only mode is being used.)
612: --
613: p_object_version_number := null;
614: hr_utility.set_location(' Leaving:'||l_proc, 80);
615: when others then
616: --
617: -- A validation or unexpected error has occured
618: --

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

621: -- Reset IN OUT parameters and set all
622: -- OUT parameters, including warnings, to null
623: --
624: p_object_version_number := null;
625: hr_utility.set_location(' Leaving:'||l_proc, 90);
626: raise;
627: end delete_external_effort_line;
628:
629: /*

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

658: AND (assignment_id= p_assignment_id OR p_assignment_id = hr_api.g_number);
659:
660:
661: begin
662: hr_utility.set_location('Entering:'|| l_proc, 10);
663: --
664: -- Issue a savepoint
665: --
666: savepoint delete_external_effort_line_batch;

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

689: -- Reset IN OUT parameters and set OUT parameters
690: -- (Any key or derived arguments must be set to null
691: -- when validation only mode is being used.)
692: --
693: hr_utility.set_location(' Leaving:'||l_proc, 80);
694: when others then
695: --
696: -- A validation or unexpected error has occured
697: --

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

700: -- Reset IN OUT parameters and set all
701: -- OUT parameters, including warnings, to null
702: --
703: p_return_status := null;
704: hr_utility.set_location(' Leaving:'||l_proc, 90);
705: raise;
706: end delete_external_effort_line_batch;
707: */
708: