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_VER_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_ver_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_ver_bus.g_wrkplc_vldtn_ver_id := p_wrkplc_vldtn_ver_id;
147: pqh_ver_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_ID');

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

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

243: Open Emp_Type;
244: Fetch Emp_Type into l_Emp_Type;
245: Close Emp_Type;
246:
247: hr_utility.set_location(l_proc, 10);
248: Open Tariff_Contract;
249: Fetch Tariff_Contract into l_Result;
250: If Tariff_Contract%NOTFOUND Then
251: Close Tariff_Contract;

Line 252: hr_utility.set_message(8302,'PQH_DE_TRFCNT_VALDTN_DEF');

248: Open Tariff_Contract;
249: Fetch Tariff_Contract into l_Result;
250: If Tariff_Contract%NOTFOUND Then
251: Close Tariff_Contract;
252: hr_utility.set_message(8302,'PQH_DE_TRFCNT_VALDTN_DEF');
253: hr_utility.raise_error;
254: End If;
255: Close Tariff_Contract;
256: Exception

Line 253: hr_utility.raise_error;

249: Fetch Tariff_Contract into l_Result;
250: If Tariff_Contract%NOTFOUND Then
251: Close Tariff_Contract;
252: hr_utility.set_message(8302,'PQH_DE_TRFCNT_VALDTN_DEF');
253: hr_utility.raise_error;
254: End If;
255: Close Tariff_Contract;
256: Exception
257: when app_exception.application_exception then

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

257: when app_exception.application_exception then
258: if hr_multi_message.exception_add
259: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.TARIFF_CONTRACT_CODE'
260: ) then
261: hr_utility.set_location(' Leaving:'||l_proc,60);
262: raise;
263: end if;
264: hr_utility.set_location(' Leaving:'||l_proc,70);
265: End Ckh_Tariff_Contract;

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

260: ) then
261: hr_utility.set_location(' Leaving:'||l_proc,60);
262: raise;
263: end if;
264: hr_utility.set_location(' Leaving:'||l_proc,70);
265: End Ckh_Tariff_Contract;
266:
267: Procedure Ckh_Tariff_Group
268: (p_effective_date in date

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

286: b.Business_Group_Id=p_rec.Business_Group_Id ) and
287: b.Hierarchy_Version_id = a.Hierarchy_Version_id;
288:
289: Begin
290: hr_utility.set_location(l_proc, 10);
291: Open Tariff_Group;
292: Fetch Tariff_Group into l_Reslt;
293: If Tariff_Group%NOTFOUND Then
294: Close Tariff_Group;

Line 295: hr_utility.set_message(8302,'PQH_DE_TRFGRP_VALDTN_DEF');

291: Open Tariff_Group;
292: Fetch Tariff_Group into l_Reslt;
293: If Tariff_Group%NOTFOUND Then
294: Close Tariff_Group;
295: hr_utility.set_message(8302,'PQH_DE_TRFGRP_VALDTN_DEF');
296: hr_utility.raise_error;
297: End If;
298: Close Tariff_Group;
299: Exception

Line 296: hr_utility.raise_error;

292: Fetch Tariff_Group into l_Reslt;
293: If Tariff_Group%NOTFOUND Then
294: Close Tariff_Group;
295: hr_utility.set_message(8302,'PQH_DE_TRFGRP_VALDTN_DEF');
296: hr_utility.raise_error;
297: End If;
298: Close Tariff_Group;
299: Exception
300: when app_exception.application_exception then

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

300: when app_exception.application_exception then
301: if hr_multi_message.exception_add
302: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.TARIFF_GROUP_CODE'
303: ) then
304: hr_utility.set_location(' Leaving:'||l_proc,60);
305: raise;
306: end if;
307: hr_utility.set_location(' Leaving:'||l_proc,70);
308: End Ckh_Tariff_Group;

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

