DBA Data[Home] [Help]

APPS.PQH_FYN_BUS dependencies on HR_UTILITY

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_fyn_shd.api_updating
47: (p_fyi_notified_id => p_fyi_notified_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_fyi_notified_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.transaction_category_id = p_transaction_category_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_fyn_shd.api_updating
119: (p_fyi_notified_id => p_fyi_notified_id,
120: p_object_version_number => p_object_version_number);

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

143: close c1;
144: --
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: End chk_transaction_category_id;
150: --
151: -- ----------------------------------------------------------------------------

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

183: l_api_updating boolean;
184: --
185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := pqh_fyn_shd.api_updating
190: (p_fyi_notified_id => p_fyi_notified_id,
191: p_object_version_number => p_object_version_number);

Line 200: hr_utility.set_location('Type Cd: '||p_notified_type_cd, 10);

196: or not l_api_updating) then
197: --
198: -- check if value of lookup falls within lookup type.
199: --
200: hr_utility.set_location('Type Cd: '||p_notified_type_cd, 10);
201: --
202: if hr_api.not_exists_in_hr_lookups
203: (p_lookup_type => 'PQH_NOTIFIED_TYPE_CD',
204: p_lookup_code => p_notified_type_cd,

Line 209: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

205: p_effective_date => p_effective_date) then
206: --
207: -- raise error as does not exist as lookup
208: --
209: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
210: hr_utility.raise_error;
211: --
212: end if;
213: --

Line 210: hr_utility.raise_error;

206: --
207: -- raise error as does not exist as lookup
208: --
209: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
210: hr_utility.raise_error;
211: --
212: end if;
213: --
214: end if;

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

212: end if;
213: --
214: end if;
215: --
216: hr_utility.set_location('Leaving:'||l_proc,10);
217: --
218: end chk_notified_type_cd;
219: --
220: -- ----------------------------------------------------------------------------

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

252: l_api_updating boolean;
253: --
254: Begin
255: --
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: l_api_updating := pqh_fyn_shd.api_updating
259: (p_fyi_notified_id => p_fyi_notified_id,
260: p_object_version_number => p_object_version_number);

Line 277: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

273: p_effective_date => p_effective_date) then
274: --
275: -- raise error as does not exist as lookup
276: --
277: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
278: hr_utility.raise_error;
279: --
280: end if;
281: --

Line 278: hr_utility.raise_error;

274: --
275: -- raise error as does not exist as lookup
276: --
277: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
278: hr_utility.raise_error;
279: --
280: end if;
281: --
282: end if;

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

280: end if;
281: --
282: end if;
283: --
284: hr_utility.set_location('Leaving:'||l_proc,10);
285: --
286: end chk_notification_event_cd;
287: --
288: -- ----------------------------------------------------------------------------

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

327: where r.name = p_notified_name;
328: --
329: Begin
330: --
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: if p_notified_type_cd = 'OTHERS' THEN
334:
335: --

Line 347: hr_utility.set_message(8302,'PQH_INVALID_NOTIFIED_NAME');

343: close c1;
344: --
345: -- raise error
346: --
347: hr_utility.set_message(8302,'PQH_INVALID_NOTIFIED_NAME');
348: hr_utility.raise_error;
349: --
350: end if;
351: --

Line 348: hr_utility.raise_error;

344: --
345: -- raise error
346: --
347: hr_utility.set_message(8302,'PQH_INVALID_NOTIFIED_NAME');
348: hr_utility.raise_error;
349: --
350: end if;
351: --
352: close c1;

Line 364: hr_utility.set_message(8302,'PQH_INVALID_NOTIFIED_NAME');

360: if p_notified_name is not null then
361: --
362: -- raise error
363: --
364: hr_utility.set_message(8302,'PQH_INVALID_NOTIFIED_NAME');
365: hr_utility.raise_error;
366: --
367:
368: end if;

Line 365: hr_utility.raise_error;

361: --
362: -- raise error
363: --
364: hr_utility.set_message(8302,'PQH_INVALID_NOTIFIED_NAME');
365: hr_utility.raise_error;
366: --
367:
368: end if;
369:

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

369:
370: end if;
371: --
372: --
373: hr_utility.set_location('Leaving:'||l_proc,10);
374: --
375: end chk_notified_name;
376: --
377: -- ----------------------------------------------------------------------------

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

382: --
383: l_proc varchar2(72) := g_package||'insert_validate';
384: --
385: Begin
386: hr_utility.set_location('Entering:'||l_proc, 5);
387: --
388: -- Call all supporting business operations
389: --
390: chk_fyi_notified_id

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

416: p_object_version_number => p_rec.object_version_number);
417: --
418: --
419: --
420: hr_utility.set_location(' Leaving:'||l_proc, 10);
421: End insert_validate;
422: --
423: -- ----------------------------------------------------------------------------
424: -- |---------------------------< update_validate >----------------------------|

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

428: --
429: l_proc varchar2(72) := g_package||'update_validate';
430: --
431: Begin
432: hr_utility.set_location('Entering:'||l_proc, 5);
433: --
434: -- Call all supporting business operations
435: --
436: chk_fyi_notified_id

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

462: p_object_version_number => p_rec.object_version_number);
463: --
464: --
465: --
466: hr_utility.set_location(' Leaving:'||l_proc, 10);
467: End update_validate;
468: --
469: -- ----------------------------------------------------------------------------
470: -- |---------------------------< delete_validate >----------------------------|

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

474: --
475: l_proc varchar2(72) := g_package||'delete_validate';
476: --
477: Begin
478: hr_utility.set_location('Entering:'||l_proc, 5);
479: --
480: -- Call all supporting business operations
481: --
482: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

478: hr_utility.set_location('Entering:'||l_proc, 5);
479: --
480: -- Call all supporting business operations
481: --
482: hr_utility.set_location(' Leaving:'||l_proc, 10);
483: End delete_validate;
484: --
485: end pqh_fyn_bus;