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 409: hr_utility.set_location('Entering:'|| l_proc, 10);

405: -- Bug 3795968 Ends Here
406: --
407: BEGIN
408: --
409: hr_utility.set_location('Entering:'|| l_proc, 10);
410: --
411: -- Issue a savepoint if operating in validation only mode
412: --
413: SAVEPOINT update_rate;

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

417: -- Process Logic
418: --
419: l_object_version_number := p_object_version_number;
420: --
421: hr_utility.set_location(l_proc, 20);
422: --
423: BEGIN
424: --
425: -- Start of API User Hook for the before hook of update_rate

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

465: -- End of API User Hook for the before hook of update_rate
466: --
467: END;
468: --
469: hr_utility.set_location(l_proc, 30);
470:
471: -- Start changes for bug 9328526
472:
473: if nvl(p_called_from,'API') <> 'GSPW' then

Line 479: hr_utility.set_location(l_proc, 35);

475: p_rate_id => p_rate_id
476: ,p_entity => 'RATE');
477: end if;
478:
479: hr_utility.set_location(l_proc, 35);
480:
481: -- End changes for bug 9328526
482: --
483: pay_pyr_upd.upd

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

511: ,p_attribute18 => p_attribute18
512: ,p_attribute19 => p_attribute19
513: ,p_attribute20 => p_attribute20);
514: --
515: hr_utility.set_location(l_proc, 40);
516: --
517: -- Start of fix 3273216
518: -- calling database package to first delete the existing database item
519: -- and then call the database package to insert the updated database item

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

526: END IF;
527: CLOSE csr_full_hr_installed;
528: -- Bug 3795968 Ends Here
529: --
530: hr_utility.set_location(l_proc, 45);
531: --
532: -- End of 3273216
533: BEGIN
534: --

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

575: -- End of API User Hook for the after hook of update_rate
576: --
577: END;
578: --
579: hr_utility.set_location(l_proc, 50);
580: --
581: -- When in validation only mode raise the Validate_Enabled exception
582: --
583: IF p_validate THEN

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

589: -- Set all output arguments
590: --
591: p_object_version_number := l_object_version_number;
592: --
593: hr_utility.set_location(' Leaving:'||l_proc, 999);
594: --
595: EXCEPTION
596: --
597: WHEN hr_api.validate_enabled THEN

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

604: -- Only set output warning arguments
605: -- (Any key or derived arguments must be set to null
606: -- when validation only mode is being used.)
607: --
608: hr_utility.set_location(' Leaving:'||l_proc, 998);
609: --
610: WHEN others THEN
611: --
612: -- A validation or unexpected error has occured

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

676: -- Bug 3795968 Ends Here
677: --
678: BEGIN
679: --
680: hr_utility.set_location('Entering:'|| l_proc, 10);
681: --
682: -- Issue a savepoint if operating in validation only mode
683: --
684: SAVEPOINT delete_rate;

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

682: -- Issue a savepoint if operating in validation only mode
683: --
684: SAVEPOINT delete_rate;
685: --
686: hr_utility.set_location(l_proc, 20);
687: --
688: l_effective_date := TRUNC(p_effective_date);
689: --
690: -- Process Logic

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

712: -- End of API User Hook for the before hook of delete_rate
713: --
714: END;
715: --
716: hr_utility.set_location( l_proc, 30);
717: --
718: --
719: -- Process Logic
720: -- =============

Line 731: hr_utility.set_location(l_proc, 35);

