[Home] [Help]
1006: -- test_debug('l_segment_id: '|| l_segment_id);
1007: -- test_debug('l_encrypted: '|| l_encrypted);
1008: -- test_debug('l_sec_code: '|| l_sec_code);
1009:
1010: SELECT iby_fndcpt_tx_extensions_s.NEXTVAL INTO x_entity_id FROM DUAL;
1011: INSERT INTO iby_fndcpt_tx_extensions
1012: (trxn_extension_id, payment_channel_code, ext_payer_id,
1013: instr_assignment_id, origin_application_id, instrument_security_code,
1014: voice_authorization_flag, voice_authorization_date,
2066: IF (NOT Extension_Valid(l_pmt_channel,l_extension,FALSE,
2067: l_consumed_cvv2)) THEN
2068: x_response.Result_Code := G_RC_INVALID_EXTENSION_ATTRIB;
2069: ELSE
2070: SELECT iby_fndcpt_tx_extensions_s.NEXTVAL INTO x_entity_id FROM DUAL;
2071: INSERT INTO iby_fndcpt_tx_extensions
2072: (trxn_extension_id, payment_channel_code,
2073: ext_payer_id, instr_assignment_id,
2074: origin_application_id, instrument_security_code,
2213: -- If the segment Id is NULL, it implies that the CVV value wasn't encrypted
2214: -- Just securely wipe out the CVV column in this case.
2215:
2216: IF (p_segment_id IS NULL) THEN
2217: SELECT trunc(DBMS_RANDOM.VALUE(1000,9999)) INTO l_random_val FROM dual;
2218: UPDATE iby_fndcpt_tx_extensions
2219: -- Update the sec_code with a randomly generated number
2220: SET instrument_security_code = l_random_val,
2221: --instr_sec_code_length = NULL,
4202:
4203: -- insert row into IBY_TANGIBLE
4204: SELECT IBY_TANGIBLE_S.NEXTVAL
4205: INTO l_mtangible
4206: FROM DUAL;
4207:
4208: print_debuginfo(l_module_name, 'Got MTtangible Id '
4209: ||l_mtangible);
4210: