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;
22: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
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;
22: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
23: l_msg_count NUMBER;
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;
22: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
23: l_msg_count NUMBER;
24: l_msg_data VARCHAR2(2000);
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;
22: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
23: l_msg_count NUMBER;
24: l_msg_data VARCHAR2(2000);
25: l_txn_error_id NUMBER;
55: l_return_status,
56: l_error_message);
57:
58: IF NOT l_return_status = l_fnd_success THEN
59: l_error_stage := cse_datastructures_pub.g_ib_update;
60: RAISE e_dpl_error;
61: END IF;
62:
63: IF (l_debug = 'Y') THEN
71: l_return_status,
72: l_error_message);
73:
74: IF NOT l_return_status = l_fnd_success THEN
75: l_error_stage := cse_datastructures_pub.g_pa_interface;
76: RAISE e_dpl_error;
77: END IF;
78: END IF;
79:
111: P_Rcv_Txn_Id IN NUMBER,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_error_message OUT NOCOPY VARCHAR2)
114: IS
115: l_rcv_txn_tbl cse_datastructures_pub.rcv_txn_tbl_type;
116: l_txn_id NUMBER;
117:
118: l_txn_error_rec csi_datastructures_pub.transaction_error_rec;
119: l_txn_error_id number;
178: l_txn_error_rec.source_id := l_txn_id;
179: l_txn_error_rec.transaction_type_id := 105;
180: cse_util_pkg.build_error_string(l_xml_string,'RCV_TRANSACTION_ID',p_rcv_txn_id);
181: l_txn_error_rec.message_string := l_xml_string;
182: l_txn_error_rec.error_stage := cse_datastructures_pub.g_pa_interface;
183:
184: rollback to one;
185:
186: csi_transactions_pvt.create_txn_error(