727: p_rate_id => p_rate_id
728: ,p_entity => 'RATE');
729: End if;
730:
731: hr_utility.set_location(l_proc, 35);
732:
733: -- End changes for bug 9328526
734:
735: pay_pyr_shd.lck(p_rate_id => p_rate_id

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

734:
735: pay_pyr_shd.lck(p_rate_id => p_rate_id
736: ,p_object_version_number => p_object_version_number);
737: --
738: hr_utility.set_location( l_proc, 40);
739: --
740: pay_pyr_del.del(p_rate_id => p_rate_id
741: ,p_rate_type => p_rate_type
742: ,p_object_version_number => p_object_version_number);

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

740: pay_pyr_del.del(p_rate_id => p_rate_id
741: ,p_rate_type => p_rate_type
742: ,p_object_version_number => p_object_version_number);
743: --
744: hr_utility.set_location( l_proc, 50);
745: --
746: -- Start of fix 3273216
747: -- calling database package to delete database item
748: -- Bug 3795968 Starts Here

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

753: END IF;
754: CLOSE csr_full_hr_installed;
755: -- Bug 3795968 Ends Here
756: --
757: hr_utility.set_location( l_proc, 55);
758: --
759: -- End of 3273216
760: --
761: BEGIN

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

779: -- End of API User Hook for the after hook of delete_rate
780: --
781: END;
782: --
783: hr_utility.set_location(l_proc, 60);
784: --
785: -- When in validation only mode raise the Validate_Enabled exception
786: --
787: IF p_validate THEN

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

789: RAISE hr_api.validate_enabled;
790: --
791: END IF;
792: --
793: hr_utility.set_location(' Leaving:'||l_proc, 999);
794: --
795: EXCEPTION
796: --
797: WHEN hr_api.validate_enabled THEN

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

862: l_default_rate_uom pay_rates.rate_uom%TYPE;
863: --
864: BEGIN
865: --
866: hr_utility.set_location('Entering:'|| l_proc, 10);
867: --
868: -- Issue a savepoint if operating in validation only mode
869: --
870: SAVEPOINT create_assignment_rate;

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

868: -- Issue a savepoint if operating in validation only mode
869: --
870: SAVEPOINT create_assignment_rate;
871: --
872: hr_utility.set_location(l_proc, 20);
873: --
874: l_effective_date := TRUNC(p_effective_date);
875: --
876: -- Set the rate type to be Assignment

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

926: -- End of API User Hook for the before hook of create_assignment_rate
927: --
928: END;
929: --
930: hr_utility.set_location(l_proc, 30);
931: --
932: hr_rate_api.create_rate
933: (p_effective_date => l_effective_date
934: ,p_business_group_id => p_business_group_id

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

960: ,p_asg_rate_type => p_asg_rate_type
961: ,p_rate_id => l_rate_id
962: ,p_object_version_number => l_object_version_number);
963: --
964: hr_utility.set_location(l_proc, 40);
965: --
966: BEGIN
967: --
968: -- Start of API User Hook for the after hook of create_assignment_rate

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

1008: -- End of API User Hook for the after hook of create_assignment_rate
1009: --
1010: END;
1011: --
1012: hr_utility.set_location(l_proc, 50);
1013: --
1014: -- When in validation only mode raise the Validate_Enabled exception
1015: --
1016: IF p_validate THEN

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

1023: --
1024: p_object_version_number := l_object_version_number;
1025: p_rate_id := l_rate_id;
1026: --
1027: hr_utility.set_location(' Leaving:'||l_proc, 999);
1028: --
1029: EXCEPTION
1030: --
1031: WHEN hr_api.validate_enabled THEN

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

1040: -- when validation only mode is being used.)
1041: --
1042: p_object_version_number := NULL;
1043: --
1044: hr_utility.set_location(' Leaving:'||l_proc, 998);
1045: --
1046: WHEN others THEN
1047: --
1048: -- A validation or unexpected error has occured

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

1100: l_effective_date DATE;
1101: --
1102: BEGIN
1103: --
1104: hr_utility.set_location('Entering:'|| l_proc, 10);
1105: --
1106: -- Issue a savepoint if operating in validation only mode
1107: --
1108: SAVEPOINT update_assignment_rate;

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

1112: -- Process Logic
1113: --
1114: l_object_version_number := p_object_version_number;
1115: --
1116: hr_utility.set_location(l_proc, 20);
1117: --
1118: BEGIN
1119: --
1120: -- Start of API User Hook for the before hook of update_assignment_rate

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

1157: -- End of API User Hook for the before hook of update_assignment_rate
1158: --
1159: END;
1160: --
1161: hr_utility.set_location(l_proc, 30);
1162: --
1163: hr_rate_api.update_rate
1164: (p_effective_date => l_effective_date
1165: ,p_rate_id => p_rate_id

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

1188: ,p_attribute18 => p_attribute18
1189: ,p_attribute19 => p_attribute19
1190: ,p_attribute20 => p_attribute20);
1191: --
1192: hr_utility.set_location(l_proc, 40);
1193: --
1194: BEGIN
1195: --
1196: -- Start of API User Hook for the after hook of update_assignment_rate

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

1233: -- End of API User Hook for the after hook of update_assignment_rate
1234: --
1235: END;
1236: --
1237: hr_utility.set_location(l_proc, 50);
1238: --
1239: -- When in validation only mode raise the Validate_Enabled exception
1240: --
1241: IF p_validate THEN

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

1247: -- Set all output arguments
1248: --
1249: p_object_version_number := l_object_version_number;
1250: --
1251: hr_utility.set_location(' Leaving:'||l_proc, 999);
1252: --
1253: EXCEPTION
1254: --
1255: WHEN hr_api.validate_enabled THEN

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

1262: -- Only set output warning arguments
1263: -- (Any key or derived arguments must be set to null
1264: -- when validation only mode is being used.)
1265: --
1266: hr_utility.set_location(' Leaving:'||l_proc, 998);
1267: --
1268: WHEN others THEN
1269: --
1270: -- A validation or unexpected error has occured