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.IBY_INSTRREG_PUB dependencies on IBY_NETUTILS_PVT

Line 295: l_names IBY_NETUTILS_PVT.v240_tbl_type;

291:
292: l_pos NUMBER := 0;
293: l_post_body VARCHAR2(30000);
294: l_html VARCHAR2(32767) ;
295: l_names IBY_NETUTILS_PVT.v240_tbl_type;
296: l_values IBY_NETUTILS_PVT.v240_tbl_type;
297:
298: l_status NUMBER := 0;
299: l_errcode NUMBER := 0;

Line 296: l_values IBY_NETUTILS_PVT.v240_tbl_type;

292: l_pos NUMBER := 0;
293: l_post_body VARCHAR2(30000);
294: l_html VARCHAR2(32767) ;
295: l_names IBY_NETUTILS_PVT.v240_tbl_type;
296: l_values IBY_NETUTILS_PVT.v240_tbl_type;
297:
298: l_status NUMBER := 0;
299: l_errcode NUMBER := 0;
300: l_index NUMBER := 1;

Line 383: --IBY_NETUTILS_PVT.get_baseurl(l_get_baseurl);

379:
380: END IF;
381:
382: -- Finally call the procedures that will add the instrument.
383: --IBY_NETUTILS_PVT.get_baseurl(l_get_baseurl);
384:
385: IBY_NETUTILS_PVT.get_baseurl(l_get_baseurl);
386:
387: iby_debug_pub.add('GetBaseUrl :' || l_get_baseurl,

Line 385: IBY_NETUTILS_PVT.get_baseurl(l_get_baseurl);

381:
382: -- Finally call the procedures that will add the instrument.
383: --IBY_NETUTILS_PVT.get_baseurl(l_get_baseurl);
384:
385: IBY_NETUTILS_PVT.get_baseurl(l_get_baseurl);
386:
387: iby_debug_pub.add('GetBaseUrl :' || l_get_baseurl,
388: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
389:

Line 393: l_db_nls := IBY_NETUTILS_PVT.get_local_nls();

389:
390: -- Construct the full URL to send to the ECServlet.
391: l_url := l_get_baseurl;
392:
393: l_db_nls := IBY_NETUTILS_PVT.get_local_nls();
394: l_ecapp_nls := NULL; -- not passed in this api??
395:
396: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);
397: IF ( l_instrument_type <> C_INSTRTYPE_UNREG) THEN

Line 396: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);

392:
393: l_db_nls := IBY_NETUTILS_PVT.get_local_nls();
394: l_ecapp_nls := NULL; -- not passed in this api??
395:
396: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);
397: IF ( l_instrument_type <> C_INSTRTYPE_UNREG) THEN
398: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrType', l_instrument_type, l_url, l_db_nls, l_ecapp_nls);
399: END IF;
400:

Line 398: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrType', l_instrument_type, l_url, l_db_nls, l_ecapp_nls);

394: l_ecapp_nls := NULL; -- not passed in this api??
395:
396: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);
397: IF ( l_instrument_type <> C_INSTRTYPE_UNREG) THEN
398: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrType', l_instrument_type, l_url, l_db_nls, l_ecapp_nls);
399: END IF;
400:
401: -- lmallick: PA-DSS fixes
402: -- For IMMEDIATE mode of encryption, pass the login_id and user_id to the

Line 405: IBY_NETUTILS_PVT.check_mandatory('OapfLoginId', fnd_global.login_id, l_url, l_db_nls, l_ecapp_nls);

401: -- lmallick: PA-DSS fixes
402: -- For IMMEDIATE mode of encryption, pass the login_id and user_id to the
403: -- ecapp servlet. This would ensure that the audit trail is maintained even when the
404: -- requested is routed through the ecapp servlet
405: IBY_NETUTILS_PVT.check_mandatory('OapfLoginId', fnd_global.login_id, l_url, l_db_nls, l_ecapp_nls);
406: IBY_NETUTILS_PVT.check_mandatory('OapfUserId', fnd_global.user_id, l_url, l_db_nls, l_ecapp_nls);
407:
408:
409: IF ( l_instrument_type = C_INSTRTYPE_BANKACCT) THEN

Line 406: IBY_NETUTILS_PVT.check_mandatory('OapfUserId', fnd_global.user_id, l_url, l_db_nls, l_ecapp_nls);

402: -- For IMMEDIATE mode of encryption, pass the login_id and user_id to the
403: -- ecapp servlet. This would ensure that the audit trail is maintained even when the
404: -- requested is routed through the ecapp servlet
405: IBY_NETUTILS_PVT.check_mandatory('OapfLoginId', fnd_global.login_id, l_url, l_db_nls, l_ecapp_nls);
406: IBY_NETUTILS_PVT.check_mandatory('OapfUserId', fnd_global.user_id, l_url, l_db_nls, l_ecapp_nls);
407:
408:
409: IF ( l_instrument_type = C_INSTRTYPE_BANKACCT) THEN
410: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderType, l_url, l_db_nls, l_ecapp_nls);

Line 410: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderType, l_url, l_db_nls, l_ecapp_nls);

406: IBY_NETUTILS_PVT.check_mandatory('OapfUserId', fnd_global.user_id, l_url, l_db_nls, l_ecapp_nls);
407:
408:
409: IF ( l_instrument_type = C_INSTRTYPE_BANKACCT) THEN
410: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderType, l_url, l_db_nls, l_ecapp_nls);
411: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.BankAcctInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
412: IBY_NETUTILS_PVT.check_mandatory('OapfInstrBankId', p_pmtInstrRec.BankAcctInstr.Branch_ID, l_url, l_db_nls, l_ecapp_nls);
413: IBY_NETUTILS_PVT.check_optional('OapfInstrBankSwiftCode', p_pmtInstrRec.BankAcctInstr.Bank_SwiftCode, l_url, l_db_nls, l_ecapp_nls);
414: IBY_NETUTILS_PVT.check_optional('OapfInstrBranchId', p_pmtInstrRec.BankAcctInstr.Bank_ID, l_url, l_db_nls, l_ecapp_nls);

Line 411: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.BankAcctInstr.FIName, l_url, l_db_nls, l_ecapp_nls);

407:
408:
409: IF ( l_instrument_type = C_INSTRTYPE_BANKACCT) THEN
410: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderType, l_url, l_db_nls, l_ecapp_nls);
411: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.BankAcctInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
412: IBY_NETUTILS_PVT.check_mandatory('OapfInstrBankId', p_pmtInstrRec.BankAcctInstr.Branch_ID, l_url, l_db_nls, l_ecapp_nls);
413: IBY_NETUTILS_PVT.check_optional('OapfInstrBankSwiftCode', p_pmtInstrRec.BankAcctInstr.Bank_SwiftCode, l_url, l_db_nls, l_ecapp_nls);
414: IBY_NETUTILS_PVT.check_optional('OapfInstrBranchId', p_pmtInstrRec.BankAcctInstr.Bank_ID, l_url, l_db_nls, l_ecapp_nls);
415: IBY_NETUTILS_PVT.check_optional('OapfInstrAcctType', p_pmtInstrRec.BankAcctInstr.BankAcct_Type, l_url, l_db_nls, l_ecapp_nls);

Line 412: IBY_NETUTILS_PVT.check_mandatory('OapfInstrBankId', p_pmtInstrRec.BankAcctInstr.Branch_ID, l_url, l_db_nls, l_ecapp_nls);

408:
409: IF ( l_instrument_type = C_INSTRTYPE_BANKACCT) THEN
410: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderType, l_url, l_db_nls, l_ecapp_nls);
411: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.BankAcctInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
412: IBY_NETUTILS_PVT.check_mandatory('OapfInstrBankId', p_pmtInstrRec.BankAcctInstr.Branch_ID, l_url, l_db_nls, l_ecapp_nls);
413: IBY_NETUTILS_PVT.check_optional('OapfInstrBankSwiftCode', p_pmtInstrRec.BankAcctInstr.Bank_SwiftCode, l_url, l_db_nls, l_ecapp_nls);
414: IBY_NETUTILS_PVT.check_optional('OapfInstrBranchId', p_pmtInstrRec.BankAcctInstr.Bank_ID, l_url, l_db_nls, l_ecapp_nls);
415: IBY_NETUTILS_PVT.check_optional('OapfInstrAcctType', p_pmtInstrRec.BankAcctInstr.BankAcct_Type, l_url, l_db_nls, l_ecapp_nls);
416: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.BankAcctInstr.BankAcct_Num, l_url, l_db_nls, l_ecapp_nls);

Line 413: IBY_NETUTILS_PVT.check_optional('OapfInstrBankSwiftCode', p_pmtInstrRec.BankAcctInstr.Bank_SwiftCode, l_url, l_db_nls, l_ecapp_nls);

409: IF ( l_instrument_type = C_INSTRTYPE_BANKACCT) THEN
410: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderType, l_url, l_db_nls, l_ecapp_nls);
411: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.BankAcctInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
412: IBY_NETUTILS_PVT.check_mandatory('OapfInstrBankId', p_pmtInstrRec.BankAcctInstr.Branch_ID, l_url, l_db_nls, l_ecapp_nls);
413: IBY_NETUTILS_PVT.check_optional('OapfInstrBankSwiftCode', p_pmtInstrRec.BankAcctInstr.Bank_SwiftCode, l_url, l_db_nls, l_ecapp_nls);
414: IBY_NETUTILS_PVT.check_optional('OapfInstrBranchId', p_pmtInstrRec.BankAcctInstr.Bank_ID, l_url, l_db_nls, l_ecapp_nls);
415: IBY_NETUTILS_PVT.check_optional('OapfInstrAcctType', p_pmtInstrRec.BankAcctInstr.BankAcct_Type, l_url, l_db_nls, l_ecapp_nls);
416: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.BankAcctInstr.BankAcct_Num, l_url, l_db_nls, l_ecapp_nls);
417: IBY_NETUTILS_PVT.check_optional('OapfInstrCheckDigits', p_pmtInstrRec.BankAcctInstr.BankAcct_Checkdigits, l_url, l_db_nls, l_ecapp_nls);

Line 414: IBY_NETUTILS_PVT.check_optional('OapfInstrBranchId', p_pmtInstrRec.BankAcctInstr.Bank_ID, l_url, l_db_nls, l_ecapp_nls);

410: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderType, l_url, l_db_nls, l_ecapp_nls);
411: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.BankAcctInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
412: IBY_NETUTILS_PVT.check_mandatory('OapfInstrBankId', p_pmtInstrRec.BankAcctInstr.Branch_ID, l_url, l_db_nls, l_ecapp_nls);
413: IBY_NETUTILS_PVT.check_optional('OapfInstrBankSwiftCode', p_pmtInstrRec.BankAcctInstr.Bank_SwiftCode, l_url, l_db_nls, l_ecapp_nls);
414: IBY_NETUTILS_PVT.check_optional('OapfInstrBranchId', p_pmtInstrRec.BankAcctInstr.Bank_ID, l_url, l_db_nls, l_ecapp_nls);
415: IBY_NETUTILS_PVT.check_optional('OapfInstrAcctType', p_pmtInstrRec.BankAcctInstr.BankAcct_Type, l_url, l_db_nls, l_ecapp_nls);
416: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.BankAcctInstr.BankAcct_Num, l_url, l_db_nls, l_ecapp_nls);
417: IBY_NETUTILS_PVT.check_optional('OapfInstrCheckDigits', p_pmtInstrRec.BankAcctInstr.BankAcct_Checkdigits, l_url, l_db_nls, l_ecapp_nls);
418: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderName, l_url, l_db_nls, l_ecapp_nls);

Line 415: IBY_NETUTILS_PVT.check_optional('OapfInstrAcctType', p_pmtInstrRec.BankAcctInstr.BankAcct_Type, l_url, l_db_nls, l_ecapp_nls);

411: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.BankAcctInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
412: IBY_NETUTILS_PVT.check_mandatory('OapfInstrBankId', p_pmtInstrRec.BankAcctInstr.Branch_ID, l_url, l_db_nls, l_ecapp_nls);
413: IBY_NETUTILS_PVT.check_optional('OapfInstrBankSwiftCode', p_pmtInstrRec.BankAcctInstr.Bank_SwiftCode, l_url, l_db_nls, l_ecapp_nls);
414: IBY_NETUTILS_PVT.check_optional('OapfInstrBranchId', p_pmtInstrRec.BankAcctInstr.Bank_ID, l_url, l_db_nls, l_ecapp_nls);
415: IBY_NETUTILS_PVT.check_optional('OapfInstrAcctType', p_pmtInstrRec.BankAcctInstr.BankAcct_Type, l_url, l_db_nls, l_ecapp_nls);
416: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.BankAcctInstr.BankAcct_Num, l_url, l_db_nls, l_ecapp_nls);
417: IBY_NETUTILS_PVT.check_optional('OapfInstrCheckDigits', p_pmtInstrRec.BankAcctInstr.BankAcct_Checkdigits, l_url, l_db_nls, l_ecapp_nls);
418: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderName, l_url, l_db_nls, l_ecapp_nls);
419: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.BankAcctInstr.Bank_Desc, l_url, l_db_nls, l_ecapp_nls);

Line 416: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.BankAcctInstr.BankAcct_Num, l_url, l_db_nls, l_ecapp_nls);

412: IBY_NETUTILS_PVT.check_mandatory('OapfInstrBankId', p_pmtInstrRec.BankAcctInstr.Branch_ID, l_url, l_db_nls, l_ecapp_nls);
413: IBY_NETUTILS_PVT.check_optional('OapfInstrBankSwiftCode', p_pmtInstrRec.BankAcctInstr.Bank_SwiftCode, l_url, l_db_nls, l_ecapp_nls);
414: IBY_NETUTILS_PVT.check_optional('OapfInstrBranchId', p_pmtInstrRec.BankAcctInstr.Bank_ID, l_url, l_db_nls, l_ecapp_nls);
415: IBY_NETUTILS_PVT.check_optional('OapfInstrAcctType', p_pmtInstrRec.BankAcctInstr.BankAcct_Type, l_url, l_db_nls, l_ecapp_nls);
416: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.BankAcctInstr.BankAcct_Num, l_url, l_db_nls, l_ecapp_nls);
417: IBY_NETUTILS_PVT.check_optional('OapfInstrCheckDigits', p_pmtInstrRec.BankAcctInstr.BankAcct_Checkdigits, l_url, l_db_nls, l_ecapp_nls);
418: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderName, l_url, l_db_nls, l_ecapp_nls);
419: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.BankAcctInstr.Bank_Desc, l_url, l_db_nls, l_ecapp_nls);
420: IBY_NETUTILS_PVT.check_optional('OapfInstrCurrency', p_pmtInstrRec.BankAcctInstr.BankAcct_Currency, l_url, l_db_nls, l_ecapp_nls);

Line 417: IBY_NETUTILS_PVT.check_optional('OapfInstrCheckDigits', p_pmtInstrRec.BankAcctInstr.BankAcct_Checkdigits, l_url, l_db_nls, l_ecapp_nls);

