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

Line 104: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');

100:
101: EXCEPTION
102: WHEN NO_DATA_FOUND THEN
103: x_return_status := FND_API.G_RET_STS_ERROR ;
104: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
105: fnd_message.set_token('ASSET_ATTRIBUTE','DESCRIPTION');
106: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
107: x_error_msg := fnd_message.get;
108: RETURN NULL ;

Line 105: fnd_message.set_token('ASSET_ATTRIBUTE','DESCRIPTION');

101: EXCEPTION
102: WHEN NO_DATA_FOUND THEN
103: x_return_status := FND_API.G_RET_STS_ERROR ;
104: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
105: fnd_message.set_token('ASSET_ATTRIBUTE','DESCRIPTION');
106: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
107: x_error_msg := fnd_message.get;
108: RETURN NULL ;
109: WHEN OTHERS THEN

Line 106: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);

102: WHEN NO_DATA_FOUND THEN
103: x_return_status := FND_API.G_RET_STS_ERROR ;
104: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
105: fnd_message.set_token('ASSET_ATTRIBUTE','DESCRIPTION');
106: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
107: x_error_msg := fnd_message.get;
108: RETURN NULL ;
109: WHEN OTHERS THEN
110: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 107: x_error_msg := fnd_message.get;

103: x_return_status := FND_API.G_RET_STS_ERROR ;
104: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
105: fnd_message.set_token('ASSET_ATTRIBUTE','DESCRIPTION');
106: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
107: x_error_msg := fnd_message.get;
108: RETURN NULL ;
109: WHEN OTHERS THEN
110: x_return_status := FND_API.G_RET_STS_ERROR ;
111: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

Line 111: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

107: x_error_msg := fnd_message.get;
108: RETURN NULL ;
109: WHEN OTHERS THEN
110: x_return_status := FND_API.G_RET_STS_ERROR ;
111: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
112: fnd_message.set_token('API_NAME',l_api_name);
113: fnd_message.set_token('SQL_ERROR',SQLERRM);
114: x_error_msg := fnd_message.get;
115: RETURN NULL ;

Line 112: fnd_message.set_token('API_NAME',l_api_name);

108: RETURN NULL ;
109: WHEN OTHERS THEN
110: x_return_status := FND_API.G_RET_STS_ERROR ;
111: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
112: fnd_message.set_token('API_NAME',l_api_name);
113: fnd_message.set_token('SQL_ERROR',SQLERRM);
114: x_error_msg := fnd_message.get;
115: RETURN NULL ;
116: END asset_description ;

Line 113: fnd_message.set_token('SQL_ERROR',SQLERRM);

109: WHEN OTHERS THEN
110: x_return_status := FND_API.G_RET_STS_ERROR ;
111: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
112: fnd_message.set_token('API_NAME',l_api_name);
113: fnd_message.set_token('SQL_ERROR',SQLERRM);
114: x_error_msg := fnd_message.get;
115: RETURN NULL ;
116: END asset_description ;
117:

Line 114: x_error_msg := fnd_message.get;

110: x_return_status := FND_API.G_RET_STS_ERROR ;
111: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
112: fnd_message.set_token('API_NAME',l_api_name);
113: fnd_message.set_token('SQL_ERROR',SQLERRM);
114: x_error_msg := fnd_message.get;
115: RETURN NULL ;
116: END asset_description ;
117:
118: ---------------------------------------------------------------------------+

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

183: EXCEPTION
184: WHEN e_error
185: THEN
186: x_return_status := FND_API.G_RET_STS_ERROR ;
187: fnd_message.set_name('CSE','CSE_ASSET_CAT_ERROR');
188: x_error_msg := fnd_message.get;
189: RETURN NULL ;
190: WHEN OTHERS
191: THEN

Line 188: x_error_msg := fnd_message.get;

184: WHEN e_error
185: THEN
186: x_return_status := FND_API.G_RET_STS_ERROR ;
187: fnd_message.set_name('CSE','CSE_ASSET_CAT_ERROR');
188: x_error_msg := fnd_message.get;
189: RETURN NULL ;
190: WHEN OTHERS
191: THEN
192: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 193: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

189: RETURN NULL ;
190: WHEN OTHERS
191: THEN
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
194: fnd_message.set_token('API_NAME',l_api_name);
195: fnd_message.set_token('SQL_ERROR',SQLERRM);
196: x_error_msg := fnd_message.get;
197: RETURN NULL;

Line 194: fnd_message.set_token('API_NAME',l_api_name);

190: WHEN OTHERS
191: THEN
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
194: fnd_message.set_token('API_NAME',l_api_name);
195: fnd_message.set_token('SQL_ERROR',SQLERRM);
196: x_error_msg := fnd_message.get;
197: RETURN NULL;
198: END asset_category ;

Line 195: fnd_message.set_token('SQL_ERROR',SQLERRM);

191: THEN
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
194: fnd_message.set_token('API_NAME',l_api_name);
195: fnd_message.set_token('SQL_ERROR',SQLERRM);
196: x_error_msg := fnd_message.get;
197: RETURN NULL;
198: END asset_category ;
199:

Line 196: x_error_msg := fnd_message.get;

192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
194: fnd_message.set_token('API_NAME',l_api_name);
195: fnd_message.set_token('SQL_ERROR',SQLERRM);
196: x_error_msg := fnd_message.get;
197: RETURN NULL;
198: END asset_category ;
199:
200: ---------------------------------------------------------------------------+

Line 308: fnd_message.set_name('CSE','CSE_ASSET_BOOK_ERROR');

