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 148: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');

144:
145: EXCEPTION
146: WHEN NO_DATA_FOUND THEN
147: x_return_status := FND_API.G_RET_STS_ERROR ;
148: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
149: fnd_message.set_token('ASSET_ATTRIBUTE','DESCRIPTION');
150: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
151: x_error_msg := fnd_message.get;
152: RETURN NULL ;

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

145: EXCEPTION
146: WHEN NO_DATA_FOUND THEN
147: x_return_status := FND_API.G_RET_STS_ERROR ;
148: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
149: fnd_message.set_token('ASSET_ATTRIBUTE','DESCRIPTION');
150: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
151: x_error_msg := fnd_message.get;
152: RETURN NULL ;
153: WHEN OTHERS THEN

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

146: WHEN NO_DATA_FOUND THEN
147: x_return_status := FND_API.G_RET_STS_ERROR ;
148: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
149: fnd_message.set_token('ASSET_ATTRIBUTE','DESCRIPTION');
150: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
151: x_error_msg := fnd_message.get;
152: RETURN NULL ;
153: WHEN OTHERS THEN
154: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 151: x_error_msg := fnd_message.get;

147: x_return_status := FND_API.G_RET_STS_ERROR ;
148: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
149: fnd_message.set_token('ASSET_ATTRIBUTE','DESCRIPTION');
150: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
151: x_error_msg := fnd_message.get;
152: RETURN NULL ;
153: WHEN OTHERS THEN
154: x_return_status := FND_API.G_RET_STS_ERROR ;
155: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

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

151: x_error_msg := fnd_message.get;
152: RETURN NULL ;
153: WHEN OTHERS THEN
154: x_return_status := FND_API.G_RET_STS_ERROR ;
155: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
156: fnd_message.set_token('API_NAME',l_api_name);
157: fnd_message.set_token('SQL_ERROR',SQLERRM);
158: x_error_msg := fnd_message.get;
159: RETURN NULL ;

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

152: RETURN NULL ;
153: WHEN OTHERS THEN
154: x_return_status := FND_API.G_RET_STS_ERROR ;
155: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
156: fnd_message.set_token('API_NAME',l_api_name);
157: fnd_message.set_token('SQL_ERROR',SQLERRM);
158: x_error_msg := fnd_message.get;
159: RETURN NULL ;
160: END asset_description ;

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

153: WHEN OTHERS THEN
154: x_return_status := FND_API.G_RET_STS_ERROR ;
155: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
156: fnd_message.set_token('API_NAME',l_api_name);
157: fnd_message.set_token('SQL_ERROR',SQLERRM);
158: x_error_msg := fnd_message.get;
159: RETURN NULL ;
160: END asset_description ;
161:

Line 158: x_error_msg := fnd_message.get;

154: x_return_status := FND_API.G_RET_STS_ERROR ;
155: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
156: fnd_message.set_token('API_NAME',l_api_name);
157: fnd_message.set_token('SQL_ERROR',SQLERRM);
158: x_error_msg := fnd_message.get;
159: RETURN NULL ;
160: END asset_description ;
161:
162: ---------------------------------------------------------------------------+

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

227: EXCEPTION
228: WHEN e_error
229: THEN
230: x_return_status := FND_API.G_RET_STS_ERROR ;
231: fnd_message.set_name('CSE','CSE_ASSET_CAT_ERROR');
232: x_error_msg := fnd_message.get;
233: RETURN NULL ;
234: WHEN OTHERS
235: THEN

Line 232: x_error_msg := fnd_message.get;

228: WHEN e_error
229: THEN
230: x_return_status := FND_API.G_RET_STS_ERROR ;
231: fnd_message.set_name('CSE','CSE_ASSET_CAT_ERROR');
232: x_error_msg := fnd_message.get;
233: RETURN NULL ;
234: WHEN OTHERS
235: THEN
236: x_return_status := FND_API.G_RET_STS_ERROR ;

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

233: RETURN NULL ;
234: WHEN OTHERS
235: THEN
236: x_return_status := FND_API.G_RET_STS_ERROR ;
237: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
238: fnd_message.set_token('API_NAME',l_api_name);
239: fnd_message.set_token('SQL_ERROR',SQLERRM);
240: x_error_msg := fnd_message.get;
241: RETURN NULL;

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

234: WHEN OTHERS
235: THEN
236: x_return_status := FND_API.G_RET_STS_ERROR ;
237: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
238: fnd_message.set_token('API_NAME',l_api_name);
239: fnd_message.set_token('SQL_ERROR',SQLERRM);
240: x_error_msg := fnd_message.get;
241: RETURN NULL;
242: END asset_category ;

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

235: THEN
236: x_return_status := FND_API.G_RET_STS_ERROR ;
237: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
238: fnd_message.set_token('API_NAME',l_api_name);
239: fnd_message.set_token('SQL_ERROR',SQLERRM);
240: x_error_msg := fnd_message.get;
241: RETURN NULL;
242: END asset_category ;
243:

Line 240: x_error_msg := fnd_message.get;