303: ) then
304: hr_utility.set_location(' Leaving:'||l_proc,60);
305: raise;
306: end if;
307: hr_utility.set_location(' Leaving:'||l_proc,70);
308: End Ckh_Tariff_Group;
309:
310: Procedure Ckh_Grade
311: (p_effective_date in date

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

355: d_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
356: l_Grade_id Pqh_De_Wrkplc_Vldtn_Vers.USER_ENTERABLE_GRADE_ID%TYPE := NULL;
357: l_Cnt Number(2) := 0;
358: Begin
359: hr_utility.set_location(l_proc, 10);
360: If p_rec.USER_ENTERABLE_GRADE_ID Is not Null Then
361: l_Grade_Id := p_rec.USER_ENTERABLE_GRADE_ID;
362: Elsif p_rec.DERIVED_GRADE_ID Is Not Null Then
363: l_Grade_Id := p_rec.DERIVED_GRADE_ID;

Line 386: hr_utility.set_message(8302,'PQH_DE_PAYGRD_VALDTN_DEF');

382: Exit;
383: End If;
384: If Grade_dtls%NOTFOUND Then
385: Close Grade_Dtls;
386: hr_utility.set_message(8302,'PQH_DE_PAYGRD_VALDTN_DEF');
387: hr_utility.raise_error;
388: Exit;
389: End If;
390: End Loop;

Line 387: hr_utility.raise_error;

383: End If;
384: If Grade_dtls%NOTFOUND Then
385: Close Grade_Dtls;
386: hr_utility.set_message(8302,'PQH_DE_PAYGRD_VALDTN_DEF');
387: hr_utility.raise_error;
388: Exit;
389: End If;
390: End Loop;
391: If l_Cnt = 0 Then

Line 393: hr_utility.set_message(8302,'PQH_DE_PAYGRD_VALDTN_DEF');

389: End If;
390: End Loop;
391: If l_Cnt = 0 Then
392: Close Grade_Dtls;
393: hr_utility.set_message(8302,'PQH_DE_PAYGRD_VALDTN_DEF');
394: hr_utility.raise_error;
395: End If;
396: End If;
397: Exception

Line 394: hr_utility.raise_error;

390: End Loop;
391: If l_Cnt = 0 Then
392: Close Grade_Dtls;
393: hr_utility.set_message(8302,'PQH_DE_PAYGRD_VALDTN_DEF');
394: hr_utility.raise_error;
395: End If;
396: End If;
397: Exception
398: when app_exception.application_exception then

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

398: when app_exception.application_exception then
399: if hr_multi_message.exception_add
400: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.DERIVED_GRADE_ID'
401: ) then
402: hr_utility.set_location(' Leaving:'||l_proc,60);
403: raise;
404: end if;
405: hr_utility.set_location(' Leaving:'||l_proc,70);
406: End Ckh_Grade;

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