304: EXCEPTION
305: WHEN e_error
306: THEN
307: x_return_status := FND_API.G_RET_STS_ERROR ;
308: fnd_message.set_name('CSE','CSE_ASSET_BOOK_ERROR');
309: x_error_msg := fnd_message.get;
310: RETURN NULL ;
311: WHEN OTHERS
312: THEN

Line 309: x_error_msg := fnd_message.get;

305: WHEN e_error
306: THEN
307: x_return_status := FND_API.G_RET_STS_ERROR ;
308: fnd_message.set_name('CSE','CSE_ASSET_BOOK_ERROR');
309: x_error_msg := fnd_message.get;
310: RETURN NULL ;
311: WHEN OTHERS
312: THEN
313: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 314: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

310: RETURN NULL ;
311: WHEN OTHERS
312: THEN
313: x_return_status := FND_API.G_RET_STS_ERROR ;
314: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
315: fnd_message.set_token('API_NAME',l_api_name);
316: fnd_message.set_token('SQL_ERROR',SQLERRM);
317: x_error_msg := fnd_message.get;
318: RETURN NULL;

Line 315: fnd_message.set_token('API_NAME',l_api_name);

311: WHEN OTHERS
312: THEN
313: x_return_status := FND_API.G_RET_STS_ERROR ;
314: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
315: fnd_message.set_token('API_NAME',l_api_name);
316: fnd_message.set_token('SQL_ERROR',SQLERRM);
317: x_error_msg := fnd_message.get;
318: RETURN NULL;
319: END book_type;

Line 316: fnd_message.set_token('SQL_ERROR',SQLERRM);

312: THEN
313: x_return_status := FND_API.G_RET_STS_ERROR ;
314: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
315: fnd_message.set_token('API_NAME',l_api_name);
316: fnd_message.set_token('SQL_ERROR',SQLERRM);
317: x_error_msg := fnd_message.get;
318: RETURN NULL;
319: END book_type;
320:

Line 317: x_error_msg := fnd_message.get;

313: x_return_status := FND_API.G_RET_STS_ERROR ;
314: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
315: fnd_message.set_token('API_NAME',l_api_name);
316: fnd_message.set_token('SQL_ERROR',SQLERRM);
317: x_error_msg := fnd_message.get;
318: RETURN NULL;
319: END book_type;
320:
321: --------------------------------------------------------------------------

Line 430: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');

426:
427: EXCEPTION
428: WHEN fnd_api.g_exc_error THEN
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
431: fnd_message.set_token('ASSET_ATTRIBUTE','DATE_PLACED_IN_SERVICE');
432: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
433: x_error_msg := fnd_message.get;
434: RETURN null ;

Line 431: fnd_message.set_token('ASSET_ATTRIBUTE','DATE_PLACED_IN_SERVICE');

427: EXCEPTION
428: WHEN fnd_api.g_exc_error THEN
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
431: fnd_message.set_token('ASSET_ATTRIBUTE','DATE_PLACED_IN_SERVICE');
432: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
433: x_error_msg := fnd_message.get;
434: RETURN null ;
435: END date_place_in_service ;

Line 432: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);

428: WHEN fnd_api.g_exc_error THEN
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
431: fnd_message.set_token('ASSET_ATTRIBUTE','DATE_PLACED_IN_SERVICE');
432: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
433: x_error_msg := fnd_message.get;
434: RETURN null ;
435: END date_place_in_service ;
436:

Line 433: x_error_msg := fnd_message.get;

429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
431: fnd_message.set_token('ASSET_ATTRIBUTE','DATE_PLACED_IN_SERVICE');
432: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
433: x_error_msg := fnd_message.get;
434: RETURN null ;
435: END date_place_in_service ;
436:
437:

Line 461: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

457:
458: EXCEPTION
459: WHEN OTHERS THEN
460: x_return_status := FND_API.G_RET_STS_ERROR ;
461: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
462: fnd_message.set_token('API_NAME',l_api_name);
463: fnd_message.set_token('SQL_ERROR',SQLERRM);
464: x_error_msg := fnd_message.get;
465: RETURN NULL;

Line 462: fnd_message.set_token('API_NAME',l_api_name);

458: EXCEPTION
459: WHEN OTHERS THEN
460: x_return_status := FND_API.G_RET_STS_ERROR ;
461: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
462: fnd_message.set_token('API_NAME',l_api_name);
463: fnd_message.set_token('SQL_ERROR',SQLERRM);
464: x_error_msg := fnd_message.get;
465: RETURN NULL;
466: END asset_key;

Line 463: fnd_message.set_token('SQL_ERROR',SQLERRM);

459: WHEN OTHERS THEN
460: x_return_status := FND_API.G_RET_STS_ERROR ;
461: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
462: fnd_message.set_token('API_NAME',l_api_name);
463: fnd_message.set_token('SQL_ERROR',SQLERRM);
464: x_error_msg := fnd_message.get;
465: RETURN NULL;
466: END asset_key;
467:

Line 464: x_error_msg := fnd_message.get;

460: x_return_status := FND_API.G_RET_STS_ERROR ;
461: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
462: fnd_message.set_token('API_NAME',l_api_name);
463: fnd_message.set_token('SQL_ERROR',SQLERRM);
464: x_error_msg := fnd_message.get;
465: RETURN NULL;
466: END asset_key;
467:
468: ---------------------------------------------------------------------------+

Line 533: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

