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_ETM_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_etm_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_etm_bus.g_ent_minutes_id := p_ent_minutes_id;
147: pqh_etm_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 204: hr_utility.set_message(8302, 'DE_PQH_NONUPD_ENT_CD');

200: END IF;
201:
202: IF nvl(p_rec.ENT_MINUTES_CD, hr_api.g_varchar2) <>
203: nvl(pqh_etm_shd.g_old_rec.ENT_MINUTES_CD, hr_api.g_varchar2) THEN
204: hr_utility.set_message(8302, 'DE_PQH_NONUPD_ENT_CD');
205: fnd_message.raise_error;
206: END IF;
207:
208: IF nvl(p_rec.TARIFF_GROUP_CD, hr_api.g_varchar2) <>

Line 210: hr_utility.set_message(8302, 'DE_PQH_NONUPD_TARIFF_CD');

206: END IF;
207:
208: IF nvl(p_rec.TARIFF_GROUP_CD, hr_api.g_varchar2) <>
209: nvl(pqh_etm_shd.g_old_rec.TARIFF_GROUP_CD, hr_api.g_varchar2) THEN
210: hr_utility.set_message(8302, 'DE_PQH_NONUPD_TARIFF_CD');
211: fnd_message.raise_error;
212: END IF;
213:
214:

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

233:
234: L_status Varchar2(1);
235: l_proc varchar2(1000) := g_package || 'UNIQUE_ENT_MIN_TFF_CD';
236: Begin
237: hr_utility.set_location(l_proc, 10);
238: Open c_TFF_CD_HR_LOOKUP;
239: Fetch c_TFF_CD_HR_LOOKUP into L_status;
240: If c_TFF_CD_HR_LOOKUP%notfound Then
241: hr_utility.set_message(8302, 'DE_PQH_TARIFF_CODE');

Line 241: hr_utility.set_message(8302, 'DE_PQH_TARIFF_CODE');

237: hr_utility.set_location(l_proc, 10);
238: Open c_TFF_CD_HR_LOOKUP;
239: Fetch c_TFF_CD_HR_LOOKUP into L_status;
240: If c_TFF_CD_HR_LOOKUP%notfound Then
241: hr_utility.set_message(8302, 'DE_PQH_TARIFF_CODE');
242: Close c_TFF_CD_HR_LOOKUP;
243: fnd_message.raise_error;
244: End If;
245: Close c_TFF_CD_HR_LOOKUP;

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

247: when app_exception.application_exception then
248: if hr_multi_message.exception_add
249: (p_associated_column1 => 'PQH_DE_ENT_MINUTES.Tariff_group_CD'
250: ) then
251: hr_utility.set_location(' Leaving:'||l_proc,60);
252: raise;
253: end if;
254: hr_utility.set_location(' Leaving:'||l_proc,70);
255: End Chk_TFF_CD_HR_LOOKUP;

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

250: ) then
251: hr_utility.set_location(' Leaving:'||l_proc,60);
252: raise;
253: end if;
254: hr_utility.set_location(' Leaving:'||l_proc,70);
255: End Chk_TFF_CD_HR_LOOKUP;
256:
257: -- ----------------------------------------------------------------------------
258: -- |-----------------------< Chk_unique_ENT_Desc >-----------------------------|

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

269:
270: L_status Varchar2(1);
271: l_proc varchar2(1000) := g_package || 'UNIQUE_unique_ENT_Desc';
272: Begin
273: hr_utility.set_location(l_proc, 10);
274: Open c_unique_ENT_Desc;
275: Fetch c_unique_ENT_Desc into L_status;
276: If c_unique_ENT_Desc%found Then
277: hr_utility.set_message(8302, 'DE_PQH_unique_ENT_Desc');

Line 277: hr_utility.set_message(8302, 'DE_PQH_unique_ENT_Desc');

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

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

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

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

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

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

305:
306: L_status Varchar2(1);
307: l_proc varchar2(1000) := g_package || 'UNIQUE_ENT_MIN_TFF_CD';
308: Begin
309: hr_utility.set_location(l_proc, 10);
310: Open c_ENT_MIN_TFF_CD;
311: Fetch c_ENT_MIN_TFF_CD into L_status;
312: If c_ENT_MIN_TFF_CD%found Then
313: hr_utility.set_message(8302, 'PQH_DE_ENT_MINUTES_DUP');

Line 313: hr_utility.set_message(8302, 'PQH_DE_ENT_MINUTES_DUP');

309: hr_utility.set_location(l_proc, 10);
310: Open c_ENT_MIN_TFF_CD;
311: Fetch c_ENT_MIN_TFF_CD into L_status;
312: If c_ENT_MIN_TFF_CD%found Then
313: hr_utility.set_message(8302, 'PQH_DE_ENT_MINUTES_DUP');
314: Close c_ENT_MIN_TFF_CD;
315: fnd_message.raise_error;
316: End If;
317: Close c_ENT_MIN_TFF_CD;

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

319: when app_exception.application_exception then
320: if hr_multi_message.exception_add
321: (p_associated_column1 => 'PQH_DE_ENT_MINUTES.ENT_MINUTES_CD'
322: ) then
323: hr_utility.set_location(' Leaving:'||l_proc,60);
324: raise;
325: end if;
326: hr_utility.set_location(' Leaving:'||l_proc,70);
327: End Chk_ENT_MIN_TFF_CD;

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

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

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

336: --
337: l_proc varchar2(72) := g_package||'insert_validate';
338: --
339: Begin
340: hr_utility.set_location('Entering:'||l_proc, 5);
341: --
342: -- Call all supporting business operations
343: --
344: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

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

376: --
377: Chk_TFF_CD_HR_LOOKUP(P_REC);
378: Chk_ENT_MIN_TFF_CD (P_Rec);
379: Chk_unique_ENT_Desc(P_Rec);
380: hr_utility.set_location(' Leaving:'||l_proc, 10);
381: End insert_validate;
382: --
383: -- ----------------------------------------------------------------------------
384: -- |---------------------------< update_validate >----------------------------|

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

390: --
391: l_proc varchar2(72) := g_package||'update_validate';
392: --
393: Begin
394: hr_utility.set_location('Entering:'||l_proc, 5);
395: --
396: -- Call all supporting business operations
397: --
398: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

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

435: Chk_TFF_CD_HR_LOOKUP(P_REC);
436: Chk_unique_ENT_Desc(P_Rec);
437: --
438: --
439: hr_utility.set_location(' Leaving:'||l_proc, 10);
440: End update_validate;
441: --
442: -- ----------------------------------------------------------------------------
443: -- |---------------------------< delete_validate >----------------------------|

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

448: --
449: l_proc varchar2(72) := g_package||'delete_validate';
450: --
451: Begin
452: hr_utility.set_location('Entering:'||l_proc, 5);
453: --
454: -- Call all supporting business operations
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

452: hr_utility.set_location('Entering:'||l_proc, 5);
453: --
454: -- Call all supporting business operations
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: End delete_validate;
458: --
459: end pqh_etm_bus;