DBA Data[Home] [Help]

APPS.PJI_UTILS dependencies on FND_MESSAGE

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

1132: l_temp varchar2(1000) := null;
1133: BEGIN
1134:
1135:
1136: fnd_message.set_name('PJI','PJI_SUM_DBI_CURR_OUTPUT_HDR');
1137: l_msg := fnd_message.get || l_newline || l_newline;
1138:
1139:
1140: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_RATE_TYPE');

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

1133: BEGIN
1134:
1135:
1136: fnd_message.set_name('PJI','PJI_SUM_DBI_CURR_OUTPUT_HDR');
1137: l_msg := fnd_message.get || l_newline || l_newline;
1138:
1139:
1140: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_RATE_TYPE');
1141: l_temp:=substr(fnd_message.get, 1,g_length_rate_type );

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

1136: fnd_message.set_name('PJI','PJI_SUM_DBI_CURR_OUTPUT_HDR');
1137: l_msg := fnd_message.get || l_newline || l_newline;
1138:
1139:
1140: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_RATE_TYPE');
1141: l_temp:=substr(fnd_message.get, 1,g_length_rate_type );
1142: l_temp := l_temp|| substr(g_space, 1, g_length_rate_type - length(l_temp))||g_indenting;
1143: l_msg := l_msg || l_temp;
1144:

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

1137: l_msg := fnd_message.get || l_newline || l_newline;
1138:
1139:
1140: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_RATE_TYPE');
1141: l_temp:=substr(fnd_message.get, 1,g_length_rate_type );
1142: l_temp := l_temp|| substr(g_space, 1, g_length_rate_type - length(l_temp))||g_indenting;
1143: l_msg := l_msg || l_temp;
1144:
1145:

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

1143: l_msg := l_msg || l_temp;
1144:
1145:
1146:
1147: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_FROM_CURRENCY');
1148: l_temp := substr(fnd_message.get, 1, g_length_from_currency);
1149: l_temp := l_temp || substr(g_space, 1, g_length_from_currency - length(l_temp)) || g_indenting;
1150: l_msg := l_msg || l_temp;
1151:

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

1144:
1145:
1146:
1147: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_FROM_CURRENCY');
1148: l_temp := substr(fnd_message.get, 1, g_length_from_currency);
1149: l_temp := l_temp || substr(g_space, 1, g_length_from_currency - length(l_temp)) || g_indenting;
1150: l_msg := l_msg || l_temp;
1151:
1152: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_TO_CURRENCY');

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

1148: l_temp := substr(fnd_message.get, 1, g_length_from_currency);
1149: l_temp := l_temp || substr(g_space, 1, g_length_from_currency - length(l_temp)) || g_indenting;
1150: l_msg := l_msg || l_temp;
1151:
1152: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_TO_CURRENCY');
1153: l_temp:=substr(fnd_message.get, 1,g_length_to_currency );
1154: l_temp := l_temp || substr(g_space, 1, g_length_to_currency - length(l_temp)) || g_indenting;
1155: l_msg := l_msg || l_temp;
1156:

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

1149: l_temp := l_temp || substr(g_space, 1, g_length_from_currency - length(l_temp)) || g_indenting;
1150: l_msg := l_msg || l_temp;
1151:
1152: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_TO_CURRENCY');
1153: l_temp:=substr(fnd_message.get, 1,g_length_to_currency );
1154: l_temp := l_temp || substr(g_space, 1, g_length_to_currency - length(l_temp)) || g_indenting;
1155: l_msg := l_msg || l_temp;
1156:
1157: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_DATE');

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

1153: l_temp:=substr(fnd_message.get, 1,g_length_to_currency );
1154: l_temp := l_temp || substr(g_space, 1, g_length_to_currency - length(l_temp)) || g_indenting;
1155: l_msg := l_msg || l_temp;
1156:
1157: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_DATE');
1158: l_temp:=substr(fnd_message.get, 1,g_length_date );
1159: l_temp := l_temp || substr(g_space, 1, g_length_date - length(l_temp));
1160: l_msg := l_msg || l_temp || l_newline;
1161:

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

1154: l_temp := l_temp || substr(g_space, 1, g_length_to_currency - length(l_temp)) || g_indenting;
1155: l_msg := l_msg || l_temp;
1156:
1157: fnd_message.set_name('PJI','PJI_SUM_DBI_COL_DATE');
1158: l_temp:=substr(fnd_message.get, 1,g_length_date );
1159: l_temp := l_temp || substr(g_space, 1, g_length_date - length(l_temp));
1160: l_msg := l_msg || l_temp || l_newline;
1161:
1162: l_temp := substr(g_line, 1, g_length_rate_type)||g_indenting||

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

1629: end if;
1630: end if;
1631:
1632: -- For Getting the headings of the Audit report
1633: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_TEXT'),
1634: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),
1635: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1636: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1637: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),

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

1630: end if;
1631:
1632: -- For Getting the headings of the Audit report
1633: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_TEXT'),
1634: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),
1635: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1636: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1637: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1638: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),

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

1631:
1632: -- For Getting the headings of the Audit report
1633: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_TEXT'),
1634: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),
1635: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1636: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1637: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1638: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1639: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),

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

1632: -- For Getting the headings of the Audit report
1633: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_TEXT'),
1634: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),
1635: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1636: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1637: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1638: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1639: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1640: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),

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

1633: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_TEXT'),
1634: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),
1635: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1636: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1637: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1638: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1639: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1640: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1641: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),

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

1634: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),
1635: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1636: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1637: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1638: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1639: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1640: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1641: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),
1642: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),

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

1635: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
1636: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1637: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1638: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1639: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1640: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1641: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),
1642: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),
1643: FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')

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

1636: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
1637: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1638: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1639: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1640: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1641: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),
1642: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),
1643: FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')
1644: INTO l_pji_report_msg,l_pji_head1,l_pji_head2,l_pji_head3,l_pji_head4,l_pji_head5,

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

1637: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
1638: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1639: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1640: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1641: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),
1642: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),
1643: FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')
1644: INTO l_pji_report_msg,l_pji_head1,l_pji_head2,l_pji_head3,l_pji_head4,l_pji_head5,
1645: l_pji_foot1,l_pji_foot2,l_pji_foot3,l_pji_foot4,l_p_curr_rep_not

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

1638: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
1639: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1640: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1641: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),
1642: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),
1643: FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')
1644: INTO l_pji_report_msg,l_pji_head1,l_pji_head2,l_pji_head3,l_pji_head4,l_pji_head5,
1645: l_pji_foot1,l_pji_foot2,l_pji_foot3,l_pji_foot4,l_p_curr_rep_not
1646: FROM dual;

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

1639: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
1640: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
1641: FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),
1642: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),
1643: FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')
1644: INTO l_pji_report_msg,l_pji_head1,l_pji_head2,l_pji_head3,l_pji_head4,l_pji_head5,
1645: l_pji_foot1,l_pji_foot2,l_pji_foot3,l_pji_foot4,l_p_curr_rep_not
1646: FROM dual;
1647:

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