DBA Data[Home] [Help]

APPS.GHR_CCA_BUS dependencies on HR_UTILITY

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

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

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

73: hr_api.set_security_group_id
74: (p_security_group_id => l_security_group_id
75: );
76: --
77: hr_utility.set_location(' Leaving:'|| l_proc, 20);
78: --
79: end set_security_group_id;
80: --
81: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

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

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := ghr_cca_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

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

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

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

152: close csr_leg_code;
153: ghr_cca_bus.g_compl_appeal_id := p_compl_appeal_id;
154: ghr_cca_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

237:
238:
239: BEGIN
240:
241: hr_utility.set_location('Entering: '|| l_proc, 10);
242:
243: -- Check Mandatory Parameters are set
244:
245: hr_api.mandatory_arg_error

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

267: OR
268: NOT l_api_updating THEN
269:
270: --
271: hr_utility.set_location(l_proc,20);
272: --
273: -- If appealed_to is not null then
274: -- Check if the appealed_to value exists in fnd_lookups
275: -- Where the look up type is 'GHR_US_APPEAL_TO'

Line 290: hr_utility.set_message(8301,'GHR_38707_INV_COMP_APPEAL_TO');

286: -- Error: Invalid Subject to IA Action
287:
288: -- New Message
289:
290: hr_utility.set_message(8301,'GHR_38707_INV_COMP_APPEAL_TO');
291: hr_utility.raise_error;
292: END IF;
293: hr_utility.set_location(l_proc,30);
294:

Line 291: hr_utility.raise_error;

287:
288: -- New Message
289:
290: hr_utility.set_message(8301,'GHR_38707_INV_COMP_APPEAL_TO');
291: hr_utility.raise_error;
292: END IF;
293: hr_utility.set_location(l_proc,30);
294:
295: END IF;

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

289:
290: hr_utility.set_message(8301,'GHR_38707_INV_COMP_APPEAL_TO');
291: hr_utility.raise_error;
292: END IF;
293: hr_utility.set_location(l_proc,30);
294:
295: END IF;
296:
297: END IF;

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

295: END IF;
296:
297: END IF;
298:
299: hr_utility.set_location('Leaving: '|| l_proc, 40);
300:
301: END chk_appealed_to;
302:
303: --

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

317:
318:
319: BEGIN
320:
321: hr_utility.set_location('Entering: '|| l_proc, 10);
322:
323: -- Check Mandatory Parameters are set
324:
325: hr_api.mandatory_arg_error

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

347: OR
348: NOT l_api_updating THEN
349:
350: --
351: hr_utility.set_location(l_proc,20);
352: --
353: -- If reason_for_appeal is not null then
354: -- Check if the reason_for_appeal value exists in fnd_lookups
355: -- Where the look up type is 'GHR_US_APPEAL_REASON'

Line 370: hr_utility.set_message(8301,'GHR_38708_INV_COMP_APPEAL_RESN');

366: -- Error: Invalid Subject to IA Action
367:
368: -- New Message
369:
370: hr_utility.set_message(8301,'GHR_38708_INV_COMP_APPEAL_RESN');
371: hr_utility.raise_error;
372: END IF;
373: hr_utility.set_location(l_proc,30);
374:

Line 371: hr_utility.raise_error;

367:
368: -- New Message
369:
370: hr_utility.set_message(8301,'GHR_38708_INV_COMP_APPEAL_RESN');
371: hr_utility.raise_error;
372: END IF;
373: hr_utility.set_location(l_proc,30);
374:
375: END IF;

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

369:
370: hr_utility.set_message(8301,'GHR_38708_INV_COMP_APPEAL_RESN');
371: hr_utility.raise_error;
372: END IF;
373: hr_utility.set_location(l_proc,30);
374:
375: END IF;
376:
377: END IF;

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

375: END IF;
376:
377: END IF;
378:
379: hr_utility.set_location('Leaving: '|| l_proc, 40);
380:
381: END chk_reason_for_appeal;
382:
383: --

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

402:
403:
404: BEGIN
405:
406: hr_utility.set_location('Entering: '|| l_proc, 10);
407:
408: -- Check Mandatory Parameters are set
409:
410: hr_api.mandatory_arg_error

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

432: OR
433: NOT l_api_updating THEN
434:
435: --
436: hr_utility.set_location(l_proc,20);
437: --
438: -- If decision is not null then
439: -- If appealed_to value = '10' (OFO) then check if the decision value exists in fnd_lookups
440: -- Where the look up type is 'GHR_US_APPEAL_DECISION'

Line 465: hr_utility.set_message(8301,'GHR_38709_INV_COMP_DECISION');

461: -- Error: Invalid Subject to IA Action
462:
463: -- New Message
464:
465: hr_utility.set_message(8301,'GHR_38709_INV_COMP_DECISION');
466: hr_utility.raise_error;
467: END IF;
468: hr_utility.set_location(l_proc,30);
469:

Line 466: hr_utility.raise_error;

462:
463: -- New Message
464:
465: hr_utility.set_message(8301,'GHR_38709_INV_COMP_DECISION');
466: hr_utility.raise_error;
467: END IF;
468: hr_utility.set_location(l_proc,30);
469:
470: END IF;

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

464:
465: hr_utility.set_message(8301,'GHR_38709_INV_COMP_DECISION');
466: hr_utility.raise_error;
467: END IF;
468: hr_utility.set_location(l_proc,30);
469:
470: END IF;
471:
472: END IF;

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

