eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_PAYMENTS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 389


        select PARTY_NAME
		from hz_parties
		where party_id = p_party_id;

Line: 612


	iex_debug_pub.LogMessage(l_api_name || ': Creating/selecting bank branch...');

Line: 710


    select IEX_PAYMENTS_S.NEXTVAL from dual;

Line: 714


    select IEX_DEL_PAY_XREF_S.NEXTVAL from dual;

Line: 718


    select IEX_PAY_RECEIPT_XREF_S.NEXTVAL from dual;

Line: 722


    select IEX_RECEIPT_NUMBER_S.NEXTVAL from dual;

Line: 726


    select delinquency_id
    from iex_delinquencies
    where payment_schedule_id = p_payment_schedule_id;

Line: 809


	    iex_debug_pub.LogMessage(l_api_name || ': Before IEX_PAYMENTS_PKG.Insert_Row');

Line: 812


	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);

Line: 849


    	   iex_debug_pub.LogMessage(l_api_name || ': After IEX_PAYMENTS_PKG.Insert_Row');

Line: 1083


		    iex_debug_pub.LogMessage(l_api_name || ': Before call to IEX_PAY_RECEIPT_XREF_PKG.INSERT_ROW');

Line: 1086


		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);

Line: 1102


		    iex_debug_pub.LogMessage(l_api_name || ': After call to IEX_PAY_RECEIPT_XREF_PKG.INSERT_ROW');

Line: 1361


			iex_debug_pub.LogMessage(l_api_name || ': Delinquency found. Going to insert row into IEX_DEL_PAY_XREF table');

Line: 1370


			iex_debug_pub.LogMessage(l_api_name || ': Before IEX_DEL_PAY_XREF_PKG.INSERT_ROW');

Line: 1373


		    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);

Line: 1387


			iex_debug_pub.LogMessage(l_api_name || ': After call to IEX_DEL_PAY_XREF_PKG.INSERT_ROW');

Line: 1402


		iex_debug_pub.LogMessage(l_api_name || ': Before IEX_DEL_PAY_XREF_PKG.INSERT_ROW');

Line: 1405


	    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);

Line: 1419


		iex_debug_pub.LogMessage(l_api_name || ': After IEX_DEL_PAY_XREF_PKG.INSERT_ROW');

Line: 1509


			iex_debug_pub.LogMessage(l_api_name || ': Delinquency found. Going to insert row into IEX_DEL_PAY_XREF table');

Line: 1518


			iex_debug_pub.LogMessage(l_api_name || ': Before IEX_DEL_PAY_XREF_PKG.INSERT_ROW');

Line: 1521


		    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);

Line: 1535


			iex_debug_pub.LogMessage(l_api_name || ': After call to IEX_DEL_PAY_XREF_PKG.INSERT_ROW');

Line: 1552


		iex_debug_pub.LogMessage(l_api_name || ': Before IEX_DEL_PAY_XREF_PKG.INSERT_ROW');

Line: 1555


	    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);

Line: 1571


		iex_debug_pub.LogMessage(l_api_name || ': After IEX_DEL_PAY_XREF_PKG.INSERT_ROW');

Line: 1624


	/* 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');

Line: 1820


   	select IEX_PAYMENTS_S.NEXTVAL from dual;

Line: 1824


   	select IEX_IPAYMENT_TANGIBLE_S.NEXTVAL from dual;

Line: 1828


   	select iex_pay_okl_xref_s.NEXTVAL from dual;

Line: 1833


		select INSTRID
		from iby_bankacct_v
		where
		BANKID = p_BANKID and
		BANKACCOUNTID = p_BANKACCOUNTID and
		OWNERID = p_PAYER_ID;

Line: 1842


		select INSTRID
		from iby_creditcard_v
		where
		CCNUMBER = p_CCNUMBER and
		OWNERID = p_PAYER_ID;

Line: 1956


			iex_debug_pub.LogMessage(l_api_name || ': Going to insert new cc');

Line: 1993


				FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_INSERT_INSTR');

Line: 2038


				FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_UPDATE_INSTR');

Line: 2089


			iex_debug_pub.LogMessage(l_api_name || ': Going to insert new ba');

Line: 2126


				FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_INSERT_INSTR');

Line: 2419


	iex_debug_pub.LogMessage(l_api_name || ': Before IEX_PAYMENTS_PKG.Insert_Row');

Line: 2421


    	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);

Line: 2458


	   iex_debug_pub.LogMessage(l_api_name || ': After IEX_PAYMENTS_PKG.Insert_Row');

Line: 2558


			iex_debug_pub.LogMessage(l_api_name || ': Before IEX_PAY_OKL_XREF_PKG.INSERT_ROW');

Line: 2561


        		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));

Line: 2577


			     iex_debug_pub.LogMessage(l_api_name || ': After IEX_PAY_OKL_XREF_PKG.INSERT_ROW');

Line: 2632


			     iex_debug_pub.LogMessage(l_api_name || ': Before IEX_PAY_OKL_XREF_PKG.INSERT_ROW');

Line: 2635


        		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));

Line: 2651


			     iex_debug_pub.LogMessage(l_api_name || ': After IEX_PAY_OKL_XREF_PKG.INSERT_ROW');

Line: 2699


	-- 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');