413: IBY_NETUTILS_PVT.check_optional('OapfInstrBankSwiftCode', p_pmtInstrRec.BankAcctInstr.Bank_SwiftCode, l_url, l_db_nls, l_ecapp_nls);
414: IBY_NETUTILS_PVT.check_optional('OapfInstrBranchId', p_pmtInstrRec.BankAcctInstr.Bank_ID, l_url, l_db_nls, l_ecapp_nls);
415: IBY_NETUTILS_PVT.check_optional('OapfInstrAcctType', p_pmtInstrRec.BankAcctInstr.BankAcct_Type, l_url, l_db_nls, l_ecapp_nls);
416: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.BankAcctInstr.BankAcct_Num, l_url, l_db_nls, l_ecapp_nls);
417: IBY_NETUTILS_PVT.check_optional('OapfInstrCheckDigits', p_pmtInstrRec.BankAcctInstr.BankAcct_Checkdigits, l_url, l_db_nls, l_ecapp_nls);
418: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderName, l_url, l_db_nls, l_ecapp_nls);
419: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.BankAcctInstr.Bank_Desc, l_url, l_db_nls, l_ecapp_nls);
420: IBY_NETUTILS_PVT.check_optional('OapfInstrCurrency', p_pmtInstrRec.BankAcctInstr.BankAcct_Currency, l_url, l_db_nls, l_ecapp_nls);
421: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerAddrId', p_pmtInstrRec.BankAcctInstr.Acct_HolderAddrId, l_url, l_db_nls, l_ecapp_nls);

Line 418: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderName, l_url, l_db_nls, l_ecapp_nls);

414: IBY_NETUTILS_PVT.check_optional('OapfInstrBranchId', p_pmtInstrRec.BankAcctInstr.Bank_ID, l_url, l_db_nls, l_ecapp_nls);
415: IBY_NETUTILS_PVT.check_optional('OapfInstrAcctType', p_pmtInstrRec.BankAcctInstr.BankAcct_Type, l_url, l_db_nls, l_ecapp_nls);
416: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.BankAcctInstr.BankAcct_Num, l_url, l_db_nls, l_ecapp_nls);
417: IBY_NETUTILS_PVT.check_optional('OapfInstrCheckDigits', p_pmtInstrRec.BankAcctInstr.BankAcct_Checkdigits, l_url, l_db_nls, l_ecapp_nls);
418: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderName, l_url, l_db_nls, l_ecapp_nls);
419: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.BankAcctInstr.Bank_Desc, l_url, l_db_nls, l_ecapp_nls);
420: IBY_NETUTILS_PVT.check_optional('OapfInstrCurrency', p_pmtInstrRec.BankAcctInstr.BankAcct_Currency, l_url, l_db_nls, l_ecapp_nls);
421: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerAddrId', p_pmtInstrRec.BankAcctInstr.Acct_HolderAddrId, l_url, l_db_nls, l_ecapp_nls);
422: IF ( p_pmtInstrRec.BankAcctInstr.Bank_AddrId is NOT null ) THEN

Line 419: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.BankAcctInstr.Bank_Desc, l_url, l_db_nls, l_ecapp_nls);

415: IBY_NETUTILS_PVT.check_optional('OapfInstrAcctType', p_pmtInstrRec.BankAcctInstr.BankAcct_Type, l_url, l_db_nls, l_ecapp_nls);
416: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.BankAcctInstr.BankAcct_Num, l_url, l_db_nls, l_ecapp_nls);
417: IBY_NETUTILS_PVT.check_optional('OapfInstrCheckDigits', p_pmtInstrRec.BankAcctInstr.BankAcct_Checkdigits, l_url, l_db_nls, l_ecapp_nls);
418: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderName, l_url, l_db_nls, l_ecapp_nls);
419: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.BankAcctInstr.Bank_Desc, l_url, l_db_nls, l_ecapp_nls);
420: IBY_NETUTILS_PVT.check_optional('OapfInstrCurrency', p_pmtInstrRec.BankAcctInstr.BankAcct_Currency, l_url, l_db_nls, l_ecapp_nls);
421: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerAddrId', p_pmtInstrRec.BankAcctInstr.Acct_HolderAddrId, l_url, l_db_nls, l_ecapp_nls);
422: IF ( p_pmtInstrRec.BankAcctInstr.Bank_AddrId is NOT null ) THEN
423: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrId', p_pmtInstrRec.BankAcctInstr.Bank_AddrId, l_url, l_db_nls, l_ecapp_nls);

Line 420: IBY_NETUTILS_PVT.check_optional('OapfInstrCurrency', p_pmtInstrRec.BankAcctInstr.BankAcct_Currency, l_url, l_db_nls, l_ecapp_nls);

416: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.BankAcctInstr.BankAcct_Num, l_url, l_db_nls, l_ecapp_nls);
417: IBY_NETUTILS_PVT.check_optional('OapfInstrCheckDigits', p_pmtInstrRec.BankAcctInstr.BankAcct_Checkdigits, l_url, l_db_nls, l_ecapp_nls);
418: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderName, l_url, l_db_nls, l_ecapp_nls);
419: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.BankAcctInstr.Bank_Desc, l_url, l_db_nls, l_ecapp_nls);
420: IBY_NETUTILS_PVT.check_optional('OapfInstrCurrency', p_pmtInstrRec.BankAcctInstr.BankAcct_Currency, l_url, l_db_nls, l_ecapp_nls);
421: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerAddrId', p_pmtInstrRec.BankAcctInstr.Acct_HolderAddrId, l_url, l_db_nls, l_ecapp_nls);
422: IF ( p_pmtInstrRec.BankAcctInstr.Bank_AddrId is NOT null ) THEN
423: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrId', p_pmtInstrRec.BankAcctInstr.Bank_AddrId, l_url, l_db_nls, l_ecapp_nls);
424: ELSIF ( p_pmtInstrRec.BankAcctInstr.Bank_Address1 is NOT NULL) THEN

Line 421: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerAddrId', p_pmtInstrRec.BankAcctInstr.Acct_HolderAddrId, l_url, l_db_nls, l_ecapp_nls);

417: IBY_NETUTILS_PVT.check_optional('OapfInstrCheckDigits', p_pmtInstrRec.BankAcctInstr.BankAcct_Checkdigits, l_url, l_db_nls, l_ecapp_nls);
418: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.BankAcctInstr.BankAcct_HolderName, l_url, l_db_nls, l_ecapp_nls);
419: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.BankAcctInstr.Bank_Desc, l_url, l_db_nls, l_ecapp_nls);
420: IBY_NETUTILS_PVT.check_optional('OapfInstrCurrency', p_pmtInstrRec.BankAcctInstr.BankAcct_Currency, l_url, l_db_nls, l_ecapp_nls);
421: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerAddrId', p_pmtInstrRec.BankAcctInstr.Acct_HolderAddrId, l_url, l_db_nls, l_ecapp_nls);
422: IF ( p_pmtInstrRec.BankAcctInstr.Bank_AddrId is NOT null ) THEN
423: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrId', p_pmtInstrRec.BankAcctInstr.Bank_AddrId, l_url, l_db_nls, l_ecapp_nls);
424: ELSIF ( p_pmtInstrRec.BankAcctInstr.Bank_Address1 is NOT NULL) THEN
425: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.BankAcctInstr.Bank_Address1, l_url, l_db_nls, l_ecapp_nls);

Line 423: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrId', p_pmtInstrRec.BankAcctInstr.Bank_AddrId, l_url, l_db_nls, l_ecapp_nls);

419: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.BankAcctInstr.Bank_Desc, l_url, l_db_nls, l_ecapp_nls);
420: IBY_NETUTILS_PVT.check_optional('OapfInstrCurrency', p_pmtInstrRec.BankAcctInstr.BankAcct_Currency, l_url, l_db_nls, l_ecapp_nls);
421: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerAddrId', p_pmtInstrRec.BankAcctInstr.Acct_HolderAddrId, l_url, l_db_nls, l_ecapp_nls);
422: IF ( p_pmtInstrRec.BankAcctInstr.Bank_AddrId is NOT null ) THEN
423: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrId', p_pmtInstrRec.BankAcctInstr.Bank_AddrId, l_url, l_db_nls, l_ecapp_nls);
424: ELSIF ( p_pmtInstrRec.BankAcctInstr.Bank_Address1 is NOT NULL) THEN
425: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.BankAcctInstr.Bank_Address1, l_url, l_db_nls, l_ecapp_nls);
426: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.BankAcctInstr.Bank_Address2, l_url, l_db_nls, l_ecapp_nls);
427: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.BankAcctInstr.Bank_Address3, l_url, l_db_nls, l_ecapp_nls);

Line 425: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.BankAcctInstr.Bank_Address1, l_url, l_db_nls, l_ecapp_nls);

421: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerAddrId', p_pmtInstrRec.BankAcctInstr.Acct_HolderAddrId, l_url, l_db_nls, l_ecapp_nls);
422: IF ( p_pmtInstrRec.BankAcctInstr.Bank_AddrId is NOT null ) THEN
423: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrId', p_pmtInstrRec.BankAcctInstr.Bank_AddrId, l_url, l_db_nls, l_ecapp_nls);
424: ELSIF ( p_pmtInstrRec.BankAcctInstr.Bank_Address1 is NOT NULL) THEN
425: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.BankAcctInstr.Bank_Address1, l_url, l_db_nls, l_ecapp_nls);
426: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.BankAcctInstr.Bank_Address2, l_url, l_db_nls, l_ecapp_nls);
427: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.BankAcctInstr.Bank_Address3, l_url, l_db_nls, l_ecapp_nls);
428: IBY_NETUTILS_PVT.check_optional('OapfInstrCity', p_pmtInstrRec.BankAcctInstr.Bank_City, l_url, l_db_nls, l_ecapp_nls);
429: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.BankAcctInstr.Bank_County, l_url, l_db_nls, l_ecapp_nls);

Line 426: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.BankAcctInstr.Bank_Address2, l_url, l_db_nls, l_ecapp_nls);

422: IF ( p_pmtInstrRec.BankAcctInstr.Bank_AddrId is NOT null ) THEN
423: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrId', p_pmtInstrRec.BankAcctInstr.Bank_AddrId, l_url, l_db_nls, l_ecapp_nls);
424: ELSIF ( p_pmtInstrRec.BankAcctInstr.Bank_Address1 is NOT NULL) THEN
425: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.BankAcctInstr.Bank_Address1, l_url, l_db_nls, l_ecapp_nls);
426: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.BankAcctInstr.Bank_Address2, l_url, l_db_nls, l_ecapp_nls);
427: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.BankAcctInstr.Bank_Address3, l_url, l_db_nls, l_ecapp_nls);
428: IBY_NETUTILS_PVT.check_optional('OapfInstrCity', p_pmtInstrRec.BankAcctInstr.Bank_City, l_url, l_db_nls, l_ecapp_nls);
429: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.BankAcctInstr.Bank_County, l_url, l_db_nls, l_ecapp_nls);
430: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.BankAcctInstr.Bank_State, l_url, l_db_nls, l_ecapp_nls);

Line 427: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.BankAcctInstr.Bank_Address3, l_url, l_db_nls, l_ecapp_nls);

423: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrId', p_pmtInstrRec.BankAcctInstr.Bank_AddrId, l_url, l_db_nls, l_ecapp_nls);
424: ELSIF ( p_pmtInstrRec.BankAcctInstr.Bank_Address1 is NOT NULL) THEN
425: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.BankAcctInstr.Bank_Address1, l_url, l_db_nls, l_ecapp_nls);
426: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.BankAcctInstr.Bank_Address2, l_url, l_db_nls, l_ecapp_nls);
427: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.BankAcctInstr.Bank_Address3, l_url, l_db_nls, l_ecapp_nls);
428: IBY_NETUTILS_PVT.check_optional('OapfInstrCity', p_pmtInstrRec.BankAcctInstr.Bank_City, l_url, l_db_nls, l_ecapp_nls);
429: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.BankAcctInstr.Bank_County, l_url, l_db_nls, l_ecapp_nls);
430: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.BankAcctInstr.Bank_State, l_url, l_db_nls, l_ecapp_nls);
431: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.BankAcctInstr.Bank_Country, l_url, l_db_nls, l_ecapp_nls);

Line 428: IBY_NETUTILS_PVT.check_optional('OapfInstrCity', p_pmtInstrRec.BankAcctInstr.Bank_City, l_url, l_db_nls, l_ecapp_nls);

424: ELSIF ( p_pmtInstrRec.BankAcctInstr.Bank_Address1 is NOT NULL) THEN
425: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.BankAcctInstr.Bank_Address1, l_url, l_db_nls, l_ecapp_nls);
426: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.BankAcctInstr.Bank_Address2, l_url, l_db_nls, l_ecapp_nls);
427: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.BankAcctInstr.Bank_Address3, l_url, l_db_nls, l_ecapp_nls);
428: IBY_NETUTILS_PVT.check_optional('OapfInstrCity', p_pmtInstrRec.BankAcctInstr.Bank_City, l_url, l_db_nls, l_ecapp_nls);
429: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.BankAcctInstr.Bank_County, l_url, l_db_nls, l_ecapp_nls);
430: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.BankAcctInstr.Bank_State, l_url, l_db_nls, l_ecapp_nls);
431: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.BankAcctInstr.Bank_Country, l_url, l_db_nls, l_ecapp_nls);
432: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.BankAcctInstr.Bank_PostalCode, l_url, l_db_nls, l_ecapp_nls);

Line 429: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.BankAcctInstr.Bank_County, l_url, l_db_nls, l_ecapp_nls);

425: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.BankAcctInstr.Bank_Address1, l_url, l_db_nls, l_ecapp_nls);
426: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.BankAcctInstr.Bank_Address2, l_url, l_db_nls, l_ecapp_nls);
427: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.BankAcctInstr.Bank_Address3, l_url, l_db_nls, l_ecapp_nls);
428: IBY_NETUTILS_PVT.check_optional('OapfInstrCity', p_pmtInstrRec.BankAcctInstr.Bank_City, l_url, l_db_nls, l_ecapp_nls);
429: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.BankAcctInstr.Bank_County, l_url, l_db_nls, l_ecapp_nls);
430: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.BankAcctInstr.Bank_State, l_url, l_db_nls, l_ecapp_nls);
431: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.BankAcctInstr.Bank_Country, l_url, l_db_nls, l_ecapp_nls);
432: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.BankAcctInstr.Bank_PostalCode, l_url, l_db_nls, l_ecapp_nls);
433: END IF;

Line 430: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.BankAcctInstr.Bank_State, l_url, l_db_nls, l_ecapp_nls);

426: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.BankAcctInstr.Bank_Address2, l_url, l_db_nls, l_ecapp_nls);
427: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.BankAcctInstr.Bank_Address3, l_url, l_db_nls, l_ecapp_nls);
428: IBY_NETUTILS_PVT.check_optional('OapfInstrCity', p_pmtInstrRec.BankAcctInstr.Bank_City, l_url, l_db_nls, l_ecapp_nls);
429: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.BankAcctInstr.Bank_County, l_url, l_db_nls, l_ecapp_nls);
430: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.BankAcctInstr.Bank_State, l_url, l_db_nls, l_ecapp_nls);
431: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.BankAcctInstr.Bank_Country, l_url, l_db_nls, l_ecapp_nls);
432: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.BankAcctInstr.Bank_PostalCode, l_url, l_db_nls, l_ecapp_nls);
433: END IF;
434:

Line 431: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.BankAcctInstr.Bank_Country, l_url, l_db_nls, l_ecapp_nls);

427: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.BankAcctInstr.Bank_Address3, l_url, l_db_nls, l_ecapp_nls);
428: IBY_NETUTILS_PVT.check_optional('OapfInstrCity', p_pmtInstrRec.BankAcctInstr.Bank_City, l_url, l_db_nls, l_ecapp_nls);
429: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.BankAcctInstr.Bank_County, l_url, l_db_nls, l_ecapp_nls);
430: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.BankAcctInstr.Bank_State, l_url, l_db_nls, l_ecapp_nls);
431: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.BankAcctInstr.Bank_Country, l_url, l_db_nls, l_ecapp_nls);
432: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.BankAcctInstr.Bank_PostalCode, l_url, l_db_nls, l_ecapp_nls);
433: END IF;
434:
435: ELSIF( l_instrument_type = C_INSTRTYPE_PURCHASECARD ) THEN

Line 432: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.BankAcctInstr.Bank_PostalCode, l_url, l_db_nls, l_ecapp_nls);

428: IBY_NETUTILS_PVT.check_optional('OapfInstrCity', p_pmtInstrRec.BankAcctInstr.Bank_City, l_url, l_db_nls, l_ecapp_nls);
429: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.BankAcctInstr.Bank_County, l_url, l_db_nls, l_ecapp_nls);
430: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.BankAcctInstr.Bank_State, l_url, l_db_nls, l_ecapp_nls);
431: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.BankAcctInstr.Bank_Country, l_url, l_db_nls, l_ecapp_nls);
432: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.BankAcctInstr.Bank_PostalCode, l_url, l_db_nls, l_ecapp_nls);
433: END IF;
434:
435: ELSIF( l_instrument_type = C_INSTRTYPE_PURCHASECARD ) THEN
436:

Line 437: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.PurchaseCardInstr.FIName, l_url, l_db_nls, l_ecapp_nls);

433: END IF;
434:
435: ELSIF( l_instrument_type = C_INSTRTYPE_PURCHASECARD ) THEN
436:
437: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.PurchaseCardInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
438: IBY_NETUTILS_PVT.check_mandatory('OapfCCType',p_pmtInstrRec.PurchaseCardInstr.PC_Type, l_url, l_db_nls, l_ecapp_nls);
439: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrExp',to_char(p_pmtInstrRec.PurchaseCardInstr.PC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
440: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.PurchaseCardInstr.PC_Num, l_url, l_db_nls, l_ecapp_nls);
441: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.PurchaseCardInstr.PC_HolderName , l_url, l_db_nls, l_ecapp_nls);

Line 438: IBY_NETUTILS_PVT.check_mandatory('OapfCCType',p_pmtInstrRec.PurchaseCardInstr.PC_Type, l_url, l_db_nls, l_ecapp_nls);

434:
435: ELSIF( l_instrument_type = C_INSTRTYPE_PURCHASECARD ) THEN
436:
437: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.PurchaseCardInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
438: IBY_NETUTILS_PVT.check_mandatory('OapfCCType',p_pmtInstrRec.PurchaseCardInstr.PC_Type, l_url, l_db_nls, l_ecapp_nls);
439: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrExp',to_char(p_pmtInstrRec.PurchaseCardInstr.PC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
440: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.PurchaseCardInstr.PC_Num, l_url, l_db_nls, l_ecapp_nls);
441: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.PurchaseCardInstr.PC_HolderName , l_url, l_db_nls, l_ecapp_nls);
442: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.PurchaseCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);

Line 439: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrExp',to_char(p_pmtInstrRec.PurchaseCardInstr.PC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);

435: ELSIF( l_instrument_type = C_INSTRTYPE_PURCHASECARD ) THEN
436:
437: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.PurchaseCardInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
438: IBY_NETUTILS_PVT.check_mandatory('OapfCCType',p_pmtInstrRec.PurchaseCardInstr.PC_Type, l_url, l_db_nls, l_ecapp_nls);
439: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrExp',to_char(p_pmtInstrRec.PurchaseCardInstr.PC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
440: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.PurchaseCardInstr.PC_Num, l_url, l_db_nls, l_ecapp_nls);
441: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.PurchaseCardInstr.PC_HolderName , l_url, l_db_nls, l_ecapp_nls);
442: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.PurchaseCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);
443: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.PurchaseCardInstr.PC_HolderType, l_url, l_db_nls, l_ecapp_nls);

Line 440: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.PurchaseCardInstr.PC_Num, l_url, l_db_nls, l_ecapp_nls);

436:
437: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.PurchaseCardInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
438: IBY_NETUTILS_PVT.check_mandatory('OapfCCType',p_pmtInstrRec.PurchaseCardInstr.PC_Type, l_url, l_db_nls, l_ecapp_nls);
439: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrExp',to_char(p_pmtInstrRec.PurchaseCardInstr.PC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
440: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.PurchaseCardInstr.PC_Num, l_url, l_db_nls, l_ecapp_nls);
441: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.PurchaseCardInstr.PC_HolderName , l_url, l_db_nls, l_ecapp_nls);
442: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.PurchaseCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);
443: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.PurchaseCardInstr.PC_HolderType, l_url, l_db_nls, l_ecapp_nls);
444: IBY_NETUTILS_PVT.check_mandatory('OapfCardSubType', p_pmtInstrRec.PurchaseCardInstr.PC_Subtype, l_url, l_db_nls, l_ecapp_nls);

Line 441: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.PurchaseCardInstr.PC_HolderName , l_url, l_db_nls, l_ecapp_nls);

437: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.PurchaseCardInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
438: IBY_NETUTILS_PVT.check_mandatory('OapfCCType',p_pmtInstrRec.PurchaseCardInstr.PC_Type, l_url, l_db_nls, l_ecapp_nls);
439: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrExp',to_char(p_pmtInstrRec.PurchaseCardInstr.PC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
440: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.PurchaseCardInstr.PC_Num, l_url, l_db_nls, l_ecapp_nls);
441: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.PurchaseCardInstr.PC_HolderName , l_url, l_db_nls, l_ecapp_nls);
442: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.PurchaseCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);
443: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.PurchaseCardInstr.PC_HolderType, l_url, l_db_nls, l_ecapp_nls);
444: IBY_NETUTILS_PVT.check_mandatory('OapfCardSubType', p_pmtInstrRec.PurchaseCardInstr.PC_Subtype, l_url, l_db_nls, l_ecapp_nls);
445: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.PurchaseCardInstr.PC_Desc, l_url, l_db_nls, l_ecapp_nls);

Line 442: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.PurchaseCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);

438: IBY_NETUTILS_PVT.check_mandatory('OapfCCType',p_pmtInstrRec.PurchaseCardInstr.PC_Type, l_url, l_db_nls, l_ecapp_nls);
439: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrExp',to_char(p_pmtInstrRec.PurchaseCardInstr.PC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
440: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.PurchaseCardInstr.PC_Num, l_url, l_db_nls, l_ecapp_nls);
441: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.PurchaseCardInstr.PC_HolderName , l_url, l_db_nls, l_ecapp_nls);
442: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.PurchaseCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);
443: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.PurchaseCardInstr.PC_HolderType, l_url, l_db_nls, l_ecapp_nls);
444: IBY_NETUTILS_PVT.check_mandatory('OapfCardSubType', p_pmtInstrRec.PurchaseCardInstr.PC_Subtype, l_url, l_db_nls, l_ecapp_nls);
445: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.PurchaseCardInstr.PC_Desc, l_url, l_db_nls, l_ecapp_nls);
446: IF ( p_pmtInstrRec.PurchaseCardInstr.Billing_Address1 is NOT NULL) THEN

Line 443: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.PurchaseCardInstr.PC_HolderType, l_url, l_db_nls, l_ecapp_nls);

439: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrExp',to_char(p_pmtInstrRec.PurchaseCardInstr.PC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
440: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.PurchaseCardInstr.PC_Num, l_url, l_db_nls, l_ecapp_nls);
441: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.PurchaseCardInstr.PC_HolderName , l_url, l_db_nls, l_ecapp_nls);
442: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.PurchaseCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);
443: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.PurchaseCardInstr.PC_HolderType, l_url, l_db_nls, l_ecapp_nls);
444: IBY_NETUTILS_PVT.check_mandatory('OapfCardSubType', p_pmtInstrRec.PurchaseCardInstr.PC_Subtype, l_url, l_db_nls, l_ecapp_nls);
445: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.PurchaseCardInstr.PC_Desc, l_url, l_db_nls, l_ecapp_nls);
446: IF ( p_pmtInstrRec.PurchaseCardInstr.Billing_Address1 is NOT NULL) THEN
447: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.PurchaseCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);

Line 444: IBY_NETUTILS_PVT.check_mandatory('OapfCardSubType', p_pmtInstrRec.PurchaseCardInstr.PC_Subtype, l_url, l_db_nls, l_ecapp_nls);

440: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.PurchaseCardInstr.PC_Num, l_url, l_db_nls, l_ecapp_nls);
441: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.PurchaseCardInstr.PC_HolderName , l_url, l_db_nls, l_ecapp_nls);
442: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.PurchaseCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);
443: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.PurchaseCardInstr.PC_HolderType, l_url, l_db_nls, l_ecapp_nls);
444: IBY_NETUTILS_PVT.check_mandatory('OapfCardSubType', p_pmtInstrRec.PurchaseCardInstr.PC_Subtype, l_url, l_db_nls, l_ecapp_nls);
445: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.PurchaseCardInstr.PC_Desc, l_url, l_db_nls, l_ecapp_nls);
446: IF ( p_pmtInstrRec.PurchaseCardInstr.Billing_Address1 is NOT NULL) THEN
447: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.PurchaseCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);
448: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.PurchaseCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);

Line 445: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.PurchaseCardInstr.PC_Desc, l_url, l_db_nls, l_ecapp_nls);

441: IBY_NETUTILS_PVT.check_mandatory('OapfInstrHolderName', p_pmtInstrRec.PurchaseCardInstr.PC_HolderName , l_url, l_db_nls, l_ecapp_nls);
442: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.PurchaseCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);
443: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.PurchaseCardInstr.PC_HolderType, l_url, l_db_nls, l_ecapp_nls);
444: IBY_NETUTILS_PVT.check_mandatory('OapfCardSubType', p_pmtInstrRec.PurchaseCardInstr.PC_Subtype, l_url, l_db_nls, l_ecapp_nls);
445: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.PurchaseCardInstr.PC_Desc, l_url, l_db_nls, l_ecapp_nls);
446: IF ( p_pmtInstrRec.PurchaseCardInstr.Billing_Address1 is NOT NULL) THEN
447: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.PurchaseCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);
448: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.PurchaseCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);
449: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.PurchaseCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);

Line 447: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.PurchaseCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);

443: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.PurchaseCardInstr.PC_HolderType, l_url, l_db_nls, l_ecapp_nls);
444: IBY_NETUTILS_PVT.check_mandatory('OapfCardSubType', p_pmtInstrRec.PurchaseCardInstr.PC_Subtype, l_url, l_db_nls, l_ecapp_nls);
445: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.PurchaseCardInstr.PC_Desc, l_url, l_db_nls, l_ecapp_nls);
446: IF ( p_pmtInstrRec.PurchaseCardInstr.Billing_Address1 is NOT NULL) THEN
447: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.PurchaseCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);
448: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.PurchaseCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);
449: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.PurchaseCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
450: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.PurchaseCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
451: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.PurchaseCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);

Line 448: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.PurchaseCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);

444: IBY_NETUTILS_PVT.check_mandatory('OapfCardSubType', p_pmtInstrRec.PurchaseCardInstr.PC_Subtype, l_url, l_db_nls, l_ecapp_nls);
445: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.PurchaseCardInstr.PC_Desc, l_url, l_db_nls, l_ecapp_nls);
446: IF ( p_pmtInstrRec.PurchaseCardInstr.Billing_Address1 is NOT NULL) THEN
447: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.PurchaseCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);
448: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.PurchaseCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);
449: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.PurchaseCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
450: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.PurchaseCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
451: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.PurchaseCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
452: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.PurchaseCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);

Line 449: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.PurchaseCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);

445: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.PurchaseCardInstr.PC_Desc, l_url, l_db_nls, l_ecapp_nls);
446: IF ( p_pmtInstrRec.PurchaseCardInstr.Billing_Address1 is NOT NULL) THEN
447: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.PurchaseCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);
448: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.PurchaseCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);
449: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.PurchaseCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
450: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.PurchaseCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
451: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.PurchaseCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
452: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.PurchaseCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);
453: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.PurchaseCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);

Line 450: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.PurchaseCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);

446: IF ( p_pmtInstrRec.PurchaseCardInstr.Billing_Address1 is NOT NULL) THEN
447: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.PurchaseCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);
448: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.PurchaseCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);
449: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.PurchaseCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
450: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.PurchaseCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
451: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.PurchaseCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
452: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.PurchaseCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);
453: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.PurchaseCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);
454: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.PurchaseCardInstr.Billing_PostalCode, l_url, l_db_nls, l_ecapp_nls);

Line 451: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.PurchaseCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);

447: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.PurchaseCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);
448: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.PurchaseCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);
449: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.PurchaseCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
450: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.PurchaseCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
451: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.PurchaseCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
452: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.PurchaseCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);
453: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.PurchaseCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);
454: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.PurchaseCardInstr.Billing_PostalCode, l_url, l_db_nls, l_ecapp_nls);
455: END IF;

Line 452: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.PurchaseCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);

448: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.PurchaseCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);
449: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.PurchaseCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
450: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.PurchaseCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
451: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.PurchaseCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
452: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.PurchaseCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);
453: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.PurchaseCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);
454: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.PurchaseCardInstr.Billing_PostalCode, l_url, l_db_nls, l_ecapp_nls);
455: END IF;
456:

Line 453: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.PurchaseCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);

449: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.PurchaseCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
450: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.PurchaseCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
451: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.PurchaseCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
452: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.PurchaseCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);
453: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.PurchaseCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);
454: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.PurchaseCardInstr.Billing_PostalCode, l_url, l_db_nls, l_ecapp_nls);
455: END IF;
456:
457: ELSIF( l_instrument_type = C_INSTRTYPE_CREDITCARD ) THEN

Line 454: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.PurchaseCardInstr.Billing_PostalCode, l_url, l_db_nls, l_ecapp_nls);

450: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.PurchaseCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
451: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.PurchaseCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
452: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.PurchaseCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);
453: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.PurchaseCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);
454: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.PurchaseCardInstr.Billing_PostalCode, l_url, l_db_nls, l_ecapp_nls);
455: END IF;
456:
457: ELSIF( l_instrument_type = C_INSTRTYPE_CREDITCARD ) THEN
458:

Line 459: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.CreditCardInstr.FIName, l_url, l_db_nls, l_ecapp_nls);

455: END IF;
456:
457: ELSIF( l_instrument_type = C_INSTRTYPE_CREDITCARD ) THEN
458:
459: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.CreditCardInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
460: IBY_NETUTILS_PVT.check_optional('OapfCCType', p_pmtInstrRec.CreditCardInstr.CC_Type, l_url, l_db_nls, l_ecapp_nls);
461: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.CreditCardInstr.CC_Num, l_url, l_db_nls, l_ecapp_nls);
462: IBY_NETUTILS_PVT.check_optional('OapfPmtInstrExp', to_char(p_pmtInstrRec.CreditCardInstr.CC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
463: IBY_NETUTILS_PVT.check_optional('OapfInstrHolderName', p_pmtInstrRec.CreditCardInstr.CC_HolderName , l_url, l_db_nls, l_ecapp_nls);

Line 460: IBY_NETUTILS_PVT.check_optional('OapfCCType', p_pmtInstrRec.CreditCardInstr.CC_Type, l_url, l_db_nls, l_ecapp_nls);

456:
457: ELSIF( l_instrument_type = C_INSTRTYPE_CREDITCARD ) THEN
458:
459: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.CreditCardInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
460: IBY_NETUTILS_PVT.check_optional('OapfCCType', p_pmtInstrRec.CreditCardInstr.CC_Type, l_url, l_db_nls, l_ecapp_nls);
461: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.CreditCardInstr.CC_Num, l_url, l_db_nls, l_ecapp_nls);
462: IBY_NETUTILS_PVT.check_optional('OapfPmtInstrExp', to_char(p_pmtInstrRec.CreditCardInstr.CC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
463: IBY_NETUTILS_PVT.check_optional('OapfInstrHolderName', p_pmtInstrRec.CreditCardInstr.CC_HolderName , l_url, l_db_nls, l_ecapp_nls);
464: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.CreditCardInstr.CC_HolderType, l_url, l_db_nls, l_ecapp_nls);

Line 461: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.CreditCardInstr.CC_Num, l_url, l_db_nls, l_ecapp_nls);

457: ELSIF( l_instrument_type = C_INSTRTYPE_CREDITCARD ) THEN
458:
459: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.CreditCardInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
460: IBY_NETUTILS_PVT.check_optional('OapfCCType', p_pmtInstrRec.CreditCardInstr.CC_Type, l_url, l_db_nls, l_ecapp_nls);
461: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.CreditCardInstr.CC_Num, l_url, l_db_nls, l_ecapp_nls);
462: IBY_NETUTILS_PVT.check_optional('OapfPmtInstrExp', to_char(p_pmtInstrRec.CreditCardInstr.CC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
463: IBY_NETUTILS_PVT.check_optional('OapfInstrHolderName', p_pmtInstrRec.CreditCardInstr.CC_HolderName , l_url, l_db_nls, l_ecapp_nls);
464: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.CreditCardInstr.CC_HolderType, l_url, l_db_nls, l_ecapp_nls);
465: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.CreditCardInstr.CC_Desc, l_url, l_db_nls, l_ecapp_nls);

