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.PJI_UTILS dependencies on PJI_UTILS

Line 1: PACKAGE BODY PJI_UTILS AS

1: PACKAGE BODY PJI_UTILS AS
2: /* $Header: PJIUT01B.pls 120.8.12000000.2 2007/07/25 11:01:46 bifernan ship $ */
3:
4: -- Global variables -----------------------------------
5: g_pji_settings pji_system_settings%rowtype;

Line 654: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);

650: begin
651:
652: l_global_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');
653: l_global_rate_type := FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE');
654: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);
655: /* 5155692 Introduced the global variable g_max_roll_days, so that for plans we can
656: set it to 1500 and for actuals or default it will be 32 */
657:
658: l_exchange_date := p_exchange_date;

Line 778: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);

774: begin
775:
776: l_global_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');
777: l_global_rate_type := FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE');
778: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);
779: /* 5155692 Introduced the global variable g_max_roll_days, so that for plans we can
780: set it to 1500 and for actuals or default it will be 32 */
781:
782: l_exchange_date := p_exchange_date;

Line 1662: pji_utils.write2out(l_newline || l_pji_report_msg || l_newline || l_separator || l_newline

1658: -- Audit Report printing starts
1659: l_pji_report_msg := ' '||l_pji_report_msg;
1660:
1661:
1662: pji_utils.write2out(l_newline || l_pji_report_msg || l_newline || l_separator || l_newline
1663: ||l_pji_head1||l_newline||l_newline||l_pji_head2||l_newline||l_pji_line2||l_newline);
1664:
1665: pji_utils.write2out(l_p_bis_pri_curr_code||l_bis_pri_curr_code||l_newline);
1666: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);

Line 1665: pji_utils.write2out(l_p_bis_pri_curr_code||l_bis_pri_curr_code||l_newline);

1661:
1662: pji_utils.write2out(l_newline || l_pji_report_msg || l_newline || l_separator || l_newline
1663: ||l_pji_head1||l_newline||l_newline||l_pji_head2||l_newline||l_pji_line2||l_newline);
1664:
1665: pji_utils.write2out(l_p_bis_pri_curr_code||l_bis_pri_curr_code||l_newline);
1666: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);
1667: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1668: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1669: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);

Line 1666: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);

1662: pji_utils.write2out(l_newline || l_pji_report_msg || l_newline || l_separator || l_newline
1663: ||l_pji_head1||l_newline||l_newline||l_pji_head2||l_newline||l_pji_line2||l_newline);
1664:
1665: pji_utils.write2out(l_p_bis_pri_curr_code||l_bis_pri_curr_code||l_newline);
1666: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);
1667: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1668: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1669: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1670: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);

Line 1667: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);

1663: ||l_pji_head1||l_newline||l_newline||l_pji_head2||l_newline||l_pji_line2||l_newline);
1664:
1665: pji_utils.write2out(l_p_bis_pri_curr_code||l_bis_pri_curr_code||l_newline);
1666: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);
1667: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1668: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1669: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1670: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);
1671: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);

Line 1668: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);

1664:
1665: pji_utils.write2out(l_p_bis_pri_curr_code||l_bis_pri_curr_code||l_newline);
1666: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);
1667: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1668: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1669: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1670: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);
1671: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);
1672: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);

Line 1669: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);

1665: pji_utils.write2out(l_p_bis_pri_curr_code||l_bis_pri_curr_code||l_newline);
1666: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);
1667: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1668: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1669: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1670: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);
1671: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);
1672: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);
1673:

Line 1670: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);

1666: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);
1667: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1668: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1669: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1670: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);
1671: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);
1672: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);
1673:
1674: -- For PJP Setup options

Line 1671: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);

1667: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1668: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1669: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1670: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);
1671: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);
1672: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);
1673:
1674: -- For PJP Setup options
1675: BEGIN

Line 1672: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);

