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_FAC_INSERVICE_PKG dependencies on FND_API

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

24: x_return_status OUT nocopy varchar2,
25: x_error_message OUT nocopy varchar2)
26: IS
27: l_txn_rec csi_datastructures_pub.transaction_rec;
28: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
29: l_msg_count number;
30: l_msg_data varchar2(2000);
31: BEGIN
32:

Line 33: x_return_status := fnd_api.g_ret_sts_success;

29: l_msg_count number;
30: l_msg_data varchar2(2000);
31: BEGIN
32:
33: x_return_status := fnd_api.g_ret_sts_success;
34:
35: l_txn_rec.transaction_id := p_csi_txn_id;
36: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;
37: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;

Line 46: p_init_msg_list => fnd_api.g_true,

42: WHERE transaction_id = l_txn_rec.transaction_id;
43:
44: csi_transactions_pvt.update_transactions(
45: p_api_version => 1.0,
46: p_init_msg_list => fnd_api.g_true,
47: p_commit => fnd_api.g_false,
48: p_validation_level => fnd_api.g_valid_level_full,
49: p_transaction_rec => l_txn_rec,
50: x_return_status => l_return_status,

Line 47: p_commit => fnd_api.g_false,

43:
44: csi_transactions_pvt.update_transactions(
45: p_api_version => 1.0,
46: p_init_msg_list => fnd_api.g_true,
47: p_commit => fnd_api.g_false,
48: p_validation_level => fnd_api.g_valid_level_full,
49: p_transaction_rec => l_txn_rec,
50: x_return_status => l_return_status,
51: x_msg_count => l_msg_count,

Line 48: p_validation_level => fnd_api.g_valid_level_full,

44: csi_transactions_pvt.update_transactions(
45: p_api_version => 1.0,
46: p_init_msg_list => fnd_api.g_true,
47: p_commit => fnd_api.g_false,
48: p_validation_level => fnd_api.g_valid_level_full,
49: p_transaction_rec => l_txn_rec,
50: x_return_status => l_return_status,
51: x_msg_count => l_msg_count,
52: x_msg_data => l_msg_data);

Line 54: IF l_return_status <> fnd_api.g_ret_sts_success THEN

50: x_return_status => l_return_status,
51: x_msg_count => l_msg_count,
52: x_msg_data => l_msg_data);
53:
54: IF l_return_status <> fnd_api.g_ret_sts_success THEN
55: RAISE fnd_api.g_exc_error;
56: END IF;
57:
58: EXCEPTION

Line 55: RAISE fnd_api.g_exc_error;

51: x_msg_count => l_msg_count,
52: x_msg_data => l_msg_data);
53:
54: IF l_return_status <> fnd_api.g_ret_sts_success THEN
55: RAISE fnd_api.g_exc_error;
56: END IF;
57:
58: EXCEPTION
59: WHEN fnd_api.g_exc_error THEN

Line 59: WHEN fnd_api.g_exc_error THEN

55: RAISE fnd_api.g_exc_error;
56: END IF;
57:
58: EXCEPTION
59: WHEN fnd_api.g_exc_error THEN
60: x_return_status := fnd_api.g_ret_sts_error;
61: END complete_csi_txn;
62:
63: PROCEDURE create_expitem(

Line 60: x_return_status := fnd_api.g_ret_sts_error;

56: END IF;
57:
58: EXCEPTION
59: WHEN fnd_api.g_exc_error THEN
60: x_return_status := fnd_api.g_ret_sts_error;
61: END complete_csi_txn;
62:
63: PROCEDURE create_expitem(
64: x_return_status OUT NOCOPY VARCHAR2,

Line 71: l_Commit VARCHAR2(1) := FND_API.G_False;

67: p_task_num IN VARCHAR2 ,
68: p_conc_request_id IN NUMBER )
69: IS
70: l_Api_Version NUMBER :=1;
71: l_Commit VARCHAR2(1) := FND_API.G_False;
72: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;
73: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;
74: l_Msg_Data VARCHAR2(2000);
75: l_Msg_Count NUMBER;

Line 72: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;

68: p_conc_request_id IN NUMBER )
69: IS
70: l_Api_Version NUMBER :=1;
71: l_Commit VARCHAR2(1) := FND_API.G_False;
72: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;
73: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;
74: l_Msg_Data VARCHAR2(2000);
75: l_Msg_Count NUMBER;
76: l_Return_Status VARCHAR2(1);

