DBA Data[Home] [Help]

APPS.BIL_BI_UTIL_PKG dependencies on FND_MESSAGE

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

46: WHEN OTHERS THEN
47:
48: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
49:
50: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
51: fnd_message.set_token('Error is : ' ,SQLCODE);
52: fnd_message.set_token('Reason is : ', SQLERRM);
53:
54: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

47:
48: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
49:
50: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
51: fnd_message.set_token('Error is : ' ,SQLCODE);
52: fnd_message.set_token('Reason is : ', SQLERRM);
53:
54: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
55: MODULE => g_pkg || '.chkLogLevel',

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

48: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
49:
50: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
51: fnd_message.set_token('Error is : ' ,SQLCODE);
52: fnd_message.set_token('Reason is : ', SQLERRM);
53:
54: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
55: MODULE => g_pkg || '.chkLogLevel',
56: MESSAGE => fnd_message.get );

Line 56: MESSAGE => fnd_message.get );

52: fnd_message.set_token('Reason is : ', SQLERRM);
53:
54: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
55: MODULE => g_pkg || '.chkLogLevel',
56: MESSAGE => fnd_message.get );
57:
58: END IF;
59:
60: END chkLogLevel;

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

132: WHEN OTHERS THEN
133:
134: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
135:
136: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
137: fnd_message.set_token('Error is : ' ,SQLCODE);
138: fnd_message.set_token('Reason is : ', SQLERRM);
139:
140: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

133:
134: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
135:
136: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
137: fnd_message.set_token('Error is : ' ,SQLCODE);
138: fnd_message.set_token('Reason is : ', SQLERRM);
139:
140: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
141: MODULE => g_pkg || '.get_conv_rate',

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

134: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
135:
136: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
137: fnd_message.set_token('Error is : ' ,SQLCODE);
138: fnd_message.set_token('Reason is : ', SQLERRM);
139:
140: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
141: MODULE => g_pkg || '.get_conv_rate',
142: MESSAGE => fnd_message.get );

Line 142: MESSAGE => fnd_message.get );

138: fnd_message.set_token('Reason is : ', SQLERRM);
139:
140: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
141: MODULE => g_pkg || '.get_conv_rate',
142: MESSAGE => fnd_message.get );
143:
144: END IF;
145:
146:

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

168: WHEN OTHERS THEN
169:
170: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
171:
172: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
173: fnd_message.set_token('Error is : ' ,SQLCODE);
174: fnd_message.set_token('Reason is : ', SQLERRM);
175:
176:

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

169:
170: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
171:
172: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
173: fnd_message.set_token('Error is : ' ,SQLCODE);
174: fnd_message.set_token('Reason is : ', SQLERRM);
175:
176:
177: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

170: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
171:
172: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
173: fnd_message.set_token('Error is : ' ,SQLCODE);
174: fnd_message.set_token('Reason is : ', SQLERRM);
175:
176:
177: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
178: MODULE => g_pkg || '.get_curr_date',

Line 179: MESSAGE => fnd_message.get );

175:
176:
177: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
178: MODULE => g_pkg || '.get_curr_date',
179: MESSAGE => fnd_message.get );
180:
181: END IF;
182: END;
183:

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

237:
238:
239: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
240:
241: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
242: fnd_message.set_token('Error is : ' ,SQLCODE);
243: fnd_message.set_token('Reason is : ', SQLERRM);
244:
245: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

238:
239: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
240:
241: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
242: fnd_message.set_token('Error is : ' ,SQLCODE);
243: fnd_message.set_token('Reason is : ', SQLERRM);
244:
245: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
246: MODULE => g_pkg || '.get_dbi_params',

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

239: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
240:
241: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
242: fnd_message.set_token('Error is : ' ,SQLCODE);
243: fnd_message.set_token('Reason is : ', SQLERRM);
244:
245: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
246: MODULE => g_pkg || '.get_dbi_params',
247: MESSAGE => fnd_message.get );