401: ) then
402: hr_utility.set_location(' Leaving:'||l_proc,60);
403: raise;
404: end if;
405: hr_utility.set_location(' Leaving:'||l_proc,70);
406: End Ckh_Grade;
407:
408: Procedure Ckh_Freeze
409: (p_rec in pqh_ver_shd.g_rec_type,

Line 418: hr_utility.set_message(8302,'PQH_DE_FRDEL_VALDTN_VER');

414: l_Result Varchar2(1);
415:
416: Begin
417: If Nvl(P_Chk,'N') = 'D' and P_rec.Freeze = 'F' Then
418: hr_utility.set_message(8302,'PQH_DE_FRDEL_VALDTN_VER');
419: hr_utility.raise_error;
420: Else
421: If P_rec.Freeze = 'F' and Nvl(p_rec.USER_ENTERABLE_GRADE_ID, P_rec.DERIVED_GRADE_ID) is NULL Then
422: hr_utility.set_message(8302,'PQH_DE_FREZE_VALDTN_VER');

Line 419: hr_utility.raise_error;

415:
416: Begin
417: If Nvl(P_Chk,'N') = 'D' and P_rec.Freeze = 'F' Then
418: hr_utility.set_message(8302,'PQH_DE_FRDEL_VALDTN_VER');
419: hr_utility.raise_error;
420: Else
421: If P_rec.Freeze = 'F' and Nvl(p_rec.USER_ENTERABLE_GRADE_ID, P_rec.DERIVED_GRADE_ID) is NULL Then
422: hr_utility.set_message(8302,'PQH_DE_FREZE_VALDTN_VER');
423: hr_utility.raise_error;

Line 422: hr_utility.set_message(8302,'PQH_DE_FREZE_VALDTN_VER');

418: hr_utility.set_message(8302,'PQH_DE_FRDEL_VALDTN_VER');
419: hr_utility.raise_error;
420: Else
421: If P_rec.Freeze = 'F' and Nvl(p_rec.USER_ENTERABLE_GRADE_ID, P_rec.DERIVED_GRADE_ID) is NULL Then
422: hr_utility.set_message(8302,'PQH_DE_FREZE_VALDTN_VER');
423: hr_utility.raise_error;
424: End If;
425: End If;
426: Exception

Line 423: hr_utility.raise_error;

419: hr_utility.raise_error;
420: Else
421: If P_rec.Freeze = 'F' and Nvl(p_rec.USER_ENTERABLE_GRADE_ID, P_rec.DERIVED_GRADE_ID) is NULL Then
422: hr_utility.set_message(8302,'PQH_DE_FREZE_VALDTN_VER');
423: hr_utility.raise_error;
424: End If;
425: End If;
426: Exception
427: when app_exception.application_exception then

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

427: when app_exception.application_exception then
428: if hr_multi_message.exception_add
429: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.FREEZE'
430: ) then
431: hr_utility.set_location(' Leaving:'||l_proc,60);
432: raise;
433: end if;
434: hr_utility.set_location(' Leaving:'||l_proc,70);
435: End Ckh_Freeze;

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

430: ) then
431: hr_utility.set_location(' Leaving:'||l_proc,60);
432: raise;
433: end if;
434: hr_utility.set_location(' Leaving:'||l_proc,70);
435: End Ckh_Freeze;
436:
437:
438: --

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

446: --
447: l_proc varchar2(72) := g_package||'insert_validate';
448: --
449: Begin
450: hr_utility.set_location('Entering:'||l_proc, 5);
451: --
452: -- Call all supporting business operations
453: --
454:

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

477: --
478: -- Validate Dependent Attributes
479: --
480: --
481: hr_utility.set_location(' Leaving:'||l_proc, 10);
482: End insert_validate;
483: --
484: -- ----------------------------------------------------------------------------
485: -- |---------------------------< update_validate >----------------------------|

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

491: --
492: l_proc varchar2(72) := g_package||'update_validate';
493: --
494: Begin
495: hr_utility.set_location('Entering:'||l_proc, 5);
496: --
497: -- Call all supporting business operations
498: --
499: hr_api.validate_bus_grp_id

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

523: Ckh_Grade(p_effective_date,p_rec);
524:
525: Ckh_Freeze(p_rec,'N');
526:
527: hr_utility.set_location(' Leaving:'||l_proc, 10);
528:
529: End update_validate;
530: --
531: -- ----------------------------------------------------------------------------

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

537: --
538: l_proc varchar2(72) := g_package||'delete_validate';
539: --
540: Begin
541: hr_utility.set_location('Entering:'||l_proc, 5);
542: --
543: -- Call all supporting business operations
544: --
545: Ckh_Freeze(p_rec,'D');

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

542: --
543: -- Call all supporting business operations
544: --
545: Ckh_Freeze(p_rec,'D');
546: hr_utility.set_location(' Leaving:'||l_proc, 10);
547: End delete_validate;
548: --
549: end pqh_ver_bus;