236: x_return_status := FND_API.G_RET_STS_ERROR ;
237: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
238: fnd_message.set_token('API_NAME',l_api_name);
239: fnd_message.set_token('SQL_ERROR',SQLERRM);
240: x_error_msg := fnd_message.get;
241: RETURN NULL;
242: END asset_category ;
243:
244: ---------------------------------------------------------------------------+

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

348: EXCEPTION
349: WHEN e_error
350: THEN
351: x_return_status := FND_API.G_RET_STS_ERROR ;
352: fnd_message.set_name('CSE','CSE_ASSET_BOOK_ERROR');
353: x_error_msg := fnd_message.get;
354: RETURN NULL ;
355: WHEN OTHERS
356: THEN

Line 353: x_error_msg := fnd_message.get;

349: WHEN e_error
350: THEN
351: x_return_status := FND_API.G_RET_STS_ERROR ;
352: fnd_message.set_name('CSE','CSE_ASSET_BOOK_ERROR');
353: x_error_msg := fnd_message.get;
354: RETURN NULL ;
355: WHEN OTHERS
356: THEN
357: x_return_status := FND_API.G_RET_STS_ERROR ;

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

354: RETURN NULL ;
355: WHEN OTHERS
356: THEN
357: x_return_status := FND_API.G_RET_STS_ERROR ;
358: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
359: fnd_message.set_token('API_NAME',l_api_name);
360: fnd_message.set_token('SQL_ERROR',SQLERRM);
361: x_error_msg := fnd_message.get;
362: RETURN NULL;

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

355: WHEN OTHERS
356: THEN
357: x_return_status := FND_API.G_RET_STS_ERROR ;
358: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
359: fnd_message.set_token('API_NAME',l_api_name);
360: fnd_message.set_token('SQL_ERROR',SQLERRM);
361: x_error_msg := fnd_message.get;
362: RETURN NULL;
363: END book_type;

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

356: THEN
357: x_return_status := FND_API.G_RET_STS_ERROR ;
358: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
359: fnd_message.set_token('API_NAME',l_api_name);
360: fnd_message.set_token('SQL_ERROR',SQLERRM);
361: x_error_msg := fnd_message.get;
362: RETURN NULL;
363: END book_type;
364:

Line 361: x_error_msg := fnd_message.get;

357: x_return_status := FND_API.G_RET_STS_ERROR ;
358: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
359: fnd_message.set_token('API_NAME',l_api_name);
360: fnd_message.set_token('SQL_ERROR',SQLERRM);
361: x_error_msg := fnd_message.get;
362: RETURN NULL;
363: END book_type;
364:
365: --------------------------------------------------------------------------

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

470:
471: EXCEPTION
472: WHEN fnd_api.g_exc_error THEN
473: x_return_status := FND_API.G_RET_STS_ERROR ;
474: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
475: fnd_message.set_token('ASSET_ATTRIBUTE','DATE_PLACED_IN_SERVICE');
476: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
477: x_error_msg := fnd_message.get;
478: RETURN null ;

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

471: EXCEPTION
472: WHEN fnd_api.g_exc_error THEN
473: x_return_status := FND_API.G_RET_STS_ERROR ;
474: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
475: fnd_message.set_token('ASSET_ATTRIBUTE','DATE_PLACED_IN_SERVICE');
476: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
477: x_error_msg := fnd_message.get;
478: RETURN null ;
479: END date_place_in_service ;

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

472: WHEN fnd_api.g_exc_error THEN
473: x_return_status := FND_API.G_RET_STS_ERROR ;
474: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
475: fnd_message.set_token('ASSET_ATTRIBUTE','DATE_PLACED_IN_SERVICE');
476: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
477: x_error_msg := fnd_message.get;
478: RETURN null ;
479: END date_place_in_service ;
480:

Line 477: x_error_msg := fnd_message.get;

473: x_return_status := FND_API.G_RET_STS_ERROR ;
474: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
475: fnd_message.set_token('ASSET_ATTRIBUTE','DATE_PLACED_IN_SERVICE');
476: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
477: x_error_msg := fnd_message.get;
478: RETURN null ;
479: END date_place_in_service ;
480:
481:

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

501:
502: EXCEPTION
503: WHEN OTHERS THEN
504: x_return_status := FND_API.G_RET_STS_ERROR ;
505: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
506: fnd_message.set_token('API_NAME',l_api_name);
507: fnd_message.set_token('SQL_ERROR',SQLERRM);
508: x_error_msg := fnd_message.get;
509: RETURN NULL;

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

502: EXCEPTION
503: WHEN OTHERS THEN
504: x_return_status := FND_API.G_RET_STS_ERROR ;
505: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
506: fnd_message.set_token('API_NAME',l_api_name);
507: fnd_message.set_token('SQL_ERROR',SQLERRM);
508: x_error_msg := fnd_message.get;
509: RETURN NULL;
510: END asset_key;

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

503: WHEN OTHERS THEN
504: x_return_status := FND_API.G_RET_STS_ERROR ;
505: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
506: fnd_message.set_token('API_NAME',l_api_name);
507: fnd_message.set_token('SQL_ERROR',SQLERRM);
508: x_error_msg := fnd_message.get;
509: RETURN NULL;
510: END asset_key;
511:

