eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BEN_UPDATE_LEDGERS dependencies on HR_UTILITY

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

49:
50: l_datetrack_mode varchar2(30);
51: test_ldgr_id number;
52: BEGIN
53: hr_utility.set_location('Entering '||l_proc, 10);
54:
55: /* new columns being loaded:
56: ACTY_REF_PERD_CD VARCHAR2(30)
57: CMCD_FRFTD_VAL NUMBER

Line 71: hr_utility.set_location('This result is: ', 20);

67: ANN_CASH_RECD_VAL
68: */
69:
70: for l_ldgr in c_ldgr loop
71: hr_utility.set_location('This result is: ', 20);
72:
73: l_acty_ref_perd_cd := null;
74: l_cmcd_ref_perd_cd := null;
75: l_cmcd_frftd_val := null;

Line 122: hr_utility.set_location('Updating ledger. Id='||to_char(l_ldgr.bnft_prvdd_ldgr_id),22);

118: p_mode => l_datetrack_mode);
119: */
120: --
121: --
122: hr_utility.set_location('Updating ledger. Id='||to_char(l_ldgr.bnft_prvdd_ldgr_id),22);
123: begin
124: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
125: p_bnft_prvdd_ldgr_id => l_ldgr.bnft_prvdd_ldgr_id
126: ,p_effective_start_date => l_ldgr.effective_start_date

Line 143: hr_utility.set_location('Updated Ledger. Id='||to_char(l_ldgr.bnft_prvdd_ldgr_id),24);

139: ,p_ann_cash_recd_val => l_ann_cash_recd_val
140: ,p_object_version_number => l_ldgr.object_version_number
141: ,p_effective_date => l_ldgr.effective_start_date
142: ,p_datetrack_mode => 'CORRECTION');
143: hr_utility.set_location('Updated Ledger. Id='||to_char(l_ldgr.bnft_prvdd_ldgr_id),24);
144: exception
145: when others then
146: --continue leaving the errored record
147: null;

Line 153: hr_utility.set_location('Leaving '||l_proc, 999);

149: end if;
150:
151: end loop;
152:
153: hr_utility.set_location('Leaving '||l_proc, 999);
154:
155: END; -- main
156: -- ---------------------------------------------------------------------
157: -- get_cmcd_ann_values

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

344: l_payroll_id per_all_assignments_f.payroll_id%type;
345: l_organization_id per_all_assignments_f.organization_id%type;
346: --END GEVITY
347: begin
348: hr_utility.set_location('Entering '||l_proc, 10);
349: -- init all the out parms
350: p_acty_ref_perd_cd := null;
351: p_cmcd_ref_perd_cd := null;
352: p_cmcd_frftd_val := null;