529:
530: EXCEPTION
531: WHEN OTHERS THEN
532: x_return_status := FND_API.G_RET_STS_ERROR ;
533: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
534: fnd_message.set_token('API_NAME',l_api_name);
535: fnd_message.set_token('SQL_ERROR',SQLERRM);
536: x_error_msg := fnd_message.get;
537: END get_wip_assembly_cost;

Line 534: fnd_message.set_token('API_NAME',l_api_name);

530: EXCEPTION
531: WHEN OTHERS THEN
532: x_return_status := FND_API.G_RET_STS_ERROR ;
533: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
534: fnd_message.set_token('API_NAME',l_api_name);
535: fnd_message.set_token('SQL_ERROR',SQLERRM);
536: x_error_msg := fnd_message.get;
537: END get_wip_assembly_cost;
538:

Line 535: fnd_message.set_token('SQL_ERROR',SQLERRM);

531: WHEN OTHERS THEN
532: x_return_status := FND_API.G_RET_STS_ERROR ;
533: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
534: fnd_message.set_token('API_NAME',l_api_name);
535: fnd_message.set_token('SQL_ERROR',SQLERRM);
536: x_error_msg := fnd_message.get;
537: END get_wip_assembly_cost;
538:
539: FUNCTION deprn_expense_ccid(

Line 536: x_error_msg := fnd_message.get;

532: x_return_status := FND_API.G_RET_STS_ERROR ;
533: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
534: fnd_message.set_token('API_NAME',l_api_name);
535: fnd_message.set_token('SQL_ERROR',SQLERRM);
536: x_error_msg := fnd_message.get;
537: END get_wip_assembly_cost;
538:
539: FUNCTION deprn_expense_ccid(
540: p_asset_attrib_rec IN OUT NOCOPY cse_datastructures_pub.asset_attrib_rec,

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

651: FETCH asset_clearing_acct_cur INTO l_temp_ccid , l_deprn_expense_acct ;
652: CLOSE asset_clearing_acct_cur ;
653:
654: IF l_temp_ccid is null THEN
655: fnd_message.set_name('CSE','CSE_ASSET_BOOK_CAT_UNDEFINED');
656: fnd_message.set_token('BOOK_TYPE_CODE',l_book_type_code);
657: OPEN fa_category_kfv_cur (l_category_id) ;
658: FETCH fa_category_kfv_cur into l_category_conc_seg ;
659: CLOSE fa_category_kfv_cur ;

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

652: CLOSE asset_clearing_acct_cur ;
653:
654: IF l_temp_ccid is null THEN
655: fnd_message.set_name('CSE','CSE_ASSET_BOOK_CAT_UNDEFINED');
656: fnd_message.set_token('BOOK_TYPE_CODE',l_book_type_code);
657: OPEN fa_category_kfv_cur (l_category_id) ;
658: FETCH fa_category_kfv_cur into l_category_conc_seg ;
659: CLOSE fa_category_kfv_cur ;
660: fnd_message.set_token('ASSET_CAT',l_category_conc_seg);

Line 660: fnd_message.set_token('ASSET_CAT',l_category_conc_seg);

656: fnd_message.set_token('BOOK_TYPE_CODE',l_book_type_code);
657: OPEN fa_category_kfv_cur (l_category_id) ;
658: FETCH fa_category_kfv_cur into l_category_conc_seg ;
659: CLOSE fa_category_kfv_cur ;
660: fnd_message.set_token('ASSET_CAT',l_category_conc_seg);
661: l_error_message := fnd_message.get;
662: RAISE fnd_api.g_exc_error;
663: END IF ;
664:

Line 661: l_error_message := fnd_message.get;

657: OPEN fa_category_kfv_cur (l_category_id) ;
658: FETCH fa_category_kfv_cur into l_category_conc_seg ;
659: CLOSE fa_category_kfv_cur ;
660: fnd_message.set_token('ASSET_CAT',l_category_conc_seg);
661: l_error_message := fnd_message.get;
662: RAISE fnd_api.g_exc_error;
663: END IF ;
664:
665: OPEN fnd_application_cur ;

Line 707: fnd_message.set_name('CSE','CSE_ASSET_EXPENSE_ACCT_ERROR');

703: EXCEPTION
704: WHEN fnd_api.g_exc_error THEN
705: x_return_status := fnd_api.g_ret_sts_error;
706: IF l_error_message is null THEN
707: fnd_message.set_name('CSE','CSE_ASSET_EXPENSE_ACCT_ERROR');
708: fnd_message.set_token('BOOK_TYPE_CODE',l_book_type_code);
709: l_error_message := fnd_message.get;
710: END IF;
711: x_error_msg := l_error_message;

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

704: WHEN fnd_api.g_exc_error THEN
705: x_return_status := fnd_api.g_ret_sts_error;
706: IF l_error_message is null THEN
707: fnd_message.set_name('CSE','CSE_ASSET_EXPENSE_ACCT_ERROR');
708: fnd_message.set_token('BOOK_TYPE_CODE',l_book_type_code);
709: l_error_message := fnd_message.get;
710: END IF;
711: x_error_msg := l_error_message;
712: RETURN null ;

Line 709: l_error_message := fnd_message.get;

705: x_return_status := fnd_api.g_ret_sts_error;
706: IF l_error_message is null THEN
707: fnd_message.set_name('CSE','CSE_ASSET_EXPENSE_ACCT_ERROR');
708: fnd_message.set_token('BOOK_TYPE_CODE',l_book_type_code);
709: l_error_message := fnd_message.get;
710: END IF;
711: x_error_msg := l_error_message;
712: RETURN null ;
713: END deprn_expense_ccid ;

Line 786: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

782: EXCEPTION
783: WHEN e_error
784: THEN
785: x_return_status := FND_API.G_RET_STS_ERROR ;
786: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
787: fnd_message.set_token('API_NAME',l_api_name);
788: fnd_message.set_token('SQL_ERROR',SQLERRM);
789: x_error_msg := fnd_message.get;
790: RETURN NULL;

Line 787: fnd_message.set_token('API_NAME',l_api_name);

783: WHEN e_error
784: THEN
785: x_return_status := FND_API.G_RET_STS_ERROR ;
786: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
787: fnd_message.set_token('API_NAME',l_api_name);
788: fnd_message.set_token('SQL_ERROR',SQLERRM);
789: x_error_msg := fnd_message.get;
790: RETURN NULL;
791: WHEN OTHERS

Line 788: fnd_message.set_token('SQL_ERROR',SQLERRM);

784: THEN
785: x_return_status := FND_API.G_RET_STS_ERROR ;
786: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
787: fnd_message.set_token('API_NAME',l_api_name);
788: fnd_message.set_token('SQL_ERROR',SQLERRM);
789: x_error_msg := fnd_message.get;
790: RETURN NULL;
791: WHEN OTHERS
792: THEN

Line 789: x_error_msg := fnd_message.get;

785: x_return_status := FND_API.G_RET_STS_ERROR ;
786: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
787: fnd_message.set_token('API_NAME',l_api_name);
788: fnd_message.set_token('SQL_ERROR',SQLERRM);
789: x_error_msg := fnd_message.get;
790: RETURN NULL;
791: WHEN OTHERS
792: THEN
793: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 794: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

790: RETURN NULL;
791: WHEN OTHERS
792: THEN
793: x_return_status := FND_API.G_RET_STS_ERROR ;
794: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
795: fnd_message.set_token('API_NAME',l_api_name);
796: fnd_message.set_token('SQL_ERROR',SQLERRM);
797: x_error_msg := fnd_message.get;
798: RETURN NULL;

Line 795: fnd_message.set_token('API_NAME',l_api_name);

791: WHEN OTHERS
792: THEN
793: x_return_status := FND_API.G_RET_STS_ERROR ;
794: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
795: fnd_message.set_token('API_NAME',l_api_name);
796: fnd_message.set_token('SQL_ERROR',SQLERRM);
797: x_error_msg := fnd_message.get;
798: RETURN NULL;
799: END search_method;

Line 796: fnd_message.set_token('SQL_ERROR',SQLERRM);

792: THEN
793: x_return_status := FND_API.G_RET_STS_ERROR ;
794: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
795: fnd_message.set_token('API_NAME',l_api_name);
796: fnd_message.set_token('SQL_ERROR',SQLERRM);
797: x_error_msg := fnd_message.get;
798: RETURN NULL;
799: END search_method;
800:

Line 797: x_error_msg := fnd_message.get;

793: x_return_status := FND_API.G_RET_STS_ERROR ;
794: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
795: fnd_message.set_token('API_NAME',l_api_name);
796: fnd_message.set_token('SQL_ERROR',SQLERRM);
797: x_error_msg := fnd_message.get;
798: RETURN NULL;
799: END search_method;
800:
801:

Line 1055: fnd_message.set_name('CSE','CSE_SLA_PAY_CCID_NOT_FOUND');

1051: WHEN fnd_api.g_exc_error THEN
1052: x_return_status := FND_API.G_RET_STS_ERROR ;
1053:
1054: IF l_sla_flag THEN
1055: fnd_message.set_name('CSE','CSE_SLA_PAY_CCID_NOT_FOUND');
1056: fnd_message.set_token('MTL_TXN_ID', l_mtl_txn_id);
1057: ELSE
1058: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
1059: fnd_message.set_token('ASSET_ATTRIBUTE','PAYABLES_CODE_COMBINATION_ID');

Line 1056: fnd_message.set_token('MTL_TXN_ID', l_mtl_txn_id);

1052: x_return_status := FND_API.G_RET_STS_ERROR ;
1053:
1054: IF l_sla_flag THEN
1055: fnd_message.set_name('CSE','CSE_SLA_PAY_CCID_NOT_FOUND');
1056: fnd_message.set_token('MTL_TXN_ID', l_mtl_txn_id);
1057: ELSE
1058: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
1059: fnd_message.set_token('ASSET_ATTRIBUTE','PAYABLES_CODE_COMBINATION_ID');
1060: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);

Line 1058: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');

1054: IF l_sla_flag THEN
1055: fnd_message.set_name('CSE','CSE_SLA_PAY_CCID_NOT_FOUND');
1056: fnd_message.set_token('MTL_TXN_ID', l_mtl_txn_id);
1057: ELSE
1058: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
1059: fnd_message.set_token('ASSET_ATTRIBUTE','PAYABLES_CODE_COMBINATION_ID');
1060: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
1061: END IF;
1062: x_error_msg := fnd_message.get;

Line 1059: fnd_message.set_token('ASSET_ATTRIBUTE','PAYABLES_CODE_COMBINATION_ID');

1055: fnd_message.set_name('CSE','CSE_SLA_PAY_CCID_NOT_FOUND');
1056: fnd_message.set_token('MTL_TXN_ID', l_mtl_txn_id);
1057: ELSE
1058: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
1059: fnd_message.set_token('ASSET_ATTRIBUTE','PAYABLES_CODE_COMBINATION_ID');
1060: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
1061: END IF;
1062: x_error_msg := fnd_message.get;
1063: RETURN NULL ;

Line 1060: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);

