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.BIL_BI_SALES_MGMT_RPTS_PKG dependencies on FND_MESSAGE

Line 1146: fnd_message.set_name('FND','SQL_PLSQL_ERROR');

1142: WHEN OTHERS THEN
1143:
1144: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1145:
1146: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1147: fnd_message.set_token('ERROR' ,SQLCODE);
1148: fnd_message.set_token('REASON',SQLERRM);
1149:
1150: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 1147: fnd_message.set_token('ERROR' ,SQLCODE);

1143:
1144: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1145:
1146: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1147: fnd_message.set_token('ERROR' ,SQLCODE);
1148: fnd_message.set_token('REASON',SQLERRM);
1149:
1150: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1151: MODULE => g_pkg || l_proc || 'proc_error',

Line 1148: fnd_message.set_token('REASON',SQLERRM);

1144: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1145:
1146: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1147: fnd_message.set_token('ERROR' ,SQLCODE);
1148: fnd_message.set_token('REASON',SQLERRM);
1149:
1150: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1151: MODULE => g_pkg || l_proc || 'proc_error',
1152: MESSAGE => fnd_message.get );

Line 1152: MESSAGE => fnd_message.get );

1148: fnd_message.set_token('REASON',SQLERRM);
1149:
1150: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1151: MODULE => g_pkg || l_proc || 'proc_error',
1152: MESSAGE => fnd_message.get );
1153:
1154: END IF;
1155:
1156: RAISE;

Line 1333: l_cat_assign:=FND_MESSAGE.GET_STRING('BIL', 'BIL_BI_ASSIGN_CATEGORY');

1329:
1330:
1331: IF l_parameter_valid THEN
1332: --retrieve 'Item unassigned' message here. We should be retireving from Message dicts?
1333: l_cat_assign:=FND_MESSAGE.GET_STRING('BIL', 'BIL_BI_ASSIGN_CATEGORY');
1334:
1335:
1336: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1337:

Line 2813: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

2809: EXCEPTION
2810: WHEN OTHERS THEN
2811:
2812: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2813: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2814: fnd_message.set_token('Error is : ' ,SQLCODE);
2815: fnd_message.set_token('Reason is : ', SQLERRM);
2816:
2817: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 2814: fnd_message.set_token('Error is : ' ,SQLCODE);

2810: WHEN OTHERS THEN
2811:
2812: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2813: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2814: fnd_message.set_token('Error is : ' ,SQLCODE);
2815: fnd_message.set_token('Reason is : ', SQLERRM);
2816:
2817: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2818: MODULE => g_pkg || l_proc || 'proc_error',

Line 2815: fnd_message.set_token('Reason is : ', SQLERRM);

2811:
2812: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2813: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2814: fnd_message.set_token('Error is : ' ,SQLCODE);
2815: fnd_message.set_token('Reason is : ', SQLERRM);
2816:
2817: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2818: MODULE => g_pkg || l_proc || 'proc_error',
2819: MESSAGE => fnd_message.get );

Line 2819: MESSAGE => fnd_message.get );

2815: fnd_message.set_token('Reason is : ', SQLERRM);
2816:
2817: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2818: MODULE => g_pkg || l_proc || 'proc_error',
2819: MESSAGE => fnd_message.get );
2820:
2821: END IF;
2822: COMMIT;
2823: RAISE;

Line 2992: l_cat_assign:=FND_MESSAGE.GET_STRING('BIL', 'BIL_BI_ASSIGN_CATEGORY');

2988: */
2989:
2990: IF l_parameter_valid THEN
2991: --retrieve 'Item unassigned' message here. We should be retireving from Message dicts?
2992: l_cat_assign:=FND_MESSAGE.GET_STRING('BIL', 'BIL_BI_ASSIGN_CATEGORY');
2993:
2994: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2995:
2996: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

Line 3883: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

3879: EXCEPTION
3880: WHEN OTHERS THEN
3881:
3882: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3883: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3884: fnd_message.set_token('Error is : ' ,SQLCODE);
3885: fnd_message.set_token('Reason is : ', SQLERRM);
3886:
3887:

Line 3884: fnd_message.set_token('Error is : ' ,SQLCODE);

3880: WHEN OTHERS THEN
3881:
3882: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3883: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3884: fnd_message.set_token('Error is : ' ,SQLCODE);
3885: fnd_message.set_token('Reason is : ', SQLERRM);
3886:
3887:
3888: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 3885: fnd_message.set_token('Reason is : ', SQLERRM);

3881:
3882: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3883: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3884: fnd_message.set_token('Error is : ' ,SQLCODE);
3885: fnd_message.set_token('Reason is : ', SQLERRM);
3886:
3887:
3888: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3889: MODULE => g_pkg || l_proc || 'proc_error',