Line 73: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;

69: IS
70: l_Api_Version NUMBER :=1;
71: l_Commit VARCHAR2(1) := FND_API.G_False;
72: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;
73: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;
74: l_Msg_Data VARCHAR2(2000);
75: l_Msg_Count NUMBER;
76: l_Return_Status VARCHAR2(1);
77: l_Error_Message VARCHAR2(2000);

Line 230: RAISE fnd_api.g_exc_error;

226: x_error_message => l_error_message);
227:
228: IF NOT l_Return_Status = g_ret_sts_success THEN
229: debug('error interfacing nl_to_pa '||substr(l_error_message,1,200));
230: RAISE fnd_api.g_exc_error;
231: END IF;
232:
233: ELSE
234:

Line 240: IF l_return_status <> fnd_api.g_ret_sts_success THEN

236: p_csi_txn_id => inservice_txn_rec.transaction_id,
237: x_return_status => l_return_status,
238: x_error_message => l_error_message);
239:
240: IF l_return_status <> fnd_api.g_ret_sts_success THEN
241: RAISE fnd_api.g_exc_error;
242: END IF;
243:
244: END IF;

Line 241: RAISE fnd_api.g_exc_error;

237: x_return_status => l_return_status,
238: x_error_message => l_error_message);
239:
240: IF l_return_status <> fnd_api.g_ret_sts_success THEN
241: RAISE fnd_api.g_exc_error;
242: END IF;
243:
244: END IF;
245:

Line 250: WHEN fnd_api.g_exc_error THEN

246: END LOOP;
247:
248:
249: EXCEPTION
250: WHEN fnd_api.g_exc_error THEN
251: rollback to start_csi_transaction;
252:
253: x_return_status := g_ret_sts_error;
254:

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

407: l_err_stage varchar2(640);
408: l_err_code varchar2(640);
409: l_rejection_code varchar2(640);
410: l_error_message varchar2(2000);
411: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
412: l_msg_count number;
413: l_msg_data varchar2(4000);
414: l_hook_used number;
415:

Line 417: l_Commit VARCHAR2(1) := FND_API.G_False;

413: l_msg_data varchar2(4000);
414: l_hook_used number;
415:
416: l_Api_Version NUMBER :=1;
417: l_Commit VARCHAR2(1) := FND_API.G_False;
418: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;
419: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;
420: l_Msg_Text VARCHAR2(4000);
421: l_Transaction_Error_Id NUMBER;

Line 418: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;

414: l_hook_used number;
415:
416: l_Api_Version NUMBER :=1;
417: l_Commit VARCHAR2(1) := FND_API.G_False;
418: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;
419: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;
420: l_Msg_Text VARCHAR2(4000);
421: l_Transaction_Error_Id NUMBER;
422: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;

Line 419: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;

415:
416: l_Api_Version NUMBER :=1;
417: l_Commit VARCHAR2(1) := FND_API.G_False;
418: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;
419: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;
420: l_Msg_Text VARCHAR2(4000);
421: l_Transaction_Error_Id NUMBER;
422: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
423:

Line 452: x_return_status := fnd_api.g_ret_sts_success;

448: AND pal.project_asset_id >= 1);
449:
450: BEGIN
451:
452: x_return_status := fnd_api.g_ret_sts_success;
453: x_processed_flag := 'N';
454:
455: debug('Inside API create_project_asset');
456:

Line 539: l_error_message := fnd_api.g_miss_char;

