DBA Data[Home] [Help]

APPS.HR_RATE_API dependencies on HR_UTILITY

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

61: -- Bug 3795968 Ends Here
62: --
63: BEGIN
64: --
65: hr_utility.set_location('Entering:'|| l_proc, 10);
66: --
67: -- Issue a savepoint if operating in validation only mode
68: --
69: SAVEPOINT create_rate;

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

67: -- Issue a savepoint if operating in validation only mode
68: --
69: SAVEPOINT create_rate;
70: --
71: hr_utility.set_location(l_proc, 20);
72: --
73: l_effective_date := TRUNC(p_effective_date);
74: --
75: -- Process Logic

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

119: -- End of API User Hook for the before hook of create_rate
120: --
121: END;
122: --
123: hr_utility.set_location(l_proc, 30);
124: --
125: pay_pyr_ins.ins
126: (p_effective_date => l_effective_date
127: ,p_business_group_id => p_business_group_id

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

155: ,p_asg_rate_type => p_asg_rate_type
156: ,p_rate_id => l_rate_id
157: ,p_object_version_number => l_object_version_number);
158: --
159: hr_utility.set_location(l_proc, 40);
160: --
161: --
162: -- Start of fix 3273216
163: -- calling database package to insert database item

Line 173: hr_utility.set_location(l_proc, 45);

169: END IF;
170: CLOSE csr_full_hr_installed;
171: -- Bug 3795968 Ends Here
172: --
173: hr_utility.set_location(l_proc, 45);
174: --
175: -- End of 3273216
176: BEGIN
177: --

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

220: -- End of API User Hook for the after hook of create_rate
221: --
222: END;
223: --
224: hr_utility.set_location(l_proc, 50);
225: --
226: -- When in validation only mode raise the Validate_Enabled exception
227: --
228: IF p_validate THEN

Line 239: hr_utility.set_location(' Leaving:'||l_proc, 999);

235: --
236: p_object_version_number := l_object_version_number;
237: p_rate_id := l_rate_id;
238: --
239: hr_utility.set_location(' Leaving:'||l_proc, 999);
240: --
241: EXCEPTION
242: --
243: WHEN hr_api.validate_enabled THEN

Line 256: hr_utility.set_location(' Leaving:'||l_proc, 998);

252: -- when validation only mode is being used.)
253: --
254: p_object_version_number := NULL;
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 998);
257: --
258: WHEN others THEN
259: --
260: -- A validation or unexpected error has occured

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

324: -- Bug 3795968 Ends Here
325: --
326: BEGIN
327: --
328: hr_utility.set_location('Entering:'|| l_proc, 10);
329: --
330: -- Issue a savepoint if operating in validation only mode
331: --
332: SAVEPOINT update_rate;

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

336: -- Process Logic
337: --
338: l_object_version_number := p_object_version_number;
339: --
340: hr_utility.set_location(l_proc, 20);
341: --
342: BEGIN
343: --
344: -- Start of API User Hook for the before hook of update_rate

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

384: -- End of API User Hook for the before hook of update_rate
385: --
386: END;
387: --
388: hr_utility.set_location(l_proc, 30);
389: --
390: pay_pyr_upd.upd
391: (p_effective_date => l_effective_date
392: ,p_rate_id => p_rate_id

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

418: ,p_attribute18 => p_attribute18
419: ,p_attribute19 => p_attribute19
420: ,p_attribute20 => p_attribute20);
421: --
422: hr_utility.set_location(l_proc, 40);
423: --
424: -- Start of fix 3273216
425: -- calling database package to first delete the existing database item
426: -- and then call the database package to insert the updated database item

Line 437: hr_utility.set_location(l_proc, 45);

433: END IF;
434: CLOSE csr_full_hr_installed;
435: -- Bug 3795968 Ends Here
436: --
437: hr_utility.set_location(l_proc, 45);
438: --
439: -- End of 3273216
440: BEGIN
441: --

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

