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_OPG_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_opg_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_opg_bus.g_operation_group_id := p_operation_group_id;
147: pqh_opg_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, 'PQH_DE_NONUPD_OPGRP_CODE');

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

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

224: Where Description = p_rec.Description;
225: l_Description pqh_de_operation_groups.Description%TYPE;
226: l_proc varchar2(72) := g_package || 'Unique_Description';
227: Begin
228: hr_utility.set_location(l_proc, 10);
229: Open c_Description;
230: Fetch c_Description into l_Description;
231: If c_Description%ROWCOUNT > 0 Then
232: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_Description');

Line 232: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_Description');

228: hr_utility.set_location(l_proc, 10);
229: Open c_Description;
230: Fetch c_Description into l_Description;
231: If c_Description%ROWCOUNT > 0 Then
232: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_Description');
233: Close c_Description;
234: fnd_message.raise_error;
235: End If;
236: Close c_Description;

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

238: when app_exception.application_exception then
239: if hr_multi_message.exception_add
240: (p_associated_column1 => 'pqh_de_operation_groups.Description'
241: ) then
242: hr_utility.set_location(' Leaving:'||l_proc,60);
243: raise;
244: end if;
245: hr_utility.set_location(' Leaving:'||l_proc,70);
246: End Chk_Unique_Description;

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

241: ) then
242: hr_utility.set_location(' Leaving:'||l_proc,60);
243: raise;
244: end if;
245: hr_utility.set_location(' Leaving:'||l_proc,70);
246: End Chk_Unique_Description;
247:
248:
249: -- ----------------------------------------------------------------------------

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

259: Where operation_Group_CODE = p_rec.operation_Group_CODE;
260: L_status Varchar2(1);
261: l_proc varchar2(1000) := g_package || 'Unique_OPG_NUMBER';
262: Begin
263: hr_utility.set_location(l_proc, 10);
264: Open c_operation_Group_CODE;
265: Fetch c_operation_Group_CODE into L_status;
266: If c_operation_Group_CODE%found Then
267: hr_utility.set_message(8302, 'PQH_DE_OPG_GROUP_DUP');

Line 267: hr_utility.set_message(8302, 'PQH_DE_OPG_GROUP_DUP');

263: hr_utility.set_location(l_proc, 10);
264: Open c_operation_Group_CODE;
265: Fetch c_operation_Group_CODE into L_status;
266: If c_operation_Group_CODE%found Then
267: hr_utility.set_message(8302, 'PQH_DE_OPG_GROUP_DUP');
268: Close c_operation_Group_CODE;
269: fnd_message.raise_error;
270: End If;
271: Close c_operation_Group_CODE;

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

273: when app_exception.application_exception then
274: if hr_multi_message.exception_add
275: (p_associated_column1 => 'PQH_DE_OPERATION_groupS.operation_Group_CODE'
276: ) then
277: hr_utility.set_location(' Leaving:'||l_proc,60);
278: raise;
279: end if;
280: hr_utility.set_location(' Leaving:'||l_proc,70);
281: End Chk_Unique_opg_Group_CODE;

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

276: ) then
277: hr_utility.set_location(' Leaving:'||l_proc,60);
278: raise;
279: end if;
280: hr_utility.set_location(' Leaving:'||l_proc,70);
281: End Chk_Unique_opg_Group_CODE;
282:
283:
284: --

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

292: --
293: l_proc varchar2(72) := g_package||'insert_validate';
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: -- Call all supporting business operations
299: --
300: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

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

335: --
336: -- Validate Dependent Attributes
337: --
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 10);
340: End insert_validate;
341: --
342: -- ----------------------------------------------------------------------------
343: -- |---------------------------< update_validate >----------------------------|

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

349: --
350: l_proc varchar2(72) := g_package||'update_validate';
351: --
352: Begin
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: --
355: -- Call all supporting business operations
356: --
357: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

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

393: ,p_rec => p_rec
394: );
395: --
396: --
397: hr_utility.set_location(' Leaving:'||l_proc, 10);
398: End update_validate;
399: --
400: -- ----------------------------------------------------------------------------
401: -- |---------------------------< delete_validate >----------------------------|

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

406: --
407: l_proc varchar2(72) := g_package||'delete_validate';
408: --
409: Begin
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: --
412: -- Call all supporting business operations
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

410: hr_utility.set_location('Entering:'||l_proc, 5);
411: --
412: -- Call all supporting business operations
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 10);
415: End delete_validate;
416: --
417: end pqh_opg_bus;