535: debug('processing_mode : CREATE');
536:
537: l_asset_attrib_rec.Transaction_ID :=p_csi_txn_id;
538:
539: l_error_message := fnd_api.g_miss_char;
540:
541: cse_asset_client_ext_stub.get_asset_name(
542: p_asset_attrib_rec => l_asset_attrib_rec,
543: x_asset_name => l_asset_name,

Line 547: IF nvl(l_error_message,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN

543: x_asset_name => l_asset_name,
544: x_hook_used => l_hook_used,
545: x_error_msg => l_error_message);
546:
547: IF nvl(l_error_message,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
548: x_error_message := l_error_message; --- Added for bug 6030501
549: RAISE fnd_api.g_exc_error;
550: END IF;
551:

Line 549: RAISE fnd_api.g_exc_error;

545: x_error_msg => l_error_message);
546:
547: IF nvl(l_error_message,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
548: x_error_message := l_error_message; --- Added for bug 6030501
549: RAISE fnd_api.g_exc_error;
550: END IF;
551:
552: SELECT csi_pa_interface_s.nextval
553: INTO l_suffix

Line 649: IF l_return_status <> fnd_api.g_ret_sts_success THEN

645: p_asset_attrib_rec => l_asset_attrib_rec,
646: x_error_msg => l_error_message,
647: x_return_status => l_return_status);
648:
649: IF l_return_status <> fnd_api.g_ret_sts_success THEN
650: x_error_message := l_error_message; --- Added for bug 6030501
651: RAISE fnd_api.g_exc_error;
652: END IF;
653:

Line 651: RAISE fnd_api.g_exc_error;

647: x_return_status => l_return_status);
648:
649: IF l_return_status <> fnd_api.g_ret_sts_success THEN
650: x_error_message := l_error_message; --- Added for bug 6030501
651: RAISE fnd_api.g_exc_error;
652: END IF;
653:
654: debug(' book_type_code : '||l_book_type_code);
655:

Line 657: IF l_return_status <> fnd_api.g_ret_sts_success THEN

653:
654: debug(' book_type_code : '||l_book_type_code);
655:
656:
657: IF l_return_status <> fnd_api.g_ret_sts_success THEN
658: RAISE fnd_api.g_exc_error;
659: END IF;
660:
661: debug(' book_type_code : '||l_book_type_code);

Line 658: RAISE fnd_api.g_exc_error;

654: debug(' book_type_code : '||l_book_type_code);
655:
656:
657: IF l_return_status <> fnd_api.g_ret_sts_success THEN
658: RAISE fnd_api.g_exc_error;
659: END IF;
660:
661: debug(' book_type_code : '||l_book_type_code);
662:

Line 663: l_error_message := fnd_api.g_miss_char;