Line 247: MESSAGE => fnd_message.get );

243: fnd_message.set_token('Reason is : ', SQLERRM);
244:
245: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
246: MODULE => g_pkg || '.get_dbi_params',
247: MESSAGE => fnd_message.get );
248:
249: END IF;
250:
251: END;

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

285: WHEN OTHERS THEN
286:
287: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
288:
289: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
290: fnd_message.set_token('Error is : ' ,SQLCODE);
291: fnd_message.set_token('Reason is : ', SQLERRM);
292:
293: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

286:
287: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
288:
289: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
290: fnd_message.set_token('Error is : ' ,SQLCODE);
291: fnd_message.set_token('Reason is : ', SQLERRM);
292:
293: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
294: MODULE => g_pkg || '.get_dbi_sales_group_id',

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

287: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
288:
289: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
290: fnd_message.set_token('Error is : ' ,SQLCODE);
291: fnd_message.set_token('Reason is : ', SQLERRM);
292:
293: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
294: MODULE => g_pkg || '.get_dbi_sales_group_id',
295: MESSAGE => fnd_message.get );

Line 295: MESSAGE => fnd_message.get );

291: fnd_message.set_token('Reason is : ', SQLERRM);
292:
293: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
294: MODULE => g_pkg || '.get_dbi_sales_group_id',
295: MESSAGE => fnd_message.get );
296: END IF;
297: END;
298:
299: RETURN l_sg_id;

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

365: WHEN OTHERS THEN
366:
367: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
368:
369: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
370: fnd_message.set_token('Error is : ' ,SQLCODE);
371: fnd_message.set_token('Reason is : ', SQLERRM);
372:
373: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

366:
367: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
368:
369: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
370: fnd_message.set_token('Error is : ' ,SQLCODE);
371: fnd_message.set_token('Reason is : ', SQLERRM);
372:
373: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
374: MODULE => g_pkg || '.get_default_query',

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

367: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
368:
369: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
370: fnd_message.set_token('Error is : ' ,SQLCODE);
371: fnd_message.set_token('Reason is : ', SQLERRM);
372:
373: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
374: MODULE => g_pkg || '.get_default_query',
375: MESSAGE => fnd_message.get );

Line 375: MESSAGE => fnd_message.get );

371: fnd_message.set_token('Reason is : ', SQLERRM);
372:
373: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
374: MODULE => g_pkg || '.get_default_query',
375: MESSAGE => fnd_message.get );
376:
377: END IF;
378: END;
379:

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

418: WHEN OTHERS THEN
419:
420: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
421:
422: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
423: fnd_message.set_token('Error is : ' ,SQLCODE);
424: fnd_message.set_token('Reason is : ', SQLERRM);
425:
426: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

419:
420: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
421:
422: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
423: fnd_message.set_token('Error is : ' ,SQLCODE);
424: fnd_message.set_token('Reason is : ', SQLERRM);
425:
426: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
427: MODULE => g_pkg || '.get_forecast_profiles',

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

420: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
421:
422: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
423: fnd_message.set_token('Error is : ' ,SQLCODE);
424: fnd_message.set_token('Reason is : ', SQLERRM);
425:
426: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
427: MODULE => g_pkg || '.get_forecast_profiles',
428: MESSAGE => fnd_message.get );

Line 428: MESSAGE => fnd_message.get );

424: fnd_message.set_token('Reason is : ', SQLERRM);
425:
426: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
427: MODULE => g_pkg || '.get_forecast_profiles',
428: MESSAGE => fnd_message.get );
429:
430: END IF;
431: END;
432:

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

476: EXCEPTION
477: WHEN OTHERS THEN
478:
479: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
480: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
481: fnd_message.set_token('Error is : ' ,SQLCODE);
482: fnd_message.set_token('Reason is : ', SQLERRM);
483:
484: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

