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.PER_PCL_SHD dependencies on HR_UTILITY

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

20: l_return_value BOOLEAN;
21: --
22: BEGIN
23: --
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: -- If the category is such that the value field
27: -- should not be populated then return false
28: --

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

29: IF p_category_name IN ('PYS','POS','PRO') THEN
30: --
31: l_return_value := TRUE;
32: --
33: hr_utility.set_location(l_proc, 20);
34: --
35: ELSE
36: --
37: l_return_value := FALSE;

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

35: ELSE
36: --
37: l_return_value := FALSE;
38: --
39: hr_utility.set_location(l_proc, 30);
40: --
41: END IF;
42: --
43: hr_utility.set_location('Leaving :'||l_proc, 999);

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

39: hr_utility.set_location(l_proc, 30);
40: --
41: END IF;
42: --
43: hr_utility.set_location('Leaving :'||l_proc, 999);
44: --
45: RETURN(l_return_value);
46: --
47: END non_value_category;

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

72: l_proc VARCHAR2(72) := g_package||'retrieve_entitlement_item_info';
73: --
74: BEGIN
75: --
76: hr_utility.set_location('Entering:'||l_proc, 10);
77: --
78: -- Check mandatory parameters has been set
79: --
80: hr_api.mandatory_arg_error

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

81: (p_api_name => l_proc
82: ,p_argument => 'CAGR_ENTITLEMENT_ID'
83: ,p_argument_value => p_cagr_entitlement_id);
84: --
85: hr_utility.set_location(l_proc, 30);
86: --
87: -- Retrieve the entitlement_item_id
88: --
89: OPEN csr_get_entitlement_item_id;

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

92: p_formula_criteria;
93: --
94: IF csr_get_entitlement_item_id%NOTFOUND THEN
95: --
96: hr_utility.set_location(l_proc, 30);
97: --
98: CLOSE csr_get_entitlement_item_id;
99: --
100: hr_utility.set_message(800, 'HR_289330_ENT_ITEM_NOT_FOUND');

Line 100: hr_utility.set_message(800, 'HR_289330_ENT_ITEM_NOT_FOUND');

96: hr_utility.set_location(l_proc, 30);
97: --
98: CLOSE csr_get_entitlement_item_id;
99: --
100: hr_utility.set_message(800, 'HR_289330_ENT_ITEM_NOT_FOUND');
101: hr_utility.raise_error;
102: --
103: END IF;
104: --

Line 101: hr_utility.raise_error;

97: --
98: CLOSE csr_get_entitlement_item_id;
99: --
100: hr_utility.set_message(800, 'HR_289330_ENT_ITEM_NOT_FOUND');
101: hr_utility.raise_error;
102: --
103: END IF;
104: --
105: hr_utility.set_location(l_proc, 40);

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

101: hr_utility.raise_error;
102: --
103: END IF;
104: --
105: hr_utility.set_location(l_proc, 40);
106: --
107: CLOSE csr_get_entitlement_item_id;
108: --
109: hr_utility.set_location('Leaving:'||l_proc, 999);

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

105: hr_utility.set_location(l_proc, 40);
106: --
107: CLOSE csr_get_entitlement_item_id;
108: --
109: hr_utility.set_location('Leaving:'||l_proc, 999);
110: --
111: END retrieve_entitlement_item_info;
112: --
113: -- ----------------------------------------------------------------------------

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

134: l_proc VARCHAR2(72) := g_package || 'retrieve_cagr_info';
135: --
136: BEGIN
137: --
138: hr_utility.set_location('Entering:'||l_proc, 10);
139: --
140: -- Check mandatory parameters has been set
141: --
142: hr_api.mandatory_arg_error

Line 154: hr_utility.set_message(800, 'HR_289345_CAGR_REC_INV');

150: IF csr_cagr_info%NOTFOUND THEN
151: --
152: CLOSE csr_cagr_info;
153: --
154: hr_utility.set_message(800, 'HR_289345_CAGR_REC_INV');
155: hr_utility.raise_error;
156: --
157: ELSE
158: --

Line 155: hr_utility.raise_error;

151: --
152: CLOSE csr_cagr_info;
153: --
154: hr_utility.set_message(800, 'HR_289345_CAGR_REC_INV');
155: hr_utility.raise_error;
156: --
157: ELSE
158: --
159: CLOSE csr_cagr_info;

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

159: CLOSE csr_cagr_info;
160: --
161: END IF;
162: --
163: hr_utility.set_location('Leaving :'||l_proc, 999);
164: --
165: END retrieve_cagr_info;
166: --
167: -- ----------------------------------------------------------------------------

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