659: END IF;
660:
661: debug(' book_type_code : '||l_book_type_code);
662:
663: l_error_message := fnd_api.g_miss_char;
664: cse_asset_client_ext_stub.get_deprn_expense_ccid(
665: p_asset_attrib_rec => l_asset_attrib_rec,
666: x_deprn_expense_ccid => l_deprn_expense_ccid,
667: x_hook_used => l_hook_used,

Line 670: IF nvl(l_error_message,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN

666: x_deprn_expense_ccid => l_deprn_expense_ccid,
667: x_hook_used => l_hook_used,
668: x_error_msg => l_error_message);
669:
670: IF nvl(l_error_message,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
671: x_error_message := l_error_message; --- Added for bug 6030501
672: RAISE fnd_api.g_exc_error;
673: END IF;
674:

Line 672: RAISE fnd_api.g_exc_error;

668: x_error_msg => l_error_message);
669:
670: IF nvl(l_error_message,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
671: x_error_message := l_error_message; --- Added for bug 6030501
672: RAISE fnd_api.g_exc_error;
673: END IF;
674:
675: IF l_hook_used = 0 THEN
676: ipa_client_extension_pkg.get_default_deprn_expense(

Line 743: IF l_return_status <> fnd_api.g_ret_sts_success THEN

739:
740: l_msg_data := fnd_message.get;
741: debug('l_msg_data : '||l_msg_data);
742:
743: IF l_return_status <> fnd_api.g_ret_sts_success THEN
744: x_error_message := l_msg_data; --- Added for bug 6030501
745: RAISE fnd_api.g_exc_error;
746: END IF;
747:

Line 745: RAISE fnd_api.g_exc_error;

741: debug('l_msg_data : '||l_msg_data);
742:
743: IF l_return_status <> fnd_api.g_ret_sts_success THEN
744: x_error_message := l_msg_data; --- Added for bug 6030501
745: RAISE fnd_api.g_exc_error;
746: END IF;
747:
748: END IF; -- l_asset_key_required
749:

Line 757: p_init_msg_list => fnd_api.g_true,

753: debug('Inside API pa_project_assets_pub.add_project_asset');
754:
755: pa_project_assets_pub.add_project_asset(
756: p_api_version_number => 1.0,
757: p_init_msg_list => fnd_api.g_true,
758: p_pm_product_code => 'CSE',
759: p_pm_project_reference => l_project_num,
760: p_pa_project_id => p_project_id,
761: p_pa_asset_name => l_asset_name,

Line 790: IF l_return_status <> fnd_api.g_ret_sts_success THEN

786:
787: l_msg_data := fnd_message.get;
788: debug('l_msg_data : '||l_msg_data);
789:
790: IF l_return_status <> fnd_api.g_ret_sts_success THEN
791: debug('Error in API pa_project_assets_pub.add_project_asset'); -- Added for Bug 6152305
792: -- x_error_message := l_msg_data; --- Added for bug 6030501
793: --debug('l_msg_data : '||l_msg_data);
794: RAISE fnd_api.g_exc_error;

Line 794: RAISE fnd_api.g_exc_error;

790: IF l_return_status <> fnd_api.g_ret_sts_success THEN
791: debug('Error in API pa_project_assets_pub.add_project_asset'); -- Added for Bug 6152305
792: -- x_error_message := l_msg_data; --- Added for bug 6030501
793: --debug('l_msg_data : '||l_msg_data);
794: RAISE fnd_api.g_exc_error;
795: END IF;
796:
797: debug(' pa_project_asset_id : '||l_pa_project_asset_id);
798:

Line 803: p_init_msg_list => fnd_api.g_true,

799: debug('Inside API pa_project_assets_pub.add_asset_assignment');
800:
801: pa_project_assets_pub.add_asset_assignment(
802: p_api_version_number => 1.0,
803: p_init_msg_list => fnd_api.g_true,
804: p_pm_product_code => 'CSE',
805: p_pm_project_reference => l_project_num,
806: p_pa_project_id => p_project_id,
807: p_pm_task_reference => l_task_num,

Line 822: IF l_return_status <> fnd_api.g_ret_sts_success THEN

818: p_return_status => l_return_status,
819: p_msg_count => l_msg_count,
820: p_msg_data => l_msg_data);
821:
822: IF l_return_status <> fnd_api.g_ret_sts_success THEN
823: debug('Error in API pa_project_assets_pub.add_asset_assignment'); -- Added for Bug 6152305
824: --x_error_message := l_msg_data; --- Added for bug 6030501
825: RAISE fnd_api.g_exc_error;
826: END IF;

Line 825: RAISE fnd_api.g_exc_error;

821:
822: IF l_return_status <> fnd_api.g_ret_sts_success THEN
823: debug('Error in API pa_project_assets_pub.add_asset_assignment'); -- Added for Bug 6152305
824: --x_error_message := l_msg_data; --- Added for bug 6030501
825: RAISE fnd_api.g_exc_error;
826: END IF;
827:
828: x_processed_flag := 'Y';
829:

Line 856: WHEN fnd_api.g_exc_error THEN

852:
853: x_project_asset_id := l_pa_project_asset_id;
854:
855: EXCEPTION
856: WHEN fnd_api.g_exc_error THEN
857: ----- Code start for bug 6030501
858: IF x_error_message IS NULL then
859: x_error_message := nvl(cse_util_pkg.dump_error_stack, l_error_message);
860: END IF;

Line 861: x_return_status := fnd_api.g_ret_sts_error;

857: ----- Code start for bug 6030501
858: IF x_error_message IS NULL then
859: x_error_message := nvl(cse_util_pkg.dump_error_stack, l_error_message);
860: END IF;
861: x_return_status := fnd_api.g_ret_sts_error;
862:
863: debug(' Error Message '||x_error_message);
864: l_txn_error_rec := CSE_UTIL_PKG.Init_Txn_Error_Rec;
865: l_txn_error_rec.ERROR_TEXT := x_error_message;

Line 883: x_return_status := fnd_api.g_ret_sts_error;

879: x_msg_data => l_Msg_Data,
880: x_transaction_error_id => l_Transaction_Error_Id);
881:
882: -- x_error_message := nvl(cse_util_pkg.dump_error_stack, l_error_message);
883: x_return_status := fnd_api.g_ret_sts_error;
884:
885: ---- Code end for bug 6030501
886: END create_project_asset ;
887:

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

893: p_task_id IN number,
894: P_conc_request_id IN NUMBER)
895: IS
896:
897: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
898: l_error_message varchar2(2000);
899: l_project_asset_id number;
900: l_fa_group_by varchar2(30);
901: l_serial_number varchar2(200);

Line 933: l_Commit VARCHAR2(1) := FND_API.G_False;

929: AND cii.instance_id = ciih.instance_id
930: AND (ciih.new_operational_status_code = 'IN_SERVICE' OR cii.operational_status_code = 'IN_SERVICE');
931:
932: l_Api_Version NUMBER :=1;
933: l_Commit VARCHAR2(1) := FND_API.G_False;
934: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;
935: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;
936: l_Msg_Text VARCHAR2(4000);
937: l_Transaction_Error_Id NUMBER;

Line 934: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;

930: AND (ciih.new_operational_status_code = 'IN_SERVICE' OR cii.operational_status_code = 'IN_SERVICE');
931:
932: l_Api_Version NUMBER :=1;
933: l_Commit VARCHAR2(1) := FND_API.G_False;
934: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;
935: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;
936: l_Msg_Text VARCHAR2(4000);
937: l_Transaction_Error_Id NUMBER;
938: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;

Line 935: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;

931:
932: l_Api_Version NUMBER :=1;
933: l_Commit VARCHAR2(1) := FND_API.G_False;
934: l_Validation_Level NUMBER := FND_API.G_Valid_Level_Full;
935: l_Init_Msg_List VARCHAR2(1) := FND_API.G_True;
936: l_Msg_Text VARCHAR2(4000);
937: l_Transaction_Error_Id NUMBER;
938: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
939: l_msg_count number;

Line 1008: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1004: x_return_status => l_return_status,
1005: x_error_message => l_error_message,
1006: P_conc_request_id => P_conc_request_id);
1007:
1008: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1009: RAISE fnd_api.g_exc_error;
1010: END IF;
1011:
1012: IF l_processed_flag = 'Y' THEN

Line 1009: RAISE fnd_api.g_exc_error;

1005: x_error_message => l_error_message,
1006: P_conc_request_id => P_conc_request_id);
1007:
1008: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1009: RAISE fnd_api.g_exc_error;
1010: END IF;
1011:
1012: IF l_processed_flag = 'Y' THEN
1013: l_process_flag := TRUE;

