DBA Data[Home] [Help]

APPS.CSE_PO_NOQUEUE_PVT dependencies on CSE_UTIL_PKG

Line 39: cse_util_pkg.set_debug;

35: l_return_status := l_fnd_success;
36: l_error_message := NULL;
37: savepoint one;
38:
39: cse_util_pkg.set_debug;
40:
41: IF P_Txn_Type = 'PO_RECEIPT_INTO_PROJECT' THEN
42:
43: l_type_id := cse_util_pkg.get_txn_type_id('PO_RECEIPT_INTO_PROJECT','PO');

Line 43: l_type_id := cse_util_pkg.get_txn_type_id('PO_RECEIPT_INTO_PROJECT','PO');

39: cse_util_pkg.set_debug;
40:
41: IF P_Txn_Type = 'PO_RECEIPT_INTO_PROJECT' THEN
42:
43: l_type_id := cse_util_pkg.get_txn_type_id('PO_RECEIPT_INTO_PROJECT','PO');
44:
45: cse_util_pkg.build_error_string(l_xml_string,'RCV_TRANSACTION_ID',p_ref_id);
46:
47: l_rcv_attributes_rec.Rcv_Transaction_Id := P_Ref_Id;

Line 45: cse_util_pkg.build_error_string(l_xml_string,'RCV_TRANSACTION_ID',p_ref_id);

41: IF P_Txn_Type = 'PO_RECEIPT_INTO_PROJECT' THEN
42:
43: l_type_id := cse_util_pkg.get_txn_type_id('PO_RECEIPT_INTO_PROJECT','PO');
44:
45: cse_util_pkg.build_error_string(l_xml_string,'RCV_TRANSACTION_ID',p_ref_id);
46:
47: l_rcv_attributes_rec.Rcv_Transaction_Id := P_Ref_Id;
48: IF (l_debug = 'Y') THEN
49: cse_debug_pub.add('No Queue PO_RECEIPT_INTO_PROJECT');

Line 86: l_txn_error_rec := cse_util_pkg.Init_Txn_Error_Rec;

82: IF (l_debug = 'Y') THEN
83: cse_debug_pub.add('No Queue error'||l_error_Message);
84: END IF;
85:
86: l_txn_error_rec := cse_util_pkg.Init_Txn_Error_Rec;
87: l_txn_error_rec.transaction_id := l_transaction_id;
88: l_txn_error_rec.error_text := l_error_message;
89: l_txn_error_rec.source_type := P_Txn_Type;
90: l_txn_error_rec.source_id := P_Ref_Id;

Line 131: AND Transaction_Type_Id = cse_util_pkg.get_txn_type_id('PO_RECEIPT_INTO_PROJECT','PO');

127: CURSOR txn_id_cur IS
128: SELECT transaction_id
129: FROM csi_transactions
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;

Line 174: l_txn_error_rec := cse_util_pkg.Init_Txn_Error_Rec;

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;
177: l_txn_error_rec.source_type := 'CSEPORCV';
178: l_txn_error_rec.source_id := l_txn_id;

Line 180: cse_util_pkg.build_error_string(l_xml_string,'RCV_TRANSACTION_ID',p_rcv_txn_id);

176: l_txn_error_rec.error_text := l_error_message;
177: l_txn_error_rec.source_type := 'CSEPORCV';
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;