DBA Data[Home] [Help]

APPS.CSE_IPA_TRANS_PKG dependencies on FND_MESSAGE

Line 218: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

214: END IF;
215:
216: EXCEPTION
217: WHEN others THEN
218: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
219: fnd_message.set_token('ERR_MSG', sqlerrm);
220: l_error_message := fnd_message.get;
221: x_error_message := l_error_message;
222: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 219: fnd_message.set_token('ERR_MSG', sqlerrm);

215:
216: EXCEPTION
217: WHEN others THEN
218: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
219: fnd_message.set_token('ERR_MSG', sqlerrm);
220: l_error_message := fnd_message.get;
221: x_error_message := l_error_message;
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: END populate_pa_interface;

Line 220: l_error_message := fnd_message.get;

216: EXCEPTION
217: WHEN others THEN
218: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
219: fnd_message.set_token('ERR_MSG', sqlerrm);
220: l_error_message := fnd_message.get;
221: x_error_message := l_error_message;
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: END populate_pa_interface;
224:

Line 273: fnd_message.set_name('CSE', 'CSE_ASSET_CAT_ERROR');

269:
270: END IF;
271:
272: IF l_asset_category_id is null THEN
273: fnd_message.set_name('CSE', 'CSE_ASSET_CAT_ERROR');
274: fnd_msg_pub.add;
275: RAISE fnd_api.g_exc_error ;
276: END IF;
277:

Line 307: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');

303: WHERE category_id = l_asset_category_id
304: AND book_type_code = l_book_type_code);
305: EXCEPTION
306: WHEN no_data_found THEN
307: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');
308: fnd_message.set_token('ASSET_CAT', l_con_asset_category);
309: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);
310: fnd_msg_pub.add;
311: END;

Line 308: fnd_message.set_token('ASSET_CAT', l_con_asset_category);

304: AND book_type_code = l_book_type_code);
305: EXCEPTION
306: WHEN no_data_found THEN
307: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');
308: fnd_message.set_token('ASSET_CAT', l_con_asset_category);
309: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);
310: fnd_msg_pub.add;
311: END;
312:

Line 309: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);

305: EXCEPTION
306: WHEN no_data_found THEN
307: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');
308: fnd_message.set_token('ASSET_CAT', l_con_asset_category);
309: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);
310: fnd_msg_pub.add;
311: END;
312:
313: -- removes the delimiter

Line 336: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

332: x_error_message := nvl(l_error_message, cse_util_pkg.dump_error_stack);
333: x_return_status := l_return_status;
334:
335: WHEN OTHERS THEN
336: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
337: fnd_message.set_token('ERR_MSG', sqlerrm);
338: fnd_msg_pub.add;
339: x_error_message := cse_util_pkg.dump_error_stack;
340: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 337: fnd_message.set_token('ERR_MSG', sqlerrm);

333: x_return_status := l_return_status;
334:
335: WHEN OTHERS THEN
336: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
337: fnd_message.set_token('ERR_MSG', sqlerrm);
338: fnd_msg_pub.add;
339: x_error_message := cse_util_pkg.dump_error_stack;
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341: END get_fa_asset_category;

Line 410: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

406: WHEN asset_loc_exp THEN
407: x_error_message := l_error_message;
408: x_return_status := l_return_status;
409: WHEN OTHERS THEN
410: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
411: fnd_message.set_token('ERR_MSG', sqlerrm);
412: l_error_message := fnd_message.get;
413: x_error_message :=l_error_message;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 411: fnd_message.set_token('ERR_MSG', sqlerrm);

407: x_error_message := l_error_message;
408: x_return_status := l_return_status;
409: WHEN OTHERS THEN
410: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
411: fnd_message.set_token('ERR_MSG', sqlerrm);
412: l_error_message := fnd_message.get;
413: x_error_message :=l_error_message;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: END get_fa_location_segment;

Line 412: l_error_message := fnd_message.get;

408: x_return_status := l_return_status;
409: WHEN OTHERS THEN
410: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
411: fnd_message.set_token('ERR_MSG', sqlerrm);
412: l_error_message := fnd_message.get;
413: x_error_message :=l_error_message;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: END get_fa_location_segment;
416:

Line 462: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

458: x_product_name := l_product_name;
459:
460: EXCEPTION
461: WHEN OTHERS THEN
462: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
463: fnd_message.set_token('ERR_MSG', sqlerrm);
464: l_error_message := fnd_message.get;
465: x_error_message :=l_error_message;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 463: fnd_message.set_token('ERR_MSG', sqlerrm);

459:
460: EXCEPTION
461: WHEN OTHERS THEN
462: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
463: fnd_message.set_token('ERR_MSG', sqlerrm);
464: l_error_message := fnd_message.get;
465: x_error_message :=l_error_message;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467: END get_product_name;

Line 464: l_error_message := fnd_message.get;

460: EXCEPTION
461: WHEN OTHERS THEN
462: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
463: fnd_message.set_token('ERR_MSG', sqlerrm);
464: l_error_message := fnd_message.get;
465: x_error_message :=l_error_message;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467: END get_product_name;
468:

Line 574: fnd_message.set_name('CSE', 'CSE_CRL_GRP_NOT_FOUND');

570: END IF;
571:
572: EXCEPTION
573: WHEN no_data_found THEN
574: fnd_message.set_name('CSE', 'CSE_CRL_GRP_NOT_FOUND');
575: fnd_message.set_token('ORG_ID', p_org_id);
576: fnd_msg_pub.add;
577: l_error_message := cse_util_pkg.dump_error_stack;
578: RAISE fnd_api.g_exc_error;

Line 575: fnd_message.set_token('ORG_ID', p_org_id);

571:
572: EXCEPTION
573: WHEN no_data_found THEN
574: fnd_message.set_name('CSE', 'CSE_CRL_GRP_NOT_FOUND');
575: fnd_message.set_token('ORG_ID', p_org_id);
576: fnd_msg_pub.add;
577: l_error_message := cse_util_pkg.dump_error_stack;
578: RAISE fnd_api.g_exc_error;
579: END;

Line 586: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

582: WHEN fnd_api.g_exc_error THEN
583: x_error_message := l_error_message;
584: x_return_status := l_return_status;
585: WHEN OTHERS THEN
586: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
587: fnd_message.set_token('ERR_MSG', sqlerrm);
588: l_error_message := fnd_message.get;
589: x_error_message := l_error_message;
590: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 587: fnd_message.set_token('ERR_MSG', sqlerrm);

583: x_error_message := l_error_message;
584: x_return_status := l_return_status;
585: WHEN OTHERS THEN
586: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
587: fnd_message.set_token('ERR_MSG', sqlerrm);
588: l_error_message := fnd_message.get;
589: x_error_message := l_error_message;
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591: END get_grouping_attribute;

Line 588: l_error_message := fnd_message.get;

584: x_return_status := l_return_status;
585: WHEN OTHERS THEN
586: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
587: fnd_message.set_token('ERR_MSG', sqlerrm);
588: l_error_message := fnd_message.get;
589: x_error_message := l_error_message;
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591: END get_grouping_attribute;
592: