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.19.12020000.2 2012/07/18 10:57:44 admarath ship $ */
3:
4: -- Global variables -----------------------------------
5: g_pji_settings pji_system_settings%rowtype;

Line 525: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

521: function GET_SETUP_PARAMETER (p_name in varchar2) return varchar2 is
522: begin
523:
524: /* Added for bug 13030627 */
525: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
526:
527: return GET_SETUP_PARAMETER_1(p_name);
528:
529: else

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

767: begin
768:
769: l_global_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');
770: l_global_rate_type := FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE');
771: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);
772: /* 5155692 Introduced the global variable g_max_roll_days, so that for plans we can
773: set it to 1500 and for actuals or default it will be 32 */
774:
775: l_exchange_date := p_exchange_date;

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

891: begin
892:
893: l_global_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');
894: l_global_rate_type := FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE');
895: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);
896: /* 5155692 Introduced the global variable g_max_roll_days, so that for plans we can
897: set it to 1500 and for actuals or default it will be 32 */
898:
899: l_exchange_date := p_exchange_date;

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

1822: -- Audit Report printing starts
1823: l_pji_report_msg := ' '||l_pji_report_msg;
1824:
1825:
1826: pji_utils.write2out(l_newline || l_pji_report_msg || l_newline || l_separator || l_newline
1827: ||l_pji_head1||l_newline||l_newline||l_pji_head2||l_newline||l_pji_line2||l_newline);
1828:
1829: pji_utils.write2out(l_p_bis_pri_curr_code||l_bis_pri_curr_code||l_newline);
1830: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);

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

1825:
1826: pji_utils.write2out(l_newline || l_pji_report_msg || l_newline || l_separator || l_newline
1827: ||l_pji_head1||l_newline||l_newline||l_pji_head2||l_newline||l_pji_line2||l_newline);
1828:
1829: pji_utils.write2out(l_p_bis_pri_curr_code||l_bis_pri_curr_code||l_newline);
1830: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);
1831: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1832: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1833: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);

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

1826: pji_utils.write2out(l_newline || l_pji_report_msg || l_newline || l_separator || l_newline
1827: ||l_pji_head1||l_newline||l_newline||l_pji_head2||l_newline||l_pji_line2||l_newline);
1828:
1829: pji_utils.write2out(l_p_bis_pri_curr_code||l_bis_pri_curr_code||l_newline);
1830: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);
1831: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1832: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1833: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1834: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);

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

1827: ||l_pji_head1||l_newline||l_newline||l_pji_head2||l_newline||l_pji_line2||l_newline);
1828:
1829: pji_utils.write2out(l_p_bis_pri_curr_code||l_bis_pri_curr_code||l_newline);
1830: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);
1831: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1832: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1833: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1834: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);
1835: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);

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

1828:
1829: pji_utils.write2out(l_p_bis_pri_curr_code||l_bis_pri_curr_code||l_newline);
1830: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);
1831: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1832: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1833: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1834: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);
1835: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);
1836: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);

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

1829: pji_utils.write2out(l_p_bis_pri_curr_code||l_bis_pri_curr_code||l_newline);
1830: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);
1831: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1832: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1833: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1834: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);
1835: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);
1836: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);
1837: /*Following code is added for bug 6802867 */

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

1830: pji_utils.write2out(l_p_bis_pri_rate_type||l_bis_pri_rate_type||l_newline);
1831: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1832: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1833: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1834: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);
1835: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);
1836: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);
1837: /*Following code is added for bug 6802867 */
1838: pji_utils.write2out(l_p_extraction_batch_size||l_extraction_batch_size||l_newline);

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

1831: pji_utils.write2out(l_p_bis_sec_curr_code||l_bis_sec_curr_code||l_newline);
1832: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1833: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1834: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);
1835: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);
1836: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);
1837: /*Following code is added for bug 6802867 */
1838: pji_utils.write2out(l_p_extraction_batch_size||l_extraction_batch_size||l_newline);
1839: pji_utils.write2out(l_p_def_rept_cal_type||PJI_LOOKUP_VALUE('PJI_REPORTING_CALENDARS',l_def_rept_cal_type)||l_newline);

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

1832: pji_utils.write2out(l_p_bis_sec_rate_type||l_bis_sec_rate_type||l_newline);
1833: pji_utils.write2out(l_p_bis_ent_calendar||l_bis_ent_calendar||l_newline);
1834: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);
1835: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);
1836: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);
1837: /*Following code is added for bug 6802867 */
1838: pji_utils.write2out(l_p_extraction_batch_size||l_extraction_batch_size||l_newline);
1839: pji_utils.write2out(l_p_def_rept_cal_type||PJI_LOOKUP_VALUE('PJI_REPORTING_CALENDARS',l_def_rept_cal_type)||l_newline);
1840: pji_utils.write2out(l_p_def_rept_cur_type||PJI_LOOKUP_VALUE('PJI_REP_CURRENCY_TYPE',l_def_rept_cur_type)||l_newline);

Line 1838: pji_utils.write2out(l_p_extraction_batch_size||l_extraction_batch_size||l_newline);

1834: pji_utils.write2out(l_p_bis_period_type||l_bis_period_type||l_newline);
1835: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);
1836: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);
1837: /*Following code is added for bug 6802867 */
1838: pji_utils.write2out(l_p_extraction_batch_size||l_extraction_batch_size||l_newline);
1839: pji_utils.write2out(l_p_def_rept_cal_type||PJI_LOOKUP_VALUE('PJI_REPORTING_CALENDARS',l_def_rept_cal_type)||l_newline);
1840: pji_utils.write2out(l_p_def_rept_cur_type||PJI_LOOKUP_VALUE('PJI_REP_CURRENCY_TYPE',l_def_rept_cur_type)||l_newline);
1841:
1842:

Line 1839: pji_utils.write2out(l_p_def_rept_cal_type||PJI_LOOKUP_VALUE('PJI_REPORTING_CALENDARS',l_def_rept_cal_type)||l_newline);

1835: pji_utils.write2out(l_p_bis_global_start_date||l_bis_global_start_date||l_newline);
1836: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);
1837: /*Following code is added for bug 6802867 */
1838: pji_utils.write2out(l_p_extraction_batch_size||l_extraction_batch_size||l_newline);
1839: pji_utils.write2out(l_p_def_rept_cal_type||PJI_LOOKUP_VALUE('PJI_REPORTING_CALENDARS',l_def_rept_cal_type)||l_newline);
1840: pji_utils.write2out(l_p_def_rept_cur_type||PJI_LOOKUP_VALUE('PJI_REP_CURRENCY_TYPE',l_def_rept_cur_type)||l_newline);
1841:
1842:
1843: -- For PJP Setup options

Line 1840: pji_utils.write2out(l_p_def_rept_cur_type||PJI_LOOKUP_VALUE('PJI_REP_CURRENCY_TYPE',l_def_rept_cur_type)||l_newline);

1836: pji_utils.write2out(l_p_pji_global_start_date||l_pji_global_start_date||l_newline);
1837: /*Following code is added for bug 6802867 */
1838: pji_utils.write2out(l_p_extraction_batch_size||l_extraction_batch_size||l_newline);
1839: pji_utils.write2out(l_p_def_rept_cal_type||PJI_LOOKUP_VALUE('PJI_REPORTING_CALENDARS',l_def_rept_cal_type)||l_newline);
1840: pji_utils.write2out(l_p_def_rept_cur_type||PJI_LOOKUP_VALUE('PJI_REP_CURRENCY_TYPE',l_def_rept_cur_type)||l_newline);
1841:
1842:
1843: -- For PJP Setup options
1844: BEGIN

Line 1884: 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)

1880: AND PARAMS.NAME = 'PJI_PJP_ENT_CURR_REP_PERIOD'; */
1881: SELECT ORG.name,
1882: 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)-
1883: 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)
1884: 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)
1885: BULK COLLECT INTO
1886: l_sp_curr_rep_org_tbl,
1887: l_sp_curr_rep_pa_period_tbl,
1888: l_sp_curr_rep_gl_period_tbl,

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