Line 462: IBY_NETUTILS_PVT.check_optional('OapfPmtInstrExp', to_char(p_pmtInstrRec.CreditCardInstr.CC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);

458:
459: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.CreditCardInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
460: IBY_NETUTILS_PVT.check_optional('OapfCCType', p_pmtInstrRec.CreditCardInstr.CC_Type, l_url, l_db_nls, l_ecapp_nls);
461: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.CreditCardInstr.CC_Num, l_url, l_db_nls, l_ecapp_nls);
462: IBY_NETUTILS_PVT.check_optional('OapfPmtInstrExp', to_char(p_pmtInstrRec.CreditCardInstr.CC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
463: IBY_NETUTILS_PVT.check_optional('OapfInstrHolderName', p_pmtInstrRec.CreditCardInstr.CC_HolderName , l_url, l_db_nls, l_ecapp_nls);
464: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.CreditCardInstr.CC_HolderType, l_url, l_db_nls, l_ecapp_nls);
465: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.CreditCardInstr.CC_Desc, l_url, l_db_nls, l_ecapp_nls);
466:

Line 463: IBY_NETUTILS_PVT.check_optional('OapfInstrHolderName', p_pmtInstrRec.CreditCardInstr.CC_HolderName , l_url, l_db_nls, l_ecapp_nls);

459: IBY_NETUTILS_PVT.check_optional('OapfInstrFIName', p_pmtInstrRec.CreditCardInstr.FIName, l_url, l_db_nls, l_ecapp_nls);
460: IBY_NETUTILS_PVT.check_optional('OapfCCType', p_pmtInstrRec.CreditCardInstr.CC_Type, l_url, l_db_nls, l_ecapp_nls);
461: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.CreditCardInstr.CC_Num, l_url, l_db_nls, l_ecapp_nls);
462: IBY_NETUTILS_PVT.check_optional('OapfPmtInstrExp', to_char(p_pmtInstrRec.CreditCardInstr.CC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
463: IBY_NETUTILS_PVT.check_optional('OapfInstrHolderName', p_pmtInstrRec.CreditCardInstr.CC_HolderName , l_url, l_db_nls, l_ecapp_nls);
464: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.CreditCardInstr.CC_HolderType, l_url, l_db_nls, l_ecapp_nls);
465: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.CreditCardInstr.CC_Desc, l_url, l_db_nls, l_ecapp_nls);
466:
467: --lmallick

Line 464: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.CreditCardInstr.CC_HolderType, l_url, l_db_nls, l_ecapp_nls);

460: IBY_NETUTILS_PVT.check_optional('OapfCCType', p_pmtInstrRec.CreditCardInstr.CC_Type, l_url, l_db_nls, l_ecapp_nls);
461: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.CreditCardInstr.CC_Num, l_url, l_db_nls, l_ecapp_nls);
462: IBY_NETUTILS_PVT.check_optional('OapfPmtInstrExp', to_char(p_pmtInstrRec.CreditCardInstr.CC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
463: IBY_NETUTILS_PVT.check_optional('OapfInstrHolderName', p_pmtInstrRec.CreditCardInstr.CC_HolderName , l_url, l_db_nls, l_ecapp_nls);
464: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.CreditCardInstr.CC_HolderType, l_url, l_db_nls, l_ecapp_nls);
465: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.CreditCardInstr.CC_Desc, l_url, l_db_nls, l_ecapp_nls);
466:
467: --lmallick
468: --ownerid is optional (OIE registers cards without passing an ownerid)

Line 465: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.CreditCardInstr.CC_Desc, l_url, l_db_nls, l_ecapp_nls);

461: IBY_NETUTILS_PVT.check_mandatory('OapfInstrNum', p_pmtInstrRec.CreditCardInstr.CC_Num, l_url, l_db_nls, l_ecapp_nls);
462: IBY_NETUTILS_PVT.check_optional('OapfPmtInstrExp', to_char(p_pmtInstrRec.CreditCardInstr.CC_ExpDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
463: IBY_NETUTILS_PVT.check_optional('OapfInstrHolderName', p_pmtInstrRec.CreditCardInstr.CC_HolderName , l_url, l_db_nls, l_ecapp_nls);
464: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerType', p_pmtInstrRec.CreditCardInstr.CC_HolderType, l_url, l_db_nls, l_ecapp_nls);
465: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.CreditCardInstr.CC_Desc, l_url, l_db_nls, l_ecapp_nls);
466:
467: --lmallick
468: --ownerid is optional (OIE registers cards without passing an ownerid)
469: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.CreditCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);

Line 469: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.CreditCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);

465: IBY_NETUTILS_PVT.check_optional('OapfInstrBuf', p_pmtInstrRec.CreditCardInstr.CC_Desc, l_url, l_db_nls, l_ecapp_nls);
466:
467: --lmallick
468: --ownerid is optional (OIE registers cards without passing an ownerid)
469: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.CreditCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);
470:
471: IBY_NETUTILS_PVT.check_optional('OapfSingleUseFlag', p_pmtInstrRec.CreditCardInstr.Single_Use_Flag, l_url, l_db_nls, l_ecapp_nls);
472: IBY_NETUTILS_PVT.check_optional('OapfInfoOnlyFlag', p_pmtInstrRec.CreditCardInstr.Info_Only_Flag, l_url, l_db_nls, l_ecapp_nls);
473:

Line 471: IBY_NETUTILS_PVT.check_optional('OapfSingleUseFlag', p_pmtInstrRec.CreditCardInstr.Single_Use_Flag, l_url, l_db_nls, l_ecapp_nls);

467: --lmallick
468: --ownerid is optional (OIE registers cards without passing an ownerid)
469: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.CreditCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);
470:
471: IBY_NETUTILS_PVT.check_optional('OapfSingleUseFlag', p_pmtInstrRec.CreditCardInstr.Single_Use_Flag, l_url, l_db_nls, l_ecapp_nls);
472: IBY_NETUTILS_PVT.check_optional('OapfInfoOnlyFlag', p_pmtInstrRec.CreditCardInstr.Info_Only_Flag, l_url, l_db_nls, l_ecapp_nls);
473:
474: iby_debug_pub.add('Card_purpose passed is :' || p_pmtInstrRec.CreditCardInstr.Card_Purpose, iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
475: IBY_NETUTILS_PVT.check_optional('OapfCardPurpose', p_pmtInstrRec.CreditCardInstr.Card_Purpose, l_url, l_db_nls, l_ecapp_nls);

Line 472: IBY_NETUTILS_PVT.check_optional('OapfInfoOnlyFlag', p_pmtInstrRec.CreditCardInstr.Info_Only_Flag, l_url, l_db_nls, l_ecapp_nls);

468: --ownerid is optional (OIE registers cards without passing an ownerid)
469: IBY_NETUTILS_PVT.check_optional('OapfInstrOwnerId', p_pmtInstrRec.CreditCardInstr.Owner_Id, l_url, l_db_nls, l_ecapp_nls);
470:
471: IBY_NETUTILS_PVT.check_optional('OapfSingleUseFlag', p_pmtInstrRec.CreditCardInstr.Single_Use_Flag, l_url, l_db_nls, l_ecapp_nls);
472: IBY_NETUTILS_PVT.check_optional('OapfInfoOnlyFlag', p_pmtInstrRec.CreditCardInstr.Info_Only_Flag, l_url, l_db_nls, l_ecapp_nls);
473:
474: iby_debug_pub.add('Card_purpose passed is :' || p_pmtInstrRec.CreditCardInstr.Card_Purpose, iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
475: IBY_NETUTILS_PVT.check_optional('OapfCardPurpose', p_pmtInstrRec.CreditCardInstr.Card_Purpose, l_url, l_db_nls, l_ecapp_nls);
476: IBY_NETUTILS_PVT.check_optional('OapfActiveFlag', p_pmtInstrRec.CreditCardInstr.Active_Flag, l_url, l_db_nls, l_ecapp_nls);

Line 475: IBY_NETUTILS_PVT.check_optional('OapfCardPurpose', p_pmtInstrRec.CreditCardInstr.Card_Purpose, l_url, l_db_nls, l_ecapp_nls);

471: IBY_NETUTILS_PVT.check_optional('OapfSingleUseFlag', p_pmtInstrRec.CreditCardInstr.Single_Use_Flag, l_url, l_db_nls, l_ecapp_nls);
472: IBY_NETUTILS_PVT.check_optional('OapfInfoOnlyFlag', p_pmtInstrRec.CreditCardInstr.Info_Only_Flag, l_url, l_db_nls, l_ecapp_nls);
473:
474: iby_debug_pub.add('Card_purpose passed is :' || p_pmtInstrRec.CreditCardInstr.Card_Purpose, iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
475: IBY_NETUTILS_PVT.check_optional('OapfCardPurpose', p_pmtInstrRec.CreditCardInstr.Card_Purpose, l_url, l_db_nls, l_ecapp_nls);
476: IBY_NETUTILS_PVT.check_optional('OapfActiveFlag', p_pmtInstrRec.CreditCardInstr.Active_Flag, l_url, l_db_nls, l_ecapp_nls);
477: IBY_NETUTILS_PVT.check_optional('OapfInactiveDate', TO_CHAR(p_pmtInstrRec.CreditCardInstr.Inactive_Date,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
478:
479: --bug 8423951

Line 476: IBY_NETUTILS_PVT.check_optional('OapfActiveFlag', p_pmtInstrRec.CreditCardInstr.Active_Flag, l_url, l_db_nls, l_ecapp_nls);

472: IBY_NETUTILS_PVT.check_optional('OapfInfoOnlyFlag', p_pmtInstrRec.CreditCardInstr.Info_Only_Flag, l_url, l_db_nls, l_ecapp_nls);
473:
474: iby_debug_pub.add('Card_purpose passed is :' || p_pmtInstrRec.CreditCardInstr.Card_Purpose, iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
475: IBY_NETUTILS_PVT.check_optional('OapfCardPurpose', p_pmtInstrRec.CreditCardInstr.Card_Purpose, l_url, l_db_nls, l_ecapp_nls);
476: IBY_NETUTILS_PVT.check_optional('OapfActiveFlag', p_pmtInstrRec.CreditCardInstr.Active_Flag, l_url, l_db_nls, l_ecapp_nls);
477: IBY_NETUTILS_PVT.check_optional('OapfInactiveDate', TO_CHAR(p_pmtInstrRec.CreditCardInstr.Inactive_Date,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
478:
479: --bug 8423951
480: iby_debug_pub.add('Address ID is :' || p_pmtInstrRec.CreditCardInstr.Billing_Address_Id, iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 477: IBY_NETUTILS_PVT.check_optional('OapfInactiveDate', TO_CHAR(p_pmtInstrRec.CreditCardInstr.Inactive_Date,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);

473:
474: iby_debug_pub.add('Card_purpose passed is :' || p_pmtInstrRec.CreditCardInstr.Card_Purpose, iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
475: IBY_NETUTILS_PVT.check_optional('OapfCardPurpose', p_pmtInstrRec.CreditCardInstr.Card_Purpose, l_url, l_db_nls, l_ecapp_nls);
476: IBY_NETUTILS_PVT.check_optional('OapfActiveFlag', p_pmtInstrRec.CreditCardInstr.Active_Flag, l_url, l_db_nls, l_ecapp_nls);
477: IBY_NETUTILS_PVT.check_optional('OapfInactiveDate', TO_CHAR(p_pmtInstrRec.CreditCardInstr.Inactive_Date,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
478:
479: --bug 8423951
480: iby_debug_pub.add('Address ID is :' || p_pmtInstrRec.CreditCardInstr.Billing_Address_Id, iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
481: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrId', p_pmtInstrRec.CreditCardInstr.Billing_Address_Id, l_url, l_db_nls, l_ecapp_nls);

Line 481: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrId', p_pmtInstrRec.CreditCardInstr.Billing_Address_Id, l_url, l_db_nls, l_ecapp_nls);

477: IBY_NETUTILS_PVT.check_optional('OapfInactiveDate', TO_CHAR(p_pmtInstrRec.CreditCardInstr.Inactive_Date,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
478:
479: --bug 8423951
480: iby_debug_pub.add('Address ID is :' || p_pmtInstrRec.CreditCardInstr.Billing_Address_Id, iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
481: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrId', p_pmtInstrRec.CreditCardInstr.Billing_Address_Id, l_url, l_db_nls, l_ecapp_nls);
482:
483: IF ( p_pmtInstrRec.CreditCardInstr.Billing_Address1 is NOT NULL) THEN
484: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.CreditCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);
485: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.CreditCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);

Line 484: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.CreditCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);

480: iby_debug_pub.add('Address ID is :' || p_pmtInstrRec.CreditCardInstr.Billing_Address_Id, iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
481: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrId', p_pmtInstrRec.CreditCardInstr.Billing_Address_Id, l_url, l_db_nls, l_ecapp_nls);
482:
483: IF ( p_pmtInstrRec.CreditCardInstr.Billing_Address1 is NOT NULL) THEN
484: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.CreditCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);
485: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.CreditCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);
486: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.CreditCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
487: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.CreditCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
488: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.CreditCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);

Line 485: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.CreditCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);

481: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrId', p_pmtInstrRec.CreditCardInstr.Billing_Address_Id, l_url, l_db_nls, l_ecapp_nls);
482:
483: IF ( p_pmtInstrRec.CreditCardInstr.Billing_Address1 is NOT NULL) THEN
484: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.CreditCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);
485: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.CreditCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);
486: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.CreditCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
487: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.CreditCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
488: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.CreditCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
489: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.CreditCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);

Line 486: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.CreditCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);

482:
483: IF ( p_pmtInstrRec.CreditCardInstr.Billing_Address1 is NOT NULL) THEN
484: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.CreditCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);
485: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.CreditCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);
486: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.CreditCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
487: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.CreditCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
488: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.CreditCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
489: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.CreditCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);
490: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.CreditCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);

Line 487: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.CreditCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);

483: IF ( p_pmtInstrRec.CreditCardInstr.Billing_Address1 is NOT NULL) THEN
484: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.CreditCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);
485: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.CreditCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);
486: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.CreditCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
487: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.CreditCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
488: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.CreditCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
489: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.CreditCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);
490: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.CreditCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);
491: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.CreditCardInstr.Billing_PostalCode, l_url, l_db_nls, l_ecapp_nls);

Line 488: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.CreditCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);

484: IBY_NETUTILS_PVT.check_mandatory('OapfInstrAddrLine1', p_pmtInstrRec.CreditCardInstr.Billing_Address1, l_url, l_db_nls, l_ecapp_nls);
485: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.CreditCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);
486: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.CreditCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
487: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.CreditCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
488: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.CreditCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
489: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.CreditCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);
490: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.CreditCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);
491: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.CreditCardInstr.Billing_PostalCode, l_url, l_db_nls, l_ecapp_nls);
492:

Line 489: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.CreditCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);

485: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine2', p_pmtInstrRec.CreditCardInstr.Billing_Address2, l_url, l_db_nls, l_ecapp_nls);
486: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.CreditCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
487: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.CreditCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
488: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.CreditCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
489: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.CreditCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);
490: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.CreditCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);
491: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.CreditCardInstr.Billing_PostalCode, l_url, l_db_nls, l_ecapp_nls);
492:
493: END IF;

Line 490: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.CreditCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);

486: IBY_NETUTILS_PVT.check_optional('OapfInstrAddrLine3', p_pmtInstrRec.CreditCardInstr.Billing_Address3, l_url, l_db_nls, l_ecapp_nls);
487: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.CreditCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
488: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.CreditCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
489: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.CreditCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);
490: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.CreditCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);
491: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.CreditCardInstr.Billing_PostalCode, l_url, l_db_nls, l_ecapp_nls);
492:
493: END IF;
494:

Line 491: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.CreditCardInstr.Billing_PostalCode, l_url, l_db_nls, l_ecapp_nls);

487: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCity', p_pmtInstrRec.CreditCardInstr.Billing_City, l_url, l_db_nls, l_ecapp_nls);
488: IBY_NETUTILS_PVT.check_optional('OapfInstrCounty', p_pmtInstrRec.CreditCardInstr.Billing_County, l_url, l_db_nls, l_ecapp_nls);
489: IBY_NETUTILS_PVT.check_optional('OapfInstrState', p_pmtInstrRec.CreditCardInstr.Billing_State, l_url, l_db_nls, l_ecapp_nls);
490: IBY_NETUTILS_PVT.check_mandatory('OapfInstrCountry', p_pmtInstrRec.CreditCardInstr.Billing_Country, l_url, l_db_nls, l_ecapp_nls);
491: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.CreditCardInstr.Billing_PostalCode, l_url, l_db_nls, l_ecapp_nls);
492:
493: END IF;
494:
495: IBY_NETUTILS_PVT.check_optional('OapfInstrAttCategory', p_pmtInstrRec.CreditCardInstr.Attribute_category, l_url, l_db_nls, l_ecapp_nls);

Line 495: IBY_NETUTILS_PVT.check_optional('OapfInstrAttCategory', p_pmtInstrRec.CreditCardInstr.Attribute_category, l_url, l_db_nls, l_ecapp_nls);

491: IBY_NETUTILS_PVT.check_optional('OapfInstrPostalCode', p_pmtInstrRec.CreditCardInstr.Billing_PostalCode, l_url, l_db_nls, l_ecapp_nls);
492:
493: END IF;
494:
495: IBY_NETUTILS_PVT.check_optional('OapfInstrAttCategory', p_pmtInstrRec.CreditCardInstr.Attribute_category, l_url, l_db_nls, l_ecapp_nls);
496: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute1', p_pmtInstrRec.CreditCardInstr.Attribute1, l_url, l_db_nls, l_ecapp_nls);
497: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute2', p_pmtInstrRec.CreditCardInstr.Attribute2, l_url, l_db_nls, l_ecapp_nls);
498: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute3', p_pmtInstrRec.CreditCardInstr.Attribute3, l_url, l_db_nls, l_ecapp_nls);
499: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute4', p_pmtInstrRec.CreditCardInstr.Attribute4, l_url, l_db_nls, l_ecapp_nls);

Line 496: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute1', p_pmtInstrRec.CreditCardInstr.Attribute1, l_url, l_db_nls, l_ecapp_nls);

492:
493: END IF;
494:
495: IBY_NETUTILS_PVT.check_optional('OapfInstrAttCategory', p_pmtInstrRec.CreditCardInstr.Attribute_category, l_url, l_db_nls, l_ecapp_nls);
496: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute1', p_pmtInstrRec.CreditCardInstr.Attribute1, l_url, l_db_nls, l_ecapp_nls);
497: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute2', p_pmtInstrRec.CreditCardInstr.Attribute2, l_url, l_db_nls, l_ecapp_nls);
498: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute3', p_pmtInstrRec.CreditCardInstr.Attribute3, l_url, l_db_nls, l_ecapp_nls);
499: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute4', p_pmtInstrRec.CreditCardInstr.Attribute4, l_url, l_db_nls, l_ecapp_nls);
500: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute5', p_pmtInstrRec.CreditCardInstr.Attribute5, l_url, l_db_nls, l_ecapp_nls);

Line 497: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute2', p_pmtInstrRec.CreditCardInstr.Attribute2, l_url, l_db_nls, l_ecapp_nls);

493: END IF;
494:
495: IBY_NETUTILS_PVT.check_optional('OapfInstrAttCategory', p_pmtInstrRec.CreditCardInstr.Attribute_category, l_url, l_db_nls, l_ecapp_nls);
496: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute1', p_pmtInstrRec.CreditCardInstr.Attribute1, l_url, l_db_nls, l_ecapp_nls);
497: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute2', p_pmtInstrRec.CreditCardInstr.Attribute2, l_url, l_db_nls, l_ecapp_nls);
498: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute3', p_pmtInstrRec.CreditCardInstr.Attribute3, l_url, l_db_nls, l_ecapp_nls);
499: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute4', p_pmtInstrRec.CreditCardInstr.Attribute4, l_url, l_db_nls, l_ecapp_nls);
500: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute5', p_pmtInstrRec.CreditCardInstr.Attribute5, l_url, l_db_nls, l_ecapp_nls);
501: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute6', p_pmtInstrRec.CreditCardInstr.Attribute6, l_url, l_db_nls, l_ecapp_nls);

Line 498: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute3', p_pmtInstrRec.CreditCardInstr.Attribute3, l_url, l_db_nls, l_ecapp_nls);

494:
495: IBY_NETUTILS_PVT.check_optional('OapfInstrAttCategory', p_pmtInstrRec.CreditCardInstr.Attribute_category, l_url, l_db_nls, l_ecapp_nls);
496: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute1', p_pmtInstrRec.CreditCardInstr.Attribute1, l_url, l_db_nls, l_ecapp_nls);
497: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute2', p_pmtInstrRec.CreditCardInstr.Attribute2, l_url, l_db_nls, l_ecapp_nls);
498: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute3', p_pmtInstrRec.CreditCardInstr.Attribute3, l_url, l_db_nls, l_ecapp_nls);
499: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute4', p_pmtInstrRec.CreditCardInstr.Attribute4, l_url, l_db_nls, l_ecapp_nls);
500: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute5', p_pmtInstrRec.CreditCardInstr.Attribute5, l_url, l_db_nls, l_ecapp_nls);
501: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute6', p_pmtInstrRec.CreditCardInstr.Attribute6, l_url, l_db_nls, l_ecapp_nls);
502: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute7', p_pmtInstrRec.CreditCardInstr.Attribute7, l_url, l_db_nls, l_ecapp_nls);

Line 499: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute4', p_pmtInstrRec.CreditCardInstr.Attribute4, l_url, l_db_nls, l_ecapp_nls);

495: IBY_NETUTILS_PVT.check_optional('OapfInstrAttCategory', p_pmtInstrRec.CreditCardInstr.Attribute_category, l_url, l_db_nls, l_ecapp_nls);
496: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute1', p_pmtInstrRec.CreditCardInstr.Attribute1, l_url, l_db_nls, l_ecapp_nls);
497: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute2', p_pmtInstrRec.CreditCardInstr.Attribute2, l_url, l_db_nls, l_ecapp_nls);
498: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute3', p_pmtInstrRec.CreditCardInstr.Attribute3, l_url, l_db_nls, l_ecapp_nls);
499: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute4', p_pmtInstrRec.CreditCardInstr.Attribute4, l_url, l_db_nls, l_ecapp_nls);
500: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute5', p_pmtInstrRec.CreditCardInstr.Attribute5, l_url, l_db_nls, l_ecapp_nls);
501: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute6', p_pmtInstrRec.CreditCardInstr.Attribute6, l_url, l_db_nls, l_ecapp_nls);
502: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute7', p_pmtInstrRec.CreditCardInstr.Attribute7, l_url, l_db_nls, l_ecapp_nls);
503: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute8', p_pmtInstrRec.CreditCardInstr.Attribute8, l_url, l_db_nls, l_ecapp_nls);

Line 500: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute5', p_pmtInstrRec.CreditCardInstr.Attribute5, l_url, l_db_nls, l_ecapp_nls);

496: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute1', p_pmtInstrRec.CreditCardInstr.Attribute1, l_url, l_db_nls, l_ecapp_nls);
497: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute2', p_pmtInstrRec.CreditCardInstr.Attribute2, l_url, l_db_nls, l_ecapp_nls);
498: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute3', p_pmtInstrRec.CreditCardInstr.Attribute3, l_url, l_db_nls, l_ecapp_nls);
499: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute4', p_pmtInstrRec.CreditCardInstr.Attribute4, l_url, l_db_nls, l_ecapp_nls);
500: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute5', p_pmtInstrRec.CreditCardInstr.Attribute5, l_url, l_db_nls, l_ecapp_nls);
501: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute6', p_pmtInstrRec.CreditCardInstr.Attribute6, l_url, l_db_nls, l_ecapp_nls);
502: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute7', p_pmtInstrRec.CreditCardInstr.Attribute7, l_url, l_db_nls, l_ecapp_nls);
503: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute8', p_pmtInstrRec.CreditCardInstr.Attribute8, l_url, l_db_nls, l_ecapp_nls);
504: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute9', p_pmtInstrRec.CreditCardInstr.Attribute9, l_url, l_db_nls, l_ecapp_nls);

Line 501: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute6', p_pmtInstrRec.CreditCardInstr.Attribute6, l_url, l_db_nls, l_ecapp_nls);

497: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute2', p_pmtInstrRec.CreditCardInstr.Attribute2, l_url, l_db_nls, l_ecapp_nls);
498: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute3', p_pmtInstrRec.CreditCardInstr.Attribute3, l_url, l_db_nls, l_ecapp_nls);
499: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute4', p_pmtInstrRec.CreditCardInstr.Attribute4, l_url, l_db_nls, l_ecapp_nls);
500: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute5', p_pmtInstrRec.CreditCardInstr.Attribute5, l_url, l_db_nls, l_ecapp_nls);
501: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute6', p_pmtInstrRec.CreditCardInstr.Attribute6, l_url, l_db_nls, l_ecapp_nls);
502: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute7', p_pmtInstrRec.CreditCardInstr.Attribute7, l_url, l_db_nls, l_ecapp_nls);
503: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute8', p_pmtInstrRec.CreditCardInstr.Attribute8, l_url, l_db_nls, l_ecapp_nls);
504: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute9', p_pmtInstrRec.CreditCardInstr.Attribute9, l_url, l_db_nls, l_ecapp_nls);
505: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute10', p_pmtInstrRec.CreditCardInstr.Attribute10, l_url, l_db_nls, l_ecapp_nls);

Line 502: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute7', p_pmtInstrRec.CreditCardInstr.Attribute7, l_url, l_db_nls, l_ecapp_nls);

498: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute3', p_pmtInstrRec.CreditCardInstr.Attribute3, l_url, l_db_nls, l_ecapp_nls);
499: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute4', p_pmtInstrRec.CreditCardInstr.Attribute4, l_url, l_db_nls, l_ecapp_nls);
500: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute5', p_pmtInstrRec.CreditCardInstr.Attribute5, l_url, l_db_nls, l_ecapp_nls);
501: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute6', p_pmtInstrRec.CreditCardInstr.Attribute6, l_url, l_db_nls, l_ecapp_nls);
502: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute7', p_pmtInstrRec.CreditCardInstr.Attribute7, l_url, l_db_nls, l_ecapp_nls);
503: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute8', p_pmtInstrRec.CreditCardInstr.Attribute8, l_url, l_db_nls, l_ecapp_nls);
504: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute9', p_pmtInstrRec.CreditCardInstr.Attribute9, l_url, l_db_nls, l_ecapp_nls);
505: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute10', p_pmtInstrRec.CreditCardInstr.Attribute10, l_url, l_db_nls, l_ecapp_nls);
506: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute11', p_pmtInstrRec.CreditCardInstr.Attribute11, l_url, l_db_nls, l_ecapp_nls);

Line 503: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute8', p_pmtInstrRec.CreditCardInstr.Attribute8, l_url, l_db_nls, l_ecapp_nls);

499: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute4', p_pmtInstrRec.CreditCardInstr.Attribute4, l_url, l_db_nls, l_ecapp_nls);
500: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute5', p_pmtInstrRec.CreditCardInstr.Attribute5, l_url, l_db_nls, l_ecapp_nls);
501: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute6', p_pmtInstrRec.CreditCardInstr.Attribute6, l_url, l_db_nls, l_ecapp_nls);
502: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute7', p_pmtInstrRec.CreditCardInstr.Attribute7, l_url, l_db_nls, l_ecapp_nls);
503: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute8', p_pmtInstrRec.CreditCardInstr.Attribute8, l_url, l_db_nls, l_ecapp_nls);
504: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute9', p_pmtInstrRec.CreditCardInstr.Attribute9, l_url, l_db_nls, l_ecapp_nls);
505: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute10', p_pmtInstrRec.CreditCardInstr.Attribute10, l_url, l_db_nls, l_ecapp_nls);
506: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute11', p_pmtInstrRec.CreditCardInstr.Attribute11, l_url, l_db_nls, l_ecapp_nls);
507: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute12', p_pmtInstrRec.CreditCardInstr.Attribute12, l_url, l_db_nls, l_ecapp_nls);

Line 504: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute9', p_pmtInstrRec.CreditCardInstr.Attribute9, l_url, l_db_nls, l_ecapp_nls);

500: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute5', p_pmtInstrRec.CreditCardInstr.Attribute5, l_url, l_db_nls, l_ecapp_nls);
501: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute6', p_pmtInstrRec.CreditCardInstr.Attribute6, l_url, l_db_nls, l_ecapp_nls);
502: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute7', p_pmtInstrRec.CreditCardInstr.Attribute7, l_url, l_db_nls, l_ecapp_nls);
503: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute8', p_pmtInstrRec.CreditCardInstr.Attribute8, l_url, l_db_nls, l_ecapp_nls);
504: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute9', p_pmtInstrRec.CreditCardInstr.Attribute9, l_url, l_db_nls, l_ecapp_nls);
505: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute10', p_pmtInstrRec.CreditCardInstr.Attribute10, l_url, l_db_nls, l_ecapp_nls);
506: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute11', p_pmtInstrRec.CreditCardInstr.Attribute11, l_url, l_db_nls, l_ecapp_nls);
507: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute12', p_pmtInstrRec.CreditCardInstr.Attribute12, l_url, l_db_nls, l_ecapp_nls);
508: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute13', p_pmtInstrRec.CreditCardInstr.Attribute13, l_url, l_db_nls, l_ecapp_nls);

Line 505: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute10', p_pmtInstrRec.CreditCardInstr.Attribute10, l_url, l_db_nls, l_ecapp_nls);

