APPS.CSE_ASSET_CREATION_PKG dependencies on FND_API

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

166: l_error_id number;
167: l_source_type varchar2(20);
168: l_error_message varchar2(2000);
169:
170: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
171: l_msg_count number;
172: l_msg_data varchar2(2000);
173:
174: BEGIN

Line 222: p_init_msg_list => fnd_api.g_true,

218: WHEN no_data_found THEN
219:
220: csi_transactions_pvt.create_txn_error (
221: p_api_version => 1.0,
222: p_init_msg_list => fnd_api.g_true,
223: p_commit => fnd_api.g_false,
224: p_validation_level => fnd_api.g_valid_level_full,
225: p_txn_error_rec => l_error_rec,
226: x_transaction_error_id => l_error_id,

Line 223: p_commit => fnd_api.g_false,

219:
220: csi_transactions_pvt.create_txn_error (
221: p_api_version => 1.0,
222: p_init_msg_list => fnd_api.g_true,
223: p_commit => fnd_api.g_false,
224: p_validation_level => fnd_api.g_valid_level_full,
225: p_txn_error_rec => l_error_rec,
226: x_transaction_error_id => l_error_id,
227: x_return_status => l_return_status,

Line 224: p_validation_level => fnd_api.g_valid_level_full,

220: csi_transactions_pvt.create_txn_error (
221: p_api_version => 1.0,
222: p_init_msg_list => fnd_api.g_true,
223: p_commit => fnd_api.g_false,
224: p_validation_level => fnd_api.g_valid_level_full,
225: p_txn_error_rec => l_error_rec,
226: x_transaction_error_id => l_error_id,
227: x_return_status => l_return_status,
228: x_msg_count => l_msg_count,

Line 231: IF l_return_status <> fnd_api.g_ret_sts_success THEN

227: x_return_status => l_return_status,
228: x_msg_count => l_msg_count,
229: x_msg_data => l_msg_data);
230:
231: IF l_return_status <> fnd_api.g_ret_sts_success THEN
232: RAISE fnd_api.g_exc_error;
233: END IF;
234:
235: debug(' new error logged. transaction_error_id : '||l_error_id);

Line 232: RAISE fnd_api.g_exc_error;

228: x_msg_count => l_msg_count,
229: x_msg_data => l_msg_data);
230:
231: IF l_return_status <> fnd_api.g_ret_sts_success THEN
232: RAISE fnd_api.g_exc_error;
233: END IF;
234:
235: debug(' new error logged. transaction_error_id : '||l_error_id);
236: END;

Line 239: WHEN fnd_api.g_exc_error THEN

235: debug(' new error logged. transaction_error_id : '||l_error_id);
236: END;
237:
238: EXCEPTION
239: WHEN fnd_api.g_exc_error THEN
240: NULL;
241: -- i mean if you can't log the error then what else will you do.
242: -- just leave the transaction as pending so that atleast the next run
243: -- will pick it yp

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

248: x_return_status OUT nocopy varchar2,
249: x_error_message OUT nocopy varchar2)
250: IS
251: l_txn_rec csi_datastructures_pub.transaction_rec;
252: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
253: l_msg_count number;
254: l_msg_data varchar2(2000);
255: BEGIN
256:

Line 257: x_return_status := fnd_api.g_ret_sts_success;

253: l_msg_count number;
254: l_msg_data varchar2(2000);
255: BEGIN
256:
257: x_return_status := fnd_api.g_ret_sts_success;
258:
259: l_txn_rec.transaction_id := p_csi_txn_id;
260: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;
261: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;

Line 270: p_init_msg_list => fnd_api.g_true,

266: WHERE transaction_id = l_txn_rec.transaction_id;
267:
268: csi_transactions_pvt.update_transactions(
269: p_api_version => 1.0,
270: p_init_msg_list => fnd_api.g_true,
271: p_commit => fnd_api.g_false,
272: p_validation_level => fnd_api.g_valid_level_full,
273: p_transaction_rec => l_txn_rec,
274: x_return_status => l_return_status,

Line 271: p_commit => fnd_api.g_false,

267:
268: csi_transactions_pvt.update_transactions(
269: p_api_version => 1.0,
270: p_init_msg_list => fnd_api.g_true,
271: p_commit => fnd_api.g_false,
272: p_validation_level => fnd_api.g_valid_level_full,
273: p_transaction_rec => l_txn_rec,
274: x_return_status => l_return_status,
275: x_msg_count => l_msg_count,

Line 272: p_validation_level => fnd_api.g_valid_level_full,

268: csi_transactions_pvt.update_transactions(
269: p_api_version => 1.0,
270: p_init_msg_list => fnd_api.g_true,
271: p_commit => fnd_api.g_false,
272: p_validation_level => fnd_api.g_valid_level_full,
273: p_transaction_rec => l_txn_rec,
274: x_return_status => l_return_status,
275: x_msg_count => l_msg_count,
276: x_msg_data => l_msg_data);

Line 278: IF l_return_status <> fnd_api.g_ret_sts_success THEN

274: x_return_status => l_return_status,
275: x_msg_count => l_msg_count,
276: x_msg_data => l_msg_data);
277:
278: IF l_return_status <> fnd_api.g_ret_sts_success THEN
279: RAISE fnd_api.g_exc_error;
280: END IF;
281:
282: EXCEPTION

Line 279: RAISE fnd_api.g_exc_error;

275: x_msg_count => l_msg_count,
276: x_msg_data => l_msg_data);
277:
278: IF l_return_status <> fnd_api.g_ret_sts_success THEN
279: RAISE fnd_api.g_exc_error;
280: END IF;
281:
282: EXCEPTION
283: WHEN fnd_api.g_exc_error THEN

Line 283: WHEN fnd_api.g_exc_error THEN

279: RAISE fnd_api.g_exc_error;
280: END IF;
281:
282: EXCEPTION
283: WHEN fnd_api.g_exc_error THEN
284: x_return_status := fnd_api.g_ret_sts_error;
285: END complete_csi_txn;
286:
287: PROCEDURE get_redeploy_flag(

Line 284: x_return_status := fnd_api.g_ret_sts_error;

280: END IF;
281:
282: EXCEPTION
283: WHEN fnd_api.g_exc_error THEN
284: x_return_status := fnd_api.g_ret_sts_error;
285: END complete_csi_txn;
286:
287: PROCEDURE get_redeploy_flag(
288: p_instance_id IN number,

Line 442: x_return_status := fnd_api.g_ret_sts_success ;

438: CLOSE round_currency_cur;
439: END round_currency;
440:
441: BEGIN
442: x_return_status := fnd_api.g_ret_sts_success ;
443:
444: OPEN base_currency_cur ;
445: FETCH base_currency_cur INTO l_fa_currency_code ;
446: CLOSE base_currency_cur ;

Line 506: RAISE fnd_api.g_exc_error;

502: CLOSE po_sob_currency_cur ;
503: debug('l_base_amount : '||l_base_amount);
504: IF l_base_amount IS NULL THEN
505: x_error_msg := 'Unable to derive base amount for PO receit transaction';
506: RAISE fnd_api.g_exc_error;
507: END IF ;
508:
509: x_base_amount := l_base_amount;
510:

Line 512: WHEN fnd_api.g_exc_error THEN

508:
509: x_base_amount := l_base_amount;
510:
511: EXCEPTION
512: WHEN fnd_api.g_exc_error THEN
513: x_return_status := fnd_api.g_ret_sts_error ;
514: END get_base_amount ;
515:
516: PROCEDURE get_fa_location_id(

Line 513: x_return_status := fnd_api.g_ret_sts_error ;

509: x_base_amount := l_base_amount;
510:
511: EXCEPTION
512: WHEN fnd_api.g_exc_error THEN
513: x_return_status := fnd_api.g_ret_sts_error ;
514: END get_base_amount ;
515:
516: PROCEDURE get_fa_location_id(
517: p_location_type_code IN varchar2,

Line 535: x_return_status := fnd_api.g_ret_sts_success;

531: AND sysdate BETWEEN nvl(active_start_date, sysdate - 1)
532: AND nvl(active_end_date, sysdate + 1);
533: BEGIN
534:
535: x_return_status := fnd_api.g_ret_sts_success;
536:
537: IF p_location_type_code = 'INVENTORY' THEN
538: l_location_table := 'HR_LOCATIONS';
539: ELSIF p_location_type_code = 'HZ_LOCATIONS' THEN

Line 560: RAISE fnd_api.g_exc_error;

556: exit;
557: END LOOP;
558:
559: IF x_fa_location_id is null then
560: RAISE fnd_api.g_exc_error;
561: END IF;
562: EXCEPTION
563: WHEN fnd_api.g_exc_error THEN
564: x_return_status := fnd_api.g_ret_sts_error;

Line 563: WHEN fnd_api.g_exc_error THEN

559: IF x_fa_location_id is null then
560: RAISE fnd_api.g_exc_error;
561: END IF;
562: EXCEPTION
563: WHEN fnd_api.g_exc_error THEN
564: x_return_status := fnd_api.g_ret_sts_error;
565: END get_fa_location_id;
566:
567: PROCEDURE derive_asset_attribs(

Line 564: x_return_status := fnd_api.g_ret_sts_error;

560: RAISE fnd_api.g_exc_error;
561: END IF;
562: EXCEPTION
563: WHEN fnd_api.g_exc_error THEN
564: x_return_status := fnd_api.g_ret_sts_error;
565: END get_fa_location_id;
566:
567: PROCEDURE derive_asset_attribs(
568: px_instance_tbl IN OUT nocopy instance_tbl,

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

595: l_employee_id number;
596: l_search_method varchar2(10);
597:
598: l_hook_used varchar2(1);
599: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
600: l_error_message varchar2(2000);
601:
602: BEGIN
603:

Line 606: x_return_status := fnd_api.g_ret_sts_success;

602: BEGIN
603:
604: debug('inside derive_asset_attribs');
605:
606: x_return_status := fnd_api.g_ret_sts_success;
607:
608: l_inst_tbl := px_instance_tbl;
609:
610: IF l_inst_tbl.COUNT > 0 THEN

Line 653: IF l_return_status <> fnd_api.g_ret_sts_success THEN

649: l_asset_description := cse_asset_util_pkg.asset_description(
650: p_asset_attrib_rec => l_asset_attrib_rec,
651: x_error_msg => l_error_message,
652: x_return_status => l_return_status);
653: IF l_return_status <> fnd_api.g_ret_sts_success THEN
654: RAISE fnd_api.g_exc_error;
655: END IF;
656:
657: -- asset unit cost

Line 654: RAISE fnd_api.g_exc_error;

650: p_asset_attrib_rec => l_asset_attrib_rec,
651: x_error_msg => l_error_message,
652: x_return_status => l_return_status);
653: IF l_return_status <> fnd_api.g_ret_sts_success THEN
654: RAISE fnd_api.g_exc_error;
655: END IF;
656:
657: -- asset unit cost
658: cse_asset_util_pkg.get_unit_cost(

Line 667: IF l_return_status <> fnd_api.g_ret_sts_success THEN

663: x_unit_cost => l_asset_unit_cost,
664: x_error_msg => l_error_message,
665: x_return_status => l_return_status);
666:
667: IF l_return_status <> fnd_api.g_ret_sts_success THEN
668: RAISE fnd_api.g_exc_error;
669: END IF;
670:
671: debug(' asset_unit_cost : '||l_asset_unit_cost);

Line 668: RAISE fnd_api.g_exc_error;

664: x_error_msg => l_error_message,
665: x_return_status => l_return_status);
666:
667: IF l_return_status <> fnd_api.g_ret_sts_success THEN
668: RAISE fnd_api.g_exc_error;
669: END IF;
670:
671: debug(' asset_unit_cost : '||l_asset_unit_cost);
672:

Line 680: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 681: RAISE fnd_api.g_exc_error;

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

Line 686: IF nvl(l_asset_attrib_rec.asset_category_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

682: END IF;
683:
684: l_asset_attrib_rec.asset_category_id := l_asset_category_id;
685:
686: IF nvl(l_asset_attrib_rec.asset_category_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
687:
688: SELECT concatenated_segments
689: INTO l_asset_category
690: FROM fa_categories_b_kfv

Line 700: IF l_return_status <> fnd_api.g_ret_sts_success THEN

696: p_asset_attrib_rec => l_asset_attrib_rec,
697: x_error_msg => l_error_message,
698: x_return_status => l_return_status);
699:
700: IF l_return_status <> fnd_api.g_ret_sts_success THEN
701: RAISE fnd_api.g_exc_error;
702: END IF;
703:
704: l_asset_attrib_rec.book_type_code := l_book_type_code;

Line 701: RAISE fnd_api.g_exc_error;

697: x_error_msg => l_error_message,
698: x_return_status => l_return_status);
699:
700: IF l_return_status <> fnd_api.g_ret_sts_success THEN
701: RAISE fnd_api.g_exc_error;
702: END IF;
703:
704: l_asset_attrib_rec.book_type_code := l_book_type_code;
705:

Line 719: RAISE fnd_api.g_exc_error;

715: fnd_message.set_name('CSE', 'CSE_ASSET_BOOK_CAT_UNDEFINED');
716: fnd_message.set_token('ASSET_CAT', l_asset_category);
717: fnd_message.set_token('BOOK_TYPE_CODE', l_book_type_code);
718: l_error_message := fnd_message.get;
719: RAISE fnd_api.g_exc_error;
720: END;
721: ELSE
722: fnd_message.set_name('CSE', 'CSE_ASSET_CAT_ERROR');
723: l_error_message := fnd_message.get;

Line 724: RAISE fnd_api.g_exc_error;

720: END;
721: ELSE
722: fnd_message.set_name('CSE', 'CSE_ASSET_CAT_ERROR');
723: l_error_message := fnd_message.get;
724: RAISE fnd_api.g_exc_error;
725: END IF;
726:
727: -- date placed in service
728: l_dpi :=

Line 734: IF l_return_status <> fnd_api.g_ret_sts_success THEN

730: p_asset_attrib_rec => l_asset_attrib_rec,
731: x_error_msg => l_error_message,
732: x_return_status => l_return_status);
733:
734: IF l_return_status <> fnd_api.g_ret_sts_success THEN
735: RAISE fnd_api.g_exc_error;
736: END IF;
737:
738: l_asset_key_ccid :=

Line 735: RAISE fnd_api.g_exc_error;

731: x_error_msg => l_error_message,
732: x_return_status => l_return_status);
733:
734: IF l_return_status <> fnd_api.g_ret_sts_success THEN
735: RAISE fnd_api.g_exc_error;
736: END IF;
737:
738: l_asset_key_ccid :=
739: cse_asset_util_pkg.asset_key(

Line 744: IF l_return_status <> fnd_api.g_ret_sts_success THEN

740: p_asset_attrib_rec => l_asset_attrib_rec,
741: x_error_msg => l_error_message,
742: x_return_status => l_return_status);
743:
744: IF l_return_status <> fnd_api.g_ret_sts_success THEN
745: RAISE fnd_api.g_exc_error;
746: END IF;
747:
748: -- get fa location

Line 745: RAISE fnd_api.g_exc_error;

741: x_error_msg => l_error_message,
742: x_return_status => l_return_status);
743:
744: IF l_return_status <> fnd_api.g_ret_sts_success THEN
745: RAISE fnd_api.g_exc_error;
746: END IF;
747:
748: -- get fa location
749: get_fa_location_id(

Line 755: IF l_return_status <> fnd_api.g_ret_sts_success THEN

751: p_location_id => l_inst_tbl(l_ind).location_id,
752: x_fa_location_id => l_fa_location_id,
753: x_return_status => l_return_status);
754:
755: IF l_return_status <> fnd_api.g_ret_sts_success THEN
756: debug(' location_type_code : '||l_inst_tbl(l_ind).location_type_code);
757: debug(' location_id : '||l_inst_tbl(l_ind).location_id);
758: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
759: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');

Line 762: RAISE fnd_api.g_exc_error;

758: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
759: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
760: fnd_message.set_token('CSI_TRANSACTION_ID',l_inst_tbl(l_ind).csi_txn_id);
761: l_error_message := fnd_message.get;
762: RAISE fnd_api.g_exc_error;
763: END IF;
764:
765: -- get deprn expense ccid
766: l_deprn_expense_ccid :=

Line 772: IF l_return_status <> fnd_api.g_ret_sts_success THEN

768: p_asset_attrib_rec => l_asset_attrib_rec,
769: x_error_msg => l_error_message,
770: x_return_status => l_return_status);
771:
772: IF l_return_status <> fnd_api.g_ret_sts_success THEN
773: RAISE fnd_api.g_exc_error;
774: END IF;
775:
776: -- payables ccid