1967: end if;
1968: end if;
1969: end if;
1970: --- PJP Report printing
1971: pji_utils.write2out(l_newline ||l_pji_head3||l_newline||l_pji_line3||l_newline);
1972: pji_utils.write2out(l_p_glb_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_glb_curr_flag)||l_newline);
1973: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1974: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1975: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);

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

1968: end if;
1969: end if;
1970: --- PJP Report printing
1971: pji_utils.write2out(l_newline ||l_pji_head3||l_newline||l_pji_line3||l_newline);
1972: pji_utils.write2out(l_p_glb_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_glb_curr_flag)||l_newline);
1973: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1974: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1975: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1976: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);

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

1969: end if;
1970: --- PJP Report printing
1971: pji_utils.write2out(l_newline ||l_pji_head3||l_newline||l_pji_line3||l_newline);
1972: pji_utils.write2out(l_p_glb_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_glb_curr_flag)||l_newline);
1973: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1974: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1975: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1976: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1977: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);

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

1970: --- PJP Report printing
1971: pji_utils.write2out(l_newline ||l_pji_head3||l_newline||l_pji_line3||l_newline);
1972: pji_utils.write2out(l_p_glb_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_glb_curr_flag)||l_newline);
1973: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1974: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1975: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1976: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1977: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);
1978: pji_utils.write2out(l_p_curr_rep_gl_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_gl_period)||l_newline);

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

1971: pji_utils.write2out(l_newline ||l_pji_head3||l_newline||l_pji_line3||l_newline);
1972: pji_utils.write2out(l_p_glb_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_glb_curr_flag)||l_newline);
1973: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1974: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1975: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1976: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1977: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);
1978: pji_utils.write2out(l_p_curr_rep_gl_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_gl_period)||l_newline);
1979: 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 1976: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);

1972: pji_utils.write2out(l_p_glb_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_glb_curr_flag)||l_newline);
1973: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1974: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1975: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1976: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1977: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);
1978: pji_utils.write2out(l_p_curr_rep_gl_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_gl_period)||l_newline);
1979: 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);
1980: --- Organization wise current reporting period table

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

1973: pji_utils.write2out(l_p_txn_curr_flag||PJI_LOOKUP_VALUE('PJI_YES_NO',l_txn_curr_flag)||l_newline);
1974: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1975: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1976: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1977: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);
1978: pji_utils.write2out(l_p_curr_rep_gl_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_gl_period)||l_newline);
1979: 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);
1980: --- Organization wise current reporting period table
1981: /* If l_curr_rep_pa_period = 'SPECIFIC' or l_curr_rep_gl_period = 'SPECIFIC'

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

1974: pji_utils.write2out(l_p_planamt_conv_date||PJI_LOOKUP_VALUE('PJI_PLN_AMT_CON',l_planamt_conv_date)||l_newline);
1975: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1976: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1977: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);
1978: pji_utils.write2out(l_p_curr_rep_gl_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_gl_period)||l_newline);
1979: 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);
1980: --- Organization wise current reporting period table
1981: /* If l_curr_rep_pa_period = 'SPECIFIC' or l_curr_rep_gl_period = 'SPECIFIC'
1982: or l_curr_rep_ent_period = 'SPECIFIC' then 5207578 */

Line 1979: 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);

