148:
149: -- Get org Id for the contract
150: --l_return_status := get_org_id(p_contract_id, l_org_id);
151:
152: l_org_id :=mo_global.get_current_org_id();
153: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
154: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
155: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
156: RAISE okl_api.G_EXCEPTION_ERROR;
366: RAISE okl_api.G_EXCEPTION_ERROR;
367: END IF;
368:
369: -- Get org Id for OKL
370: l_org_id :=mo_global.get_current_org_id();
371:
372: -- get payment method
373: OPEN get_receipt_method_csr(p_payment_method_id);
374: FETCH get_receipt_method_csr INTO l_check;
548: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
549: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
550: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
551: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_rec.PAYMENT_DATE);
552: l_org_id Number DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
553: l_rcpt_rec rcpt_rec_type;
554: l_appl_tbl appl_tbl_type;
555: l_customer_trx_id NUMBER;
556: l_payment_trxn_extension_id NUMBER;
733: END IF;
734:
735: IF l_org_id IS NOT NULL THEN
736: l_rcpt_rec.org_id := l_org_id;
737: mo_global.init('M');
738: MO_GLOBAL.set_policy_context('S',l_org_id);
739: END IF;
740:
741:
734:
735: IF l_org_id IS NOT NULL THEN
736: l_rcpt_rec.org_id := l_org_id;
737: mo_global.init('M');
738: MO_GLOBAL.set_policy_context('S',l_org_id);
739: END IF;
740:
741:
742: OPEN c_get_payment_channel(l_payment_trxn_extension_id);
807: IF l_msg_data is NULL Then
808: EXIT;
809: END if;
810: END loop;
811: MO_GLOBAL.set_policy_context('M',-1);
812: x_return_status := l_return_status;
813:
814: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;