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_OPL_BUS dependencies on HR_UTILITY

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

43: l_proc varchar2(72) := g_package||'set_security_group_id';
44: --
45: begin
46: --
47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: --
49: -- Ensure that all the mandatory parameter are not null
50: --
51: hr_api.mandatory_arg_error

Line 82: hr_utility.set_location(' Leaving:'|| l_proc, 20);

78: (p_security_group_id => l_security_group_id
79: );
80: end if;
81: --
82: hr_utility.set_location(' Leaving:'|| l_proc, 20);
83: --
84: end set_security_group_id;
85: --
86: -- ---------------------------------------------------------------------------

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

113: l_proc varchar2(72) := g_package||'return_legislation_code';
114: --
115: Begin
116: --
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: --
119: -- Ensure that all the mandatory parameter are not null
120: --
121: hr_api.mandatory_arg_error

Line 135: hr_utility.set_location(l_proc, 20);

131: -- call to this function. Just return the value in the global
132: -- variable.
133: --
134: l_legislation_code := pqh_opl_bus.g_legislation_code;
135: hr_utility.set_location(l_proc, 20);
136: else
137: --
138: -- The ID is different to the last call to this function
139: -- or this is the first call to this function.

Line 152: hr_utility.set_location(l_proc,30);

148: close csr_leg_code;
149: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
150: fnd_message.raise_error;
151: end if;
152: hr_utility.set_location(l_proc,30);
153: --
154: -- Set the global variables so the values are
155: -- available for the next call to this function.
156: --

Line 161: hr_utility.set_location(' Leaving:'|| l_proc, 40);

157: close csr_leg_code;
158: pqh_opl_bus.g_operation_id := p_operation_id;
159: pqh_opl_bus.g_legislation_code := l_legislation_code;
160: end if;
161: hr_utility.set_location(' Leaving:'|| l_proc, 40);
162: return l_legislation_code;
163: end return_legislation_code;
164: --
165: -- ----------------------------------------------------------------------------

Line 220: hr_utility.set_message(8302, 'PQH_DE_NONUPD_OPERATION_NUMBER');

216: -- not been updated.
217: --
218: IF nvl(p_rec.OPERATION_NUMBER, hr_api.g_varchar2) <>
219: nvl(pqh_opl_shd.g_old_rec.OPERATION_NUMBER, hr_api.g_varchar2) THEN
220: hr_utility.set_message(8302, 'PQH_DE_NONUPD_OPERATION_NUMBER');
221: fnd_message.raise_error;
222: END IF;
223:
224: End chk_non_updateable_args;

Line 242: hr_utility.set_message(8302, 'PQH_OPRTNS_PRE_DEL');

238: Open Del;
239: Fetch Del into l_Status;
240: If Del%Found Then
241: Close Del;
242: hr_utility.set_message(8302, 'PQH_OPRTNS_PRE_DEL');
243: hr_utility.raise_error;
244: End If;
245: Close Del;
246: Exception

Line 243: hr_utility.raise_error;

239: Fetch Del into l_Status;
240: If Del%Found Then
241: Close Del;
242: hr_utility.set_message(8302, 'PQH_OPRTNS_PRE_DEL');
243: hr_utility.raise_error;
244: End If;
245: Close Del;
246: Exception
247: when app_exception.application_exception then

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_OPERATIONS.OPERATION_NUMBER'
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_Delete;

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_Delete;
256:
257: -- ----------------------------------------------------------------------------
258: -- |-----------------------< Chk_Unique_Description >-------------------------|

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

266: Where Description = p_rec.Description;
267: l_Description PQH_DE_OPERATIONS.Description%TYPE;
268: l_proc varchar2(72) := g_package || 'Unique_Description';
269: Begin
270: hr_utility.set_location(l_proc, 10);
271: Open c_Description;
272: Fetch c_Description into l_Description;
273: If c_Description%ROWCOUNT > 0 Then
274: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_Description');

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

270: hr_utility.set_location(l_proc, 10);
271: Open c_Description;
272: Fetch c_Description into l_Description;
273: If c_Description%ROWCOUNT > 0 Then
274: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_Description');
275: Close c_Description;
276: fnd_message.raise_error;
277: End If;
278: Close c_Description;

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

280: when app_exception.application_exception then
281: if hr_multi_message.exception_add
282: (p_associated_column1 => 'PQH_DE_OPERATIONS.Description'
283: ) then
284: hr_utility.set_location(' Leaving:'||l_proc,60);
285: raise;
286: end if;
287: hr_utility.set_location(' Leaving:'||l_proc,70);
288: End Chk_Unique_Description;

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

283: ) then
284: hr_utility.set_location(' Leaving:'||l_proc,60);
285: raise;
286: end if;
287: hr_utility.set_location(' Leaving:'||l_proc,70);
288: End Chk_Unique_Description;
289: -- ----------------------------------------------------------------------------
290: -- |-----------------------< Chk_Unique_OPERATION_NUMBER >--------------------|
291: -- ----------------------------------------------------------------------------

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

298: Where OPERATION_NUMBER = p_rec.OPERATION_NUMBER;
299: l_OPERATION_NUMBER PQH_DE_OPERATIONS.OPERATION_NUMBER%TYPE;
300: l_proc varchar2(72) := g_package || 'Unique_OPERATION_NUMBER';
301: Begin
302: hr_utility.set_location(l_proc, 10);
303: Open c_OPERATION_NUMBER;
304: Fetch c_OPERATION_NUMBER into l_OPERATION_NUMBER;
305: If c_OPERATION_NUMBER%ROWCOUNT > 0 Then
306: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_OPERATIONS');

Line 306: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_OPERATIONS');

302: hr_utility.set_location(l_proc, 10);
303: Open c_OPERATION_NUMBER;
304: Fetch c_OPERATION_NUMBER into l_OPERATION_NUMBER;
305: If c_OPERATION_NUMBER%ROWCOUNT > 0 Then
306: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_OPERATIONS');
307: Close c_OPERATION_NUMBER;
308: fnd_message.raise_error;
309: End If;
310: Close c_OPERATION_NUMBER;

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_OPERATIONS.OPERATION_NUMBER'
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_Unique_OPERATION_NUMBER;

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_Unique_OPERATION_NUMBER;
321: -- ----------------------------------------------------------------------------
322: -- |---------------------------< insert_validate >----------------------------|
323: -- ----------------------------------------------------------------------------

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

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

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

346: --
347: -- Validate Dependent Attributes
348: --
349: --
350: hr_utility.set_location(' Leaving:'||l_proc, 10);
351: End insert_validate;
352: --
353: -- ----------------------------------------------------------------------------
354: -- |---------------------------< update_validate >----------------------------|

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

360: --
361: l_proc varchar2(72) := g_package||'update_validate';
362: --
363: Begin
364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: -- Call all supporting business operations
367: --
368: --

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

382: ,p_rec => p_rec
383: );
384: --
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 10);
387: End update_validate;
388: --
389: -- ----------------------------------------------------------------------------
390: -- |---------------------------< delete_validate >----------------------------|

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

395: --
396: l_proc varchar2(72) := g_package||'delete_validate';
397: --
398: Begin
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: -- Call all supporting business operations
402: --
403: Chk_delete(P_Rec);

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

400: --
401: -- Call all supporting business operations
402: --
403: Chk_delete(P_Rec);
404: hr_utility.set_location(' Leaving:'||l_proc, 10);
405: End delete_validate;
406: --
407: end pqh_opl_bus;