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 130: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

126: WHERE msib.organization_id = c_org_id
127: AND msib.inventory_item_id = c_inv_item_id ;
128:
129: BEGIN
130: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
131: i:= 0;
132: cse_asset_client_ext_stub.get_asset_description( p_asset_attrib_rec, x_description, x_hook_used, x_error_msg);
133: l_description := x_description ;
134:

Line 147: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 154: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 183: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

179:
180: l_api_name VARCHAR2(100) ;
181:
182: BEGIN
183: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
184: l_api_name := 'CSE_ASSET_UTIL_PKG.asset_category';
185: cse_asset_client_ext_stub.get_asset_category
186: (p_asset_attrib_rec, --modified the signature for R12
187: x_hook_used,

Line 200: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS

196: x_transaction_class => l_txn_class,
197: x_return_status => l_return_status ,
198: x_error_msg => l_error_msg);
199:
200: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
201: THEN
202: RAISE e_error ;
203: END IF ;
204:

Line 221: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS

217: l_category_segs,
218: l_return_status,
219: x_error_msg);
220:
221: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
222: THEN
223: RAISE e_error ;
224: END IF ;
225: RETURN p_asset_attrib_rec.Asset_Category_ID;

Line 230: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

Line 264: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

260: e_error EXCEPTION;
261: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.Book_Type';
262: l_txn_ou_context NUMBER; -- Bug 6492235, added to support multiple FA book
263: BEGIN
264: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
265: cse_asset_client_ext_stub.get_book_type(p_asset_attrib_rec, --modified the signature for R12
266: x_hook_used,
267: x_error_msg);
268:

Line 351: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

Line 407: x_return_status := fnd_api.g_ret_sts_success ;