Line 773: RAISE fnd_api.g_exc_error;

769: x_error_msg => l_error_message,
770: x_return_status => l_return_status);
771:
772: IF l_return_status <> fnd_api.g_ret_sts_success THEN
773: RAISE fnd_api.g_exc_error;
774: END IF;
775:
776: -- payables ccid
777: l_payables_ccid :=

Line 783: IF l_return_status <> fnd_api.g_ret_sts_success THEN

779: p_asset_attrib_rec => l_asset_attrib_rec,
780: x_error_msg => l_error_message,
781: x_return_status => l_return_status);
782:
783: IF l_return_status <> fnd_api.g_ret_sts_success THEN
784: --l_payables_ccid := l_inst_tbl(l_ind).mtl_dist_acct_id;
785: RAISE fnd_api.g_exc_error;
786: END IF;
787:

Line 785: RAISE fnd_api.g_exc_error;

781: x_return_status => l_return_status);
782:
783: IF l_return_status <> fnd_api.g_ret_sts_success THEN
784: --l_payables_ccid := l_inst_tbl(l_ind).mtl_dist_acct_id;
785: RAISE fnd_api.g_exc_error;
786: END IF;
787:
788: -- tag number
789: l_tag_number :=

Line 795: IF l_return_status <> fnd_api.g_ret_sts_success THEN

791: p_asset_attrib_rec => l_asset_attrib_rec,
792: x_error_msg => l_error_message,
793: x_return_status => l_return_status);
794:
795: IF l_return_status <> fnd_api.g_ret_sts_success THEN
796: RAISE fnd_api.g_exc_error;
797: END IF;
798:
799:

Line 796: RAISE fnd_api.g_exc_error;

792: x_error_msg => l_error_message,
793: x_return_status => l_return_status);
794:
795: IF l_return_status <> fnd_api.g_ret_sts_success THEN
796: RAISE fnd_api.g_exc_error;
797: END IF;
798:
799:
800: -- manufacturer

Line 807: IF l_return_status <> fnd_api.g_ret_sts_success THEN

803: p_asset_attrib_rec => l_asset_attrib_rec,
804: x_error_msg => l_error_message,
805: x_return_status => l_return_status);
806:
807: IF l_return_status <> fnd_api.g_ret_sts_success THEN
808: RAISE fnd_api.g_exc_error;
809: END IF;
810:
811: -- employee

Line 808: RAISE fnd_api.g_exc_error;

804: x_error_msg => l_error_message,
805: x_return_status => l_return_status);
806:
807: IF l_return_status <> fnd_api.g_ret_sts_success THEN
808: RAISE fnd_api.g_exc_error;
809: END IF;
810:
811: -- employee
812: l_employee_id :=

Line 818: IF l_return_status <> fnd_api.g_ret_sts_success THEN

814: p_asset_attrib_rec => l_asset_attrib_rec,
815: x_error_msg => l_error_message,
816: x_return_status => l_return_status);
817:
818: IF l_return_status <> fnd_api.g_ret_sts_success THEN
819: RAISE fnd_api.g_exc_error;
820: END IF;
821:
822: -- search method

Line 819: RAISE fnd_api.g_exc_error;

815: x_error_msg => l_error_message,
816: x_return_status => l_return_status);
817:
818: IF l_return_status <> fnd_api.g_ret_sts_success THEN
819: RAISE fnd_api.g_exc_error;
820: END IF;
821:
822: -- search method
823: l_search_method :=

Line 829: IF l_return_status <> fnd_api.g_ret_sts_success THEN

825: p_asset_attrib_rec => l_asset_attrib_rec,
826: x_error_msg => l_error_message,
827: x_return_status => l_return_status);
828:
829: IF l_return_status <> fnd_api.g_ret_sts_success THEN
830: RAISE fnd_api.g_exc_error;
831: END IF;
832:
833: END IF; -- first record only

Line 830: RAISE fnd_api.g_exc_error;

826: x_error_msg => l_error_message,
827: x_return_status => l_return_status);
828:
829: IF l_return_status <> fnd_api.g_ret_sts_success THEN
830: RAISE fnd_api.g_exc_error;
831: END IF;
832:
833: END IF; -- first record only
834:

Line 843: IF l_return_status <> fnd_api.g_ret_sts_success THEN

839: p_asset_attrib_rec => l_asset_attrib_rec,
840: x_error_msg => l_error_message,
841: x_return_status => l_return_status);
842:
843: IF l_return_status <> fnd_api.g_ret_sts_success THEN
844: RAISE fnd_api.g_exc_error;
845: END IF;
846: --Changes for bug#13859344
847:

Line 844: RAISE fnd_api.g_exc_error;

840: x_error_msg => l_error_message,
841: x_return_status => l_return_status);
842:
843: IF l_return_status <> fnd_api.g_ret_sts_success THEN
844: RAISE fnd_api.g_exc_error;
845: END IF;
846: --Changes for bug#13859344
847:
848: l_asset_cost := NVL(l_inst_tbl(l_ind).quantity,0) * NVL(l_asset_unit_cost,0);

Line 859: IF l_return_status <> fnd_api.g_ret_sts_success THEN

855: p_book_type_code => l_book_type_code,
856: x_base_amount => l_base_amount,
857: x_return_status => l_return_status,
858: x_error_msg => l_error_message);
859: IF l_return_status <> fnd_api.g_ret_sts_success THEN
860: RAISE fnd_api.g_exc_error;
861: END IF;
862: l_asset_cost := l_base_amount;
863: --Added for bug 12972937 to convert the unit cost to currency defined in FA

Line 860: RAISE fnd_api.g_exc_error;

856: x_base_amount => l_base_amount,
857: x_return_status => l_return_status,
858: x_error_msg => l_error_message);
859: IF l_return_status <> fnd_api.g_ret_sts_success THEN
860: RAISE fnd_api.g_exc_error;
861: END IF;
862: l_asset_cost := l_base_amount;
863: --Added for bug 12972937 to convert the unit cost to currency defined in FA
864: l_derived_asset_unit_cost := l_base_amount/NVL(l_inst_tbl(l_ind).quantity,1);

Line 916: WHEN fnd_api.g_exc_error THEN