501: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute6', p_pmtInstrRec.CreditCardInstr.Attribute6, l_url, l_db_nls, l_ecapp_nls);
502: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute7', p_pmtInstrRec.CreditCardInstr.Attribute7, l_url, l_db_nls, l_ecapp_nls);
503: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute8', p_pmtInstrRec.CreditCardInstr.Attribute8, l_url, l_db_nls, l_ecapp_nls);
504: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute9', p_pmtInstrRec.CreditCardInstr.Attribute9, l_url, l_db_nls, l_ecapp_nls);
505: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute10', p_pmtInstrRec.CreditCardInstr.Attribute10, l_url, l_db_nls, l_ecapp_nls);
506: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute11', p_pmtInstrRec.CreditCardInstr.Attribute11, l_url, l_db_nls, l_ecapp_nls);
507: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute12', p_pmtInstrRec.CreditCardInstr.Attribute12, l_url, l_db_nls, l_ecapp_nls);
508: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute13', p_pmtInstrRec.CreditCardInstr.Attribute13, l_url, l_db_nls, l_ecapp_nls);
509: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute14', p_pmtInstrRec.CreditCardInstr.Attribute14, l_url, l_db_nls, l_ecapp_nls);

Line 506: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute11', p_pmtInstrRec.CreditCardInstr.Attribute11, l_url, l_db_nls, l_ecapp_nls);

502: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute7', p_pmtInstrRec.CreditCardInstr.Attribute7, l_url, l_db_nls, l_ecapp_nls);
503: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute8', p_pmtInstrRec.CreditCardInstr.Attribute8, l_url, l_db_nls, l_ecapp_nls);
504: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute9', p_pmtInstrRec.CreditCardInstr.Attribute9, l_url, l_db_nls, l_ecapp_nls);
505: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute10', p_pmtInstrRec.CreditCardInstr.Attribute10, l_url, l_db_nls, l_ecapp_nls);
506: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute11', p_pmtInstrRec.CreditCardInstr.Attribute11, l_url, l_db_nls, l_ecapp_nls);
507: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute12', p_pmtInstrRec.CreditCardInstr.Attribute12, l_url, l_db_nls, l_ecapp_nls);
508: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute13', p_pmtInstrRec.CreditCardInstr.Attribute13, l_url, l_db_nls, l_ecapp_nls);
509: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute14', p_pmtInstrRec.CreditCardInstr.Attribute14, l_url, l_db_nls, l_ecapp_nls);
510: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute15', p_pmtInstrRec.CreditCardInstr.Attribute15, l_url, l_db_nls, l_ecapp_nls);

Line 507: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute12', p_pmtInstrRec.CreditCardInstr.Attribute12, l_url, l_db_nls, l_ecapp_nls);

503: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute8', p_pmtInstrRec.CreditCardInstr.Attribute8, l_url, l_db_nls, l_ecapp_nls);
504: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute9', p_pmtInstrRec.CreditCardInstr.Attribute9, l_url, l_db_nls, l_ecapp_nls);
505: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute10', p_pmtInstrRec.CreditCardInstr.Attribute10, l_url, l_db_nls, l_ecapp_nls);
506: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute11', p_pmtInstrRec.CreditCardInstr.Attribute11, l_url, l_db_nls, l_ecapp_nls);
507: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute12', p_pmtInstrRec.CreditCardInstr.Attribute12, l_url, l_db_nls, l_ecapp_nls);
508: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute13', p_pmtInstrRec.CreditCardInstr.Attribute13, l_url, l_db_nls, l_ecapp_nls);
509: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute14', p_pmtInstrRec.CreditCardInstr.Attribute14, l_url, l_db_nls, l_ecapp_nls);
510: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute15', p_pmtInstrRec.CreditCardInstr.Attribute15, l_url, l_db_nls, l_ecapp_nls);
511: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute16', p_pmtInstrRec.CreditCardInstr.Attribute16, l_url, l_db_nls, l_ecapp_nls);

Line 508: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute13', p_pmtInstrRec.CreditCardInstr.Attribute13, l_url, l_db_nls, l_ecapp_nls);

504: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute9', p_pmtInstrRec.CreditCardInstr.Attribute9, l_url, l_db_nls, l_ecapp_nls);
505: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute10', p_pmtInstrRec.CreditCardInstr.Attribute10, l_url, l_db_nls, l_ecapp_nls);
506: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute11', p_pmtInstrRec.CreditCardInstr.Attribute11, l_url, l_db_nls, l_ecapp_nls);
507: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute12', p_pmtInstrRec.CreditCardInstr.Attribute12, l_url, l_db_nls, l_ecapp_nls);
508: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute13', p_pmtInstrRec.CreditCardInstr.Attribute13, l_url, l_db_nls, l_ecapp_nls);
509: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute14', p_pmtInstrRec.CreditCardInstr.Attribute14, l_url, l_db_nls, l_ecapp_nls);
510: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute15', p_pmtInstrRec.CreditCardInstr.Attribute15, l_url, l_db_nls, l_ecapp_nls);
511: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute16', p_pmtInstrRec.CreditCardInstr.Attribute16, l_url, l_db_nls, l_ecapp_nls);
512: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute17', p_pmtInstrRec.CreditCardInstr.Attribute17, l_url, l_db_nls, l_ecapp_nls);

Line 509: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute14', p_pmtInstrRec.CreditCardInstr.Attribute14, l_url, l_db_nls, l_ecapp_nls);

505: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute10', p_pmtInstrRec.CreditCardInstr.Attribute10, l_url, l_db_nls, l_ecapp_nls);
506: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute11', p_pmtInstrRec.CreditCardInstr.Attribute11, l_url, l_db_nls, l_ecapp_nls);
507: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute12', p_pmtInstrRec.CreditCardInstr.Attribute12, l_url, l_db_nls, l_ecapp_nls);
508: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute13', p_pmtInstrRec.CreditCardInstr.Attribute13, l_url, l_db_nls, l_ecapp_nls);
509: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute14', p_pmtInstrRec.CreditCardInstr.Attribute14, l_url, l_db_nls, l_ecapp_nls);
510: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute15', p_pmtInstrRec.CreditCardInstr.Attribute15, l_url, l_db_nls, l_ecapp_nls);
511: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute16', p_pmtInstrRec.CreditCardInstr.Attribute16, l_url, l_db_nls, l_ecapp_nls);
512: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute17', p_pmtInstrRec.CreditCardInstr.Attribute17, l_url, l_db_nls, l_ecapp_nls);
513: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute18', p_pmtInstrRec.CreditCardInstr.Attribute18, l_url, l_db_nls, l_ecapp_nls);

Line 510: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute15', p_pmtInstrRec.CreditCardInstr.Attribute15, l_url, l_db_nls, l_ecapp_nls);

506: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute11', p_pmtInstrRec.CreditCardInstr.Attribute11, l_url, l_db_nls, l_ecapp_nls);
507: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute12', p_pmtInstrRec.CreditCardInstr.Attribute12, l_url, l_db_nls, l_ecapp_nls);
508: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute13', p_pmtInstrRec.CreditCardInstr.Attribute13, l_url, l_db_nls, l_ecapp_nls);
509: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute14', p_pmtInstrRec.CreditCardInstr.Attribute14, l_url, l_db_nls, l_ecapp_nls);
510: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute15', p_pmtInstrRec.CreditCardInstr.Attribute15, l_url, l_db_nls, l_ecapp_nls);
511: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute16', p_pmtInstrRec.CreditCardInstr.Attribute16, l_url, l_db_nls, l_ecapp_nls);
512: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute17', p_pmtInstrRec.CreditCardInstr.Attribute17, l_url, l_db_nls, l_ecapp_nls);
513: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute18', p_pmtInstrRec.CreditCardInstr.Attribute18, l_url, l_db_nls, l_ecapp_nls);
514: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute19', p_pmtInstrRec.CreditCardInstr.Attribute19, l_url, l_db_nls, l_ecapp_nls);

Line 511: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute16', p_pmtInstrRec.CreditCardInstr.Attribute16, l_url, l_db_nls, l_ecapp_nls);

507: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute12', p_pmtInstrRec.CreditCardInstr.Attribute12, l_url, l_db_nls, l_ecapp_nls);
508: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute13', p_pmtInstrRec.CreditCardInstr.Attribute13, l_url, l_db_nls, l_ecapp_nls);
509: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute14', p_pmtInstrRec.CreditCardInstr.Attribute14, l_url, l_db_nls, l_ecapp_nls);
510: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute15', p_pmtInstrRec.CreditCardInstr.Attribute15, l_url, l_db_nls, l_ecapp_nls);
511: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute16', p_pmtInstrRec.CreditCardInstr.Attribute16, l_url, l_db_nls, l_ecapp_nls);
512: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute17', p_pmtInstrRec.CreditCardInstr.Attribute17, l_url, l_db_nls, l_ecapp_nls);
513: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute18', p_pmtInstrRec.CreditCardInstr.Attribute18, l_url, l_db_nls, l_ecapp_nls);
514: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute19', p_pmtInstrRec.CreditCardInstr.Attribute19, l_url, l_db_nls, l_ecapp_nls);
515: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute20', p_pmtInstrRec.CreditCardInstr.Attribute20, l_url, l_db_nls, l_ecapp_nls);

Line 512: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute17', p_pmtInstrRec.CreditCardInstr.Attribute17, l_url, l_db_nls, l_ecapp_nls);

508: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute13', p_pmtInstrRec.CreditCardInstr.Attribute13, l_url, l_db_nls, l_ecapp_nls);
509: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute14', p_pmtInstrRec.CreditCardInstr.Attribute14, l_url, l_db_nls, l_ecapp_nls);
510: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute15', p_pmtInstrRec.CreditCardInstr.Attribute15, l_url, l_db_nls, l_ecapp_nls);
511: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute16', p_pmtInstrRec.CreditCardInstr.Attribute16, l_url, l_db_nls, l_ecapp_nls);
512: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute17', p_pmtInstrRec.CreditCardInstr.Attribute17, l_url, l_db_nls, l_ecapp_nls);
513: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute18', p_pmtInstrRec.CreditCardInstr.Attribute18, l_url, l_db_nls, l_ecapp_nls);
514: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute19', p_pmtInstrRec.CreditCardInstr.Attribute19, l_url, l_db_nls, l_ecapp_nls);
515: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute20', p_pmtInstrRec.CreditCardInstr.Attribute20, l_url, l_db_nls, l_ecapp_nls);
516: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute21', p_pmtInstrRec.CreditCardInstr.Attribute21, l_url, l_db_nls, l_ecapp_nls);

Line 513: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute18', p_pmtInstrRec.CreditCardInstr.Attribute18, l_url, l_db_nls, l_ecapp_nls);

509: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute14', p_pmtInstrRec.CreditCardInstr.Attribute14, l_url, l_db_nls, l_ecapp_nls);
510: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute15', p_pmtInstrRec.CreditCardInstr.Attribute15, l_url, l_db_nls, l_ecapp_nls);
511: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute16', p_pmtInstrRec.CreditCardInstr.Attribute16, l_url, l_db_nls, l_ecapp_nls);
512: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute17', p_pmtInstrRec.CreditCardInstr.Attribute17, l_url, l_db_nls, l_ecapp_nls);
513: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute18', p_pmtInstrRec.CreditCardInstr.Attribute18, l_url, l_db_nls, l_ecapp_nls);
514: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute19', p_pmtInstrRec.CreditCardInstr.Attribute19, l_url, l_db_nls, l_ecapp_nls);
515: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute20', p_pmtInstrRec.CreditCardInstr.Attribute20, l_url, l_db_nls, l_ecapp_nls);
516: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute21', p_pmtInstrRec.CreditCardInstr.Attribute21, l_url, l_db_nls, l_ecapp_nls);
517: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute22', p_pmtInstrRec.CreditCardInstr.Attribute22, l_url, l_db_nls, l_ecapp_nls);

Line 514: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute19', p_pmtInstrRec.CreditCardInstr.Attribute19, l_url, l_db_nls, l_ecapp_nls);

510: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute15', p_pmtInstrRec.CreditCardInstr.Attribute15, l_url, l_db_nls, l_ecapp_nls);
511: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute16', p_pmtInstrRec.CreditCardInstr.Attribute16, l_url, l_db_nls, l_ecapp_nls);
512: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute17', p_pmtInstrRec.CreditCardInstr.Attribute17, l_url, l_db_nls, l_ecapp_nls);
513: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute18', p_pmtInstrRec.CreditCardInstr.Attribute18, l_url, l_db_nls, l_ecapp_nls);
514: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute19', p_pmtInstrRec.CreditCardInstr.Attribute19, l_url, l_db_nls, l_ecapp_nls);
515: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute20', p_pmtInstrRec.CreditCardInstr.Attribute20, l_url, l_db_nls, l_ecapp_nls);
516: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute21', p_pmtInstrRec.CreditCardInstr.Attribute21, l_url, l_db_nls, l_ecapp_nls);
517: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute22', p_pmtInstrRec.CreditCardInstr.Attribute22, l_url, l_db_nls, l_ecapp_nls);
518: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute23', p_pmtInstrRec.CreditCardInstr.Attribute23, l_url, l_db_nls, l_ecapp_nls);

Line 515: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute20', p_pmtInstrRec.CreditCardInstr.Attribute20, l_url, l_db_nls, l_ecapp_nls);

511: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute16', p_pmtInstrRec.CreditCardInstr.Attribute16, l_url, l_db_nls, l_ecapp_nls);
512: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute17', p_pmtInstrRec.CreditCardInstr.Attribute17, l_url, l_db_nls, l_ecapp_nls);
513: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute18', p_pmtInstrRec.CreditCardInstr.Attribute18, l_url, l_db_nls, l_ecapp_nls);
514: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute19', p_pmtInstrRec.CreditCardInstr.Attribute19, l_url, l_db_nls, l_ecapp_nls);
515: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute20', p_pmtInstrRec.CreditCardInstr.Attribute20, l_url, l_db_nls, l_ecapp_nls);
516: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute21', p_pmtInstrRec.CreditCardInstr.Attribute21, l_url, l_db_nls, l_ecapp_nls);
517: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute22', p_pmtInstrRec.CreditCardInstr.Attribute22, l_url, l_db_nls, l_ecapp_nls);
518: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute23', p_pmtInstrRec.CreditCardInstr.Attribute23, l_url, l_db_nls, l_ecapp_nls);
519: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute24', p_pmtInstrRec.CreditCardInstr.Attribute24, l_url, l_db_nls, l_ecapp_nls);

Line 516: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute21', p_pmtInstrRec.CreditCardInstr.Attribute21, l_url, l_db_nls, l_ecapp_nls);

512: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute17', p_pmtInstrRec.CreditCardInstr.Attribute17, l_url, l_db_nls, l_ecapp_nls);
513: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute18', p_pmtInstrRec.CreditCardInstr.Attribute18, l_url, l_db_nls, l_ecapp_nls);
514: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute19', p_pmtInstrRec.CreditCardInstr.Attribute19, l_url, l_db_nls, l_ecapp_nls);
515: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute20', p_pmtInstrRec.CreditCardInstr.Attribute20, l_url, l_db_nls, l_ecapp_nls);
516: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute21', p_pmtInstrRec.CreditCardInstr.Attribute21, l_url, l_db_nls, l_ecapp_nls);
517: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute22', p_pmtInstrRec.CreditCardInstr.Attribute22, l_url, l_db_nls, l_ecapp_nls);
518: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute23', p_pmtInstrRec.CreditCardInstr.Attribute23, l_url, l_db_nls, l_ecapp_nls);
519: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute24', p_pmtInstrRec.CreditCardInstr.Attribute24, l_url, l_db_nls, l_ecapp_nls);
520: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute25', p_pmtInstrRec.CreditCardInstr.Attribute25, l_url, l_db_nls, l_ecapp_nls);

