DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on AR_CC_ERROR_MAPPINGS

Line 202: p_cc_error_code IN ar_cc_error_mappings.cc_error_code%TYPE,

198: | MODIFICATION HISTORY - Created by Srinivasa Kini - 30-Oct-2004
199: |
200: +===========================================================================*/
201: FUNCTION cc_mapping_exist (
202: p_cc_error_code IN ar_cc_error_mappings.cc_error_code%TYPE,
203: p_cc_trx_category IN ar_cc_error_mappings.cc_trx_category%TYPE,
204: p_receipt_method_id IN ar_cc_error_mappings.receipt_method_id%TYPE)
205: RETURN VARCHAR2 IS
206: l_return VARCHAR2(1);

Line 203: p_cc_trx_category IN ar_cc_error_mappings.cc_trx_category%TYPE,

199: |
200: +===========================================================================*/
201: FUNCTION cc_mapping_exist (
202: p_cc_error_code IN ar_cc_error_mappings.cc_error_code%TYPE,
203: p_cc_trx_category IN ar_cc_error_mappings.cc_trx_category%TYPE,
204: p_receipt_method_id IN ar_cc_error_mappings.receipt_method_id%TYPE)
205: RETURN VARCHAR2 IS
206: l_return VARCHAR2(1);
207: BEGIN

Line 204: p_receipt_method_id IN ar_cc_error_mappings.receipt_method_id%TYPE)

200: +===========================================================================*/
201: FUNCTION cc_mapping_exist (
202: p_cc_error_code IN ar_cc_error_mappings.cc_error_code%TYPE,
203: p_cc_trx_category IN ar_cc_error_mappings.cc_trx_category%TYPE,
204: p_receipt_method_id IN ar_cc_error_mappings.receipt_method_id%TYPE)
205: RETURN VARCHAR2 IS
206: l_return VARCHAR2(1);
207: BEGIN
208: IF PG_DEBUG in ('Y', 'C') THEN

Line 215: FROM ar_cc_error_mappings

211: SELECT 'Y'
212: INTO l_return
213: FROM dual
214: WHERE EXISTS (SELECT 1
215: FROM ar_cc_error_mappings
216: WHERE cc_error_code = p_cc_error_code
217: AND cc_trx_category = p_cc_trx_category
218: AND receipt_method_id = p_receipt_method_id);
219: IF PG_DEBUG in ('Y', 'C') THEN

Line 233: | Gets the cc_action_code from ar_cc_error_mappings if one exists

229: | PROCEDURE
230: | get_action_code
231: |
232: | DESCRIPTION
233: | Gets the cc_action_code from ar_cc_error_mappings if one exists
234: | otherwise passes 'Not avaialable'
235: |
236: |
237: | SCOPE - PRIVATE

Line 247: | x_cc_error_desc - From ar_cc_error_mappings

243: | p_receipt_method_id -
244: | p_payment_trxn_extension_id -
245: | p_cc_error_code - Error that was occured during CC processing
246: | OUT:
247: | x_cc_error_desc - From ar_cc_error_mappings
248: | x_first_record_flag - Y Indicates this is the first correction
249: | on the given transaction with the present
250: | error code and credit card number
251: | x_cc_action_code - RET/REV REC/CLR PAY INFO/REAUT REC

Line 253: | x_error_notes - Error note, picked from ar_cc_error_mappings

249: | on the given transaction with the present
250: | error code and credit card number
251: | x_cc_action_code - RET/REV REC/CLR PAY INFO/REAUT REC
252: | x_cc_action_type - A/S, 'A' for Action and 'S' for subsequent action
253: | x_error_notes - Error note, picked from ar_cc_error_mappings
254: |
255: |
256: | RETURNS : None
257: |

Line 298: -- Check if there is action code in ar_cc_error_mappings

294:
295: END IF;
296:
297:
298: -- Check if there is action code in ar_cc_error_mappings
299: BEGIN
300: IF PG_DEBUG in ('Y', 'C') THEN
301: arp_standard.debug( 'get_action_code()+' );
302: END IF;

Line 313: FROM ar_cc_error_mappings

309: x_cc_error_desc,
310: l_no_days,
311: l_subsequent_action_code,
312: x_error_notes
313: FROM ar_cc_error_mappings
314: WHERE cc_error_code = p_cc_error_code
315: AND cc_trx_category = p_cc_trx_category
316: AND receipt_method_id = p_receipt_method_id;
317:

Line 1745: l_cc_action_code ar_cc_error_mappings.cc_action_code%TYPE;

1741: l_error_notes VARCHAR2(240);
1742: l_cc_error_desc VARCHAR2(240);
1743: l_first_record_flag VARCHAR2(1);
1744: l_cc_action_type VARCHAR2(1);
1745: l_cc_action_code ar_cc_error_mappings.cc_action_code%TYPE;
1746: CURSOR cr IS
1747: Select cash_receipt_id,
1748: type,
1749: receipt_method_id,

Line 1773: x_cc_error_desc => l_cc_error_desc, /* One which was stored in ar_cc_error_mappings*/

1769: p_cc_trx_category => cr_rec.type,
1770: p_receipt_method_id => cr_rec.receipt_method_id,
1771: p_payment_trxn_extension_id => cr_rec.payment_trxn_extension_id,
1772: p_cc_error_code => cr_rec.cc_error_code,
1773: x_cc_error_desc => l_cc_error_desc, /* One which was stored in ar_cc_error_mappings*/
1774: x_first_record_flag => l_first_record_flag,
1775: x_cc_action_code => l_cc_action_code,
1776: x_cc_action_type => l_cc_action_type,
1777: x_error_notes => l_error_notes);

Line 1871: l_cc_action_code ar_cc_error_mappings.cc_action_code%TYPE;

1867: l_error_notes VARCHAR2(240);
1868: l_cc_error_desc VARCHAR2(240);
1869: l_first_record_flag VARCHAR2(1);
1870: l_cc_action_type VARCHAR2(1);
1871: l_cc_action_code ar_cc_error_mappings.cc_action_code%TYPE;
1872: CURSOR inv IS
1873: Select trx.customer_trx_id,
1874: trx_type.type,
1875: trx.receipt_method_id,

Line 1899: x_cc_error_desc => l_cc_error_desc, /* One which was stored in ar_cc_error_mappings*/

1895: p_cc_trx_category => inv_rec.type,
1896: p_receipt_method_id => inv_rec.receipt_method_id,
1897: p_payment_trxn_extension_id => inv_rec.payment_trxn_extension_id,
1898: p_cc_error_code => inv_rec.cc_error_code,
1899: x_cc_error_desc => l_cc_error_desc, /* One which was stored in ar_cc_error_mappings*/
1900: x_first_record_flag => l_first_record_flag,
1901: x_cc_action_code => l_cc_action_code,
1902: x_cc_action_type => l_cc_action_type,
1903: x_error_notes => l_error_notes);