1975: pji_utils.write2out(l_p_planamt_alloc_method||PJI_LOOKUP_VALUE('PJI_PLN_AMT_ALC',l_planamt_alloc_method)||l_newline);
1976: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
1977: pji_utils.write2out(l_p_curr_rep_pa_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_pa_period)||l_newline);
1978: pji_utils.write2out(l_p_curr_rep_gl_period||PJI_LOOKUP_VALUE('PJI_CURR_REP_PD',l_curr_rep_gl_period)||l_newline);
1979: 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);
1980: --- Organization wise current reporting period table
1981: /* If l_curr_rep_pa_period = 'SPECIFIC' or l_curr_rep_gl_period = 'SPECIFIC'
1982: or l_curr_rep_ent_period = 'SPECIFIC' then 5207578 */
1983: pji_utils.write2out(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_TBL_H')||l_newline);

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

1979: 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);
1980: --- Organization wise current reporting period table
1981: /* If l_curr_rep_pa_period = 'SPECIFIC' or l_curr_rep_gl_period = 'SPECIFIC'
1982: or l_curr_rep_ent_period = 'SPECIFIC' then 5207578 */
1983: pji_utils.write2out(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_TBL_H')||l_newline);
1984: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1985: pji_utils.write2out('|'||RPAD(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_OU'),27,' ')||'|'||RPAD(l_p_curr_rep_pa_period,16,' ')||'|'||
1986: RPAD(l_p_curr_rep_gl_period,16,' ')||'|'||RPAD(l_p_curr_rep_ent_period,17,' ')||'|'||l_newline);
1987: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);

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

1980: --- Organization wise current reporting period table
1981: /* If l_curr_rep_pa_period = 'SPECIFIC' or l_curr_rep_gl_period = 'SPECIFIC'
1982: or l_curr_rep_ent_period = 'SPECIFIC' then 5207578 */
1983: pji_utils.write2out(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_TBL_H')||l_newline);
1984: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1985: pji_utils.write2out('|'||RPAD(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_OU'),27,' ')||'|'||RPAD(l_p_curr_rep_pa_period,16,' ')||'|'||
1986: RPAD(l_p_curr_rep_gl_period,16,' ')||'|'||RPAD(l_p_curr_rep_ent_period,17,' ')||'|'||l_newline);
1987: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1988: For i in 1..l_sp_curr_rep_org_tbl.count loop

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

1981: /* If l_curr_rep_pa_period = 'SPECIFIC' or l_curr_rep_gl_period = 'SPECIFIC'
1982: or l_curr_rep_ent_period = 'SPECIFIC' then 5207578 */
1983: pji_utils.write2out(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_TBL_H')||l_newline);
1984: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1985: pji_utils.write2out('|'||RPAD(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_OU'),27,' ')||'|'||RPAD(l_p_curr_rep_pa_period,16,' ')||'|'||
1986: RPAD(l_p_curr_rep_gl_period,16,' ')||'|'||RPAD(l_p_curr_rep_ent_period,17,' ')||'|'||l_newline);
1987: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1988: For i in 1..l_sp_curr_rep_org_tbl.count loop
1989: 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 1987: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);

1983: pji_utils.write2out(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_TBL_H')||l_newline);
1984: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1985: pji_utils.write2out('|'||RPAD(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_OU'),27,' ')||'|'||RPAD(l_p_curr_rep_pa_period,16,' ')||'|'||
1986: RPAD(l_p_curr_rep_gl_period,16,' ')||'|'||RPAD(l_p_curr_rep_ent_period,17,' ')||'|'||l_newline);
1987: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1988: For i in 1..l_sp_curr_rep_org_tbl.count loop
1989: 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,' ')||'|'||
1990: 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);
1991: for j in 1..ceil(length(l_sp_curr_rep_org_tbl(i))/27)-1 loop

Line 1989: 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,' ')||'|'||

1985: pji_utils.write2out('|'||RPAD(FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_OU'),27,' ')||'|'||RPAD(l_p_curr_rep_pa_period,16,' ')||'|'||
1986: RPAD(l_p_curr_rep_gl_period,16,' ')||'|'||RPAD(l_p_curr_rep_ent_period,17,' ')||'|'||l_newline);
1987: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
1988: For i in 1..l_sp_curr_rep_org_tbl.count loop
1989: 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,' ')||'|'||
1990: 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);
1991: for j in 1..ceil(length(l_sp_curr_rep_org_tbl(i))/27)-1 loop
1992: pji_utils.write2out('|'||RPAD(substr(l_sp_curr_rep_org_tbl(i),(j*27)+1,j+1*27),27,' ')||'|'||RPAD(' ',16,' ')||'|'||
1993: RPAD(' ',16,' ')||'|'||RPAD(' ',17,' ')||'|'||l_newline);

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

1988: For i in 1..l_sp_curr_rep_org_tbl.count loop
1989: 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,' ')||'|'||
1990: 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);
1991: for j in 1..ceil(length(l_sp_curr_rep_org_tbl(i))/27)-1 loop
1992: pji_utils.write2out('|'||RPAD(substr(l_sp_curr_rep_org_tbl(i),(j*27)+1,j+1*27),27,' ')||'|'||RPAD(' ',16,' ')||'|'||
1993: RPAD(' ',16,' ')||'|'||RPAD(' ',17,' ')||'|'||l_newline);
1994: end loop;
1995:
1996: if l_sp_curr_rep_pa_period_tbl(i) is null or l_sp_curr_rep_gl_period_tbl(i) is null

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