477: WHEN OTHERS THEN
478:
479: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
480: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
481: fnd_message.set_token('Error is : ' ,SQLCODE);
482: fnd_message.set_token('Reason is : ', SQLERRM);
483:
484: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
485: MODULE => g_pkg || '.get_global_conts',

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

478:
479: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
480: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
481: fnd_message.set_token('Error is : ' ,SQLCODE);
482: fnd_message.set_token('Reason is : ', SQLERRM);
483:
484: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
485: MODULE => g_pkg || '.get_global_conts',
486: MESSAGE => fnd_message.get );

Line 486: MESSAGE => fnd_message.get );

482: fnd_message.set_token('Reason is : ', SQLERRM);
483:
484: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
485: MODULE => g_pkg || '.get_global_conts',
486: MESSAGE => fnd_message.get );
487:
488: END IF;
489: END GET_GLOBAL_CONTS;
490:

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

570: EXCEPTION
571: WHEN OTHERS THEN
572:
573: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
574: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
575: fnd_message.set_token('Error is : ' ,SQLCODE);
576: fnd_message.set_token('Reason is : ', SQLERRM);
577:
578: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

571: WHEN OTHERS THEN
572:
573: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
574: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
575: fnd_message.set_token('Error is : ' ,SQLCODE);
576: fnd_message.set_token('Reason is : ', SQLERRM);
577:
578: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
579: MODULE => g_pkg || '.get_latest_snapshot',

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

572:
573: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
574: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
575: fnd_message.set_token('Error is : ' ,SQLCODE);
576: fnd_message.set_token('Reason is : ', SQLERRM);
577:
578: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
579: MODULE => g_pkg || '.get_latest_snapshot',
580: MESSAGE => fnd_message.get );

Line 580: MESSAGE => fnd_message.get );

576: fnd_message.set_token('Reason is : ', SQLERRM);
577:
578: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
579: MODULE => g_pkg || '.get_latest_snapshot',
580: MESSAGE => fnd_message.get );
581:
582: END IF;
583: END;
584:

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

608: EXCEPTION
609: WHEN OTHERS THEN
610:
611: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
612: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
613: fnd_message.set_token('Error is : ' ,SQLCODE);
614: fnd_message.set_token('Reason is : ', SQLERRM);
615:
616: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

609: WHEN OTHERS THEN
610:
611: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
612: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
613: fnd_message.set_token('Error is : ' ,SQLCODE);
614: fnd_message.set_token('Reason is : ', SQLERRM);
615:
616: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
617: MODULE => g_pkg || '.get_other_profiles',

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

610:
611: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
612: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
613: fnd_message.set_token('Error is : ' ,SQLCODE);
614: fnd_message.set_token('Reason is : ', SQLERRM);
615:
616: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
617: MODULE => g_pkg || '.get_other_profiles',
618: MESSAGE => fnd_message.get );

Line 618: MESSAGE => fnd_message.get );

614: fnd_message.set_token('Reason is : ', SQLERRM);
615:
616: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
617: MODULE => g_pkg || '.get_other_profiles',
618: MESSAGE => fnd_message.get );
619: END IF;
620: END;
621:
622:

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

1058:
1059: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1060: l_parameter_valid := FALSE;
1061: x_parameter_valid := l_parameter_valid;
1062: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1063: fnd_message.set_token('ERROR',SQLCODE);
1064: fnd_message.set_token('REASON', SQLERRM);
1065:
1066: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

1059: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1060: l_parameter_valid := FALSE;
1061: x_parameter_valid := l_parameter_valid;
1062: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1063: fnd_message.set_token('ERROR',SQLCODE);
1064: fnd_message.set_token('REASON', SQLERRM);
1065:
1066: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1067: MODULE => g_pkg ||'.getParentSalesGroup',

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