1056: fnd_message.set_token('MTL_TXN_ID', l_mtl_txn_id);
1057: ELSE
1058: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
1059: fnd_message.set_token('ASSET_ATTRIBUTE','PAYABLES_CODE_COMBINATION_ID');
1060: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
1061: END IF;
1062: x_error_msg := fnd_message.get;
1063: RETURN NULL ;
1064: END payables_ccid;

Line 1062: x_error_msg := fnd_message.get;

1058: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
1059: fnd_message.set_token('ASSET_ATTRIBUTE','PAYABLES_CODE_COMBINATION_ID');
1060: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
1061: END IF;
1062: x_error_msg := fnd_message.get;
1063: RETURN NULL ;
1064: END payables_ccid;
1065:
1066: ---------------------------------------------------------------------------+

Line 1099: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

1095: EXCEPTION
1096: WHEN OTHERS
1097: THEN
1098: x_return_status := FND_API.G_RET_STS_ERROR ;
1099: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1100: fnd_message.set_token('API_NAME',l_api_name);
1101: fnd_message.set_token('SQL_ERROR',SQLERRM);
1102: x_error_msg := fnd_message.get;
1103: RETURN NULL;

Line 1100: fnd_message.set_token('API_NAME',l_api_name);

1096: WHEN OTHERS
1097: THEN
1098: x_return_status := FND_API.G_RET_STS_ERROR ;
1099: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1100: fnd_message.set_token('API_NAME',l_api_name);
1101: fnd_message.set_token('SQL_ERROR',SQLERRM);
1102: x_error_msg := fnd_message.get;
1103: RETURN NULL;
1104: END tag_number;

Line 1101: fnd_message.set_token('SQL_ERROR',SQLERRM);

1097: THEN
1098: x_return_status := FND_API.G_RET_STS_ERROR ;
1099: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1100: fnd_message.set_token('API_NAME',l_api_name);
1101: fnd_message.set_token('SQL_ERROR',SQLERRM);
1102: x_error_msg := fnd_message.get;
1103: RETURN NULL;
1104: END tag_number;
1105:

Line 1102: x_error_msg := fnd_message.get;

1098: x_return_status := FND_API.G_RET_STS_ERROR ;
1099: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1100: fnd_message.set_token('API_NAME',l_api_name);
1101: fnd_message.set_token('SQL_ERROR',SQLERRM);
1102: x_error_msg := fnd_message.get;
1103: RETURN NULL;
1104: END tag_number;
1105:
1106: ---------------------------------------------------------------------------+

Line 1138: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

1134: EXCEPTION
1135: WHEN OTHERS
1136: THEN
1137: x_return_status := FND_API.G_RET_STS_ERROR ;
1138: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1139: fnd_message.set_token('API_NAME',l_api_name);
1140: fnd_message.set_token('SQL_ERROR',SQLERRM);
1141: x_error_msg := fnd_message.get;
1142: RETURN NULL;

Line 1139: fnd_message.set_token('API_NAME',l_api_name);

1135: WHEN OTHERS
1136: THEN
1137: x_return_status := FND_API.G_RET_STS_ERROR ;
1138: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1139: fnd_message.set_token('API_NAME',l_api_name);
1140: fnd_message.set_token('SQL_ERROR',SQLERRM);
1141: x_error_msg := fnd_message.get;
1142: RETURN NULL;
1143: END model_number;

Line 1140: fnd_message.set_token('SQL_ERROR',SQLERRM);

1136: THEN
1137: x_return_status := FND_API.G_RET_STS_ERROR ;
1138: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1139: fnd_message.set_token('API_NAME',l_api_name);
1140: fnd_message.set_token('SQL_ERROR',SQLERRM);
1141: x_error_msg := fnd_message.get;
1142: RETURN NULL;
1143: END model_number;
1144:

Line 1141: x_error_msg := fnd_message.get;

1137: x_return_status := FND_API.G_RET_STS_ERROR ;
1138: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1139: fnd_message.set_token('API_NAME',l_api_name);
1140: fnd_message.set_token('SQL_ERROR',SQLERRM);
1141: x_error_msg := fnd_message.get;
1142: RETURN NULL;
1143: END model_number;
1144:
1145: ---------------------------------------------------------------------------+

Line 1177: fnd_message.set_token('API_NAME',l_api_name);

1173: EXCEPTION
1174: WHEN OTHERS
1175: THEN
1176: x_return_status := FND_API.G_RET_STS_ERROR ;
1177: fnd_message.set_token('API_NAME',l_api_name);
1178: fnd_message.set_token('SQL_ERROR',SQLERRM);
1179: x_error_msg := fnd_message.get;
1180: RETURN NULL;
1181: END manufacturer;

Line 1178: fnd_message.set_token('SQL_ERROR',SQLERRM);

1174: WHEN OTHERS
1175: THEN
1176: x_return_status := FND_API.G_RET_STS_ERROR ;
1177: fnd_message.set_token('API_NAME',l_api_name);
1178: fnd_message.set_token('SQL_ERROR',SQLERRM);
1179: x_error_msg := fnd_message.get;
1180: RETURN NULL;
1181: END manufacturer;
1182:

Line 1179: x_error_msg := fnd_message.get;

1175: THEN
1176: x_return_status := FND_API.G_RET_STS_ERROR ;
1177: fnd_message.set_token('API_NAME',l_api_name);
1178: fnd_message.set_token('SQL_ERROR',SQLERRM);
1179: x_error_msg := fnd_message.get;
1180: RETURN NULL;
1181: END manufacturer;
1182:
1183: ---------------------------------------------------------------------------+

