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_CGN_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_cgn_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_cgn_bus.g_case_group_id := p_case_group_id;
147: pqh_cgn_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 209: hr_utility.set_message(8302, 'PQH_DE_CSGRP_NUMBER');

205:
206:
207: IF nvl(p_rec.CASE_GROUP_NUMBER, hr_api.g_varchar2) <>
208: nvl(pqh_cgn_shd.g_old_rec.CASE_GROUP_NUMBER, hr_api.g_varchar2) THEN
209: hr_utility.set_message(8302, 'PQH_DE_CSGRP_NUMBER');
210: fnd_message.raise_error;
211: END IF;
212:
213:

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

228:
229: l_case_group_NUMBER PQH_DE_case_groupS.case_group_NUMBER%TYPE;
230: l_proc varchar2(72) := g_package || 'Chk_case_group_NUMBER';
231: Begin
232: hr_utility.set_location(l_proc, 10);
233: Open c_case_group_NUMBER;
234: Fetch c_case_group_NUMBER into l_case_group_NUMBER;
235: If c_case_group_NUMBER%ROWCOUNT = 0 Then
236: hr_utility.set_message(8302, 'PQH_DE_NO_EXIST_CASE_GROUP');

Line 236: hr_utility.set_message(8302, 'PQH_DE_NO_EXIST_CASE_GROUP');

232: hr_utility.set_location(l_proc, 10);
233: Open c_case_group_NUMBER;
234: Fetch c_case_group_NUMBER into l_case_group_NUMBER;
235: If c_case_group_NUMBER%ROWCOUNT = 0 Then
236: hr_utility.set_message(8302, 'PQH_DE_NO_EXIST_CASE_GROUP');
237: Close c_case_group_NUMBER;
238: fnd_message.raise_error;
239: End If;
240: Close c_case_group_NUMBER;

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

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

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

245: ) then
246: hr_utility.set_location(' Leaving:'||l_proc,60);
247: raise;
248: end if;
249: hr_utility.set_location(' Leaving:'||l_proc,70);
250: End Chk_ADVANCEMENT_TO;
251: --
252: -- ----------------------------------------------------------------------------
253: -- |-----------------------< Chk_delete >--------------------------------------|

Line 272: hr_utility.set_message(8302,'PQH_CASE_GROUP_PRE_DEL');

268: Open Del;
269: Fetch Del into l_Status;
270: If Del%Found Then
271: Close Del;
272: hr_utility.set_message(8302,'PQH_CASE_GROUP_PRE_DEL');
273: hr_utility.raise_error;
274: End If;
275: Close Del;
276: Exception

Line 273: hr_utility.raise_error;

269: Fetch Del into l_Status;
270: If Del%Found Then
271: Close Del;
272: hr_utility.set_message(8302,'PQH_CASE_GROUP_PRE_DEL');
273: hr_utility.raise_error;
274: End If;
275: Close Del;
276: Exception
277: when app_exception.application_exception then

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

277: when app_exception.application_exception then
278: if hr_multi_message.exception_add
279: (p_associated_column1 => 'PQH_DE_CASE_GROUPS.CASE_GROUP_NUMBER'
280: ) then
281: hr_utility.set_location(' Leaving:'||l_proc,60);
282: raise;
283: end if;
284: hr_utility.set_location(' Leaving:'||l_proc,70);
285: End Chk_Delete;

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

280: ) then
281: hr_utility.set_location(' Leaving:'||l_proc,60);
282: raise;
283: end if;
284: hr_utility.set_location(' Leaving:'||l_proc,70);
285: End Chk_Delete;
286: -- ----------------------------------------------------------------------------
287: -- |-----------------------< Chk_Unique_case_group_NUMBER >------------------|
288: -- ----------------------------------------------------------------------------

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

297: and description = p_rec.description;
298: L_status Varchar2(1);
299: l_proc varchar2(1000) := g_package || 'Unique_cg_NUMBER';
300: Begin
301: hr_utility.set_location(l_proc, 10);
302: Open c_case_group_NUMBER;
303: Fetch c_case_group_NUMBER into L_status;
304: If c_case_group_NUMBER%found Then
305: hr_utility.set_message(8302, 'PQH_DE_CASE_GROUP_DUP');

Line 305: hr_utility.set_message(8302, 'PQH_DE_CASE_GROUP_DUP');

301: hr_utility.set_location(l_proc, 10);
302: Open c_case_group_NUMBER;
303: Fetch c_case_group_NUMBER into L_status;
304: If c_case_group_NUMBER%found Then
305: hr_utility.set_message(8302, 'PQH_DE_CASE_GROUP_DUP');
306: Close c_case_group_NUMBER;
307: fnd_message.raise_error;
308: End If;
309: Close c_case_group_NUMBER;

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

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

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

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

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: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

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

369: --
370: -- Validate Dependent Attributes
371: --
372: --
373: hr_utility.set_location(' Leaving:'||l_proc, 10);
374: End insert_validate;
375: --
376: -- ----------------------------------------------------------------------------
377: -- |---------------------------< update_validate >----------------------------|

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

383: --
384: l_proc varchar2(72) := g_package||'update_validate';
385: --
386: Begin
387: hr_utility.set_location('Entering:'||l_proc, 5);
388: --
389: -- Call all supporting business operations
390: --
391: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

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

432:
433:
434: --
435: --
436: hr_utility.set_location(' Leaving:'||l_proc, 10);
437: End update_validate;
438: --
439: -- ----------------------------------------------------------------------------
440: -- |---------------------------< delete_validate >----------------------------|

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

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

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

450: --
451: -- Call all supporting business operations
452: --
453: Chk_delete(P_Rec);
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: End delete_validate;
456: --
457: end pqh_cgn_bus;