DBA Data[Home] [Help]

APPS.GHR_PDI_BUS dependencies on HR_UTILITY

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

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;

Line 30: hr_utility.set_message(8301, 'GHR_DATE_TO_<_DATE_FROM');

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:

Line 32: hr_utility.raise_error;

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:

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

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

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

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;

Line 98: hr_utility.set_message(8301, 'GHR_38635_INVALID_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);

Line 100: hr_utility.raise_error;

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:

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

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:

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

105: END IF;
106:
107: END IF;
108:
109: hr_utility.set_location('Leaving: '|| l_proc, 40);
110:
111: end chk_category;
112: --
113: ---------------------------------------------------------------

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

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

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

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'

Line 174: hr_utility.set_message(8301, 'GHR_FLSA_CODE_INVALID');

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);

Line 176: hr_utility.raise_error;

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;

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

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;

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

180: END IF;
181:
182: END IF;
183:
184: hr_utility.set_location('Leaving: '|| l_proc, 40);
185:
186: end chk_flsa;
187:
188: --

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

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

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

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'

Line 250: hr_utility.set_message(8301, 'GHR_FINANCIAL_STAT_INVALID');

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;

Line 252: hr_utility.raise_error;

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:

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

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;

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

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:

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

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

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

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'

Line 328: hr_utility.set_message(8301, 'GHR_SUBJECT_TO_IA_INVALID');

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

Line 330: hr_utility.raise_error;

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;

Line 333: hr_utility.set_message(8301, 'GHR_38637_NULL_SUB_IA_ACTION');

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;

Line 334: hr_utility.raise_error;

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:

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

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;

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

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:

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

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

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

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'

Line 408: hr_utility.set_message(8301, 'GHR_POSITION_STATUS_INVALID');

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);

Line 409: hr_utility.raise_error;

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:

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

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;

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

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:

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

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

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

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'

Line 487: hr_utility.set_message(8301, 'GHR_POSITION_IS_VALUE_INVALID');

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:

Line 488: hr_utility.raise_error;

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;

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

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;

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

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:

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

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

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

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'

Line 564: hr_utility.set_message(8301, 'GHR_POS_SENSITIVITY_INVALID');

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:

Line 565: hr_utility.raise_error;

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;

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

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;

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

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:

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

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

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

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'

Line 642: -- hr_utility.set_message(8301, 'GHR_COMPETITIVE_LEVEL_INVALID');

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: --

Line 643: -- hr_utility.raise_error;

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;

Line 645: -- hr_utility.set_location(l_proc,30);

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;

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

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:

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

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

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

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'

Line 721: hr_utility.set_message(8301, 'GHR_CAREER_LADDER_INVALID');

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');

Line 722: hr_utility.raise_error;

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;

Line 725: hr_utility.set_message(8301, 'GHR_38636_NULL_CAREER_LADDER');

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:

Line 726: hr_utility.raise_error;

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;

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

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;

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

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: --

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

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.

Line 793: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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:

Line 794: hr_utility.set_message_token('PROCEDURE',l_proc);

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: --

Line 795: hr_utility.set_message_token('STEP','20');

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);

Line 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:

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

822: END IF;
823:
824:
825: --
826: hr_utility.set_location('Leaving :' || l_proc, 40);
827:
828: EXCEPTION
829:
830: WHEN l_error THEN

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

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;

Line 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: --

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

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 >----------------------------|

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

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;

Line 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: --

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

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 >----------------------------|

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

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);

Line 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;