Line 508: x_error_msg := fnd_message.get;

504: x_return_status := FND_API.G_RET_STS_ERROR ;
505: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
506: fnd_message.set_token('API_NAME',l_api_name);
507: fnd_message.set_token('SQL_ERROR',SQLERRM);
508: x_error_msg := fnd_message.get;
509: RETURN NULL;
510: END asset_key;
511:
512: ---------------------------------------------------------------------------+

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

573:
574: EXCEPTION
575: WHEN OTHERS THEN
576: x_return_status := FND_API.G_RET_STS_ERROR ;
577: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
578: fnd_message.set_token('API_NAME',l_api_name);
579: fnd_message.set_token('SQL_ERROR',SQLERRM);
580: x_error_msg := fnd_message.get;
581: END get_wip_assembly_cost;

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

574: EXCEPTION
575: WHEN OTHERS THEN
576: x_return_status := FND_API.G_RET_STS_ERROR ;
577: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
578: fnd_message.set_token('API_NAME',l_api_name);
579: fnd_message.set_token('SQL_ERROR',SQLERRM);
580: x_error_msg := fnd_message.get;
581: END get_wip_assembly_cost;
582:

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

575: WHEN OTHERS THEN
576: x_return_status := FND_API.G_RET_STS_ERROR ;
577: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
578: fnd_message.set_token('API_NAME',l_api_name);
579: fnd_message.set_token('SQL_ERROR',SQLERRM);
580: x_error_msg := fnd_message.get;
581: END get_wip_assembly_cost;
582:
583: FUNCTION deprn_expense_ccid(

Line 580: x_error_msg := fnd_message.get;

576: x_return_status := FND_API.G_RET_STS_ERROR ;
577: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
578: fnd_message.set_token('API_NAME',l_api_name);
579: fnd_message.set_token('SQL_ERROR',SQLERRM);
580: x_error_msg := fnd_message.get;
581: END get_wip_assembly_cost;
582:
583: FUNCTION deprn_expense_ccid(
584: p_asset_attrib_rec IN OUT NOCOPY cse_datastructures_pub.asset_attrib_rec,

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

695: FETCH asset_clearing_acct_cur INTO l_temp_ccid , l_deprn_expense_acct ;
696: CLOSE asset_clearing_acct_cur ;
697:
698: IF l_temp_ccid is null THEN
699: fnd_message.set_name('CSE','CSE_ASSET_BOOK_CAT_UNDEFINED');
700: fnd_message.set_token('BOOK_TYPE_CODE',l_book_type_code);
701: OPEN fa_category_kfv_cur (l_category_id) ;
702: FETCH fa_category_kfv_cur into l_category_conc_seg ;
703: CLOSE fa_category_kfv_cur ;

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

696: CLOSE asset_clearing_acct_cur ;
697:
698: IF l_temp_ccid is null THEN
699: fnd_message.set_name('CSE','CSE_ASSET_BOOK_CAT_UNDEFINED');
700: fnd_message.set_token('BOOK_TYPE_CODE',l_book_type_code);
701: OPEN fa_category_kfv_cur (l_category_id) ;
702: FETCH fa_category_kfv_cur into l_category_conc_seg ;
703: CLOSE fa_category_kfv_cur ;
704: fnd_message.set_token('ASSET_CAT',l_category_conc_seg);

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

700: fnd_message.set_token('BOOK_TYPE_CODE',l_book_type_code);
701: OPEN fa_category_kfv_cur (l_category_id) ;
702: FETCH fa_category_kfv_cur into l_category_conc_seg ;
703: CLOSE fa_category_kfv_cur ;
704: fnd_message.set_token('ASSET_CAT',l_category_conc_seg);
705: l_error_message := fnd_message.get;
706: RAISE fnd_api.g_exc_error;
707: END IF ;
708:

Line 705: l_error_message := fnd_message.get;

701: OPEN fa_category_kfv_cur (l_category_id) ;
702: FETCH fa_category_kfv_cur into l_category_conc_seg ;
703: CLOSE fa_category_kfv_cur ;
704: fnd_message.set_token('ASSET_CAT',l_category_conc_seg);
705: l_error_message := fnd_message.get;
706: RAISE fnd_api.g_exc_error;
707: END IF ;
708:
709: OPEN fnd_application_cur ;

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

747: EXCEPTION
748: WHEN fnd_api.g_exc_error THEN
749: x_return_status := fnd_api.g_ret_sts_error;
750: IF l_error_message is null THEN
751: fnd_message.set_name('CSE','CSE_ASSET_EXPENSE_ACCT_ERROR');
752: fnd_message.set_token('BOOK_TYPE_CODE',l_book_type_code);
753: l_error_message := fnd_message.get;
754: END IF;
755: x_error_msg := l_error_message;

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

748: WHEN fnd_api.g_exc_error THEN
749: x_return_status := fnd_api.g_ret_sts_error;
750: IF l_error_message is null THEN
751: fnd_message.set_name('CSE','CSE_ASSET_EXPENSE_ACCT_ERROR');
752: fnd_message.set_token('BOOK_TYPE_CODE',l_book_type_code);
753: l_error_message := fnd_message.get;
754: END IF;
755: x_error_msg := l_error_message;
756: RETURN null ;

Line 753: l_error_message := fnd_message.get;

749: x_return_status := fnd_api.g_ret_sts_error;
750: IF l_error_message is null THEN
751: fnd_message.set_name('CSE','CSE_ASSET_EXPENSE_ACCT_ERROR');
752: fnd_message.set_token('BOOK_TYPE_CODE',l_book_type_code);
753: l_error_message := fnd_message.get;
754: END IF;
755: x_error_msg := l_error_message;
756: RETURN null ;
757: END deprn_expense_ccid ;

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

826: EXCEPTION
827: WHEN e_error
828: THEN
829: x_return_status := FND_API.G_RET_STS_ERROR ;
830: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
831: fnd_message.set_token('API_NAME',l_api_name);
832: fnd_message.set_token('SQL_ERROR',SQLERRM);
833: x_error_msg := fnd_message.get;
834: RETURN NULL;

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

827: WHEN e_error
828: THEN
829: x_return_status := FND_API.G_RET_STS_ERROR ;
830: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
831: fnd_message.set_token('API_NAME',l_api_name);
832: fnd_message.set_token('SQL_ERROR',SQLERRM);
833: x_error_msg := fnd_message.get;
834: RETURN NULL;
835: WHEN OTHERS

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

828: THEN
829: x_return_status := FND_API.G_RET_STS_ERROR ;
830: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
831: fnd_message.set_token('API_NAME',l_api_name);
832: fnd_message.set_token('SQL_ERROR',SQLERRM);
833: x_error_msg := fnd_message.get;
834: RETURN NULL;
835: WHEN OTHERS
836: THEN

Line 833: x_error_msg := fnd_message.get;

829: x_return_status := FND_API.G_RET_STS_ERROR ;
830: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
831: fnd_message.set_token('API_NAME',l_api_name);
832: fnd_message.set_token('SQL_ERROR',SQLERRM);
833: x_error_msg := fnd_message.get;
834: RETURN NULL;
835: WHEN OTHERS
836: THEN
837: x_return_status := FND_API.G_RET_STS_ERROR ;

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

834: RETURN NULL;
835: WHEN OTHERS
836: THEN
837: x_return_status := FND_API.G_RET_STS_ERROR ;
838: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
839: fnd_message.set_token('API_NAME',l_api_name);
840: fnd_message.set_token('SQL_ERROR',SQLERRM);
841: x_error_msg := fnd_message.get;
842: RETURN NULL;

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

835: WHEN OTHERS
836: THEN
837: x_return_status := FND_API.G_RET_STS_ERROR ;
838: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
839: fnd_message.set_token('API_NAME',l_api_name);
840: fnd_message.set_token('SQL_ERROR',SQLERRM);
841: x_error_msg := fnd_message.get;
842: RETURN NULL;
843: END search_method;

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

836: THEN
837: x_return_status := FND_API.G_RET_STS_ERROR ;
838: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
839: fnd_message.set_token('API_NAME',l_api_name);
840: fnd_message.set_token('SQL_ERROR',SQLERRM);
841: x_error_msg := fnd_message.get;
842: RETURN NULL;
843: END search_method;
844:

Line 841: x_error_msg := fnd_message.get;

837: x_return_status := FND_API.G_RET_STS_ERROR ;
838: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
839: fnd_message.set_token('API_NAME',l_api_name);
840: fnd_message.set_token('SQL_ERROR',SQLERRM);
841: x_error_msg := fnd_message.get;
842: RETURN NULL;
843: END search_method;
844:
845:

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

1176: WHEN fnd_api.g_exc_error THEN
1177: x_return_status := FND_API.G_RET_STS_ERROR ;
1178:
1179: IF l_sla_flag THEN
1180: fnd_message.set_name('CSE','CSE_SLA_PAY_CCID_NOT_FOUND');
1181: fnd_message.set_token('MTL_TXN_ID', l_mtl_txn_id);
1182: ELSE
1183: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
1184: fnd_message.set_token('ASSET_ATTRIBUTE','PAYABLES_CODE_COMBINATION_ID');

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

1177: x_return_status := FND_API.G_RET_STS_ERROR ;
1178:
1179: IF l_sla_flag THEN
1180: fnd_message.set_name('CSE','CSE_SLA_PAY_CCID_NOT_FOUND');
1181: fnd_message.set_token('MTL_TXN_ID', l_mtl_txn_id);
1182: ELSE
1183: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
1184: fnd_message.set_token('ASSET_ATTRIBUTE','PAYABLES_CODE_COMBINATION_ID');
1185: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);

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

1179: IF l_sla_flag THEN
1180: fnd_message.set_name('CSE','CSE_SLA_PAY_CCID_NOT_FOUND');
1181: fnd_message.set_token('MTL_TXN_ID', l_mtl_txn_id);
1182: ELSE
1183: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
1184: fnd_message.set_token('ASSET_ATTRIBUTE','PAYABLES_CODE_COMBINATION_ID');
1185: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
1186: END IF;
1187: x_error_msg := fnd_message.get;

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

1180: fnd_message.set_name('CSE','CSE_SLA_PAY_CCID_NOT_FOUND');
1181: fnd_message.set_token('MTL_TXN_ID', l_mtl_txn_id);
1182: ELSE
1183: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
1184: fnd_message.set_token('ASSET_ATTRIBUTE','PAYABLES_CODE_COMBINATION_ID');
1185: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
1186: END IF;
1187: x_error_msg := fnd_message.get;
1188: RETURN NULL ;

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

1181: fnd_message.set_token('MTL_TXN_ID', l_mtl_txn_id);
1182: ELSE
1183: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
1184: fnd_message.set_token('ASSET_ATTRIBUTE','PAYABLES_CODE_COMBINATION_ID');
1185: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
1186: END IF;
1187: x_error_msg := fnd_message.get;
1188: RETURN NULL ;
1189: END payables_ccid;

Line 1187: x_error_msg := fnd_message.get;

1183: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
1184: fnd_message.set_token('ASSET_ATTRIBUTE','PAYABLES_CODE_COMBINATION_ID');
1185: fnd_message.set_token('CSI_TRANSACTION_ID',p_asset_attrib_rec.transaction_id);
1186: END IF;
1187: x_error_msg := fnd_message.get;
1188: RETURN NULL ;
1189: END payables_ccid;
1190:
1191: ---------------------------------------------------------------------------+

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

1220: EXCEPTION
1221: WHEN OTHERS
1222: THEN
1223: x_return_status := FND_API.G_RET_STS_ERROR ;
1224: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1225: fnd_message.set_token('API_NAME',l_api_name);
1226: fnd_message.set_token('SQL_ERROR',SQLERRM);
1227: x_error_msg := fnd_message.get;
1228: RETURN NULL;

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

1221: WHEN OTHERS
1222: THEN
1223: x_return_status := FND_API.G_RET_STS_ERROR ;
1224: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1225: fnd_message.set_token('API_NAME',l_api_name);
1226: fnd_message.set_token('SQL_ERROR',SQLERRM);
1227: x_error_msg := fnd_message.get;
1228: RETURN NULL;
1229: END tag_number;

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

1222: THEN
1223: x_return_status := FND_API.G_RET_STS_ERROR ;
1224: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1225: fnd_message.set_token('API_NAME',l_api_name);
1226: fnd_message.set_token('SQL_ERROR',SQLERRM);
1227: x_error_msg := fnd_message.get;
1228: RETURN NULL;
1229: END tag_number;
1230:

Line 1227: x_error_msg := fnd_message.get;

1223: x_return_status := FND_API.G_RET_STS_ERROR ;
1224: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1225: fnd_message.set_token('API_NAME',l_api_name);
1226: fnd_message.set_token('SQL_ERROR',SQLERRM);
1227: x_error_msg := fnd_message.get;
1228: RETURN NULL;
1229: END tag_number;
1230:
1231: ---------------------------------------------------------------------------+

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

1259: EXCEPTION
1260: WHEN OTHERS
1261: THEN
1262: x_return_status := FND_API.G_RET_STS_ERROR ;
1263: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1264: fnd_message.set_token('API_NAME',l_api_name);
1265: fnd_message.set_token('SQL_ERROR',SQLERRM);
1266: x_error_msg := fnd_message.get;
1267: RETURN NULL;

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

1260: WHEN OTHERS
1261: THEN
1262: x_return_status := FND_API.G_RET_STS_ERROR ;
1263: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1264: fnd_message.set_token('API_NAME',l_api_name);
1265: fnd_message.set_token('SQL_ERROR',SQLERRM);
1266: x_error_msg := fnd_message.get;
1267: RETURN NULL;
1268: END model_number;

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

1261: THEN
1262: x_return_status := FND_API.G_RET_STS_ERROR ;
1263: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1264: fnd_message.set_token('API_NAME',l_api_name);
1265: fnd_message.set_token('SQL_ERROR',SQLERRM);
1266: x_error_msg := fnd_message.get;
1267: RETURN NULL;
1268: END model_number;
1269:

Line 1266: x_error_msg := fnd_message.get;

1262: x_return_status := FND_API.G_RET_STS_ERROR ;
1263: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1264: fnd_message.set_token('API_NAME',l_api_name);
1265: fnd_message.set_token('SQL_ERROR',SQLERRM);
1266: x_error_msg := fnd_message.get;
1267: RETURN NULL;
1268: END model_number;
1269:
1270: ---------------------------------------------------------------------------+

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

1298: EXCEPTION
1299: WHEN OTHERS
1300: THEN
1301: x_return_status := FND_API.G_RET_STS_ERROR ;
1302: fnd_message.set_token('API_NAME',l_api_name);
1303: fnd_message.set_token('SQL_ERROR',SQLERRM);
1304: x_error_msg := fnd_message.get;
1305: RETURN NULL;
1306: END manufacturer;

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

1299: WHEN OTHERS
1300: THEN
1301: x_return_status := FND_API.G_RET_STS_ERROR ;
1302: fnd_message.set_token('API_NAME',l_api_name);
1303: fnd_message.set_token('SQL_ERROR',SQLERRM);
1304: x_error_msg := fnd_message.get;
1305: RETURN NULL;
1306: END manufacturer;
1307:

Line 1304: x_error_msg := fnd_message.get;

1300: THEN
1301: x_return_status := FND_API.G_RET_STS_ERROR ;
1302: fnd_message.set_token('API_NAME',l_api_name);
1303: fnd_message.set_token('SQL_ERROR',SQLERRM);
1304: x_error_msg := fnd_message.get;
1305: RETURN NULL;
1306: END manufacturer;
1307:
1308: ---------------------------------------------------------------------------+

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

1336: EXCEPTION
1337: WHEN OTHERS
1338: THEN
1339: x_return_status := FND_API.G_RET_STS_ERROR ;
1340: fnd_message.set_token('API_NAME',l_api_name);
1341: fnd_message.set_token('SQL_ERROR',SQLERRM);
1342: x_error_msg := fnd_message.get;
1343: RETURN NULL;
1344: END employee;

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

1337: WHEN OTHERS
1338: THEN
1339: x_return_status := FND_API.G_RET_STS_ERROR ;
1340: fnd_message.set_token('API_NAME',l_api_name);
1341: fnd_message.set_token('SQL_ERROR',SQLERRM);
1342: x_error_msg := fnd_message.get;
1343: RETURN NULL;
1344: END employee;
1345:

Line 1342: x_error_msg := fnd_message.get;

1338: THEN
1339: x_return_status := FND_API.G_RET_STS_ERROR ;
1340: fnd_message.set_token('API_NAME',l_api_name);
1341: fnd_message.set_token('SQL_ERROR',SQLERRM);
1342: x_error_msg := fnd_message.get;
1343: RETURN NULL;
1344: END employee;
1345:
1346: FUNCTION inventory_item(

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

1434: EXCEPTION
1435: WHEN OTHERS
1436: THEN
1437: x_return_status := FND_API.G_RET_STS_ERROR ;
1438: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1439: fnd_message.set_token('API_NAME',l_api_name);
1440: fnd_message.set_token('SQL_ERROR',SQLERRM);
1441: x_error_msg := fnd_message.get;
1442:

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

1435: WHEN OTHERS
1436: THEN
1437: x_return_status := FND_API.G_RET_STS_ERROR ;
1438: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1439: fnd_message.set_token('API_NAME',l_api_name);
1440: fnd_message.set_token('SQL_ERROR',SQLERRM);
1441: x_error_msg := fnd_message.get;
1442:
1443: END get_pending_retirements;

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

1436: THEN
1437: x_return_status := FND_API.G_RET_STS_ERROR ;
1438: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1439: fnd_message.set_token('API_NAME',l_api_name);
1440: fnd_message.set_token('SQL_ERROR',SQLERRM);
1441: x_error_msg := fnd_message.get;
1442:
1443: END get_pending_retirements;
1444:

Line 1441: x_error_msg := fnd_message.get;

1437: x_return_status := FND_API.G_RET_STS_ERROR ;
1438: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1439: fnd_message.set_token('API_NAME',l_api_name);
1440: fnd_message.set_token('SQL_ERROR',SQLERRM);
1441: x_error_msg := fnd_message.get;
1442:
1443: END get_pending_retirements;
1444:
1445: ---------------------------------------------------------------------------

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

1517: EXCEPTION
1518: WHEN OTHERS
1519: THEN
1520: x_return_status := FND_API.G_RET_STS_ERROR ;
1521: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1522: fnd_message.set_token('API_NAME',l_api_name);
1523: fnd_message.set_token('SQL_ERROR',SQLERRM);
1524: x_error_msg := fnd_message.get;
1525:

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

1518: WHEN OTHERS
1519: THEN
1520: x_return_status := FND_API.G_RET_STS_ERROR ;
1521: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1522: fnd_message.set_token('API_NAME',l_api_name);
1523: fnd_message.set_token('SQL_ERROR',SQLERRM);
1524: x_error_msg := fnd_message.get;
1525:
1526: END get_pending_adjustments ;

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

1519: THEN
1520: x_return_status := FND_API.G_RET_STS_ERROR ;
1521: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1522: fnd_message.set_token('API_NAME',l_api_name);
1523: fnd_message.set_token('SQL_ERROR',SQLERRM);
1524: x_error_msg := fnd_message.get;
1525:
1526: END get_pending_adjustments ;
1527:

Line 1524: x_error_msg := fnd_message.get;

1520: x_return_status := FND_API.G_RET_STS_ERROR ;
1521: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1522: fnd_message.set_token('API_NAME',l_api_name);
1523: fnd_message.set_token('SQL_ERROR',SQLERRM);
1524: x_error_msg := fnd_message.get;
1525:
1526: END get_pending_adjustments ;
1527:
1528: -------------------------------------------------------------------------------

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

1840: END IF ;
1841: EXCEPTION
1842: WHEN OTHERS THEN
1843: x_return_status := FND_API.G_RET_STS_ERROR ;
1844: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1845: fnd_message.set_token('API_NAME',l_api_name);
1846: fnd_message.set_token('SQL_ERROR',SQLERRM);
1847: x_error_msg := fnd_message.get;
1848: END get_txn_class ;

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

1841: EXCEPTION
1842: WHEN OTHERS THEN
1843: x_return_status := FND_API.G_RET_STS_ERROR ;
1844: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1845: fnd_message.set_token('API_NAME',l_api_name);
1846: fnd_message.set_token('SQL_ERROR',SQLERRM);
1847: x_error_msg := fnd_message.get;
1848: END get_txn_class ;
1849:

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

1842: WHEN OTHERS THEN
1843: x_return_status := FND_API.G_RET_STS_ERROR ;
1844: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1845: fnd_message.set_token('API_NAME',l_api_name);
1846: fnd_message.set_token('SQL_ERROR',SQLERRM);
1847: x_error_msg := fnd_message.get;
1848: END get_txn_class ;
1849:
1850: -------------------------------------------------------------------------------

Line 1847: x_error_msg := fnd_message.get;

1843: x_return_status := FND_API.G_RET_STS_ERROR ;
1844: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1845: fnd_message.set_token('API_NAME',l_api_name);
1846: fnd_message.set_token('SQL_ERROR',SQLERRM);
1847: x_error_msg := fnd_message.get;
1848: END get_txn_class ;
1849:
1850: -------------------------------------------------------------------------------
1851: -- Procedure/Function Name : validate_inst_asset

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

1918: EXCEPTION
1919: WHEN OTHERS
1920: THEN
1921: x_return_status := FND_API.G_RET_STS_ERROR ;
1922: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1923: fnd_message.set_token('API_NAME',l_api_name);
1924: fnd_message.set_token('SQL_ERROR',SQLERRM);
1925: x_error_msg := fnd_message.get;
1926:

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

1919: WHEN OTHERS
1920: THEN
1921: x_return_status := FND_API.G_RET_STS_ERROR ;
1922: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1923: fnd_message.set_token('API_NAME',l_api_name);
1924: fnd_message.set_token('SQL_ERROR',SQLERRM);
1925: x_error_msg := fnd_message.get;
1926:
1927: END validate_inst_asset;

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

1920: THEN
1921: x_return_status := FND_API.G_RET_STS_ERROR ;
1922: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1923: fnd_message.set_token('API_NAME',l_api_name);
1924: fnd_message.set_token('SQL_ERROR',SQLERRM);
1925: x_error_msg := fnd_message.get;
1926:
1927: END validate_inst_asset;
1928:

Line 1925: x_error_msg := fnd_message.get;

1921: x_return_status := FND_API.G_RET_STS_ERROR ;
1922: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1923: fnd_message.set_token('API_NAME',l_api_name);
1924: fnd_message.set_token('SQL_ERROR',SQLERRM);
1925: x_error_msg := fnd_message.get;
1926:
1927: END validate_inst_asset;
1928:
1929:

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

2266: x_error_msg := substr(sqlerrm,1,200) ;
2267: debug('SQL ERRM : '||x_error_msg);
2268: x_return_status := FND_API.G_RET_STS_ERROR ;
2269: x_msg_count := 1;
2270: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2271: fnd_message.set_token('API_NAME',l_api_name);
2272: fnd_message.set_token('SQL_ERROR',SQLERRM);
2273: x_msg_data := fnd_message.get;
2274: END insert_mass_add;

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

2267: debug('SQL ERRM : '||x_error_msg);
2268: x_return_status := FND_API.G_RET_STS_ERROR ;
2269: x_msg_count := 1;
2270: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2271: fnd_message.set_token('API_NAME',l_api_name);
2272: fnd_message.set_token('SQL_ERROR',SQLERRM);
2273: x_msg_data := fnd_message.get;
2274: END insert_mass_add;
2275:

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

2268: x_return_status := FND_API.G_RET_STS_ERROR ;
2269: x_msg_count := 1;
2270: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2271: fnd_message.set_token('API_NAME',l_api_name);
2272: fnd_message.set_token('SQL_ERROR',SQLERRM);
2273: x_msg_data := fnd_message.get;
2274: END insert_mass_add;
2275:
2276:

Line 2273: x_msg_data := fnd_message.get;

2269: x_msg_count := 1;
2270: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2271: fnd_message.set_token('API_NAME',l_api_name);
2272: fnd_message.set_token('SQL_ERROR',SQLERRM);
2273: x_msg_data := fnd_message.get;
2274: END insert_mass_add;
2275:
2276:
2277: FUNCTION retire_non_mtl(

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

2541:
2542: EXCEPTION
2543: WHEN fnd_api.g_exc_error THEN
2544: x_return_status := FND_API.G_RET_STS_ERROR ;
2545: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
2546: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
2547: fnd_message.set_token('CSI_TRANSACTION_ID',p_inst_loc_rec.transaction_id);
2548: x_error_msg := fnd_message.get;
2549: END get_fa_location ;

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

2542: EXCEPTION
2543: WHEN fnd_api.g_exc_error THEN
2544: x_return_status := FND_API.G_RET_STS_ERROR ;
2545: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
2546: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
2547: fnd_message.set_token('CSI_TRANSACTION_ID',p_inst_loc_rec.transaction_id);
2548: x_error_msg := fnd_message.get;
2549: END get_fa_location ;
2550:

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

2543: WHEN fnd_api.g_exc_error THEN
2544: x_return_status := FND_API.G_RET_STS_ERROR ;
2545: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
2546: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
2547: fnd_message.set_token('CSI_TRANSACTION_ID',p_inst_loc_rec.transaction_id);
2548: x_error_msg := fnd_message.get;
2549: END get_fa_location ;
2550:
2551: -------------------------------------------------------------------------------

Line 2548: x_error_msg := fnd_message.get;

2544: x_return_status := FND_API.G_RET_STS_ERROR ;
2545: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
2546: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
2547: fnd_message.set_token('CSI_TRANSACTION_ID',p_inst_loc_rec.transaction_id);
2548: x_error_msg := fnd_message.get;
2549: END get_fa_location ;
2550:
2551: -------------------------------------------------------------------------------
2552: -- PROCEDURE get_unit_cost ---

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

2628: -- Added error message for bug 4869653
2629: IF x_unit_cost IS NULL THEN
2630: 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);
2631: x_return_status := FND_API.G_RET_STS_ERROR ;
2632: fnd_message.set_name('CSE','CSE_UNABLE_DERIVE_COST_ERROR');
2633: fnd_message.set_token('SOURCE_TYPE_CODE',p_source_txn_type);
2634: fnd_message.set_token('SOURCE_TYPE_ID',p_source_txn_id);
2635: x_error_msg := fnd_message.get;
2636: END IF;

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

2629: IF x_unit_cost IS NULL THEN
2630: 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);
2631: x_return_status := FND_API.G_RET_STS_ERROR ;
2632: fnd_message.set_name('CSE','CSE_UNABLE_DERIVE_COST_ERROR');
2633: fnd_message.set_token('SOURCE_TYPE_CODE',p_source_txn_type);
2634: fnd_message.set_token('SOURCE_TYPE_ID',p_source_txn_id);
2635: x_error_msg := fnd_message.get;
2636: END IF;
2637: -- End error message for bug 4869653

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

2630: 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);
2631: x_return_status := FND_API.G_RET_STS_ERROR ;
2632: fnd_message.set_name('CSE','CSE_UNABLE_DERIVE_COST_ERROR');
2633: fnd_message.set_token('SOURCE_TYPE_CODE',p_source_txn_type);
2634: fnd_message.set_token('SOURCE_TYPE_ID',p_source_txn_id);
2635: x_error_msg := fnd_message.get;
2636: END IF;
2637: -- End error message for bug 4869653
2638: END get_unit_cost ;

