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 1793: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

1789:
1790: WHEN OTHERS THEN
1791: x_return_status := FND_API.g_ret_sts_error;
1792: IF (l_uLog) THEN
1793: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1794: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1795: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1796: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1797: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

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

1790: WHEN OTHERS THEN
1791: x_return_status := FND_API.g_ret_sts_error;
1792: IF (l_uLog) THEN
1793: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1794: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1795: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1796: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1797: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1798: FND_MSG_PUB.ADD;

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

1791: x_return_status := FND_API.g_ret_sts_error;
1792: IF (l_uLog) THEN
1793: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1794: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1795: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1796: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1797: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1798: FND_MSG_PUB.ADD;
1799:

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

1792: IF (l_uLog) THEN
1793: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1794: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1795: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1796: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1797: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1798: FND_MSG_PUB.ADD;
1799:
1800: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');

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

1796: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1797: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1798: FND_MSG_PUB.ADD;
1799:
1800: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
1801: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
1802: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1803: FND_MSG_PUB.ADD;
1804:

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

1797: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1798: FND_MSG_PUB.ADD;
1799:
1800: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
1801: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
1802: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1803: FND_MSG_PUB.ADD;
1804:
1805: END IF;

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

2499:
2500: WHEN OTHERS THEN
2501: x_return_status := FND_API.g_ret_sts_error;
2502: IF (l_uLog) THEN
2503: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2504: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2505: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2506: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2507: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

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

2500: WHEN OTHERS THEN
2501: x_return_status := FND_API.g_ret_sts_error;
2502: IF (l_uLog) THEN
2503: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2504: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2505: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2506: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2507: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2508: FND_MSG_PUB.ADD;

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

2501: x_return_status := FND_API.g_ret_sts_error;
2502: IF (l_uLog) THEN
2503: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2504: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2505: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2506: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2507: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2508: FND_MSG_PUB.ADD;
2509:

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

2502: IF (l_uLog) THEN
2503: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2504: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2505: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2506: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2507: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2508: FND_MSG_PUB.ADD;
2509:
2510: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');

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

2506: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2507: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2508: FND_MSG_PUB.ADD;
2509:
2510: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2511: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
2512: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2513: FND_MSG_PUB.ADD;
2514:

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

2507: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2508: FND_MSG_PUB.ADD;
2509:
2510: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2511: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
2512: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2513: FND_MSG_PUB.ADD;
2514:
2515: END IF;

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

2876:
2877: WHEN OTHERS THEN
2878: x_return_status := FND_API.g_ret_sts_error;
2879: IF (l_uLog) THEN
2880: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2881: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2882: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2883: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2884: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

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

2877: WHEN OTHERS THEN
2878: x_return_status := FND_API.g_ret_sts_error;
2879: IF (l_uLog) THEN
2880: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2881: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2882: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2883: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2884: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2885: FND_MSG_PUB.ADD;

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

2878: x_return_status := FND_API.g_ret_sts_error;
2879: IF (l_uLog) THEN
2880: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2881: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2882: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2883: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2884: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2885: FND_MSG_PUB.ADD;
2886:

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

2879: IF (l_uLog) THEN
2880: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2881: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2882: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2883: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2884: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2885: FND_MSG_PUB.ADD;
2886:
2887: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');

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

2883: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2884: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2885: FND_MSG_PUB.ADD;
2886:
2887: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2888: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
2889: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2890: FND_MSG_PUB.ADD;
2891:

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

2884: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2885: FND_MSG_PUB.ADD;
2886:
2887: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2888: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
2889: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2890: FND_MSG_PUB.ADD;
2891:
2892: END IF;