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_LCD_BUS dependencies on HR_UTILITY

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

43: l_proc varchar2(72) := g_package||'set_security_group_id';
44: --
45: begin
46: --
47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: --
49: -- Ensure that all the mandatory parameter are not null
50: --
51: hr_api.mandatory_arg_error

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

78: (p_security_group_id => l_security_group_id
79: );
80: end if;
81: --
82: hr_utility.set_location(' Leaving:'|| l_proc, 20);
83: --
84: end set_security_group_id;
85: --
86: -- ---------------------------------------------------------------------------

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

113: l_proc varchar2(72) := g_package||'return_legislation_code';
114: --
115: Begin
116: --
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: --
119: -- Ensure that all the mandatory parameter are not null
120: --
121: hr_api.mandatory_arg_error

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

131: -- call to this function. Just return the value in the global
132: -- variable.
133: --
134: l_legislation_code := pqh_lcd_bus.g_legislation_code;
135: hr_utility.set_location(l_proc, 20);
136: else
137: --
138: -- The ID is different to the last call to this function
139: -- or this is the first call to this function.

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

148: close csr_leg_code;
149: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
150: fnd_message.raise_error;
151: end if;
152: hr_utility.set_location(l_proc,30);
153: --
154: -- Set the global variables so the values are
155: -- available for the next call to this function.
156: --

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

157: close csr_leg_code;
158: pqh_lcd_bus.g_level_code_id := p_level_code_id;
159: pqh_lcd_bus.g_legislation_code := l_legislation_code;
160: end if;
161: hr_utility.set_location(' Leaving:'|| l_proc, 40);
162: return l_legislation_code;
163: end return_legislation_code;
164: --
165: -- ----------------------------------------------------------------------------

Line 219: hr_utility.set_message(8302, 'PQH_DE_NONUPD_LEVEL_CODE');

215: -- not been updated.
216: --
217: IF nvl(p_rec.level_code, hr_api.g_varchar2) <>
218: nvl(pqh_lcd_shd.g_old_rec.level_code, hr_api.g_varchar2) THEN
219: hr_utility.set_message(8302, 'PQH_DE_NONUPD_LEVEL_CODE');
220: fnd_message.raise_error;
221: END IF;
222:
223:

Line 244: hr_utility.set_message(8302, 'PQH_LVLCD_PRE_DEL');

240: Open Del;
241: Fetch Del into l_Status;
242: If Del%Found Then
243: Close Del;
244: hr_utility.set_message(8302, 'PQH_LVLCD_PRE_DEL');
245: hr_utility.raise_error;
246: End If;
247: Close Del;
248: Exception

Line 245: hr_utility.raise_error;

241: Fetch Del into l_Status;
242: If Del%Found Then
243: Close Del;
244: hr_utility.set_message(8302, 'PQH_LVLCD_PRE_DEL');
245: hr_utility.raise_error;
246: End If;
247: Close Del;
248: Exception
249: when app_exception.application_exception then

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

249: when app_exception.application_exception then
250: if hr_multi_message.exception_add
251: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_LVLNUMS.LEVEL_CODE_ID'
252: ) then
253: hr_utility.set_location(' Leaving:'||l_proc,60);
254: raise;
255: end if;
256: hr_utility.set_location(' Leaving:'||l_proc,70);
257: End Chk_Delete;

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

252: ) then
253: hr_utility.set_location(' Leaving:'||l_proc,60);
254: raise;
255: end if;
256: hr_utility.set_location(' Leaving:'||l_proc,70);
257: End Chk_Delete;
258: -- ----------------------------------------------------------------------------
259: -- |-----------------------< Chk_LEVEL_NUMBER_ID >----------------------------|
260: -- ----------------------------------------------------------------------------

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

270:
271: l_LEVEL_NUMBER_ID PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER_ID%TYPE;
272:
273: Begin
274: hr_utility.set_location(l_proc, 10);
275: Open c_LEVEL_NUMBER_ID;
276: Fetch c_LEVEL_NUMBER_ID into l_LEVEL_NUMBER_ID;
277: If c_LEVEL_NUMBER_ID%found Then
278: hr_utility.set_message(8302, 'PQH_DE_NOEXIST_LEVEL_NUMBER_ID');

Line 278: hr_utility.set_message(8302, 'PQH_DE_NOEXIST_LEVEL_NUMBER_ID');