Line 1025: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1021: p_csi_txn_id => insrv_txn_rec.transaction_id,
1022: x_return_status => l_return_status,
1023: x_error_message => l_error_message);
1024:
1025: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1026: RAISE fnd_api.g_exc_error;
1027: END IF;
1028:
1029: debug('csi transaction interfaced to project asset successfully.');

Line 1026: RAISE fnd_api.g_exc_error;

1022: x_return_status => l_return_status,
1023: x_error_message => l_error_message);
1024:
1025: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1026: RAISE fnd_api.g_exc_error;
1027: END IF;
1028:
1029: debug('csi transaction interfaced to project asset successfully.');
1030:

Line 1036: WHEN fnd_api.g_exc_error THEN

1032:
1033: END IF;
1034:
1035: EXCEPTION
1036: WHEN fnd_api.g_exc_error THEN
1037: debug(l_error_message);
1038: rollback to insrv_txn;
1039: debug(' Error Message '||l_error_message);
1040: l_txn_error_rec := CSE_UTIL_PKG.Init_Txn_Error_Rec;

Line 1070: --x_return_status := fnd_api.g_ret_sts_error;

1066:
1067: END LOOP;
1068: EXCEPTION
1069: WHEN others THEN
1070: --x_return_status := fnd_api.g_ret_sts_error;
1071: retcode := -1;
1072: errbuf := sqlerrm;
1073: END create_pa_asset_headers;
1074:

Line 1116: x_return_status := fnd_api.g_ret_sts_success;

1112: AND source_type = 'FA_UNIT_ADJUSTMENT_NORMAL';
1113:
1114: BEGIN
1115:
1116: x_return_status := fnd_api.g_ret_sts_success;
1117: x_error_message := NULL;
1118:
1119: debug('inside api cse_fac_inservice_pkg.update_units');
1120:

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

