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_DEF_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_def_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_def_bus.g_wrkplc_vldtn_id := p_wrkplc_vldtn_id;
147: pqh_def_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 206: hr_utility.set_message(8302, 'PQH_DE_NONUPD_VALDTN_EMP');

202: -- EDIT_HERE: Add checks to ensure non-updateable args have
203: -- not been updated.
204: --
205: If p_rec.Employment_type <> pqh_def_shd.g_old_rec.Employment_type Then
206: hr_utility.set_message(8302, 'PQH_DE_NONUPD_VALDTN_EMP');
207: fnd_message.raise_error;
208: End If;
209:
210: If p_rec.Remuneration_Regulation <> pqh_def_shd.g_old_rec.Remuneration_Regulation Then

Line 211: hr_utility.set_message(8302, 'PQH_DE_NONUPD_VALDTN_RRN');

207: fnd_message.raise_error;
208: End If;
209:
210: If p_rec.Remuneration_Regulation <> pqh_def_shd.g_old_rec.Remuneration_Regulation Then
211: hr_utility.set_message(8302, 'PQH_DE_NONUPD_VALDTN_RRN');
212: fnd_message.raise_error;
213: End If;
214: End chk_non_updateable_args;
215: --

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

227: l_Validation_Name Pqh_De_Wrkplc_Vldtns.Validation_Name%TYPE;
228: l_proc varchar2(72) := g_package || 'Unique_Validation_Name';
229:
230: Begin
231: hr_utility.set_location(l_proc, 10);
232: Open Vldtn_Name;
233: Fetch VLdtn_Name into l_Validation_Name;
234: If Vldtn_name%fOUND Then
235: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_VALDTN_DEF');

Line 235: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_VALDTN_DEF');

231: hr_utility.set_location(l_proc, 10);
232: Open Vldtn_Name;
233: Fetch VLdtn_Name into l_Validation_Name;
234: If Vldtn_name%fOUND Then
235: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_VALDTN_DEF');
236: Close Vldtn_Name;
237: fnd_message.raise_error;
238: End If;
239: Close Vldtn_Name;

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

241: when app_exception.application_exception then
242: if hr_multi_message.exception_add
243: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.Validation_Name'
244: ) then
245: hr_utility.set_location(' Leaving:'||l_proc,60);
246: raise;
247: end if;
248: hr_utility.set_location(' Leaving:'||l_proc,70);
249: End Chk_Unique_Validation_Name;

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

244: ) then
245: hr_utility.set_location(' Leaving:'||l_proc,60);
246: raise;
247: end if;
248: hr_utility.set_location(' Leaving:'||l_proc,70);
249: End Chk_Unique_Validation_Name;
250:
251: Procedure Ckh_Emp_Type
252: (p_rec in pqh_def_shd.g_rec_type) is

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

252: (p_rec in pqh_def_shd.g_rec_type) is
253: --
254: l_proc varchar2(72) := g_package||'Ckh_Emp_Type';
255: Begin
256: hr_utility.set_location(l_proc, 10);
257: If p_rec.Employment_type Not in ('WC','BC','BE') Then
258: hr_utility.set_message(8302, 'PQH_DE_EMPTYP_VALDTN_DEF');
259: hr_utility.raise_error;
260: End If;

Line 258: hr_utility.set_message(8302, 'PQH_DE_EMPTYP_VALDTN_DEF');

254: l_proc varchar2(72) := g_package||'Ckh_Emp_Type';
255: Begin
256: hr_utility.set_location(l_proc, 10);
257: If p_rec.Employment_type Not in ('WC','BC','BE') Then
258: hr_utility.set_message(8302, 'PQH_DE_EMPTYP_VALDTN_DEF');
259: hr_utility.raise_error;
260: End If;
261: Exception
262: when app_exception.application_exception then

Line 259: hr_utility.raise_error;

255: Begin
256: hr_utility.set_location(l_proc, 10);
257: If p_rec.Employment_type Not in ('WC','BC','BE') Then
258: hr_utility.set_message(8302, 'PQH_DE_EMPTYP_VALDTN_DEF');
259: hr_utility.raise_error;
260: End If;
261: Exception
262: when app_exception.application_exception then
263: if hr_multi_message.exception_add

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

262: when app_exception.application_exception then
263: if hr_multi_message.exception_add
264: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.Employment_Type'
265: ) then
266: hr_utility.set_location(' Leaving:'||l_proc,60);
267: raise;
268: end if;
269: hr_utility.set_location(' Leaving:'||l_proc,70);
270: End Ckh_Emp_Type;

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

265: ) then
266: hr_utility.set_location(' Leaving:'||l_proc,60);
267: raise;
268: end if;
269: hr_utility.set_location(' Leaving:'||l_proc,70);
270: End Ckh_Emp_Type;
271:
272: Procedure Ckh_Remuneration
273: (p_rec in pqh_def_shd.g_rec_type) is

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

273: (p_rec in pqh_def_shd.g_rec_type) is
274: --
275: l_proc varchar2(72) := g_package||'Ckh_Emp_Type';
276: Begin
277: hr_utility.set_location(l_proc, 10);
278: If nvl(p_rec.REMUNERATION_REGULATION ,'XX') Not in ('CP','AP') Then
279: hr_utility.set_message(8302, 'PQH_DE_REMRGU_VALDTN_DEF');
280: hr_utility.raise_error;
281: End If;

Line 279: hr_utility.set_message(8302, 'PQH_DE_REMRGU_VALDTN_DEF');

