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_API

Line 86: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

82: WHERE msib.organization_id = c_org_id
83: AND msib.inventory_item_id = c_inv_item_id ;
84:
85: BEGIN
86: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
87: i:= 0;
88: cse_asset_client_ext_stub.get_asset_description( p_asset_attrib_rec, x_description, x_hook_used, x_error_msg);
89: l_description := x_description ;
90:

Line 103: x_return_status := FND_API.G_RET_STS_ERROR ;

99: RETURN l_description ;
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;

Line 110: x_return_status := FND_API.G_RET_STS_ERROR ;

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');
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;

Line 139: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

135:
136: l_api_name VARCHAR2(100) ;
137:
138: BEGIN
139: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
140: l_api_name := 'CSE_ASSET_UTIL_PKG.asset_category';
141: cse_asset_client_ext_stub.get_asset_category
142: (p_asset_attrib_rec, --modified the signature for R12
143: x_hook_used,

Line 156: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS

152: x_transaction_class => l_txn_class,
153: x_return_status => l_return_status ,
154: x_error_msg => l_error_msg);
155:
156: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
157: THEN
158: RAISE e_error ;
159: END IF ;
160:

Line 177: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS

173: l_category_segs,
174: l_return_status,
175: x_error_msg);
176:
177: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
178: THEN
179: RAISE e_error ;
180: END IF ;
181: RETURN p_asset_attrib_rec.Asset_Category_ID;

Line 186: x_return_status := FND_API.G_RET_STS_ERROR ;

182: END IF;
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

Line 192: x_return_status := FND_API.G_RET_STS_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 ;
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;

Line 220: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

216: e_error EXCEPTION;
217: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.Book_Type';
218: l_txn_ou_context NUMBER; -- Bug 6492235, added to support multiple FA book
219: BEGIN
220: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
221: cse_asset_client_ext_stub.get_book_type(p_asset_attrib_rec, --modified the signature for R12
222: x_hook_used,
223: x_error_msg);
224:

Line 307: x_return_status := FND_API.G_RET_STS_ERROR ;

303:
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

Line 313: x_return_status := FND_API.G_RET_STS_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 ;
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;

Line 363: x_return_status := fnd_api.g_ret_sts_success ;

