[Home] [Help]
208: last_update_login, object_version_number
209: )
210: VALUES
211: (x_segment_id, l_segment_cipher, lx_subkey_id, 'NUMERIC',
212: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
213: fnd_global.login_id, 1
214: );
215: ELSE
216: -- indicative of PCI encryption
209: )
210: VALUES
211: (x_segment_id, l_segment_cipher, lx_subkey_id, 'NUMERIC',
212: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
213: fnd_global.login_id, 1
214: );
215: ELSE
216: -- indicative of PCI encryption
217: x_segment_id := -1;
248: object_version_number)
249: VALUES
250: (iby_trxn_extensibility_s.NEXTVAL,
251: p_trxnmid,p_extend_names(i),p_extend_vals(i),
252: fnd_global.user_id,sysdate,fnd_global.user_id,sysdate,
253: fnd_global.login_id,1);
254: END LOOP;
255:
256: IF (p_commit = 'Y') THEN
249: VALUES
250: (iby_trxn_extensibility_s.NEXTVAL,
251: p_trxnmid,p_extend_names(i),p_extend_vals(i),
252: fnd_global.user_id,sysdate,fnd_global.user_id,sysdate,
253: fnd_global.login_id,1);
254: END LOOP;
255:
256: IF (p_commit = 'Y') THEN
257: COMMIT;
486: order_id_in, l_mpayeeid, merchant_id_in, vendor_id_in,
487: vendor_key_in, l_tmid, vendor_code_in, vendor_message_in,
488: error_location_in, ecapp_id_in, org_id_in,
489: payerinstrid_in, l_instrnum, payerid_in, instrType_in,
490: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
491: fnd_global.login_id, 1, l_cc_type, trxnref_in,
492: org_type_in, payment_channel_code_in, factored_flag_in,
493: lx_range_id, lx_cc_hash, lx_instr_len, lx_segment_id,
494: l_payer_party_id, process_profile_code_in,
487: vendor_key_in, l_tmid, vendor_code_in, vendor_message_in,
488: error_location_in, ecapp_id_in, org_id_in,
489: payerinstrid_in, l_instrnum, payerid_in, instrType_in,
490: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
491: fnd_global.login_id, 1, l_cc_type, trxnref_in,
492: org_type_in, payment_channel_code_in, factored_flag_in,
493: lx_range_id, lx_cc_hash, lx_instr_len, lx_segment_id,
494: l_payer_party_id, process_profile_code_in,
495: iby_security_pkg.get_salt_version,'Y',sub_key_id_in);
542: instr_city_in, instr_state_in, instr_country_in, instr_postalcode_in,
543: instr_phonenumber_in, instr_email_in,
544: pos_reader_cap_in, pos_entry_method_in, pos_card_id_method_in,
545: pos_auth_source_in, reader_data_in, l_pos_txn,debit_network_code_in, surcharge_amount_in, proc_tracenumber_in,
546: sysdate,fnd_global.user_id,
547: sysdate,fnd_global.user_id,fnd_global.login_id,1
548: );
549:
550: -- probably a superflous call since the first insert is
543: instr_phonenumber_in, instr_email_in,
544: pos_reader_cap_in, pos_entry_method_in, pos_card_id_method_in,
545: pos_auth_source_in, reader_data_in, l_pos_txn,debit_network_code_in, surcharge_amount_in, proc_tracenumber_in,
546: sysdate,fnd_global.user_id,
547: sysdate,fnd_global.user_id,fnd_global.login_id,1
548: );
549:
550: -- probably a superflous call since the first insert is
551: -- to log the transaction before it is sent to the payment system
611: cc_issuer_range_id = lx_range_id,
612: instrnum_sec_segment_id = lx_segment_id,
613: trxnref = trxnref_in,
614: last_update_date = sysdate,
615: last_updated_by = fnd_global.user_id,
616: creation_date = sysdate,
617: created_by = fnd_global.user_id,
618: object_version_number = object_version_number + 1,
619: payment_channel_code = payment_channel_code_in,
613: trxnref = trxnref_in,
614: last_update_date = sysdate,
615: last_updated_by = fnd_global.user_id,
616: creation_date = sysdate,
617: created_by = fnd_global.user_id,
618: object_version_number = object_version_number + 1,
619: payment_channel_code = payment_channel_code_in,
620: factored_flag = factored_flag_in
621: WHERE TrxnMID = l_trxn_mid;
659: debit_network_code = debit_network_code_in,
660: surcharge_amount = surcharge_amount_in,
661: proc_tracenumber = proc_tracenumber_in,
662: last_update_date = sysdate,
663: last_updated_by = fnd_global.user_id,
664: creation_date = sysdate,
665: created_by = fnd_global.user_id,
666: object_version_number = object_version_number + 1
667: WHERE TrxnMID = l_trxn_mid;
661: proc_tracenumber = proc_tracenumber_in,
662: last_update_date = sysdate,
663: last_updated_by = fnd_global.user_id,
664: creation_date = sysdate,
665: created_by = fnd_global.user_id,
666: object_version_number = object_version_number + 1
667: WHERE TrxnMID = l_trxn_mid;
668:
669: insert_extensibility(l_trxn_mid,'N',extend_names_in,extend_vals_in);
882: l_order_id, l_mpayeeid, merchant_id_in, vendor_id_in,
883: vendor_key_in, l_tmid, vendor_code_in, vendor_message_in,
884: error_location_in, ecapp_id_in, l_org_id,
885: payerinstrid_in, l_instrnum, payerid_in,
886: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
887: fnd_global.login_id, 1, l_instrtype, l_instrsubtype, trxnref_in,
888: org_type_in, nvl(payment_channel_code_in, l_pmt_chnl_code), factored_flag_in,
889: lx_cc_hash, lx_instr_len, lx_range_id, lx_segment_id,
890: l_payer_party_id, l_process_profile_code,
883: vendor_key_in, l_tmid, vendor_code_in, vendor_message_in,
884: error_location_in, ecapp_id_in, l_org_id,
885: payerinstrid_in, l_instrnum, payerid_in,
886: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
887: fnd_global.login_id, 1, l_instrtype, l_instrsubtype, trxnref_in,
888: org_type_in, nvl(payment_channel_code_in, l_pmt_chnl_code), factored_flag_in,
889: lx_cc_hash, lx_instr_len, lx_range_id, lx_segment_id,
890: l_payer_party_id, l_process_profile_code,
891: iby_security_pkg.get_salt_version,'Y', settlement_date_in, settlement_due_date_in
906: instr_owner_name_in, instr_address_line1_in, instr_address_line2_in,
907: instr_address_line3_in, instr_city_in, instr_state_in,
908: instr_country_in, instr_postalcode_in, instr_phonenumber_in,
909: instr_email_in,
910: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
911: fnd_global.login_id,1);
912:
913: insert_extensibility(l_trxn_mid,'N',extend_names_in,extend_vals_in);
914:
907: instr_address_line3_in, instr_city_in, instr_state_in,
908: instr_country_in, instr_postalcode_in, instr_phonenumber_in,
909: instr_email_in,
910: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
911: fnd_global.login_id,1);
912:
913: insert_extensibility(l_trxn_mid,'N',extend_names_in,extend_vals_in);
914:
915: ELSIF (l_num_trxns = 1) THEN
970: cc_issuer_range_id = lx_range_id,
971: instrnum_sec_segment_id = lx_segment_id,
972: trxnref = trxnref_in,
973: Last_Update_Date = sysdate,
974: Last_Updated_by = fnd_global.user_id,
975: Creation_Date = sysdate,
976: Created_By = fnd_global.user_id,
977: Object_Version_Number = object_version_number + 1
978: WHERE TrxnMID = l_trxn_mid;
972: trxnref = trxnref_in,
973: Last_Update_Date = sysdate,
974: Last_Updated_by = fnd_global.user_id,
975: Creation_Date = sysdate,
976: Created_By = fnd_global.user_id,
977: Object_Version_Number = object_version_number + 1
978: WHERE TrxnMID = l_trxn_mid;
979:
980: DELETE iby_security_segments WHERE sec_segment_id = l_old_segment_id;
995: Instr_Owner_PostalCode = instr_postalcode_in,
996: Instr_Owner_Phone = instr_phonenumber_in,
997: Instr_Owner_Email = instr_email_in,
998: Last_Update_Date = sysdate,
999: Last_Updated_by = fnd_global.user_id,
1000: Creation_Date = sysdate,
1001: Created_By = fnd_global.user_id,
1002: Object_Version_Number = object_version_number + 1
1003: WHERE TrxnMID = l_trxn_mid;
997: Instr_Owner_Email = instr_email_in,
998: Last_Update_Date = sysdate,
999: Last_Updated_by = fnd_global.user_id,
1000: Creation_Date = sysdate,
1001: Created_By = fnd_global.user_id,
1002: Object_Version_Number = object_version_number + 1
1003: WHERE TrxnMID = l_trxn_mid;
1004:
1005: insert_extensibility(l_trxn_mid,'N',extend_names_in,extend_vals_in);
1060: --
1061: status=decode(status,100,114,status),
1062: last_update_date = sysdate,
1063: updatedate = sysdate,
1064: last_updated_by = fnd_global.user_id,
1065: object_version_number = object_version_number + 1
1066: WHERE (transactionid=transaction_id_in_out) AND (trxntypeid=l_target_trxn_type);
1067: END IF;
1068:
1197: time_in, status_in, amount_in, currency_in,
1198: l_order_id, l_mpayeeid, merchant_id_in, vendor_id_in,
1199: vendor_key_in, ecapp_id_in, l_org_id,l_tmid,
1200: payerinstrid_in, l_instrnum, l_subkey_id, payerid_in, instrType_in,
1201: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
1202: fnd_global.login_id,1,l_cc_type,trxntypeid_in,trxnref_in,
1203: org_type_in, payment_channel_code_in, factored_flag_in,'Y');
1204:
1205:
1198: l_order_id, l_mpayeeid, merchant_id_in, vendor_id_in,
1199: vendor_key_in, ecapp_id_in, l_org_id,l_tmid,
1200: payerinstrid_in, l_instrnum, l_subkey_id, payerid_in, instrType_in,
1201: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
1202: fnd_global.login_id,1,l_cc_type,trxntypeid_in,trxnref_in,
1203: org_type_in, payment_channel_code_in, factored_flag_in,'Y');
1204:
1205:
1206: INSERT INTO iby_trxn_core
1207: (TrxnMID,
1208: last_update_date,last_updated_by,creation_date,created_by,
1209: last_update_login,object_version_number)
1210: VALUES (l_trxn_mid,
1211: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id,1);
1212:
1213:
1214: ELSIF (l_num_trxns = 1) THEN
1215: -- One previous transaction, so update previous row
1246: instrType = instrType_in,
1247: trxnref = trxnref_in,
1248:
1249: Last_Update_Date = sysdate,
1250: Last_Updated_by = fnd_global.user_id,
1251: Creation_Date = sysdate,
1252: Created_By = fnd_global.user_id,
1253: Object_Version_Number = object_version_number + 1,
1254: payment_channel_code = payment_channel_code_in,
1248:
1249: Last_Update_Date = sysdate,
1250: Last_Updated_by = fnd_global.user_id,
1251: Creation_Date = sysdate,
1252: Created_By = fnd_global.user_id,
1253: Object_Version_Number = object_version_number + 1,
1254: payment_channel_code = payment_channel_code_in,
1255: factored_flag = factored_flag_in
1256: WHERE TrxnMID = l_trxn_mid;
1365: batchid = merch_batchid_in,
1366: mbatchid = l_mbatchid,
1367: last_update_date = sysdate,
1368: updatedate = sysdate,
1369: last_updated_by = fnd_global.user_id,
1370: object_version_number = object_version_number + 1
1371: WHERE (bepid = vendor_id_in)
1372: AND (bepkey = vendor_key_in)
1373: AND (payeeid = merchant_id_in)
1402: vendor_key_in, pmt_type_in, status_in, time_in, viby_batchid_in,
1403: '', 0, batchstate_in, batchtotal_in, saleamount_in,
1404: cramount_in, gwid_in, vendor_code_in, vendor_message_in,
1405: error_location_in, terminal_id_in, Acquirer_id_in,req_type_in, sysdate,
1406: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id,1);
1407:
1408: validate_open_batch(vendor_id_in, l_mbatchid, sec_key_present_in,
1409: l_trxncount, l_batchcurr);
1410:
1434: BEPCODE = vendor_code_in,
1435: BEPMESSAGE = vendor_message_in,
1436: ERRORLOCATION = error_location_in,
1437: Last_Update_Date = sysdate,
1438: Last_Updated_by = fnd_global.user_id,
1439:
1440: -- Do not update creation timestamp
1441: -- when updating records: Bug 3128675
1442: --Creation_Date = sysdate,
1439:
1440: -- Do not update creation timestamp
1441: -- when updating records: Bug 3128675
1442: --Creation_Date = sysdate,
1443: --Created_By = fnd_global.user_id,
1444:
1445: Object_Version_Number = Object_Version_Number + 1
1446:
1447: WHERE batchid = merch_batchid_in
1780: || '_' || i,
1781: mbatchid = l_trxns_in_batch_tab(i).mbatch_id,
1782: last_update_date = sysdate,
1783: updatedate = sysdate,
1784: last_updated_by = fnd_global.user_id,
1785: object_version_number = object_version_number + 1
1786: WHERE
1787: (bepid = vendor_id_in) AND
1788: (bepkey = vendor_key_in) AND
1820: mbatchid = l_trxns_in_batch_tab(i).
1821: mbatch_id,
1822: last_update_date = sysdate,
1823: updatedate = sysdate,
1824: last_updated_by = fnd_global.user_id,
1825: object_version_number = object_version_number + 1
1826: WHERE
1827: transactionid = l_trxns_in_batch_tab(i).trxn_id AND
1828: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED
1919: l_batches_tab(i).profile_code,
1920: instr_type_in,
1921: br_disputed_flag_in,
1922: sysdate,
1923: fnd_global.user_id,
1924: sysdate,
1925: fnd_global.user_id,
1926: fnd_global.login_id,
1927: 1,
1921: br_disputed_flag_in,
1922: sysdate,
1923: fnd_global.user_id,
1924: sysdate,
1925: fnd_global.user_id,
1926: fnd_global.login_id,
1927: 1,
1928: l_batches_tab(i).int_bank_acct_id,
1929: l_batches_tab(i).le_id,
1922: sysdate,
1923: fnd_global.user_id,
1924: sysdate,
1925: fnd_global.user_id,
1926: fnd_global.login_id,
1927: 1,
1928: l_batches_tab(i).int_bank_acct_id,
1929: l_batches_tab(i).le_id,
1930: l_batches_tab(i).org_id,
1996: BEPCODE = vendor_code_in,
1997: BEPMESSAGE = vendor_message_in,
1998: ERRORLOCATION = error_location_in,
1999: LAST_UPDATE_DATE = sysdate,
2000: LAST_UPDATED_BY = fnd_global.user_id,
2001:
2002: -- Do not update creation timestamp
2003: -- when updating records: Bug 3128675
2004: --CREATION_DATE = sysdate,
2001:
2002: -- Do not update creation timestamp
2003: -- when updating records: Bug 3128675
2004: --CREATION_DATE = sysdate,
2005: --CREATED_BY = fnd_global.user_id,
2006:
2007: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2008: WHERE
2009: batchid = merch_batchid_in AND
2421: || '_' || i,
2422: mbatchid = l_trxns_in_batch_tab(i).mbatch_id,
2423: last_update_date = sysdate,
2424: updatedate = sysdate,
2425: last_updated_by = fnd_global.user_id,
2426: object_version_number = object_version_number + 1
2427: WHERE
2428: (bepid = vendor_id_in) AND
2429: (bepkey = vendor_key_in) AND
2461: mbatchid = l_trxns_in_batch_tab(i).
2462: mbatch_id,
2463: last_update_date = sysdate,
2464: updatedate = sysdate,
2465: last_updated_by = fnd_global.user_id,
2466: object_version_number = object_version_number + 1
2467: WHERE
2468: transactionid = l_trxns_in_batch_tab(i).trxn_id AND
2469: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED
2561: profile_code_array(1),
2562: instr_type_in,
2563: br_disputed_flag_in,
2564: sysdate,
2565: fnd_global.user_id,
2566: sysdate,
2567: fnd_global.user_id,
2568: fnd_global.login_id,
2569: 1,
2563: br_disputed_flag_in,
2564: sysdate,
2565: fnd_global.user_id,
2566: sysdate,
2567: fnd_global.user_id,
2568: fnd_global.login_id,
2569: 1,
2570: l_batches_tab(i).int_bank_acct_id,
2571: l_batches_tab(i).le_id,
2564: sysdate,
2565: fnd_global.user_id,
2566: sysdate,
2567: fnd_global.user_id,
2568: fnd_global.login_id,
2569: 1,
2570: l_batches_tab(i).int_bank_acct_id,
2571: l_batches_tab(i).le_id,
2572: l_batches_tab(i).org_id,
2638: BEPCODE = vendor_code_in,
2639: BEPMESSAGE = vendor_message_in,
2640: ERRORLOCATION = error_location_in,
2641: LAST_UPDATE_DATE = sysdate,
2642: LAST_UPDATED_BY = fnd_global.user_id,
2643:
2644: -- Do not update creation timestamp
2645: -- when updating records: Bug 3128675
2646: --CREATION_DATE = sysdate,
2643:
2644: -- Do not update creation timestamp
2645: -- when updating records: Bug 3128675
2646: --CREATION_DATE = sysdate,
2647: --CREATED_BY = fnd_global.user_id,
2648:
2649: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2650: WHERE
2651: batchid = merch_batchid_in AND
5174:
5175: BEGIN
5176:
5177: /*
5178: * If FND_GLOBAL.conc_request_id is -1, it implies that
5179: * this method has not been invoked via the concurrent
5180: * manager. In that case, write to apps log else write
5181: * to concurrent manager log file.
5182: */
5184: -- INSERT INTO TEMP_IBY_LOGS VALUES (p_module || ': '
5185: -- || p_debug_text, sysdate);
5186: -- commit;
5187:
5188: IF (FND_GLOBAL.conc_request_id = -1) THEN
5189:
5190: /*
5191: * OPTION I:
5192: * Write debug text to the common application log file.
5425: SET BatchID = merch_batchid_in,
5426: MBatchID = l_mbatchid,
5427: last_update_date=sysdate,
5428: updatedate = sysdate,
5429: last_updated_by = fnd_global.user_id,
5430: creation_date = sysdate,
5431: created_by = fnd_global.user_id,
5432: object_version_number = object_version_number + 1
5433: WHERE TangibleID = order_id_in
5427: last_update_date=sysdate,
5428: updatedate = sysdate,
5429: last_updated_by = fnd_global.user_id,
5430: creation_date = sysdate,
5431: created_by = fnd_global.user_id,
5432: object_version_number = object_version_number + 1
5433: WHERE TangibleID = order_id_in
5434: AND PayeeID = merchant_id_in
5435: AND TrxntypeID IN (2, 3, 8,9)
5447: SET BatchID = merch_batchid_in,
5448: MBatchID = l_mbatchid,
5449: last_update_date=sysdate,
5450: updatedate = sysdate,
5451: last_updated_by = fnd_global.user_id,
5452: creation_date = sysdate,
5453: created_by = fnd_global.user_id,
5454: object_version_number = object_version_number + 1
5455: WHERE TangibleID = order_id_in
5449: last_update_date=sysdate,
5450: updatedate = sysdate,
5451: last_updated_by = fnd_global.user_id,
5452: creation_date = sysdate,
5453: created_by = fnd_global.user_id,
5454: object_version_number = object_version_number + 1
5455: WHERE TangibleID = order_id_in
5456: AND PayeeID = merchant_id_in
5457: AND TrxntypeID IN (5, 10)
5528: vendor_key_in, ecapp_id_in, org_id_in, status_in, time_in,
5529: trxn_type_in, l_mbatchid, merch_batchid_in,
5530: vendor_code_in, vendor_message_in, error_location_in,
5531: l_reqtype, sysdate, l_mtangibleid,
5532: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
5533: fnd_global.login_id,1,l_instrtype,l_instrsubtype,'Y');
5534: --dbms_output.put_line('position 6');
5535: ELSE
5536:
5529: trxn_type_in, l_mbatchid, merch_batchid_in,
5530: vendor_code_in, vendor_message_in, error_location_in,
5531: l_reqtype, sysdate, l_mtangibleid,
5532: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
5533: fnd_global.login_id,1,l_instrtype,l_instrsubtype,'Y');
5534: --dbms_output.put_line('position 6');
5535: ELSE
5536:
5537: -- retrieve existing tid out
5650: instrType = NVL(l_instrtype,instrType),
5651: instrsubtype = NVL(l_instrsubtype,instrsubtype),
5652: --org_id = org_id_in,
5653: last_update_date = sysdate,
5654: last_updated_by = fnd_global.user_id,
5655: last_update_login = fnd_global.login_id,
5656: object_version_number = object_version_number+1
5657: WHERE (trxnmid = l_trxn_mid);
5658:
5651: instrsubtype = NVL(l_instrsubtype,instrsubtype),
5652: --org_id = org_id_in,
5653: last_update_date = sysdate,
5654: last_updated_by = fnd_global.user_id,
5655: last_update_login = fnd_global.login_id,
5656: object_version_number = object_version_number+1
5657: WHERE (trxnmid = l_trxn_mid);
5658:
5659: UPDATE iby_trxn_core
5664: Auxmsg = auxmsg_in,
5665: TraceNumber = trace_number_in,
5666: InstrName = NVL(payment_name_in,instrname),
5667: last_update_date = sysdate,
5668: last_updated_by = fnd_global.user_id,
5669: last_update_login = fnd_global.login_id,
5670: object_version_number = object_version_number+1
5671: WHERE (trxnmid = l_trxn_mid);
5672:
5665: TraceNumber = trace_number_in,
5666: InstrName = NVL(payment_name_in,instrname),
5667: last_update_date = sysdate,
5668: last_updated_by = fnd_global.user_id,
5669: last_update_login = fnd_global.login_id,
5670: object_version_number = object_version_number+1
5671: WHERE (trxnmid = l_trxn_mid);
5672:
5673: COMMIT;
5744: amount_in, currency_in, time_in, status_in,
5745: order_id_in, l_mpayeeid, merchant_id_in, vendor_id_in,
5746: vendor_key_in, l_mtangibleid,
5747: vendor_code_in, vendor_message_in, error_location_in, org_id_in,
5748: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
5749: fnd_global.login_id,1,l_instrtype,l_instrsubtype,l_trxnref,'Y');
5750:
5751: INSERT INTO iby_trxn_core
5752: (TrxnMID, AuthCode, ReferenceCode, AVSCode, Acquirer, Auxmsg,
5745: order_id_in, l_mpayeeid, merchant_id_in, vendor_id_in,
5746: vendor_key_in, l_mtangibleid,
5747: vendor_code_in, vendor_message_in, error_location_in, org_id_in,
5748: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,
5749: fnd_global.login_id,1,l_instrtype,l_instrsubtype,l_trxnref,'Y');
5750:
5751: INSERT INTO iby_trxn_core
5752: (TrxnMID, AuthCode, ReferenceCode, AVSCode, Acquirer, Auxmsg,
5753: TraceNumber, InstrName,
5756: object_version_number)
5757: VALUES (l_trxn_mid, authcode_in,referencecode_in,avscode_in, acquirer_in,
5758: auxmsg_in, trace_number_in, payment_name_in,
5759:
5760: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id,1);
5761:
5762: END IF;
5763:
5764: COMMIT;
5799: batchid = newbatchid_in,
5800: mbatchid = l_mbatchid,
5801: last_update_date = sysdate,
5802: updatedate = sysdate,
5803: last_updated_by = fnd_global.user_id,
5804: object_version_number = object_version_number + 1
5805: WHERE (bepid = bepid_in)
5806: AND (bepkey = bepkey_in)
5807: AND (payeeid = payeeid_in)
5841: bepcode=DECODE(NVL(bep_code_in,''), '',bepcode, bep_code_in),
5842: bepmessage=DECODE(NVL(bep_msg_in,''), '',bepmessage, bep_msg_in),
5843: errorlocation=DECODE(NVL(error_loc_in,''), '',errorlocation, error_loc_in),
5844: last_update_date = sysdate,
5845: last_updated_by = fnd_global.user_id,
5846: object_version_number = object_version_number + 1
5847:
5848: WHERE
5849:
6005: bepcode = bep_code_in,
6006: bepmessage = bep_message_in,
6007: errorlocation = error_location_in,
6008: last_update_date = sysdate,
6009: last_updated_by = fnd_global.user_id,
6010: object_version_number = object_version_number + 1
6011: WHERE (payeeid = payeeid_in)
6012: AND (mbatchid = batchid_in);
6013:
6045: bepcode = trxn_bep_code_in(i),
6046: bepmessage = trxn_bep_msg_in(i),
6047: errorlocation = TO_NUMBER(trxn_error_loc_in(i)),
6048: last_update_date = sysdate,
6049: last_updated_by = fnd_global.user_id,
6050: object_version_number = object_version_number + 1
6051: WHERE (trxnmid = l_tmid);
6052:
6053: UPDATE iby_trxn_core
6054: SET authcode = trxn_authcode_in(i),
6055: avscode = trxn_avscode_in(i),
6056: cvv2result = trxn_cvv2result_in(i),
6057: last_update_date = sysdate,
6058: last_updated_by = fnd_global.user_id,
6059: object_version_number = object_version_number + 1
6060: WHERE (trxnmid = l_tmid);
6061:
6062: --trxnid_out(i) := l_tid;
6087: 'P',C_STATUS_BEP_FAIL,
6088: 'N',C_STATUS_SUCCESS,
6089: C_STATUS_OPEN_BATCHED),
6090: last_update_date = sysdate,
6091: last_updated_by = fnd_global.user_id,
6092: object_version_number = object_version_number + 1
6093: WHERE (payeeid = payeeid_in)
6094: AND (batchid = batchid_in)
6095: AND (status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED);
6592: instr_expirydate = NULL,
6593: expiry_sec_segment_id = l_expdate_sec_segment_id,
6594: object_version_number = object_version_number + 1,
6595: last_update_date = sysdate,
6596: last_updated_by = fnd_global.user_id,
6597: last_update_login = fnd_global.login_id
6598: WHERE (trxnmid = core_rec.tmid);
6599:
6600: END LOOP;
6593: expiry_sec_segment_id = l_expdate_sec_segment_id,
6594: object_version_number = object_version_number + 1,
6595: last_update_date = sysdate,
6596: last_updated_by = fnd_global.user_id,
6597: last_update_login = fnd_global.login_id
6598: WHERE (trxnmid = core_rec.tmid);
6599:
6600: END LOOP;
6601: END IF;
6752: instr_expirydate = l_exp_date,
6753: expiry_sec_segment_id = NULL,
6754: object_version_number = object_version_number + 1,
6755: last_update_date = sysdate,
6756: last_updated_by = fnd_global.user_id,
6757: last_update_login = fnd_global.login_id
6758: WHERE (trxnmid = core_rec.trxnmid);
6759:
6760: END LOOP;
6753: expiry_sec_segment_id = NULL,
6754: object_version_number = object_version_number + 1,
6755: last_update_date = sysdate,
6756: last_updated_by = fnd_global.user_id,
6757: last_update_login = fnd_global.login_id
6758: WHERE (trxnmid = core_rec.trxnmid);
6759:
6760: END LOOP;
6761: END IF;
7010: -- Only for settlement trxn
7011: UPDATE iby_batches_all
7012: SET
7013: last_update_date = sysdate,
7014: last_updated_by = fnd_global.user_id,
7015: object_version_number = object_version_number + 1,
7016: payer_notification_required = l_payer_notif_flag
7017: WHERE (mbatchid = mbatchid_in);
7018:
7020: -- authcapture, capture and markcapture
7021: UPDATE iby_trxn_summaries_all
7022: SET payer_notification_required = l_payer_notif_flag,
7023: last_update_date=sysdate,
7024: last_updated_by = fnd_global.user_id,
7025: object_version_number = object_version_number + 1
7026: WHERE mbatchid = mbatchid_in
7027: AND TrxntypeID IN (3,8,9,100);
7028: