5:
6: G_APP_ID CONSTANT NUMBER := 695;
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_PAYMENTS_PUB';
8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpypyb.pls';
9: G_LOGIN_ID NUMBER; -- := FND_GLOBAL.Conc_Login_Id;
10: G_PROGRAM_ID NUMBER; -- := FND_GLOBAL.Conc_Program_Id;
11: G_USER_ID NUMBER; -- := FND_GLOBAL.User_Id;
12: G_REQUEST_ID NUMBER; -- := FND_GLOBAL.Conc_Request_Id;
13: G_ONLINE_CCPAY varchar2(5) := NVL(fnd_profile.value('IEX_ONLINE_CCPAY'),'N'); -- Fix a bug 5897567
6: G_APP_ID CONSTANT NUMBER := 695;
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_PAYMENTS_PUB';
8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpypyb.pls';
9: G_LOGIN_ID NUMBER; -- := FND_GLOBAL.Conc_Login_Id;
10: G_PROGRAM_ID NUMBER; -- := FND_GLOBAL.Conc_Program_Id;
11: G_USER_ID NUMBER; -- := FND_GLOBAL.User_Id;
12: G_REQUEST_ID NUMBER; -- := FND_GLOBAL.Conc_Request_Id;
13: G_ONLINE_CCPAY varchar2(5) := NVL(fnd_profile.value('IEX_ONLINE_CCPAY'),'N'); -- Fix a bug 5897567
14:
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_PAYMENTS_PUB';
8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpypyb.pls';
9: G_LOGIN_ID NUMBER; -- := FND_GLOBAL.Conc_Login_Id;
10: G_PROGRAM_ID NUMBER; -- := FND_GLOBAL.Conc_Program_Id;
11: G_USER_ID NUMBER; -- := FND_GLOBAL.User_Id;
12: G_REQUEST_ID NUMBER; -- := FND_GLOBAL.Conc_Request_Id;
13: G_ONLINE_CCPAY varchar2(5) := NVL(fnd_profile.value('IEX_ONLINE_CCPAY'),'N'); -- Fix a bug 5897567
14:
15:
8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpypyb.pls';
9: G_LOGIN_ID NUMBER; -- := FND_GLOBAL.Conc_Login_Id;
10: G_PROGRAM_ID NUMBER; -- := FND_GLOBAL.Conc_Program_Id;
11: G_USER_ID NUMBER; -- := FND_GLOBAL.User_Id;
12: G_REQUEST_ID NUMBER; -- := FND_GLOBAL.Conc_Request_Id;
13: G_ONLINE_CCPAY varchar2(5) := NVL(fnd_profile.value('IEX_ONLINE_CCPAY'),'N'); -- Fix a bug 5897567
14:
15:
16: procedure validate_input(
814: P_PAYMENT_ID => l_payment_id,
815: P_OBJECT_VERSION_NUMBER => 1.0,
816: P_PROGRAM_ID => 695,
817: P_LAST_UPDATE_DATE => sysdate,
818: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
819: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
820: P_CREATION_DATE => sysdate,
821: P_CREATED_BY => FND_GLOBAL.User_Id,
822: P_PAYMENT_METHOD_ID => null,
817: P_LAST_UPDATE_DATE => sysdate,
818: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
819: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
820: P_CREATION_DATE => sysdate,
821: P_CREATED_BY => FND_GLOBAL.User_Id,
822: P_PAYMENT_METHOD_ID => null,
823: P_PAYMENT_METHOD => P_PMTINSTR_REC.USE_INSTRUMENT,
824: P_IPAYMENT_TRANS_ID => null,
825: P_IPAYMENT_STATUS => null,
1086: IEX_PAY_RECEIPT_XREF_PKG.INSERT_ROW(
1087: X_ROWID => l_rowid,
1088: P_PAY_RECEIPT_XREF_ID => l_pay_receipt_ref_id,
1089: P_LAST_UPDATE_DATE => sysdate,
1090: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1091: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1092: P_CREATION_DATE => sysdate,
1093: P_CREATED_BY => FND_GLOBAL.User_Id,
1094: P_PROGRAM_ID => 695,
1089: P_LAST_UPDATE_DATE => sysdate,
1090: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1091: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1092: P_CREATION_DATE => sysdate,
1093: P_CREATED_BY => FND_GLOBAL.User_Id,
1094: P_PROGRAM_ID => 695,
1095: P_OBJECT_VERSION_NUMBER => 1.0,
1096: P_PAYMENT_ID => l_payment_id,
1097: P_CASH_RECEIPT_ID => l_cr_id);
1373: IEX_DEL_PAY_XREF_PKG.INSERT_ROW(
1374: X_ROWID => l_rowid,
1375: P_DEL_PAY_ID => l_del_pay_ref_id,
1376: P_LAST_UPDATE_DATE => sysdate,
1377: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1378: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1379: P_CREATION_DATE => sysdate,
1380: P_CREATED_BY => FND_GLOBAL.User_Id,
1381: P_PROGRAM_ID => 695,
1376: P_LAST_UPDATE_DATE => sysdate,
1377: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1378: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1379: P_CREATION_DATE => sysdate,
1380: P_CREATED_BY => FND_GLOBAL.User_Id,
1381: P_PROGRAM_ID => 695,
1382: P_OBJECT_VERSION_NUMBER => 1.0,
1383: P_DELINQUENCY_ID => l_del_id,
1384: P_PAYMENT_ID => l_payment_id);
1405: IEX_PAY_RECEIPT_XREF_PKG.Insert_Row(
1406: X_ROWID => l_rowid,
1407: P_PAY_RECEIPT_XREF_ID => l_pay_receipt_ref_id,
1408: P_LAST_UPDATE_DATE => sysdate,
1409: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1410: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1411: P_CREATION_DATE => sysdate,
1412: P_CREATED_BY => FND_GLOBAL.User_Id,
1413: P_PROGRAM_ID => 695,
1408: P_LAST_UPDATE_DATE => sysdate,
1409: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1410: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1411: P_CREATION_DATE => sysdate,
1412: P_CREATED_BY => FND_GLOBAL.User_Id,
1413: P_PROGRAM_ID => 695,
1414: P_OBJECT_VERSION_NUMBER => 1.0,
1415: P_PAYMENT_ID => l_payment_id,
1416: P_CASH_RECEIPT_ID => l_cr_id);
1521: IEX_DEL_PAY_XREF_PKG.INSERT_ROW(
1522: X_ROWID => l_rowid,
1523: P_DEL_PAY_ID => l_del_pay_ref_id,
1524: P_LAST_UPDATE_DATE => sysdate,
1525: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1526: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1527: P_CREATION_DATE => sysdate,
1528: P_CREATED_BY => FND_GLOBAL.User_Id,
1529: P_PROGRAM_ID => 695,
1524: P_LAST_UPDATE_DATE => sysdate,
1525: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1526: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1527: P_CREATION_DATE => sysdate,
1528: P_CREATED_BY => FND_GLOBAL.User_Id,
1529: P_PROGRAM_ID => 695,
1530: P_OBJECT_VERSION_NUMBER => 1.0,
1531: P_DELINQUENCY_ID => l_del_id,
1532: P_PAYMENT_ID => l_payment_id);
1555: IEX_PAY_RECEIPT_XREF_PKG.Insert_Row(
1556: X_ROWID => l_rowid,
1557: P_PAY_RECEIPT_XREF_ID => l_pay_receipt_ref_id,
1558: P_LAST_UPDATE_DATE => sysdate,
1559: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1560: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1561: P_CREATION_DATE => sysdate,
1562: P_CREATED_BY => FND_GLOBAL.User_Id,
1563: P_PROGRAM_ID => 695,
1558: P_LAST_UPDATE_DATE => sysdate,
1559: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1560: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1561: P_CREATION_DATE => sysdate,
1562: P_CREATED_BY => FND_GLOBAL.User_Id,
1563: P_PROGRAM_ID => 695,
1564: P_OBJECT_VERSION_NUMBER => 1.0,
1565: P_PAYMENT_ID => l_payment_id,
1566: P_CASH_RECEIPT_ID => l_cr_id);
2423: P_PAYMENT_ID => l_payment_id,
2424: P_OBJECT_VERSION_NUMBER => 1.0,
2425: P_PROGRAM_ID => 695,
2426: P_LAST_UPDATE_DATE => sysdate,
2427: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
2428: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2429: P_CREATION_DATE => sysdate,
2430: P_CREATED_BY => FND_GLOBAL.User_Id,
2431: P_PAYMENT_METHOD_ID => l_pmtinstr_rec.PmtInstr_ID,
2426: P_LAST_UPDATE_DATE => sysdate,
2427: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
2428: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2429: P_CREATION_DATE => sysdate,
2430: P_CREATED_BY => FND_GLOBAL.User_Id,
2431: P_PAYMENT_METHOD_ID => l_pmtinstr_rec.PmtInstr_ID,
2432: P_PAYMENT_METHOD => P_PMTINSTR_REC.USE_INSTRUMENT,
2433: P_IPAYMENT_TRANS_ID => l_reqresp_rec.trxn_id,
2434: P_IPAYMENT_STATUS => l_reqresp_rec.response.status,
2561: IEX_PAY_OKL_XREF_PKG.Insert_Row(
2562: X_ROWID => l_rowid,
2563: P_PAY_OKL_XREF_ID => l_pay_okl_ref_id,
2564: P_LAST_UPDATE_DATE => sysdate,
2565: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
2566: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2567: P_CREATION_DATE => sysdate,
2568: P_CREATED_BY => FND_GLOBAL.User_Id,
2569: P_PROGRAM_ID => 695,
2564: P_LAST_UPDATE_DATE => sysdate,
2565: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
2566: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2567: P_CREATION_DATE => sysdate,
2568: P_CREATED_BY => FND_GLOBAL.User_Id,
2569: P_PROGRAM_ID => 695,
2570: P_OBJECT_VERSION_NUMBER => 1.0,
2571: P_PAYMENT_ID => l_payment_id,
2572: P_CNSLD_INVOICE_ID => P_PMTDTLS_TBL(i).CNSLD_INVOICE_ID,
2635: IEX_PAY_OKL_XREF_PKG.Insert_Row(
2636: X_ROWID => l_rowid,
2637: P_PAY_OKL_XREF_ID => l_pay_okl_ref_id,
2638: P_LAST_UPDATE_DATE => sysdate,
2639: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
2640: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2641: P_CREATION_DATE => sysdate,
2642: P_CREATED_BY => FND_GLOBAL.User_Id,
2643: P_PROGRAM_ID => 695,
2638: P_LAST_UPDATE_DATE => sysdate,
2639: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
2640: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2641: P_CREATION_DATE => sysdate,
2642: P_CREATED_BY => FND_GLOBAL.User_Id,
2643: P_PROGRAM_ID => 695,
2644: P_OBJECT_VERSION_NUMBER => 1.0,
2645: P_PAYMENT_ID => l_payment_id,
2646: p_CNSLD_INVOICE_ID => null,
2887: END IF;
2888: END;
2889: begin
2890: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2891: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
2892: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
2893: G_USER_ID := FND_GLOBAL.User_Id;
2894: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
2895: END ;
2888: END;
2889: begin
2890: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2891: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
2892: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
2893: G_USER_ID := FND_GLOBAL.User_Id;
2894: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
2895: END ;
2889: begin
2890: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2891: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
2892: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
2893: G_USER_ID := FND_GLOBAL.User_Id;
2894: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
2895: END ;
2890: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2891: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
2892: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
2893: G_USER_ID := FND_GLOBAL.User_Id;
2894: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
2895: END ;