Line 3890: MESSAGE => fnd_message.get );

3886:
3887:
3888: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3889: MODULE => g_pkg || l_proc || 'proc_error',
3890: MESSAGE => fnd_message.get );
3891:
3892: END IF;
3893:
3894: COMMIT;

Line 4263: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

4259: EXCEPTION
4260: WHEN OTHERS THEN
4261:
4262: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4263: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4264: fnd_message.set_token('Error is : ' ,SQLCODE);
4265: fnd_message.set_token('Reason is : ', SQLERRM);
4266:
4267: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 4264: fnd_message.set_token('Error is : ' ,SQLCODE);

4260: WHEN OTHERS THEN
4261:
4262: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4263: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4264: fnd_message.set_token('Error is : ' ,SQLCODE);
4265: fnd_message.set_token('Reason is : ', SQLERRM);
4266:
4267: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
4268: MODULE => g_pkg || l_proc || 'proc_error',

Line 4265: fnd_message.set_token('Reason is : ', SQLERRM);

4261:
4262: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4263: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4264: fnd_message.set_token('Error is : ' ,SQLCODE);
4265: fnd_message.set_token('Reason is : ', SQLERRM);
4266:
4267: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
4268: MODULE => g_pkg || l_proc || 'proc_error',
4269: MESSAGE => fnd_message.get );

Line 4269: MESSAGE => fnd_message.get );

4265: fnd_message.set_token('Reason is : ', SQLERRM);
4266:
4267: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
4268: MODULE => g_pkg || l_proc || 'proc_error',
4269: MESSAGE => fnd_message.get );
4270:
4271:
4272: END IF;
4273: RAISE;

Line 5883: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

5879:
5880: EXCEPTION
5881: WHEN OTHERS THEN
5882: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5883: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
5884: fnd_message.set_token('LDOPBKLOG Error is : ' ,SQLCODE);
5885: fnd_message.set_token('Reason is : ', SQLERRM);
5886:
5887: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 5884: fnd_message.set_token('LDOPBKLOG Error is : ' ,SQLCODE);

5880: EXCEPTION
5881: WHEN OTHERS THEN
5882: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5883: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
5884: fnd_message.set_token('LDOPBKLOG Error is : ' ,SQLCODE);
5885: fnd_message.set_token('Reason is : ', SQLERRM);
5886:
5887: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
5888: MODULE => g_pkg || l_proc || 'proc_error',

Line 5885: fnd_message.set_token('Reason is : ', SQLERRM);

5881: WHEN OTHERS THEN
5882: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5883: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
5884: fnd_message.set_token('LDOPBKLOG Error is : ' ,SQLCODE);
5885: fnd_message.set_token('Reason is : ', SQLERRM);
5886:
5887: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
5888: MODULE => g_pkg || l_proc || 'proc_error',
5889: MESSAGE => fnd_message.get );

Line 5889: MESSAGE => fnd_message.get );

5885: fnd_message.set_token('Reason is : ', SQLERRM);
5886:
5887: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
5888: MODULE => g_pkg || l_proc || 'proc_error',
5889: MESSAGE => fnd_message.get );
5890: END IF;
5891:
5892: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
5893: ,x_sqlstr => x_custom_sql);

Line 6702: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

6698: EXCEPTION
6699: WHEN OTHERS THEN
6700:
6701: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6702: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
6703: fnd_message.set_token('Error is : ' ,SQLCODE);
6704: fnd_message.set_token('Reason is : ', SQLERRM);
6705:
6706: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 6703: fnd_message.set_token('Error is : ' ,SQLCODE);

6699: WHEN OTHERS THEN
6700:
6701: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6702: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
6703: fnd_message.set_token('Error is : ' ,SQLCODE);
6704: fnd_message.set_token('Reason is : ', SQLERRM);
6705:
6706: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
6707: MODULE => g_pkg || l_proc || 'proc_error',

Line 6704: fnd_message.set_token('Reason is : ', SQLERRM);

6700:
6701: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6702: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
6703: fnd_message.set_token('Error is : ' ,SQLCODE);
6704: fnd_message.set_token('Reason is : ', SQLERRM);
6705:
6706: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
6707: MODULE => g_pkg || l_proc || 'proc_error',
6708: MESSAGE => fnd_message.get );

Line 6708: MESSAGE => fnd_message.get );

6704: fnd_message.set_token('Reason is : ', SQLERRM);
6705:
6706: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
6707: MODULE => g_pkg || l_proc || 'proc_error',
6708: MESSAGE => fnd_message.get );
6709:
6710: END IF;
6711: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
6712: ,x_sqlstr => x_custom_sql);