Line 517: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute22', p_pmtInstrRec.CreditCardInstr.Attribute22, l_url, l_db_nls, l_ecapp_nls);

513: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute18', p_pmtInstrRec.CreditCardInstr.Attribute18, l_url, l_db_nls, l_ecapp_nls);
514: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute19', p_pmtInstrRec.CreditCardInstr.Attribute19, l_url, l_db_nls, l_ecapp_nls);
515: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute20', p_pmtInstrRec.CreditCardInstr.Attribute20, l_url, l_db_nls, l_ecapp_nls);
516: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute21', p_pmtInstrRec.CreditCardInstr.Attribute21, l_url, l_db_nls, l_ecapp_nls);
517: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute22', p_pmtInstrRec.CreditCardInstr.Attribute22, l_url, l_db_nls, l_ecapp_nls);
518: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute23', p_pmtInstrRec.CreditCardInstr.Attribute23, l_url, l_db_nls, l_ecapp_nls);
519: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute24', p_pmtInstrRec.CreditCardInstr.Attribute24, l_url, l_db_nls, l_ecapp_nls);
520: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute25', p_pmtInstrRec.CreditCardInstr.Attribute25, l_url, l_db_nls, l_ecapp_nls);
521: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute26', p_pmtInstrRec.CreditCardInstr.Attribute26, l_url, l_db_nls, l_ecapp_nls);

Line 518: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute23', p_pmtInstrRec.CreditCardInstr.Attribute23, l_url, l_db_nls, l_ecapp_nls);

514: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute19', p_pmtInstrRec.CreditCardInstr.Attribute19, l_url, l_db_nls, l_ecapp_nls);
515: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute20', p_pmtInstrRec.CreditCardInstr.Attribute20, l_url, l_db_nls, l_ecapp_nls);
516: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute21', p_pmtInstrRec.CreditCardInstr.Attribute21, l_url, l_db_nls, l_ecapp_nls);
517: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute22', p_pmtInstrRec.CreditCardInstr.Attribute22, l_url, l_db_nls, l_ecapp_nls);
518: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute23', p_pmtInstrRec.CreditCardInstr.Attribute23, l_url, l_db_nls, l_ecapp_nls);
519: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute24', p_pmtInstrRec.CreditCardInstr.Attribute24, l_url, l_db_nls, l_ecapp_nls);
520: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute25', p_pmtInstrRec.CreditCardInstr.Attribute25, l_url, l_db_nls, l_ecapp_nls);
521: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute26', p_pmtInstrRec.CreditCardInstr.Attribute26, l_url, l_db_nls, l_ecapp_nls);
522: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute27', p_pmtInstrRec.CreditCardInstr.Attribute27, l_url, l_db_nls, l_ecapp_nls);

Line 519: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute24', p_pmtInstrRec.CreditCardInstr.Attribute24, l_url, l_db_nls, l_ecapp_nls);

515: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute20', p_pmtInstrRec.CreditCardInstr.Attribute20, l_url, l_db_nls, l_ecapp_nls);
516: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute21', p_pmtInstrRec.CreditCardInstr.Attribute21, l_url, l_db_nls, l_ecapp_nls);
517: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute22', p_pmtInstrRec.CreditCardInstr.Attribute22, l_url, l_db_nls, l_ecapp_nls);
518: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute23', p_pmtInstrRec.CreditCardInstr.Attribute23, l_url, l_db_nls, l_ecapp_nls);
519: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute24', p_pmtInstrRec.CreditCardInstr.Attribute24, l_url, l_db_nls, l_ecapp_nls);
520: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute25', p_pmtInstrRec.CreditCardInstr.Attribute25, l_url, l_db_nls, l_ecapp_nls);
521: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute26', p_pmtInstrRec.CreditCardInstr.Attribute26, l_url, l_db_nls, l_ecapp_nls);
522: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute27', p_pmtInstrRec.CreditCardInstr.Attribute27, l_url, l_db_nls, l_ecapp_nls);
523: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute28', p_pmtInstrRec.CreditCardInstr.Attribute28, l_url, l_db_nls, l_ecapp_nls);

Line 520: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute25', p_pmtInstrRec.CreditCardInstr.Attribute25, l_url, l_db_nls, l_ecapp_nls);

516: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute21', p_pmtInstrRec.CreditCardInstr.Attribute21, l_url, l_db_nls, l_ecapp_nls);
517: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute22', p_pmtInstrRec.CreditCardInstr.Attribute22, l_url, l_db_nls, l_ecapp_nls);
518: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute23', p_pmtInstrRec.CreditCardInstr.Attribute23, l_url, l_db_nls, l_ecapp_nls);
519: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute24', p_pmtInstrRec.CreditCardInstr.Attribute24, l_url, l_db_nls, l_ecapp_nls);
520: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute25', p_pmtInstrRec.CreditCardInstr.Attribute25, l_url, l_db_nls, l_ecapp_nls);
521: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute26', p_pmtInstrRec.CreditCardInstr.Attribute26, l_url, l_db_nls, l_ecapp_nls);
522: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute27', p_pmtInstrRec.CreditCardInstr.Attribute27, l_url, l_db_nls, l_ecapp_nls);
523: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute28', p_pmtInstrRec.CreditCardInstr.Attribute28, l_url, l_db_nls, l_ecapp_nls);
524: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute29', p_pmtInstrRec.CreditCardInstr.Attribute29, l_url, l_db_nls, l_ecapp_nls);

Line 521: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute26', p_pmtInstrRec.CreditCardInstr.Attribute26, l_url, l_db_nls, l_ecapp_nls);

517: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute22', p_pmtInstrRec.CreditCardInstr.Attribute22, l_url, l_db_nls, l_ecapp_nls);
518: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute23', p_pmtInstrRec.CreditCardInstr.Attribute23, l_url, l_db_nls, l_ecapp_nls);
519: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute24', p_pmtInstrRec.CreditCardInstr.Attribute24, l_url, l_db_nls, l_ecapp_nls);
520: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute25', p_pmtInstrRec.CreditCardInstr.Attribute25, l_url, l_db_nls, l_ecapp_nls);
521: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute26', p_pmtInstrRec.CreditCardInstr.Attribute26, l_url, l_db_nls, l_ecapp_nls);
522: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute27', p_pmtInstrRec.CreditCardInstr.Attribute27, l_url, l_db_nls, l_ecapp_nls);
523: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute28', p_pmtInstrRec.CreditCardInstr.Attribute28, l_url, l_db_nls, l_ecapp_nls);
524: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute29', p_pmtInstrRec.CreditCardInstr.Attribute29, l_url, l_db_nls, l_ecapp_nls);
525: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute30', p_pmtInstrRec.CreditCardInstr.Attribute30, l_url, l_db_nls, l_ecapp_nls);

Line 522: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute27', p_pmtInstrRec.CreditCardInstr.Attribute27, l_url, l_db_nls, l_ecapp_nls);

518: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute23', p_pmtInstrRec.CreditCardInstr.Attribute23, l_url, l_db_nls, l_ecapp_nls);
519: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute24', p_pmtInstrRec.CreditCardInstr.Attribute24, l_url, l_db_nls, l_ecapp_nls);
520: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute25', p_pmtInstrRec.CreditCardInstr.Attribute25, l_url, l_db_nls, l_ecapp_nls);
521: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute26', p_pmtInstrRec.CreditCardInstr.Attribute26, l_url, l_db_nls, l_ecapp_nls);
522: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute27', p_pmtInstrRec.CreditCardInstr.Attribute27, l_url, l_db_nls, l_ecapp_nls);
523: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute28', p_pmtInstrRec.CreditCardInstr.Attribute28, l_url, l_db_nls, l_ecapp_nls);
524: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute29', p_pmtInstrRec.CreditCardInstr.Attribute29, l_url, l_db_nls, l_ecapp_nls);
525: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute30', p_pmtInstrRec.CreditCardInstr.Attribute30, l_url, l_db_nls, l_ecapp_nls);
526: IBY_NETUTILS_PVT.check_optional('OapfRegstrInvalidCard', p_pmtInstrRec.CreditCardInstr.Register_Invalid_Card, l_url, l_db_nls, l_ecapp_nls);

Line 523: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute28', p_pmtInstrRec.CreditCardInstr.Attribute28, l_url, l_db_nls, l_ecapp_nls);

519: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute24', p_pmtInstrRec.CreditCardInstr.Attribute24, l_url, l_db_nls, l_ecapp_nls);
520: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute25', p_pmtInstrRec.CreditCardInstr.Attribute25, l_url, l_db_nls, l_ecapp_nls);
521: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute26', p_pmtInstrRec.CreditCardInstr.Attribute26, l_url, l_db_nls, l_ecapp_nls);
522: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute27', p_pmtInstrRec.CreditCardInstr.Attribute27, l_url, l_db_nls, l_ecapp_nls);
523: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute28', p_pmtInstrRec.CreditCardInstr.Attribute28, l_url, l_db_nls, l_ecapp_nls);
524: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute29', p_pmtInstrRec.CreditCardInstr.Attribute29, l_url, l_db_nls, l_ecapp_nls);
525: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute30', p_pmtInstrRec.CreditCardInstr.Attribute30, l_url, l_db_nls, l_ecapp_nls);
526: IBY_NETUTILS_PVT.check_optional('OapfRegstrInvalidCard', p_pmtInstrRec.CreditCardInstr.Register_Invalid_Card, l_url, l_db_nls, l_ecapp_nls);
527:

Line 524: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute29', p_pmtInstrRec.CreditCardInstr.Attribute29, l_url, l_db_nls, l_ecapp_nls);

520: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute25', p_pmtInstrRec.CreditCardInstr.Attribute25, l_url, l_db_nls, l_ecapp_nls);
521: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute26', p_pmtInstrRec.CreditCardInstr.Attribute26, l_url, l_db_nls, l_ecapp_nls);
522: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute27', p_pmtInstrRec.CreditCardInstr.Attribute27, l_url, l_db_nls, l_ecapp_nls);
523: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute28', p_pmtInstrRec.CreditCardInstr.Attribute28, l_url, l_db_nls, l_ecapp_nls);
524: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute29', p_pmtInstrRec.CreditCardInstr.Attribute29, l_url, l_db_nls, l_ecapp_nls);
525: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute30', p_pmtInstrRec.CreditCardInstr.Attribute30, l_url, l_db_nls, l_ecapp_nls);
526: IBY_NETUTILS_PVT.check_optional('OapfRegstrInvalidCard', p_pmtInstrRec.CreditCardInstr.Register_Invalid_Card, l_url, l_db_nls, l_ecapp_nls);
527:
528: END IF;

Line 525: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute30', p_pmtInstrRec.CreditCardInstr.Attribute30, l_url, l_db_nls, l_ecapp_nls);

521: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute26', p_pmtInstrRec.CreditCardInstr.Attribute26, l_url, l_db_nls, l_ecapp_nls);
522: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute27', p_pmtInstrRec.CreditCardInstr.Attribute27, l_url, l_db_nls, l_ecapp_nls);
523: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute28', p_pmtInstrRec.CreditCardInstr.Attribute28, l_url, l_db_nls, l_ecapp_nls);
524: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute29', p_pmtInstrRec.CreditCardInstr.Attribute29, l_url, l_db_nls, l_ecapp_nls);
525: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute30', p_pmtInstrRec.CreditCardInstr.Attribute30, l_url, l_db_nls, l_ecapp_nls);
526: IBY_NETUTILS_PVT.check_optional('OapfRegstrInvalidCard', p_pmtInstrRec.CreditCardInstr.Register_Invalid_Card, l_url, l_db_nls, l_ecapp_nls);
527:
528: END IF;
529:

Line 526: IBY_NETUTILS_PVT.check_optional('OapfRegstrInvalidCard', p_pmtInstrRec.CreditCardInstr.Register_Invalid_Card, l_url, l_db_nls, l_ecapp_nls);

522: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute27', p_pmtInstrRec.CreditCardInstr.Attribute27, l_url, l_db_nls, l_ecapp_nls);
523: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute28', p_pmtInstrRec.CreditCardInstr.Attribute28, l_url, l_db_nls, l_ecapp_nls);
524: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute29', p_pmtInstrRec.CreditCardInstr.Attribute29, l_url, l_db_nls, l_ecapp_nls);
525: IBY_NETUTILS_PVT.check_optional('OapfInstrAttribute30', p_pmtInstrRec.CreditCardInstr.Attribute30, l_url, l_db_nls, l_ecapp_nls);
526: IBY_NETUTILS_PVT.check_optional('OapfRegstrInvalidCard', p_pmtInstrRec.CreditCardInstr.Register_Invalid_Card, l_url, l_db_nls, l_ecapp_nls);
527:
528: END IF;
529:
530: -- Send http request to the payment server

Line 535: IBY_NETUTILS_PVT.check_optional('OapfNlsLang', p_pmtInstrRec.nls_lang_param, l_url, l_db_nls, l_ecapp_nls);

531: --l_html := UTL_HTTP.REQUEST(l_url);
532:
533: /* Bug 6318167 */
534: IF p_pmtInstrRec.nls_lang_param IS NOT NULL THEN
535: IBY_NETUTILS_PVT.check_optional('OapfNlsLang', p_pmtInstrRec.nls_lang_param, l_url, l_db_nls, l_ecapp_nls);
536: END IF;
537:
538: -- set the security token
539: iby_security_pkg.store_credential(l_url,l_sec_cred);

Line 540: iby_netutils_pvt.check_mandatory('OapfSecurityToken', TO_CHAR(l_sec_cred),

536: END IF;
537:
538: -- set the security token
539: iby_security_pkg.store_credential(l_url,l_sec_cred);
540: iby_netutils_pvt.check_mandatory('OapfSecurityToken', TO_CHAR(l_sec_cred),
541: l_url, l_db_nls, l_ecapp_nls);
542:
543: -- iby_debug_pub.add(debug_msg => 'OraInstrAdd => full url: '|| l_url,
544: -- debug_level => iby_debug_pub.G_LEVEL_INFO,

Line 557: IBY_NETUTILS_PVT.POST_REQUEST(l_url,l_post_body,l_html);

553: --dbms_output.put_line('l_url : '||l_url);
554: --dbms_output.put_line('l_post_body : '||l_post_body);
555:
556: -- sending Post Request
557: IBY_NETUTILS_PVT.POST_REQUEST(l_url,l_post_body,l_html);
558:
559: -- Unpack the results
560: IBY_NETUTILS_PVT.UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
561:

Line 560: IBY_NETUTILS_PVT.UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);

556: -- sending Post Request
557: IBY_NETUTILS_PVT.POST_REQUEST(l_url,l_post_body,l_html);
558:
559: -- Unpack the results
560: IBY_NETUTILS_PVT.UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
561:
562: iby_debug_pub.add('Return Parameter count : '|| l_values.COUNT,
563: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
564:

Line 1641: l_names IBY_NETUTILS_PVT.v240_tbl_type;

1637:
1638: l_pos NUMBER := 0;
1639: l_post_body VARCHAR2(30000);
1640: l_html VARCHAR2(32767) ;
1641: l_names IBY_NETUTILS_PVT.v240_tbl_type;
1642: l_values IBY_NETUTILS_PVT.v240_tbl_type;
1643:
1644:
1645: --The following 3 variables are meant for output of

Line 1642: l_values IBY_NETUTILS_PVT.v240_tbl_type;

1638: l_pos NUMBER := 0;
1639: l_post_body VARCHAR2(30000);
1640: l_html VARCHAR2(32767) ;
1641: l_names IBY_NETUTILS_PVT.v240_tbl_type;
1642: l_values IBY_NETUTILS_PVT.v240_tbl_type;
1643:
1644:
1645: --The following 3 variables are meant for output of
1646: --unpack_results_url procedure.

Line 1668: IBY_NETUTILS_PVT.get_baseurl(l_get_baseurl);

1664: AND p_cardHolderName IS NULL) THEN
1665: RETURN;
1666: END IF;
1667:
1668: IBY_NETUTILS_PVT.get_baseurl(l_get_baseurl);
1669: --dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
1670: --test_debug('SecureCardInfo l_get_baseurl= '|| l_get_baseurl);
1671: -- dbms_output.put_line('l_status_url= ' || l_status_url);
1672: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);