470: END IF;
471:
472: END IF;
473:
474: hr_utility.set_location('Leaving: '|| l_proc, 40);
475:
476: END chk_decision;
477:
478: --

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

492:
493:
494: BEGIN
495:
496: hr_utility.set_location('Entering: '|| l_proc, 10);
497:
498: -- Check Mandatory Parameters are set
499:
500: hr_api.mandatory_arg_error

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

522: OR
523: NOT l_api_updating THEN
524:
525: --
526: hr_utility.set_location(l_proc,20);
527: --
528: -- If rfr_requested_by is not null then
529: -- Check if the rfr_requested_by value exists in fnd_lookups
530: -- Where the look up type is 'GHR_US_REQUESTOR'

Line 545: hr_utility.set_message(8301,'GHR_38711_INV_COMP_REQUESTOR');

541: -- Error: Invalid Subject to IA Action
542:
543: -- New Message
544:
545: hr_utility.set_message(8301,'GHR_38711_INV_COMP_REQUESTOR');
546: hr_utility.raise_error;
547: END IF;
548: hr_utility.set_location(l_proc,30);
549:

Line 546: hr_utility.raise_error;

542:
543: -- New Message
544:
545: hr_utility.set_message(8301,'GHR_38711_INV_COMP_REQUESTOR');
546: hr_utility.raise_error;
547: END IF;
548: hr_utility.set_location(l_proc,30);
549:
550: END IF;

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

544:
545: hr_utility.set_message(8301,'GHR_38711_INV_COMP_REQUESTOR');
546: hr_utility.raise_error;
547: END IF;
548: hr_utility.set_location(l_proc,30);
549:
550: END IF;
551:
552: END IF;

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

550: END IF;
551:
552: END IF;
553:
554: hr_utility.set_location('Leaving: '|| l_proc, 40);
555:
556: END chk_rfr_requested_by;
557:
558: --

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

572:
573:
574: BEGIN
575:
576: hr_utility.set_location('Entering: '|| l_proc, 10);
577:
578: -- Check Mandatory Parameters are set
579:
580: hr_api.mandatory_arg_error

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

602: OR
603: NOT l_api_updating THEN
604:
605: --
606: hr_utility.set_location(l_proc,20);
607: --
608: -- If rfr_decision is not null then
609: -- Check if the rfr_decision value exists in fnd_lookups
610: -- Where the look up type is 'GHR_US_OFO_RFR_DECISION'

Line 625: hr_utility.set_message(8301,'GHR_38710_INV_COMP_OFO_RFR_DES');

621: -- Error: Invalid Subject to IA Action
622:
623: -- New Message
624:
625: hr_utility.set_message(8301,'GHR_38710_INV_COMP_OFO_RFR_DES');
626: hr_utility.raise_error;
627: END IF;
628: hr_utility.set_location(l_proc,30);
629:

Line 626: hr_utility.raise_error;

622:
623: -- New Message
624:
625: hr_utility.set_message(8301,'GHR_38710_INV_COMP_OFO_RFR_DES');
626: hr_utility.raise_error;
627: END IF;
628: hr_utility.set_location(l_proc,30);
629:
630: END IF;

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

624:
625: hr_utility.set_message(8301,'GHR_38710_INV_COMP_OFO_RFR_DES');
626: hr_utility.raise_error;
627: END IF;
628: hr_utility.set_location(l_proc,30);
629:
630: END IF;
631:
632: END IF;

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

630: END IF;
631:
632: END IF;
633:
634: hr_utility.set_location('Leaving: '|| l_proc, 40);
635:
636: END chk_rfr_decision;
637:
638: --

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

646: --
647: l_proc varchar2(72) := g_package||'insert_validate';
648: --
649: Begin
650: hr_utility.set_location('Entering:'||l_proc, 5);
651: --
652: -- Call all supporting business operations
653: --
654: --

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

687: ,p_effective_date => p_effective_date
688: ,p_object_version_number => p_rec.object_version_number);
689:
690:
691: hr_utility.set_location(' Leaving:'||l_proc, 10);
692: End insert_validate;
693: --
694: -- ----------------------------------------------------------------------------
695: -- |---------------------------< update_validate >----------------------------|

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

701: --
702: l_proc varchar2(72) := g_package||'update_validate';
703: --
704: Begin
705: hr_utility.set_location('Entering:'||l_proc, 5);
706: --
707: -- Call all supporting business operations
708: --
709: --

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

746: ,p_effective_date => p_effective_date
747: ,p_object_version_number => p_rec.object_version_number);
748:
749: --
750: hr_utility.set_location(' Leaving:'||l_proc, 10);
751: End update_validate;
752: --
753: -- ----------------------------------------------------------------------------
754: -- |---------------------------< delete_validate >----------------------------|

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

759: --
760: l_proc varchar2(72) := g_package||'delete_validate';
761: --
762: Begin
763: hr_utility.set_location('Entering:'||l_proc, 5);
764: --
765: -- Call all supporting business operations
766: --
767: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

763: hr_utility.set_location('Entering:'||l_proc, 5);
764: --
765: -- Call all supporting business operations
766: --
767: hr_utility.set_location(' Leaving:'||l_proc, 10);
768: End delete_validate;
769: --
770: end ghr_cca_bus;