403: AND trunc(l_transaction_date) BETWEEN fcp.start_date AND fcp.end_date;
404:
405: BEGIN
406:
407: x_return_status := fnd_api.g_ret_sts_success ;
408:
409: debug('inside cse_asset_util_pkg.date_place_in_service');
410:
411: cse_asset_client_ext_stub.get_date_place_in_service(

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

440: IF l_serial_control_code in (2, 5) THEN
441: l_date_place_in_service := l_transaction_date;
442: ELSE
443:
444: IF nvl(p_asset_attrib_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
445: l_book_type_code := cse_asset_util_pkg.book_type(p_asset_attrib_rec,
446: x_error_msg,
447: x_return_status);
448: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

Line 448: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

444: IF nvl(p_asset_attrib_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
445: l_book_type_code := cse_asset_util_pkg.book_type(p_asset_attrib_rec,
446: x_error_msg,
447: x_return_status);
448: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
449: RAISE fnd_api.g_exc_error ;
450: END IF ;
451: ELSE
452: l_book_type_code := p_asset_attrib_rec.book_type_code;

Line 449: RAISE fnd_api.g_exc_error ;

445: l_book_type_code := cse_asset_util_pkg.book_type(p_asset_attrib_rec,
446: x_error_msg,
447: x_return_status);
448: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
449: RAISE fnd_api.g_exc_error ;
450: END IF ;
451: ELSE
452: l_book_type_code := p_asset_attrib_rec.book_type_code;
453: END IF;

Line 462: RAISE fnd_api.g_exc_error ;

458:
459: END IF;
460:
461: IF l_date_place_in_service IS NULL THEN
462: RAISE fnd_api.g_exc_error ;
463: END IF ;
464:
465: debug(' date_placed_in_service : '||l_date_place_in_service);
466: RETURN l_date_place_in_service ;

Line 472: WHEN fnd_api.g_exc_error THEN

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

Line 473: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 491: x_return_status := fnd_api.g_ret_sts_success;

487: l_asset_key_ccid NUMBER;
488: l_hook_used PLS_INTEGER;
489: l_api_name VARCHAR2(100) := 'cse_asset_util_pkg.asset_key';
490: BEGIN
491: x_return_status := fnd_api.g_ret_sts_success;
492: cse_asset_client_ext_stub.get_asset_key(p_asset_attrib_rec,
493: l_asset_key_ccid,
494: l_hook_used,
495: x_error_msg);

Line 504: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 553: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

549: AND citdv.inv_material_transaction_id=mmt.transaction_id ;
550:
551: BEGIN
552:
553: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
554: l_api_name := 'CSE_ASSET_UTIL_PKG.get_wip_assembly_cost';
555:
556: debug('Begining of Calculation of Wip cost ');
557:

Line 576: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

601: l_hook_used pls_integer;
602: l_category_conc_seg varchar2(80);
603:
604: l_api_name varchar2(100) := 'cse_asset_util_pkg.deprn_expense_ccod';
605: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
606: l_error_message varchar2(2000);
607:
608: CURSOR fab_control_cur (c_book_type_code IN VARCHAR2) IS
609: SELECT accounting_flex_structure

Line 646: x_return_status := fnd_api.g_ret_sts_success;

642: WHERE category_id = l_category_id ;
643:
644: BEGIN
645:
646: x_return_status := fnd_api.g_ret_sts_success;
647:
648: IF nvl(p_asset_attrib_rec.book_type_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
649: l_book_type_code := p_asset_attrib_rec.book_type_code;
650: ELSE

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

644: BEGIN
645:
646: x_return_status := fnd_api.g_ret_sts_success;
647:
648: IF nvl(p_asset_attrib_rec.book_type_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
649: l_book_type_code := p_asset_attrib_rec.book_type_code;
650: ELSE
651:
652: l_book_type_code := cse_asset_util_pkg.book_type(

Line 657: IF l_return_status <> fnd_api.g_ret_sts_success THEN

653: p_asset_attrib_rec => p_asset_attrib_rec,
654: x_error_msg => l_error_message,
655: x_return_status => l_return_status);
656:
657: IF l_return_status <> fnd_api.g_ret_sts_success THEN
658: RAISE fnd_api.g_exc_error;
659: END IF ;
660: END IF;
661:

Line 658: RAISE fnd_api.g_exc_error;

654: x_error_msg => l_error_message,
655: x_return_status => l_return_status);
656:
657: IF l_return_status <> fnd_api.g_ret_sts_success THEN
658: RAISE fnd_api.g_exc_error;
659: END IF ;
660: END IF;
661:
662: cse_asset_client_ext_stub.get_deprn_expense_ccid(

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

668: IF l_hook_used = 1 THEN
669: RETURN l_deprn_expense_ccid;
670: ELSE
671:
672: IF nvl(p_asset_attrib_rec.asset_category_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
673: l_category_id := p_asset_attrib_rec.asset_category_id;
674: ELSE
675:
676: l_category_id := cse_asset_util_pkg.asset_category(

Line 681: IF l_return_status <> fnd_api.g_ret_sts_success THEN

677: p_asset_attrib_rec => p_asset_attrib_rec,
678: x_error_msg => l_error_message,
679: x_return_status => l_return_status);
680:
681: IF l_return_status <> fnd_api.g_ret_sts_success THEN
682: RAISE fnd_api.g_exc_error;
683: END IF ;
684: END IF;
685:

Line 682: RAISE fnd_api.g_exc_error;

678: x_error_msg => l_error_message,
679: x_return_status => l_return_status);
680:
681: IF l_return_status <> fnd_api.g_ret_sts_success THEN
682: RAISE fnd_api.g_exc_error;
683: END IF ;
684: END IF;
685:
686: OPEN fab_control_cur(l_book_type_code) ;

Line 706: RAISE fnd_api.g_exc_error;

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

Line 734: RAISE fnd_api.g_exc_error;

730: segments => l_segments,
731: combination_id => l_deprn_expense_ccid)
732: THEN
733: IF l_deprn_expense_ccid IS NULL THEN
734: RAISE fnd_api.g_exc_error;
735: END IF ;
736: RETURN l_deprn_expense_ccid ;
737: ELSE
738: null ;

Line 744: RAISE fnd_api.g_exc_error ;

740: END IF;
741: END IF;
742:
743: IF l_deprn_expense_ccid IS NULL THEN
744: RAISE fnd_api.g_exc_error ;
745: END IF;
746:
747: EXCEPTION
748: WHEN fnd_api.g_exc_error THEN

Line 748: WHEN fnd_api.g_exc_error THEN

744: RAISE fnd_api.g_exc_error ;
745: END IF;
746:
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);

Line 749: x_return_status := fnd_api.g_ret_sts_error;

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

Line 779: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

775: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.search_method';
776:
777:
778: BEGIN
779: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
780: cse_asset_client_ext_stub.get_search_method( p_asset_attrib_rec,
781: x_search_method,
782: x_hook_used,
783: x_error_msg);

Line 829: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 837: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 966: x_return_status := fnd_api.g_ret_sts_success;

962: l_cogs_recognized VARCHAR2(1);
963: l_cogs_mtl_txn_id NUMBER;
964: BEGIN
965:
966: x_return_status := fnd_api.g_ret_sts_success;
967:
968: debug('inside cse_asset_util_pkg.payables_ccid');
969:
970: l_asset_creation_txn_subtype :=nvl(FND_PROFILE.VALUE('CSE_TXN_SUBTYPE_ASSET_CREATION'), 0); --Added for ER#16265912

Line 1001: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

997: x_transaction_class => l_txn_class,
998: x_return_status => l_return_status ,
999: x_error_msg => l_error_message);
1000:
1001: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1002: RAISE fnd_api.g_exc_error;
1003: END IF ;
1004:
1005: debug('txn class : '||l_txn_class);

Line 1002: RAISE fnd_api.g_exc_error;

998: x_return_status => l_return_status ,
999: x_error_msg => l_error_message);
1000:
1001: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1002: RAISE fnd_api.g_exc_error;
1003: END IF ;
1004:
1005: debug('txn class : '||l_txn_class);
1006:

Line 1015: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1011:
1012: l_book_type_code := cse_asset_util_pkg.book_type(p_asset_attrib_rec,
1013: l_error_message,
1014: l_return_status);
1015: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1016: RAISE fnd_api.g_exc_error;
1017: END IF ;
1018: l_category_id := cse_asset_util_pkg.asset_category(p_asset_attrib_rec,
1019: l_error_message,

Line 1016: RAISE fnd_api.g_exc_error;

1012: l_book_type_code := cse_asset_util_pkg.book_type(p_asset_attrib_rec,
1013: l_error_message,
1014: l_return_status);
1015: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1016: RAISE fnd_api.g_exc_error;
1017: END IF ;
1018: l_category_id := cse_asset_util_pkg.asset_category(p_asset_attrib_rec,
1019: l_error_message,
1020: l_return_status);

Line 1021: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1017: END IF ;
1018: l_category_id := cse_asset_util_pkg.asset_category(p_asset_attrib_rec,
1019: l_error_message,
1020: l_return_status);
1021: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1022: RAISE fnd_api.g_exc_error;
1023: END IF ;
1024:
1025: OPEN asset_acct_cur (l_book_type_code,l_category_id);

Line 1022: RAISE fnd_api.g_exc_error;

1018: l_category_id := cse_asset_util_pkg.asset_category(p_asset_attrib_rec,
1019: l_error_message,
1020: l_return_status);
1021: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1022: RAISE fnd_api.g_exc_error;
1023: END IF ;
1024:
1025: OPEN asset_acct_cur (l_book_type_code,l_category_id);
1026: FETCH asset_acct_cur INTO l_asset_acct_ccid ;

Line 1030: RAISE fnd_api.g_exc_error;

1026: FETCH asset_acct_cur INTO l_asset_acct_ccid ;
1027: CLOSE asset_acct_cur ;
1028:
1029: IF l_asset_acct_ccid IS NULL THEN
1030: RAISE fnd_api.g_exc_error;
1031: END IF ;
1032:
1033: RETURN l_asset_acct_ccid ;
1034: ELSE

Line 1121: RAISE fnd_api.g_exc_error;

1117:
1118: EXCEPTION
1119: WHEN NO_DATA_FOUND THEN
1120: debug('COGS is not recognized for the shipping item.Please run COGS recognition Programs. ');
1121: RAISE fnd_api.g_exc_error;
1122: END;
1123: IF l_cogs_recognized ='Y' THEN
1124: l_acct_line_type := 35;
1125: l_mtl_txn_id := l_cogs_mtl_txn_id;

Line 1168: RAISE fnd_api.g_exc_error;

1164:
1165: END IF;
1166:
1167: IF l_asset_acct_ccid IS NULL THEN
1168: RAISE fnd_api.g_exc_error;
1169: END IF ;
1170:
1171: RETURN l_asset_acct_ccid ;
1172: END IF ; --Move Txn

Line 1176: WHEN fnd_api.g_exc_error THEN

1172: END IF ; --Move Txn
1173: END IF; --Hook Used
1174:
1175: EXCEPTION
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');

Line 1177: x_return_status := FND_API.G_RET_STS_ERROR ;

1173: END IF; --Hook Used
1174:
1175: EXCEPTION
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);

Line 1207: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1203: l_tag_number VARCHAR2(15);
1204: x_hook_used PLS_INTEGER;
1205: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.tag_number';
1206: BEGIN
1207: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1208: cse_asset_client_ext_stub.get_tag_number(p_asset_attrib_rec,
1209: x_tag_number,
1210: x_hook_used,
1211: x_error_msg);

Line 1223: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1247: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1243: l_model_number VARCHAR2(40);
1244: x_hook_used PLS_INTEGER;
1245: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.model_number';
1246: BEGIN
1247: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1248: cse_asset_client_ext_stub.get_model_number(p_asset_attrib_rec,
1249: x_model_number,
1250: x_hook_used,
1251: x_error_msg);

Line 1262: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1286: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1282: l_manufacturer_name VARCHAR2(30);
1283: x_hook_used PLS_INTEGER;
1284: l_api_name VARCHAR2(100) := 'CSE_ASSET_UTIL_PKG.manufacturer';
1285: BEGIN
1286: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1287: cse_asset_client_ext_stub.get_manufacturer(p_asset_attrib_rec,
1288: x_manufacturer_name,
1289: x_hook_used,
1290: x_error_msg);

Line 1301: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1324: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1320: x_employee_id NUMBER;
1321: l_employee_id NUMBER;
1322: x_hook_used PLS_INTEGER;
1323: BEGIN
1324: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1325: cse_asset_client_ext_stub.get_employee(p_asset_attrib_rec,
1326: x_employee_id,
1327: x_hook_used,
1328: x_error_msg);

Line 1339: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1400: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1396: AND asset_id = p_asset_query_rec.asset_id ;
1397: --AND distribution_id = c_distribution_id ;
1398:
1399: BEGIN
1400: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1401: debug('Begin get_pending_retirements');
1402: FOR i IN 1..p_distribution_tbl.COUNT
1403: LOOP
1404: debug('Distribution ID : '||p_distribution_tbl(i).distribution_id) ;

Line 1418: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1414: NVL(p_asset_query_rec.pending_ret_mtl_cost,0)+l_cost ;
1415: p_distribution_tbl(i).pending_ret_units :=
1416: NVL(p_distribution_tbl(i).pending_ret_units,0)+l_units ;
1417: END IF;
1418: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1419: CLOSE pending_rets_cur ;
1420:
1421: OPEN ext_ret_cur (p_distribution_tbl(i).distribution_id) ;
1422: FETCH ext_ret_cur INTO l_cost, l_units ;

Line 1431: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1427: NVL(p_asset_query_rec.pending_ret_mtl_cost,0)+l_cost ;
1428: p_distribution_tbl(i).pending_ret_units :=
1429: NVL(p_distribution_tbl(i).pending_ret_units,0)+l_units ;
1430: END IF;
1431: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1432: CLOSE ext_ret_cur ;
1433: END LOOP ;
1434: EXCEPTION
1435: WHEN OTHERS

Line 1437: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1484: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1480: AND location_id = NVL(p_asset_query_rec.location_id,NVL(location_id,-1))
1481: AND mass_addition_id = c_mass_addition_id ;
1482:
1483: BEGIN
1484: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1485:
1486: debug('Start of get_pending_adjustment');
1487: FOR pending_adj_rec IN pending_adj_cur
1488: LOOP

Line 1520: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1567: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1563: AND cia.instance_id = c_inst_id
1564: AND cia.instance_asset_id = c_instance_asset_id;
1565:
1566: BEGIN
1567: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1568: cse_asset_client_ext_stub.get_catchup_flag(p_asset_number,
1569: p_instance_asset_id,
1570: l_catchup_flag,
1571: x_hook_used,

Line 1642: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1638:
1639: BEGIN
1640: l_api_name := 'CSE_ASSET_UTIL_PKG.check_txn_class';
1641:
1642: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1643:
1644: l_txn_type := p_asset_attrib_rec.source_transaction_type ;
1645:
1646: l_asset_creation_txn_subtype :=nvl(FND_PROFILE.VALUE('CSE_TXN_SUBTYPE_ASSET_CREATION'), 0); --Added for ER#16265912

Line 1672: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1668: x_redeploy_flag => l_redeploy_flag,
1669: x_return_status => x_return_status,
1670: x_error_message => x_error_msg);
1671:
1672: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1673: RAISE e_error ;
1674: END IF ;
1675: END IF ; --l_serial_number IS NULL
1676: ---For Redeployement

Line 1843: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1896: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1892: l_inv_organization_id := p_asset_attrib_rec.organization_id;
1893: l_instance_id := p_asset_attrib_rec.instance_id;
1894: l_valid :='E';
1895: X_Valid :='Y';
1896: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1897: OPEN c_get_asset_subinventory ;
1898: FETCH c_get_asset_subinventory INTO l_valid ;
1899: CLOSE c_get_asset_subinventory ;
1900:

Line 1921: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1981: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

1977: AND FAC.BOOk_TYPE_CODE =c_book_type_code
1978: AND FAP.PERIOD_NAME=c_period_name;
1979:
1980: BEGIN
1981: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1982:
1983: SELECT fa_mass_additions_s.nextval
1984: INTO p_mass_add_rec.mass_addition_id
1985: FROM SYS.DUAL ;

Line 2261: IF p_commit = FND_API.G_TRUE THEN

2257: p_mass_add_rec.ATTRIBUTE29,
2258: p_mass_add_rec.ATTRIBUTE30
2259: );
2260:
2261: IF p_commit = FND_API.G_TRUE THEN
2262: COMMIT ;
2263: END IF ;
2264: EXCEPTION
2265: WHEN OTHERS THEN