Line 1678: l_db_nls := IBY_NETUTILS_PVT.get_local_nls();

1674:
1675: -- Construct the full URL to send to the ECServlet.
1676: l_url := l_get_baseurl;
1677:
1678: l_db_nls := IBY_NETUTILS_PVT.get_local_nls();
1679: l_ecapp_nls := NULL; -- not passed in this api??
1680:
1681: --MANDATORY INPUT PARAMETERS
1682: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);

Line 1682: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);

1678: l_db_nls := IBY_NETUTILS_PVT.get_local_nls();
1679: l_ecapp_nls := NULL; -- not passed in this api??
1680:
1681: --MANDATORY INPUT PARAMETERS
1682: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);
1683:
1684: --OPTIONAL INPUT PARAMETERS
1685: IBY_NETUTILS_PVT.check_optional('OapfExpDate', to_char(p_cardExpiryDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
1686: IBY_NETUTILS_PVT.check_optional('OapfExpSegmentId', p_expSegmentId, l_url, l_db_nls, l_ecapp_nls);

Line 1685: IBY_NETUTILS_PVT.check_optional('OapfExpDate', to_char(p_cardExpiryDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);

1681: --MANDATORY INPUT PARAMETERS
1682: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);
1683:
1684: --OPTIONAL INPUT PARAMETERS
1685: IBY_NETUTILS_PVT.check_optional('OapfExpDate', to_char(p_cardExpiryDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
1686: IBY_NETUTILS_PVT.check_optional('OapfExpSegmentId', p_expSegmentId, l_url, l_db_nls, l_ecapp_nls);
1687: IBY_NETUTILS_PVT.check_optional('OapfChname', p_cardHolderName, l_url, l_db_nls, l_ecapp_nls);
1688: IBY_NETUTILS_PVT.check_optional('OapfChnameSegmentId', p_chnameSegmentId, l_url, l_db_nls, l_ecapp_nls);
1689: IBY_NETUTILS_PVT.check_optional('OapfChnameMaskSetting', p_chnameMaskSetting, l_url, l_db_nls, l_ecapp_nls);

Line 1686: IBY_NETUTILS_PVT.check_optional('OapfExpSegmentId', p_expSegmentId, l_url, l_db_nls, l_ecapp_nls);

1682: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);
1683:
1684: --OPTIONAL INPUT PARAMETERS
1685: IBY_NETUTILS_PVT.check_optional('OapfExpDate', to_char(p_cardExpiryDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
1686: IBY_NETUTILS_PVT.check_optional('OapfExpSegmentId', p_expSegmentId, l_url, l_db_nls, l_ecapp_nls);
1687: IBY_NETUTILS_PVT.check_optional('OapfChname', p_cardHolderName, l_url, l_db_nls, l_ecapp_nls);
1688: IBY_NETUTILS_PVT.check_optional('OapfChnameSegmentId', p_chnameSegmentId, l_url, l_db_nls, l_ecapp_nls);
1689: IBY_NETUTILS_PVT.check_optional('OapfChnameMaskSetting', p_chnameMaskSetting, l_url, l_db_nls, l_ecapp_nls);
1690: IBY_NETUTILS_PVT.check_optional('OapfChnameUnmaskLen', p_chnameUnmaskLength, l_url, l_db_nls, l_ecapp_nls);

Line 1687: IBY_NETUTILS_PVT.check_optional('OapfChname', p_cardHolderName, l_url, l_db_nls, l_ecapp_nls);

1683:
1684: --OPTIONAL INPUT PARAMETERS
1685: IBY_NETUTILS_PVT.check_optional('OapfExpDate', to_char(p_cardExpiryDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
1686: IBY_NETUTILS_PVT.check_optional('OapfExpSegmentId', p_expSegmentId, l_url, l_db_nls, l_ecapp_nls);
1687: IBY_NETUTILS_PVT.check_optional('OapfChname', p_cardHolderName, l_url, l_db_nls, l_ecapp_nls);
1688: IBY_NETUTILS_PVT.check_optional('OapfChnameSegmentId', p_chnameSegmentId, l_url, l_db_nls, l_ecapp_nls);
1689: IBY_NETUTILS_PVT.check_optional('OapfChnameMaskSetting', p_chnameMaskSetting, l_url, l_db_nls, l_ecapp_nls);
1690: IBY_NETUTILS_PVT.check_optional('OapfChnameUnmaskLen', p_chnameUnmaskLength, l_url, l_db_nls, l_ecapp_nls);
1691:

Line 1688: IBY_NETUTILS_PVT.check_optional('OapfChnameSegmentId', p_chnameSegmentId, l_url, l_db_nls, l_ecapp_nls);

1684: --OPTIONAL INPUT PARAMETERS
1685: IBY_NETUTILS_PVT.check_optional('OapfExpDate', to_char(p_cardExpiryDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
1686: IBY_NETUTILS_PVT.check_optional('OapfExpSegmentId', p_expSegmentId, l_url, l_db_nls, l_ecapp_nls);
1687: IBY_NETUTILS_PVT.check_optional('OapfChname', p_cardHolderName, l_url, l_db_nls, l_ecapp_nls);
1688: IBY_NETUTILS_PVT.check_optional('OapfChnameSegmentId', p_chnameSegmentId, l_url, l_db_nls, l_ecapp_nls);
1689: IBY_NETUTILS_PVT.check_optional('OapfChnameMaskSetting', p_chnameMaskSetting, l_url, l_db_nls, l_ecapp_nls);
1690: IBY_NETUTILS_PVT.check_optional('OapfChnameUnmaskLen', p_chnameUnmaskLength, l_url, l_db_nls, l_ecapp_nls);
1691:
1692: -- set the security token

Line 1689: IBY_NETUTILS_PVT.check_optional('OapfChnameMaskSetting', p_chnameMaskSetting, l_url, l_db_nls, l_ecapp_nls);

1685: IBY_NETUTILS_PVT.check_optional('OapfExpDate', to_char(p_cardExpiryDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
1686: IBY_NETUTILS_PVT.check_optional('OapfExpSegmentId', p_expSegmentId, l_url, l_db_nls, l_ecapp_nls);
1687: IBY_NETUTILS_PVT.check_optional('OapfChname', p_cardHolderName, l_url, l_db_nls, l_ecapp_nls);
1688: IBY_NETUTILS_PVT.check_optional('OapfChnameSegmentId', p_chnameSegmentId, l_url, l_db_nls, l_ecapp_nls);
1689: IBY_NETUTILS_PVT.check_optional('OapfChnameMaskSetting', p_chnameMaskSetting, l_url, l_db_nls, l_ecapp_nls);
1690: IBY_NETUTILS_PVT.check_optional('OapfChnameUnmaskLen', p_chnameUnmaskLength, l_url, l_db_nls, l_ecapp_nls);
1691:
1692: -- set the security token
1693: iby_security_pkg.store_credential(l_url,l_sec_cred);

Line 1690: IBY_NETUTILS_PVT.check_optional('OapfChnameUnmaskLen', p_chnameUnmaskLength, l_url, l_db_nls, l_ecapp_nls);

1686: IBY_NETUTILS_PVT.check_optional('OapfExpSegmentId', p_expSegmentId, l_url, l_db_nls, l_ecapp_nls);
1687: IBY_NETUTILS_PVT.check_optional('OapfChname', p_cardHolderName, l_url, l_db_nls, l_ecapp_nls);
1688: IBY_NETUTILS_PVT.check_optional('OapfChnameSegmentId', p_chnameSegmentId, l_url, l_db_nls, l_ecapp_nls);
1689: IBY_NETUTILS_PVT.check_optional('OapfChnameMaskSetting', p_chnameMaskSetting, l_url, l_db_nls, l_ecapp_nls);
1690: IBY_NETUTILS_PVT.check_optional('OapfChnameUnmaskLen', p_chnameUnmaskLength, l_url, l_db_nls, l_ecapp_nls);
1691:
1692: -- set the security token
1693: iby_security_pkg.store_credential(l_url,l_sec_cred);
1694: iby_netutils_pvt.check_mandatory('OapfSecurityToken', TO_CHAR(l_sec_cred),

Line 1694: iby_netutils_pvt.check_mandatory('OapfSecurityToken', TO_CHAR(l_sec_cred),

1690: IBY_NETUTILS_PVT.check_optional('OapfChnameUnmaskLen', p_chnameUnmaskLength, l_url, l_db_nls, l_ecapp_nls);
1691:
1692: -- set the security token
1693: iby_security_pkg.store_credential(l_url,l_sec_cred);
1694: iby_netutils_pvt.check_mandatory('OapfSecurityToken', TO_CHAR(l_sec_cred),
1695: l_url, l_db_nls, l_ecapp_nls);
1696:
1697: --test_debug('SecureCardInfo=> full url: '|| l_url);
1698: -- iby_debug_pub.add(debug_msg => 'SecureCardInfo=> full url: '|| l_url,

Line 1709: IBY_NETUTILS_PVT.POST_REQUEST(l_url,l_post_body,l_html);

1705: -- test_debug('SecureCardInfo=> url after stripping: '|| l_url);
1706: -- test_debug('SecureCardInfo=> post body: '|| l_post_body);
1707:
1708:
1709: IBY_NETUTILS_PVT.POST_REQUEST(l_url,l_post_body,l_html);
1710:
1711: -- Unpack the results
1712: IBY_NETUTILS_PVT.UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
1713:

Line 1712: IBY_NETUTILS_PVT.UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);

1708:
1709: IBY_NETUTILS_PVT.POST_REQUEST(l_url,l_post_body,l_html);
1710:
1711: -- Unpack the results
1712: IBY_NETUTILS_PVT.UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
1713:
1714:
1715: --Raising Exception to handle errors in unpacking resulting html file.
1716: IF (l_status = -1) THEN

Line 1888: l_names IBY_NETUTILS_PVT.v240_tbl_type;

1884:
1885: l_pos NUMBER := 0;
1886: l_post_body VARCHAR2(30000);
1887: l_html VARCHAR2(32767) ;
1888: l_names IBY_NETUTILS_PVT.v240_tbl_type;
1889: l_values IBY_NETUTILS_PVT.v240_tbl_type;
1890:
1891:
1892: --The following 3 variables are meant for output of

Line 1889: l_values IBY_NETUTILS_PVT.v240_tbl_type;

1885: l_pos NUMBER := 0;
1886: l_post_body VARCHAR2(30000);
1887: l_html VARCHAR2(32767) ;
1888: l_names IBY_NETUTILS_PVT.v240_tbl_type;
1889: l_values IBY_NETUTILS_PVT.v240_tbl_type;
1890:
1891:
1892: --The following 3 variables are meant for output of
1893: --unpack_results_url procedure.

Line 1909: IBY_NETUTILS_PVT.get_baseurl(l_get_baseurl);

1905:
1906: -- START OF BODY OF API
1907:
1908:
1909: IBY_NETUTILS_PVT.get_baseurl(l_get_baseurl);
1910: --dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
1911: --test_debug('SecureCardInfo l_get_baseurl= '|| l_get_baseurl);
1912: -- dbms_output.put_line('l_status_url= ' || l_status_url);
1913: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);

Line 1919: l_db_nls := IBY_NETUTILS_PVT.get_local_nls();

1915:
1916: -- Construct the full URL to send to the ECServlet.
1917: l_url := l_get_baseurl;
1918:
1919: l_db_nls := IBY_NETUTILS_PVT.get_local_nls();
1920: l_ecapp_nls := NULL; -- not passed in this api??
1921:
1922: --MANDATORY INPUT PARAMETERS
1923: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);

Line 1923: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);

1919: l_db_nls := IBY_NETUTILS_PVT.get_local_nls();
1920: l_ecapp_nls := NULL; -- not passed in this api??
1921:
1922: --MANDATORY INPUT PARAMETERS
1923: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);
1924:
1925: IBY_NETUTILS_PVT.check_mandatory('OapfInstrid', p_instrid, l_url, l_db_nls, l_ecapp_nls);
1926: IBY_NETUTILS_PVT.check_mandatory('OapfInputDate', to_char(p_inputDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
1927:

Line 1925: IBY_NETUTILS_PVT.check_mandatory('OapfInstrid', p_instrid, l_url, l_db_nls, l_ecapp_nls);

1921:
1922: --MANDATORY INPUT PARAMETERS
1923: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);
1924:
1925: IBY_NETUTILS_PVT.check_mandatory('OapfInstrid', p_instrid, l_url, l_db_nls, l_ecapp_nls);
1926: IBY_NETUTILS_PVT.check_mandatory('OapfInputDate', to_char(p_inputDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
1927:
1928: -- set the security token
1929: iby_security_pkg.store_credential(l_url,l_sec_cred);

Line 1926: IBY_NETUTILS_PVT.check_mandatory('OapfInputDate', to_char(p_inputDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);

1922: --MANDATORY INPUT PARAMETERS
1923: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);
1924:
1925: IBY_NETUTILS_PVT.check_mandatory('OapfInstrid', p_instrid, l_url, l_db_nls, l_ecapp_nls);
1926: IBY_NETUTILS_PVT.check_mandatory('OapfInputDate', to_char(p_inputDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
1927:
1928: -- set the security token
1929: iby_security_pkg.store_credential(l_url,l_sec_cred);
1930: iby_netutils_pvt.check_mandatory('OapfSecurityToken', TO_CHAR(l_sec_cred),

Line 1930: iby_netutils_pvt.check_mandatory('OapfSecurityToken', TO_CHAR(l_sec_cred),

1926: IBY_NETUTILS_PVT.check_mandatory('OapfInputDate', to_char(p_inputDate,'YYYY-MM-DD'), l_url, l_db_nls, l_ecapp_nls);
1927:
1928: -- set the security token
1929: iby_security_pkg.store_credential(l_url,l_sec_cred);
1930: iby_netutils_pvt.check_mandatory('OapfSecurityToken', TO_CHAR(l_sec_cred),
1931: l_url, l_db_nls, l_ecapp_nls);
1932:
1933: --test_debug('Get_Expiration_Status=> full url: '|| l_url);
1934: iby_debug_pub.add(debug_msg => 'Get_Expiration_Status=> full url: '|| l_url,

Line 1945: IBY_NETUTILS_PVT.POST_REQUEST(l_url,l_post_body,l_html);

1941: -- test_debug('SecureCardInfo=> url after stripping: '|| l_url);
1942: -- test_debug('SecureCardInfo=> post body: '|| l_post_body);
1943:
1944:
1945: IBY_NETUTILS_PVT.POST_REQUEST(l_url,l_post_body,l_html);
1946:
1947: -- Unpack the results
1948: IBY_NETUTILS_PVT.UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
1949:

Line 1948: IBY_NETUTILS_PVT.UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);

1944:
1945: IBY_NETUTILS_PVT.POST_REQUEST(l_url,l_post_body,l_html);
1946:
1947: -- Unpack the results
1948: IBY_NETUTILS_PVT.UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
1949:
1950:
1951: --Raising Exception to handle errors in unpacking resulting html file.
1952: IF (l_status = -1) THEN