Line 367: hr_utility.set_location('Have to find out nocopy ledger parms:'||

363: -- When updating ledgers, the api may not get all the parms passed in, hence
364: -- we might not either. Go get the ones we need.
365: if p_prtt_enrt_rslt_id is null or p_acty_base_rt_id is null or
366: p_per_in_ler_id is null or p_business_group_id is null then
367: hr_utility.set_location('Have to find out nocopy ledger parms:'||
368: to_char(p_bnft_prvdd_ldgr_id), 20);
369: open c_ldgr(c_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id,
370: c_effective_date => p_effective_start_date);
371: fetch c_ldgr into l_ldgr;

Line 374: hr_utility.set_location('LEDGER INFO NOT FOUND. LEDGER ID='||

370: c_effective_date => p_effective_start_date);
371: fetch c_ldgr into l_ldgr;
372: if c_ldgr%NOTFOUND or c_ldgr%NOTFOUND is null then
373: -- if we can't find this info, we can't find the data we need.
374: hr_utility.set_location('LEDGER INFO NOT FOUND. LEDGER ID='||
375: to_char(p_bnft_prvdd_ldgr_id)||' DATE='||
376: to_char(p_effective_start_date)||' RESULT ID='||
377: to_char(p_prtt_enrt_rslt_id)||' ',22);
378: close c_ldgr;

Line 382: hr_utility.set_location('Found ledger parms',24);

378: close c_ldgr;
379: return; --<-------------------------------------
380: end if;
381: close c_ldgr;
382: hr_utility.set_location('Found ledger parms',24);
383: end if;
384: if p_prtt_enrt_rslt_id is null then
385: l_ldgr_parms.prtt_enrt_rslt_id := l_ldgr.prtt_enrt_rslt_id;
386: else

Line 406: hr_utility.set_location('rslt:'||to_char(l_ldgr_parms.prtt_enrt_rslt_id), 26);

402: l_ldgr_parms.business_group_id := p_business_group_id;
403: end if;
404:
405: /*
406: hr_utility.set_location('rslt:'||to_char(l_ldgr_parms.prtt_enrt_rslt_id), 26);
407: hr_utility.set_location('rt:'||to_char(l_ldgr_parms.acty_base_rt_id), 26);
408: hr_utility.set_location('pil:'||to_char(l_ldgr_parms.per_in_ler_id), 26);
409: hr_utility.set_location('bg:'||to_char(l_ldgr_parms.business_group_id), 26);
410: hr_utility.set_location('esd:'||to_char(p_effective_start_date), 26);

Line 407: hr_utility.set_location('rt:'||to_char(l_ldgr_parms.acty_base_rt_id), 26);

403: end if;
404:
405: /*
406: hr_utility.set_location('rslt:'||to_char(l_ldgr_parms.prtt_enrt_rslt_id), 26);
407: hr_utility.set_location('rt:'||to_char(l_ldgr_parms.acty_base_rt_id), 26);
408: hr_utility.set_location('pil:'||to_char(l_ldgr_parms.per_in_ler_id), 26);
409: hr_utility.set_location('bg:'||to_char(l_ldgr_parms.business_group_id), 26);
410: hr_utility.set_location('esd:'||to_char(p_effective_start_date), 26);
411: hr_utility.set_location('used:'||to_char(p_used_val), 26);

Line 408: hr_utility.set_location('pil:'||to_char(l_ldgr_parms.per_in_ler_id), 26);

404:
405: /*
406: hr_utility.set_location('rslt:'||to_char(l_ldgr_parms.prtt_enrt_rslt_id), 26);
407: hr_utility.set_location('rt:'||to_char(l_ldgr_parms.acty_base_rt_id), 26);
408: hr_utility.set_location('pil:'||to_char(l_ldgr_parms.per_in_ler_id), 26);
409: hr_utility.set_location('bg:'||to_char(l_ldgr_parms.business_group_id), 26);
410: hr_utility.set_location('esd:'||to_char(p_effective_start_date), 26);
411: hr_utility.set_location('used:'||to_char(p_used_val), 26);
412: */

Line 409: hr_utility.set_location('bg:'||to_char(l_ldgr_parms.business_group_id), 26);

405: /*
406: hr_utility.set_location('rslt:'||to_char(l_ldgr_parms.prtt_enrt_rslt_id), 26);
407: hr_utility.set_location('rt:'||to_char(l_ldgr_parms.acty_base_rt_id), 26);
408: hr_utility.set_location('pil:'||to_char(l_ldgr_parms.per_in_ler_id), 26);
409: hr_utility.set_location('bg:'||to_char(l_ldgr_parms.business_group_id), 26);
410: hr_utility.set_location('esd:'||to_char(p_effective_start_date), 26);
411: hr_utility.set_location('used:'||to_char(p_used_val), 26);
412: */
413:

Line 410: hr_utility.set_location('esd:'||to_char(p_effective_start_date), 26);

406: hr_utility.set_location('rslt:'||to_char(l_ldgr_parms.prtt_enrt_rslt_id), 26);
407: hr_utility.set_location('rt:'||to_char(l_ldgr_parms.acty_base_rt_id), 26);
408: hr_utility.set_location('pil:'||to_char(l_ldgr_parms.per_in_ler_id), 26);
409: hr_utility.set_location('bg:'||to_char(l_ldgr_parms.business_group_id), 26);
410: hr_utility.set_location('esd:'||to_char(p_effective_start_date), 26);
411: hr_utility.set_location('used:'||to_char(p_used_val), 26);
412: */
413:
414: -- get the dummy flex credit result and it's programs ref-perd-cd's.

Line 411: hr_utility.set_location('used:'||to_char(p_used_val), 26);

407: hr_utility.set_location('rt:'||to_char(l_ldgr_parms.acty_base_rt_id), 26);
408: hr_utility.set_location('pil:'||to_char(l_ldgr_parms.per_in_ler_id), 26);
409: hr_utility.set_location('bg:'||to_char(l_ldgr_parms.business_group_id), 26);
410: hr_utility.set_location('esd:'||to_char(p_effective_start_date), 26);
411: hr_utility.set_location('used:'||to_char(p_used_val), 26);
412: */
413:
414: -- get the dummy flex credit result and it's programs ref-perd-cd's.
415: open c_rslt (c_prtt_enrt_rslt_id => l_ldgr_parms.prtt_enrt_rslt_id,

Line 420: hr_utility.set_location('RESULT INFO NOT FOUND. LEDGER ID='||

416: c_effective_date => p_effective_start_date);
417: fetch c_rslt into l_rslt;
418: if c_rslt%NOTFOUND or c_rslt%NOTFOUND is null then
419: close c_rslt;
420: hr_utility.set_location('RESULT INFO NOT FOUND. LEDGER ID='||
421: to_char(p_bnft_prvdd_ldgr_id)||' DATE='||
422: to_char(p_effective_start_date)||' RESULT ID='||
423: to_char(l_ldgr_parms.prtt_enrt_rslt_id)||' ',28);
424: else

Line 427: hr_utility.set_location('person:'||to_char(l_rslt.person_id), 30);

423: to_char(l_ldgr_parms.prtt_enrt_rslt_id)||' ',28);
424: else
425: close c_rslt;
426: /*
427: hr_utility.set_location('person:'||to_char(l_rslt.person_id), 30);
428: hr_utility.set_location('ref prd:'||l_rslt.acty_ref_perd_cd, 30);
429: hr_utility.set_location('cmcd:'||l_rslt.enrt_info_rt_freq_cd, 30);
430: */
431: --GEVITY

Line 428: hr_utility.set_location('ref prd:'||l_rslt.acty_ref_perd_cd, 30);

424: else
425: close c_rslt;
426: /*
427: hr_utility.set_location('person:'||to_char(l_rslt.person_id), 30);
428: hr_utility.set_location('ref prd:'||l_rslt.acty_ref_perd_cd, 30);
429: hr_utility.set_location('cmcd:'||l_rslt.enrt_info_rt_freq_cd, 30);
430: */
431: --GEVITY
432: ben_element_entry.get_abr_assignment

Line 429: hr_utility.set_location('cmcd:'||l_rslt.enrt_info_rt_freq_cd, 30);

425: close c_rslt;
426: /*
427: hr_utility.set_location('person:'||to_char(l_rslt.person_id), 30);
428: hr_utility.set_location('ref prd:'||l_rslt.acty_ref_perd_cd, 30);
429: hr_utility.set_location('cmcd:'||l_rslt.enrt_info_rt_freq_cd, 30);
430: */
431: --GEVITY
432: ben_element_entry.get_abr_assignment
433: (p_person_id => l_rslt.person_id

Line 454: hr_utility.set_location('Forfeited Row: '||l_ldgr_parms.prtt_enrt_rslt_id, 32);

450: -- ---------------------------------------------------------------------
451: -- Forfeited values
452: -- ---------------------------------------------------------------------
453: if p_frftd_val is not null then
454: hr_utility.set_location('Forfeited Row: '||l_ldgr_parms.prtt_enrt_rslt_id, 32);
455: if p_frftd_val = 0 then
456: p_ann_frftd_val := 0;
457: p_cmcd_frftd_val := 0;
458: else

Line 472: hr_utility.set_location('FORFEITED RATE INFO NOT FOUND. LEDGER ID='||

468: c_effective_date => p_effective_start_date);
469: fetch c_choice_data into l_choice_data;
470: if c_choice_data%NOTFOUND or c_choice_data%NOTFOUND is null then
471: close c_choice_data;
472: hr_utility.set_location('FORFEITED RATE INFO NOT FOUND. LEDGER ID='||
473: to_char(p_bnft_prvdd_ldgr_id)||' DATE='||
474: to_char(p_effective_start_date)||' RESULT ID='||
475: to_char(l_ldgr_parms.prtt_enrt_rslt_id),34);
476: else

Line 486: hr_utility.set_location('FORFEITED PERSON INFO NOT FOUND. LEDGER ID='||

482: c_effective_date => p_effective_start_date);
483: fetch c_person into l_person;
484: if c_person%NOTFOUND or c_person%NOTFOUND is null then
485: close c_person;
486: hr_utility.set_location('FORFEITED PERSON INFO NOT FOUND. LEDGER ID='||
487: to_char(p_bnft_prvdd_ldgr_id)||' DATE='||
488: to_char(p_effective_start_date)||' RESULT ID='||
489: to_char(l_ldgr_parms.prtt_enrt_rslt_id),36);
490: else

Line 513: hr_utility.set_location('Forfeited Row: Calling Distribute Rates', 38);

509: ,p_val => l_dfnd_dummy
510: );
511: --
512: ELSE
513: hr_utility.set_location('Forfeited Row: Calling Distribute Rates', 38);
514: p_ann_frftd_val := ben_distribute_rates.period_to_annual(
515: p_amount => p_frftd_val,
516: p_enrt_rt_id => l_choice_data.enrt_rt_id,
517: p_elig_per_elctbl_chc_id => l_choice_data.elig_per_elctbl_chc_id,

Line 534: hr_utility.set_location('frftd l_flex_shell_rt.enrt_rt_id'||l_flex_shell_rt.enrt_rt_id,99);

530: l_rslt.pgm_id);
531: fetch get_flex_shell_rt into l_flex_shell_rt;
532: if get_flex_shell_rt%FOUND then
533: close get_flex_shell_rt;
534: hr_utility.set_location('frftd l_flex_shell_rt.enrt_rt_id'||l_flex_shell_rt.enrt_rt_id,99);
535: hr_utility.set_location('frftd l_flex_shell_rt.element_type_id'||l_flex_shell_rt.element_type_id,99);
536: hr_utility.set_location('frftd l_flex_shell_rt.acty_base_rt_id'||l_flex_shell_rt.acty_base_rt_id,99);
537: p_cmcd_frftd_val := ben_distribute_rates.annual_to_period(
538: p_amount => p_ann_frftd_val,

Line 535: hr_utility.set_location('frftd l_flex_shell_rt.element_type_id'||l_flex_shell_rt.element_type_id,99);

531: fetch get_flex_shell_rt into l_flex_shell_rt;
532: if get_flex_shell_rt%FOUND then
533: close get_flex_shell_rt;
534: hr_utility.set_location('frftd l_flex_shell_rt.enrt_rt_id'||l_flex_shell_rt.enrt_rt_id,99);
535: hr_utility.set_location('frftd l_flex_shell_rt.element_type_id'||l_flex_shell_rt.element_type_id,99);
536: hr_utility.set_location('frftd l_flex_shell_rt.acty_base_rt_id'||l_flex_shell_rt.acty_base_rt_id,99);
537: p_cmcd_frftd_val := ben_distribute_rates.annual_to_period(
538: p_amount => p_ann_frftd_val,
539: p_enrt_rt_id => l_flex_shell_rt.enrt_rt_id,

Line 536: hr_utility.set_location('frftd l_flex_shell_rt.acty_base_rt_id'||l_flex_shell_rt.acty_base_rt_id,99);

532: if get_flex_shell_rt%FOUND then
533: close get_flex_shell_rt;
534: hr_utility.set_location('frftd l_flex_shell_rt.enrt_rt_id'||l_flex_shell_rt.enrt_rt_id,99);
535: hr_utility.set_location('frftd l_flex_shell_rt.element_type_id'||l_flex_shell_rt.element_type_id,99);
536: hr_utility.set_location('frftd l_flex_shell_rt.acty_base_rt_id'||l_flex_shell_rt.acty_base_rt_id,99);
537: p_cmcd_frftd_val := ben_distribute_rates.annual_to_period(
538: p_amount => p_ann_frftd_val,
539: p_enrt_rt_id => l_flex_shell_rt.enrt_rt_id,
540: p_elig_per_elctbl_chc_id => l_flex_shell_rt.elig_per_elctbl_chc_id,

Line 572: hr_utility.set_location('Used Row: '||l_ldgr_parms.prtt_enrt_rslt_id, 40);

568: -- ---------------------------------------------------------------------
569: -- Used values
570: -- ---------------------------------------------------------------------
571: elsif p_used_val is not null then
572: hr_utility.set_location('Used Row: '||l_ldgr_parms.prtt_enrt_rslt_id, 40);
573: -- used val's are complex, must get communicated and annual values from
574: -- the prtt-rt-val table. They must have been put there by the enrollment
575: -- process, otherwise we can't get them. If rates are overridden, the user
576: -- must have provided the cmcd and ann vals to prtt-rt too.

Line 604: hr_utility.set_location('USED CHOICE INFO NOT FOUND. LEDGER ID='||

600: c_effective_date => p_effective_start_date);
601: fetch c_choice_data into l_choice_data;
602: if c_choice_data%NOTFOUND or c_choice_data%NOTFOUND is null then
603: close c_choice_data;
604: hr_utility.set_location('USED CHOICE INFO NOT FOUND. LEDGER ID='||
605: to_char(p_bnft_prvdd_ldgr_id)||' DATE='||
606: to_char(p_effective_start_date)||' RESULT ID='||
607: to_char(l_ldgr_parms.prtt_enrt_rslt_id),42);
608: else

Line 617: hr_utility.set_location('USED PERSON INFO NOT FOUND. LEDGER ID='||

613: c_effective_date => p_effective_start_date);
614: fetch c_person into l_person;
615: if c_person%NOTFOUND or c_person%NOTFOUND is null then
616: close c_person;
617: hr_utility.set_location('USED PERSON INFO NOT FOUND. LEDGER ID='||
618: to_char(p_bnft_prvdd_ldgr_id)||' DATE='||
619: to_char(p_effective_start_date)||' RESULT ID='||
620: to_char(l_ldgr_parms.prtt_enrt_rslt_id),44);
621: else

Line 625: hr_utility.set_location('Forfeited Row: Calling Distribute Rates', 46);

621: else
622: close c_person;
623: */
624: if l_payroll_id IS NOT NULL THEN
625: hr_utility.set_location('Forfeited Row: Calling Distribute Rates', 46);
626: IF l_rate_periodization_rl IS NOT NULL THEN
627: --
628: --
629: ben_distribute_rates.periodize_with_rule

Line 669: hr_utility.set_location('USED RATE ANN OR CMCD NOT FOUND. LEDGER ID='||

665: p_complete_year_flag => 'Y');
666: END IF; --GEVITY
667: --
668: if p_ann_used_val is null or p_cmcd_used_val is null then
669: hr_utility.set_location('USED RATE ANN OR CMCD NOT FOUND. LEDGER ID='||
670: to_char(p_bnft_prvdd_ldgr_id)||' DATE='||
671: to_char(p_effective_start_date)||' RESULT ID='||
672: to_char(l_ldgr_parms.prtt_enrt_rslt_id),48);
673: end if;

Line 682: hr_utility.set_location('ann:'||to_char(p_ann_used_val), 50);

678: close c_used_rate;
679: p_ann_used_val := l_used_rate.ann_rt_val;
680: p_cmcd_used_val := l_used_rate.cmcd_rt_val;
681: /*
682: hr_utility.set_location('ann:'||to_char(p_ann_used_val), 50);
683: hr_utility.set_location('cmcd:'||to_char(p_cmcd_used_val), 50);
684: */
685: if p_ann_used_val is null or p_cmcd_used_val is null then
686: hr_utility.set_location('USED RATE ANN OR CMCD NOT FOUND. LEDGER ID='||

Line 683: hr_utility.set_location('cmcd:'||to_char(p_cmcd_used_val), 50);

679: p_ann_used_val := l_used_rate.ann_rt_val;
680: p_cmcd_used_val := l_used_rate.cmcd_rt_val;
681: /*
682: hr_utility.set_location('ann:'||to_char(p_ann_used_val), 50);
683: hr_utility.set_location('cmcd:'||to_char(p_cmcd_used_val), 50);
684: */
685: if p_ann_used_val is null or p_cmcd_used_val is null then
686: hr_utility.set_location('USED RATE ANN OR CMCD NOT FOUND. LEDGER ID='||
687: to_char(p_bnft_prvdd_ldgr_id)||' DATE='||

Line 686: hr_utility.set_location('USED RATE ANN OR CMCD NOT FOUND. LEDGER ID='||

682: hr_utility.set_location('ann:'||to_char(p_ann_used_val), 50);
683: hr_utility.set_location('cmcd:'||to_char(p_cmcd_used_val), 50);
684: */
685: if p_ann_used_val is null or p_cmcd_used_val is null then
686: hr_utility.set_location('USED RATE ANN OR CMCD NOT FOUND. LEDGER ID='||
687: to_char(p_bnft_prvdd_ldgr_id)||' DATE='||
688: to_char(p_effective_start_date)||' RESULT ID='||
689: to_char(l_ldgr_parms.prtt_enrt_rslt_id),52);
690: end if;

Line 697: hr_utility.set_location('Provided Row: '||l_ldgr_parms.prtt_enrt_rslt_id, 54);

693: -- ---------------------------------------------------------------------
694: -- Provided values
695: -- ---------------------------------------------------------------------
696: elsif p_prvdd_val is not null then
697: hr_utility.set_location('Provided Row: '||l_ldgr_parms.prtt_enrt_rslt_id, 54);
698: if p_used_val = 0 then
699: p_ann_used_val := 0;
700: p_cmcd_used_val := 0;
701: else

Line 724: hr_utility.set_location('PRVDD RATE INFO NOT FOUND. LEDGER ID='||

720: c_prvdd_val => p_prvdd_val);
721: fetch c_prvdd_rate2 into l_prvdd_rate2;
722: if c_prvdd_rate2%NOTFOUND or c_prvdd_rate2%NOTFOUND is null then
723: close c_prvdd_rate2;
724: hr_utility.set_location('PRVDD RATE INFO NOT FOUND. LEDGER ID='||
725: to_char(p_bnft_prvdd_ldgr_id)||' DATE='||
726: to_char(p_effective_start_date)||' RESULT ID='||
727: to_char(l_ldgr_parms.prtt_enrt_rslt_id),56);
728: else

Line 744: hr_utility.set_location('Cash Row: '||l_ldgr_parms.prtt_enrt_rslt_id, 58);

740: -----------------------------------------------------------------------
741: -- Cash values
742: -- ---------------------------------------------------------------------
743: elsif p_cash_recd_val is not null then
744: hr_utility.set_location('Cash Row: '||l_ldgr_parms.prtt_enrt_rslt_id, 58);
745: if p_cash_recd_val = 0 then
746: p_ann_cash_recd_val := 0;
747: p_cmcd_cash_recd_val := 0;
748: else

Line 762: hr_utility.set_location('CASH RATE INFO NOT FOUND. LEDGER ID='||

758: c_effective_date => p_effective_start_date);
759: fetch c_choice_data into l_choice_data;
760: if c_choice_data%NOTFOUND or c_choice_data%NOTFOUND is null then
761: close c_choice_data;
762: hr_utility.set_location('CASH RATE INFO NOT FOUND. LEDGER ID='||
763: to_char(p_bnft_prvdd_ldgr_id)||' DATE='||
764: to_char(p_effective_start_date)||' RESULT ID='||
765: to_char(l_ldgr_parms.prtt_enrt_rslt_id),60);
766: else

Line 775: hr_utility.set_location('CASH PERSON INFO NOT FOUND. LEDGER ID='||

771: c_effective_date => p_effective_start_date);
772: fetch c_person into l_person;
773: if c_person%NOTFOUND or c_person%NOTFOUND is null then
774: close c_person;
775: hr_utility.set_location('CASH PERSON INFO NOT FOUND. LEDGER ID='||
776: to_char(p_bnft_prvdd_ldgr_id)||' DATE='||
777: to_char(p_effective_start_date)||' RESULT ID='||
778: to_char(l_ldgr_parms.prtt_enrt_rslt_id),62);
779: else

Line 783: hr_utility.set_location('Cash Row: Calling Distribute Rates', 64);

779: else
780: close c_person;
781: */
782: if l_payroll_id IS NOT NULL THEN
783: hr_utility.set_location('Cash Row: Calling Distribute Rates', 64);
784: IF l_rate_periodization_rl IS NOT NULL THEN
785: --
786: --
787: ben_distribute_rates.periodize_with_rule

Line 823: hr_utility.set_location('cash l_flex_shell_rt.enrt_rt_id'||l_flex_shell_rt.enrt_rt_id,99);

819: l_rslt.pgm_id);
820: fetch get_flex_shell_rt into l_flex_shell_rt;
821: if get_flex_shell_rt%FOUND then
822: close get_flex_shell_rt;
823: hr_utility.set_location('cash l_flex_shell_rt.enrt_rt_id'||l_flex_shell_rt.enrt_rt_id,99);
824: hr_utility.set_location('cash l_flex_shell_rt.element_type_id'||l_flex_shell_rt.element_type_id,99);
825: hr_utility.set_location('cash l_flex_shell_rt.acty_base_rt_id'||l_flex_shell_rt.acty_base_rt_id,99);
826: p_cmcd_cash_recd_val := ben_distribute_rates.annual_to_period(
827: p_amount => p_ann_cash_recd_val,

Line 824: hr_utility.set_location('cash l_flex_shell_rt.element_type_id'||l_flex_shell_rt.element_type_id,99);

820: fetch get_flex_shell_rt into l_flex_shell_rt;
821: if get_flex_shell_rt%FOUND then
822: close get_flex_shell_rt;
823: hr_utility.set_location('cash l_flex_shell_rt.enrt_rt_id'||l_flex_shell_rt.enrt_rt_id,99);
824: hr_utility.set_location('cash l_flex_shell_rt.element_type_id'||l_flex_shell_rt.element_type_id,99);
825: hr_utility.set_location('cash l_flex_shell_rt.acty_base_rt_id'||l_flex_shell_rt.acty_base_rt_id,99);
826: p_cmcd_cash_recd_val := ben_distribute_rates.annual_to_period(
827: p_amount => p_ann_cash_recd_val,
828: p_enrt_rt_id => l_flex_shell_rt.enrt_rt_id,

Line 825: hr_utility.set_location('cash l_flex_shell_rt.acty_base_rt_id'||l_flex_shell_rt.acty_base_rt_id,99);

821: if get_flex_shell_rt%FOUND then
822: close get_flex_shell_rt;
823: hr_utility.set_location('cash l_flex_shell_rt.enrt_rt_id'||l_flex_shell_rt.enrt_rt_id,99);
824: hr_utility.set_location('cash l_flex_shell_rt.element_type_id'||l_flex_shell_rt.element_type_id,99);
825: hr_utility.set_location('cash l_flex_shell_rt.acty_base_rt_id'||l_flex_shell_rt.acty_base_rt_id,99);
826: p_cmcd_cash_recd_val := ben_distribute_rates.annual_to_period(
827: p_amount => p_ann_cash_recd_val,
828: p_enrt_rt_id => l_flex_shell_rt.enrt_rt_id,
829: p_elig_per_elctbl_chc_id => l_flex_shell_rt.elig_per_elctbl_chc_id,

Line 868: hr_utility.set_location('Leaving '||l_proc, 999);

864: null;
865: end if; -- end of 'if' for the various val columns
866: end if; -- end of 'if' for getting result table data
867:
868: hr_utility.set_location('Leaving '||l_proc, 999);
869: end; -- get_cmcd_ann_values
870: -- ---------------------------------------------------------------------
871: -- get_dt_mode
872: -- ---------------------------------------------------------------------

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

881: l_update_override boolean := FALSE;
882: l_update_change_insert boolean := FALSE;
883: --
884: begin
885: hr_utility.set_location('Entering '||l_proc, 10);
886: --
887: -- Get the appropriate update mode.
888: --
889: DT_Api.Find_DT_Upd_Modes(p_effective_date => p_effective_date,

Line 903: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

899: p_mode := 'UPDATE_OVERRIDE';
900: elsif l_correction then
901: p_mode := 'CORRECTION';
902: else
903: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
904: hr_utility.raise_error;
905: end if;
906: hr_utility.set_location('Leaving '||l_proc, 999);
907: end; -- get_dt_mode

Line 904: hr_utility.raise_error;

900: elsif l_correction then
901: p_mode := 'CORRECTION';
902: else
903: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
904: hr_utility.raise_error;
905: end if;
906: hr_utility.set_location('Leaving '||l_proc, 999);
907: end; -- get_dt_mode
908: end ben_update_ledgers;

Line 906: hr_utility.set_location('Leaving '||l_proc, 999);

902: else
903: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
904: hr_utility.raise_error;
905: end if;
906: hr_utility.set_location('Leaving '||l_proc, 999);
907: end; -- get_dt_mode
908: end ben_update_ledgers;