912: END IF;
913: px_instance_tbl := l_inst_tbl;
914:
915: EXCEPTION
916: WHEN fnd_api.g_exc_error THEN
917: x_return_status := fnd_api.g_ret_sts_error;
918: x_error_message := l_error_message;
919: END derive_asset_attribs;
920:

Line 917: x_return_status := fnd_api.g_ret_sts_error;

913: px_instance_tbl := l_inst_tbl;
914:
915: EXCEPTION
916: WHEN fnd_api.g_exc_error THEN
917: x_return_status := fnd_api.g_ret_sts_error;
918: x_error_message := l_error_message;
919: END derive_asset_attribs;
920:
921: PROCEDURE get_fixed_assets(

Line 948: x_return_status := fnd_api.g_ret_sts_success;

944: l_asset_rec fixed_asset_rec;
945:
946: BEGIN
947:
948: x_return_status := fnd_api.g_ret_sts_success;
949:
950: IF p_fa_query_rec.book_type_code is not null THEN
951: l_and_clause := 'AND fb.book_type_code = :book_type_code ';
952: END IF;

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

1089: IS
1090: l_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
1091: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1092:
1093: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1094: l_msg_count number;
1095: l_msg_data varchar2(2000);
1096:
1097: BEGIN

Line 1099: x_return_status := fnd_api.g_ret_sts_success;

1095: l_msg_data varchar2(2000);
1096:
1097: BEGIN
1098:
1099: x_return_status := fnd_api.g_ret_sts_success;
1100:
1101: l_inst_asset_query_rec.instance_id := p_instance_id;
1102: l_inst_asset_query_rec.fa_asset_id := p_asset_id;
1103:

Line 1108: p_commit => fnd_api.g_false,

1104: debug('inside api csi_asset_pvt.get_instance_assets');
1105:
1106: csi_asset_pvt.get_instance_assets(
1107: p_api_version => 1.0,
1108: p_commit => fnd_api.g_false,
1109: p_init_msg_list => fnd_api.g_true,
1110: p_validation_level => fnd_api.g_valid_level_full,
1111: p_instance_asset_query_rec => l_inst_asset_query_rec,
1112: p_resolve_id_columns => fnd_api.g_true,

Line 1109: p_init_msg_list => fnd_api.g_true,

1105:
1106: csi_asset_pvt.get_instance_assets(
1107: p_api_version => 1.0,
1108: p_commit => fnd_api.g_false,
1109: p_init_msg_list => fnd_api.g_true,
1110: p_validation_level => fnd_api.g_valid_level_full,
1111: p_instance_asset_query_rec => l_inst_asset_query_rec,
1112: p_resolve_id_columns => fnd_api.g_true,
1113: p_time_stamp => to_date(null),

Line 1110: p_validation_level => fnd_api.g_valid_level_full,

1106: csi_asset_pvt.get_instance_assets(
1107: p_api_version => 1.0,
1108: p_commit => fnd_api.g_false,
1109: p_init_msg_list => fnd_api.g_true,
1110: p_validation_level => fnd_api.g_valid_level_full,
1111: p_instance_asset_query_rec => l_inst_asset_query_rec,
1112: p_resolve_id_columns => fnd_api.g_true,
1113: p_time_stamp => to_date(null),
1114: x_instance_asset_tbl => l_inst_asset_tbl,

Line 1112: p_resolve_id_columns => fnd_api.g_true,

1108: p_commit => fnd_api.g_false,
1109: p_init_msg_list => fnd_api.g_true,
1110: p_validation_level => fnd_api.g_valid_level_full,
1111: p_instance_asset_query_rec => l_inst_asset_query_rec,
1112: p_resolve_id_columns => fnd_api.g_true,
1113: p_time_stamp => to_date(null),
1114: x_instance_asset_tbl => l_inst_asset_tbl,
1115: x_return_status => l_return_status,
1116: x_msg_count => l_msg_count,

Line 1119: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1115: x_return_status => l_return_status,
1116: x_msg_count => l_msg_count,
1117: x_msg_data => l_msg_data);
1118:
1119: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1120: RAISE fnd_api.g_exc_error;
1121: END IF;
1122:
1123: IF l_inst_asset_tbl.COUNT > 0 THEN

Line 1120: RAISE fnd_api.g_exc_error;

1116: x_msg_count => l_msg_count,
1117: x_msg_data => l_msg_data);
1118:
1119: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1120: RAISE fnd_api.g_exc_error;
1121: END IF;
1122:
1123: IF l_inst_asset_tbl.COUNT > 0 THEN
1124: FOR l_ind IN l_inst_asset_tbl.FIRST .. l_inst_asset_tbl.LAST

Line 1152: WHEN fnd_api.g_exc_error THEN

1148: END LOOP;
1149: END IF;
1150:
1151: EXCEPTION
1152: WHEN fnd_api.g_exc_error THEN
1153: x_return_status := fnd_api.g_ret_sts_success;
1154: END get_instance_asset;
1155:
1156:

Line 1153: x_return_status := fnd_api.g_ret_sts_success;

1149: END IF;
1150:
1151: EXCEPTION
1152: WHEN fnd_api.g_exc_error THEN
1153: x_return_status := fnd_api.g_ret_sts_success;
1154: END get_instance_asset;
1155:
1156:
1157: PROCEDURE get_pending_additions(

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

1357: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1358: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1359: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1360:
1361: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1362: l_msg_count number;
1363: l_msg_data varchar2(2000);
1364: l_error_message varchar2(2000);
1365: BEGIN

Line 1367: x_return_status := fnd_api.g_ret_sts_success;

1363: l_msg_data varchar2(2000);
1364: l_error_message varchar2(2000);
1365: BEGIN
1366:
1367: x_return_status := fnd_api.g_ret_sts_success;
1368:
1369: debug('inside api amend_instance_asset');
1370:
1371: IF p_action = 'ADD_TO_ASSET' THEN

Line 1376: l_asset_id := fnd_api.g_miss_num;

1372:
1373: IF p_inst_rec.fa_group_by = 'ITEM' THEN
1374: l_asset_id := p_asset_id;
1375: ELSE
1376: l_asset_id := fnd_api.g_miss_num;
1377: END IF;
1378:
1379: get_instance_asset(
1380: p_instance_id => p_inst_rec.instance_id,

Line 1386: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1382: x_inst_asset_rec => l_inst_asset_rec,
1383: x_return_status => l_return_status,
1384: x_error_message => l_error_message);
1385:
1386: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1387: RAISE fnd_api.g_exc_error;
1388: END IF;
1389:
1390: IF nvl(l_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

Line 1387: RAISE fnd_api.g_exc_error;

1383: x_return_status => l_return_status,
1384: x_error_message => l_error_message);
1385:
1386: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1387: RAISE fnd_api.g_exc_error;
1388: END IF;
1389:
1390: IF nvl(l_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1391:

Line 1390: IF nvl(l_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

1386: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1387: RAISE fnd_api.g_exc_error;
1388: END IF;
1389:
1390: IF nvl(l_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1391:
1392: IF p_inst_rec.fa_group_by = 'ITEM' THEN
1393:
1394: SELECT asset_quantity + p_inst_rec.quantity,

Line 1407: p_commit => fnd_api.g_false,

1403: l_inst_asset_rec.fa_sync_flag := 'Y';
1404:
1405: csi_asset_pvt.update_instance_asset(
1406: p_api_version => 1.0,
1407: p_commit => fnd_api.g_false,
1408: p_init_msg_list => fnd_api.g_true,
1409: p_validation_level => fnd_api.g_valid_level_full,
1410: p_instance_asset_rec => l_inst_asset_rec,
1411: p_txn_rec => px_csi_txn_rec,

Line 1408: p_init_msg_list => fnd_api.g_true,

1404:
1405: csi_asset_pvt.update_instance_asset(
1406: p_api_version => 1.0,
1407: p_commit => fnd_api.g_false,
1408: p_init_msg_list => fnd_api.g_true,
1409: p_validation_level => fnd_api.g_valid_level_full,
1410: p_instance_asset_rec => l_inst_asset_rec,
1411: p_txn_rec => px_csi_txn_rec,
1412: x_return_status => l_return_status,

Line 1409: p_validation_level => fnd_api.g_valid_level_full,

1405: csi_asset_pvt.update_instance_asset(
1406: p_api_version => 1.0,
1407: p_commit => fnd_api.g_false,
1408: p_init_msg_list => fnd_api.g_true,
1409: p_validation_level => fnd_api.g_valid_level_full,
1410: p_instance_asset_rec => l_inst_asset_rec,
1411: p_txn_rec => px_csi_txn_rec,
1412: x_return_status => l_return_status,
1413: x_msg_count => l_msg_count,

Line 1420: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1416: p_asset_count_rec => l_asset_count_rec,
1417: p_asset_id_tbl => l_asset_id_tbl,
1418: p_asset_loc_tbl => l_asset_loc_tbl);
1419:
1420: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1421: RAISE fnd_api.g_exc_error;
1422: END IF;
1423:
1424: debug('instance asset rec updated. instance_asset_id : '||l_inst_asset_rec.instance_asset_id);

Line 1421: RAISE fnd_api.g_exc_error;

1417: p_asset_id_tbl => l_asset_id_tbl,
1418: p_asset_loc_tbl => l_asset_loc_tbl);
1419:
1420: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1421: RAISE fnd_api.g_exc_error;
1422: END IF;
1423:
1424: debug('instance asset rec updated. instance_asset_id : '||l_inst_asset_rec.instance_asset_id);
1425:

Line 1435: l_inst_asset_rec.instance_asset_id := fnd_api.g_miss_num;

1431: END IF;
1432:
1433: ELSE
1434:
1435: l_inst_asset_rec.instance_asset_id := fnd_api.g_miss_num;
1436: l_inst_asset_rec.instance_id := p_inst_rec.instance_id;
1437: l_inst_asset_rec.fa_book_type_code := p_inst_rec.book_type_code;
1438: l_inst_asset_rec.fa_asset_id := p_asset_id;
1439: l_inst_asset_rec.fa_location_id := p_inst_rec.asset_location_id;

Line 1447: p_commit => fnd_api.g_false,

1443: l_inst_asset_rec.fa_sync_flag := 'Y';
1444:
1445: csi_asset_pvt.create_instance_asset(
1446: p_api_version => 1.0,
1447: p_commit => fnd_api.g_false,
1448: p_init_msg_list => fnd_api.g_true,
1449: p_validation_level => fnd_api.g_valid_level_full,
1450: p_instance_asset_rec => l_inst_asset_rec,
1451: p_txn_rec => px_csi_txn_rec,

Line 1448: p_init_msg_list => fnd_api.g_true,

1444:
1445: csi_asset_pvt.create_instance_asset(
1446: p_api_version => 1.0,
1447: p_commit => fnd_api.g_false,
1448: p_init_msg_list => fnd_api.g_true,
1449: p_validation_level => fnd_api.g_valid_level_full,
1450: p_instance_asset_rec => l_inst_asset_rec,
1451: p_txn_rec => px_csi_txn_rec,
1452: x_return_status => l_return_status,

Line 1449: p_validation_level => fnd_api.g_valid_level_full,

1445: csi_asset_pvt.create_instance_asset(
1446: p_api_version => 1.0,
1447: p_commit => fnd_api.g_false,
1448: p_init_msg_list => fnd_api.g_true,
1449: p_validation_level => fnd_api.g_valid_level_full,
1450: p_instance_asset_rec => l_inst_asset_rec,
1451: p_txn_rec => px_csi_txn_rec,
1452: x_return_status => l_return_status,
1453: x_msg_count => l_msg_count,

Line 1460: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1456: p_asset_count_rec => l_asset_count_rec,
1457: p_asset_id_tbl => l_asset_id_tbl,
1458: p_asset_loc_tbl => l_asset_loc_tbl);
1459:
1460: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1461: RAISE fnd_api.g_exc_error;
1462: END IF;
1463:
1464: debug('instance asset rec created. instance_asset_id : '||l_inst_asset_rec.instance_asset_id);

Line 1461: RAISE fnd_api.g_exc_error;

1457: p_asset_id_tbl => l_asset_id_tbl,
1458: p_asset_loc_tbl => l_asset_loc_tbl);
1459:
1460: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1461: RAISE fnd_api.g_exc_error;
1462: END IF;
1463:
1464: debug('instance asset rec created. instance_asset_id : '||l_inst_asset_rec.instance_asset_id);
1465:

Line 1476: l_inst_asset_rec.check_for_instance_expiry := fnd_api.g_false;

1472: l_inst_asset_rec.fa_location_id := p_inst_rec.asset_location_id;
1473: l_inst_asset_rec.asset_quantity := p_inst_rec.quantity;
1474: l_inst_asset_rec.fa_mass_addition_id := p_mass_addition_id;
1475: l_inst_asset_rec.fa_sync_flag := 'N';
1476: l_inst_asset_rec.check_for_instance_expiry := fnd_api.g_false;
1477:
1478: csi_asset_pvt.create_instance_asset(
1479: p_api_version => 1.0,
1480: p_commit => fnd_api.g_false,

Line 1480: p_commit => fnd_api.g_false,

1476: l_inst_asset_rec.check_for_instance_expiry := fnd_api.g_false;
1477:
1478: csi_asset_pvt.create_instance_asset(
1479: p_api_version => 1.0,
1480: p_commit => fnd_api.g_false,
1481: p_init_msg_list => fnd_api.g_true,
1482: p_validation_level => fnd_api.g_valid_level_full,
1483: p_instance_asset_rec => l_inst_asset_rec,
1484: p_txn_rec => px_csi_txn_rec,

Line 1481: p_init_msg_list => fnd_api.g_true,

1477:
1478: csi_asset_pvt.create_instance_asset(
1479: p_api_version => 1.0,
1480: p_commit => fnd_api.g_false,
1481: p_init_msg_list => fnd_api.g_true,
1482: p_validation_level => fnd_api.g_valid_level_full,
1483: p_instance_asset_rec => l_inst_asset_rec,
1484: p_txn_rec => px_csi_txn_rec,
1485: x_return_status => l_return_status,

Line 1482: p_validation_level => fnd_api.g_valid_level_full,

1478: csi_asset_pvt.create_instance_asset(
1479: p_api_version => 1.0,
1480: p_commit => fnd_api.g_false,
1481: p_init_msg_list => fnd_api.g_true,
1482: p_validation_level => fnd_api.g_valid_level_full,
1483: p_instance_asset_rec => l_inst_asset_rec,
1484: p_txn_rec => px_csi_txn_rec,
1485: x_return_status => l_return_status,
1486: x_msg_count => l_msg_count,

Line 1493: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1489: p_asset_count_rec => l_asset_count_rec,
1490: p_asset_id_tbl => l_asset_id_tbl,
1491: p_asset_loc_tbl => l_asset_loc_tbl);
1492:
1493: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1494: RAISE fnd_api.g_exc_error;
1495: END IF;
1496:
1497: debug('instance asset rec created. instance_asset_id : '||l_inst_asset_rec.instance_asset_id);

Line 1494: RAISE fnd_api.g_exc_error;

1490: p_asset_id_tbl => l_asset_id_tbl,
1491: p_asset_loc_tbl => l_asset_loc_tbl);
1492:
1493: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1494: RAISE fnd_api.g_exc_error;
1495: END IF;
1496:
1497: debug('instance asset rec created. instance_asset_id : '||l_inst_asset_rec.instance_asset_id);
1498: x_inst_asset_rec := l_inst_asset_rec;

Line 1504: p_asset_id => fnd_api.g_miss_num,

1500: ELSIF p_action = 'ADD_TO_MASS_ADDITION' THEN
1501:
1502: get_instance_asset(
1503: p_instance_id => p_inst_rec.instance_id,
1504: p_asset_id => fnd_api.g_miss_num,
1505: x_inst_asset_rec => l_inst_asset_rec,
1506: x_return_status => l_return_status,
1507: x_error_message => l_error_message);
1508:

Line 1509: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1505: x_inst_asset_rec => l_inst_asset_rec,
1506: x_return_status => l_return_status,
1507: x_error_message => l_error_message);
1508:
1509: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1510: RAISE fnd_api.g_exc_error;
1511: END IF;
1512:
1513: IF nvl(l_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

Line 1510: RAISE fnd_api.g_exc_error;

1506: x_return_status => l_return_status,
1507: x_error_message => l_error_message);
1508:
1509: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1510: RAISE fnd_api.g_exc_error;
1511: END IF;
1512:
1513: IF nvl(l_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1514:

Line 1513: IF nvl(l_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

1509: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1510: RAISE fnd_api.g_exc_error;
1511: END IF;
1512:
1513: IF nvl(l_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1514:
1515: IF p_inst_rec.fa_group_by = 'ITEM' THEN
1516:
1517: SELECT asset_quantity + p_inst_rec.quantity,

Line 1530: p_commit => fnd_api.g_false,

1526: l_inst_asset_rec.fa_sync_flag := 'N';
1527:
1528: csi_asset_pvt.update_instance_asset(
1529: p_api_version => 1.0,
1530: p_commit => fnd_api.g_false,
1531: p_init_msg_list => fnd_api.g_true,
1532: p_validation_level => fnd_api.g_valid_level_full,
1533: p_instance_asset_rec => l_inst_asset_rec,
1534: p_txn_rec => px_csi_txn_rec,

Line 1531: p_init_msg_list => fnd_api.g_true,

1527:
1528: csi_asset_pvt.update_instance_asset(
1529: p_api_version => 1.0,
1530: p_commit => fnd_api.g_false,
1531: p_init_msg_list => fnd_api.g_true,
1532: p_validation_level => fnd_api.g_valid_level_full,
1533: p_instance_asset_rec => l_inst_asset_rec,
1534: p_txn_rec => px_csi_txn_rec,
1535: x_return_status => l_return_status,

Line 1532: p_validation_level => fnd_api.g_valid_level_full,

1528: csi_asset_pvt.update_instance_asset(
1529: p_api_version => 1.0,
1530: p_commit => fnd_api.g_false,
1531: p_init_msg_list => fnd_api.g_true,
1532: p_validation_level => fnd_api.g_valid_level_full,
1533: p_instance_asset_rec => l_inst_asset_rec,
1534: p_txn_rec => px_csi_txn_rec,
1535: x_return_status => l_return_status,
1536: x_msg_count => l_msg_count,

Line 1543: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1539: p_asset_count_rec => l_asset_count_rec,
1540: p_asset_id_tbl => l_asset_id_tbl,
1541: p_asset_loc_tbl => l_asset_loc_tbl);
1542:
1543: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1544: RAISE fnd_api.g_exc_error;
1545: END IF;
1546:
1547: debug('instance asset rec updated. instance_asset_id : '||l_inst_asset_rec.instance_asset_id);

Line 1544: RAISE fnd_api.g_exc_error;

1540: p_asset_id_tbl => l_asset_id_tbl,
1541: p_asset_loc_tbl => l_asset_loc_tbl);
1542:
1543: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1544: RAISE fnd_api.g_exc_error;
1545: END IF;
1546:
1547: debug('instance asset rec updated. instance_asset_id : '||l_inst_asset_rec.instance_asset_id);
1548: END IF;

Line 1552: l_inst_asset_rec.instance_asset_id := fnd_api.g_miss_num;

1548: END IF;
1549:
1550: ELSE
1551:
1552: l_inst_asset_rec.instance_asset_id := fnd_api.g_miss_num;
1553: l_inst_asset_rec.instance_id := p_inst_rec.instance_id;
1554: l_inst_asset_rec.fa_book_type_code := p_inst_rec.book_type_code;
1555: l_inst_asset_rec.fa_location_id := p_inst_rec.asset_location_id;
1556: l_inst_asset_rec.asset_quantity := p_inst_rec.quantity;

Line 1563: p_commit => fnd_api.g_false,

1559: l_inst_asset_rec.fa_sync_flag := 'N';
1560:
1561: csi_asset_pvt.create_instance_asset(
1562: p_api_version => 1.0,
1563: p_commit => fnd_api.g_false,
1564: p_init_msg_list => fnd_api.g_true,
1565: p_validation_level => fnd_api.g_valid_level_full,
1566: p_instance_asset_rec => l_inst_asset_rec,
1567: p_txn_rec => px_csi_txn_rec,

Line 1564: p_init_msg_list => fnd_api.g_true,

1560:
1561: csi_asset_pvt.create_instance_asset(
1562: p_api_version => 1.0,
1563: p_commit => fnd_api.g_false,
1564: p_init_msg_list => fnd_api.g_true,
1565: p_validation_level => fnd_api.g_valid_level_full,
1566: p_instance_asset_rec => l_inst_asset_rec,
1567: p_txn_rec => px_csi_txn_rec,
1568: x_return_status => l_return_status,

Line 1565: p_validation_level => fnd_api.g_valid_level_full,

1561: csi_asset_pvt.create_instance_asset(
1562: p_api_version => 1.0,
1563: p_commit => fnd_api.g_false,
1564: p_init_msg_list => fnd_api.g_true,
1565: p_validation_level => fnd_api.g_valid_level_full,
1566: p_instance_asset_rec => l_inst_asset_rec,
1567: p_txn_rec => px_csi_txn_rec,
1568: x_return_status => l_return_status,
1569: x_msg_count => l_msg_count,

Line 1576: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1572: p_asset_count_rec => l_asset_count_rec,
1573: p_asset_id_tbl => l_asset_id_tbl,
1574: p_asset_loc_tbl => l_asset_loc_tbl);
1575:
1576: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1577: RAISE fnd_api.g_exc_error;
1578: END IF;
1579:
1580: debug('instance asset rec created. instance_asset_id : '||l_inst_asset_rec.instance_asset_id);

Line 1577: RAISE fnd_api.g_exc_error;

1573: p_asset_id_tbl => l_asset_id_tbl,
1574: p_asset_loc_tbl => l_asset_loc_tbl);
1575:
1576: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1577: RAISE fnd_api.g_exc_error;
1578: END IF;
1579:
1580: debug('instance asset rec created. instance_asset_id : '||l_inst_asset_rec.instance_asset_id);
1581:

Line 1587: WHEN fnd_api.g_exc_error THEN

1583:
1584: END IF;
1585:
1586: EXCEPTION
1587: WHEN fnd_api.g_exc_error THEN
1588: x_return_status := fnd_api.g_ret_sts_error;
1589: END amend_instance_asset;
1590:
1591: PROCEDURE create_mass_addition(

Line 1588: x_return_status := fnd_api.g_ret_sts_error;

1584: END IF;
1585:
1586: EXCEPTION
1587: WHEN fnd_api.g_exc_error THEN
1588: x_return_status := fnd_api.g_ret_sts_error;
1589: END amend_instance_asset;
1590:
1591: PROCEDURE create_mass_addition(
1592: p_instance_rec IN instance_rec,

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

1602:
1603: l_p_mass_add_rec fa_mass_additions%rowtype;
1604: l_c_mass_add_rec fa_mass_additions%rowtype;
1605:
1606: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1607: l_msg_count number;
1608: l_msg_data varchar2(2000);
1609:
1610: -- ER 13083427

Line 1618: x_return_status := fnd_api.g_ret_sts_success;

1614: x_error_msg VARCHAR2(2000);
1615:
1616: BEGIN
1617:
1618: x_return_status := fnd_api.g_ret_sts_success;
1619:
1620: debug('inside api create_mass_addition');
1621: savepoint create_mass_addition;
1622:

Line 1626: -- If the aset type is CIP, then date placed in service must be FND_API.G_MISS_DATE

1622:
1623: debug('Calling Client extension get_asset_type_n_dpis');
1624: -- ER 13083427
1625: -- CSE Hook to get asset type and corresponding date placed in service
1626: -- If the aset type is CIP, then date placed in service must be FND_API.G_MISS_DATE
1627: -- If the asset type is from hook is NULL or CAPITALIZED, then below logic to assign
1628: -- date placed in service based on fa_group_by flag is followed
1629: -- Bug 13559230 Providing instance id in hook API
1630: CSE_ASSET_CLIENT_EXT_STUB.get_asset_type_n_dpis (

Line 1707: p_commit => fnd_api.g_false,

1703: l_p_mass_add_rec.payables_cost := 0;
1704:
1705: cse_asset_util_pkg.insert_mass_add(
1706: p_api_version => 1.0,
1707: p_commit => fnd_api.g_false,
1708: p_init_msg_list => fnd_api.g_true,
1709: p_mass_add_rec => l_p_mass_add_rec,
1710: x_return_status => l_return_status,
1711: x_msg_count => l_msg_count,

Line 1708: p_init_msg_list => fnd_api.g_true,

1704:
1705: cse_asset_util_pkg.insert_mass_add(
1706: p_api_version => 1.0,
1707: p_commit => fnd_api.g_false,
1708: p_init_msg_list => fnd_api.g_true,
1709: p_mass_add_rec => l_p_mass_add_rec,
1710: x_return_status => l_return_status,
1711: x_msg_count => l_msg_count,
1712: x_msg_data => l_msg_data);

Line 1714: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1710: x_return_status => l_return_status,
1711: x_msg_count => l_msg_count,
1712: x_msg_data => l_msg_data);
1713:
1714: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1715: RAISE fnd_api.g_exc_error;
1716: END IF;
1717:
1718: debug('mass_addition rec created. parent_mass_addition_id : '||l_p_mass_add_rec.mass_addition_id);

Line 1715: RAISE fnd_api.g_exc_error;

1711: x_msg_count => l_msg_count,
1712: x_msg_data => l_msg_data);
1713:
1714: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1715: RAISE fnd_api.g_exc_error;
1716: END IF;
1717:
1718: debug('mass_addition rec created. parent_mass_addition_id : '||l_p_mass_add_rec.mass_addition_id);
1719:

Line 1736: p_commit => fnd_api.g_false,

1732: NVL(l_p_mass_add_rec.payables_units,0);
1733:
1734: cse_asset_util_pkg.insert_mass_add(
1735: p_api_version => 1.0,
1736: p_commit => fnd_api.g_false,
1737: p_init_msg_list => fnd_api.g_true,
1738: p_mass_add_rec => l_c_mass_add_rec,
1739: x_return_status => l_return_status,
1740: x_msg_count => l_msg_count,

Line 1737: p_init_msg_list => fnd_api.g_true,

1733:
1734: cse_asset_util_pkg.insert_mass_add(
1735: p_api_version => 1.0,
1736: p_commit => fnd_api.g_false,
1737: p_init_msg_list => fnd_api.g_true,
1738: p_mass_add_rec => l_c_mass_add_rec,
1739: x_return_status => l_return_status,
1740: x_msg_count => l_msg_count,
1741: x_msg_data => l_msg_data);

Line 1743: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1739: x_return_status => l_return_status,
1740: x_msg_count => l_msg_count,
1741: x_msg_data => l_msg_data);
1742:
1743: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1744: RAISE fnd_api.g_exc_error;
1745: END IF;
1746:
1747: x_mass_addition_id := l_p_mass_add_rec.mass_addition_id;

Line 1744: RAISE fnd_api.g_exc_error;

1740: x_msg_count => l_msg_count,
1741: x_msg_data => l_msg_data);
1742:
1743: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1744: RAISE fnd_api.g_exc_error;
1745: END IF;
1746:
1747: x_mass_addition_id := l_p_mass_add_rec.mass_addition_id;
1748:

Line 1750: WHEN fnd_api.g_exc_error THEN

1746:
1747: x_mass_addition_id := l_p_mass_add_rec.mass_addition_id;
1748:
1749: EXCEPTION
1750: WHEN fnd_api.g_exc_error THEN
1751: rollback to create_mass_addition;
1752: x_return_status := fnd_api.g_ret_sts_error;
1753: x_error_message := cse_util_pkg.dump_error_stack;
1754: END create_mass_addition;

Line 1752: x_return_status := fnd_api.g_ret_sts_error;

1748:
1749: EXCEPTION
1750: WHEN fnd_api.g_exc_error THEN
1751: rollback to create_mass_addition;
1752: x_return_status := fnd_api.g_ret_sts_error;
1753: x_error_message := cse_util_pkg.dump_error_stack;
1754: END create_mass_addition;
1755:
1756: PROCEDURE add_to_mass_addition(

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

1767:
1768: l_asset_quantity number;
1769: l_obj_ver_num number;
1770:
1771: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1772: l_msg_count number;
1773: l_msg_data varchar2(2000);
1774: l_error_message varchar2(2000);
1775:

Line 1788: -- If the aset type is CIP, then date placed in service must be FND_API.G_MISS_DATE

1784: debug('inside api add_to_mass_addition');
1785: debug('Calling Client extension get_asset_type_n_dpis');
1786: -- ER 13083427
1787: -- CSE Hook to get asset type and corresponding date placed in service
1788: -- If the aset type is CIP, then date placed in service must be FND_API.G_MISS_DATE
1789: -- If the asset type is from hook is NULL or CAPITALIZED, then below logic to assign
1790: -- date placed in service based on fa_group_by flag is followed
1791: -- Bug 13559230 Providing instance id in hook API
1792: CSE_ASSET_CLIENT_EXT_STUB.get_asset_type_n_dpis (

Line 1844: IF NVL(x_asset_type_hook_used, FND_API.G_MISS_NUM) = 1 THEN

1840: -- ER 13083427
1841: -- Checking if asset type and date placed in service hook is used
1842: -- If x_asset_type_hook_used is 1, then override l_p_mass_add_rec.date_placed_in_service
1843: -- and l_p_mass_add_rec.asset_type
1844: IF NVL(x_asset_type_hook_used, FND_API.G_MISS_NUM) = 1 THEN
1845: l_c_mass_add_rec.date_placed_in_service := l_date_placed_inservice;
1846: l_c_mass_add_rec.asset_type := l_asset_type;
1847: END IF;
1848:

Line 1858: p_commit => fnd_api.g_false,

1854: l_c_mass_add_rec.merged_code := l_child_merge_code;
1855:
1856: cse_asset_util_pkg.insert_mass_add(
1857: p_api_version => 1.0,
1858: p_commit => fnd_api.g_false,
1859: p_init_msg_list => fnd_api.g_true,
1860: p_mass_add_rec => l_c_mass_add_rec,
1861: x_return_status => l_return_status,
1862: x_msg_count => l_msg_count,

Line 1859: p_init_msg_list => fnd_api.g_true,

1855:
1856: cse_asset_util_pkg.insert_mass_add(
1857: p_api_version => 1.0,
1858: p_commit => fnd_api.g_false,
1859: p_init_msg_list => fnd_api.g_true,
1860: p_mass_add_rec => l_c_mass_add_rec,
1861: x_return_status => l_return_status,
1862: x_msg_count => l_msg_count,
1863: x_msg_data => l_msg_data);

Line 1865: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1861: x_return_status => l_return_status,
1862: x_msg_count => l_msg_count,
1863: x_msg_data => l_msg_data);
1864:
1865: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1866: RAISE fnd_api.g_exc_error;
1867: END IF;
1868:
1869: -- when a child record is added the parent record does not get the cumulative quantity

Line 1866: RAISE fnd_api.g_exc_error;

1862: x_msg_count => l_msg_count,
1863: x_msg_data => l_msg_data);
1864:
1865: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1866: RAISE fnd_api.g_exc_error;
1867: END IF;
1868:
1869: -- when a child record is added the parent record does not get the cumulative quantity
1870: UPDATE fa_mass_additions

Line 1876: WHEN fnd_api.g_exc_error THEN

1872: fixed_assets_units = fixed_assets_units + NVL(l_c_mass_add_rec.fixed_assets_units,0)
1873: WHERE mass_addition_id = p_mass_addition_id;
1874:
1875: EXCEPTION
1876: WHEN fnd_api.g_exc_error THEN
1877: x_return_status := fnd_api.g_ret_sts_error;
1878: x_error_message := cse_util_pkg.dump_error_stack;
1879: END add_to_mass_addition;
1880:

Line 1877: x_return_status := fnd_api.g_ret_sts_error;

1873: WHERE mass_addition_id = p_mass_addition_id;
1874:
1875: EXCEPTION
1876: WHEN fnd_api.g_exc_error THEN
1877: x_return_status := fnd_api.g_ret_sts_error;
1878: x_error_message := cse_util_pkg.dump_error_stack;
1879: END add_to_mass_addition;
1880:
1881: PROCEDURE get_distribution_id(

Line 1903: x_return_status := fnd_api.g_ret_sts_success;

1899: l_distribution_id number := null;
1900:
1901: BEGIN
1902:
1903: x_return_status := fnd_api.g_ret_sts_success;
1904:
1905: FOR dist_rec IN dist_cur
1906: LOOP
1907: l_distribution_id := dist_rec.distribution_id;

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

1925: l_fa_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1926: l_fa_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1927:
1928: l_error_message varchar2(2000);
1929: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1930: l_msg_data varchar2(2000);
1931: l_msg_count number;
1932:
1933: BEGIN

Line 1935: x_return_status := fnd_api.g_ret_sts_success;

1931: l_msg_count number;
1932:
1933: BEGIN
1934:
1935: x_return_status := fnd_api.g_ret_sts_success;
1936:
1937: debug('calling get_distribution_id');
1938:
1939: get_distribution_id(

Line 1945: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1941: x_distribution_id => l_distribution_id,
1942: x_return_status => l_return_status,
1943: x_error_message => l_error_message);
1944:
1945: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1946: RAISE fnd_api.g_exc_error;
1947: END IF;
1948:
1949: fnd_msg_pub.initialize;

Line 1946: RAISE fnd_api.g_exc_error;

1942: x_return_status => l_return_status,
1943: x_error_message => l_error_message);
1944:
1945: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1946: RAISE fnd_api.g_exc_error;
1947: END IF;
1948:
1949: fnd_msg_pub.initialize;
1950:

Line 1975: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1971: x_return_status => l_return_status,
1972: x_msg_count => l_msg_count,
1973: x_msg_data => l_msg_data);
1974:
1975: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1976: l_error_message := cse_util_pkg.dump_error_stack;
1977: RAISE fnd_api.g_exc_error;
1978: END IF;
1979:

Line 1977: RAISE fnd_api.g_exc_error;

1973: x_msg_data => l_msg_data);
1974:
1975: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1976: l_error_message := cse_util_pkg.dump_error_stack;
1977: RAISE fnd_api.g_exc_error;
1978: END IF;
1979:
1980: EXCEPTION
1981: WHEN fnd_api.g_exc_error THEN

Line 1981: WHEN fnd_api.g_exc_error THEN

1977: RAISE fnd_api.g_exc_error;
1978: END IF;
1979:
1980: EXCEPTION
1981: WHEN fnd_api.g_exc_error THEN
1982: x_return_status := fnd_api.g_ret_sts_error;
1983: x_error_message := l_error_message;
1984: END create_distribution;
1985:

Line 1982: x_return_status := fnd_api.g_ret_sts_error;

1978: END IF;
1979:
1980: EXCEPTION
1981: WHEN fnd_api.g_exc_error THEN
1982: x_return_status := fnd_api.g_ret_sts_error;
1983: x_error_message := l_error_message;
1984: END create_distribution;
1985:
1986: PROCEDURE add_to_asset(

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

1995: l_asset_quantity number;
1996: l_obj_ver_num number;
1997:
1998: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
1999: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2000: l_error_message varchar2(2000);
2001:
2002: l_msg_count number;
2003: l_msg_data varchar2(2000);

Line 2019: -- If the aset type is CIP, then date placed in service must be FND_API.G_MISS_DATE

2015: debug('inside api add_to_asset');
2016: debug('Calling Client extension get_asset_type_n_dpis');
2017: -- ER 13083427
2018: -- CSE Hook to get asset type and corresponding date placed in service
2019: -- If the aset type is CIP, then date placed in service must be FND_API.G_MISS_DATE
2020: -- If the asset type is from hook is NULL or CAPITALIZED, then below logic to assign
2021: -- date placed in service based on fa_group_by flag is followed
2022: -- Bug 13559230 Providing instance id in hook API
2023: CSE_ASSET_CLIENT_EXT_STUB.get_asset_type_n_dpis (

Line 2073: p_asset_id => fnd_api.g_miss_num,

2069: l_mass_add_rec.fixed_assets_units := p_instance_rec.quantity;
2070:
2071: get_instance_asset(
2072: p_instance_id => p_instance_rec.instance_id,
2073: p_asset_id => fnd_api.g_miss_num,
2074: x_inst_asset_rec => l_inst_asset_rec,
2075: x_return_status => l_return_status,
2076: x_error_message => l_error_message);
2077:

Line 2078: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2074: x_inst_asset_rec => l_inst_asset_rec,
2075: x_return_status => l_return_status,
2076: x_error_message => l_error_message);
2077:
2078: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2079: RAISE fnd_api.g_exc_error;
2080: END IF;
2081:
2082: IF nvl(l_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

Line 2079: RAISE fnd_api.g_exc_error;

2075: x_return_status => l_return_status,
2076: x_error_message => l_error_message);
2077:
2078: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2079: RAISE fnd_api.g_exc_error;
2080: END IF;
2081:
2082: IF nvl(l_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
2083: debug('skipping the add to asset for serialized item instance that already has an asset link.');

Line 2082: IF nvl(l_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

2078: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2079: RAISE fnd_api.g_exc_error;
2080: END IF;
2081:
2082: IF nvl(l_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
2083: debug('skipping the add to asset for serialized item instance that already has an asset link.');
2084: RAISE skip_add_to_asset;
2085: END IF;
2086:

Line 2109: IF NVL(x_asset_type_hook_used, FND_API.G_MISS_NUM) = 1 THEN

2105: -- ER 13083427
2106: -- Checking if asset type and date placed in service hook is used
2107: -- If x_asset_type_hook_used is 1, then override l_p_mass_add_rec.date_placed_in_service
2108: -- and l_p_mass_add_rec.asset_type
2109: IF NVL(x_asset_type_hook_used, FND_API.G_MISS_NUM) = 1 THEN
2110: l_mass_add_rec.date_placed_in_service := l_date_placed_inservice;
2111: l_mass_add_rec.asset_type := l_asset_type;
2112: END IF;
2113:

Line 2116: p_commit => fnd_api.g_false,

2112: END IF;
2113:
2114: cse_asset_util_pkg.insert_mass_add(
2115: p_api_version => 1.0,
2116: p_commit => fnd_api.g_false,
2117: p_init_msg_list => fnd_api.g_true,
2118: p_mass_add_rec => l_mass_add_rec,
2119: x_return_status => l_return_status,
2120: x_msg_count => l_msg_count,

Line 2117: p_init_msg_list => fnd_api.g_true,

2113:
2114: cse_asset_util_pkg.insert_mass_add(
2115: p_api_version => 1.0,
2116: p_commit => fnd_api.g_false,
2117: p_init_msg_list => fnd_api.g_true,
2118: p_mass_add_rec => l_mass_add_rec,
2119: x_return_status => l_return_status,
2120: x_msg_count => l_msg_count,
2121: x_msg_data => l_msg_data);

Line 2123: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2119: x_return_status => l_return_status,
2120: x_msg_count => l_msg_count,
2121: x_msg_data => l_msg_data);
2122:
2123: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2124: RAISE fnd_api.g_exc_error;
2125: END IF;
2126:
2127: debug('fa_mass_addition rec created. parent_mass_addition_id : '||l_mass_add_rec.mass_addition_id);

Line 2124: RAISE fnd_api.g_exc_error;

2120: x_msg_count => l_msg_count,
2121: x_msg_data => l_msg_data);
2122:
2123: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2124: RAISE fnd_api.g_exc_error;
2125: END IF;
2126:
2127: debug('fa_mass_addition rec created. parent_mass_addition_id : '||l_mass_add_rec.mass_addition_id);
2128:

Line 2134: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2130: p_mass_add_rec => l_mass_add_rec,
2131: x_return_status => l_return_status,
2132: x_error_message => l_error_message);
2133:
2134: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2135: RAISE fnd_api.g_exc_error;
2136: END IF;
2137:
2138: EXCEPTION

Line 2135: RAISE fnd_api.g_exc_error;

2131: x_return_status => l_return_status,
2132: x_error_message => l_error_message);
2133:
2134: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2135: RAISE fnd_api.g_exc_error;
2136: END IF;
2137:
2138: EXCEPTION
2139: WHEN skip_add_to_asset THEN

Line 2141: WHEN fnd_api.g_exc_error THEN

2137:
2138: EXCEPTION
2139: WHEN skip_add_to_asset THEN
2140: null;
2141: WHEN fnd_api.g_exc_error THEN
2142: x_return_status := fnd_api.g_ret_sts_error;
2143: x_error_message := cse_util_pkg.dump_error_stack;
2144: END add_to_asset;
2145:

Line 2142: x_return_status := fnd_api.g_ret_sts_error;

2138: EXCEPTION
2139: WHEN skip_add_to_asset THEN
2140: null;
2141: WHEN fnd_api.g_exc_error THEN
2142: x_return_status := fnd_api.g_ret_sts_error;
2143: x_error_message := cse_util_pkg.dump_error_stack;
2144: END add_to_asset;
2145:
2146: PROCEDURE create_depreciable_assets(

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

2265:
2266: l_inst_tbl instance_tbl;
2267: inst_ind binary_integer := 0;
2268:
2269: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2270: l_error_message varchar2(2000);
2271: l_err_inst_rec instance_rec;
2272: --Added for ER#16265912
2273: l_ship_only VARCHAR2(1);

Line 2455: IF ( NVL(x_hook_used, FND_API.G_MISS_NUM) = 1 AND

2451: , x_error_msg => x_error_msg
2452: );
2453: debug('Asset Creation Hook flag : '||x_hook_used);
2454: debug('Asset Creation Skip flag : '||x_skip_flag);
2455: IF ( NVL(x_hook_used, FND_API.G_MISS_NUM) = 1 AND
2456: NVL(x_skip_flag, FND_API.G_MISS_CHAR) = 'Y') THEN
2457: -- Asset Creation programatically skipped in
2458: -- CSE_ASSET_CLIENT_EXT_STUB.skip_asset_creation
2459: RAISE SKIP_ASSET_CREATION;

Line 2456: NVL(x_skip_flag, FND_API.G_MISS_CHAR) = 'Y') THEN

2452: );
2453: debug('Asset Creation Hook flag : '||x_hook_used);
2454: debug('Asset Creation Skip flag : '||x_skip_flag);
2455: IF ( NVL(x_hook_used, FND_API.G_MISS_NUM) = 1 AND
2456: NVL(x_skip_flag, FND_API.G_MISS_CHAR) = 'Y') THEN
2457: -- Asset Creation programatically skipped in
2458: -- CSE_ASSET_CLIENT_EXT_STUB.skip_asset_creation
2459: RAISE SKIP_ASSET_CREATION;
2460: END IF;

Line 2608: RAISE fnd_api.g_exc_error;

2604: IF transaction_pending(csi_txn_rec.transaction_id, l_instance_id) THEN
2605: fnd_message.set_name('CSE', 'CSE_PRIOR_TXN_PENDING');
2606: fnd_msg_pub.add;
2607: l_error_message := cse_util_pkg.dump_error_stack;
2608: RAISE fnd_api.g_exc_error;
2609: END IF;
2610:
2611: IF l_redeploy_flag = 'N' THEN
2612:

Line 2697: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2693: px_instance_tbl => l_inst_tbl,
2694: x_return_status => l_return_status,
2695: x_error_message => l_error_message);
2696:
2697: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2698: l_err_inst_rec := l_inst_tbl(1);
2699: RAISE fnd_api.g_exc_error;
2700: END IF;
2701:

Line 2699: RAISE fnd_api.g_exc_error;

2695: x_error_message => l_error_message);
2696:
2697: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2698: l_err_inst_rec := l_inst_tbl(1);
2699: RAISE fnd_api.g_exc_error;
2700: END IF;
2701:
2702: dump_inst_tbl(p_inst_tbl => l_inst_tbl);
2703:

Line 2737: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2733: x_fixed_asset_rec => l_fixed_asset_rec,
2734: x_return_status => l_return_status,
2735: x_error_message => l_error_message);
2736:
2737: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2738: l_err_inst_rec := l_inst_tbl(l_ind);
2739: RAISE fnd_api.g_exc_error;
2740: END IF;
2741:

Line 2739: RAISE fnd_api.g_exc_error;

2735: x_error_message => l_error_message);
2736:
2737: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2738: l_err_inst_rec := l_inst_tbl(l_ind);
2739: RAISE fnd_api.g_exc_error;
2740: END IF;
2741:
2742: IF l_fixed_asset_rec.asset_id is not null THEN
2743:

Line 2754: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2750: p_instance_rec => l_inst_tbl(l_ind),
2751: x_return_status => l_return_status,
2752: x_error_message => l_error_message);
2753:
2754: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2755: l_err_inst_rec := l_inst_tbl(l_ind);
2756: RAISE fnd_api.g_exc_error;
2757: END IF;
2758:

Line 2756: RAISE fnd_api.g_exc_error;

2752: x_error_message => l_error_message);
2753:
2754: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2755: l_err_inst_rec := l_inst_tbl(l_ind);
2756: RAISE fnd_api.g_exc_error;
2757: END IF;
2758:
2759: ELSE
2760:

Line 2769: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2765: x_fixed_asset_rec => l_pending_fa_rec,
2766: x_return_status => l_return_status,
2767: x_error_message => l_error_message);
2768:
2769: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2770: l_err_inst_rec := l_inst_tbl(l_ind);
2771: RAISE fnd_api.g_exc_error;
2772: END IF;
2773:

Line 2771: RAISE fnd_api.g_exc_error;

2767: x_error_message => l_error_message);
2768:
2769: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2770: l_err_inst_rec := l_inst_tbl(l_ind);
2771: RAISE fnd_api.g_exc_error;
2772: END IF;
2773:
2774: IF l_pending_fa_rec.mass_addition_id is not null THEN
2775:

Line 2790: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2786: p_instance_rec => l_inst_tbl(l_ind),
2787: x_return_status => l_return_status,
2788: x_error_message => l_error_message);
2789:
2790: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2791: l_err_inst_rec := l_inst_tbl(l_ind);
2792: RAISE fnd_api.g_exc_error;
2793: END IF;
2794:

Line 2792: RAISE fnd_api.g_exc_error;

2788: x_error_message => l_error_message);
2789:
2790: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2791: l_err_inst_rec := l_inst_tbl(l_ind);
2792: RAISE fnd_api.g_exc_error;
2793: END IF;
2794:
2795: ELSE
2796:

Line 2807: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2803: x_mass_addition_id => l_mass_addition_id,
2804: x_return_status => l_return_status,
2805: x_error_message => l_error_message);
2806:
2807: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2808: l_err_inst_rec := l_inst_tbl(l_ind);
2809: RAISE fnd_api.g_exc_error;
2810: END IF;
2811:

Line 2809: RAISE fnd_api.g_exc_error;

2805: x_error_message => l_error_message);
2806:
2807: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2808: l_err_inst_rec := l_inst_tbl(l_ind);
2809: RAISE fnd_api.g_exc_error;
2810: END IF;
2811:
2812: END IF; -- pending mass_addition is not null
2813:

Line 2822: p_asset_id => fnd_api.g_miss_num,

2818: ELSE -- group by is ITEM_SERIAL
2819:
2820: get_instance_asset(
2821: p_instance_id => l_inst_tbl(l_ind).instance_id,
2822: p_asset_id => fnd_api.g_miss_num,
2823: x_inst_asset_rec => l_instance_asset_rec,
2824: x_return_status => l_return_status,
2825: x_error_message => l_error_message);
2826:

Line 2827: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2823: x_inst_asset_rec => l_instance_asset_rec,
2824: x_return_status => l_return_status,
2825: x_error_message => l_error_message);
2826:
2827: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2828: RAISE fnd_api.g_exc_error;
2829: END IF;
2830:
2831: IF nvl(l_instance_asset_rec.instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

Line 2828: RAISE fnd_api.g_exc_error;

2824: x_return_status => l_return_status,
2825: x_error_message => l_error_message);
2826:
2827: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2828: RAISE fnd_api.g_exc_error;
2829: END IF;
2830:
2831: IF nvl(l_instance_asset_rec.instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
2832: THEN

Line 2831: IF nvl(l_instance_asset_rec.instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

2827: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2828: RAISE fnd_api.g_exc_error;
2829: END IF;
2830:
2831: IF nvl(l_instance_asset_rec.instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
2832: THEN
2833:
2834: l_fa_action := 'CREATE_MASS_ADDITION';
2835:

Line 2842: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2838: x_mass_addition_id => l_mass_addition_id,
2839: x_return_status => l_return_status,
2840: x_error_message => l_error_message);
2841:
2842: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2843: l_err_inst_rec := l_inst_tbl(l_ind);
2844: RAISE fnd_api.g_exc_error;
2845: END IF;
2846:

Line 2844: RAISE fnd_api.g_exc_error;

2840: x_error_message => l_error_message);
2841:
2842: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2843: l_err_inst_rec := l_inst_tbl(l_ind);
2844: RAISE fnd_api.g_exc_error;
2845: END IF;
2846:
2847: ELSE
2848: l_fa_action := 'NONE';

Line 2855: l_csi_txn_rec.transaction_id := fnd_api.g_miss_num;

2851: END IF; -- fa creation group by ITEM/ITEM_SERIAL
2852:
2853: IF l_fa_action <> 'NONE' THEN
2854:
2855: l_csi_txn_rec.transaction_id := fnd_api.g_miss_num;
2856: l_csi_txn_rec.source_header_ref := 'CSI_TXN_ID';
2857: l_csi_txn_rec.source_header_ref_id := csi_txn_rec.transaction_id;
2858:
2859: IF l_mass_addition_id is not null THEN

Line 2873: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2869: px_csi_txn_rec => l_csi_txn_rec,
2870: x_inst_asset_rec => l_instance_asset_rec,
2871: x_return_status => l_return_status);
2872:
2873: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2874: RAISE fnd_api.g_exc_error;
2875: END IF;
2876: END IF;
2877:

Line 2874: RAISE fnd_api.g_exc_error;

2870: x_inst_asset_rec => l_instance_asset_rec,
2871: x_return_status => l_return_status);
2872:
2873: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2874: RAISE fnd_api.g_exc_error;
2875: END IF;
2876: END IF;
2877:
2878: END LOOP; -- loop thru instances

