DBA Data[Home] [Help]

APPS.CST_LCMADJUSTMENTS_PVT dependencies on FND_MESSAGE

Line 162: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');

158: x_return_status => l_return_status);
159:
160: IF l_return_status <> FND_API.g_ret_sts_success THEN
161: IF l_exceptionLog THEN
162: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
163: fnd_message.set_token('CALLED','Validate_Lc_Interface');
164:
165: END IF;
166:

Line 163: fnd_message.set_token('CALLED','Validate_Lc_Interface');

159:
160: IF l_return_status <> FND_API.g_ret_sts_success THEN
161: IF l_exceptionLog THEN
162: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
163: fnd_message.set_token('CALLED','Validate_Lc_Interface');
164:
165: END IF;
166:
167: RAISE FND_API.g_exc_unexpected_error;

Line 201: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');

197: x_return_status => l_return_status);
198:
199: IF l_return_status <> FND_API.g_ret_sts_success THEN
200: IF l_exceptionLog THEN
201: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
202: fnd_message.set_token('CALLED','Populate_Temp_Adjustment_Data');
203:
204: END IF;
205: RAISE FND_API.g_exc_unexpected_error;

Line 202: fnd_message.set_token('CALLED','Populate_Temp_Adjustment_Data');

198:
199: IF l_return_status <> FND_API.g_ret_sts_success THEN
200: IF l_exceptionLog THEN
201: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
202: fnd_message.set_token('CALLED','Populate_Temp_Adjustment_Data');
203:
204: END IF;
205: RAISE FND_API.g_exc_unexpected_error;
206: END IF;

Line 221: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');

217: x_return_status => l_return_status);
218:
219: IF l_return_status <> FND_API.g_ret_sts_success THEN
220: IF l_exceptionLog THEN
221: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
222: fnd_message.set_token('CALLED','Populate_Temp_Adjustment_Data');
223:
224: END IF;
225:

Line 222: fnd_message.set_token('CALLED','Populate_Temp_Adjustment_Data');

218:
219: IF l_return_status <> FND_API.g_ret_sts_success THEN
220: IF l_exceptionLog THEN
221: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
222: fnd_message.set_token('CALLED','Populate_Temp_Adjustment_Data');
223:
224: END IF;
225:
226: RAISE FND_API.g_exc_unexpected_error;

Line 243: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');

239: x_return_status => l_return_status);
240:
241: IF l_return_status <> FND_API.g_ret_sts_success THEN
242: IF l_exceptionLog THEN
243: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
244: fnd_message.set_token('CALLED','Insert_Adjustment_Data');
245:
246: END IF;
247: RAISE FND_API.g_exc_unexpected_error;

Line 244: fnd_message.set_token('CALLED','Insert_Adjustment_Data');

240:
241: IF l_return_status <> FND_API.g_ret_sts_success THEN
242: IF l_exceptionLog THEN
243: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
244: fnd_message.set_token('CALLED','Insert_Adjustment_Data');
245:
246: END IF;
247: RAISE FND_API.g_exc_unexpected_error;
248: END IF;

Line 276: FND_MESSAGE.SET_NAME('BOM', 'CST_INVALID_LCM_TRANSACTIONS');

272:
273: EXCEPTION
274: WHEN INVALID_ADJUSTMENT_TXNS THEN
275:
276: FND_MESSAGE.SET_NAME('BOM', 'CST_INVALID_LCM_TRANSACTIONS');
277: FND_MESSAGE.SET_TOKEN('NUM', l_no_of_errored);
278: FND_MESSAGE.SET_TOKEN('ORG', p_organization_id);
279: FND_MESSAGE.SET_TOKEN('GROUP', p_group_id);
280: FND_MESSAGE.SET_MODULE(l_module);

Line 277: FND_MESSAGE.SET_TOKEN('NUM', l_no_of_errored);

273: EXCEPTION
274: WHEN INVALID_ADJUSTMENT_TXNS THEN
275:
276: FND_MESSAGE.SET_NAME('BOM', 'CST_INVALID_LCM_TRANSACTIONS');
277: FND_MESSAGE.SET_TOKEN('NUM', l_no_of_errored);
278: FND_MESSAGE.SET_TOKEN('ORG', p_organization_id);
279: FND_MESSAGE.SET_TOKEN('GROUP', p_group_id);
280: FND_MESSAGE.SET_MODULE(l_module);
281: fnd_file.put_line( FND_FILE.LOG, FND_MESSAGE.GET);

Line 278: FND_MESSAGE.SET_TOKEN('ORG', p_organization_id);

274: WHEN INVALID_ADJUSTMENT_TXNS THEN
275:
276: FND_MESSAGE.SET_NAME('BOM', 'CST_INVALID_LCM_TRANSACTIONS');
277: FND_MESSAGE.SET_TOKEN('NUM', l_no_of_errored);
278: FND_MESSAGE.SET_TOKEN('ORG', p_organization_id);
279: FND_MESSAGE.SET_TOKEN('GROUP', p_group_id);
280: FND_MESSAGE.SET_MODULE(l_module);
281: fnd_file.put_line( FND_FILE.LOG, FND_MESSAGE.GET);
282:

