DBA Data[Home] [Help]

APPS.PER_POSITION_STRUCTURE_API dependencies on HR_UTILITY

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

146: l_position_structure_id per_position_Structures.position_structure_id%TYPE;
147: l_object_version_number per_position_structures.object_version_number%TYPE;
148: --
149: BEGIN
150: hr_utility.set_location('Entering:'|| l_proc, 10);
151: --
152: -- Issue a savepoint
153: --
154: savepoint create_position_structure;

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

199:
200: --
201: --
202: --
203: hr_utility.set_location(l_proc, 20);
204: --
205: -- Process Logic
206: --
207: per_pst_ins.ins

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

238: ,p_position_structure_id =>l_position_structure_id
239: ,p_object_version_number =>l_object_version_number );
240:
241: --
242: hr_utility.set_location(l_proc, 60);
243: --
244: -- When in validation only mode raise the Validate_Enabled exception
245: --
246: IF p_validate THEN

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

251: --
252: p_position_structure_id := l_position_structure_id;
253: p_object_version_number := l_object_version_number;
254: --
255: hr_utility.set_location(' Leaving:'||l_proc, 70);
256: --
257:
258:
259:

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

316: -- when validation only mode is being used.)
317: --
318: p_position_structure_id := NULL;
319: p_object_version_number := NULL;
320: hr_utility.set_location(' Leaving:'||l_proc, 80);
321: WHEN OTHERS THEN
322: --
323: -- A validation or unexpected error has occurred
324: p_position_structure_id := NULL;

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

323: -- A validation or unexpected error has occurred
324: p_position_structure_id := NULL;
325: p_object_version_number := NULL;
326: ROLLBACK TO create_position_structure;
327: hr_utility.set_location(' Leaving:'||l_proc, 90);
328: RAISE;
329: --
330: END create_position_structure;
331:

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

427: ,p_hook_type => 'BP'
428: );
429: end;
430: --
431: hr_utility.set_location('Entering:'|| l_proc, 10);
432: --
433: --
434: hr_utility.set_location(l_proc, 20);
435: --

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

430: --
431: hr_utility.set_location('Entering:'|| l_proc, 10);
432: --
433: --
434: hr_utility.set_location(l_proc, 20);
435: --
436: --
437: -- Process Logic
438: --

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

477: --
478: --
479: --
480: --
481: hr_utility.set_location(l_proc, 60);
482: --
483: -- When in validation only mode raise the Validate_Enabled exception
484: --
485: IF p_validate THEN

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

490: -- never reached, so p_object_version_number is passed back unchanged.
491: --
492: p_object_version_number := l_object_version_number;
493: --
494: hr_utility.set_location(' Leaving:'||l_proc, 70);
495: --
496:
497: begin
498: per_pos_structure_bk2.update_pos_structure_a

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

549: --
550: -- Only set output warning arguments
551: -- (Any key or derived arguments must be set to null
552: -- when validation only mode is being used.)
553: hr_utility.set_location(' Leaving:'||l_proc, 80);
554: WHEN OTHERS THEN
555: --
556: -- A validation or unexpected error has occurred
557: p_object_version_number := l_temp_ovn;

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

555: --
556: -- A validation or unexpected error has occurred
557: p_object_version_number := l_temp_ovn;
558: ROLLBACK TO update_position_structure;
559: hr_utility.set_location(' Leaving:'||l_proc, 90);
560: RAISE;
561: --
562: --
563: END update_position_structure;

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

605: -- =============
606: --
607: -- Need to lock main table to maintain the locking ladder order
608: --
609: hr_utility.set_location( l_proc, 30);
610: per_pst_shd.lck ( p_position_structure_id => p_position_structure_id,
611: p_object_version_number => p_object_version_number );
612: hr_utility.set_location( l_proc, 40);
613: per_pst_del.del ( p_position_structure_id => p_position_structure_id,

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

608: --
609: hr_utility.set_location( l_proc, 30);
610: per_pst_shd.lck ( p_position_structure_id => p_position_structure_id,
611: p_object_version_number => p_object_version_number );
612: hr_utility.set_location( l_proc, 40);
613: per_pst_del.del ( p_position_structure_id => p_position_structure_id,
614: p_object_version_number => p_object_version_number );
615: --
616: --

Line 617: hr_utility.set_location(' Leaving:'||l_proc, 60);

613: per_pst_del.del ( p_position_structure_id => p_position_structure_id,
614: p_object_version_number => p_object_version_number );
615: --
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 60);
618: --
619: -- When in validation only mode raise the Validate_Enabled exception
620: --
621: IF p_validate THEN

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

651: -- Only set output warning arguments
652: -- (Any key or derived arguments must be set to null
653: -- when validation only mode is being used.)
654: --
655: hr_utility.set_location(' Leaving:'||l_proc, 80);
656: WHEN OTHERS THEN
657: --
658: -- A validation or unexpected error has occurred
659: ROLLBACK TO delete_position_structure;

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

656: WHEN OTHERS THEN
657: --
658: -- A validation or unexpected error has occurred
659: ROLLBACK TO delete_position_structure;
660: hr_utility.set_location(' Leaving:'||l_proc, 90);
661: RAISE;
662: --
663: END delete_position_structure;
664: --