359: AND trunc(l_transaction_date) BETWEEN fcp.start_date AND fcp.end_date;
360:
361: BEGIN
362:
363: x_return_status := fnd_api.g_ret_sts_success ;
364:
365: debug('inside cse_asset_util_pkg.date_place_in_service');
366:
367: cse_asset_client_ext_stub.get_date_place_in_service(

Line 400: IF nvl(p_asset_attrib_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN

396: IF l_serial_control_code in (2, 5) THEN
397: l_date_place_in_service := l_transaction_date;
398: ELSE
399:
400: IF nvl(p_asset_attrib_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
401: l_book_type_code := cse_asset_util_pkg.book_type(p_asset_attrib_rec,
402: x_error_msg,
403: x_return_status);
404: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

Line 404: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

400: IF nvl(p_asset_attrib_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
401: l_book_type_code := cse_asset_util_pkg.book_type(p_asset_attrib_rec,
402: x_error_msg,
403: x_return_status);
404: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
405: RAISE fnd_api.g_exc_error ;
406: END IF ;
407: ELSE
408: l_book_type_code := p_asset_attrib_rec.book_type_code;

Line 405: RAISE fnd_api.g_exc_error ;

401: l_book_type_code := cse_asset_util_pkg.book_type(p_asset_attrib_rec,
402: x_error_msg,
403: x_return_status);
404: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
405: RAISE fnd_api.g_exc_error ;
406: END IF ;
407: ELSE
408: l_book_type_code := p_asset_attrib_rec.book_type_code;
409: END IF;

Line 418: RAISE fnd_api.g_exc_error ;

414:
415: END IF;
416:
417: IF l_date_place_in_service IS NULL THEN
418: RAISE fnd_api.g_exc_error ;
419: END IF ;
420:
421: debug(' date_placed_in_service : '||l_date_place_in_service);
422: RETURN l_date_place_in_service ;

Line 428: WHEN fnd_api.g_exc_error THEN

424: END IF ; ---IPV/MOVE
425: END IF ; --Hook Used
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);

Line 429: x_return_status := FND_API.G_RET_STS_ERROR ;

425: END IF ; --Hook Used
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;

Line 447: x_return_status := fnd_api.g_ret_sts_success;

443: l_asset_key_ccid NUMBER;
444: l_hook_used PLS_INTEGER;
445: l_api_name VARCHAR2(100) := 'cse_asset_util_pkg.asset_key';
446: BEGIN
447: x_return_status := fnd_api.g_ret_sts_success;
448: cse_asset_client_ext_stub.get_asset_key(p_asset_attrib_rec,
449: l_asset_key_ccid,
450: l_hook_used,
451: x_error_msg);

Line 460: x_return_status := FND_API.G_RET_STS_ERROR ;

456: END IF;
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;

Line 509: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

505: AND citdv.inv_material_transaction_id=mmt.transaction_id ;
506:
507: BEGIN
508:
509: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
510: l_api_name := 'CSE_ASSET_UTIL_PKG.get_wip_assembly_cost';
511:
512: debug('Begining of Calculation of Wip cost ');
513:

Line 532: x_return_status := FND_API.G_RET_STS_ERROR ;

528: x_wip_assembly_cost := NVL(l_wip_job_cost,0) - NVL(l_fa_comp_cost,0);
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;

Line 561: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

557: l_hook_used pls_integer;
558: l_category_conc_seg varchar2(80);
559:
560: l_api_name varchar2(100) := 'cse_asset_util_pkg.deprn_expense_ccod';
561: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
562: l_error_message varchar2(2000);
563:
564: CURSOR fab_control_cur (c_book_type_code IN VARCHAR2) IS
565: SELECT accounting_flex_structure

Line 602: x_return_status := fnd_api.g_ret_sts_success;

598: WHERE category_id = l_category_id ;
599:
600: BEGIN
601:
602: x_return_status := fnd_api.g_ret_sts_success;
603:
604: IF nvl(p_asset_attrib_rec.book_type_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
605: l_book_type_code := p_asset_attrib_rec.book_type_code;
606: ELSE

Line 604: IF nvl(p_asset_attrib_rec.book_type_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN

600: BEGIN
601:
602: x_return_status := fnd_api.g_ret_sts_success;
603:
604: IF nvl(p_asset_attrib_rec.book_type_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
605: l_book_type_code := p_asset_attrib_rec.book_type_code;
606: ELSE
607:
608: l_book_type_code := cse_asset_util_pkg.book_type(

Line 613: IF l_return_status <> fnd_api.g_ret_sts_success THEN

609: p_asset_attrib_rec => p_asset_attrib_rec,
610: x_error_msg => l_error_message,
611: x_return_status => l_return_status);
612:
613: IF l_return_status <> fnd_api.g_ret_sts_success THEN
614: RAISE fnd_api.g_exc_error;
615: END IF ;
616: END IF;
617:

Line 614: RAISE fnd_api.g_exc_error;

610: x_error_msg => l_error_message,
611: x_return_status => l_return_status);
612:
613: IF l_return_status <> fnd_api.g_ret_sts_success THEN
614: RAISE fnd_api.g_exc_error;
615: END IF ;
616: END IF;
617:
618: cse_asset_client_ext_stub.get_deprn_expense_ccid(

Line 628: IF nvl(p_asset_attrib_rec.asset_category_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

624: IF l_hook_used = 1 THEN
625: RETURN l_deprn_expense_ccid;
626: ELSE
627:
628: IF nvl(p_asset_attrib_rec.asset_category_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
629: l_category_id := p_asset_attrib_rec.asset_category_id;
630: ELSE
631:
632: l_category_id := cse_asset_util_pkg.asset_category(

Line 637: IF l_return_status <> fnd_api.g_ret_sts_success THEN

633: p_asset_attrib_rec => p_asset_attrib_rec,
634: x_error_msg => l_error_message,
635: x_return_status => l_return_status);
636:
637: IF l_return_status <> fnd_api.g_ret_sts_success THEN
638: RAISE fnd_api.g_exc_error;
639: END IF ;
640: END IF;
641:

Line 638: RAISE fnd_api.g_exc_error;

634: x_error_msg => l_error_message,
635: x_return_status => l_return_status);
636:
637: IF l_return_status <> fnd_api.g_ret_sts_success THEN
638: RAISE fnd_api.g_exc_error;
639: END IF ;
640: END IF;
641:
642: OPEN fab_control_cur(l_book_type_code) ;

Line 662: RAISE fnd_api.g_exc_error;

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 ;
666: FETCH fnd_application_cur INTO l_app_short_name ;

Line 690: RAISE fnd_api.g_exc_error;

686: segments => l_segments,
687: combination_id => l_deprn_expense_ccid)
688: THEN
689: IF l_deprn_expense_ccid IS NULL THEN
690: RAISE fnd_api.g_exc_error;
691: END IF ;
692: RETURN l_deprn_expense_ccid ;
693: ELSE
694: null ;

Line 700: RAISE fnd_api.g_exc_error ;

696: END IF;
697: END IF;
698:
699: IF l_deprn_expense_ccid IS NULL THEN
700: RAISE fnd_api.g_exc_error ;
701: END IF;
702:
703: EXCEPTION
704: WHEN fnd_api.g_exc_error THEN

Line 704: WHEN fnd_api.g_exc_error THEN

700: RAISE fnd_api.g_exc_error ;
701: END IF;
702:
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);

Line 705: x_return_status := fnd_api.g_ret_sts_error;

701: END IF;
702:
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;

Line 735: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

731: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.search_method';
732:
733:
734: BEGIN
735: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
736: cse_asset_client_ext_stub.get_search_method( p_asset_attrib_rec,
737: x_search_method,
738: x_hook_used,
739: x_error_msg);

Line 785: x_return_status := FND_API.G_RET_STS_ERROR ;

781:
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;

Line 793: x_return_status := FND_API.G_RET_STS_ERROR ;

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 ;
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;

Line 912: x_return_status := fnd_api.g_ret_sts_success;

908: AND category_id = c_category_id ;
909:
910: BEGIN
911:
912: x_return_status := fnd_api.g_ret_sts_success;
913:
914: debug('inside cse_asset_util_pkg.payables_ccid');
915:
916: cse_asset_client_ext_stub.get_payables_ccid(

Line 941: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

937: x_transaction_class => l_txn_class,
938: x_return_status => l_return_status ,
939: x_error_msg => l_error_message);
940:
941: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
942: RAISE fnd_api.g_exc_error;
943: END IF ;
944:
945: debug('txn class : '||l_txn_class);

Line 942: RAISE fnd_api.g_exc_error;

938: x_return_status => l_return_status ,
939: x_error_msg => l_error_message);
940:
941: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
942: RAISE fnd_api.g_exc_error;
943: END IF ;
944:
945: debug('txn class : '||l_txn_class);
946:

Line 955: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

951:
952: l_book_type_code := cse_asset_util_pkg.book_type(p_asset_attrib_rec,
953: l_error_message,
954: l_return_status);
955: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
956: RAISE fnd_api.g_exc_error;
957: END IF ;
958: l_category_id := cse_asset_util_pkg.asset_category(p_asset_attrib_rec,
959: l_error_message,

Line 956: RAISE fnd_api.g_exc_error;

952: l_book_type_code := cse_asset_util_pkg.book_type(p_asset_attrib_rec,
953: l_error_message,
954: l_return_status);
955: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
956: RAISE fnd_api.g_exc_error;
957: END IF ;
958: l_category_id := cse_asset_util_pkg.asset_category(p_asset_attrib_rec,
959: l_error_message,
960: l_return_status);

Line 961: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

957: END IF ;
958: l_category_id := cse_asset_util_pkg.asset_category(p_asset_attrib_rec,
959: l_error_message,
960: l_return_status);
961: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
962: RAISE fnd_api.g_exc_error;
963: END IF ;
964:
965: OPEN asset_acct_cur (l_book_type_code,l_category_id);

Line 962: RAISE fnd_api.g_exc_error;

958: l_category_id := cse_asset_util_pkg.asset_category(p_asset_attrib_rec,
959: l_error_message,
960: l_return_status);
961: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
962: RAISE fnd_api.g_exc_error;
963: END IF ;
964:
965: OPEN asset_acct_cur (l_book_type_code,l_category_id);
966: FETCH asset_acct_cur INTO l_asset_acct_ccid ;

Line 970: RAISE fnd_api.g_exc_error;

966: FETCH asset_acct_cur INTO l_asset_acct_ccid ;
967: CLOSE asset_acct_cur ;
968:
969: IF l_asset_acct_ccid IS NULL THEN
970: RAISE fnd_api.g_exc_error;
971: END IF ;
972:
973: RETURN l_asset_acct_ccid ;
974: ELSE

Line 1043: RAISE fnd_api.g_exc_error;

1039:
1040: END IF;
1041:
1042: IF l_asset_acct_ccid IS NULL THEN
1043: RAISE fnd_api.g_exc_error;
1044: END IF ;
1045:
1046: RETURN l_asset_acct_ccid ;
1047: END IF ; --Move Txn

Line 1051: WHEN fnd_api.g_exc_error THEN

1047: END IF ; --Move Txn
1048: END IF; --Hook Used
1049:
1050: EXCEPTION
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');

Line 1052: x_return_status := FND_API.G_RET_STS_ERROR ;

1048: END IF; --Hook Used
1049:
1050: EXCEPTION
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);

Line 1082: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1078: l_tag_number VARCHAR2(15);
1079: x_hook_used PLS_INTEGER;
1080: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.tag_number';
1081: BEGIN
1082: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1083: cse_asset_client_ext_stub.get_tag_number(p_asset_attrib_rec,
1084: x_tag_number,
1085: x_hook_used,
1086: x_error_msg);

Line 1098: x_return_status := FND_API.G_RET_STS_ERROR ;

1094:
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;

Line 1122: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1118: l_model_number VARCHAR2(40);
1119: x_hook_used PLS_INTEGER;
1120: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.model_number';
1121: BEGIN
1122: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1123: cse_asset_client_ext_stub.get_model_number(p_asset_attrib_rec,
1124: x_model_number,
1125: x_hook_used,
1126: x_error_msg);

Line 1137: x_return_status := FND_API.G_RET_STS_ERROR ;

1133: END IF;
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;

Line 1161: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1157: l_manufacturer_name VARCHAR2(30);
1158: x_hook_used PLS_INTEGER;
1159: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.manufacturer';
1160: BEGIN
1161: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1162: cse_asset_client_ext_stub.get_manufacturer(p_asset_attrib_rec,
1163: x_manufacturer_name,
1164: x_hook_used,
1165: x_error_msg);

Line 1176: x_return_status := FND_API.G_RET_STS_ERROR ;

1172: END IF;
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;

Line 1199: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1195: x_employee_id NUMBER;
1196: l_employee_id NUMBER;
1197: x_hook_used PLS_INTEGER;
1198: BEGIN
1199: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1200: cse_asset_client_ext_stub.get_employee(p_asset_attrib_rec,
1201: x_employee_id,
1202: x_hook_used,
1203: x_error_msg);

Line 1214: x_return_status := FND_API.G_RET_STS_ERROR ;

1210: END IF;
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;

Line 1275: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1271: AND asset_id = p_asset_query_rec.asset_id ;
1272: --AND distribution_id = c_distribution_id ;
1273:
1274: BEGIN
1275: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1276: debug('Begin get_pending_retirements');
1277: FOR i IN 1..p_distribution_tbl.COUNT
1278: LOOP
1279: debug('Distribution ID : '||p_distribution_tbl(i).distribution_id) ;

Line 1293: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1289: NVL(p_asset_query_rec.pending_ret_mtl_cost,0)+l_cost ;
1290: p_distribution_tbl(i).pending_ret_units :=
1291: NVL(p_distribution_tbl(i).pending_ret_units,0)+l_units ;
1292: END IF;
1293: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1294: CLOSE pending_rets_cur ;
1295:
1296: OPEN ext_ret_cur (p_distribution_tbl(i).distribution_id) ;
1297: FETCH ext_ret_cur INTO l_cost, l_units ;

Line 1306: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1302: NVL(p_asset_query_rec.pending_ret_mtl_cost,0)+l_cost ;
1303: p_distribution_tbl(i).pending_ret_units :=
1304: NVL(p_distribution_tbl(i).pending_ret_units,0)+l_units ;
1305: END IF;
1306: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1307: CLOSE ext_ret_cur ;
1308: END LOOP ;
1309: EXCEPTION
1310: WHEN OTHERS

Line 1312: x_return_status := FND_API.G_RET_STS_ERROR ;

1308: END LOOP ;
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;

Line 1359: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1355: AND location_id = NVL(p_asset_query_rec.location_id,NVL(location_id,-1))
1356: AND mass_addition_id = c_mass_addition_id ;
1357:
1358: BEGIN
1359: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1360:
1361: debug('Start of get_pending_adjustment');
1362: FOR pending_adj_rec IN pending_adj_cur
1363: LOOP

Line 1395: x_return_status := FND_API.G_RET_STS_ERROR ;

1391:
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;

Line 1442: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1438: AND cia.instance_id = c_inst_id
1439: AND cia.instance_asset_id = c_instance_asset_id;
1440:
1441: BEGIN
1442: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1443: cse_asset_client_ext_stub.get_catchup_flag(p_asset_number,
1444: p_instance_asset_id,
1445: l_catchup_flag,
1446: x_hook_used,

Line 1511: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1507:
1508: BEGIN
1509: l_api_name := 'CSE_ASSET_UTIL_PKG.check_txn_class';
1510:
1511: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1512:
1513: l_txn_type := p_asset_attrib_rec.source_transaction_type ;
1514:
1515: OPEN item_type_cur(p_asset_attrib_rec.inv_master_organization_id, p_asset_attrib_rec.inventory_item_id) ;

Line 1538: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1534: x_redeploy_flag => l_redeploy_flag,
1535: x_return_status => x_return_status,
1536: x_error_message => x_error_msg);
1537:
1538: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1539: RAISE e_error ;
1540: END IF ;
1541: END IF ; --l_serial_number IS NULL
1542: ---For Redeployement

Line 1657: x_return_status := FND_API.G_RET_STS_ERROR ;

1653: x_transaction_class := 'NONE' ;
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;

Line 1710: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1706: l_inv_organization_id := p_asset_attrib_rec.organization_id;
1707: l_instance_id := p_asset_attrib_rec.instance_id;
1708: l_valid :='E';
1709: X_Valid :='Y';
1710: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1711: OPEN c_get_asset_subinventory ;
1712: FETCH c_get_asset_subinventory INTO l_valid ;
1713: CLOSE c_get_asset_subinventory ;
1714:

Line 1735: x_return_status := FND_API.G_RET_STS_ERROR ;

1731: END IF;
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;

Line 1791: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1787: AND FAC.BOOk_TYPE_CODE =c_book_type_code
1788: AND FAP.PERIOD_NAME=c_period_name;
1789:
1790: BEGIN
1791: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1792:
1793: SELECT fa_mass_additions_s.nextval
1794: INTO p_mass_add_rec.mass_addition_id
1795: FROM SYS.DUAL ;

Line 1997: IF p_commit = FND_API.G_TRUE THEN

1993: p_mass_add_rec.TRANSACTION_date,
1994: p_mass_add_rec.TRANSACTION_TYPE_CODE,
1995: p_mass_add_rec.po_distribution_id);
1996:
1997: IF p_commit = FND_API.G_TRUE THEN
1998: COMMIT ;
1999: END IF ;
2000: EXCEPTION
2001: WHEN OTHERS THEN

Line 2004: x_return_status := FND_API.G_RET_STS_ERROR ;

2000: EXCEPTION
2001: WHEN OTHERS THEN
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);

Line 2023: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

2019: IS
2020: x_retire_non_mtl_flag VARCHAR2(1) ;
2021: x_hook_used NUMBER;
2022: BEGIN
2023: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
2024: cse_asset_client_ext_stub.get_non_mtl_retire_flag
2025: ( p_asset_attrib_rec,
2026: p_asset_id,
2027: x_retire_non_mtl_flag,

Line 2041: x_return_status := fnd_api.G_RET_STS_ERROR ;

2037: RETURN x_retire_non_mtl_flag;
2038: EXCEPTION
2039: WHEN OTHERS
2040: THEN
2041: x_return_status := fnd_api.G_RET_STS_ERROR ;
2042: END retire_non_mtl ;
2043:
2044: -------------------------------------------------------------------------------
2045: --- Validates if current transaction is OK to interface to FA

Line 2181: x_return_status := fnd_api.g_ret_sts_success ;

2177: AND NVL(cal.active_end_date , l_sysdate) >= l_sysdate ;
2178:
2179: BEGIN
2180:
2181: x_return_status := fnd_api.g_ret_sts_success ;
2182: debug('Inside cse_asset_util_pkg.get_fa_location');
2183:
2184: x_asset_location_id := NULL ;
2185:

Line 2217: p_commit => fnd_api.g_false,

2213: debug(' time_stamp : '||to_char(l_time_stamp, 'dd-mon-yyyy hh24:mi:ss'));
2214:
2215: csi_item_instance_pub.get_item_instance_details(
2216: p_api_version => 1.0,
2217: p_commit => fnd_api.g_false,
2218: p_init_msg_list => fnd_api.g_true,
2219: p_validation_level => fnd_api.g_valid_level_full,
2220: p_instance_rec => l_instance_rec,
2221: p_get_parties => fnd_api.g_false,

Line 2218: p_init_msg_list => fnd_api.g_true,

2214:
2215: csi_item_instance_pub.get_item_instance_details(
2216: p_api_version => 1.0,
2217: p_commit => fnd_api.g_false,
2218: p_init_msg_list => fnd_api.g_true,
2219: p_validation_level => fnd_api.g_valid_level_full,
2220: p_instance_rec => l_instance_rec,
2221: p_get_parties => fnd_api.g_false,
2222: p_party_header_tbl => l_party_header_tbl,

Line 2219: p_validation_level => fnd_api.g_valid_level_full,

2215: csi_item_instance_pub.get_item_instance_details(
2216: p_api_version => 1.0,
2217: p_commit => fnd_api.g_false,
2218: p_init_msg_list => fnd_api.g_true,
2219: p_validation_level => fnd_api.g_valid_level_full,
2220: p_instance_rec => l_instance_rec,
2221: p_get_parties => fnd_api.g_false,
2222: p_party_header_tbl => l_party_header_tbl,
2223: p_get_accounts => fnd_api.g_false,

Line 2221: p_get_parties => fnd_api.g_false,

2217: p_commit => fnd_api.g_false,
2218: p_init_msg_list => fnd_api.g_true,
2219: p_validation_level => fnd_api.g_valid_level_full,
2220: p_instance_rec => l_instance_rec,
2221: p_get_parties => fnd_api.g_false,
2222: p_party_header_tbl => l_party_header_tbl,
2223: p_get_accounts => fnd_api.g_false,
2224: p_account_header_tbl => l_account_header_tbl,
2225: p_get_org_assignments => fnd_api.g_false,

Line 2223: p_get_accounts => fnd_api.g_false,

2219: p_validation_level => fnd_api.g_valid_level_full,
2220: p_instance_rec => l_instance_rec,
2221: p_get_parties => fnd_api.g_false,
2222: p_party_header_tbl => l_party_header_tbl,
2223: p_get_accounts => fnd_api.g_false,
2224: p_account_header_tbl => l_account_header_tbl,
2225: p_get_org_assignments => fnd_api.g_false,
2226: p_org_header_tbl => l_org_header_tbl,
2227: p_get_pricing_attribs => fnd_api.g_false,

Line 2225: p_get_org_assignments => fnd_api.g_false,

2221: p_get_parties => fnd_api.g_false,
2222: p_party_header_tbl => l_party_header_tbl,
2223: p_get_accounts => fnd_api.g_false,
2224: p_account_header_tbl => l_account_header_tbl,
2225: p_get_org_assignments => fnd_api.g_false,
2226: p_org_header_tbl => l_org_header_tbl,
2227: p_get_pricing_attribs => fnd_api.g_false,
2228: p_pricing_attrib_tbl => l_pricing_attrib_tbl,
2229: p_get_ext_attribs => fnd_api.g_false,

Line 2227: p_get_pricing_attribs => fnd_api.g_false,

2223: p_get_accounts => fnd_api.g_false,
2224: p_account_header_tbl => l_account_header_tbl,
2225: p_get_org_assignments => fnd_api.g_false,
2226: p_org_header_tbl => l_org_header_tbl,
2227: p_get_pricing_attribs => fnd_api.g_false,
2228: p_pricing_attrib_tbl => l_pricing_attrib_tbl,
2229: p_get_ext_attribs => fnd_api.g_false,
2230: p_ext_attrib_tbl => l_ext_attrib_tbl,
2231: p_ext_attrib_def_tbl => l_ext_attrib_def_tbl,

Line 2229: p_get_ext_attribs => fnd_api.g_false,

2225: p_get_org_assignments => fnd_api.g_false,
2226: p_org_header_tbl => l_org_header_tbl,
2227: p_get_pricing_attribs => fnd_api.g_false,
2228: p_pricing_attrib_tbl => l_pricing_attrib_tbl,
2229: p_get_ext_attribs => fnd_api.g_false,
2230: p_ext_attrib_tbl => l_ext_attrib_tbl,
2231: p_ext_attrib_def_tbl => l_ext_attrib_def_tbl,
2232: p_get_asset_assignments => fnd_api.g_false,
2233: p_asset_header_tbl => l_asset_header_tbl,

Line 2232: p_get_asset_assignments => fnd_api.g_false,

2228: p_pricing_attrib_tbl => l_pricing_attrib_tbl,
2229: p_get_ext_attribs => fnd_api.g_false,
2230: p_ext_attrib_tbl => l_ext_attrib_tbl,
2231: p_ext_attrib_def_tbl => l_ext_attrib_def_tbl,
2232: p_get_asset_assignments => fnd_api.g_false,
2233: p_asset_header_tbl => l_asset_header_tbl,
2234: p_resolve_id_columns => fnd_api.g_false,
2235: p_time_stamp => l_time_stamp,
2236: x_return_status => l_return_status,

Line 2234: p_resolve_id_columns => fnd_api.g_false,

2230: p_ext_attrib_tbl => l_ext_attrib_tbl,
2231: p_ext_attrib_def_tbl => l_ext_attrib_def_tbl,
2232: p_get_asset_assignments => fnd_api.g_false,
2233: p_asset_header_tbl => l_asset_header_tbl,
2234: p_resolve_id_columns => fnd_api.g_false,
2235: p_time_stamp => l_time_stamp,
2236: x_return_status => l_return_status,
2237: x_msg_count => l_msg_count,
2238: x_msg_data => l_msg_data );

Line 2240: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

2236: x_return_status => l_return_status,
2237: x_msg_count => l_msg_count,
2238: x_msg_data => l_msg_data );
2239:
2240: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
2241: l_error_message := cse_util_pkg.dump_error_stack;
2242: RAISE fnd_api.g_exc_error;
2243: END IF;
2244:

Line 2242: RAISE fnd_api.g_exc_error;

2238: x_msg_data => l_msg_data );
2239:
2240: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
2241: l_error_message := cse_util_pkg.dump_error_stack;
2242: RAISE fnd_api.g_exc_error;
2243: END IF;
2244:
2245: IF l_location_type_code IS NULL THEN
2246: l_location_type_code := l_instance_rec.location_type_code ;

Line 2276: RAISE fnd_api.g_exc_error ;

2272:
2273: debug(' x_asset_location_id : '||x_asset_location_id);
2274:
2275: IF x_asset_location_id IS NULL THEN
2276: RAISE fnd_api.g_exc_error ;
2277: END IF ;
2278:
2279: EXCEPTION
2280: WHEN fnd_api.g_exc_error THEN

Line 2280: WHEN fnd_api.g_exc_error THEN

2276: RAISE fnd_api.g_exc_error ;
2277: END IF ;
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);

Line 2281: x_return_status := FND_API.G_RET_STS_ERROR ;

2277: END IF ;
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;

Line 2367: x_return_status := FND_API.G_RET_STS_ERROR ;

2363:
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;

Line 2411: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2407:
2408: BEGIN
2409: x_valid_to_retire_flag := 'Y' ;
2410:
2411: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2412:
2413: OPEN check_current_period_add ;
2414: FETCH check_current_period_add INTO x_valid_to_retire_flag ;
2415: CLOSE check_current_period_add ;

Line 2420: x_return_status := FND_API.G_RET_STS_ERROR ;

2416:
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;