Line 2268: x_return_status := FND_API.G_RET_STS_ERROR ;

2264: EXCEPTION
2265: WHEN OTHERS THEN
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);

Line 2287: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

2283: IS
2284: x_retire_non_mtl_flag VARCHAR2(1) ;
2285: x_hook_used NUMBER;
2286: BEGIN
2287: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
2288: cse_asset_client_ext_stub.get_non_mtl_retire_flag
2289: ( p_asset_attrib_rec,
2290: p_asset_id,
2291: x_retire_non_mtl_flag,

Line 2305: x_return_status := fnd_api.G_RET_STS_ERROR ;

2301: RETURN x_retire_non_mtl_flag;
2302: EXCEPTION
2303: WHEN OTHERS
2304: THEN
2305: x_return_status := fnd_api.G_RET_STS_ERROR ;
2306: END retire_non_mtl ;
2307:
2308: -------------------------------------------------------------------------------
2309: --- Validates if current transaction is OK to interface to FA

Line 2444: x_return_status := fnd_api.g_ret_sts_success ;

2440: AND NVL(cal.active_end_date , l_sysdate) >= l_sysdate ;
2441:
2442: BEGIN
2443:
2444: x_return_status := fnd_api.g_ret_sts_success ;
2445: debug('Inside cse_asset_util_pkg.get_fa_location');
2446:
2447: x_asset_location_id := NULL ;
2448:

Line 2480: p_commit => fnd_api.g_false,

2476: debug(' time_stamp : '||to_char(l_time_stamp, 'dd-mon-yyyy hh24:mi:ss'));
2477:
2478: csi_item_instance_pub.get_item_instance_details(
2479: p_api_version => 1.0,
2480: p_commit => fnd_api.g_false,
2481: p_init_msg_list => fnd_api.g_true,
2482: p_validation_level => fnd_api.g_valid_level_full,
2483: p_instance_rec => l_instance_rec,
2484: p_get_parties => fnd_api.g_false,

Line 2481: p_init_msg_list => fnd_api.g_true,

2477:
2478: csi_item_instance_pub.get_item_instance_details(
2479: p_api_version => 1.0,
2480: p_commit => fnd_api.g_false,
2481: p_init_msg_list => fnd_api.g_true,
2482: p_validation_level => fnd_api.g_valid_level_full,
2483: p_instance_rec => l_instance_rec,
2484: p_get_parties => fnd_api.g_false,
2485: p_party_header_tbl => l_party_header_tbl,

Line 2482: p_validation_level => fnd_api.g_valid_level_full,

2478: csi_item_instance_pub.get_item_instance_details(
2479: p_api_version => 1.0,
2480: p_commit => fnd_api.g_false,
2481: p_init_msg_list => fnd_api.g_true,
2482: p_validation_level => fnd_api.g_valid_level_full,
2483: p_instance_rec => l_instance_rec,
2484: p_get_parties => fnd_api.g_false,
2485: p_party_header_tbl => l_party_header_tbl,
2486: p_get_accounts => fnd_api.g_false,

Line 2484: p_get_parties => fnd_api.g_false,

2480: p_commit => fnd_api.g_false,
2481: p_init_msg_list => fnd_api.g_true,
2482: p_validation_level => fnd_api.g_valid_level_full,
2483: p_instance_rec => l_instance_rec,
2484: p_get_parties => fnd_api.g_false,
2485: p_party_header_tbl => l_party_header_tbl,
2486: p_get_accounts => fnd_api.g_false,
2487: p_account_header_tbl => l_account_header_tbl,
2488: p_get_org_assignments => fnd_api.g_false,

Line 2486: p_get_accounts => fnd_api.g_false,

2482: p_validation_level => fnd_api.g_valid_level_full,
2483: p_instance_rec => l_instance_rec,
2484: p_get_parties => fnd_api.g_false,
2485: p_party_header_tbl => l_party_header_tbl,
2486: p_get_accounts => fnd_api.g_false,
2487: p_account_header_tbl => l_account_header_tbl,
2488: p_get_org_assignments => fnd_api.g_false,
2489: p_org_header_tbl => l_org_header_tbl,
2490: p_get_pricing_attribs => fnd_api.g_false,

Line 2488: p_get_org_assignments => fnd_api.g_false,

2484: p_get_parties => fnd_api.g_false,
2485: p_party_header_tbl => l_party_header_tbl,
2486: p_get_accounts => fnd_api.g_false,
2487: p_account_header_tbl => l_account_header_tbl,
2488: p_get_org_assignments => fnd_api.g_false,
2489: p_org_header_tbl => l_org_header_tbl,
2490: p_get_pricing_attribs => fnd_api.g_false,
2491: p_pricing_attrib_tbl => l_pricing_attrib_tbl,
2492: p_get_ext_attribs => fnd_api.g_false,

Line 2490: p_get_pricing_attribs => fnd_api.g_false,

2486: p_get_accounts => fnd_api.g_false,
2487: p_account_header_tbl => l_account_header_tbl,
2488: p_get_org_assignments => fnd_api.g_false,
2489: p_org_header_tbl => l_org_header_tbl,
2490: p_get_pricing_attribs => fnd_api.g_false,
2491: p_pricing_attrib_tbl => l_pricing_attrib_tbl,
2492: p_get_ext_attribs => fnd_api.g_false,
2493: p_ext_attrib_tbl => l_ext_attrib_tbl,
2494: p_ext_attrib_def_tbl => l_ext_attrib_def_tbl,

Line 2492: p_get_ext_attribs => fnd_api.g_false,

2488: p_get_org_assignments => fnd_api.g_false,
2489: p_org_header_tbl => l_org_header_tbl,
2490: p_get_pricing_attribs => fnd_api.g_false,
2491: p_pricing_attrib_tbl => l_pricing_attrib_tbl,
2492: p_get_ext_attribs => fnd_api.g_false,
2493: p_ext_attrib_tbl => l_ext_attrib_tbl,
2494: p_ext_attrib_def_tbl => l_ext_attrib_def_tbl,
2495: p_get_asset_assignments => fnd_api.g_false,
2496: p_asset_header_tbl => l_asset_header_tbl,

Line 2495: p_get_asset_assignments => fnd_api.g_false,

2491: p_pricing_attrib_tbl => l_pricing_attrib_tbl,
2492: p_get_ext_attribs => fnd_api.g_false,
2493: p_ext_attrib_tbl => l_ext_attrib_tbl,
2494: p_ext_attrib_def_tbl => l_ext_attrib_def_tbl,
2495: p_get_asset_assignments => fnd_api.g_false,
2496: p_asset_header_tbl => l_asset_header_tbl,
2497: p_resolve_id_columns => fnd_api.g_false,
2498: p_time_stamp => l_time_stamp,
2499: x_return_status => l_return_status,

Line 2497: p_resolve_id_columns => fnd_api.g_false,

2493: p_ext_attrib_tbl => l_ext_attrib_tbl,
2494: p_ext_attrib_def_tbl => l_ext_attrib_def_tbl,
2495: p_get_asset_assignments => fnd_api.g_false,
2496: p_asset_header_tbl => l_asset_header_tbl,
2497: p_resolve_id_columns => fnd_api.g_false,
2498: p_time_stamp => l_time_stamp,
2499: x_return_status => l_return_status,
2500: x_msg_count => l_msg_count,
2501: x_msg_data => l_msg_data );

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

2499: x_return_status => l_return_status,
2500: x_msg_count => l_msg_count,
2501: x_msg_data => l_msg_data );
2502:
2503: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
2504: l_error_message := cse_util_pkg.dump_error_stack;
2505: RAISE fnd_api.g_exc_error;
2506: END IF;
2507:

Line 2505: RAISE fnd_api.g_exc_error;

2501: x_msg_data => l_msg_data );
2502:
2503: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
2504: l_error_message := cse_util_pkg.dump_error_stack;
2505: RAISE fnd_api.g_exc_error;
2506: END IF;
2507:
2508: IF l_location_type_code IS NULL THEN
2509: l_location_type_code := l_instance_rec.location_type_code ;

Line 2539: RAISE fnd_api.g_exc_error ;

2535:
2536: debug(' x_asset_location_id : '||x_asset_location_id);
2537:
2538: IF x_asset_location_id IS NULL THEN
2539: RAISE fnd_api.g_exc_error ;
2540: END IF ;
2541:
2542: EXCEPTION
2543: WHEN fnd_api.g_exc_error THEN

Line 2543: WHEN fnd_api.g_exc_error THEN

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

Line 2544: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 2631: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 2675: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2671:
2672: BEGIN
2673: x_valid_to_retire_flag := 'Y' ;
2674:
2675: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2676:
2677: OPEN check_current_period_add ;
2678: FETCH check_current_period_add INTO x_valid_to_retire_flag ;
2679: CLOSE check_current_period_add ;

Line 2684: x_return_status := FND_API.G_RET_STS_ERROR ;

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