187: AND cei.flex_value_set_id IS NOT NULL;
188: --
189: BEGIN
190: --
191: hr_utility.set_location('Entering:'||l_proc, 10);
192: --
193: -- Check mandatory parameters has been set
194: --
195: hr_api.mandatory_arg_error

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

196: (p_api_name => l_proc
197: ,p_argument => 'CAGR_ENTITLEMENT_ITEM_ID'
198: ,p_argument_value => p_cagr_entitlement_item_id);
199: --
200: hr_utility.set_location(l_proc, 20);
201: --
202: OPEN csr_get_value_set_id;
203: FETCH csr_get_value_set_id INTO l_flex_value_set_id;
204: --

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

201: --
202: OPEN csr_get_value_set_id;
203: FETCH csr_get_value_set_id INTO l_flex_value_set_id;
204: --
205: hr_utility.set_location(l_proc, 30);
206: --
207: CLOSE csr_get_value_set_id;
208: --
209: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 209: hr_utility.set_location('Leaving:'||l_proc, 10);

205: hr_utility.set_location(l_proc, 30);
206: --
207: CLOSE csr_get_value_set_id;
208: --
209: hr_utility.set_location('Leaving:'||l_proc, 10);
210: --
211: RETURN(l_flex_value_set_id);
212: --
213: END retrieve_value_set_id;

Line 351: hr_utility.set_location('Entering:'||l_proc, 5);

347: --
348: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: -- Call the corresponding datetrack api
354: --
355: dt_api.find_dt_upd_modes

Line 366: hr_utility.set_location(' Leaving:'||l_proc, 10);

362: ,p_update_override => p_update_override
363: ,p_update_change_insert => p_update_change_insert
364: );
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: End find_dt_upd_modes;
368: --
369: -- ----------------------------------------------------------------------------
370: -- |---------------------------< find_dt_del_modes >--------------------------|

Line 400: hr_utility.set_location('Entering:'||l_proc, 5);

396: and p_effective_date
397: between t.effective_start_date and t.effective_end_date;
398: --
399: Begin
400: hr_utility.set_location('Entering:'||l_proc, 5);
401: Open C_sel1;
402: Fetch C_Sel1 Into
403: l_parent_key_value1
404: ,l_parent_key_value2

Line 441: hr_utility.set_location(' Leaving:'||l_proc, 10);

437: ,p_future_change => p_future_change
438: ,p_delete_next_change => p_delete_next_change
439: );
440: --
441: hr_utility.set_location(' Leaving:'||l_proc, 10);
442: End find_dt_del_modes;
443: --
444: -- ----------------------------------------------------------------------------
445: -- |-----------------------< upd_effective_end_date >-------------------------|

Line 460: hr_utility.set_location('Entering:'||l_proc, 5);

456: l_proc varchar2(72) := g_package||'upd_effective_end_date';
457: l_object_version_number number;
458: --
459: Begin
460: hr_utility.set_location('Entering:'||l_proc, 5);
461: --
462: -- Because we are updating a row we must get the next object
463: -- version number.
464: --

Line 472: hr_utility.set_location(l_proc, 10);

468: ,p_base_key_column => 'cagr_entitlement_line_id'
469: ,p_base_key_value => p_base_key_value
470: );
471: --
472: hr_utility.set_location(l_proc, 10);
473: --
474: --
475: -- Update the specified datetrack row setting the effective
476: -- end date to the specified new effective end date.

Line 487: hr_utility.set_location(' Leaving:'||l_proc, 15);

483: between t.effective_start_date and t.effective_end_date;
484: --
485: --
486: p_object_version_number := l_object_version_number;
487: hr_utility.set_location(' Leaving:'||l_proc, 15);
488: --
489: End upd_effective_end_date;
490: --
491: -- ----------------------------------------------------------------------------

Line 539: hr_utility.set_location('Entering:'||l_proc, 5);

535: --
536: --
537: --
538: Begin
539: hr_utility.set_location('Entering:'||l_proc, 5);
540: --
541: -- Ensure that all the mandatory arguments are not null
542: --
543: hr_api.mandatory_arg_error(p_api_name => l_proc

Line 629: hr_utility.set_location(' Leaving:'||l_proc, 30);

625: --
626: p_validation_start_date := l_validation_start_date;
627: p_validation_end_date := l_validation_end_date;
628: --
629: hr_utility.set_location(' Leaving:'||l_proc, 30);
630: --
631: -- We need to trap the ORA LOCK exception
632: --
633: Exception