DBA Data[Home] [Help]

APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on HR_UTILITY

Line 245: hr_utility.set_location ('Entering '||l_proc,05);

241: l_id Number;
242: l_OVN1 varchar2(240);
243: l_actn_cd varchar2(30);
244: Begin
245: hr_utility.set_location ('Entering '||l_proc,05);
246: l_actn := 'Starting...';
247: If (p_error) then
248: If (p_audit_log = 'Y') then
249: l_category := 'ERROR_C';

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

338: End loop;
339: End if;
340: End loop;
341: End if;
342: hr_utility.set_location ('Leaving '||l_proc,10);
343: Exception
344: When others then
345: ben_batch_utils.rpt_error(p_proc => l_proc
346: ,p_last_actn => l_actn

Line 364: hr_utility.set_location ('Entering '||l_proc,05);

360: l_proc varchar2(80) := g_package||'.submit_all_reports';
361: l_actn varchar2(80);
362: l_request_id number;
363: Begin
364: hr_utility.set_location ('Entering '||l_proc,05);
365: If fnd_global.conc_request_id <> -1 then
366: l_actn := 'Calling ben_batch_utils.batch_report (BENDFAUD)...';
367: If (p_audit_log = 'Y') then
368: ben_batch_utils.batch_report

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

393: ,p_subtitle =>
394: 'ERROR DETAIL BY PERSON'
395: );
396: End if;
397: hr_utility.set_location ('Leaving '||l_proc,10);
398: Exception
399: When others then
400: ben_batch_utils.rpt_error(p_proc => l_proc
401: ,p_last_actn => l_actn

Line 474: hr_utility.set_location ('Entering '||l_proc,05);

470: l_commit number;
471: --
472: Begin
473: --
474: hr_utility.set_location ('Entering '||l_proc,05);
475: --
476: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
477: --
478: -- Put row in fnd_sessions

Line 624: hr_utility.set_location ('Leaving '||l_proc,70);

620: l_actn := 'Calling Log_beneadeb_statistics...';
621: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd
622: ,p_num_pers_errored => g_persons_errored
623: );
624: hr_utility.set_location ('Leaving '||l_proc,70);
625: Exception
626: When others then
627: ben_batch_utils.rpt_error(p_proc => l_proc
628: ,p_last_actn => l_actn

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

680: l_errbuf varchar2(80);
681: l_retcode number;
682: l_actn varchar2(80);
683: Begin
684: hr_utility.set_location ('Entering '||l_proc,10);
685: --
686: -- get the parameters for a previous run and do a restart
687: --
688: l_actn := 'Getting parameter data...';

Line 723: hr_utility.set_location ('Leaving '||l_proc,70);

719: ,p_payroll_id => l_parameters.payroll_id
720: ,p_debug_messages => l_parameters.debug_messages_flag
721: ,p_audit_log => l_parameters.audit_log_flag
722: );
723: hr_utility.set_location ('Leaving '||l_proc,70);
724: Exception
725: when others then
726: ben_batch_utils.rpt_error(p_proc => l_proc
727: ,p_last_actn => l_actn

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

905: l_silent_error exception;
906: --
907: Begin
908: --
909: hr_utility.set_location ('Entering '||l_proc,10);
910: -- Bug 5857493
911: if p_audit_log ='Y' then
912: ben_batch_utils.g_audit_flag := true;
913: else

Line 1271: hr_utility.set_location ('Leaving '||l_proc,70);

1267: --
1268: l_actn := 'Calling submit_all_reports...';
1269: submit_all_reports(p_audit_log => p_audit_log);
1270: --
1271: hr_utility.set_location ('Leaving '||l_proc,70);
1272: --
1273: Exception
1274: --
1275: when l_silent_error then

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

1550: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type; -- 4684991
1551: l_rdefault_table_cnt number;
1552:
1553: Begin
1554: hr_utility.set_location ('Entering '|| l_proc , 5);
1555:
1556: l_actn := 'Openning c_dflt_mn_epe cursor...';
1557: hr_utility.set_location (l_actn , 10);
1558: p_susp_flag := FALSE;

Line 1557: hr_utility.set_location (l_actn , 10);

1553: Begin
1554: hr_utility.set_location ('Entering '|| l_proc , 5);
1555:
1556: l_actn := 'Openning c_dflt_mn_epe cursor...';
1557: hr_utility.set_location (l_actn , 10);
1558: p_susp_flag := FALSE;
1559:
1560: -- Bug - 4684991 - Fetch pil details
1561: ben_global_enrt.get_pil

Line 1571: --hr_utility.set_location (l_actn , 11);

1567: --
1568: --
1569:
1570: For l_rec in c_dflt_mn_epe loop
1571: --hr_utility.set_location (l_actn , 11);
1572: hr_utility.set_location ('l_rec.prtt_enrt_rslt_id '|| l_rec.prtt_enrt_rslt_id , 5);
1573: open c_test(l_rec.prtt_enrt_rslt_id);
1574: fetch c_test into l_test;
1575: hr_utility.set_location ('l_test '|| l_test , 5);

Line 1572: hr_utility.set_location ('l_rec.prtt_enrt_rslt_id '|| l_rec.prtt_enrt_rslt_id , 5);

1568: --
1569:
1570: For l_rec in c_dflt_mn_epe loop
1571: --hr_utility.set_location (l_actn , 11);
1572: hr_utility.set_location ('l_rec.prtt_enrt_rslt_id '|| l_rec.prtt_enrt_rslt_id , 5);
1573: open c_test(l_rec.prtt_enrt_rslt_id);
1574: fetch c_test into l_test;
1575: hr_utility.set_location ('l_test '|| l_test , 5);
1576: close c_test;

Line 1575: hr_utility.set_location ('l_test '|| l_test , 5);

1571: --hr_utility.set_location (l_actn , 11);
1572: hr_utility.set_location ('l_rec.prtt_enrt_rslt_id '|| l_rec.prtt_enrt_rslt_id , 5);
1573: open c_test(l_rec.prtt_enrt_rslt_id);
1574: fetch c_test into l_test;
1575: hr_utility.set_location ('l_test '|| l_test , 5);
1576: close c_test;
1577:
1578: If (l_prev_pgm_id = -999999) then
1579: NULL;

Line 1585: --hr_utility.set_location (l_actn||' First ', 12 );

1581: For l_rec1 in c_dflt_mn_epe_mndtry(c_pgm_id => l_prev_pgm_id
1582: ,c_pl_id => l_prev_pl_id ) loop
1583: l_epe_cnt := l_epe_cnt + 1;
1584: l_epe(l_epe_cnt) := l_rec1;
1585: --hr_utility.set_location (l_actn||' First ', 12 );
1586: End loop;
1587: Elsif (l_prev_pl_id <> l_rec.pl_id) then
1588: For l_rec1 in c_dflt_mn_epe_mndtry(c_pgm_id => l_prev_pgm_id
1589: ,c_pl_id => l_prev_pl_id ) loop

Line 1592: --hr_utility.set_location (l_actn||' Second ', 12 );

1588: For l_rec1 in c_dflt_mn_epe_mndtry(c_pgm_id => l_prev_pgm_id
1589: ,c_pl_id => l_prev_pl_id ) loop
1590: l_epe_cnt := l_epe_cnt + 1;
1591: l_epe(l_epe_cnt) := l_rec1;
1592: --hr_utility.set_location (l_actn||' Second ', 12 );
1593: End loop;
1594: End if;
1595: --hr_utility.set_location (l_actn||'Outside ', 13);
1596: l_epe_cnt := l_epe_cnt + 1;

Line 1595: --hr_utility.set_location (l_actn||'Outside ', 13);

1591: l_epe(l_epe_cnt) := l_rec1;
1592: --hr_utility.set_location (l_actn||' Second ', 12 );
1593: End loop;
1594: End if;
1595: --hr_utility.set_location (l_actn||'Outside ', 13);
1596: l_epe_cnt := l_epe_cnt + 1;
1597: l_epe(l_epe_cnt) := l_rec;
1598: l_prev_pgm_id := l_rec.pgm_id;
1599: l_prev_pl_id := l_rec.pl_id;

Line 1602: --hr_utility.set_location ('Last loop '||l_actn , 15);

1598: l_prev_pgm_id := l_rec.pgm_id;
1599: l_prev_pl_id := l_rec.pl_id;
1600: End loop;
1601: --
1602: --hr_utility.set_location ('Last loop '||l_actn , 15);
1603: -- Last loop
1604: --
1605: If l_epe_cnt > 0 then
1606: For l_rec1 in c_dflt_mn_epe_mndtry(c_pgm_id => l_prev_pgm_id

Line 1610: --hr_utility.set_location ('l_rec1 ' , 16);

1606: For l_rec1 in c_dflt_mn_epe_mndtry(c_pgm_id => l_prev_pgm_id
1607: ,c_pl_id => l_prev_pl_id ) loop
1608: l_epe_cnt := l_epe_cnt + 1;
1609: l_epe(l_epe_cnt) := l_rec1;
1610: --hr_utility.set_location ('l_rec1 ' , 16);
1611: End loop;
1612: End if;
1613: --
1614: --hr_utility.set_location ('Before '||l_actn , 17);

Line 1614: --hr_utility.set_location ('Before '||l_actn , 17);

1610: --hr_utility.set_location ('l_rec1 ' , 16);
1611: End loop;
1612: End if;
1613: --
1614: --hr_utility.set_location ('Before '||l_actn , 17);
1615: For i in 1..l_epe_cnt Loop
1616: --
1617: l_not_ovridn := true ;
1618: --

Line 1621: hr_utility.set_location (l_actn , 18);

1617: l_not_ovridn := true ;
1618: --
1619: If (l_epe(i).prtt_enrt_rslt_id is not NULL) then
1620: l_actn := 'Getting enrollment data from c_pen cursor...';
1621: hr_utility.set_location (l_actn , 18);
1622: open c_pen(l_epe(i).prtt_enrt_rslt_id);
1623: fetch c_pen into l_pen;
1624: If (c_pen%notfound) then
1625: Close c_pen;

Line 1636: hr_utility.set_location (' lf_evt_ocrd_dt '|| to_char(l_global_pil_rec.lf_evt_ocrd_dt) , 5);

1632: fnd_message.raise_error;
1633: End if;
1634: close c_pen;
1635: --
1636: hr_utility.set_location (' lf_evt_ocrd_dt '|| to_char(l_global_pil_rec.lf_evt_ocrd_dt) , 5);
1637: --
1638: -- 4684991 - Use lf_evt_ocrd_dt instead of p_effective_date
1639: if l_pen.enrt_ovridn_flag = 'Y'
1640: AND nvl(l_pen.enrt_ovrid_thru_dt,hr_api.g_eot) >

Line 1665: hr_utility.set_location(l_actn , 20);

1661: l_not_ovridn then -- added flag condition so that if pending flag=Y
1662: -- election is not made
1663:
1664: l_actn := 'Openning c_bnft cursor for benefit...';
1665: hr_utility.set_location(l_actn , 20);
1666: l_bnft_id:=null;
1667: l_bnft_amt:=null;
1668: l_dflt_bnft_amt:=null;
1669: l_entr_flag:=null;

Line 1673: --hr_utility.set_location(' l_bnft_amt '||l_bnft_amt ,21 );

1669: l_entr_flag:=null;
1670: open c_bnft(l_epe(i).elig_per_elctbl_chc_id);
1671:
1672: fetch c_bnft into l_bnft_id, l_bnft_amt, l_dflt_bnft_amt, l_entr_flag,l_cvg_mlt_cd ;
1673: --hr_utility.set_location(' l_bnft_amt '||l_bnft_amt ,21 );
1674: --hr_utility.set_location(' l_dflt_bnft_amt '||l_dflt_bnft_amt , 22);
1675: --hr_utility.set_location(' l_entr_flag '||l_entr_flag , 23);
1676: close c_bnft;
1677: -- if the benefit amount is entered at enrollment, use the default

Line 1674: --hr_utility.set_location(' l_dflt_bnft_amt '||l_dflt_bnft_amt , 22);

1670: open c_bnft(l_epe(i).elig_per_elctbl_chc_id);
1671:
1672: fetch c_bnft into l_bnft_id, l_bnft_amt, l_dflt_bnft_amt, l_entr_flag,l_cvg_mlt_cd ;
1673: --hr_utility.set_location(' l_bnft_amt '||l_bnft_amt ,21 );
1674: --hr_utility.set_location(' l_dflt_bnft_amt '||l_dflt_bnft_amt , 22);
1675: --hr_utility.set_location(' l_entr_flag '||l_entr_flag , 23);
1676: close c_bnft;
1677: -- if the benefit amount is entered at enrollment, use the default
1678: -- benefit value instead of the val field.

Line 1675: --hr_utility.set_location(' l_entr_flag '||l_entr_flag , 23);

1671:
1672: fetch c_bnft into l_bnft_id, l_bnft_amt, l_dflt_bnft_amt, l_entr_flag,l_cvg_mlt_cd ;
1673: --hr_utility.set_location(' l_bnft_amt '||l_bnft_amt ,21 );
1674: --hr_utility.set_location(' l_dflt_bnft_amt '||l_dflt_bnft_amt , 22);
1675: --hr_utility.set_location(' l_entr_flag '||l_entr_flag , 23);
1676: close c_bnft;
1677: -- if the benefit amount is entered at enrollment, use the default
1678: -- benefit value instead of the val field.
1679: if l_entr_flag = 'Y' or l_cvg_mlt_cd = 'SAAEAR' then

Line 1696: --hr_utility.set_location('l_rt(l_tot_rt).ann_dflt_val '||l_rt(l_tot_rt).ann_dflt_val ,26);

1692: l_tot_rt := l_tot_rt + 1;
1693: l_rt(l_tot_rt).enrt_rt_id := Crec.enrt_rt_id;
1694: l_rt(l_tot_rt).default_val := Crec.default_val;
1695: l_rt(l_tot_rt).ann_dflt_val := Crec.ann_dflt_val;
1696: --hr_utility.set_location('l_rt(l_tot_rt).ann_dflt_val '||l_rt(l_tot_rt).ann_dflt_val ,26);
1697: --hr_utility.set_location('Crec.dflt_val '||l_rt(l_tot_rt).dflt_val , 27);
1698: End loop;
1699: l_suspend_flag := 'N';
1700: If (nvl(l_epe(i).actn_cd,'XXX') = 'UPD') then

Line 1697: --hr_utility.set_location('Crec.dflt_val '||l_rt(l_tot_rt).dflt_val , 27);

1693: l_rt(l_tot_rt).enrt_rt_id := Crec.enrt_rt_id;
1694: l_rt(l_tot_rt).default_val := Crec.default_val;
1695: l_rt(l_tot_rt).ann_dflt_val := Crec.ann_dflt_val;
1696: --hr_utility.set_location('l_rt(l_tot_rt).ann_dflt_val '||l_rt(l_tot_rt).ann_dflt_val ,26);
1697: --hr_utility.set_location('Crec.dflt_val '||l_rt(l_tot_rt).dflt_val , 27);
1698: End loop;
1699: l_suspend_flag := 'N';
1700: If (nvl(l_epe(i).actn_cd,'XXX') = 'UPD') then
1701: If nvl(l_bnft_amt,0) = nvl(l_pen.bnft_amt,0) then

Line 1709: hr_utility.set_location(l_actn , 30);

1705: --
1706: l_actn := 'Calling ben_election_information.election_information...';
1707: --
1708: /*
1709: hr_utility.set_location(l_actn , 30);
1710: hr_utility.set_location(' l_bnft_id '||l_bnft_id ,30);
1711: hr_utility.set_location(' l_bnft_amt '||l_bnft_amt ,30);
1712: hr_utility.set_location(' p_enrt_rt_id1 '||l_rt(1).enrt_rt_id ,30);
1713: hr_utility.set_location(' l_rt(1).dflt_val '||l_rt(1).dflt_val ,31);

Line 1710: hr_utility.set_location(' l_bnft_id '||l_bnft_id ,30);

1706: l_actn := 'Calling ben_election_information.election_information...';
1707: --
1708: /*
1709: hr_utility.set_location(l_actn , 30);
1710: hr_utility.set_location(' l_bnft_id '||l_bnft_id ,30);
1711: hr_utility.set_location(' l_bnft_amt '||l_bnft_amt ,30);
1712: hr_utility.set_location(' p_enrt_rt_id1 '||l_rt(1).enrt_rt_id ,30);
1713: hr_utility.set_location(' l_rt(1).dflt_val '||l_rt(1).dflt_val ,31);
1714: hr_utility.set_location(' p_Ann_rt_val1 '|| l_rt(1).ann_dflt_val , 31);

Line 1711: hr_utility.set_location(' l_bnft_amt '||l_bnft_amt ,30);

1707: --
1708: /*
1709: hr_utility.set_location(l_actn , 30);
1710: hr_utility.set_location(' l_bnft_id '||l_bnft_id ,30);
1711: hr_utility.set_location(' l_bnft_amt '||l_bnft_amt ,30);
1712: hr_utility.set_location(' p_enrt_rt_id1 '||l_rt(1).enrt_rt_id ,30);
1713: hr_utility.set_location(' l_rt(1).dflt_val '||l_rt(1).dflt_val ,31);
1714: hr_utility.set_location(' p_Ann_rt_val1 '|| l_rt(1).ann_dflt_val , 31);
1715: */

Line 1712: hr_utility.set_location(' p_enrt_rt_id1 '||l_rt(1).enrt_rt_id ,30);

1708: /*
1709: hr_utility.set_location(l_actn , 30);
1710: hr_utility.set_location(' l_bnft_id '||l_bnft_id ,30);
1711: hr_utility.set_location(' l_bnft_amt '||l_bnft_amt ,30);
1712: hr_utility.set_location(' p_enrt_rt_id1 '||l_rt(1).enrt_rt_id ,30);
1713: hr_utility.set_location(' l_rt(1).dflt_val '||l_rt(1).dflt_val ,31);
1714: hr_utility.set_location(' p_Ann_rt_val1 '|| l_rt(1).ann_dflt_val , 31);
1715: */
1716: --

Line 1713: hr_utility.set_location(' l_rt(1).dflt_val '||l_rt(1).dflt_val ,31);

1709: hr_utility.set_location(l_actn , 30);
1710: hr_utility.set_location(' l_bnft_id '||l_bnft_id ,30);
1711: hr_utility.set_location(' l_bnft_amt '||l_bnft_amt ,30);
1712: hr_utility.set_location(' p_enrt_rt_id1 '||l_rt(1).enrt_rt_id ,30);
1713: hr_utility.set_location(' l_rt(1).dflt_val '||l_rt(1).dflt_val ,31);
1714: hr_utility.set_location(' p_Ann_rt_val1 '|| l_rt(1).ann_dflt_val , 31);
1715: */
1716: --
1717: /* Added for Enhancement Bug 8716679

Line 1714: hr_utility.set_location(' p_Ann_rt_val1 '|| l_rt(1).ann_dflt_val , 31);

1710: hr_utility.set_location(' l_bnft_id '||l_bnft_id ,30);
1711: hr_utility.set_location(' l_bnft_amt '||l_bnft_amt ,30);
1712: hr_utility.set_location(' p_enrt_rt_id1 '||l_rt(1).enrt_rt_id ,30);
1713: hr_utility.set_location(' l_rt(1).dflt_val '||l_rt(1).dflt_val ,31);
1714: hr_utility.set_location(' p_Ann_rt_val1 '|| l_rt(1).ann_dflt_val , 31);
1715: */
1716: --
1717: /* Added for Enhancement Bug 8716679
1718: To add the electable choices to pl/sql table that are defaulted. This pl/sql

Line 1722: hr_utility.set_location ('Defaulted epe '||l_epe(i).elig_per_elctbl_chc_id,199);

1718: To add the electable choices to pl/sql table that are defaulted. This pl/sql
1719: is scanned to check whether the enrollment record is already defaulted. If the
1720: enrollment is defaulted then the enrollment that is to be reinstated will
1721: not be reinstated*/
1722: hr_utility.set_location ('Defaulted epe '||l_epe(i).elig_per_elctbl_chc_id,199);
1723: hr_utility.set_location ('p_prev_per_in_ler_id '|| p_prev_per_in_ler_id , 5);
1724: if(p_reinstate_dflts_flag = 'Y') then
1725: l_rdefault_table_cnt := nvl( ben_lf_evt_clps_restore.g_reinstated_defaults.LAST, 0) + 1;
1726: ben_lf_evt_clps_restore.g_reinstated_defaults(l_rdefault_table_cnt) := l_epe(i).elig_per_elctbl_chc_id;

Line 1723: hr_utility.set_location ('p_prev_per_in_ler_id '|| p_prev_per_in_ler_id , 5);

1719: is scanned to check whether the enrollment record is already defaulted. If the
1720: enrollment is defaulted then the enrollment that is to be reinstated will
1721: not be reinstated*/
1722: hr_utility.set_location ('Defaulted epe '||l_epe(i).elig_per_elctbl_chc_id,199);
1723: hr_utility.set_location ('p_prev_per_in_ler_id '|| p_prev_per_in_ler_id , 5);
1724: if(p_reinstate_dflts_flag = 'Y') then
1725: l_rdefault_table_cnt := nvl( ben_lf_evt_clps_restore.g_reinstated_defaults.LAST, 0) + 1;
1726: ben_lf_evt_clps_restore.g_reinstated_defaults(l_rdefault_table_cnt) := l_epe(i).elig_per_elctbl_chc_id;
1727: end if;

Line 1739: hr_utility.set_location ('p_effective_date '|| p_effective_date , 5);

1735: else
1736: l_effective_dt := p_effective_date;
1737: end if;
1738: close c_pl_enrt_dt;
1739: hr_utility.set_location ('p_effective_date '|| p_effective_date , 5);
1740: hr_utility.set_location ('l_effective_dt '|| l_effective_dt , 5);
1741: --End AMN Bug 14006027
1742:
1743: Ben_election_information.election_information

Line 1740: hr_utility.set_location ('l_effective_dt '|| l_effective_dt , 5);

1736: l_effective_dt := p_effective_date;
1737: end if;
1738: close c_pl_enrt_dt;
1739: hr_utility.set_location ('p_effective_date '|| p_effective_date , 5);
1740: hr_utility.set_location ('l_effective_dt '|| l_effective_dt , 5);
1741: --End AMN Bug 14006027
1742:
1743: Ben_election_information.election_information
1744: (p_elig_per_elctbl_chc_id => l_epe(i).elig_per_elctbl_chc_id

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

1965: ,p_validate => FALSE
1966: ,p_cls_enrt_flag => p_cls_enrt_flag
1967: );
1968: end if;
1969: hr_utility.set_location ('Leaving '|| l_proc,10);
1970: Exception
1971: when app_exception.application_exception then -- 6027345
1972: fnd_message.raise_error; -- 6027345
1973: When others then

Line 1987: hr_utility.set_location ('Error in Default_Comp_obj : '|| sqlerrm , 87);

1983: );
1984: raise ben_batch_utils.g_record_error ;
1985: -- Added for Bug 2370264
1986: else
1987: hr_utility.set_location ('Error in Default_Comp_obj : '|| sqlerrm , 87);
1988: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
1989: fnd_message.set_token('2',substr(sqlerrm,1,500)); -- 4695708
1990: fnd_message.raise_error;
1991: end if;

Line 2075: -- hr_utility.trace_on(NULL,'TRC');

2071: l_ler_id number;
2072: l_dflt_enrt_date date;
2073: --
2074: begin
2075: -- hr_utility.trace_on(NULL,'TRC');
2076: hr_utility.set_location ('Entering '|| l_proc,10);
2077: l_actn := 'Initializing...';
2078: Savepoint process_default_enrt_savepoint;
2079: --

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

2072: l_dflt_enrt_date date;
2073: --
2074: begin
2075: -- hr_utility.trace_on(NULL,'TRC');
2076: hr_utility.set_location ('Entering '|| l_proc,10);
2077: l_actn := 'Initializing...';
2078: Savepoint process_default_enrt_savepoint;
2079: --
2080: -- Cache person data and write personal data into cache.

Line 2115: hr_utility.set_location ('l_Dflt_enrt_Date = ' || l_dflt_enrt_date, 9999);

2111: THEN
2112: l_dflt_enrt_date := p_effective_date;
2113: END IF;
2114: --
2115: hr_utility.set_location ('l_Dflt_enrt_Date = ' || l_dflt_enrt_date, 9999);
2116: --
2117: Default_comp_obj
2118: (p_validate => FALSE
2119: ,p_per_in_ler_id => l_rec.per_in_ler_id

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

2204: benutils.write(p_rec => g_rec);
2205: --
2206: g_persons_procd := g_persons_procd + 1;
2207: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
2208: hr_utility.set_location ('Leaving '|| l_proc,10);
2209: Exception
2210: When others then
2211: rollback to process_default_enrt_savepoint;
2212: g_persons_errored := g_persons_errored + 1;

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

2261: l_commit number;
2262: begin
2263: --
2264: fnd_msg_pub.initialize;
2265: hr_utility.set_location ('Entering '|| l_proc,10);
2266:
2267: if UPPER(p_validate) = 'TRUE' then
2268: l_validate := true;
2269: else

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

2306: p_susp_flag := 'TRUE';
2307: else
2308: p_susp_flag := 'FALSE';
2309: end if;
2310: hr_utility.set_location ('Leaving '|| l_proc,20);
2311:
2312: exception
2313: --
2314: when app_exception.application_exception then --Bug 4387247

Line 2315: hr_utility.set_location ('Application Error in Default_Comp_obj_w.', 88);

2311:
2312: exception
2313: --
2314: when app_exception.application_exception then --Bug 4387247
2315: hr_utility.set_location ('Application Error in Default_Comp_obj_w.', 88);
2316: fnd_msg_pub.add;
2317: when others then
2318: hr_utility.set_location ('Other Error in Default_Comp_obj_w : '|| sqlerrm , 89);
2319: --Bug 4387247

Line 2318: hr_utility.set_location ('Other Error in Default_Comp_obj_w : '|| sqlerrm , 89);

2314: when app_exception.application_exception then --Bug 4387247
2315: hr_utility.set_location ('Application Error in Default_Comp_obj_w.', 88);
2316: fnd_msg_pub.add;
2317: when others then
2318: hr_utility.set_location ('Other Error in Default_Comp_obj_w : '|| sqlerrm , 89);
2319: --Bug 4387247
2320: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2321: fnd_message.set_token('2',substr(sqlerrm,1,200));
2322: fnd_msg_pub.add;