Line 1215: fnd_message.set_token('API_NAME',l_api_name);

1211: EXCEPTION
1212: WHEN OTHERS
1213: THEN
1214: x_return_status := FND_API.G_RET_STS_ERROR ;
1215: fnd_message.set_token('API_NAME',l_api_name);
1216: fnd_message.set_token('SQL_ERROR',SQLERRM);
1217: x_error_msg := fnd_message.get;
1218: RETURN NULL;
1219: END employee;

Line 1216: fnd_message.set_token('SQL_ERROR',SQLERRM);

1212: WHEN OTHERS
1213: THEN
1214: x_return_status := FND_API.G_RET_STS_ERROR ;
1215: fnd_message.set_token('API_NAME',l_api_name);
1216: fnd_message.set_token('SQL_ERROR',SQLERRM);
1217: x_error_msg := fnd_message.get;
1218: RETURN NULL;
1219: END employee;
1220:

Line 1217: x_error_msg := fnd_message.get;

1213: THEN
1214: x_return_status := FND_API.G_RET_STS_ERROR ;
1215: fnd_message.set_token('API_NAME',l_api_name);
1216: fnd_message.set_token('SQL_ERROR',SQLERRM);
1217: x_error_msg := fnd_message.get;
1218: RETURN NULL;
1219: END employee;
1220:
1221: FUNCTION inventory_item(

Line 1313: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

1309: EXCEPTION
1310: WHEN OTHERS
1311: THEN
1312: x_return_status := FND_API.G_RET_STS_ERROR ;
1313: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1314: fnd_message.set_token('API_NAME',l_api_name);
1315: fnd_message.set_token('SQL_ERROR',SQLERRM);
1316: x_error_msg := fnd_message.get;
1317:

Line 1314: fnd_message.set_token('API_NAME',l_api_name);

1310: WHEN OTHERS
1311: THEN
1312: x_return_status := FND_API.G_RET_STS_ERROR ;
1313: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1314: fnd_message.set_token('API_NAME',l_api_name);
1315: fnd_message.set_token('SQL_ERROR',SQLERRM);
1316: x_error_msg := fnd_message.get;
1317:
1318: END get_pending_retirements;

Line 1315: fnd_message.set_token('SQL_ERROR',SQLERRM);

1311: THEN
1312: x_return_status := FND_API.G_RET_STS_ERROR ;
1313: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1314: fnd_message.set_token('API_NAME',l_api_name);
1315: fnd_message.set_token('SQL_ERROR',SQLERRM);
1316: x_error_msg := fnd_message.get;
1317:
1318: END get_pending_retirements;
1319:

Line 1316: x_error_msg := fnd_message.get;

1312: x_return_status := FND_API.G_RET_STS_ERROR ;
1313: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1314: fnd_message.set_token('API_NAME',l_api_name);
1315: fnd_message.set_token('SQL_ERROR',SQLERRM);
1316: x_error_msg := fnd_message.get;
1317:
1318: END get_pending_retirements;
1319:
1320: ---------------------------------------------------------------------------

Line 1396: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

1392: EXCEPTION
1393: WHEN OTHERS
1394: THEN
1395: x_return_status := FND_API.G_RET_STS_ERROR ;
1396: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1397: fnd_message.set_token('API_NAME',l_api_name);
1398: fnd_message.set_token('SQL_ERROR',SQLERRM);
1399: x_error_msg := fnd_message.get;
1400:

Line 1397: fnd_message.set_token('API_NAME',l_api_name);

1393: WHEN OTHERS
1394: THEN
1395: x_return_status := FND_API.G_RET_STS_ERROR ;
1396: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1397: fnd_message.set_token('API_NAME',l_api_name);
1398: fnd_message.set_token('SQL_ERROR',SQLERRM);
1399: x_error_msg := fnd_message.get;
1400:
1401: END get_pending_adjustments ;

Line 1398: fnd_message.set_token('SQL_ERROR',SQLERRM);

1394: THEN
1395: x_return_status := FND_API.G_RET_STS_ERROR ;
1396: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1397: fnd_message.set_token('API_NAME',l_api_name);
1398: fnd_message.set_token('SQL_ERROR',SQLERRM);
1399: x_error_msg := fnd_message.get;
1400:
1401: END get_pending_adjustments ;
1402:

Line 1399: x_error_msg := fnd_message.get;

1395: x_return_status := FND_API.G_RET_STS_ERROR ;
1396: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1397: fnd_message.set_token('API_NAME',l_api_name);
1398: fnd_message.set_token('SQL_ERROR',SQLERRM);
1399: x_error_msg := fnd_message.get;
1400:
1401: END get_pending_adjustments ;
1402:
1403: -------------------------------------------------------------------------------

Line 1658: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

1654: END IF ;
1655: EXCEPTION
1656: WHEN OTHERS THEN
1657: x_return_status := FND_API.G_RET_STS_ERROR ;
1658: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1659: fnd_message.set_token('API_NAME',l_api_name);
1660: fnd_message.set_token('SQL_ERROR',SQLERRM);
1661: x_error_msg := fnd_message.get;
1662: END get_txn_class ;

Line 1659: fnd_message.set_token('API_NAME',l_api_name);

1655: EXCEPTION
1656: WHEN OTHERS THEN
1657: x_return_status := FND_API.G_RET_STS_ERROR ;
1658: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1659: fnd_message.set_token('API_NAME',l_api_name);
1660: fnd_message.set_token('SQL_ERROR',SQLERRM);
1661: x_error_msg := fnd_message.get;
1662: END get_txn_class ;
1663:

Line 1660: fnd_message.set_token('SQL_ERROR',SQLERRM);

1656: WHEN OTHERS THEN
1657: x_return_status := FND_API.G_RET_STS_ERROR ;
1658: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1659: fnd_message.set_token('API_NAME',l_api_name);
1660: fnd_message.set_token('SQL_ERROR',SQLERRM);
1661: x_error_msg := fnd_message.get;
1662: END get_txn_class ;
1663:
1664: -------------------------------------------------------------------------------

Line 1661: x_error_msg := fnd_message.get;

1657: x_return_status := FND_API.G_RET_STS_ERROR ;
1658: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1659: fnd_message.set_token('API_NAME',l_api_name);
1660: fnd_message.set_token('SQL_ERROR',SQLERRM);
1661: x_error_msg := fnd_message.get;
1662: END get_txn_class ;
1663:
1664: -------------------------------------------------------------------------------
1665: -- Procedure/Function Name : validate_inst_asset

Line 1736: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

1732: EXCEPTION
1733: WHEN OTHERS
1734: THEN
1735: x_return_status := FND_API.G_RET_STS_ERROR ;
1736: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1737: fnd_message.set_token('API_NAME',l_api_name);
1738: fnd_message.set_token('SQL_ERROR',SQLERRM);
1739: x_error_msg := fnd_message.get;
1740:

Line 1737: fnd_message.set_token('API_NAME',l_api_name);

1733: WHEN OTHERS
1734: THEN
1735: x_return_status := FND_API.G_RET_STS_ERROR ;
1736: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1737: fnd_message.set_token('API_NAME',l_api_name);
1738: fnd_message.set_token('SQL_ERROR',SQLERRM);
1739: x_error_msg := fnd_message.get;
1740:
1741: END validate_inst_asset;

Line 1738: fnd_message.set_token('SQL_ERROR',SQLERRM);

1734: THEN
1735: x_return_status := FND_API.G_RET_STS_ERROR ;
1736: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1737: fnd_message.set_token('API_NAME',l_api_name);
1738: fnd_message.set_token('SQL_ERROR',SQLERRM);
1739: x_error_msg := fnd_message.get;
1740:
1741: END validate_inst_asset;
1742:

Line 1739: x_error_msg := fnd_message.get;

1735: x_return_status := FND_API.G_RET_STS_ERROR ;
1736: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1737: fnd_message.set_token('API_NAME',l_api_name);
1738: fnd_message.set_token('SQL_ERROR',SQLERRM);
1739: x_error_msg := fnd_message.get;
1740:
1741: END validate_inst_asset;
1742:
1743:

Line 2006: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

2002: x_error_msg := substr(sqlerrm,1,200) ;
2003: debug('SQL ERRM : '||x_error_msg);
2004: x_return_status := FND_API.G_RET_STS_ERROR ;
2005: x_msg_count := 1;
2006: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2007: fnd_message.set_token('API_NAME',l_api_name);
2008: fnd_message.set_token('SQL_ERROR',SQLERRM);
2009: x_msg_data := fnd_message.get;
2010: END insert_mass_add;

Line 2007: fnd_message.set_token('API_NAME',l_api_name);

2003: debug('SQL ERRM : '||x_error_msg);
2004: x_return_status := FND_API.G_RET_STS_ERROR ;
2005: x_msg_count := 1;
2006: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2007: fnd_message.set_token('API_NAME',l_api_name);
2008: fnd_message.set_token('SQL_ERROR',SQLERRM);
2009: x_msg_data := fnd_message.get;
2010: END insert_mass_add;
2011:

Line 2008: fnd_message.set_token('SQL_ERROR',SQLERRM);

2004: x_return_status := FND_API.G_RET_STS_ERROR ;
2005: x_msg_count := 1;
2006: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2007: fnd_message.set_token('API_NAME',l_api_name);
2008: fnd_message.set_token('SQL_ERROR',SQLERRM);
2009: x_msg_data := fnd_message.get;
2010: END insert_mass_add;
2011:
2012:

Line 2009: x_msg_data := fnd_message.get;

2005: x_msg_count := 1;
2006: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2007: fnd_message.set_token('API_NAME',l_api_name);
2008: fnd_message.set_token('SQL_ERROR',SQLERRM);
2009: x_msg_data := fnd_message.get;
2010: END insert_mass_add;
2011:
2012:
2013: FUNCTION retire_non_mtl(

Line 2282: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');

2278:
2279: EXCEPTION
2280: WHEN fnd_api.g_exc_error THEN
2281: x_return_status := FND_API.G_RET_STS_ERROR ;
2282: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
2283: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
2284: fnd_message.set_token('CSI_TRANSACTION_ID',p_inst_loc_rec.transaction_id);
2285: x_error_msg := fnd_message.get;
2286: END get_fa_location ;

Line 2283: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');

2279: EXCEPTION
2280: WHEN fnd_api.g_exc_error THEN
2281: x_return_status := FND_API.G_RET_STS_ERROR ;
2282: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
2283: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
2284: fnd_message.set_token('CSI_TRANSACTION_ID',p_inst_loc_rec.transaction_id);
2285: x_error_msg := fnd_message.get;
2286: END get_fa_location ;
2287:

Line 2284: fnd_message.set_token('CSI_TRANSACTION_ID',p_inst_loc_rec.transaction_id);

2280: WHEN fnd_api.g_exc_error THEN
2281: x_return_status := FND_API.G_RET_STS_ERROR ;
2282: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
2283: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
2284: fnd_message.set_token('CSI_TRANSACTION_ID',p_inst_loc_rec.transaction_id);
2285: x_error_msg := fnd_message.get;
2286: END get_fa_location ;
2287:
2288: -------------------------------------------------------------------------------

Line 2285: x_error_msg := fnd_message.get;

2281: x_return_status := FND_API.G_RET_STS_ERROR ;
2282: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
2283: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
2284: fnd_message.set_token('CSI_TRANSACTION_ID',p_inst_loc_rec.transaction_id);
2285: x_error_msg := fnd_message.get;
2286: END get_fa_location ;
2287:
2288: -------------------------------------------------------------------------------
2289: -- PROCEDURE get_unit_cost ---

Line 2368: fnd_message.set_name('CSE','CSE_UNABLE_DERIVE_COST_ERROR');

2364: -- Added error message for bug 4869653
2365: IF x_unit_cost IS NULL THEN
2366: debug( 'Unable to derive Cost for item : '||p_inventory_item_id ||' Org : '|| p_organization_id||' Source : '||p_source_txn_type||' ID '||p_source_txn_id);
2367: x_return_status := FND_API.G_RET_STS_ERROR ;
2368: fnd_message.set_name('CSE','CSE_UNABLE_DERIVE_COST_ERROR');
2369: fnd_message.set_token('SOURCE_TYPE_CODE',p_source_txn_type);
2370: fnd_message.set_token('SOURCE_TYPE_ID',p_source_txn_id);
2371: x_error_msg := fnd_message.get;
2372: END IF;

Line 2369: fnd_message.set_token('SOURCE_TYPE_CODE',p_source_txn_type);

2365: IF x_unit_cost IS NULL THEN
2366: debug( 'Unable to derive Cost for item : '||p_inventory_item_id ||' Org : '|| p_organization_id||' Source : '||p_source_txn_type||' ID '||p_source_txn_id);
2367: x_return_status := FND_API.G_RET_STS_ERROR ;
2368: fnd_message.set_name('CSE','CSE_UNABLE_DERIVE_COST_ERROR');
2369: fnd_message.set_token('SOURCE_TYPE_CODE',p_source_txn_type);
2370: fnd_message.set_token('SOURCE_TYPE_ID',p_source_txn_id);
2371: x_error_msg := fnd_message.get;
2372: END IF;
2373: -- End error message for bug 4869653

Line 2370: fnd_message.set_token('SOURCE_TYPE_ID',p_source_txn_id);

2366: debug( 'Unable to derive Cost for item : '||p_inventory_item_id ||' Org : '|| p_organization_id||' Source : '||p_source_txn_type||' ID '||p_source_txn_id);
2367: x_return_status := FND_API.G_RET_STS_ERROR ;
2368: fnd_message.set_name('CSE','CSE_UNABLE_DERIVE_COST_ERROR');
2369: fnd_message.set_token('SOURCE_TYPE_CODE',p_source_txn_type);
2370: fnd_message.set_token('SOURCE_TYPE_ID',p_source_txn_id);
2371: x_error_msg := fnd_message.get;
2372: END IF;
2373: -- End error message for bug 4869653
2374: END get_unit_cost ;

Line 2371: x_error_msg := fnd_message.get;

2367: x_return_status := FND_API.G_RET_STS_ERROR ;
2368: fnd_message.set_name('CSE','CSE_UNABLE_DERIVE_COST_ERROR');
2369: fnd_message.set_token('SOURCE_TYPE_CODE',p_source_txn_type);
2370: fnd_message.set_token('SOURCE_TYPE_ID',p_source_txn_id);
2371: x_error_msg := fnd_message.get;
2372: END IF;
2373: -- End error message for bug 4869653
2374: END get_unit_cost ;
2375:

Line 2421: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

2417: EXCEPTION
2418: WHEN OTHERS
2419: THEN
2420: x_return_status := FND_API.G_RET_STS_ERROR ;
2421: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2422: fnd_message.set_token('API_NAME',l_api_name);
2423: fnd_message.set_token('SQL_ERROR',SQLERRM);
2424: x_error_msg := fnd_message.get;
2425: END is_valid_to_retire ;

Line 2422: fnd_message.set_token('API_NAME',l_api_name);

2418: WHEN OTHERS
2419: THEN
2420: x_return_status := FND_API.G_RET_STS_ERROR ;
2421: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2422: fnd_message.set_token('API_NAME',l_api_name);
2423: fnd_message.set_token('SQL_ERROR',SQLERRM);
2424: x_error_msg := fnd_message.get;
2425: END is_valid_to_retire ;
2426:

Line 2423: fnd_message.set_token('SQL_ERROR',SQLERRM);

2419: THEN
2420: x_return_status := FND_API.G_RET_STS_ERROR ;
2421: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2422: fnd_message.set_token('API_NAME',l_api_name);
2423: fnd_message.set_token('SQL_ERROR',SQLERRM);
2424: x_error_msg := fnd_message.get;
2425: END is_valid_to_retire ;
2426:
2427:

Line 2424: x_error_msg := fnd_message.get;

2420: x_return_status := FND_API.G_RET_STS_ERROR ;
2421: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2422: fnd_message.set_token('API_NAME',l_api_name);
2423: fnd_message.set_token('SQL_ERROR',SQLERRM);
2424: x_error_msg := fnd_message.get;
2425: END is_valid_to_retire ;
2426:
2427:
2428: -------------------------------------------------------------------------------