1668: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1669: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1670: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);
1671: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);
1672: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);
1673:
1674: -- For PJP Setup options
1675: BEGIN
1676: SELECT

Line 1715: DECODE(l_curr_rep_ent_period,'SPECIFIC',pji_utils.get_parameter('PJI_PJP_ENT_CURR_REP_PERIOD'), Derive_curr_rep_Info(ORG_ID,'E',l_curr_rep_ent_period)) GLOBAL_PERIOD_NAME -- Enterprise (global) periods (Mandatory)

1711: AND PARAMS.NAME = 'PJI_PJP_ENT_CURR_REP_PERIOD'; */
1712: SELECT ORG.name,
1713: DECODE(l_curr_rep_pa_period,'SPECIFIC',INFO.PA_CURR_REP_PERIOD, Derive_curr_rep_Info(ORG_ID,'P',l_curr_rep_pa_period)) PROJECT_PERIOD_NAME, -- PA periods (Mandatory)-
1714: DECODE(l_curr_rep_gl_period,'SPECIFIC',INFO.GL_CURR_REP_PERIOD, Derive_curr_rep_Info(ORG_ID,'G',l_curr_rep_gl_period)) FISCAL_PERIOD_NAME, -- GL periods (Mandatory)
1715: DECODE(l_curr_rep_ent_period,'SPECIFIC',pji_utils.get_parameter('PJI_PJP_ENT_CURR_REP_PERIOD'), Derive_curr_rep_Info(ORG_ID,'E',l_curr_rep_ent_period)) GLOBAL_PERIOD_NAME -- Enterprise (global) periods (Mandatory)
1716: BULK COLLECT INTO
1717: l_sp_curr_rep_org_tbl,
1718: l_sp_curr_rep_pa_period_tbl,
1719: l_sp_curr_rep_gl_period_tbl,

Line 1802: pji_utils.write2out(l_newline ||l_pji_head3||l_newline||l_pji_line3||l_newline);

1798: end if;
1799: end if;
1800: end if;
1801: --- PJP Report printing
1802: pji_utils.write2out(l_newline ||l_pji_head3||l_newline||l_pji_line3||l_newline);
1803: pji_utils.write2out(l_p_glb_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_glb_curr_flag)||l_newline);
1804: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1805: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1806: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);

Line 1803: pji_utils.write2out(l_p_glb_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_glb_curr_flag)||l_newline);

1799: end if;
1800: end if;
1801: --- PJP Report printing
1802: pji_utils.write2out(l_newline ||l_pji_head3||l_newline||l_pji_line3||l_newline);
1803: pji_utils.write2out(l_p_glb_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_glb_curr_flag)||l_newline);
1804: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1805: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1806: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1807: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);

Line 1804: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);

1800: end if;
1801: --- PJP Report printing
1802: pji_utils.write2out(l_newline ||l_pji_head3||l_newline||l_pji_line3||l_newline);
1803: pji_utils.write2out(l_p_glb_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_glb_curr_flag)||l_newline);
1804: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1805: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1806: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1807: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1808: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);

Line 1805: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);

1801: --- PJP Report printing
1802: pji_utils.write2out(l_newline ||l_pji_head3||l_newline||l_pji_line3||l_newline);
1803: pji_utils.write2out(l_p_glb_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_glb_curr_flag)||l_newline);
1804: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1805: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1806: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1807: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1808: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);
1809: pji_utils.write2out(l_p_curr_rep_gl_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_gl_period)||l_newline);

Line 1806: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);

1802: pji_utils.write2out(l_newline ||l_pji_head3||l_newline||l_pji_line3||l_newline);
1803: pji_utils.write2out(l_p_glb_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_glb_curr_flag)||l_newline);
1804: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1805: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1806: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1807: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1808: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);
1809: pji_utils.write2out(l_p_curr_rep_gl_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_gl_period)||l_newline);
1810: pji_utils.write2out(l_p_curr_rep_ent_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_ent_period)||l_newline||l_newline||l_newline);

