20:
21:
22: BEGIN
23:
24: hr_utility.set_location('Entering: '|| l_proc, 10);
25:
26: IF NVL(p_date_to,p_date_from) >= p_date_from THEN
27:
28: NULL;
26: IF NVL(p_date_to,p_date_from) >= p_date_from THEN
27:
28: NULL;
29: ELSE
30: hr_utility.set_message(8301, 'GHR_DATE_TO_<_DATE_FROM');
31:
32: hr_utility.raise_error;
33: END IF;
34:
28: NULL;
29: ELSE
30: hr_utility.set_message(8301, 'GHR_DATE_TO_<_DATE_FROM');
31:
32: hr_utility.raise_error;
33: END IF;
34:
35: END CHK_DATE_TO;
36:
55: where p_category in ('ACTIVE','INACTIVE','STANDARD','CANCELED');
56:
57: BEGIN
58:
59: hr_utility.set_location('Entering: '|| l_proc, 10);
60:
61: -- Check Mandatory Parameters are set
62:
63: hr_api.mandatory_arg_error
85: OR
86: NOT l_api_updating THEN
87:
88: --
89: hr_utility.set_location(l_proc,20);
90: --
91:
92: IF p_category is NOT NULL THEN
93: open c_pd_category;
94: fetch c_pd_category into l_dummy;
95: IF c_pd_category%notfound then
96:
97: -- Error: Invalid category category
98: hr_utility.set_message(8301, 'GHR_38635_INVALID_PD_CATEGORY');
99:
100: hr_utility.raise_error;
101: END IF;
102: hr_utility.set_location(l_proc,30);
96:
97: -- Error: Invalid category category
98: hr_utility.set_message(8301, 'GHR_38635_INVALID_PD_CATEGORY');
99:
100: hr_utility.raise_error;
101: END IF;
102: hr_utility.set_location(l_proc,30);
103: close c_pd_category;
104:
98: hr_utility.set_message(8301, 'GHR_38635_INVALID_PD_CATEGORY');
99:
100: hr_utility.raise_error;
101: END IF;
102: hr_utility.set_location(l_proc,30);
103: close c_pd_category;
104:
105: END IF;
106:
105: END IF;
106:
107: END IF;
108:
109: hr_utility.set_location('Leaving: '|| l_proc, 40);
110:
111: end chk_category;
112: --
113: -----------------------------
125:
126:
127: BEGIN
128:
129: hr_utility.set_location('Entering: '|| l_proc, 10);
130:
131: -- Check Mandatory Parameters are set
132:
133: hr_api.mandatory_arg_error
155: OR
156: NOT l_api_updating THEN
157:
158: --
159: hr_utility.set_location(l_proc,20);
160: --
161: -- If flsa is not null then
162: -- Check if the flsa value exists in fnd_lookups
163: -- Where the look up type is 'GHR_US_FLSA_CATEGORY'
170: p_lookup_type => 'GHR_US_FLSA_CATEGORY',
171: p_lookup_code => p_flsa
172: ) THEN
173: -- Error: Invalid FLSA category
174: hr_utility.set_message(8301, 'GHR_FLSA_CODE_INVALID');
175:
176: hr_utility.raise_error;
177: END IF;
178: hr_utility.set_location(l_proc,30);
172: ) THEN
173: -- Error: Invalid FLSA category
174: hr_utility.set_message(8301, 'GHR_FLSA_CODE_INVALID');
175:
176: hr_utility.raise_error;
177: END IF;
178: hr_utility.set_location(l_proc,30);
179:
180: END IF;
174: hr_utility.set_message(8301, 'GHR_FLSA_CODE_INVALID');
175:
176: hr_utility.raise_error;
177: END IF;
178: hr_utility.set_location(l_proc,30);
179:
180: END IF;
181:
182: END IF;
180: END IF;
181:
182: END IF;
183:
184: hr_utility.set_location('Leaving: '|| l_proc, 40);
185:
186: end chk_flsa;
187:
188: --
201: l_api_updating boolean;
202:
203: BEGIN
204:
205: hr_utility.set_location('Entering: '|| l_proc, 10);
206:
207: -- Check Mandatory Parameters are set
208:
209: hr_api.mandatory_arg_error
231: <> nvl(p_financial_statement,hr_api.g_varchar2))))
232: OR
233: NOT l_api_updating THEN
234: --
235: hr_utility.set_location(l_proc,20);
236: --
237: -- If financial statement is not null then
238: -- Check if the financial statement value exists in fnd_lookups
239: -- Where the look up type is 'GHR_US_FINANCIAL_STATEMENT'
246: p_lookup_type => 'GHR_US_FINANCIAL_STATEMENT',
247: p_lookup_code => p_financial_statement
248: ) THEN
249: -- Error: Invalid FLSA category
250: hr_utility.set_message(8301, 'GHR_FINANCIAL_STAT_INVALID');
251:
252: hr_utility.raise_error;
253:
254: END IF;
248: ) THEN
249: -- Error: Invalid FLSA category
250: hr_utility.set_message(8301, 'GHR_FINANCIAL_STAT_INVALID');
251:
252: hr_utility.raise_error;
253:
254: END IF;
255: hr_utility.set_location(l_proc,30);
256:
251:
252: hr_utility.raise_error;
253:
254: END IF;
255: hr_utility.set_location(l_proc,30);
256:
257: END IF;
258:
259: END IF;
257: END IF;
258:
259: END IF;
260:
261: hr_utility.set_location('Leaving: '|| l_proc, 40);
262:
263: END chk_financial_statement;
264:
265:
280:
281:
282: BEGIN
283:
284: hr_utility.set_location('Entering: '|| l_proc, 10);
285:
286: -- Check Mandatory Parameters are set
287:
288: hr_api.mandatory_arg_error
309: <> nvl(p_sub_to_ia_action,hr_api.g_varchar2))))
310: OR
311: NOT l_api_updating THEN
312: --
313: hr_utility.set_location(l_proc,20);
314: --
315: -- If Subject to IA action is not null then
316: -- Check if the subject to IA action value exists in fnd_lookups
317: -- Where the look up type is 'subject_to_ia_action_ACTION'
324: p_lookup_type => 'YES_NO',
325: p_lookup_code => p_sub_to_ia_action
326: ) THEN
327: -- Error: Invalid Subject to IA Action
328: hr_utility.set_message(8301, 'GHR_SUBJECT_TO_IA_INVALID');
329:
330: hr_utility.raise_error;
331: END IF;
332: ELSE
326: ) THEN
327: -- Error: Invalid Subject to IA Action
328: hr_utility.set_message(8301, 'GHR_SUBJECT_TO_IA_INVALID');
329:
330: hr_utility.raise_error;
331: END IF;
332: ELSE
333: hr_utility.set_message(8301, 'GHR_38637_NULL_SUB_IA_ACTION');
334: hr_utility.raise_error;
329:
330: hr_utility.raise_error;
331: END IF;
332: ELSE
333: hr_utility.set_message(8301, 'GHR_38637_NULL_SUB_IA_ACTION');
334: hr_utility.raise_error;
335: hr_utility.set_location(l_proc,30);
336:
337: END IF;
330: hr_utility.raise_error;
331: END IF;
332: ELSE
333: hr_utility.set_message(8301, 'GHR_38637_NULL_SUB_IA_ACTION');
334: hr_utility.raise_error;
335: hr_utility.set_location(l_proc,30);
336:
337: END IF;
338:
331: END IF;
332: ELSE
333: hr_utility.set_message(8301, 'GHR_38637_NULL_SUB_IA_ACTION');
334: hr_utility.raise_error;
335: hr_utility.set_location(l_proc,30);
336:
337: END IF;
338:
339: END IF;
337: END IF;
338:
339: END IF;
340:
341: hr_utility.set_location('Leaving: '|| l_proc, 40);
342:
343: END CHK_subject_to_ia_action;
344:
345:
358:
359:
360: BEGIN
361:
362: hr_utility.set_location('Entering: '|| l_proc, 10);
363:
364: -- Check Mandatory Parameters are set
365:
366: hr_api.mandatory_arg_error
388: OR
389: NOT l_api_updating THEN
390:
391: --
392: hr_utility.set_location(l_proc,20);
393: --
394: -- If Subject to IA action is not null then
395: -- Check if the position status value exists in fnd_lookups
396: -- Where the look up type is 'GHR_US_POSITION_OCCUPIED'
404: p_lookup_code => p_position_status
405: ) THEN
406:
407: -- Error: Invalid Position Status
408: hr_utility.set_message(8301, 'GHR_POSITION_STATUS_INVALID');
409: hr_utility.raise_error;
410:
411: END IF;
412: hr_utility.set_location(l_proc,30);
405: ) THEN
406:
407: -- Error: Invalid Position Status
408: hr_utility.set_message(8301, 'GHR_POSITION_STATUS_INVALID');
409: hr_utility.raise_error;
410:
411: END IF;
412: hr_utility.set_location(l_proc,30);
413:
408: hr_utility.set_message(8301, 'GHR_POSITION_STATUS_INVALID');
409: hr_utility.raise_error;
410:
411: END IF;
412: hr_utility.set_location(l_proc,30);
413:
414: END IF;
415:
416: END IF;
414: END IF;
415:
416: END IF;
417:
418: hr_utility.set_location('Leaving: '|| l_proc, 40);
419:
420: END CHK_POSITION_STATUS;
421:
422:
437:
438:
439: BEGIN
440:
441: hr_utility.set_location('Entering: '|| l_proc, 10);
442:
443: -- Check Mandatory Parameters are set
444:
445: hr_api.mandatory_arg_error
467: OR
468: NOT l_api_updating THEN
469:
470: --
471: hr_utility.set_location(l_proc,20);
472: --
473: -- If Position is is not null then
474: -- Check if the Position Is value exists in fnd_lookups
475: -- Where the look up type is 'GHR_US_SUPERVISORY_STATUS'
483: p_lookup_code => p_position_is
484: ) THEN
485:
486: -- Error: Invalid Position Is
487: hr_utility.set_message(8301, 'GHR_POSITION_IS_VALUE_INVALID');
488: hr_utility.raise_error;
489: END IF;
490: hr_utility.set_location(l_proc,30);
491:
484: ) THEN
485:
486: -- Error: Invalid Position Is
487: hr_utility.set_message(8301, 'GHR_POSITION_IS_VALUE_INVALID');
488: hr_utility.raise_error;
489: END IF;
490: hr_utility.set_location(l_proc,30);
491:
492: END IF;
486: -- Error: Invalid Position Is
487: hr_utility.set_message(8301, 'GHR_POSITION_IS_VALUE_INVALID');
488: hr_utility.raise_error;
489: END IF;
490: hr_utility.set_location(l_proc,30);
491:
492: END IF;
493:
494: END IF;
492: END IF;
493:
494: END IF;
495:
496: hr_utility.set_location('Leaving: '|| l_proc, 40);
497:
498: END CHK_POSITION_IS;
499:
500:
515:
516:
517: BEGIN
518:
519: hr_utility.set_location('Entering: '|| l_proc, 10);
520:
521: -- Check Mandatory Parameters are set
522:
523: hr_api.mandatory_arg_error
545: OR
546: NOT l_api_updating THEN
547:
548: --
549: hr_utility.set_location(l_proc,20);
550: --
551: -- If position sensitivity is not null then
552: -- Check if the position sensitivity value exists in fnd_lookups
553: -- Where the look up type is 'GHR_US_POSN_SENSITIVITY'
560: p_lookup_type => 'GHR_US_POSN_SENSITIVITY',
561: p_lookup_code => p_position_sensitivity
562: ) THEN
563: -- Error: Invalid Position Sensitivity
564: hr_utility.set_message(8301, 'GHR_POS_SENSITIVITY_INVALID');
565: hr_utility.raise_error;
566: END IF;
567: hr_utility.set_location(l_proc,30);
568:
561: p_lookup_code => p_position_sensitivity
562: ) THEN
563: -- Error: Invalid Position Sensitivity
564: hr_utility.set_message(8301, 'GHR_POS_SENSITIVITY_INVALID');
565: hr_utility.raise_error;
566: END IF;
567: hr_utility.set_location(l_proc,30);
568:
569: END IF;
563: -- Error: Invalid Position Sensitivity
564: hr_utility.set_message(8301, 'GHR_POS_SENSITIVITY_INVALID');
565: hr_utility.raise_error;
566: END IF;
567: hr_utility.set_location(l_proc,30);
568:
569: END IF;
570:
571: END IF;
569: END IF;
570:
571: END IF;
572:
573: hr_utility.set_location('Leaving: '|| l_proc, 40);
574:
575: END CHK_POSITION_SENSITIVITY;
576:
577:
593:
594:
595: BEGIN
596:
597: hr_utility.set_location('Entering: '|| l_proc, 10);
598:
599: -- Check Mandatory Parameters are set
600:
601: hr_api.mandatory_arg_error
623: OR
624: NOT l_api_updating THEN
625:
626:
627: hr_utility.set_location(l_proc,20);
628: -- Commented by vtakru 04/06/98
629: -- If Competitive level is not null then
630: -- Check if the comp level value exists in fnd_lookups
631: -- Where the look up type is 'GHR_US_COMP_LEVEL'
638: -- p_lookup_type => 'GHR_US_COMP_LEVEL',
639: -- p_lookup_code => p_competitive_level
640: -- ) THEN
641: -- Error: Invalid Competitive level
642: -- hr_utility.set_message(8301, 'GHR_COMPETITIVE_LEVEL_INVALID');
643: -- hr_utility.raise_error;
644: -- END IF;
645: -- hr_utility.set_location(l_proc,30);
646: --
639: -- p_lookup_code => p_competitive_level
640: -- ) THEN
641: -- Error: Invalid Competitive level
642: -- hr_utility.set_message(8301, 'GHR_COMPETITIVE_LEVEL_INVALID');
643: -- hr_utility.raise_error;
644: -- END IF;
645: -- hr_utility.set_location(l_proc,30);
646: --
647: -- END IF;
641: -- Error: Invalid Competitive level
642: -- hr_utility.set_message(8301, 'GHR_COMPETITIVE_LEVEL_INVALID');
643: -- hr_utility.raise_error;
644: -- END IF;
645: -- hr_utility.set_location(l_proc,30);
646: --
647: -- END IF;
648:
649: END IF;
647: -- END IF;
648:
649: END IF;
650:
651: hr_utility.set_location('Leaving: '|| l_proc, 40);
652:
653: END CHK_COMPETITIVE_LEVEL;
654:
655:
672:
673:
674: BEGIN
675:
676: hr_utility.set_location('Entering: '|| l_proc, 10);
677:
678: -- Check Mandatory Parameters are set
679:
680: hr_api.mandatory_arg_error
702: OR
703: NOT l_api_updating THEN
704:
705: --
706: hr_utility.set_location(l_proc,20);
707: --
708: -- If career ladder is not null then
709: -- Check if the career ladder value exists in fnd_lookups
710: -- Where the look up type is 'YES_NO'
717: p_lookup_type => 'YES_NO',
718: p_lookup_code => p_career_ladder
719: ) THEN
720: -- Error: Invalid career ladder value
721: hr_utility.set_message(8301, 'GHR_CAREER_LADDER_INVALID');
722: hr_utility.raise_error;
723: END IF;
724: ELSE
725: hr_utility.set_message(8301, 'GHR_38636_NULL_CAREER_LADDER');
718: p_lookup_code => p_career_ladder
719: ) THEN
720: -- Error: Invalid career ladder value
721: hr_utility.set_message(8301, 'GHR_CAREER_LADDER_INVALID');
722: hr_utility.raise_error;
723: END IF;
724: ELSE
725: hr_utility.set_message(8301, 'GHR_38636_NULL_CAREER_LADDER');
726: hr_utility.raise_error;
721: hr_utility.set_message(8301, 'GHR_CAREER_LADDER_INVALID');
722: hr_utility.raise_error;
723: END IF;
724: ELSE
725: hr_utility.set_message(8301, 'GHR_38636_NULL_CAREER_LADDER');
726: hr_utility.raise_error;
727:
728: hr_utility.set_location(l_proc,30);
729:
722: hr_utility.raise_error;
723: END IF;
724: ELSE
725: hr_utility.set_message(8301, 'GHR_38636_NULL_CAREER_LADDER');
726: hr_utility.raise_error;
727:
728: hr_utility.set_location(l_proc,30);
729:
730: END IF;
724: ELSE
725: hr_utility.set_message(8301, 'GHR_38636_NULL_CAREER_LADDER');
726: hr_utility.raise_error;
727:
728: hr_utility.set_location(l_proc,30);
729:
730: END IF;
731:
732: END IF;
730: END IF;
731:
732: END IF;
733:
734: hr_utility.set_location('Leaving: '|| l_proc, 40);
735:
736: END CHK_CAREER_LADDER;
737:
738: --
777: BEGIN
778:
779: --
780:
781: hr_utility.set_location('Entering:'|| l_proc,10);
782:
783: --
784: -- Only proceed with the validation if the row exists for
785: -- the current record in the HR schema.
789: (p_position_description_id => p_rec.position_description_id,
790: p_object_version_number => p_rec.object_version_number)
791: THEN
792:
793: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
794: hr_utility.set_message_token('PROCEDURE',l_proc);
795: hr_utility.set_message_token('STEP','20');
796: END IF;
797:
790: p_object_version_number => p_rec.object_version_number)
791: THEN
792:
793: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
794: hr_utility.set_message_token('PROCEDURE',l_proc);
795: hr_utility.set_message_token('STEP','20');
796: END IF;
797:
798: --
791: THEN
792:
793: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
794: hr_utility.set_message_token('PROCEDURE',l_proc);
795: hr_utility.set_message_token('STEP','20');
796: END IF;
797:
798: --
799: hr_utility.set_location (l_proc, 30);
795: hr_utility.set_message_token('STEP','20');
796: END IF;
797:
798: --
799: hr_utility.set_location (l_proc, 30);
800: --
801:
802: /*
803:
822: END IF;
823:
824:
825: --
826: hr_utility.set_location('Leaving :' || l_proc, 40);
827:
828: EXCEPTION
829:
830: WHEN l_error THEN
847: --
848: l_proc varchar2(72) := g_package||'insert_validate';
849: --
850: Begin
851: hr_utility.set_location('Entering:'||l_proc, 5);
852: --
853: -- Set up the CLIENT_INFO
854: --
855: ghr_utility.set_client_info;
851: hr_utility.set_location('Entering:'||l_proc, 5);
852: --
853: -- Set up the CLIENT_INFO
854: --
855: ghr_utility.set_client_info;
856: --
857: -- Call all supporting business operations
858: --
859: --
924: p_effective_date => p_rec.date_from,
925: p_object_version_number => p_rec.object_version_number);
926:
927:
928: hr_utility.set_location(' Leaving:'||l_proc, 10);
929: End insert_validate;
930: --
931: -- ----------------------------------------------------------------------------
932: -- |---------------------------< update_validate >----------------------------|
935: --
936: l_proc varchar2(72) := g_package||'update_validate';
937: --
938: Begin
939: hr_utility.set_location('Entering:'||l_proc, 5);
940: --
941: -- Set up the CLIENT_INFO
942: --
943: ghr_utility.set_client_info;
939: hr_utility.set_location('Entering:'||l_proc, 5);
940: --
941: -- Set up the CLIENT_INFO
942: --
943: ghr_utility.set_client_info;
944: --
945: -- Call all supporting business operations
946: --
947: --
1004: p_position_description_id => p_rec.position_description_id,
1005: p_routing_group_id => p_rec.routing_group_id,
1006: p_effective_date => p_rec.date_from,
1007: p_object_version_number => p_rec.object_version_number);
1008: hr_utility.set_location(' Leaving:'||l_proc, 10);
1009: End update_validate;
1010: --
1011: -- ----------------------------------------------------------------------------
1012: -- |---------------------------< delete_validate >----------------------------|
1015: --
1016: l_proc varchar2(72) := g_package||'delete_validate';
1017: --
1018: Begin
1019: hr_utility.set_location('Entering:'||l_proc, 5);
1020: --
1021: -- Call all supporting business operations
1022: --
1023: hr_utility.set_location(' Leaving:'||l_proc, 10);
1019: hr_utility.set_location('Entering:'||l_proc, 5);
1020: --
1021: -- Call all supporting business operations
1022: --
1023: hr_utility.set_location(' Leaving:'||l_proc, 10);
1024: End delete_validate;
1025: --
1026: end ghr_pdi_bus;