DBA Data[Home] [Help]

APPS.CSE_RCVTXN_PKG dependencies on FND_API

Line 34: l_commit VARCHAR2(1) DEFAULT fnd_api.g_false;

30: l_error_message VARCHAR2(2000);
31: l_return_status VARCHAR2(100);
32: l_file VARCHAR2(500);
33: l_api_version NUMBER DEFAULT 1.0;
34: l_commit VARCHAR2(1) DEFAULT fnd_api.g_false;
35: l_init_msg_list VARCHAR2(1) DEFAULT fnd_api.g_true;
36: l_msg_count NUMBER;
37: l_msg_data VARCHAR2(2000);
38: l_trx_error_rec csi_datastructures_pub.transaction_error_rec;

Line 35: l_init_msg_list VARCHAR2(1) DEFAULT fnd_api.g_true;

31: l_return_status VARCHAR2(100);
32: l_file VARCHAR2(500);
33: l_api_version NUMBER DEFAULT 1.0;
34: l_commit VARCHAR2(1) DEFAULT fnd_api.g_false;
35: l_init_msg_list VARCHAR2(1) DEFAULT fnd_api.g_true;
36: l_msg_count NUMBER;
37: l_msg_data VARCHAR2(2000);
38: l_trx_error_rec csi_datastructures_pub.transaction_error_rec;
39: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;

Line 39: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;

35: l_init_msg_list VARCHAR2(1) DEFAULT fnd_api.g_true;
36: l_msg_count NUMBER;
37: l_msg_data VARCHAR2(2000);
38: l_trx_error_rec csi_datastructures_pub.transaction_error_rec;
39: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
40: l_Txn_Error_Id NUMBER;
41: l_xml_string VARCHAR2(2000);
42:
43: CURSOR rcv_txn_cur IS

Line 61: p_return_status := fnd_api.g_ret_sts_success;

57: BEGIN
58:
59: savepoint rcv_hook;
60:
61: p_return_status := fnd_api.g_ret_sts_success;
62: l_eib_installed := cse_util_pkg.is_eib_installed;
63:
64: IF l_eib_installed = 'Y' THEN
65:

Line 109: RAISE fnd_api.g_exc_error;

105: x_error_code => l_error_code ,
106: x_error_message => l_error_message);
107:
108: IF l_error_code <> 0 THEN
109: RAISE fnd_api.g_exc_error;
110: END IF;
111:
112: ELSE
113: cse_po_noqueue_pvt.process_noqueue_txn(

Line 120: IF l_return_status <> fnd_api.g_ret_sts_success THEN

116: x_return_status => l_return_Status,
117: x_msg_count => l_msg_count,
118: x_msg_data => l_msg_data);
119:
120: IF l_return_status <> fnd_api.g_ret_sts_success THEN
121: l_error_message := l_msg_data;
122: RAISE fnd_api.g_exc_error;
123: END IF;
124:

Line 122: RAISE fnd_api.g_exc_error;

118: x_msg_data => l_msg_data);
119:
120: IF l_return_status <> fnd_api.g_ret_sts_success THEN
121: l_error_message := l_msg_data;
122: RAISE fnd_api.g_exc_error;
123: END IF;
124:
125: END IF; -- bypass/publish
126: END IF; -- ib tracked

Line 135: p_return_Status := fnd_api.g_ret_sts_unexp_error;

131:
132: EXCEPTION
133: WHEN OTHERS THEN
134: ROLLBACK TO rcv_hook;
135: p_return_Status := fnd_api.g_ret_sts_unexp_error;
136: l_error_Message := nvl(l_error_message, sqlerrm);
137: IF l_eib_installed = 'Y' THEN
138: l_trx_error_rec.error_text := l_error_message;
139: l_trx_error_rec.source_type := 'CSEPORCV';