274: hr_utility.set_location(l_proc, 10);
275: Open c_LEVEL_NUMBER_ID;
276: Fetch c_LEVEL_NUMBER_ID into l_LEVEL_NUMBER_ID;
277: If c_LEVEL_NUMBER_ID%found Then
278: hr_utility.set_message(8302, 'PQH_DE_NOEXIST_LEVEL_NUMBER_ID');
279: Close c_LEVEL_NUMBER_ID;
280: fnd_message.raise_error;
281: End If;
282: Close c_LEVEL_NUMBER_ID;

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

284: when app_exception.application_exception then
285: if hr_multi_message.exception_add
286: (p_associated_column1 => 'PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER_ID'
287: ) then
288: hr_utility.set_location(' Leaving:'||l_proc,60);
289: raise;
290: end if;
291: hr_utility.set_location(' Leaving:'||l_proc,70);
292: End Chk_LEVEL_NUMBER_ID;

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

287: ) then
288: hr_utility.set_location(' Leaving:'||l_proc,60);
289: raise;
290: end if;
291: hr_utility.set_location(' Leaving:'||l_proc,70);
292: End Chk_LEVEL_NUMBER_ID;
293: -- ----------------------------------------------------------------------------
294: -- |-----------------------< Chk_Unique_Level_Code >--------------------------|
295: -- ----------------------------------------------------------------------------

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

303: Where Level_Code = p_rec.Level_Code;
304: l_Level_Code PQH_DE_Level_Codes.Level_Code%TYPE;
305: l_proc varchar2(72) := g_package || 'Unique_Level_Code';
306: Begin
307: hr_utility.set_location(l_proc, 10);
308: Open c_Level_Code;
309: Fetch c_Level_Code into l_Level_Code;
310: If c_Level_Code%ROWCOUNT > 0 Then
311: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_Level_Code');

Line 311: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_Level_Code');

307: hr_utility.set_location(l_proc, 10);
308: Open c_Level_Code;
309: Fetch c_Level_Code into l_Level_Code;
310: If c_Level_Code%ROWCOUNT > 0 Then
311: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_Level_Code');
312: Close c_Level_Code;
313: fnd_message.raise_error;
314: End If;
315: Close c_Level_Code;

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

317: when app_exception.application_exception then
318: if hr_multi_message.exception_add
319: (p_associated_column1 => 'PQH_DE_Level_Codes.Level_Code'
320: ) then
321: hr_utility.set_location(' Leaving:'||l_proc,60);
322: raise;
323: end if;
324: hr_utility.set_location(' Leaving:'||l_proc,70);
325: End Chk_Unique_Level_Code;

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

320: ) then
321: hr_utility.set_location(' Leaving:'||l_proc,60);
322: raise;
323: end if;
324: hr_utility.set_location(' Leaving:'||l_proc,70);
325: End Chk_Unique_Level_Code;
326:
327: -- ----------------------------------------------------------------------------
328: -- |---------------------------< insert_validate >----------------------------|

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

333: --
334: l_proc varchar2(72) := g_package||'insert_validate';
335: --
336: Begin
337: hr_utility.set_location('Entering:'||l_proc, 5);
338: --
339: -- Call all supporting business operations
340: --
341: --

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

350: --
351: Chk_Unique_Level_Code (p_rec);
352: Chk_LEVEL_NUMBER_ID (p_rec);
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: End insert_validate;
356: --
357: -- ----------------------------------------------------------------------------
358: -- |---------------------------< update_validate >----------------------------|

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

363: --
364: l_proc varchar2(72) := g_package||'update_validate';
365: --
366: Begin
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: --
369: -- Call all supporting business operations
370: --
371: --

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

382: (p_rec => p_rec
383: );
384: --
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 10);
387: End update_validate;
388: --
389: -- ----------------------------------------------------------------------------
390: -- |---------------------------< delete_validate >----------------------------|

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

395: --
396: l_proc varchar2(72) := g_package||'delete_validate';
397: --
398: Begin
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: -- Call all supporting business operations
402: --
403: Chk_delete(p_rec);

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

400: --
401: -- Call all supporting business operations
402: --
403: Chk_delete(p_rec);
404: hr_utility.set_location(' Leaving:'||l_proc, 10);
405: End delete_validate;
406: --
407: end pqh_lcd_bus;