Line 1807: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);

1803: pji_utils.write2out(l_p_glb_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_glb_curr_flag)||l_newline);
1804: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1805: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1806: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1807: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1808: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);
1809: pji_utils.write2out(l_p_curr_rep_gl_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_gl_period)||l_newline);
1810: pji_utils.write2out(l_p_curr_rep_ent_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_ent_period)||l_newline||l_newline||l_newline);
1811: --- Organization wise current reporting period table

Line 1808: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);

1804: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1805: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1806: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1807: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1808: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);
1809: pji_utils.write2out(l_p_curr_rep_gl_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_gl_period)||l_newline);
1810: pji_utils.write2out(l_p_curr_rep_ent_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_ent_period)||l_newline||l_newline||l_newline);
1811: --- Organization wise current reporting period table
1812: /* If l_curr_rep_pa_period = 'SPECIFIC' or l_curr_rep_gl_period = 'SPECIFIC'

Line 1809: pji_utils.write2out(l_p_curr_rep_gl_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_gl_period)||l_newline);

1805: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1806: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1807: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1808: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);
1809: pji_utils.write2out(l_p_curr_rep_gl_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_gl_period)||l_newline);
1810: pji_utils.write2out(l_p_curr_rep_ent_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_ent_period)||l_newline||l_newline||l_newline);
1811: --- Organization wise current reporting period table
1812: /* If l_curr_rep_pa_period = 'SPECIFIC' or l_curr_rep_gl_period = 'SPECIFIC'
1813: or l_curr_rep_ent_period = 'SPECIFIC' then 5207578 */

Line 1810: pji_utils.write2out(l_p_curr_rep_ent_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_ent_period)||l_newline||l_newline||l_newline);

