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.

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 363: hr_utility.set_location('stee p_prtt_enrt_rslt_id '||p_prtt_enrt_rslt_id, 10);

359: p_ann_rld_up_val := null;
360: p_ann_used_val := null;
361: p_ann_cash_recd_val := null;
362: --
363: hr_utility.set_location('stee p_prtt_enrt_rslt_id '||p_prtt_enrt_rslt_id, 10);
364: hr_utility.set_location('stee p_acty_base_rt_id '||p_acty_base_rt_id, 10);
365: hr_utility.set_location('stee p_per_in_ler_id '||p_per_in_ler_id, 10);
366: --
367: -- When updating ledgers, the api may not get all the parms passed in, hence

Line 364: hr_utility.set_location('stee p_acty_base_rt_id '||p_acty_base_rt_id, 10);

360: p_ann_used_val := null;
361: p_ann_cash_recd_val := null;
362: --
363: hr_utility.set_location('stee p_prtt_enrt_rslt_id '||p_prtt_enrt_rslt_id, 10);
364: hr_utility.set_location('stee p_acty_base_rt_id '||p_acty_base_rt_id, 10);
365: hr_utility.set_location('stee p_per_in_ler_id '||p_per_in_ler_id, 10);
366: --
367: -- When updating ledgers, the api may not get all the parms passed in, hence
368: -- we might not either. Go get the ones we need.

Line 365: hr_utility.set_location('stee p_per_in_ler_id '||p_per_in_ler_id, 10);

361: p_ann_cash_recd_val := null;
362: --
363: hr_utility.set_location('stee p_prtt_enrt_rslt_id '||p_prtt_enrt_rslt_id, 10);
364: hr_utility.set_location('stee p_acty_base_rt_id '||p_acty_base_rt_id, 10);
365: hr_utility.set_location('stee p_per_in_ler_id '||p_per_in_ler_id, 10);
366: --
367: -- When updating ledgers, the api may not get all the parms passed in, hence
368: -- we might not either. Go get the ones we need.
369: if p_prtt_enrt_rslt_id is null or p_acty_base_rt_id is null or

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

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

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

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

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

382: close c_ldgr;
383: return; --<-------------------------------------
384: end if;
385: close c_ldgr;
386: hr_utility.set_location('Found ledger parms',24);
387: hr_utility.set_location('stee l_ldgr.acty_base_rt_id '||l_ldgr.acty_base_rt_id,24);
388: end if;
389: if p_prtt_enrt_rslt_id is null then
390: l_ldgr_parms.prtt_enrt_rslt_id := l_ldgr.prtt_enrt_rslt_id;

Line 387: hr_utility.set_location('stee l_ldgr.acty_base_rt_id '||l_ldgr.acty_base_rt_id,24);

383: return; --<-------------------------------------
384: end if;
385: close c_ldgr;
386: hr_utility.set_location('Found ledger parms',24);
387: hr_utility.set_location('stee l_ldgr.acty_base_rt_id '||l_ldgr.acty_base_rt_id,24);
388: end if;
389: if p_prtt_enrt_rslt_id is null then
390: l_ldgr_parms.prtt_enrt_rslt_id := l_ldgr.prtt_enrt_rslt_id;
391: else

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

406: else
407: l_ldgr_parms.business_group_id := p_business_group_id;
408: end if;
409:
410: hr_utility.set_location('rslt:'||to_char(l_ldgr_parms.prtt_enrt_rslt_id), 26);
411: hr_utility.set_location('rt:'||to_char(l_ldgr_parms.acty_base_rt_id), 26);
412: hr_utility.set_location('pil:'||to_char(l_ldgr_parms.per_in_ler_id), 26);
413: hr_utility.set_location('bg:'||to_char(l_ldgr_parms.business_group_id), 26);
414: hr_utility.set_location('esd:'||to_char(p_effective_start_date), 26);

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

407: l_ldgr_parms.business_group_id := p_business_group_id;
408: end if;
409:
410: hr_utility.set_location('rslt:'||to_char(l_ldgr_parms.prtt_enrt_rslt_id), 26);
411: hr_utility.set_location('rt:'||to_char(l_ldgr_parms.acty_base_rt_id), 26);
412: hr_utility.set_location('pil:'||to_char(l_ldgr_parms.per_in_ler_id), 26);
413: hr_utility.set_location('bg:'||to_char(l_ldgr_parms.business_group_id), 26);
414: hr_utility.set_location('esd:'||to_char(p_effective_start_date), 26);
415: hr_utility.set_location('used:'||to_char(p_used_val), 26);

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

408: end if;
409:
410: hr_utility.set_location('rslt:'||to_char(l_ldgr_parms.prtt_enrt_rslt_id), 26);
411: hr_utility.set_location('rt:'||to_char(l_ldgr_parms.acty_base_rt_id), 26);
412: hr_utility.set_location('pil:'||to_char(l_ldgr_parms.per_in_ler_id), 26);
413: hr_utility.set_location('bg:'||to_char(l_ldgr_parms.business_group_id), 26);
414: hr_utility.set_location('esd:'||to_char(p_effective_start_date), 26);
415: hr_utility.set_location('used:'||to_char(p_used_val), 26);
416:

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

409:
410: hr_utility.set_location('rslt:'||to_char(l_ldgr_parms.prtt_enrt_rslt_id), 26);
411: hr_utility.set_location('rt:'||to_char(l_ldgr_parms.acty_base_rt_id), 26);
412: hr_utility.set_location('pil:'||to_char(l_ldgr_parms.per_in_ler_id), 26);
413: hr_utility.set_location('bg:'||to_char(l_ldgr_parms.business_group_id), 26);
414: hr_utility.set_location('esd:'||to_char(p_effective_start_date), 26);
415: hr_utility.set_location('used:'||to_char(p_used_val), 26);
416:
417:

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

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

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

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

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

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

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

427: to_char(l_ldgr_parms.prtt_enrt_rslt_id)||' ',28);
428: else
429: close c_rslt;
430:
431: hr_utility.set_location('person:'||to_char(l_rslt.person_id), 30);
432: hr_utility.set_location('ref prd:'||l_rslt.acty_ref_perd_cd, 30);
433: hr_utility.set_location('cmcd:'||l_rslt.enrt_info_rt_freq_cd, 30);
434:
435: --GEVITY

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

428: else
429: close c_rslt;
430:
431: hr_utility.set_location('person:'||to_char(l_rslt.person_id), 30);
432: hr_utility.set_location('ref prd:'||l_rslt.acty_ref_perd_cd, 30);
433: hr_utility.set_location('cmcd:'||l_rslt.enrt_info_rt_freq_cd, 30);
434:
435: --GEVITY
436: ben_element_entry.get_abr_assignment

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

429: close c_rslt;
430:
431: hr_utility.set_location('person:'||to_char(l_rslt.person_id), 30);
432: hr_utility.set_location('ref prd:'||l_rslt.acty_ref_perd_cd, 30);
433: hr_utility.set_location('cmcd:'||l_rslt.enrt_info_rt_freq_cd, 30);
434:
435: --GEVITY
436: ben_element_entry.get_abr_assignment
437: (p_person_id => l_rslt.person_id

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 908: hr_utility.raise_error;

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

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

906: else
907: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
908: hr_utility.raise_error;
909: end if;
910: hr_utility.set_location('Leaving '||l_proc, 999);
911: end; -- get_dt_mode
912: end ben_update_ledgers;