482: -- End of API User Hook for the after hook of update_rate
483: --
484: END;
485: --
486: hr_utility.set_location(l_proc, 50);
487: --
488: -- When in validation only mode raise the Validate_Enabled exception
489: --
490: IF p_validate THEN

Line 500: hr_utility.set_location(' Leaving:'||l_proc, 999);

496: -- Set all output arguments
497: --
498: p_object_version_number := l_object_version_number;
499: --
500: hr_utility.set_location(' Leaving:'||l_proc, 999);
501: --
502: EXCEPTION
503: --
504: WHEN hr_api.validate_enabled THEN

Line 515: hr_utility.set_location(' Leaving:'||l_proc, 998);

511: -- Only set output warning arguments
512: -- (Any key or derived arguments must be set to null
513: -- when validation only mode is being used.)
514: --
515: hr_utility.set_location(' Leaving:'||l_proc, 998);
516: --
517: WHEN others THEN
518: --
519: -- A validation or unexpected error has occured

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

556: -- Bug 3795968 Ends Here
557: --
558: BEGIN
559: --
560: hr_utility.set_location('Entering:'|| l_proc, 10);
561: --
562: -- Issue a savepoint if operating in validation only mode
563: --
564: SAVEPOINT delete_rate;

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

562: -- Issue a savepoint if operating in validation only mode
563: --
564: SAVEPOINT delete_rate;
565: --
566: hr_utility.set_location(l_proc, 20);
567: --
568: l_effective_date := TRUNC(p_effective_date);
569: --
570: -- Process Logic

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

592: -- End of API User Hook for the before hook of delete_rate
593: --
594: END;
595: --
596: hr_utility.set_location( l_proc, 30);
597: --
598: --
599: -- Process Logic
600: -- =============

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

603: --
604: pay_pyr_shd.lck(p_rate_id => p_rate_id
605: ,p_object_version_number => p_object_version_number);
606: --
607: hr_utility.set_location( l_proc, 40);
608: --
609: pay_pyr_del.del(p_rate_id => p_rate_id
610: ,p_rate_type => p_rate_type
611: ,p_object_version_number => p_object_version_number);

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

609: pay_pyr_del.del(p_rate_id => p_rate_id
610: ,p_rate_type => p_rate_type
611: ,p_object_version_number => p_object_version_number);
612: --
613: hr_utility.set_location( l_proc, 50);
614: --
615: -- Start of fix 3273216
616: -- calling database package to delete database item
617: -- Bug 3795968 Starts Here

Line 626: hr_utility.set_location( l_proc, 55);

622: END IF;
623: CLOSE csr_full_hr_installed;
624: -- Bug 3795968 Ends Here
625: --
626: hr_utility.set_location( l_proc, 55);
627: --
628: -- End of 3273216
629: --
630: BEGIN

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

648: -- End of API User Hook for the after hook of delete_rate
649: --
650: END;
651: --
652: hr_utility.set_location(l_proc, 60);
653: --
654: -- When in validation only mode raise the Validate_Enabled exception
655: --
656: IF p_validate THEN

Line 662: hr_utility.set_location(' Leaving:'||l_proc, 999);

658: RAISE hr_api.validate_enabled;
659: --
660: END IF;
661: --
662: hr_utility.set_location(' Leaving:'||l_proc, 999);
663: --
664: EXCEPTION
665: --
666: WHEN hr_api.validate_enabled THEN

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

731: l_default_rate_uom pay_rates.rate_uom%TYPE;
732: --
733: BEGIN
734: --
735: hr_utility.set_location('Entering:'|| l_proc, 10);
736: --
737: -- Issue a savepoint if operating in validation only mode
738: --
739: SAVEPOINT create_assignment_rate;

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

737: -- Issue a savepoint if operating in validation only mode
738: --
739: SAVEPOINT create_assignment_rate;
740: --
741: hr_utility.set_location(l_proc, 20);
742: --
743: l_effective_date := TRUNC(p_effective_date);
744: --
745: -- Set the rate type to be Assignment

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

