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