2000: l_prm_miss := 2;
2001: end if;
2002: end if;
2003: end loop;
2004: pji_utils.write2out(RPAD(l_pji_tline,81,'-')||l_newline);
2005:
2006: -- end if; /* 5207578 */
2007:
2008:

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

2008:
2009: -- Exception reporting for all setup missing
2010: -- Mandatory Setup
2011: if l_prm_miss = 2 or l_prm_miss = 4 then
2012: pji_utils.write2out(l_newline ||l_pji_head4||l_newline||l_pji_line4||l_newline);
2013: if l_bis_pri_curr_code is NULL then
2014: pji_utils.write2out(l_p_bis_pri_curr_code||l_newline);
2015: end if;
2016: if l_bis_pri_rate_type is NULL then

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

2010: -- Mandatory Setup
2011: if l_prm_miss = 2 or l_prm_miss = 4 then
2012: pji_utils.write2out(l_newline ||l_pji_head4||l_newline||l_pji_line4||l_newline);
2013: if l_bis_pri_curr_code is NULL then
2014: pji_utils.write2out(l_p_bis_pri_curr_code||l_newline);
2015: end if;
2016: if l_bis_pri_rate_type is NULL then
2017: pji_utils.write2out(l_p_bis_pri_rate_type||l_newline);
2018: end if;

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

2013: if l_bis_pri_curr_code is NULL then
2014: pji_utils.write2out(l_p_bis_pri_curr_code||l_newline);
2015: end if;
2016: if l_bis_pri_rate_type is NULL then
2017: pji_utils.write2out(l_p_bis_pri_rate_type||l_newline);
2018: end if;
2019: if l_bis_ent_calendar is NULL then
2020: pji_utils.write2out(l_p_bis_ent_calendar||l_newline);
2021: end if;

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

2016: if l_bis_pri_rate_type is NULL then
2017: pji_utils.write2out(l_p_bis_pri_rate_type||l_newline);
2018: end if;
2019: if l_bis_ent_calendar is NULL then
2020: pji_utils.write2out(l_p_bis_ent_calendar||l_newline);
2021: end if;
2022: if l_bis_period_type is NULL then
2023: pji_utils.write2out(l_p_bis_period_type||l_newline);
2024: end if;

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

2019: if l_bis_ent_calendar is NULL then
2020: pji_utils.write2out(l_p_bis_ent_calendar||l_newline);
2021: end if;
2022: if l_bis_period_type is NULL then
2023: pji_utils.write2out(l_p_bis_period_type||l_newline);
2024: end if;
2025: if l_bis_global_start_date is NULL then
2026: pji_utils.write2out(l_p_bis_global_start_date||l_newline);
2027: end if;

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

2022: if l_bis_period_type is NULL then
2023: pji_utils.write2out(l_p_bis_period_type||l_newline);
2024: end if;
2025: if l_bis_global_start_date is NULL then
2026: pji_utils.write2out(l_p_bis_global_start_date||l_newline);
2027: end if;
2028: if l_planamt_conv_date is NULL then
2029: pji_utils.write2out(l_p_planamt_conv_date||l_newline);
2030: end if;

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

2025: if l_bis_global_start_date is NULL then
2026: pji_utils.write2out(l_p_bis_global_start_date||l_newline);
2027: end if;
2028: if l_planamt_conv_date is NULL then
2029: pji_utils.write2out(l_p_planamt_conv_date||l_newline);
2030: end if;
2031: if l_planamt_alloc_method is NULL then
2032: pji_utils.write2out(l_p_planamt_alloc_method||l_newline);
2033: end if;

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