1806: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1807: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1808: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);
1809: pji_utils.write2out(l_p_curr_rep_gl_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_gl_period)||l_newline);
1810: pji_utils.write2out(l_p_curr_rep_ent_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_ent_period)||l_newline||l_newline||l_newline);
1811: --- Organization wise current reporting period table
1812: /* If l_curr_rep_pa_period = 'SPECIFIC' or l_curr_rep_gl_period = 'SPECIFIC'
1813: or l_curr_rep_ent_period = 'SPECIFIC' then 5207578 */
1814: pji_utils.write2out(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_TBL_H')||l_newline);

Line 1814: pji_utils.write2out(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_TBL_H')||l_newline);

1810: pji_utils.write2out(l_p_curr_rep_ent_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_ent_period)||l_newline||l_newline||l_newline);
1811: --- Organization wise current reporting period table
1812: /* If l_curr_rep_pa_period = 'SPECIFIC' or l_curr_rep_gl_period = 'SPECIFIC'
1813: or l_curr_rep_ent_period = 'SPECIFIC' then 5207578 */
1814: pji_utils.write2out(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_TBL_H')||l_newline);
1815: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1816: pji_utils.write2out('|'||RPAD(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_OU'),27,' ')||'|'||RPAD(l_p_curr_rep_pa_period,16,' ')||'|'||
1817: RPAD(l_p_curr_rep_gl_period,16,' ')||'|'||RPAD(l_p_curr_rep_ent_period,17,' ')||'|'||l_newline);
1818: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);

Line 1815: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);

1811: --- Organization wise current reporting period table
1812: /* If l_curr_rep_pa_period = 'SPECIFIC' or l_curr_rep_gl_period = 'SPECIFIC'
1813: or l_curr_rep_ent_period = 'SPECIFIC' then 5207578 */
1814: pji_utils.write2out(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_TBL_H')||l_newline);
1815: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1816: pji_utils.write2out('|'||RPAD(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_OU'),27,' ')||'|'||RPAD(l_p_curr_rep_pa_period,16,' ')||'|'||
1817: RPAD(l_p_curr_rep_gl_period,16,' ')||'|'||RPAD(l_p_curr_rep_ent_period,17,' ')||'|'||l_newline);
1818: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1819: For i in 1..l_sp_curr_rep_org_tbl.count loop

Line 1816: pji_utils.write2out('|'||RPAD(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_OU'),27,' ')||'|'||RPAD(l_p_curr_rep_pa_period,16,' ')||'|'||

1812: /* If l_curr_rep_pa_period = 'SPECIFIC' or l_curr_rep_gl_period = 'SPECIFIC'
1813: or l_curr_rep_ent_period = 'SPECIFIC' then 5207578 */
1814: pji_utils.write2out(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_TBL_H')||l_newline);
1815: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1816: pji_utils.write2out('|'||RPAD(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_OU'),27,' ')||'|'||RPAD(l_p_curr_rep_pa_period,16,' ')||'|'||
1817: RPAD(l_p_curr_rep_gl_period,16,' ')||'|'||RPAD(l_p_curr_rep_ent_period,17,' ')||'|'||l_newline);
1818: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1819: For i in 1..l_sp_curr_rep_org_tbl.count loop
1820: pji_utils.write2out('|'||RPAD(l_sp_curr_rep_org_tbl(i),27,' ')||'|'||RPAD(nvl(l_sp_curr_rep_pa_period_tbl(i),l_p_curr_rep_not),16,' ')||'|'||

Line 1818: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);

1814: pji_utils.write2out(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_TBL_H')||l_newline);
1815: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1816: pji_utils.write2out('|'||RPAD(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_OU'),27,' ')||'|'||RPAD(l_p_curr_rep_pa_period,16,' ')||'|'||
1817: RPAD(l_p_curr_rep_gl_period,16,' ')||'|'||RPAD(l_p_curr_rep_ent_period,17,' ')||'|'||l_newline);
1818: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1819: For i in 1..l_sp_curr_rep_org_tbl.count loop
1820: pji_utils.write2out('|'||RPAD(l_sp_curr_rep_org_tbl(i),27,' ')||'|'||RPAD(nvl(l_sp_curr_rep_pa_period_tbl(i),l_p_curr_rep_not),16,' ')||'|'||
1821: RPAD(nvl(l_sp_curr_rep_gl_period_tbl(i),l_p_curr_rep_not),16,' ')||'|'||RPAD(nvl(l_sp_curr_rep_ent_period_tbl(i),l_p_curr_rep_not),17,' ')||'|'||l_newline);
1822: for j in 1..ceil(length(l_sp_curr_rep_org_tbl(i))/27)-1 loop

Line 1820: pji_utils.write2out('|'||RPAD(l_sp_curr_rep_org_tbl(i),27,' ')||'|'||RPAD(nvl(l_sp_curr_rep_pa_period_tbl(i),l_p_curr_rep_not),16,' ')||'|'||

1816: pji_utils.write2out('|'||RPAD(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_OU'),27,' ')||'|'||RPAD(l_p_curr_rep_pa_period,16,' ')||'|'||
1817: RPAD(l_p_curr_rep_gl_period,16,' ')||'|'||RPAD(l_p_curr_rep_ent_period,17,' ')||'|'||l_newline);
1818: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1819: For i in 1..l_sp_curr_rep_org_tbl.count loop
1820: pji_utils.write2out('|'||RPAD(l_sp_curr_rep_org_tbl(i),27,' ')||'|'||RPAD(nvl(l_sp_curr_rep_pa_period_tbl(i),l_p_curr_rep_not),16,' ')||'|'||
1821: RPAD(nvl(l_sp_curr_rep_gl_period_tbl(i),l_p_curr_rep_not),16,' ')||'|'||RPAD(nvl(l_sp_curr_rep_ent_period_tbl(i),l_p_curr_rep_not),17,' ')||'|'||l_newline);
1822: for j in 1..ceil(length(l_sp_curr_rep_org_tbl(i))/27)-1 loop
1823: pji_utils.write2out('|'||RPAD(substr(l_sp_curr_rep_org_tbl(i),(j*27)+1,j+1*27),27,' ')||'|'||RPAD(' ',16,' ')||'|'||
1824: RPAD(' ',16,' ')||'|'||RPAD(' ',17,' ')||'|'||l_newline);

Line 1823: pji_utils.write2out('|'||RPAD(substr(l_sp_curr_rep_org_tbl(i),(j27)+1,j+127),27,' ')||'|'||RPAD(' ',16,' ')||'|'||

1819: For i in 1..l_sp_curr_rep_org_tbl.count loop
1820: pji_utils.write2out('|'||RPAD(l_sp_curr_rep_org_tbl(i),27,' ')||'|'||RPAD(nvl(l_sp_curr_rep_pa_period_tbl(i),l_p_curr_rep_not),16,' ')||'|'||
1821: RPAD(nvl(l_sp_curr_rep_gl_period_tbl(i),l_p_curr_rep_not),16,' ')||'|'||RPAD(nvl(l_sp_curr_rep_ent_period_tbl(i),l_p_curr_rep_not),17,' ')||'|'||l_newline);
1822: for j in 1..ceil(length(l_sp_curr_rep_org_tbl(i))/27)-1 loop
1823: pji_utils.write2out('|'||RPAD(substr(l_sp_curr_rep_org_tbl(i),(j*27)+1,j+1*27),27,' ')||'|'||RPAD(' ',16,' ')||'|'||
1824: RPAD(' ',16,' ')||'|'||RPAD(' ',17,' ')||'|'||l_newline);
1825: end loop;
1826:
1827: if l_sp_curr_rep_pa_period_tbl(i) is null or l_sp_curr_rep_gl_period_tbl(i) is null

Line 1835: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);

1831: l_prm_miss := 2;
1832: end if;
1833: end if;
1834: end loop;
1835: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1836:
1837: -- end if; /* 5207578 */
1838:
1839:

Line 1843: pji_utils.write2out(l_newline ||l_pji_head4||l_newline||l_pji_line4||l_newline);

1839:
1840: -- Exception reporting for all setup missing
1841: -- Mandatory Setup
1842: if l_prm_miss = 2 or l_prm_miss = 4 then
1843: pji_utils.write2out(l_newline ||l_pji_head4||l_newline||l_pji_line4||l_newline);
1844: if l_bis_pri_curr_code is NULL then
1845: pji_utils.write2out(l_p_bis_pri_curr_code||l_newline);
1846: end if;
1847: if l_bis_pri_rate_type is NULL then

Line 1845: pji_utils.write2out(l_p_bis_pri_curr_code||l_newline);

1841: -- Mandatory Setup
1842: if l_prm_miss = 2 or l_prm_miss = 4 then
1843: pji_utils.write2out(l_newline ||l_pji_head4||l_newline||l_pji_line4||l_newline);
1844: if l_bis_pri_curr_code is NULL then
1845: pji_utils.write2out(l_p_bis_pri_curr_code||l_newline);
1846: end if;
1847: if l_bis_pri_rate_type is NULL then
1848: pji_utils.write2out(l_p_bis_pri_rate_type||l_newline);
1849: end if;

Line 1848: pji_utils.write2out(l_p_bis_pri_rate_type||l_newline);

1844: if l_bis_pri_curr_code is NULL then
1845: pji_utils.write2out(l_p_bis_pri_curr_code||l_newline);
1846: end if;
1847: if l_bis_pri_rate_type is NULL then
1848: pji_utils.write2out(l_p_bis_pri_rate_type||l_newline);
1849: end if;
1850: if l_bis_ent_calendar is NULL then
1851: pji_utils.write2out(l_p_bis_ent_calendar||l_newline);
1852: end if;

Line 1851: pji_utils.write2out(l_p_bis_ent_calendar||l_newline);

1847: if l_bis_pri_rate_type is NULL then
1848: pji_utils.write2out(l_p_bis_pri_rate_type||l_newline);
1849: end if;
1850: if l_bis_ent_calendar is NULL then
1851: pji_utils.write2out(l_p_bis_ent_calendar||l_newline);
1852: end if;
1853: if l_bis_period_type is NULL then
1854: pji_utils.write2out(l_p_bis_period_type||l_newline);
1855: end if;

Line 1854: pji_utils.write2out(l_p_bis_period_type||l_newline);

1850: if l_bis_ent_calendar is NULL then
1851: pji_utils.write2out(l_p_bis_ent_calendar||l_newline);
1852: end if;
1853: if l_bis_period_type is NULL then
1854: pji_utils.write2out(l_p_bis_period_type||l_newline);
1855: end if;
1856: if l_bis_global_start_date is NULL then
1857: pji_utils.write2out(l_p_bis_global_start_date||l_newline);
1858: end if;

Line 1857: pji_utils.write2out(l_p_bis_global_start_date||l_newline);

1853: if l_bis_period_type is NULL then
1854: pji_utils.write2out(l_p_bis_period_type||l_newline);
1855: end if;
1856: if l_bis_global_start_date is NULL then
1857: pji_utils.write2out(l_p_bis_global_start_date||l_newline);
1858: end if;
1859: if l_planamt_conv_date is NULL then
1860: pji_utils.write2out(l_p_planamt_conv_date||l_newline);
1861: end if;

Line 1860: pji_utils.write2out(l_p_planamt_conv_date||l_newline);

1856: if l_bis_global_start_date is NULL then
1857: pji_utils.write2out(l_p_bis_global_start_date||l_newline);
1858: end if;
1859: if l_planamt_conv_date is NULL then
1860: pji_utils.write2out(l_p_planamt_conv_date||l_newline);
1861: end if;
1862: if l_planamt_alloc_method is NULL then
1863: pji_utils.write2out(l_p_planamt_alloc_method||l_newline);
1864: end if;

Line 1863: pji_utils.write2out(l_p_planamt_alloc_method||l_newline);

1859: if l_planamt_conv_date is NULL then
1860: pji_utils.write2out(l_p_planamt_conv_date||l_newline);
1861: end if;
1862: if l_planamt_alloc_method is NULL then
1863: pji_utils.write2out(l_p_planamt_alloc_method||l_newline);
1864: end if;
1865: --- For Current reporting periods
1866: if l_curr_rep_pa_period is NULL or l_curr_rep_gl_period is NULL or
1867: l_curr_rep_ent_period is NULL then

Line 1868: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);

1864: end if;
1865: --- For Current reporting periods
1866: if l_curr_rep_pa_period is NULL or l_curr_rep_gl_period is NULL or
1867: l_curr_rep_ent_period is NULL then
1868: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1869: end if;
1870: if l_curr_rep_pa_period is NULL then
1871: pji_utils.write2out(l_p_curr_rep_pa_period||l_newline);
1872: end if;

Line 1871: pji_utils.write2out(l_p_curr_rep_pa_period||l_newline);

1867: l_curr_rep_ent_period is NULL then
1868: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1869: end if;
1870: if l_curr_rep_pa_period is NULL then
1871: pji_utils.write2out(l_p_curr_rep_pa_period||l_newline);
1872: end if;
1873: if l_curr_rep_gl_period is NULL then
1874: pji_utils.write2out(l_p_curr_rep_gl_period||l_newline);
1875: end if;

Line 1874: pji_utils.write2out(l_p_curr_rep_gl_period||l_newline);

1870: if l_curr_rep_pa_period is NULL then
1871: pji_utils.write2out(l_p_curr_rep_pa_period||l_newline);
1872: end if;
1873: if l_curr_rep_gl_period is NULL then
1874: pji_utils.write2out(l_p_curr_rep_gl_period||l_newline);
1875: end if;
1876: if l_curr_rep_ent_period is NULL then
1877: pji_utils.write2out(l_p_curr_rep_ent_period||l_newline);
1878: end if;

Line 1877: pji_utils.write2out(l_p_curr_rep_ent_period||l_newline);

1873: if l_curr_rep_gl_period is NULL then
1874: pji_utils.write2out(l_p_curr_rep_gl_period||l_newline);
1875: end if;
1876: if l_curr_rep_ent_period is NULL then
1877: pji_utils.write2out(l_p_curr_rep_ent_period||l_newline);
1878: end if;
1879: --- For Current reporting period when SPECIFIC
1880: if l_sp_note = 1 then
1881: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_MISS')||l_newline);

Line 1881: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_MISS')||l_newline);

1877: pji_utils.write2out(l_p_curr_rep_ent_period||l_newline);
1878: end if;
1879: --- For Current reporting period when SPECIFIC
1880: if l_sp_note = 1 then
1881: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_MISS')||l_newline);
1882: end if;
1883:
1884: end if;
1885: -- Optional Set up

Line 1887: pji_utils.write2out(l_newline ||l_pji_head5||l_newline||l_pji_line5||l_newline);

1883:
1884: end if;
1885: -- Optional Set up
1886: if l_prm_miss = 3 or l_prm_miss = 4 then
1887: pji_utils.write2out(l_newline ||l_pji_head5||l_newline||l_pji_line5||l_newline);
1888: if l_bis_sec_curr_code is NULL then
1889: pji_utils.write2out(l_p_bis_sec_curr_code||l_newline);
1890: end if;
1891: if l_bis_sec_rate_type is NULL then

Line 1889: pji_utils.write2out(l_p_bis_sec_curr_code||l_newline);

1885: -- Optional Set up
1886: if l_prm_miss = 3 or l_prm_miss = 4 then
1887: pji_utils.write2out(l_newline ||l_pji_head5||l_newline||l_pji_line5||l_newline);
1888: if l_bis_sec_curr_code is NULL then
1889: pji_utils.write2out(l_p_bis_sec_curr_code||l_newline);
1890: end if;
1891: if l_bis_sec_rate_type is NULL then
1892: pji_utils.write2out(l_p_bis_sec_rate_type||l_newline);
1893: end if;

Line 1892: pji_utils.write2out(l_p_bis_sec_rate_type||l_newline);

1888: if l_bis_sec_curr_code is NULL then
1889: pji_utils.write2out(l_p_bis_sec_curr_code||l_newline);
1890: end if;
1891: if l_bis_sec_rate_type is NULL then
1892: pji_utils.write2out(l_p_bis_sec_rate_type||l_newline);
1893: end if;
1894: if l_pji_global_start_date is NULL then
1895: pji_utils.write2out(l_p_pji_global_start_date||l_newline);
1896: end if;

Line 1895: pji_utils.write2out(l_p_pji_global_start_date||l_newline);

1891: if l_bis_sec_rate_type is NULL then
1892: pji_utils.write2out(l_p_bis_sec_rate_type||l_newline);
1893: end if;
1894: if l_pji_global_start_date is NULL then
1895: pji_utils.write2out(l_p_pji_global_start_date||l_newline);
1896: end if;
1897: if l_glb_curr_flag is null then
1898: pji_utils.write2out(l_p_glb_curr_flag||l_newline);
1899: end if;

Line 1898: pji_utils.write2out(l_p_glb_curr_flag||l_newline);

1894: if l_pji_global_start_date is NULL then
1895: pji_utils.write2out(l_p_pji_global_start_date||l_newline);
1896: end if;
1897: if l_glb_curr_flag is null then
1898: pji_utils.write2out(l_p_glb_curr_flag||l_newline);
1899: end if;
1900: if l_txn_curr_flag is null then
1901: pji_utils.write2out(l_p_txn_curr_flag||l_newline);
1902: end if;

Line 1901: pji_utils.write2out(l_p_txn_curr_flag||l_newline);

1897: if l_glb_curr_flag is null then
1898: pji_utils.write2out(l_p_glb_curr_flag||l_newline);
1899: end if;
1900: if l_txn_curr_flag is null then
1901: pji_utils.write2out(l_p_txn_curr_flag||l_newline);
1902: end if;
1903: end if;
1904: --- Notes at the end of the report if any thing missing
1905: if l_prm_miss > 1 then

Line 1906: pji_utils.write2out(l_newline||l_pji_foot1||l_newline);

1902: end if;
1903: end if;
1904: --- Notes at the end of the report if any thing missing
1905: if l_prm_miss > 1 then
1906: pji_utils.write2out(l_newline||l_pji_foot1||l_newline);
1907: if l_bis_note > 0 then
1908: pji_utils.write2out(l_pji_foot2||l_newline);
1909: end if ;
1910: if l_pjp_note > 0 then

Line 1908: pji_utils.write2out(l_pji_foot2||l_newline);

1904: --- Notes at the end of the report if any thing missing
1905: if l_prm_miss > 1 then
1906: pji_utils.write2out(l_newline||l_pji_foot1||l_newline);
1907: if l_bis_note > 0 then
1908: pji_utils.write2out(l_pji_foot2||l_newline);
1909: end if ;
1910: if l_pjp_note > 0 then
1911: pji_utils.write2out(l_pji_foot3||l_newline);
1912: end if ;

Line 1911: pji_utils.write2out(l_pji_foot3||l_newline);

1907: if l_bis_note > 0 then
1908: pji_utils.write2out(l_pji_foot2||l_newline);
1909: end if ;
1910: if l_pjp_note > 0 then
1911: pji_utils.write2out(l_pji_foot3||l_newline);
1912: end if ;
1913: if l_sp_note > 0 then
1914: pji_utils.write2out(l_pji_foot4||l_newline);
1915: end if ;

Line 1914: pji_utils.write2out(l_pji_foot4||l_newline);

1910: if l_pjp_note > 0 then
1911: pji_utils.write2out(l_pji_foot3||l_newline);
1912: end if ;
1913: if l_sp_note > 0 then
1914: pji_utils.write2out(l_pji_foot4||l_newline);
1915: end if ;
1916: end if;
1917: Exception when others then
1918: pji_utils.write2out('Error: '||l_err_msg);

Line 1918: pji_utils.write2out('Error: '||l_err_msg);

1914: pji_utils.write2out(l_pji_foot4||l_newline);
1915: end if ;
1916: end if;
1917: Exception when others then
1918: pji_utils.write2out('Error: '||l_err_msg);
1919: END;
1920:
1921: -- -----------------------------------------------------
1922: -- Function PJI_LOOKUP_VALUE

Line 1960: if (PJI_UTILS.GET_PARAMETER('PJI_PTC_UPGRADE') = 'P') then

1956: return VARCHAR2
1957: IS
1958: l_return varchar2(1):='N';
1959: BEGIN
1960: if (PJI_UTILS.GET_PARAMETER('PJI_PTC_UPGRADE') = 'P') then
1961:
1962: select 'Y'
1963: into l_return
1964: from dual

Line 1998: select PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') into l_status from dual;

1994: IS
1995: l_status VARCHAR2(1);
1996: l_count NUMBER(10);
1997: begin
1998: select PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') into l_status from dual;
1999: IF l_status = 'P' THEN
2000: select count(1) into l_count from PJI_SYSTEM_CONFIG_HIST
2001: where PROCESS_NAME = 'STAGE3'
2002: and END_DATE is null and RUN_TYPE = 'CLEANALL';

Line 2055: end PJI_UTILS;

2051: end;
2052:
2053:
2054:
2055: end PJI_UTILS;