Line 2885: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2881: p_csi_txn_id => csi_txn_rec.transaction_id,
2882: x_return_status => l_return_status,
2883: x_error_message => l_error_message);
2884:
2885: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2886: RAISE fnd_api.g_exc_error;
2887: END IF;
2888:
2889: debug('csi transaction interfaced to fa successfully.');

Line 2886: RAISE fnd_api.g_exc_error;

2882: x_return_status => l_return_status,
2883: x_error_message => l_error_message);
2884:
2885: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2886: RAISE fnd_api.g_exc_error;
2887: END IF;
2888:
2889: debug('csi transaction interfaced to fa successfully.');
2890:

Line 2921: WHEN fnd_api.g_exc_error THEN

2917:
2918: COMMIT WORK;
2919:
2920: EXCEPTION
2921: WHEN fnd_api.g_exc_error THEN
2922: debug(' error message : '||l_error_message);
2923:
2924: l_ts_tbl(l_ts_ind).processed_flag := 'E';
2925: l_ts_tbl(l_ts_ind).error_message := l_error_message;

Line 2998: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

2994: AND date_ineffective IS NULL ;
2995:
2996: BEGIN
2997: debug('Begin - find distribution');
2998: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
2999:
3000: ---Initialize x_new_dist to TRUE (1) Indicating that matching distribution
3001: ---has not been found
3002: x_new_dist := 1 ;