1060: l_parameter_valid := FALSE;
1061: x_parameter_valid := l_parameter_valid;
1062: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1063: fnd_message.set_token('ERROR',SQLCODE);
1064: fnd_message.set_token('REASON', SQLERRM);
1065:
1066: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1067: MODULE => g_pkg ||'.getParentSalesGroup',
1068: MESSAGE => fnd_message.get );

Line 1068: MESSAGE => fnd_message.get );

1064: fnd_message.set_token('REASON', SQLERRM);
1065:
1066: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1067: MODULE => g_pkg ||'.getParentSalesGroup',
1068: MESSAGE => fnd_message.get );
1069:
1070: END IF;
1071: END get_parent_sls_grp_id;
1072:

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

1157: WHEN OTHERS THEN
1158:
1159: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1160:
1161: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1162: fnd_message.set_token('ERROR' ,SQLCODE);
1163: fnd_message.set_token('REASON',SQLERRM);
1164: fnd_message.set_token('ROUTINE',l_proc);
1165:

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

1158:
1159: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1160:
1161: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1162: fnd_message.set_token('ERROR' ,SQLCODE);
1163: fnd_message.set_token('REASON',SQLERRM);
1164: fnd_message.set_token('ROUTINE',l_proc);
1165:
1166: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

1159: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1160:
1161: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1162: fnd_message.set_token('ERROR' ,SQLCODE);
1163: fnd_message.set_token('REASON',SQLERRM);
1164: fnd_message.set_token('ROUTINE',l_proc);
1165:
1166: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1167: MODULE => g_pkg || l_proc,

Line 1164: fnd_message.set_token('ROUTINE',l_proc);

1160:
1161: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1162: fnd_message.set_token('ERROR' ,SQLCODE);
1163: fnd_message.set_token('REASON',SQLERRM);
1164: fnd_message.set_token('ROUTINE',l_proc);
1165:
1166: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1167: MODULE => g_pkg || l_proc,
1168: MESSAGE => fnd_message.get );

Line 1168: MESSAGE => fnd_message.get );

1164: fnd_message.set_token('ROUTINE',l_proc);
1165:
1166: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1167: MODULE => g_pkg || l_proc,
1168: MESSAGE => fnd_message.get );
1169: END IF;
1170: END get_Product_Where_Clause;
1171:
1172: /* **********************************************************************

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

1244: EXCEPTION
1245: WHEN OTHERS THEN
1246:
1247: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1248: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1249: fnd_message.set_token('ERROR' ,SQLCODE);
1250: fnd_message.set_token('REASON',SQLERRM);
1251: fnd_message.set_token('ROUTINE',l_proc);
1252:

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

1245: WHEN OTHERS THEN
1246:
1247: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1248: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1249: fnd_message.set_token('ERROR' ,SQLCODE);
1250: fnd_message.set_token('REASON',SQLERRM);
1251: fnd_message.set_token('ROUTINE',l_proc);
1252:
1253: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

1246:
1247: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1248: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1249: fnd_message.set_token('ERROR' ,SQLCODE);
1250: fnd_message.set_token('REASON',SQLERRM);
1251: fnd_message.set_token('ROUTINE',l_proc);
1252:
1253: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1254: MODULE => g_pkg || l_proc ,

Line 1251: fnd_message.set_token('ROUTINE',l_proc);

1247: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1248: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1249: fnd_message.set_token('ERROR' ,SQLCODE);
1250: fnd_message.set_token('REASON',SQLERRM);
1251: fnd_message.set_token('ROUTINE',l_proc);
1252:
1253: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1254: MODULE => g_pkg || l_proc ,
1255: MESSAGE => fnd_message.get );

Line 1255: MESSAGE => fnd_message.get );

1251: fnd_message.set_token('ROUTINE',l_proc);
1252:
1253: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1254: MODULE => g_pkg || l_proc ,
1255: MESSAGE => fnd_message.get );
1256:
1257: END IF;
1258: END get_PC_NoRollup_Where_Clause;
1259: -- **********************************************************************

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

1407:
1408: WHEN OTHERS THEN
1409: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1410:
1411: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1412: fnd_message.set_token('Error is : ' ,SQLCODE);
1413: fnd_message.set_token('Reason is : ', SQLERRM);
1414:
1415: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

1408: WHEN OTHERS THEN
1409: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1410:
1411: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1412: fnd_message.set_token('Error is : ' ,SQLCODE);
1413: fnd_message.set_token('Reason is : ', SQLERRM);
1414:
1415: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1416: MODULE => g_pkg || '.get_trend_params',

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

1409: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1410:
1411: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1412: fnd_message.set_token('Error is : ' ,SQLCODE);
1413: fnd_message.set_token('Reason is : ', SQLERRM);
1414:
1415: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1416: MODULE => g_pkg || '.get_trend_params',
1417: MESSAGE => fnd_message.get );

Line 1417: MESSAGE => fnd_message.get );

1413: fnd_message.set_token('Reason is : ', SQLERRM);
1414:
1415: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1416: MODULE => g_pkg || '.get_trend_params',
1417: MESSAGE => fnd_message.get );
1418:
1419: END IF;
1420: END GET_TREND_PARAMS;
1421: -- **********************************************************************

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

1438: EXCEPTION
1439: WHEN OTHERS THEN
1440:
1441: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1442: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1443: fnd_message.set_token('Error is : ' ,SQLCODE);
1444: fnd_message.set_token('Reason is : ', SQLERRM);
1445:
1446: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

1439: WHEN OTHERS THEN
1440:
1441: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1442: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1443: fnd_message.set_token('Error is : ' ,SQLCODE);
1444: fnd_message.set_token('Reason is : ', SQLERRM);
1445:
1446: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1447: MODULE => g_pkg || '. GET_UNASSIGNED_PC',

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

1440:
1441: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1442: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1443: fnd_message.set_token('Error is : ' ,SQLCODE);
1444: fnd_message.set_token('Reason is : ', SQLERRM);
1445:
1446: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1447: MODULE => g_pkg || '. GET_UNASSIGNED_PC',
1448: MESSAGE => fnd_message.get );

Line 1448: MESSAGE => fnd_message.get );

1444: fnd_message.set_token('Reason is : ', SQLERRM);
1445:
1446: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1447: MODULE => g_pkg || '. GET_UNASSIGNED_PC',
1448: MESSAGE => fnd_message.get );
1449:
1450: END IF;
1451: END GET_UNASSIGNED_PC;
1452:

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

1545:
1546: WHEN OTHERS THEN
1547:
1548: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1549: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1550: fnd_message.set_token('Error is : ' ,SQLCODE);
1551: fnd_message.set_token('Reason is : ', SQLERRM);
1552:
1553: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

1546: WHEN OTHERS THEN
1547:
1548: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1549: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1550: fnd_message.set_token('Error is : ' ,SQLCODE);
1551: fnd_message.set_token('Reason is : ', SQLERRM);
1552:
1553: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1554: MODULE => g_pkg || '.isLeafNode',

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

1547:
1548: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1549: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1550: fnd_message.set_token('Error is : ' ,SQLCODE);
1551: fnd_message.set_token('Reason is : ', SQLERRM);
1552:
1553: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1554: MODULE => g_pkg || '.isLeafNode',
1555: MESSAGE => fnd_message.get );

Line 1555: MESSAGE => fnd_message.get );

1551: fnd_message.set_token('Reason is : ', SQLERRM);
1552:
1553: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1554: MODULE => g_pkg || '.isLeafNode',
1555: MESSAGE => fnd_message.get );
1556:
1557:
1558: END IF;
1559:

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

1629: EXCEPTION
1630: WHEN OTHERS THEN
1631:
1632: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1633: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1634: fnd_message.set_token('ERROR',SQLCODE);
1635: fnd_message.set_token('REASON', SQLERRM);
1636:
1637: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

1630: WHEN OTHERS THEN
1631:
1632: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1633: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1634: fnd_message.set_token('ERROR',SQLCODE);
1635: fnd_message.set_token('REASON', SQLERRM);
1636:
1637: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1638: MODULE => g_pkg ||'.getLookupMeaning',

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

1631:
1632: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1633: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1634: fnd_message.set_token('ERROR',SQLCODE);
1635: fnd_message.set_token('REASON', SQLERRM);
1636:
1637: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1638: MODULE => g_pkg ||'.getLookupMeaning',
1639: MESSAGE => fnd_message.get );

Line 1639: MESSAGE => fnd_message.get );

1635: fnd_message.set_token('REASON', SQLERRM);
1636:
1637: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1638: MODULE => g_pkg ||'.getLookupMeaning',
1639: MESSAGE => fnd_message.get );
1640:
1641: END IF;
1642:
1643: END getLookupMeaning;

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

1828:
1829: WHEN OTHERS THEN
1830:
1831: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1832: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1833: fnd_message.set_token('Error is : ' ,SQLCODE);
1834: fnd_message.set_token('Reason is : ', SQLERRM);
1835:
1836: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

1829: WHEN OTHERS THEN
1830:
1831: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1832: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1833: fnd_message.set_token('Error is : ' ,SQLCODE);
1834: fnd_message.set_token('Reason is : ', SQLERRM);
1835:
1836: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1837: MODULE => g_pkg || '. GET_PRIOR_PRIOR_TIME',

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

1830:
1831: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1832: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1833: fnd_message.set_token('Error is : ' ,SQLCODE);
1834: fnd_message.set_token('Reason is : ', SQLERRM);
1835:
1836: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1837: MODULE => g_pkg || '. GET_PRIOR_PRIOR_TIME',
1838: MESSAGE => fnd_message.get );

Line 1838: MESSAGE => fnd_message.get );

1834: fnd_message.set_token('Reason is : ', SQLERRM);
1835:
1836: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1837: MODULE => g_pkg || '. GET_PRIOR_PRIOR_TIME',
1838: MESSAGE => fnd_message.get );
1839: END IF;
1840: END GET_PRIOR_PRIOR_TIME;
1841:
1842: -- **********************************************************************************

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

1912: EXCEPTION
1913:
1914: WHEN OTHERS THEN
1915: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1916: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1917: fnd_message.set_token('Error is : ' ,SQLCODE);
1918: fnd_message.set_token('Reason is : ', SQLERRM);
1919:
1920: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

1913:
1914: WHEN OTHERS THEN
1915: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1916: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1917: fnd_message.set_token('Error is : ' ,SQLCODE);
1918: fnd_message.set_token('Reason is : ', SQLERRM);
1919:
1920: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1921: MODULE => g_pkg || l_proc,

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

1914: WHEN OTHERS THEN
1915: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1916: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1917: fnd_message.set_token('Error is : ' ,SQLCODE);
1918: fnd_message.set_token('Reason is : ', SQLERRM);
1919:
1920: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1921: MODULE => g_pkg || l_proc,
1922: MESSAGE => fnd_message.get );

Line 1922: MESSAGE => fnd_message.get );

1918: fnd_message.set_token('Reason is : ', SQLERRM);
1919:
1920: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1921: MODULE => g_pkg || l_proc,
1922: MESSAGE => fnd_message.get );
1923:
1924: END IF;
1925:
1926: END GET_DRILL_LINKS;

Line 1969: l_label:=FND_MESSAGE.GET_STRING('BIL','BIL_BI_LABEL_SGRP_FCST');

1965: END LOOP;
1966:
1967:
1968: IF l_resource_id is NULL THEN
1969: l_label:=FND_MESSAGE.GET_STRING('BIL','BIL_BI_LABEL_SGRP_FCST');
1970: ELSE
1971: l_label:=FND_MESSAGE.GET_STRING('BIL','BIL_BI_LABEL_SREP_FCST');
1972: END IF;
1973:

Line 1971: l_label:=FND_MESSAGE.GET_STRING('BIL','BIL_BI_LABEL_SREP_FCST');

1967:
1968: IF l_resource_id is NULL THEN
1969: l_label:=FND_MESSAGE.GET_STRING('BIL','BIL_BI_LABEL_SGRP_FCST');
1970: ELSE
1971: l_label:=FND_MESSAGE.GET_STRING('BIL','BIL_BI_LABEL_SREP_FCST');
1972: END IF;
1973:
1974: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1975:

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

1985:
1986: WHEN OTHERS THEN
1987:
1988: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1989: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1990: fnd_message.set_token('Error is : ' ,SQLCODE);
1991: fnd_message.set_token('Reason is : ', SQLERRM);
1992:
1993: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

1986: WHEN OTHERS THEN
1987:
1988: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1989: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1990: fnd_message.set_token('Error is : ' ,SQLCODE);
1991: fnd_message.set_token('Reason is : ', SQLERRM);
1992:
1993: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1994: MODULE => g_pkg || l_proc,

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

1987:
1988: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1989: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1990: fnd_message.set_token('Error is : ' ,SQLCODE);
1991: fnd_message.set_token('Reason is : ', SQLERRM);
1992:
1993: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1994: MODULE => g_pkg || l_proc,
1995: MESSAGE => fnd_message.get );

Line 1995: MESSAGE => fnd_message.get );

1991: fnd_message.set_token('Reason is : ', SQLERRM);
1992:
1993: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1994: MODULE => g_pkg || l_proc,
1995: MESSAGE => fnd_message.get );
1996:
1997: END IF;
1998: RETURN 'Direct Reports Forecast';
1999:

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

2111:
2112: WHEN OTHERS THEN
2113:
2114: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2115: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2116: fnd_message.set_token('Error is : ' ,SQLCODE);
2117: fnd_message.set_token('Reason is : ', SQLERRM);
2118:
2119: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

2112: WHEN OTHERS THEN
2113:
2114: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2115: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2116: fnd_message.set_token('Error is : ' ,SQLCODE);
2117: fnd_message.set_token('Reason is : ', SQLERRM);
2118:
2119: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2120: MODULE => g_pkg || l_proc,

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

2113:
2114: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2115: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2116: fnd_message.set_token('Error is : ' ,SQLCODE);
2117: fnd_message.set_token('Reason is : ', SQLERRM);
2118:
2119: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2120: MODULE => g_pkg || l_proc,
2121: MESSAGE => fnd_message.get );

Line 2121: MESSAGE => fnd_message.get );

2117: fnd_message.set_token('Reason is : ', SQLERRM);
2118:
2119: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2120: MODULE => g_pkg || l_proc,
2121: MESSAGE => fnd_message.get );
2122: END IF;
2123:
2124: END GET_PIPE_SNAP_DATE;
2125:

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

2244:
2245: WHEN OTHERS THEN
2246:
2247: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2248: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2249: fnd_message.set_token('Error is : ' ,SQLCODE);
2250: fnd_message.set_token('Reason is : ', SQLERRM);
2251:
2252: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

2245: WHEN OTHERS THEN
2246:
2247: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2248: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2249: fnd_message.set_token('Error is : ' ,SQLCODE);
2250: fnd_message.set_token('Reason is : ', SQLERRM);
2251:
2252: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2253: MODULE => g_pkg || l_proc,

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

2246:
2247: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2248: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2249: fnd_message.set_token('Error is : ' ,SQLCODE);
2250: fnd_message.set_token('Reason is : ', SQLERRM);
2251:
2252: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2253: MODULE => g_pkg || l_proc,
2254: MESSAGE => fnd_message.get );

Line 2254: MESSAGE => fnd_message.get );

2250: fnd_message.set_token('Reason is : ', SQLERRM);
2251:
2252: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2253: MODULE => g_pkg || l_proc,
2254: MESSAGE => fnd_message.get );
2255:
2256: END IF;
2257:
2258: END GET_PIPE_MV;

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

2349:
2350: WHEN OTHERS THEN
2351:
2352: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2353: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2354: fnd_message.set_token('Error is : ' ,SQLCODE);
2355: fnd_message.set_token('Reason is : ', SQLERRM);
2356:
2357: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

2350: WHEN OTHERS THEN
2351:
2352: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2353: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2354: fnd_message.set_token('Error is : ' ,SQLCODE);
2355: fnd_message.set_token('Reason is : ', SQLERRM);
2356:
2357: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2358: MODULE => g_pkg || l_proc,

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

2351:
2352: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2353: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2354: fnd_message.set_token('Error is : ' ,SQLCODE);
2355: fnd_message.set_token('Reason is : ', SQLERRM);
2356:
2357: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2358: MODULE => g_pkg || l_proc,
2359: MESSAGE => fnd_message.get );

Line 2359: MESSAGE => fnd_message.get );

2355: fnd_message.set_token('Reason is : ', SQLERRM);
2356:
2357: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2358: MODULE => g_pkg || l_proc,
2359: MESSAGE => fnd_message.get );
2360:
2361: END IF;
2362:
2363: END GET_HIST_SNAPSHOT_DATE;

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

2475:
2476: WHEN OTHERS THEN
2477:
2478: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2479: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2480: fnd_message.set_token('Error is : ' ,SQLCODE);
2481: fnd_message.set_token('Reason is : ', SQLERRM);
2482:
2483: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

2476: WHEN OTHERS THEN
2477:
2478: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2479: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2480: fnd_message.set_token('Error is : ' ,SQLCODE);
2481: fnd_message.set_token('Reason is : ', SQLERRM);
2482:
2483: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2484: MODULE => g_pkg || l_proc,

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

2477:
2478: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2479: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2480: fnd_message.set_token('Error is : ' ,SQLCODE);
2481: fnd_message.set_token('Reason is : ', SQLERRM);
2482:
2483: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2484: MODULE => g_pkg || l_proc,
2485: MESSAGE => fnd_message.get );

Line 2485: MESSAGE => fnd_message.get );

2481: fnd_message.set_token('Reason is : ', SQLERRM);
2482:
2483: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2484: MODULE => g_pkg || l_proc,
2485: MESSAGE => fnd_message.get );
2486:
2487: END IF;
2488:
2489: END GET_PIPE_COL_NAMES;

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

2626:
2627: WHEN OTHERS THEN
2628:
2629: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2630: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2631: fnd_message.set_token('Error is : ' ,SQLCODE);
2632: fnd_message.set_token('Reason is : ', SQLERRM);
2633:
2634: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

2627: WHEN OTHERS THEN
2628:
2629: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2630: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2631: fnd_message.set_token('Error is : ' ,SQLCODE);
2632: fnd_message.set_token('Reason is : ', SQLERRM);
2633:
2634: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2635: MODULE => g_pkg || l_proc,

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

2628:
2629: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2630: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2631: fnd_message.set_token('Error is : ' ,SQLCODE);
2632: fnd_message.set_token('Reason is : ', SQLERRM);
2633:
2634: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2635: MODULE => g_pkg || l_proc,
2636: MESSAGE => fnd_message.get );

Line 2636: MESSAGE => fnd_message.get );

2632: fnd_message.set_token('Reason is : ', SQLERRM);
2633:
2634: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2635: MODULE => g_pkg || l_proc,
2636: MESSAGE => fnd_message.get );
2637:
2638: END IF;
2639:
2640: END GET_PIPE_TREND_SOURCE;