1211: l_inst_asset_rec.instance_asset_id := l_instance_asset_id;
1212: l_inst_asset_rec.object_version_number := l_object_version_number;
1213: l_inst_asset_rec.update_status := cse_datastructures_pub.g_in_service;
1214: l_inst_asset_rec.active_end_date := null;
1215: l_inst_asset_rec.check_for_instance_expiry := fnd_api.g_false;
1216:
1217: debug(' instance_asset_id : '||l_inst_asset_rec.instance_asset_id);
1218: debug(' asset_quantity : '||l_inst_asset_rec.asset_quantity);
1219:

Line 1224: p_commit => fnd_api.g_false,

1220: debug('calling csi_asset_pvt.update_instance_asset');
1221:
1222: csi_asset_pvt.update_instance_asset(
1223: p_api_version => 1.0,
1224: p_commit => fnd_api.g_false,
1225: p_init_msg_list => fnd_api.g_true,
1226: p_validation_level => fnd_api.g_valid_level_full,
1227: p_instance_asset_rec => l_inst_asset_rec,
1228: p_txn_rec => l_csi_txn_rec,

Line 1225: p_init_msg_list => fnd_api.g_true,

1221:
1222: csi_asset_pvt.update_instance_asset(
1223: p_api_version => 1.0,
1224: p_commit => fnd_api.g_false,
1225: p_init_msg_list => fnd_api.g_true,
1226: p_validation_level => fnd_api.g_valid_level_full,
1227: p_instance_asset_rec => l_inst_asset_rec,
1228: p_txn_rec => l_csi_txn_rec,
1229: x_return_status => l_return_status,

Line 1226: p_validation_level => fnd_api.g_valid_level_full,

1222: csi_asset_pvt.update_instance_asset(
1223: p_api_version => 1.0,
1224: p_commit => fnd_api.g_false,
1225: p_init_msg_list => fnd_api.g_true,
1226: p_validation_level => fnd_api.g_valid_level_full,
1227: p_instance_asset_rec => l_inst_asset_rec,
1228: p_txn_rec => l_csi_txn_rec,
1229: x_return_status => l_return_status,
1230: x_msg_count => l_msg_count,

Line 1237: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1233: p_asset_count_rec => l_asset_count_rec,
1234: p_asset_id_tbl => l_asset_id_tbl,
1235: p_asset_loc_tbl => l_asset_loc_tbl);
1236:
1237: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1238: RAISE fnd_api.g_exc_error;
1239: END IF;
1240:
1241: END IF;

Line 1238: RAISE fnd_api.g_exc_error;

1234: p_asset_id_tbl => l_asset_id_tbl,
1235: p_asset_loc_tbl => l_asset_loc_tbl);
1236:
1237: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1238: RAISE fnd_api.g_exc_error;
1239: END IF;
1240:
1241: END IF;
1242:

Line 1254: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1250: x_new_dist_id => l_new_dist_id,
1251: x_return_status => l_return_status,
1252: x_error_msg => l_error_message);
1253:
1254: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1255: RAISE fnd_api.g_exc_error;
1256: END IF;
1257:
1258: UPDATE csi_txn_errors

Line 1255: RAISE fnd_api.g_exc_error;

1251: x_return_status => l_return_status,
1252: x_error_msg => l_error_message);
1253:
1254: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1255: RAISE fnd_api.g_exc_error;
1256: END IF;
1257:
1258: UPDATE csi_txn_errors
1259: SET processed_flag = 'S',

Line 1268: WHEN fnd_api.g_exc_error THEN

1264:
1265: commit work;
1266:
1267: EXCEPTION
1268: WHEN fnd_api.g_exc_error THEN
1269:
1270: rollback to eachtxn;
1271:
1272: UPDATE csi_txn_errors

Line 1286: x_return_status := fnd_api.g_ret_sts_unexp_error;

1282: END LOOP;
1283:
1284: EXCEPTION
1285: WHEN OTHERS THEN
1286: x_return_status := fnd_api.g_ret_sts_unexp_error;
1287: x_error_message := sqlerrm;
1288: debug(' ERROR : '||x_error_message);
1289: END Update_Units;
1290: