The following lines contain the word 'select', 'insert', 'update' or 'delete':
select PARTY_NAME
from hz_parties
where party_id = p_party_id;
iex_debug_pub.LogMessage(l_api_name || ': Creating/selecting bank branch...');
select IEX_PAYMENTS_S.NEXTVAL from dual;
select IEX_DEL_PAY_XREF_S.NEXTVAL from dual;
select IEX_PAY_RECEIPT_XREF_S.NEXTVAL from dual;
select IEX_RECEIPT_NUMBER_S.NEXTVAL from dual;
select delinquency_id
from iex_delinquencies
where payment_schedule_id = p_payment_schedule_id;
iex_debug_pub.LogMessage(l_api_name || ': Before IEX_PAYMENTS_PKG.Insert_Row');
IEX_PAYMENTS_PKG.Insert_Row(
X_ROWID => l_rowid,
P_PAYMENT_ID => l_payment_id,
P_OBJECT_VERSION_NUMBER => 1.0,
P_PROGRAM_ID => 695,
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
P_CREATION_DATE => sysdate,
P_CREATED_BY => FND_GLOBAL.User_Id,
P_PAYMENT_METHOD_ID => null,
P_PAYMENT_METHOD => P_PMTINSTR_REC.USE_INSTRUMENT,
P_IPAYMENT_TRANS_ID => null,
P_IPAYMENT_STATUS => null,
P_PAY_SVR_CONFIRMATION => null,
P_CAMPAIGN_SCHED_ID => P_PMT_REC.CAMPAIGN_SCHED_ID,
p_TANGIBLE_ID => null,
p_PAYEE_ID => null,
p_RESOURCE_ID => P_PMT_REC.RESOURCE_ID,
P_ATTRIBUTE_CATEGORY => P_PMT_REC.ATTRIBUTES.ATTRIBUTE_CATEGORY,
P_ATTRIBUTE1 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE1,
P_ATTRIBUTE2 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE2,
P_ATTRIBUTE3 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE3,
P_ATTRIBUTE4 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE4,
P_ATTRIBUTE5 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE5,
P_ATTRIBUTE6 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE6,
P_ATTRIBUTE7 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE7,
P_ATTRIBUTE8 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE8,
P_ATTRIBUTE9 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE9,
P_ATTRIBUTE10 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE10,
P_ATTRIBUTE11 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE11,
P_ATTRIBUTE12 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE12,
P_ATTRIBUTE13 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE13,
P_ATTRIBUTE14 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE14,
P_ATTRIBUTE15 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE15);
iex_debug_pub.LogMessage(l_api_name || ': After IEX_PAYMENTS_PKG.Insert_Row');
iex_debug_pub.LogMessage(l_api_name || ': Before call to IEX_PAY_RECEIPT_XREF_PKG.INSERT_ROW');
IEX_PAY_RECEIPT_XREF_PKG.INSERT_ROW(
X_ROWID => l_rowid,
P_PAY_RECEIPT_XREF_ID => l_pay_receipt_ref_id,
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
P_CREATION_DATE => sysdate,
P_CREATED_BY => FND_GLOBAL.User_Id,
P_PROGRAM_ID => 695,
P_OBJECT_VERSION_NUMBER => 1.0,
P_PAYMENT_ID => l_payment_id,
P_CASH_RECEIPT_ID => l_cr_id);
iex_debug_pub.LogMessage(l_api_name || ': After call to IEX_PAY_RECEIPT_XREF_PKG.INSERT_ROW');
iex_debug_pub.LogMessage(l_api_name || ': Delinquency found. Going to insert row into IEX_DEL_PAY_XREF table');
iex_debug_pub.LogMessage(l_api_name || ': Before IEX_DEL_PAY_XREF_PKG.INSERT_ROW');
IEX_DEL_PAY_XREF_PKG.INSERT_ROW(
X_ROWID => l_rowid,
P_DEL_PAY_ID => l_del_pay_ref_id,
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
P_CREATION_DATE => sysdate,
P_CREATED_BY => FND_GLOBAL.User_Id,
P_PROGRAM_ID => 695,
P_OBJECT_VERSION_NUMBER => 1.0,
P_DELINQUENCY_ID => l_del_id,
P_PAYMENT_ID => l_payment_id);
iex_debug_pub.LogMessage(l_api_name || ': After call to IEX_DEL_PAY_XREF_PKG.INSERT_ROW');
iex_debug_pub.LogMessage(l_api_name || ': Before IEX_DEL_PAY_XREF_PKG.INSERT_ROW');
IEX_PAY_RECEIPT_XREF_PKG.Insert_Row(
X_ROWID => l_rowid,
P_PAY_RECEIPT_XREF_ID => l_pay_receipt_ref_id,
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
P_CREATION_DATE => sysdate,
P_CREATED_BY => FND_GLOBAL.User_Id,
P_PROGRAM_ID => 695,
P_OBJECT_VERSION_NUMBER => 1.0,
P_PAYMENT_ID => l_payment_id,
P_CASH_RECEIPT_ID => l_cr_id);
iex_debug_pub.LogMessage(l_api_name || ': After IEX_DEL_PAY_XREF_PKG.INSERT_ROW');
iex_debug_pub.LogMessage(l_api_name || ': Delinquency found. Going to insert row into IEX_DEL_PAY_XREF table');
iex_debug_pub.LogMessage(l_api_name || ': Before IEX_DEL_PAY_XREF_PKG.INSERT_ROW');
IEX_DEL_PAY_XREF_PKG.INSERT_ROW(
X_ROWID => l_rowid,
P_DEL_PAY_ID => l_del_pay_ref_id,
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
P_CREATION_DATE => sysdate,
P_CREATED_BY => FND_GLOBAL.User_Id,
P_PROGRAM_ID => 695,
P_OBJECT_VERSION_NUMBER => 1.0,
P_DELINQUENCY_ID => l_del_id,
P_PAYMENT_ID => l_payment_id);
iex_debug_pub.LogMessage(l_api_name || ': After call to IEX_DEL_PAY_XREF_PKG.INSERT_ROW');
iex_debug_pub.LogMessage(l_api_name || ': Before IEX_DEL_PAY_XREF_PKG.INSERT_ROW');
IEX_PAY_RECEIPT_XREF_PKG.Insert_Row(
X_ROWID => l_rowid,
P_PAY_RECEIPT_XREF_ID => l_pay_receipt_ref_id,
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
P_CREATION_DATE => sysdate,
P_CREATED_BY => FND_GLOBAL.User_Id,
P_PROGRAM_ID => 695,
P_OBJECT_VERSION_NUMBER => 1.0,
P_PAYMENT_ID => l_payment_id,
P_CASH_RECEIPT_ID => l_cr_id);
iex_debug_pub.LogMessage(l_api_name || ': After IEX_DEL_PAY_XREF_PKG.INSERT_ROW');
/* if note is passed - insert it */
if P_PMT_REC.NOTE is not null and l_note_type is not null then
IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
iex_debug_pub.LogMessage(l_api_name || ': Note is not null');
select IEX_PAYMENTS_S.NEXTVAL from dual;
select IEX_IPAYMENT_TANGIBLE_S.NEXTVAL from dual;
select iex_pay_okl_xref_s.NEXTVAL from dual;
select INSTRID
from iby_bankacct_v
where
BANKID = p_BANKID and
BANKACCOUNTID = p_BANKACCOUNTID and
OWNERID = p_PAYER_ID;
select INSTRID
from iby_creditcard_v
where
CCNUMBER = p_CCNUMBER and
OWNERID = p_PAYER_ID;
iex_debug_pub.LogMessage(l_api_name || ': Going to insert new cc');
FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_INSERT_INSTR');
FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_UPDATE_INSTR');
iex_debug_pub.LogMessage(l_api_name || ': Going to insert new ba');
FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_INSERT_INSTR');
iex_debug_pub.LogMessage(l_api_name || ': Before IEX_PAYMENTS_PKG.Insert_Row');
IEX_PAYMENTS_PKG.Insert_Row(
X_ROWID => l_rowid,
P_PAYMENT_ID => l_payment_id,
P_OBJECT_VERSION_NUMBER => 1.0,
P_PROGRAM_ID => 695,
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
P_CREATION_DATE => sysdate,
P_CREATED_BY => FND_GLOBAL.User_Id,
P_PAYMENT_METHOD_ID => l_pmtinstr_rec.PmtInstr_ID,
P_PAYMENT_METHOD => P_PMTINSTR_REC.USE_INSTRUMENT,
P_IPAYMENT_TRANS_ID => l_reqresp_rec.trxn_id,
P_IPAYMENT_STATUS => l_reqresp_rec.response.status,
P_PAY_SVR_CONFIRMATION => l_reqresp_rec.AuthCode,
P_CAMPAIGN_SCHED_ID => P_PMT_REC.CAMPAIGN_SCHED_ID,
p_TANGIBLE_ID => l_tangible_rec.tangible_id,
p_PAYEE_ID => l_payee_rec.Payee_ID,
p_RESOURCE_ID => P_PMT_REC.RESOURCE_ID,
P_ATTRIBUTE_CATEGORY => P_PMT_REC.ATTRIBUTES.ATTRIBUTE_CATEGORY,
P_ATTRIBUTE1 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE1,
P_ATTRIBUTE2 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE2,
P_ATTRIBUTE3 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE3,
P_ATTRIBUTE4 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE4,
P_ATTRIBUTE5 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE5,
P_ATTRIBUTE6 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE6,
P_ATTRIBUTE7 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE7,
P_ATTRIBUTE8 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE8,
P_ATTRIBUTE9 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE9,
P_ATTRIBUTE10 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE10,
P_ATTRIBUTE11 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE11,
P_ATTRIBUTE12 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE12,
P_ATTRIBUTE13 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE13,
P_ATTRIBUTE14 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE14,
P_ATTRIBUTE15 => P_PMT_REC.ATTRIBUTES.ATTRIBUTE15);
iex_debug_pub.LogMessage(l_api_name || ': After IEX_PAYMENTS_PKG.Insert_Row');
iex_debug_pub.LogMessage(l_api_name || ': Before IEX_PAY_OKL_XREF_PKG.INSERT_ROW');
IEX_PAY_OKL_XREF_PKG.Insert_Row(
X_ROWID => l_rowid,
P_PAY_OKL_XREF_ID => l_pay_okl_ref_id,
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
P_CREATION_DATE => sysdate,
P_CREATED_BY => FND_GLOBAL.User_Id,
P_PROGRAM_ID => 695,
P_OBJECT_VERSION_NUMBER => 1.0,
P_PAYMENT_ID => l_payment_id,
P_CNSLD_INVOICE_ID => P_PMTDTLS_TBL(i).CNSLD_INVOICE_ID,
P_CONTRACT_ID => null,
P_OKL_PAYMENT_ID => l_pay_okl_cnsld_id_tab(i));
iex_debug_pub.LogMessage(l_api_name || ': After IEX_PAY_OKL_XREF_PKG.INSERT_ROW');
iex_debug_pub.LogMessage(l_api_name || ': Before IEX_PAY_OKL_XREF_PKG.INSERT_ROW');
IEX_PAY_OKL_XREF_PKG.Insert_Row(
X_ROWID => l_rowid,
P_PAY_OKL_XREF_ID => l_pay_okl_ref_id,
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
P_CREATION_DATE => sysdate,
P_CREATED_BY => FND_GLOBAL.User_Id,
P_PROGRAM_ID => 695,
P_OBJECT_VERSION_NUMBER => 1.0,
P_PAYMENT_ID => l_payment_id,
p_CNSLD_INVOICE_ID => null,
P_CONTRACT_ID => P_PMTDTLS_TBL(i).CONTRACT_ID,
p_OKL_PAYMENT_ID => l_pay_okl_contract_id_tab(i));
iex_debug_pub.LogMessage(l_api_name || ': After IEX_PAY_OKL_XREF_PKG.INSERT_ROW');
-- if note is passed - insert it
if P_PMT_REC.NOTE is not null and l_note_type is not null then
IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
iex_debug_pub.LogMessage(l_api_name || ': Note is not null');