795: -- End of API User Hook for the before hook of create_assignment_rate
796: --
797: END;
798: --
799: hr_utility.set_location(l_proc, 30);
800: --
801: hr_rate_api.create_rate
802: (p_effective_date => l_effective_date
803: ,p_business_group_id => p_business_group_id

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

829: ,p_asg_rate_type => p_asg_rate_type
830: ,p_rate_id => l_rate_id
831: ,p_object_version_number => l_object_version_number);
832: --
833: hr_utility.set_location(l_proc, 40);
834: --
835: BEGIN
836: --
837: -- Start of API User Hook for the after hook of create_assignment_rate

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

877: -- End of API User Hook for the after hook of create_assignment_rate
878: --
879: END;
880: --
881: hr_utility.set_location(l_proc, 50);
882: --
883: -- When in validation only mode raise the Validate_Enabled exception
884: --
885: IF p_validate THEN

Line 896: hr_utility.set_location(' Leaving:'||l_proc, 999);

892: --
893: p_object_version_number := l_object_version_number;
894: p_rate_id := l_rate_id;
895: --
896: hr_utility.set_location(' Leaving:'||l_proc, 999);
897: --
898: EXCEPTION
899: --
900: WHEN hr_api.validate_enabled THEN

Line 913: hr_utility.set_location(' Leaving:'||l_proc, 998);

909: -- when validation only mode is being used.)
910: --
911: p_object_version_number := NULL;
912: --
913: hr_utility.set_location(' Leaving:'||l_proc, 998);
914: --
915: WHEN others THEN
916: --
917: -- A validation or unexpected error has occured

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

969: l_effective_date DATE;
970: --
971: BEGIN
972: --
973: hr_utility.set_location('Entering:'|| l_proc, 10);
974: --
975: -- Issue a savepoint if operating in validation only mode
976: --
977: SAVEPOINT update_assignment_rate;

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

981: -- Process Logic
982: --
983: l_object_version_number := p_object_version_number;
984: --
985: hr_utility.set_location(l_proc, 20);
986: --
987: BEGIN
988: --
989: -- Start of API User Hook for the before hook of update_assignment_rate

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

1026: -- End of API User Hook for the before hook of update_assignment_rate
1027: --
1028: END;
1029: --
1030: hr_utility.set_location(l_proc, 30);
1031: --
1032: hr_rate_api.update_rate
1033: (p_effective_date => l_effective_date
1034: ,p_rate_id => p_rate_id

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

1057: ,p_attribute18 => p_attribute18
1058: ,p_attribute19 => p_attribute19
1059: ,p_attribute20 => p_attribute20);
1060: --
1061: hr_utility.set_location(l_proc, 40);
1062: --
1063: BEGIN
1064: --
1065: -- Start of API User Hook for the after hook of update_assignment_rate

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

1102: -- End of API User Hook for the after hook of update_assignment_rate
1103: --
1104: END;
1105: --
1106: hr_utility.set_location(l_proc, 50);
1107: --
1108: -- When in validation only mode raise the Validate_Enabled exception
1109: --
1110: IF p_validate THEN

Line 1120: hr_utility.set_location(' Leaving:'||l_proc, 999);

1116: -- Set all output arguments
1117: --
1118: p_object_version_number := l_object_version_number;
1119: --
1120: hr_utility.set_location(' Leaving:'||l_proc, 999);
1121: --
1122: EXCEPTION
1123: --
1124: WHEN hr_api.validate_enabled THEN

Line 1135: hr_utility.set_location(' Leaving:'||l_proc, 998);

1131: -- Only set output warning arguments
1132: -- (Any key or derived arguments must be set to null
1133: -- when validation only mode is being used.)
1134: --
1135: hr_utility.set_location(' Leaving:'||l_proc, 998);
1136: --
1137: WHEN others THEN
1138: --
1139: -- A validation or unexpected error has occured