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

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

37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error

Line 76: hr_utility.set_location(' Leaving:'|| l_proc, 20);

72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
76: hr_utility.set_location(' Leaving:'|| l_proc, 20);
77: --
78: end set_security_group_id;
79: --
80: -- ---------------------------------------------------------------------------

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

101: l_proc varchar2(72) := g_package||'return_legislation_code';
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error

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

119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := pqh_lvl_bus.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.

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

136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --

Line 149: hr_utility.set_location(' Leaving:'|| l_proc, 40);

145: close csr_leg_code;
146: pqh_lvl_bus.g_wrkplc_vldtn_lvlnum_id := p_wrkplc_vldtn_lvlnum_id;
147: pqh_lvl_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ----------------------------------------------------------------------------

Line 222: hr_utility.set_message(8302,'PQH_DE_LVLNUM_VALDTN_LVL');

218: Open Lvlnum;
219: Fetch Lvlnum into l_Result;
220: If Lvlnum%NOTFOUND Then
221: Close Lvlnum;
222: hr_utility.set_message(8302,'PQH_DE_LVLNUM_VALDTN_LVL');
223: hr_utility.raise_error;
224: End If;
225: Close Lvlnum;
226: Exception

Line 223: hr_utility.raise_error;

219: Fetch Lvlnum into l_Result;
220: If Lvlnum%NOTFOUND Then
221: Close Lvlnum;
222: hr_utility.set_message(8302,'PQH_DE_LVLNUM_VALDTN_LVL');
223: hr_utility.raise_error;
224: End If;
225: Close Lvlnum;
226: Exception
227: when app_exception.application_exception then

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

227: when app_exception.application_exception then
228: if hr_multi_message.exception_add
229: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_LVLNUMS.LEVEL_NUMBER_ID'
230: ) then
231: hr_utility.set_location(' Leaving:'||l_proc,60);
232: raise;
233: end if;
234: hr_utility.set_location(' Leaving:'||l_proc,70);
235: End chk_Lvl_Num;

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

230: ) then
231: hr_utility.set_location(' Leaving:'||l_proc,60);
232: raise;
233: end if;
234: hr_utility.set_location(' Leaving:'||l_proc,70);
235: End chk_Lvl_Num;
236:
237: Procedure chk_Lvl_Code
238: (p_rec in pqh_lvl_shd.g_rec_type) IS

Line 254: hr_utility.set_message(8302,'PQH_DE_LVLCOD_VALDTN_LVL');

250: Open LvlCode;
251: Fetch LvlCode into l_Result;
252: If Lvlcode%NOTFOUND Then
253: Close Lvlcode;
254: hr_utility.set_message(8302,'PQH_DE_LVLCOD_VALDTN_LVL');
255: hr_utility.raise_error;
256: End If;
257: Close Lvlcode;
258: Exception

Line 255: hr_utility.raise_error;

251: Fetch LvlCode into l_Result;
252: If Lvlcode%NOTFOUND Then
253: Close Lvlcode;
254: hr_utility.set_message(8302,'PQH_DE_LVLCOD_VALDTN_LVL');
255: hr_utility.raise_error;
256: End If;
257: Close Lvlcode;
258: Exception
259: when app_exception.application_exception then

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

259: when app_exception.application_exception then
260: if hr_multi_message.exception_add
261: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_LVLNUMS.LEVEL_CODE_ID'
262: ) then
263: hr_utility.set_location(' Leaving:'||l_proc,60);
264: raise;
265: end if;
266: hr_utility.set_location(' Leaving:'||l_proc,70);
267: End chk_Lvl_Code;

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

262: ) then
263: hr_utility.set_location(' Leaving:'||l_proc,60);
264: raise;
265: end if;
266: hr_utility.set_location(' Leaving:'||l_proc,70);
267: End chk_Lvl_Code;
268: --
269: -- ----------------------------------------------------------------------------
270: -- |---------------------------< insert_validate >----------------------------|

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

276: --
277: l_proc varchar2(72) := g_package||'insert_validate';
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: -- Call all supporting business operations
283: --
284: hr_api.validate_bus_grp_id

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

297: chk_Lvl_Num(p_Rec.Level_Number_Id);
298:
299: chk_Lvl_Code(p_rec);
300: --
301: hr_utility.set_location(' Leaving:'||l_proc, 10);
302: End insert_validate;
303: --
304: -- ----------------------------------------------------------------------------
305: -- |---------------------------< update_validate >----------------------------|

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

311: --
312: l_proc varchar2(72) := g_package||'update_validate';
313: --
314: Begin
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: -- Call all supporting business operations
318: --
319: hr_api.validate_bus_grp_id

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

338:
339: chk_Lvl_Code(p_rec);
340: --
341: --
342: hr_utility.set_location(' Leaving:'||l_proc, 10);
343: End update_validate;
344: --
345: -- ----------------------------------------------------------------------------
346: -- |---------------------------< delete_validate >----------------------------|

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

351: --
352: l_proc varchar2(72) := g_package||'delete_validate';
353: --
354: Begin
355: hr_utility.set_location('Entering:'||l_proc, 5);
356: --
357: -- Call all supporting business operations
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

355: hr_utility.set_location('Entering:'||l_proc, 5);
356: --
357: -- Call all supporting business operations
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360: End delete_validate;
361: --
362: end pqh_lvl_bus;