2028: if l_planamt_conv_date is NULL then
2029: pji_utils.write2out(l_p_planamt_conv_date||l_newline);
2030: end if;
2031: if l_planamt_alloc_method is NULL then
2032: pji_utils.write2out(l_p_planamt_alloc_method||l_newline);
2033: end if;
2034: --- For Current reporting periods
2035: if l_curr_rep_pa_period is NULL or l_curr_rep_gl_period is NULL or
2036: l_curr_rep_ent_period is NULL then

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

2033: end if;
2034: --- For Current reporting periods
2035: if l_curr_rep_pa_period is NULL or l_curr_rep_gl_period is NULL or
2036: l_curr_rep_ent_period is NULL then
2037: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
2038: end if;
2039: if l_curr_rep_pa_period is NULL then
2040: pji_utils.write2out(l_p_curr_rep_pa_period||l_newline);
2041: end if;

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

2036: l_curr_rep_ent_period is NULL then
2037: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_PD')||l_newline);
2038: end if;
2039: if l_curr_rep_pa_period is NULL then
2040: pji_utils.write2out(l_p_curr_rep_pa_period||l_newline);
2041: end if;
2042: if l_curr_rep_gl_period is NULL then
2043: pji_utils.write2out(l_p_curr_rep_gl_period||l_newline);
2044: end if;

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

2039: if l_curr_rep_pa_period is NULL then
2040: pji_utils.write2out(l_p_curr_rep_pa_period||l_newline);
2041: end if;
2042: if l_curr_rep_gl_period is NULL then
2043: pji_utils.write2out(l_p_curr_rep_gl_period||l_newline);
2044: end if;
2045: if l_curr_rep_ent_period is NULL then
2046: pji_utils.write2out(l_p_curr_rep_ent_period||l_newline);
2047: end if;

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

2042: if l_curr_rep_gl_period is NULL then
2043: pji_utils.write2out(l_p_curr_rep_gl_period||l_newline);
2044: end if;
2045: if l_curr_rep_ent_period is NULL then
2046: pji_utils.write2out(l_p_curr_rep_ent_period||l_newline);
2047: end if;
2048: --- For Current reporting period when SPECIFIC
2049: if l_sp_note = 1 then
2050: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_MISS')||l_newline);

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