Line 3037: x_return_status := FND_API.G_RET_STS_ERROR ;

3033:
3034: EXCEPTION
3035: WHEN OTHERS
3036: THEN
3037: x_return_status := FND_API.G_RET_STS_ERROR ;
3038: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3039: fnd_message.set_token('API_NAME',l_api_name);
3040: fnd_message.set_token('SQL_ERROR',SQLERRM);
3041: x_error_msg := fnd_message.get;

Line 3059: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

3055: l_api_name VARCHAR2(100):= 'CSE_ASSET_CREATION_PKG.create_fa_distribution';
3056:
3057: BEGIN
3058: debug('Begin - create distribution');
3059: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
3060: l_asset_query_rec := p_asset_query_rec ;
3061:
3062: ---07/24
3063: ---As find asset may find a distribution which may

Line 3078: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS

3074: , x_new_dist
3075: , x_return_status
3076: , x_error_msg );
3077:
3078: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS
3079: THEN
3080: RAISE e_error ;
3081: END IF ;
3082: END IF ;

Line 3097: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS

3093: ,l_asset_query_rec.deprn_employee_id
3094: ,l_asset_query_rec.distribution_id
3095: ,x_return_status
3096: ,x_error_msg );
3097: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS
3098: THEN
3099: RAISE e_error ;
3100: END IF ;
3101: END IF ;

