DBA Data[Home] [Help]

APPS.PJI_UTILS dependencies on FND_MESSAGE

Line 1253: fnd_message.set_name('PJI','PJI_SUM_DBI_CURR_OUTPUT_HDR');

1249: l_temp varchar2(1000) := null;
1250: BEGIN
1251:
1252:
1253: fnd_message.set_name('PJI','PJI_SUM_DBI_CURR_OUTPUT_HDR');
1254: l_msg := fnd_message.get || l_newline || l_newline;
1255:
1256:
1257: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_RATE_TYPE');

Line 1254: l_msg := fnd_message.get || l_newline || l_newline;

1250: BEGIN
1251:
1252:
1253: fnd_message.set_name('PJI','PJI_SUM_DBI_CURR_OUTPUT_HDR');
1254: l_msg := fnd_message.get || l_newline || l_newline;
1255:
1256:
1257: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_RATE_TYPE');
1258: l_temp:=substr(fnd_message.get, 1,g_length_rate_type );

Line 1257: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_RATE_TYPE');

1253: fnd_message.set_name('PJI','PJI_SUM_DBI_CURR_OUTPUT_HDR');
1254: l_msg := fnd_message.get || l_newline || l_newline;
1255:
1256:
1257: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_RATE_TYPE');
1258: l_temp:=substr(fnd_message.get, 1,g_length_rate_type );
1259: l_temp := l_temp|| substr(g_space, 1, g_length_rate_type - length(l_temp))||g_indenting;
1260: l_msg := l_msg || l_temp;
1261:

Line 1258: l_temp:=substr(fnd_message.get, 1,g_length_rate_type );

1254: l_msg := fnd_message.get || l_newline || l_newline;
1255:
1256:
1257: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_RATE_TYPE');
1258: l_temp:=substr(fnd_message.get, 1,g_length_rate_type );
1259: l_temp := l_temp|| substr(g_space, 1, g_length_rate_type - length(l_temp))||g_indenting;
1260: l_msg := l_msg || l_temp;
1261:
1262:

Line 1264: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_FROM_CURRENCY');

1260: l_msg := l_msg || l_temp;
1261:
1262:
1263:
1264: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_FROM_CURRENCY');
1265: l_temp := substr(fnd_message.get, 1, g_length_from_currency);
1266: l_temp := l_temp || substr(g_space, 1, g_length_from_currency - length(l_temp)) || g_indenting;
1267: l_msg := l_msg || l_temp;
1268:

Line 1265: l_temp := substr(fnd_message.get, 1, g_length_from_currency);

1261:
1262:
1263:
1264: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_FROM_CURRENCY');
1265: l_temp := substr(fnd_message.get, 1, g_length_from_currency);
1266: l_temp := l_temp || substr(g_space, 1, g_length_from_currency - length(l_temp)) || g_indenting;
1267: l_msg := l_msg || l_temp;
1268:
1269: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_TO_CURRENCY');

Line 1269: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_TO_CURRENCY');

1265: l_temp := substr(fnd_message.get, 1, g_length_from_currency);
1266: l_temp := l_temp || substr(g_space, 1, g_length_from_currency - length(l_temp)) || g_indenting;
1267: l_msg := l_msg || l_temp;
1268:
1269: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_TO_CURRENCY');
1270: l_temp:=substr(fnd_message.get, 1,g_length_to_currency );
1271: l_temp := l_temp || substr(g_space, 1, g_length_to_currency - length(l_temp)) || g_indenting;
1272: l_msg := l_msg || l_temp;
1273:

Line 1270: l_temp:=substr(fnd_message.get, 1,g_length_to_currency );

1266: l_temp := l_temp || substr(g_space, 1, g_length_from_currency - length(l_temp)) || g_indenting;
1267: l_msg := l_msg || l_temp;
1268:
1269: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_TO_CURRENCY');
1270: l_temp:=substr(fnd_message.get, 1,g_length_to_currency );
1271: l_temp := l_temp || substr(g_space, 1, g_length_to_currency - length(l_temp)) || g_indenting;
1272: l_msg := l_msg || l_temp;
1273:
1274: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_DATE');

Line 1274: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_DATE');

1270: l_temp:=substr(fnd_message.get, 1,g_length_to_currency );
1271: l_temp := l_temp || substr(g_space, 1, g_length_to_currency - length(l_temp)) || g_indenting;
1272: l_msg := l_msg || l_temp;
1273:
1274: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_DATE');
1275: l_temp:=substr(fnd_message.get, 1,g_length_date );
1276: l_temp := l_temp || substr(g_space, 1, g_length_date - length(l_temp));
1277: l_msg := l_msg || l_temp || l_newline;
1278:

Line 1275: l_temp:=substr(fnd_message.get, 1,g_length_date );

1271: l_temp := l_temp || substr(g_space, 1, g_length_to_currency - length(l_temp)) || g_indenting;
1272: l_msg := l_msg || l_temp;
1273:
1274: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_DATE');
1275: l_temp:=substr(fnd_message.get, 1,g_length_date );
1276: l_temp := l_temp || substr(g_space, 1, g_length_date - length(l_temp));
1277: l_msg := l_msg || l_temp || l_newline;
1278:
1279: l_temp := substr(g_line, 1, g_length_rate_type)||g_indenting||

Line 1797: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_TEXT'),

1793: end if;
1794: end if;
1795:
1796: -- For Getting the headings of the Audit report
1797: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_TEXT'),
1798: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),
1799: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1800: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1801: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),

Line 1798: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),

1794: end if;
1795:
1796: -- For Getting the headings of the Audit report
1797: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_TEXT'),
1798: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),
1799: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1800: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1801: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1802: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),

Line 1799: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),

1795:
1796: -- For Getting the headings of the Audit report
1797: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_TEXT'),
1798: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),
1799: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1800: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1801: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1802: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1803: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),

Line 1800: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),

1796: -- For Getting the headings of the Audit report
1797: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_TEXT'),
1798: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),
1799: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1800: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1801: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1802: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1803: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1804: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),

Line 1801: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),

1797: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_TEXT'),
1798: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),
1799: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1800: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1801: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1802: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1803: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1804: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1805: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),

Line 1802: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),

1798: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),
1799: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1800: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1801: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1802: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1803: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1804: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1805: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),
1806: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),

Line 1803: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),

1799: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1800: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1801: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1802: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1803: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1804: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1805: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),
1806: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),
1807: FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')

Line 1804: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),

1800: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1801: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1802: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1803: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1804: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1805: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),
1806: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),
1807: FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')
1808: INTO l_pji_report_msg,l_pji_head1,l_pji_head2,l_pji_head3,l_pji_head4,l_pji_head5,

Line 1805: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),

1801: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1802: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1803: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1804: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1805: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),
1806: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),
1807: FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')
1808: INTO l_pji_report_msg,l_pji_head1,l_pji_head2,l_pji_head3,l_pji_head4,l_pji_head5,
1809: l_pji_foot1,l_pji_foot2,l_pji_foot3,l_pji_foot4,l_p_curr_rep_not

Line 1806: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),

1802: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1803: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1804: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1805: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),
1806: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),
1807: FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')
1808: INTO l_pji_report_msg,l_pji_head1,l_pji_head2,l_pji_head3,l_pji_head4,l_pji_head5,
1809: l_pji_foot1,l_pji_foot2,l_pji_foot3,l_pji_foot4,l_p_curr_rep_not
1810: FROM dual;

Line 1807: FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')

1803: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1804: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1805: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),
1806: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),
1807: FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')
1808: INTO l_pji_report_msg,l_pji_head1,l_pji_head2,l_pji_head3,l_pji_head4,l_pji_head5,
1809: l_pji_foot1,l_pji_foot2,l_pji_foot3,l_pji_foot4,l_p_curr_rep_not
1810: FROM dual;
1811:

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 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 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 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 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