[Home] [Help]
5969: WHERE instance_id = p_ins_id;
5970: --
5971: l_instance_csr instance_csr%ROWTYPE;
5972: --
5973: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
5974: l_ctr_group_id NUMBER;
5975: l_eam_item_type NUMBER;
5976: --
5977: BEGIN
7484: set contracts_invoked = 'Y'
7485: where transaction_id = l_upd_txn_tbl(K);
7486: END IF;
7487: --
7488: OKS_IBINT_PUB.IB_interface
7489: (
7490: P_Api_Version => 1.0,
7491: P_init_msg_list => p_init_msg_list,
7492: P_single_txn_date_flag => 'N',
7496: x_return_status => x_return_status,
7497: x_msg_count => x_msg_count,
7498: x_msg_data => x_msg_data
7499: );
7500: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);
7501: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
7502: THEN
7503: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');
7504: l_msg_index := 1;
7725: l_msg_index NUMBER;
7726: l_line_count NUMBER;
7727: l_flag VARCHAR2(1):='N';
7728: l_transaction_type VARCHAR2(10) := NULL;
7729: l_old_oks_cp_rec oks_ibint_pub.cp_rec_type;
7730: l_new_oks_cp_rec oks_ibint_pub.cp_rec_type;
7731: l_contracts_status VARCHAR2(3);
7732: l_owner_party_id NUMBER;
7733: l_transaction_date DATE ;
7726: l_line_count NUMBER;
7727: l_flag VARCHAR2(1):='N';
7728: l_transaction_type VARCHAR2(10) := NULL;
7729: l_old_oks_cp_rec oks_ibint_pub.cp_rec_type;
7730: l_new_oks_cp_rec oks_ibint_pub.cp_rec_type;
7731: l_contracts_status VARCHAR2(3);
7732: l_owner_party_id NUMBER;
7733: l_transaction_date DATE ;
7734: l_internal_party_id NUMBER;
7959: --
7960: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
7961: l_child_exists VARCHAR2(1);
7962: --
7963: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
7964: l_batch_id NUMBER;
7965: l_batch_type VARCHAR2(50);
7966: --
7967: SKIP_ERROR EXCEPTION;
9105: UPDATE CSI_TRANSACTIONS
9106: set contracts_invoked = 'Y'
9107: where transaction_id = p_txn_rec.transaction_id;
9108: --
9109: OKS_IBINT_PUB.IB_interface
9110: (
9111: P_Api_Version => 1.0,
9112: P_init_msg_list => p_init_msg_list,
9113: P_single_txn_date_flag => 'N',
9117: x_return_status => x_return_status,
9118: x_msg_count => x_msg_count,
9119: x_msg_data => x_msg_data
9120: );
9121: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);
9122: --
9123: IF x_return_status = 'W' THEN -- Warning from OKS
9124: -- Since OKS does not have the ability to pass the instance_id for the warning record(s),
9125: -- we are not populating the grp error tbl. We are still looping thru' the message stack
9256: l_msg_count NUMBER;
9257: l_iface_error_text VARCHAR2(2000);
9258: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
9259: l_instance_rec csi_datastructures_pub.instance_rec;
9260: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;
9261: l_batch_type VARCHAR2(50);
9262: l_batch_id NUMBER;
9263: --
9264: BEGIN
9376: UPDATE CSI_TRANSACTIONS
9377: set contracts_invoked = 'Y'
9378: where transaction_id = p_txn_rec.transaction_id;
9379: --
9380: OKS_IBINT_PUB.IB_interface
9381: (
9382: P_Api_Version => 1.0,
9383: P_init_msg_list => p_init_msg_list,
9384: P_single_txn_date_flag => 'N',
9388: x_return_status => x_return_status,
9389: x_msg_count => x_msg_count,
9390: x_msg_data => x_msg_data
9391: );
9392: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);
9393: --
9394: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
9395: THEN
9396: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');