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_cc_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_customer_bank_account_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 297: -- Check if there is action code in ar_cc_error_mappings

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

Line 312: FROM ar_cc_error_mappings

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

Line 1734: l_cc_action_code ar_cc_error_mappings.cc_action_code%TYPE;

1730: l_error_notes VARCHAR2(240);
1731: l_cc_error_desc VARCHAR2(240);
1732: l_first_record_flag VARCHAR2(1);
1733: l_cc_action_type VARCHAR2(1);
1734: l_cc_action_code ar_cc_error_mappings.cc_action_code%TYPE;
1735: CURSOR cr IS
1736: Select cash_receipt_id,
1737: type,
1738: receipt_method_id,

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

1755: p_cc_trx_category => cr_rec.type,
1756: p_receipt_method_id => cr_rec.receipt_method_id,
1757: p_customer_bank_account_id => cr_rec.customer_bank_account_id,
1758: p_cc_error_code => cr_rec.cc_error_code,
1759: x_cc_error_desc => l_cc_error_desc, /* One which was stored in ar_cc_error_mappings*/
1760: x_first_record_flag => l_first_record_flag,
1761: x_cc_action_code => l_cc_action_code,
1762: x_cc_action_type => l_cc_action_type,
1763: x_error_notes => l_error_notes);

Line 1854: l_cc_action_code ar_cc_error_mappings.cc_action_code%TYPE;

1850: l_error_notes VARCHAR2(240);
1851: l_cc_error_desc VARCHAR2(240);
1852: l_first_record_flag VARCHAR2(1);
1853: l_cc_action_type VARCHAR2(1);
1854: l_cc_action_code ar_cc_error_mappings.cc_action_code%TYPE;
1855: CURSOR inv IS
1856: Select trx.customer_trx_id,
1857: trx_type.type,
1858: trx.receipt_method_id,

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

1875: p_cc_trx_category => inv_rec.type,
1876: p_receipt_method_id => inv_rec.receipt_method_id,
1877: p_customer_bank_account_id => inv_rec.customer_bank_account_id,
1878: p_cc_error_code => inv_rec.cc_error_code,
1879: x_cc_error_desc => l_cc_error_desc, /* One which was stored in ar_cc_error_mappings*/
1880: x_first_record_flag => l_first_record_flag,
1881: x_cc_action_code => l_cc_action_code,
1882: x_cc_action_type => l_cc_action_type,
1883: x_error_notes => l_error_notes);