2046: pji_utils.write2out(l_p_curr_rep_ent_period||l_newline);
2047: end if;
2048: --- For Current reporting period when SPECIFIC
2049: if l_sp_note = 1 then
2050: pji_utils.write2out(l_newline||FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_MISS')||l_newline);
2051: end if;
2052:
2053: end if;
2054: -- Optional Set up

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

2052:
2053: end if;
2054: -- Optional Set up
2055: if l_prm_miss = 3 or l_prm_miss = 4 then
2056: pji_utils.write2out(l_newline ||l_pji_head5||l_newline||l_pji_line5||l_newline);
2057: if l_bis_sec_curr_code is NULL then
2058: pji_utils.write2out(l_p_bis_sec_curr_code||l_newline);
2059: end if;
2060: if l_bis_sec_rate_type is NULL then

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

2054: -- Optional Set up
2055: if l_prm_miss = 3 or l_prm_miss = 4 then
2056: pji_utils.write2out(l_newline ||l_pji_head5||l_newline||l_pji_line5||l_newline);
2057: if l_bis_sec_curr_code is NULL then
2058: pji_utils.write2out(l_p_bis_sec_curr_code||l_newline);
2059: end if;
2060: if l_bis_sec_rate_type is NULL then
2061: pji_utils.write2out(l_p_bis_sec_rate_type||l_newline);
2062: end if;

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

2057: if l_bis_sec_curr_code is NULL then
2058: pji_utils.write2out(l_p_bis_sec_curr_code||l_newline);
2059: end if;
2060: if l_bis_sec_rate_type is NULL then
2061: pji_utils.write2out(l_p_bis_sec_rate_type||l_newline);
2062: end if;
2063: if l_pji_global_start_date is NULL then
2064: pji_utils.write2out(l_p_pji_global_start_date||l_newline);
2065: end if;

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

2060: if l_bis_sec_rate_type is NULL then
2061: pji_utils.write2out(l_p_bis_sec_rate_type||l_newline);
2062: end if;
2063: if l_pji_global_start_date is NULL then
2064: pji_utils.write2out(l_p_pji_global_start_date||l_newline);
2065: end if;
2066: if l_glb_curr_flag is null then
2067: pji_utils.write2out(l_p_glb_curr_flag||l_newline);
2068: end if;

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

2063: if l_pji_global_start_date is NULL then
2064: pji_utils.write2out(l_p_pji_global_start_date||l_newline);
2065: end if;
2066: if l_glb_curr_flag is null then
2067: pji_utils.write2out(l_p_glb_curr_flag||l_newline);
2068: end if;
2069: if l_txn_curr_flag is null then
2070: pji_utils.write2out(l_p_txn_curr_flag||l_newline);
2071: end if;

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

2066: if l_glb_curr_flag is null then
2067: pji_utils.write2out(l_p_glb_curr_flag||l_newline);
2068: end if;
2069: if l_txn_curr_flag is null then
2070: pji_utils.write2out(l_p_txn_curr_flag||l_newline);
2071: end if;
2072: end if;
2073: --- Notes at the end of the report if any thing missing
2074: if l_prm_miss > 1 then

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

2071: end if;
2072: end if;
2073: --- Notes at the end of the report if any thing missing
2074: if l_prm_miss > 1 then
2075: pji_utils.write2out(l_newline||l_pji_foot1||l_newline);
2076: if l_bis_note > 0 then
2077: pji_utils.write2out(l_pji_foot2||l_newline);
2078: end if ;
2079: if l_pjp_note > 0 then

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

2073: --- Notes at the end of the report if any thing missing
2074: if l_prm_miss > 1 then
2075: pji_utils.write2out(l_newline||l_pji_foot1||l_newline);
2076: if l_bis_note > 0 then
2077: pji_utils.write2out(l_pji_foot2||l_newline);
2078: end if ;
2079: if l_pjp_note > 0 then
2080: pji_utils.write2out(l_pji_foot3||l_newline);
2081: end if ;

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

2076: if l_bis_note > 0 then
2077: pji_utils.write2out(l_pji_foot2||l_newline);
2078: end if ;
2079: if l_pjp_note > 0 then
2080: pji_utils.write2out(l_pji_foot3||l_newline);
2081: end if ;
2082: if l_sp_note > 0 then
2083: pji_utils.write2out(l_pji_foot4||l_newline);
2084: end if ;

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

2079: if l_pjp_note > 0 then
2080: pji_utils.write2out(l_pji_foot3||l_newline);
2081: end if ;
2082: if l_sp_note > 0 then
2083: pji_utils.write2out(l_pji_foot4||l_newline);
2084: end if ;
2085: end if;
2086: Exception when others then
2087: pji_utils.write2out('Error: '||l_err_msg);

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

2083: pji_utils.write2out(l_pji_foot4||l_newline);
2084: end if ;
2085: end if;
2086: Exception when others then
2087: pji_utils.write2out('Error: '||l_err_msg);
2088: END;
2089:
2090: -- -----------------------------------------------------
2091: -- Function PJI_LOOKUP_VALUE

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

2125: return VARCHAR2
2126: IS
2127: l_return varchar2(1):='N';
2128: BEGIN
2129: if (PJI_UTILS.GET_PARAMETER('PJI_PTC_UPGRADE') = 'P') then
2130:
2131: select 'Y'
2132: into l_return
2133: from dual

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

2163: IS
2164: l_status VARCHAR2(1);
2165: l_count NUMBER(10);
2166: begin
2167: select PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') into l_status from dual;
2168: IF l_status = 'P' THEN
2169: select count(1) into l_count from PJI_SYSTEM_CONFIG_HIST
2170: where PROCESS_NAME = 'STAGE3'
2171: and END_DATE is null and RUN_TYPE = 'CLEANALL';

Line 2224: end PJI_UTILS;

2220: end;
2221:
2222:
2223:
2224: end PJI_UTILS;