Line 3121: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS

3117: ,x_return_status
3118: ,x_error_msg );
3119: END IF;
3120:
3121: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS
3122: THEN
3123: RAISE e_error ;
3124: END IF ;
3125: EXCEPTION

Line 3128: x_return_status := FND_API.G_RET_STS_ERROR ;

3124: END IF ;
3125: EXCEPTION
3126: WHEN e_error
3127: THEN
3128: x_return_status := FND_API.G_RET_STS_ERROR ;
3129: x_error_msg := x_error_msg ;
3130: WHEN OTHERS
3131: THEN
3132: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 3132: x_return_status := FND_API.G_RET_STS_ERROR ;

3128: x_return_status := FND_API.G_RET_STS_ERROR ;
3129: x_error_msg := x_error_msg ;
3130: WHEN OTHERS
3131: THEN
3132: x_return_status := FND_API.G_RET_STS_ERROR ;
3133: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3134: fnd_message.set_token('API_NAME',l_api_name);
3135: fnd_message.set_token('SQL_ERROR',SQLERRM);
3136: x_error_msg := fnd_message.get;

Line 3283: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

3279:
3280: BEGIN
3281:
3282: debug('Begin - find asset');
3283: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
3284: l_asset_number := p_asset_query_rec.asset_number;
3285: l_asset_id := p_asset_query_rec.asset_id;
3286: l_book_type_code := p_asset_query_rec.book_type_code ;
3287: l_serial_number := UPPER(p_asset_query_rec.serial_number);