Line 2635: x_error_msg := fnd_message.get;

2631: x_return_status := FND_API.G_RET_STS_ERROR ;
2632: fnd_message.set_name('CSE','CSE_UNABLE_DERIVE_COST_ERROR');
2633: fnd_message.set_token('SOURCE_TYPE_CODE',p_source_txn_type);
2634: fnd_message.set_token('SOURCE_TYPE_ID',p_source_txn_id);
2635: x_error_msg := fnd_message.get;
2636: END IF;
2637: -- End error message for bug 4869653
2638: END get_unit_cost ;
2639:

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

2681: EXCEPTION
2682: WHEN OTHERS
2683: THEN
2684: x_return_status := FND_API.G_RET_STS_ERROR ;
2685: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2686: fnd_message.set_token('API_NAME',l_api_name);
2687: fnd_message.set_token('SQL_ERROR',SQLERRM);
2688: x_error_msg := fnd_message.get;
2689: END is_valid_to_retire ;

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

2682: WHEN OTHERS
2683: THEN
2684: x_return_status := FND_API.G_RET_STS_ERROR ;
2685: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2686: fnd_message.set_token('API_NAME',l_api_name);
2687: fnd_message.set_token('SQL_ERROR',SQLERRM);
2688: x_error_msg := fnd_message.get;
2689: END is_valid_to_retire ;
2690:

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

2683: THEN
2684: x_return_status := FND_API.G_RET_STS_ERROR ;
2685: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2686: fnd_message.set_token('API_NAME',l_api_name);
2687: fnd_message.set_token('SQL_ERROR',SQLERRM);
2688: x_error_msg := fnd_message.get;
2689: END is_valid_to_retire ;
2690:
2691:

Line 2688: x_error_msg := fnd_message.get;

2684: x_return_status := FND_API.G_RET_STS_ERROR ;
2685: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
2686: fnd_message.set_token('API_NAME',l_api_name);
2687: fnd_message.set_token('SQL_ERROR',SQLERRM);
2688: x_error_msg := fnd_message.get;
2689: END is_valid_to_retire ;
2690:
2691:
2692: -------------------------------------------------------------------------------