DBA Data[Home] [Help]

APPS.CSE_PO_NOQUEUE_PVT dependencies on FND_API

Line 15: l_Init_Msg_List VARCHAR2(1) :=FND_API.G_TRUE;

11: x_Msg_data OUT NOCOPY VARCHAR2)
12: IS
13: l_Error_Message VARCHAR2(2000);
14: l_Api_Version NUMBER := 1;
15: l_Init_Msg_List VARCHAR2(1) :=FND_API.G_TRUE;
16: l_return_status VARCHAR2(1);
17: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: l_rcv_attributes_rec CSE_DATASTRUCTURES_PUB.RCV_ATTRIBUTES_REC_TYPE;
19: l_Rcv_Txn_tbl CSE_Datastructures_Pub.Rcv_Txn_Tbl_Type;

Line 17: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13: l_Error_Message VARCHAR2(2000);
14: l_Api_Version NUMBER := 1;
15: l_Init_Msg_List VARCHAR2(1) :=FND_API.G_TRUE;
16: l_return_status VARCHAR2(1);
17: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: l_rcv_attributes_rec CSE_DATASTRUCTURES_PUB.RCV_ATTRIBUTES_REC_TYPE;
19: l_Rcv_Txn_tbl CSE_Datastructures_Pub.Rcv_Txn_Tbl_Type;
20: l_ipv_attributes_rec CSE_DATASTRUCTURES_PUB.IPV_ATTRIBUTES_REC_TYPE;
21: l_ipv_Txn_tbl CSE_Datastructures_Pub.Ipv_Txn_Tbl_Type;

Line 134: x_return_status := fnd_api.g_ret_sts_success;

130: WHERE source_dist_ref_id2 = p_rcv_txn_id
131: AND Transaction_Type_Id = cse_util_pkg.get_txn_type_id('PO_RECEIPT_INTO_PROJECT','PO');
132: BEGIN
133:
134: x_return_status := fnd_api.g_ret_sts_success;
135: x_error_message := null;
136:
137: savepoint one;
138:

Line 145: IF x_return_status = fnd_api.g_ret_sts_success THEN

141: l_rcv_txn_tbl,
142: x_return_status,
143: x_error_message);
144:
145: IF x_return_status = fnd_api.g_ret_sts_success THEN
146:
147: OPEN txn_id_cur;
148: FETCH txn_id_cur INTO l_txn_id;
149: CLOSE txn_id_cur;

Line 162: IF l_return_status <> fnd_api.g_ret_sts_success THEN

158: l_rcv_txn_tbl,
159: l_return_status,
160: l_error_message);
161:
162: IF l_return_status <> fnd_api.g_ret_sts_success THEN
163: RAISE fnd_api.g_exc_error;
164: END IF;
165:
166: cse_po_receipt_into_project.cleanup_transaction_temps(p_rcv_txn_id);

Line 163: RAISE fnd_api.g_exc_error;

159: l_return_status,
160: l_error_message);
161:
162: IF l_return_status <> fnd_api.g_ret_sts_success THEN
163: RAISE fnd_api.g_exc_error;
164: END IF;
165:
166: cse_po_receipt_into_project.cleanup_transaction_temps(p_rcv_txn_id);
167:

Line 172: WHEN fnd_api.g_exc_error THEN

168: END IF;
169: END IF;
170:
171: EXCEPTION
172: WHEN fnd_api.g_exc_error THEN
173:
174: l_txn_error_rec := cse_util_pkg.Init_Txn_Error_Rec;
175: l_txn_error_rec.transaction_id := l_txn_id;
176: l_txn_error_rec.error_text := l_error_message;

Line 188: fnd_api.g_true,

184: rollback to one;
185:
186: csi_transactions_pvt.create_txn_error(
187: 1.0,
188: fnd_api.g_true,
189: 'F',
190: 1,
191: l_txn_error_rec,
192: l_return_status,