eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_RATE_VALUES_API dependencies on HR_UTILITY

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

50: where business_group_id = p_business_group_id;
51: --
52: BEGIN
53: --
54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --
56: -- Issue a SAVEPOINT IF operating in validation only mode
57: --
58: SAVEPOINT create_rate_value;

Line 68: hr_utility.set_location(l_proc, 12);

64: -- Default the currency code if required.
65: --
66: IF p_currency_code IS NULL THEN
67: --
68: hr_utility.set_location(l_proc, 12);
69: --
70: -- Fetch the Rate Unit Of Measure
71: --
72: OPEN csr_get_rate_uom;

Line 78: hr_utility.set_location(l_proc, 13);

74: FETCH csr_get_rate_uom INTO l_rate_uom;
75: IF csr_get_rate_uom%NOTFOUND THEN
76: CLOSE csr_get_rate_uom;
77: --
78: hr_utility.set_location(l_proc, 13);
79: --
80: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
81: hr_utility.raise_error;
82: END IF;

Line 80: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

76: CLOSE csr_get_rate_uom;
77: --
78: hr_utility.set_location(l_proc, 13);
79: --
80: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
81: hr_utility.raise_error;
82: END IF;
83: --
84: CLOSE csr_get_rate_uom;

Line 81: hr_utility.raise_error;

77: --
78: hr_utility.set_location(l_proc, 13);
79: --
80: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
81: hr_utility.raise_error;
82: END IF;
83: --
84: CLOSE csr_get_rate_uom;
85: --

Line 86: hr_utility.set_location(l_proc, 14);

82: END IF;
83: --
84: CLOSE csr_get_rate_uom;
85: --
86: hr_utility.set_location(l_proc, 14);
87: --
88: IF l_rate_uom = 'M' THEN
89: --
90: -- Get default currency code from business group.

Line 92: hr_utility.set_location(l_proc, 15);

88: IF l_rate_uom = 'M' THEN
89: --
90: -- Get default currency code from business group.
91: --
92: hr_utility.set_location(l_proc, 15);
93: --
94: OPEN csr_get_curr_code;
95: --
96: FETCH csr_get_curr_code INTO l_currency_code;

Line 100: hr_utility.set_location(l_proc, 16);

96: FETCH csr_get_curr_code INTO l_currency_code;
97: IF csr_get_curr_code%NOTFOUND THEN
98: CLOSE csr_get_curr_code;
99: --
100: hr_utility.set_location(l_proc, 16);
101: --
102: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
103: hr_utility.raise_error;
104: END IF;

Line 102: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

98: CLOSE csr_get_curr_code;
99: --
100: hr_utility.set_location(l_proc, 16);
101: --
102: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
103: hr_utility.raise_error;
104: END IF;
105: --
106: CLOSE csr_get_curr_code;

Line 103: hr_utility.raise_error;

99: --
100: hr_utility.set_location(l_proc, 16);
101: --
102: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
103: hr_utility.raise_error;
104: END IF;
105: --
106: CLOSE csr_get_curr_code;
107: --

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

117: BEGIN
118: --
119: -- Start of API User Hook for the before hook of create_rate_value
120: --
121: hr_utility.set_location(l_proc, 20);
122: --
123: hr_rate_value_bk1.create_rate_value_b
124: (p_effective_date => l_effective_date
125: ,p_business_group_id => p_business_group_Id

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

132: ,p_minimum => p_minimum
133: ,p_sequence => p_sequence
134: ,p_value => p_value);
135: --
136: hr_utility.set_location(l_proc, 30);
137: --
138: EXCEPTION
139: --
140: WHEN hr_api.cannot_find_prog_unit THEN

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

146: -- End of API User Hook for the before hook of create_rate_value
147: --
148: END;
149: --
150: hr_utility.set_location(l_proc, 40);
151: --
152: pay_pgr_ins.ins
153: (p_effective_date => l_effective_date
154: ,p_business_group_id => p_business_group_id

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

165: ,p_object_version_number => l_object_version_number
166: ,p_effective_start_date => l_effective_start_date
167: ,p_effective_end_date => l_effective_end_Date);
168: --
169: hr_utility.set_location(l_proc, 50);
170: --
171: BEGIN
172: --
173: -- Start of API User Hook for the after hook of create_rate_value

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

171: BEGIN
172: --
173: -- Start of API User Hook for the after hook of create_rate_value
174: --
175: hr_utility.set_location(l_proc, 60);
176: --
177: hr_rate_value_bk1.create_rate_value_a
178: (p_effective_date => l_effective_date
179: ,p_grade_rule_Id => l_grade_rule_id

Line 194: hr_utility.set_location(l_proc, 70);

190: ,p_minimum => p_minimum
191: ,p_sequence => p_sequence
192: ,p_value => p_value);
193: --
194: hr_utility.set_location(l_proc, 70);
195: --
196: EXCEPTION
197: ---
198: WHEN hr_api.cannot_find_prog_unit THEN

Line 208: hr_utility.set_location(l_proc, 80);

204: -- End of API User Hook for the after hook of create_rate_value
205: --
206: END;
207: --
208: hr_utility.set_location(l_proc, 80);
209: --
210: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
211: --
212: IF p_validate THEN

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

221: p_effective_start_date := l_effective_start_date;
222: p_effective_end_date := l_effective_end_date;
223: p_object_version_number := l_object_version_number;
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 999);
226: --
227: EXCEPTION
228: --
229: WHEN hr_api.validate_enabled THEN

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

241: p_effective_start_date := null;
242: p_effective_end_date := null;
243: p_object_version_number := null;
244: --
245: hr_utility.set_location(' Leaving:'||l_proc, 998);
246: --
247: WHEN others THEN
248: --
249: -- A validation or unexpected error has occured

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

287: --
288:
289: BEGIN
290: --
291: hr_utility.set_location('Entering:'|| l_proc, 10);
292: --
293: l_effective_date := TRUNC(p_effective_date);
294: --
295: -- Issue a SAVEPOINT IF operating in validation only mode

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

295: -- Issue a SAVEPOINT IF operating in validation only mode
296: --
297: SAVEPOINT update_rate_value;
298: --
299: hr_utility.set_location(l_proc, 20);
300: --
301: -- Process Logic
302: --
303: l_object_version_number := p_object_version_number;

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

329: -- End of API User Hook for the before hook of update_rate_value
330: --
331: END;
332: --
333: hr_utility.set_location(l_proc, 30);
334: --
335: pay_pgr_upd.upd
336: (p_effective_date => l_effective_date
337: ,p_datetrack_mode => p_datetrack_mode

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

375: -- End of API User Hook for the after hook of update_rate_value
376: --
377: END;
378: --
379: hr_utility.set_location(l_proc, 40);
380: --
381: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
382: --
383: IF p_validate THEN

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

391: p_object_version_number := l_object_version_number;
392: p_effective_start_date := l_effective_start_date;
393: p_effective_end_date := l_effective_end_date;
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 999);
396: --
397: EXCEPTION
398: --
399: WHEN hr_api.validate_enabled THEN

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

411: p_effective_end_date := l_effective_end_date;
412:
413: p_object_version_number := l_temp_ovn;
414: --
415: hr_utility.set_location(' Leaving:'||l_proc, 998);
416: --
417: WHEN others THEN
418: --
419: -- A validation or unexpected error has occured

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

450: l_temp_ovn number := p_object_version_number;
451: --
452: BEGIN
453: --
454: hr_utility.set_location('Entering:'|| l_proc, 10);
455: --
456: -- Issue a SAVEPOINT IF operating in validation only mode
457: --
458: SAVEPOINT delete_rate_value;

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

458: SAVEPOINT delete_rate_value;
459: --
460: l_effective_date := TRUNC(p_effective_date);
461: --
462: hr_utility.set_location(l_proc, 20);
463: --
464: -- Process Logic
465: --
466: l_object_version_number := p_object_version_number;

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

485: -- End of API User Hook for the before hook of delete_rate_value
486: --
487: END;
488: --
489: hr_utility.set_location(l_proc, 30);
490: --
491: pay_pgr_del.del
492: (p_effective_date => p_effective_date
493: ,p_datetrack_mode => p_datetrack_mode

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

519: -- End of API User Hook for the after hook of delete_entitlement_line
520: --
521: END;
522: --
523: hr_utility.set_location(l_proc, 40);
524: --
525: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
526: --
527: IF p_validate THEN

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

535: p_object_version_number := l_object_version_number;
536: p_effective_start_date := l_effective_start_date;
537: p_effective_end_date := l_effective_end_date;
538: --
539: hr_utility.set_location(' Leaving:'||l_proc, 999);
540: --
541: EXCEPTION
542: --
543: WHEN hr_api.validate_enabled THEN

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

555: p_effective_end_date := null;
556:
557: p_object_version_number := l_temp_ovn;
558: --
559: hr_utility.set_location(' Leaving:'||l_proc, 998);
560: --
561: WHEN others THEN
562: --
563: -- A validation or unexpected error has occured

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

613: where business_group_id = p_business_group_id;
614: --
615: BEGIN
616: --
617: hr_utility.set_location('Entering:'|| l_proc, 10);
618: --
619: -- Issue a SAVEPOINT IF operating in validation only mode
620: --
621: SAVEPOINT create_assignment_rate_value;

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

627: -- Default the currency code if required.
628: --
629: IF p_currency_code IS NULL THEN
630: --
631: hr_utility.set_location(l_proc, 20);
632: --
633: -- Fetch the Rate Unit Of Measure
634: --
635: OPEN csr_get_rate_uom;

Line 641: hr_utility.set_location(l_proc, 21);

637: FETCH csr_get_rate_uom INTO l_rate_uom;
638: IF csr_get_rate_uom%NOTFOUND THEN
639: CLOSE csr_get_rate_uom;
640: --
641: hr_utility.set_location(l_proc, 21);
642: --
643: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
644: hr_utility.raise_error;
645: END IF;

Line 643: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

639: CLOSE csr_get_rate_uom;
640: --
641: hr_utility.set_location(l_proc, 21);
642: --
643: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
644: hr_utility.raise_error;
645: END IF;
646: --
647: CLOSE csr_get_rate_uom;

Line 644: hr_utility.raise_error;

640: --
641: hr_utility.set_location(l_proc, 21);
642: --
643: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
644: hr_utility.raise_error;
645: END IF;
646: --
647: CLOSE csr_get_rate_uom;
648: --

Line 649: hr_utility.set_location(l_proc, 22);

645: END IF;
646: --
647: CLOSE csr_get_rate_uom;
648: --
649: hr_utility.set_location(l_proc, 22);
650: --
651: IF l_rate_uom = 'M' THEN
652: --
653: -- Get default currency code from business group.

Line 655: hr_utility.set_location(l_proc, 23);

651: IF l_rate_uom = 'M' THEN
652: --
653: -- Get default currency code from business group.
654: --
655: hr_utility.set_location(l_proc, 23);
656: --
657: OPEN csr_get_curr_code;
658: --
659: FETCH csr_get_curr_code INTO l_currency_code;

Line 663: hr_utility.set_location(l_proc, 24);

659: FETCH csr_get_curr_code INTO l_currency_code;
660: IF csr_get_curr_code%NOTFOUND THEN
661: CLOSE csr_get_curr_code;
662: --
663: hr_utility.set_location(l_proc, 24);
664: --
665: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
666: hr_utility.raise_error;
667: END IF;

Line 665: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

661: CLOSE csr_get_curr_code;
662: --
663: hr_utility.set_location(l_proc, 24);
664: --
665: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
666: hr_utility.raise_error;
667: END IF;
668: --
669: CLOSE csr_get_curr_code;

Line 666: hr_utility.raise_error;

662: --
663: hr_utility.set_location(l_proc, 24);
664: --
665: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
666: hr_utility.raise_error;
667: END IF;
668: --
669: CLOSE csr_get_curr_code;
670: --

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

681: -- Set the default rate type to be Assignment Rate
682: --
683: l_default_rate_type := 'A';
684: --
685: hr_utility.set_location(l_proc, 40);
686: --
687: hr_rate_values_api.create_rate_value
688: (p_validate => p_validate
689: ,p_effective_date => l_effective_date

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

698: ,p_effective_start_date => l_effective_start_date
699: ,p_effective_end_date => l_effective_end_date);
700:
701: --
702: hr_utility.set_location(l_proc, 50);
703: --
704: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
705: --
706: IF p_validate THEN

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

715: p_effective_start_date := l_effective_start_date;
716: p_effective_end_date := l_effective_END_date;
717: p_object_version_number := l_object_version_number;
718: --
719: hr_utility.set_location(' Leaving:'||l_proc, 999);
720: --
721: EXCEPTION
722: --
723: WHEN hr_api.validate_enabled THEN

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

735: p_effective_start_date := null;
736: p_effective_end_date := null;
737: p_object_version_number := null;
738: --
739: hr_utility.set_location(' Leaving:'||l_proc, 998);
740: --
741: WHEN others THEN
742: --
743: -- A validation or unexpected error has occured

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

778: l_temp_ovn number := p_object_version_number;
779: --
780: BEGIN
781: --
782: hr_utility.set_location('Entering:'|| l_proc, 10);
783: --
784: l_effective_date := TRUNC(p_effective_date);
785: --
786: -- Issue a SAVEPOINT IF operating in validation only mode

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

786: -- Issue a SAVEPOINT IF operating in validation only mode
787: --
788: SAVEPOINT update_assignment_rate_value;
789: --
790: hr_utility.set_location(l_proc, 20);
791: --
792: -- Process Logic
793: --
794: l_object_version_number := p_object_version_number;

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

792: -- Process Logic
793: --
794: l_object_version_number := p_object_version_number;
795: --
796: hr_utility.set_location(l_proc, 30);
797: --
798: hr_rate_values_api.update_rate_value
799: (p_validate => p_validate
800: ,p_grade_rule_id => p_grade_rule_id

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

805: ,p_object_version_number => l_object_version_number
806: ,p_effective_start_date => l_effective_start_date
807: ,p_effective_end_date => l_effective_end_date);
808: --
809: hr_utility.set_location(l_proc, 40);
810: --
811: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
812: --
813: IF p_validate THEN

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

821: p_object_version_number := l_object_version_number;
822: p_effective_start_date := l_effective_start_date;
823: p_effective_end_date := l_effective_end_date;
824: --
825: hr_utility.set_location(' Leaving:'||l_proc, 999);
826: --
827: EXCEPTION
828: --
829: WHEN hr_api.validate_enabled THEN

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

841: p_effective_end_date := l_effective_end_date;
842:
843: p_object_version_number := l_temp_ovn;
844: --
845: hr_utility.set_location(' Leaving:'||l_proc, 998);
846: --
847: WHEN others THEN
848: --
849: -- A validation or unexpected error has occured

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

876: l_validation_end_date DATE;
877: --
878: BEGIN
879: --
880: hr_utility.set_location('Entering:'|| l_proc, 10);
881: --
882: /*
883: per_dar_shd.lck
884: (p_grade_rule_id => p_grade_rule_id

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

888: ,p_validation_start_date => l_validation_start_date
889: ,p_validation_end_date => l_validation_end_date);
890: --
891: */
892: hr_utility.set_location(' Leaving:'||l_proc, 70);
893: --
894: exception
895: when others then
896: p_validation_start_date := null;