275: l_proc varchar2(72) := g_package||'Ckh_Emp_Type';
276: Begin
277: hr_utility.set_location(l_proc, 10);
278: If nvl(p_rec.REMUNERATION_REGULATION ,'XX') Not in ('CP','AP') Then
279: hr_utility.set_message(8302, 'PQH_DE_REMRGU_VALDTN_DEF');
280: hr_utility.raise_error;
281: End If;
282: Exception
283: when app_exception.application_exception then

Line 280: hr_utility.raise_error;

276: Begin
277: hr_utility.set_location(l_proc, 10);
278: If nvl(p_rec.REMUNERATION_REGULATION ,'XX') Not in ('CP','AP') Then
279: hr_utility.set_message(8302, 'PQH_DE_REMRGU_VALDTN_DEF');
280: hr_utility.raise_error;
281: End If;
282: Exception
283: when app_exception.application_exception then
284: if hr_multi_message.exception_add

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

282: Exception
283: when app_exception.application_exception then
284: if hr_multi_message.exception_add
285: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.REMUNERATION_REGULATION') then
286: hr_utility.set_location(' Leaving:'||l_proc,60);
287: raise;
288: end if;
289: hr_utility.set_location(' Leaving:'||l_proc,70);
290: End Ckh_Remuneration;

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

285: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.REMUNERATION_REGULATION') then
286: hr_utility.set_location(' Leaving:'||l_proc,60);
287: raise;
288: end if;
289: hr_utility.set_location(' Leaving:'||l_proc,70);
290: End Ckh_Remuneration;
291:
292: Procedure Chk_delete
293: (p_rec in pqh_def_shd.g_rec_type) is

Line 307: hr_utility.set_message(8302, 'PQH_WRKVLD_PRE_DEL');

303: Open Del;
304: Fetch Del into l_Status;
305: If Del%Found Then
306: Close Del;
307: hr_utility.set_message(8302, 'PQH_WRKVLD_PRE_DEL');
308: hr_utility.raise_error;
309: End If;
310: Close Del;
311: Exception

Line 308: hr_utility.raise_error;

304: Fetch Del into l_Status;
305: If Del%Found Then
306: Close Del;
307: hr_utility.set_message(8302, 'PQH_WRKVLD_PRE_DEL');
308: hr_utility.raise_error;
309: End If;
310: Close Del;
311: Exception
312: when app_exception.application_exception then

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

312: when app_exception.application_exception then
313: if hr_multi_message.exception_add
314: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.WRKPLC_VLDTN_ID'
315: ) then
316: hr_utility.set_location(' Leaving:'||l_proc,60);
317: raise;
318: end if;
319: hr_utility.set_location(' Leaving:'||l_proc,70);
320: End Chk_Delete;

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

315: ) then
316: hr_utility.set_location(' Leaving:'||l_proc,60);
317: raise;
318: end if;
319: hr_utility.set_location(' Leaving:'||l_proc,70);
320: End Chk_Delete;
321:
322: -- ----------------------------------------------------------------------------
323: -- |---------------------------< insert_validate >----------------------------|

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

329: --
330: l_proc varchar2(72) := g_package||'insert_validate';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: -- Call all supporting business operations
336: --
337: hr_api.validate_bus_grp_id

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

344: -- one error has been found then abort further validation.
345: --
346: hr_multi_message.end_validation_set;
347:
348: hr_utility.set_location('Entering:'||l_proc, 10);
349:
350: Chk_Unique_Validation_Name(P_Rec);
351:
352: hr_utility.set_location('Entering:'||l_proc, 15);

Line 352: hr_utility.set_location('Entering:'||l_proc, 15);

348: hr_utility.set_location('Entering:'||l_proc, 10);
349:
350: Chk_Unique_Validation_Name(P_Rec);
351:
352: hr_utility.set_location('Entering:'||l_proc, 15);
353:
354: Ckh_Remuneration(p_rec);
355:
356: hr_utility.set_location('Entering:'||l_proc, 20);

Line 356: hr_utility.set_location('Entering:'||l_proc, 20);

352: hr_utility.set_location('Entering:'||l_proc, 15);
353:
354: Ckh_Remuneration(p_rec);
355:
356: hr_utility.set_location('Entering:'||l_proc, 20);
357:
358: Ckh_Emp_Type(p_rec);
359:
360:

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

361: --
362: -- Validate Dependent Attributes
363: --
364: --
365: hr_utility.set_location(' Leaving:'||l_proc, 10);
366: End insert_validate;
367: --
368: -- ----------------------------------------------------------------------------
369: -- |---------------------------< update_validate >----------------------------|

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

374: --
375: l_proc varchar2(72) := g_package||'update_validate';
376: --
377: Begin
378: hr_utility.set_location('Entering:'||l_proc, 5);
379: --
380: -- Call all supporting business operations
381: --
382: hr_api.validate_bus_grp_id

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

388: -- if Multiple Message detection is enabled and at least
389: -- one error has been found then abort further validation.
390: --
391:
392: hr_utility.set_location('Entering:'||l_proc, 10);
393:
394: hr_multi_message.end_validation_set;
395:
396: Chk_Unique_Validation_Name(P_Rec);

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

402: ,p_rec => p_rec
403: );
404: --
405: --
406: hr_utility.set_location(' Leaving:'||l_proc, 10);
407: End update_validate;
408: --
409: -- ----------------------------------------------------------------------------
410: -- |---------------------------< delete_validate >----------------------------|

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

415: --
416: l_proc varchar2(72) := g_package||'delete_validate';
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- Call all supporting business operations
422: --
423: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- Call all supporting business operations
422: --
423: hr_utility.set_location(' Leaving:'||l_proc, 10);
424:
425: Chk_delete (p_rec);
426:
427: End delete_validate;