DBA Data[Home] [Help]

APPS.GHR_CAA_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_caa_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_caa_bus.g_compl_agency_appeal_id := p_compl_agency_appeal_id;
154: ghr_caa_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 242: hr_utility.set_location('Entering: '|| l_proc, 10);

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

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

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

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

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

Line 292: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

Line 373: hr_utility.raise_error;

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

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

371:
372: hr_utility.set_message(8301,'GHR_38709_INV_COMP_DECISION');
373: hr_utility.raise_error;
374: END IF;
375: hr_utility.set_location(l_proc,30);
376:
377: END IF;
378:
379: END IF;

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

377: END IF;
378:
379: END IF;
380:
381: hr_utility.set_location('Leaving: '|| l_proc, 40);
382:
383: END chk_decision;
384:
385: --

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

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

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

429: OR
430: NOT l_api_updating THEN
431:
432: --
433: hr_utility.set_location(l_proc,20);
434: --
435: -- If rfr_requested_by is not null then
436: -- Check if the rfr_requested_by value exists in fnd_lookups
437: -- Where the look up type is 'GHR_US_REQUESTOR'

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

448: -- Error: Invalid Subject to IA Action
449:
450: -- New Message
451:
452: hr_utility.set_message(8301,'GHR_38711_INV_COMP_REQUESTOR');
453: hr_utility.raise_error;
454: END IF;
455: hr_utility.set_location(l_proc,30);
456:

Line 453: hr_utility.raise_error;

449:
450: -- New Message
451:
452: hr_utility.set_message(8301,'GHR_38711_INV_COMP_REQUESTOR');
453: hr_utility.raise_error;
454: END IF;
455: hr_utility.set_location(l_proc,30);
456:
457: END IF;

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

451:
452: hr_utility.set_message(8301,'GHR_38711_INV_COMP_REQUESTOR');
453: hr_utility.raise_error;
454: END IF;
455: hr_utility.set_location(l_proc,30);
456:
457: END IF;
458:
459: END IF;

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

457: END IF;
458:
459: END IF;
460:
461: hr_utility.set_location('Leaving: '|| l_proc, 40);
462:
463: END chk_rfr_requested_by;
464:
465: --

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

479:
480:
481: BEGIN
482:
483: hr_utility.set_location('Entering: '|| l_proc, 10);
484:
485: -- Check Mandatory Parameters are set
486:
487: hr_api.mandatory_arg_error

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

509: OR
510: NOT l_api_updating THEN
511:
512: --
513: hr_utility.set_location(l_proc,20);
514: --
515: -- If rfr_decision is not null then
516: -- Check if the rfr_decision value exists in fnd_lookups
517: -- Where the look up type is 'GHR_US_OFO_RFR_DECISION'

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

528: -- Error: Invalid Subject to IA Action
529:
530: -- New Message
531:
532: hr_utility.set_message(8301,'GHR_38710_INV_COMP_OFO_RFR_DES');
533: hr_utility.raise_error;
534: END IF;
535: hr_utility.set_location(l_proc,30);
536:

Line 533: hr_utility.raise_error;

529:
530: -- New Message
531:
532: hr_utility.set_message(8301,'GHR_38710_INV_COMP_OFO_RFR_DES');
533: hr_utility.raise_error;
534: END IF;
535: hr_utility.set_location(l_proc,30);
536:
537: END IF;

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

531:
532: hr_utility.set_message(8301,'GHR_38710_INV_COMP_OFO_RFR_DES');
533: hr_utility.raise_error;
534: END IF;
535: hr_utility.set_location(l_proc,30);
536:
537: END IF;
538:
539: END IF;

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

537: END IF;
538:
539: END IF;
540:
541: hr_utility.set_location('Leaving: '|| l_proc, 40);
542:
543: END chk_rfr_decision;
544:
545: --

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

553: --
554: l_proc varchar2(72) := g_package||'insert_validate';
555: --
556: Begin
557: hr_utility.set_location('Entering:'||l_proc, 5);
558: --
559: -- Call all supporting business operations
560: --
561: --

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

587: ,p_rfr_decision => p_rec.rfr_decision
588: ,p_effective_date => p_effective_date
589: ,p_object_version_number => p_rec.object_version_number);
590:
591: hr_utility.set_location(' Leaving:'||l_proc, 10);
592: End insert_validate;
593: --
594: -- ----------------------------------------------------------------------------
595: -- |---------------------------< update_validate >----------------------------|

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

601: --
602: l_proc varchar2(72) := g_package||'update_validate';
603: --
604: Begin
605: hr_utility.set_location('Entering:'||l_proc, 5);
606: --
607: -- Call all supporting business operations
608: --
609: --

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

642:
643:
644: --
645: --
646: hr_utility.set_location(' Leaving:'||l_proc, 10);
647: End update_validate;
648: --
649: -- ----------------------------------------------------------------------------
650: -- |---------------------------< delete_validate >----------------------------|

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

655: --
656: l_proc varchar2(72) := g_package||'delete_validate';
657: --
658: Begin
659: hr_utility.set_location('Entering:'||l_proc, 5);
660: --
661: -- Call all supporting business operations
662: --
663: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

659: hr_utility.set_location('Entering:'||l_proc, 5);
660: --
661: -- Call all supporting business operations
662: --
663: hr_utility.set_location(' Leaving:'||l_proc, 10);
664: End delete_validate;
665: --
666: end ghr_caa_bus;