DBA Data[Home] [Help]

APPS.GHR_COMPLAINT_API dependencies on HR_UTILITY

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

180: l_complaint_id ghr_complaints2.complaint_id%TYPE;
181: l_object_version_number ghr_complaints2.object_version_number%TYPE;
182:
183: begin
184: hr_utility.set_location('Entering:'|| l_proc, 10);
185: --
186: -- Issue a savepoint
187: --
188: savepoint create_complaint;

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

185: --
186: -- Issue a savepoint
187: --
188: savepoint create_complaint;
189: hr_utility.set_location(l_proc, 20);
190: --
191: -- Truncate the time portion from all IN date parameters
192: --
193:

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

361: (p_module_name => 'Create_Complaint'
362: ,p_hook_type => 'BP'
363: );
364: end;
365: hr_utility.set_location(l_proc, 30);
366: --
367: -- Validation in addition to Row Handlers
368: --
369:

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

366: --
367: -- Validation in addition to Row Handlers
368: --
369:
370: hr_utility.set_location(l_proc, 40);
371: --
372: -- Process Logic
373: --
374: ghr_cmp_ins.ins

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

533: ,p_complaint_id => l_complaint_id
534: ,p_object_version_number => l_object_version_number
535: );
536:
537: hr_utility.set_location(l_proc, 50);
538: --
539: -- Call After Process User Hook
540: --
541: begin

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

707: (p_module_name => 'Create_Complaint'
708: ,p_hook_type => 'AP'
709: );
710: end;
711: hr_utility.set_location(l_proc, 60);
712: --
713: -- When in validation only mode raise the Validate_Enabled exception
714: --
715: if p_validate then

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

720: --
721: p_complaint_id := l_complaint_id;
722: p_object_version_number := l_object_version_number;
723: --
724: hr_utility.set_location(' Leaving:'||l_proc, 70);
725: exception
726: when hr_api.validate_enabled then
727: --
728: -- As the Validate_Enabled exception has been raised

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

735: -- when validation only mode is being used.)
736: --
737: p_complaint_id := null;
738: p_object_version_number := null;
739: hr_utility.set_location(' Leaving:'||l_proc, 80);
740: when others then
741: --
742: -- A validation or unexpected error has occured
743: --

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

744: rollback to create_complaint;
745: -- RESET In/Out Params and SET Out Params
746: p_complaint_id := null;
747: p_object_version_number := null;
748: hr_utility.set_location(' Leaving:'||l_proc, 90);
749: raise;
750: end create_complaint;
751: --
752: -- ----------------------------------------------------------------------------

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

923: l_proc varchar2(72) := g_package||'create_complaint';
924: l_object_version_number ghr_complaints2.object_version_number%TYPE;
925:
926: begin
927: hr_utility.set_location('Entering:'|| l_proc, 10);
928: --
929: -- Issue a savepoint
930: --
931: savepoint update_complaint;

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

928: --
929: -- Issue a savepoint
930: --
931: savepoint update_complaint;
932: hr_utility.set_location(l_proc, 20);
933: l_object_version_number := p_object_version_number;
934: --
935: -- Truncate the time portion from all IN date parameters
936: --

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

1107: (p_module_name => 'Update_Complaint'
1108: ,p_hook_type => 'BP'
1109: );
1110: end;
1111: hr_utility.set_location(l_proc, 30);
1112: --
1113: -- Validation in addition to Row Handlers
1114: --
1115: -- Store the original ovn in case we rollback when p_validate is true

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

1115: -- Store the original ovn in case we rollback when p_validate is true
1116: --
1117: l_object_version_number := p_object_version_number;
1118:
1119: hr_utility.set_location(l_proc, 40);
1120: --
1121: -- Process Logic
1122: --
1123: ghr_cmp_upd.upd

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

1282: ,p_attribute29 => p_attribute29
1283: ,p_attribute30 => p_attribute30
1284: );
1285:
1286: hr_utility.set_location(l_proc, 50);
1287: --
1288: -- Call After Process User Hook
1289: --
1290: begin

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

1456: (p_module_name => 'Update_Complaint'
1457: ,p_hook_type => 'AP'
1458: );
1459: end;
1460: hr_utility.set_location(l_proc, 60);
1461: --
1462: -- When in validation only mode raise the Validate_Enabled exception
1463: --
1464: if p_validate then

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

1468: -- Set all output arguments
1469: --
1470: p_object_version_number := l_object_version_number;
1471: --
1472: hr_utility.set_location(' Leaving:'||l_proc, 70);
1473: exception
1474: when hr_api.validate_enabled then
1475: --
1476: -- As the Validate_Enabled exception has been raised

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

1482: -- (Any key or derived arguments must be set to null
1483: -- when validation only mode is being used.)
1484: --
1485: l_object_version_number := p_object_version_number;
1486: hr_utility.set_location(' Leaving:'||l_proc, 80);
1487: when others then
1488: --
1489: -- A validation or unexpected error has occured
1490: --

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

1490: --
1491: rollback to update_complaint;
1492: --RESET In/Out Params and SET Out Params
1493: l_object_version_number := p_object_version_number;
1494: hr_utility.set_location(' Leaving:'||l_proc, 90);
1495: raise;
1496: end update_complaint;
1497:
1498: end ghr_complaint_api;