Line 279: FND_MESSAGE.SET_TOKEN('GROUP', p_group_id);

275:
276: FND_MESSAGE.SET_NAME('BOM', 'CST_INVALID_LCM_TRANSACTIONS');
277: FND_MESSAGE.SET_TOKEN('NUM', l_no_of_errored);
278: FND_MESSAGE.SET_TOKEN('ORG', p_organization_id);
279: FND_MESSAGE.SET_TOKEN('GROUP', p_group_id);
280: FND_MESSAGE.SET_MODULE(l_module);
281: fnd_file.put_line( FND_FILE.LOG, FND_MESSAGE.GET);
282:
283: IF l_ulog THEN

Line 280: FND_MESSAGE.SET_MODULE(l_module);

276: FND_MESSAGE.SET_NAME('BOM', 'CST_INVALID_LCM_TRANSACTIONS');
277: FND_MESSAGE.SET_TOKEN('NUM', l_no_of_errored);
278: FND_MESSAGE.SET_TOKEN('ORG', p_organization_id);
279: FND_MESSAGE.SET_TOKEN('GROUP', p_group_id);
280: FND_MESSAGE.SET_MODULE(l_module);
281: fnd_file.put_line( FND_FILE.LOG, FND_MESSAGE.GET);
282:
283: IF l_ulog THEN
284: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

Line 281: fnd_file.put_line( FND_FILE.LOG, FND_MESSAGE.GET);

277: FND_MESSAGE.SET_TOKEN('NUM', l_no_of_errored);
278: FND_MESSAGE.SET_TOKEN('ORG', p_organization_id);
279: FND_MESSAGE.SET_TOKEN('GROUP', p_group_id);
280: FND_MESSAGE.SET_MODULE(l_module);
281: fnd_file.put_line( FND_FILE.LOG, FND_MESSAGE.GET);
282:
283: IF l_ulog THEN
284: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
285: END IF;

Line 287: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',FND_MESSAGE.GET);

283: IF l_ulog THEN
284: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
285: END IF;
286:
287: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',FND_MESSAGE.GET);
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK;
291:

Line 297: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',FND_MESSAGE.GET);

293: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
294: END IF;
295:
296: /* Set concurrent program status to error */
297: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',FND_MESSAGE.GET);
298:
299: WHEN FND_API.G_EXC_ERROR THEN
300: ROLLBACK;
301:

Line 307: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',FND_MESSAGE.GET);

303: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
304: END IF;
305:
306: /* Set concurrent program status to error */
307: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',FND_MESSAGE.GET);
308:
309: WHEN OTHERS THEN
310: ROLLBACK;
311:

Line 312: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

308:
309: WHEN OTHERS THEN
310: ROLLBACK;
311:
312: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
313: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
314: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
315: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
316: IF (l_uLog) THEN

Line 313: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

309: WHEN OTHERS THEN
310: ROLLBACK;
311:
312: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
313: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
314: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
315: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
316: IF (l_uLog) THEN
317: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

Line 314: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

310: ROLLBACK;
311:
312: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
313: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
314: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
315: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
316: IF (l_uLog) THEN
317: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
318: FND_MSG_PUB.ADD;

Line 315: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

311:
312: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
313: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
314: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
315: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
316: IF (l_uLog) THEN
317: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
318: FND_MSG_PUB.ADD;
319:

Line 322: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');

318: FND_MSG_PUB.ADD;
319:
320: END IF;
321:
322: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
323: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
324: IF (l_uLog) THEN
325: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
326: FND_MSG_PUB.ADD;

Line 323: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);

319:
320: END IF;
321:
322: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
323: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
324: IF (l_uLog) THEN
325: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
326: FND_MSG_PUB.ADD;
327:

Line 332: FND_MESSAGE.GET);

328: END IF;
329:
330: /* Set concurrent program status to error */
331: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',
332: FND_MESSAGE.GET);
333: fnd_file.put_line( FND_FILE.LOG, FND_MESSAGE.GET);
334:
335: END Process_LcmAdjustments;
336:

Line 333: fnd_file.put_line( FND_FILE.LOG, FND_MESSAGE.GET);