Line 3315: IF l_asset_number = FND_API.G_MISS_CHAR

3311: l_location_id := p_asset_query_rec.location_id;
3312: l_deprn_expense_ccid := p_asset_query_rec.deprn_expense_ccid;
3313: l_inventory_item_id := p_asset_query_rec.inventory_item_id;
3314:
3315: IF l_asset_number = FND_API.G_MISS_CHAR
3316: THEN
3317: debug('l_asset_number :'|| 'NULL');
3318: ELSE
3319: debug('l_asset_number :'|| p_asset_query_rec.asset_number);

Line 3327: IF l_tag_number = FND_API.G_MISS_CHAR

3323: debug('l_book_type_code :'|| l_book_type_code );
3324: debug('l_date_placed_in_service :'|| l_date_placed_in_service) ;
3325: debug('l_asset_key_ccid :'|| l_asset_key_ccid);
3326:
3327: IF l_tag_number = FND_API.G_MISS_CHAR
3328: THEN
3329: debug('l_tag_number :'|| 'NULL');
3330: ELSE
3331: debug('l_tag_number :'|| l_tag_number);

Line 3333: IF l_description = FND_API.G_MISS_CHAR

3329: debug('l_tag_number :'|| 'NULL');
3330: ELSE
3331: debug('l_tag_number :'|| l_tag_number);
3332: END IF ;
3333: IF l_description = FND_API.G_MISS_CHAR
3334: THEN
3335: debug('l_description :'|| 'NULL');
3336: ELSE
3337: debug('l_description :'|| l_description);

Line 3340: IF l_manufacturer_name = FND_API.G_MISS_CHAR

3336: ELSE
3337: debug('l_description :'|| l_description);
3338: END IF ;
3339:
3340: IF l_manufacturer_name = FND_API.G_MISS_CHAR
3341: THEN
3342: debug('l_manufacturer_name :'|| 'NULL');
3343: ELSE
3344: debug('l_manufacturer_name :'|| l_manufacturer_name);

Line 3347: IF l_serial_number = FND_API.G_MISS_CHAR

3343: ELSE
3344: debug('l_manufacturer_name :'|| l_manufacturer_name);
3345: END IF ;
3346:
3347: IF l_serial_number = FND_API.G_MISS_CHAR
3348: THEN
3349: debug('l_serial_number :'|| 'NULL');
3350: ELSE
3351: debug('l_serial_number :'|| l_serial_number);

Line 3354: IF l_model_number = FND_API.G_MISS_CHAR

3350: ELSE
3351: debug('l_serial_number :'|| l_serial_number);
3352: END IF ;
3353:
3354: IF l_model_number = FND_API.G_MISS_CHAR
3355: THEN
3356: debug('l_model_number :'|| 'NULL');
3357: ELSE
3358: debug('l_model_number :'|| l_model_number);

Line 3422: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3418:
3419: IF p_asset_query_rec.asset_id IS NOT NULL
3420: THEN
3421: debug('Asset Found , ID is :'||p_asset_query_rec.asset_id);
3422: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3423:
3424: OPEN asset_cost_cur ;
3425: FETCH asset_cost_cur into l_mtl_cost ,l_non_mtl_cost ;
3426: CLOSE asset_cost_cur ;

Line 3479: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3475: p_distribution_tbl,
3476: x_return_status,
3477: x_error_msg);
3478:
3479: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3480: THEN
3481: RAISE e_error ;
3482: END IF;
3483:

Line 3488: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3484: cse_asset_util_pkg.get_pending_adjustments(p_asset_query_rec,
3485: x_return_status,
3486: x_error_msg);
3487:
3488: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3489: THEN
3490: RAISE e_error;
3491: END IF;
3492:

Line 3495: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3491: END IF;
3492:
3493: ELSE
3494: p_asset_query_rec.asset_id := NULL;
3495: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3496: END IF;
3497:
3498: EXCEPTION
3499: WHEN e_error

Line 3501: x_return_status := fnd_api.G_RET_STS_ERROR ;

3497:
3498: EXCEPTION
3499: WHEN e_error
3500: THEN
3501: x_return_status := fnd_api.G_RET_STS_ERROR ;
3502: --Log Error Here.
3503: debug('IN e_error:'||x_error_msg);
3504: WHEN OTHERS
3505: THEN

Line 3506: x_return_status := fnd_api.G_RET_STS_ERROR ;

3502: --Log Error Here.
3503: debug('IN e_error:'||x_error_msg);
3504: WHEN OTHERS
3505: THEN
3506: x_return_status := fnd_api.G_RET_STS_ERROR ;
3507: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3508: fnd_message.set_token('API_NAME',l_api_name);
3509: fnd_message.set_token('SQL_ERROR',SQLERRM);
3510: x_error_msg := fnd_message.get;

Line 3571: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

3567: AND fab.asset_id = c_asset_id ;
3568:
3569: BEGIN
3570:
3571: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
3572: debug('inside api cse_asset_creation_pkg.adjust_asset');
3573: debug(' asset_id : '||p_asset_query_rec.asset_id);
3574: debug(' units_to_be_adjusted : '||p_mass_add_rec.payables_units);
3575:

Line 3612: fnd_api.g_false,

3608: l_mass_add_rec.attribute14 := cse_asset_util_pkg.G_MTL_INDICATOR ;
3609:
3610: cse_asset_util_pkg.insert_mass_add(
3611: 1.0,
3612: fnd_api.g_false,
3613: fnd_api.g_true,
3614: l_mass_add_rec,
3615: x_return_status,
3616: x_msg_count,

Line 3613: fnd_api.g_true,

3609:
3610: cse_asset_util_pkg.insert_mass_add(
3611: 1.0,
3612: fnd_api.g_false,
3613: fnd_api.g_true,
3614: l_mass_add_rec,
3615: x_return_status,
3616: x_msg_count,
3617: x_msg_data);

Line 3619: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

3615: x_return_status,
3616: x_msg_count,
3617: x_msg_data);
3618:
3619: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3620: x_error_msg := x_msg_data ;
3621: RAISE fnd_api.g_exc_error;
3622: END IF ;
3623:

Line 3621: RAISE fnd_api.g_exc_error;

3617: x_msg_data);
3618:
3619: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3620: x_error_msg := x_msg_data ;
3621: RAISE fnd_api.g_exc_error;
3622: END IF ;
3623:
3624: END IF ; ---Material Cost
3625:

Line 3634: fnd_api.g_false,

3630: l_mass_add_rec.attribute14 := cse_asset_util_pkg.g_non_mtl_indicator;
3631:
3632: cse_asset_util_pkg.insert_mass_add(
3633: 1.0,
3634: fnd_api.g_false,
3635: fnd_api.g_true,
3636: l_mass_add_rec,
3637: x_return_status,
3638: x_msg_count,

Line 3635: fnd_api.g_true,

3631:
3632: cse_asset_util_pkg.insert_mass_add(
3633: 1.0,
3634: fnd_api.g_false,
3635: fnd_api.g_true,
3636: l_mass_add_rec,
3637: x_return_status,
3638: x_msg_count,
3639: x_msg_data );

Line 3641: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

3637: x_return_status,
3638: x_msg_count,
3639: x_msg_data );
3640:
3641: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3642: x_error_msg := x_msg_data ;
3643: RAISE fnd_api.g_exc_error ;
3644: END IF ;
3645:

Line 3643: RAISE fnd_api.g_exc_error ;

3639: x_msg_data );
3640:
3641: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3642: x_error_msg := x_msg_data ;
3643: RAISE fnd_api.g_exc_error ;
3644: END IF ;
3645:
3646: END IF ; --Non-material Cost
3647:

Line 3661: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

3657: p_mass_add_rec,
3658: x_return_status,
3659: x_error_msg );
3660:
3661: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3662: RAISE fnd_api.g_exc_error ;
3663: END IF ;
3664: ELSE
3665: NULL ;

Line 3662: RAISE fnd_api.g_exc_error ;

3658: x_return_status,
3659: x_error_msg );
3660:
3661: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3662: RAISE fnd_api.g_exc_error ;
3663: END IF ;
3664: ELSE
3665: NULL ;
3666: debug('This is IPV Cost Adjustment ONLY');

Line 3708: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

3704: l_ext_ret_rec,
3705: x_return_status,
3706: x_error_msg) ;
3707:
3708: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3709: debug('Insert into Retirements table failed ');
3710: RAISE fnd_api.g_exc_error ;
3711: END IF ;
3712:

Line 3710: RAISE fnd_api.g_exc_error ;

3706: x_error_msg) ;
3707:
3708: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3709: debug('Insert into Retirements table failed ');
3710: RAISE fnd_api.g_exc_error ;
3711: END IF ;
3712:
3713: END IF ; --retirement
3714:

Line 3716: WHEN fnd_api.g_exc_error THEN

3712:
3713: END IF ; --retirement
3714:
3715: EXCEPTION
3716: WHEN fnd_api.g_exc_error THEN
3717: x_return_status := FND_API.G_RET_STS_ERROR ;
3718: x_error_msg := x_error_msg ;
3719: WHEN OTHERS THEN
3720: x_return_status := fnd_api.G_RET_STS_ERROR ;

Line 3717: x_return_status := FND_API.G_RET_STS_ERROR ;

3713: END IF ; --retirement
3714:
3715: EXCEPTION
3716: WHEN fnd_api.g_exc_error THEN
3717: x_return_status := FND_API.G_RET_STS_ERROR ;
3718: x_error_msg := x_error_msg ;
3719: WHEN OTHERS THEN
3720: x_return_status := fnd_api.G_RET_STS_ERROR ;
3721: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

Line 3720: x_return_status := fnd_api.G_RET_STS_ERROR ;

3716: WHEN fnd_api.g_exc_error THEN
3717: x_return_status := FND_API.G_RET_STS_ERROR ;
3718: x_error_msg := x_error_msg ;
3719: WHEN OTHERS THEN
3720: x_return_status := fnd_api.G_RET_STS_ERROR ;
3721: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
3722: fnd_message.set_token('API_NAME',l_api_name);
3723: fnd_message.set_token('SQL_ERROR',SQLERRM);
3724: x_error_msg := fnd_message.get;

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

3737:
3738: l_mass_addition_id number;
3739: l_fa_action varchar2(30);
3740:
3741: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3742: l_error_message varchar2(2000);
3743:
3744: BEGIN
3745:

Line 3773: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3769: x_fixed_asset_rec => l_fixed_asset_rec,
3770: x_return_status => l_return_status,
3771: x_error_message => l_error_message);
3772:
3773: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3774: RAISE fnd_api.g_exc_error;
3775: END IF;
3776:
3777: IF l_fixed_asset_rec.asset_id is not null THEN

Line 3774: RAISE fnd_api.g_exc_error;

3770: x_return_status => l_return_status,
3771: x_error_message => l_error_message);
3772:
3773: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3774: RAISE fnd_api.g_exc_error;
3775: END IF;
3776:
3777: IF l_fixed_asset_rec.asset_id is not null THEN
3778:

Line 3789: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3785: p_instance_rec => l_inst_rec,
3786: x_return_status => l_return_status,
3787: x_error_message => l_error_message);
3788:
3789: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3790: RAISE fnd_api.g_exc_error;
3791: END IF;
3792:
3793: ELSE

Line 3790: RAISE fnd_api.g_exc_error;

3786: x_return_status => l_return_status,
3787: x_error_message => l_error_message);
3788:
3789: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3790: RAISE fnd_api.g_exc_error;
3791: END IF;
3792:
3793: ELSE
3794:

Line 3803: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3799: x_fixed_asset_rec => l_pending_fa_rec,
3800: x_return_status => l_return_status,
3801: x_error_message => l_error_message);
3802:
3803: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3804: RAISE fnd_api.g_exc_error;
3805: END IF;
3806:
3807: IF l_pending_fa_rec.mass_addition_id is not null THEN

Line 3804: RAISE fnd_api.g_exc_error;

3800: x_return_status => l_return_status,
3801: x_error_message => l_error_message);
3802:
3803: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3804: RAISE fnd_api.g_exc_error;
3805: END IF;
3806:
3807: IF l_pending_fa_rec.mass_addition_id is not null THEN
3808:

Line 3819: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3815: p_instance_rec => l_inst_rec,
3816: x_return_status => l_return_status,
3817: x_error_message => l_error_message);
3818:
3819: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3820: RAISE fnd_api.g_exc_error;
3821: END IF;
3822:
3823: ELSE

Line 3820: RAISE fnd_api.g_exc_error;

3816: x_return_status => l_return_status,
3817: x_error_message => l_error_message);
3818:
3819: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3820: RAISE fnd_api.g_exc_error;
3821: END IF;
3822:
3823: ELSE
3824:

Line 3835: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3831: x_mass_addition_id => l_mass_addition_id,
3832: x_return_status => l_return_status,
3833: x_error_message => l_error_message);
3834:
3835: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3836: RAISE fnd_api.g_exc_error;
3837: END IF;
3838:
3839: END IF; -- pending mass_addition is not null

Line 3836: RAISE fnd_api.g_exc_error;

3832: x_return_status => l_return_status,
3833: x_error_message => l_error_message);
3834:
3835: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3836: RAISE fnd_api.g_exc_error;
3837: END IF;
3838:
3839: END IF; -- pending mass_addition is not null
3840:

Line 3846: WHEN fnd_api.g_exc_error THEN

3842:
3843: END LOOP;
3844: END IF;
3845: EXCEPTION
3846: WHEN fnd_api.g_exc_error THEN
3847: x_return_status := fnd_api.g_ret_sts_error;
3848: x_err_inst_rec := l_inst_rec;
3849: END create_asset;
3850:

Line 3847: x_return_status := fnd_api.g_ret_sts_error;

3843: END LOOP;
3844: END IF;
3845: EXCEPTION
3846: WHEN fnd_api.g_exc_error THEN
3847: x_return_status := fnd_api.g_ret_sts_error;
3848: x_err_inst_rec := l_inst_rec;
3849: END create_asset;
3850:
3851: END cse_asset_creation_pkg;