329:
330: /* Set concurrent program status to error */
331: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',
332: FND_MESSAGE.GET);
333: fnd_file.put_line( FND_FILE.LOG, FND_MESSAGE.GET);
334:
335: END Process_LcmAdjustments;
336:
337: /*===========================================================================+

Line 1052: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

1048:
1049: WHEN OTHERS THEN
1050: x_return_status := FND_API.g_ret_sts_error;
1051: IF (l_uLog) THEN
1052: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1053: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1054: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1055: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1056: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

Line 1053: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

1049: WHEN OTHERS THEN
1050: x_return_status := FND_API.g_ret_sts_error;
1051: IF (l_uLog) THEN
1052: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1053: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1054: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1055: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1056: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1057: FND_MSG_PUB.ADD;

Line 1054: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

1050: x_return_status := FND_API.g_ret_sts_error;
1051: IF (l_uLog) THEN
1052: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1053: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1054: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1055: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1056: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1057: FND_MSG_PUB.ADD;
1058:

Line 1055: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

1051: IF (l_uLog) THEN
1052: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1053: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1054: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1055: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1056: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1057: FND_MSG_PUB.ADD;
1058:
1059: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');

Line 1059: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');

1055: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1056: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1057: FND_MSG_PUB.ADD;
1058:
1059: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
1060: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
1061: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1062: FND_MSG_PUB.ADD;
1063:

Line 1060: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);

1056: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1057: FND_MSG_PUB.ADD;
1058:
1059: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
1060: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
1061: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1062: FND_MSG_PUB.ADD;
1063:
1064: END IF;

Line 1775: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

1771:
1772: WHEN OTHERS THEN
1773: x_return_status := FND_API.g_ret_sts_error;
1774: IF (l_uLog) THEN
1775: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1776: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1777: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1778: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1779: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

Line 1776: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

1772: WHEN OTHERS THEN
1773: x_return_status := FND_API.g_ret_sts_error;
1774: IF (l_uLog) THEN
1775: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1776: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1777: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1778: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1779: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1780: FND_MSG_PUB.ADD;

Line 1777: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

1773: x_return_status := FND_API.g_ret_sts_error;
1774: IF (l_uLog) THEN
1775: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1776: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1777: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1778: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1779: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1780: FND_MSG_PUB.ADD;
1781:

Line 1778: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

1774: IF (l_uLog) THEN
1775: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1776: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1777: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1778: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1779: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1780: FND_MSG_PUB.ADD;
1781:
1782: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');

Line 1782: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');

1778: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1779: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1780: FND_MSG_PUB.ADD;
1781:
1782: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
1783: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
1784: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1785: FND_MSG_PUB.ADD;
1786:

Line 1783: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);

1779: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1780: FND_MSG_PUB.ADD;
1781:
1782: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
1783: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
1784: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1785: FND_MSG_PUB.ADD;
1786:
1787: END IF;

Line 2485: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

2481:
2482: WHEN OTHERS THEN
2483: x_return_status := FND_API.g_ret_sts_error;
2484: IF (l_uLog) THEN
2485: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2486: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2487: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2488: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2489: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

Line 2486: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

2482: WHEN OTHERS THEN
2483: x_return_status := FND_API.g_ret_sts_error;
2484: IF (l_uLog) THEN
2485: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2486: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2487: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2488: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2489: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2490: FND_MSG_PUB.ADD;

Line 2487: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

2483: x_return_status := FND_API.g_ret_sts_error;
2484: IF (l_uLog) THEN
2485: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2486: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2487: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2488: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2489: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2490: FND_MSG_PUB.ADD;
2491:

Line 2488: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

2484: IF (l_uLog) THEN
2485: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2486: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2487: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2488: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2489: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2490: FND_MSG_PUB.ADD;
2491:
2492: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');

Line 2492: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');

2488: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2489: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2490: FND_MSG_PUB.ADD;
2491:
2492: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2493: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
2494: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2495: FND_MSG_PUB.ADD;
2496:

Line 2493: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);

2489: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2490: FND_MSG_PUB.ADD;
2491:
2492: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2493: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
2494: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2495: FND_MSG_PUB.ADD;
2496:
2497: END IF;

Line 2858: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

2854:
2855: WHEN OTHERS THEN
2856: x_return_status := FND_API.g_ret_sts_error;
2857: IF (l_uLog) THEN
2858: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2859: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2860: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2861: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2862: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

Line 2859: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

2855: WHEN OTHERS THEN
2856: x_return_status := FND_API.g_ret_sts_error;
2857: IF (l_uLog) THEN
2858: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2859: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2860: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2861: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2862: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2863: FND_MSG_PUB.ADD;

Line 2860: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

2856: x_return_status := FND_API.g_ret_sts_error;
2857: IF (l_uLog) THEN
2858: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2859: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2860: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2861: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2862: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2863: FND_MSG_PUB.ADD;
2864:

Line 2861: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

2857: IF (l_uLog) THEN
2858: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2859: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2860: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2861: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2862: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2863: FND_MSG_PUB.ADD;
2864:
2865: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');

Line 2865: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');

2861: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2862: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2863: FND_MSG_PUB.ADD;
2864:
2865: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2866: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
2867: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2868: FND_MSG_PUB.ADD;
2869:

Line 2866: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);

2862: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2863: FND_MSG_PUB.ADD;
2864:
2865: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2866: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
2867: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2868: FND_MSG_PUB.ADD;
2869:
2870: END IF;