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.ARP_CORRECT_CC_ERRORS dependencies on ARP_CORRECT_CC_ERRORS

Line 1: PACKAGE BODY ARP_CORRECT_CC_ERRORS AS

1: PACKAGE BODY ARP_CORRECT_CC_ERRORS AS
2: /*$Header: ARCCCORB.pls 120.4.12010000.1 2008/07/24 16:22:21 appldev ship $*/
3:
4: /* =======================================================================
5: | Global Data Types

Line 140: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()+' );

136: l_collector_name ar_collectors.name%TYPE;
137: l_collector_id NUMBER;
138: BEGIN
139: IF PG_DEBUG in ('Y', 'C') THEN
140: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()+' );
141: END IF;
142: SELECT prof.collector_id INTO l_collector_id
143: FROM hz_customer_profiles prof
144: WHERE prof.cust_account_id = p_customer_id AND

Line 153: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );

149: FROM ar_collectors
150: WHERE collector_id = l_collector_id;
151:
152: IF PG_DEBUG in ('Y', 'C') THEN
153: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );
154: END IF;
155: RETURN l_collector_name;
156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN

Line 168: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );

164: INTO l_collector_name
165: FROM ar_collectors
166: WHERE collector_id = l_collector_id;
167: IF PG_DEBUG in ('Y', 'C') THEN
168: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );
169: END IF;
170: RETURN l_collector_name;
171: WHEN OTHERS THEN
172: RETURN null;

Line 209: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.cc_mapping_exist()+' );

205: RETURN VARCHAR2 IS
206: l_return VARCHAR2(1);
207: BEGIN
208: IF PG_DEBUG in ('Y', 'C') THEN
209: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.cc_mapping_exist()+' );
210: END IF;
211: SELECT 'Y'
212: INTO l_return
213: FROM dual

Line 220: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.cc_mapping_exist()-' );

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
220: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.cc_mapping_exist()-' );
221: END IF;
222: RETURN l_return;
223: EXCEPTION
224: WHEN OTHERS THEN

Line 281: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_action_code()+' );

277: l_subsequent_action_code VARCHAR2(30);
278:
279: BEGIN
280: IF PG_DEBUG in ('Y', 'C') THEN
281: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_action_code()+' );
282: END IF;
283:
284: IF PG_DEBUG in ('Y', 'C') THEN
285: ---Print input parameters

Line 335: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );

331: x_error_notes := NULL;
332: RETURN;
333: WHEN OTHERS THEN
334: IF PG_DEBUG in ('Y', 'C') THEN
335: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );
336: END IF;
337: raise;
338: END;
339:

Line 362: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );

358: x_error_notes := NULL;
359: RETURN;
360: WHEN OTHERS THEN
361: IF PG_DEBUG in ('Y', 'C') THEN
362: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );
363: END IF;
364: raise;
365: END;
366:

Line 390: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );

386: x_first_record_flag := 'Y';
387: RETURN;
388: WHEN OTHERS THEN
389: IF PG_DEBUG in ('Y', 'C') THEN
390: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );
391: END IF;
392: raise;
393: END;
394:

Line 417: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_action_code()-' );

413: x_cc_action_type );
414: END IF;
415:
416: IF PG_DEBUG in ('Y', 'C') THEN
417: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_action_code()-' );
418: END IF;
419: END get_action_code;
420:
421: /*===========================================================================+

Line 447: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()+' );

443: +===========================================================================*/
444: PROCEDURE insert_p(p_cc_error_hist IN ar_cc_error_history%ROWTYPE) IS
445: BEGIN
446: IF PG_DEBUG in ('Y', 'C') THEN
447: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()+' );
448: END IF;
449: INSERT INTO ar_cc_error_history
450: (
451: request_id,

Line 492: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()-' );

488: NVL(pg_login_id,pg_conc_login_id),
489: pg_user_id
490: );
491: IF PG_DEBUG in ('Y', 'C') THEN
492: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()-' );
493: END IF;
494: EXCEPTION
495: WHEN OTHERS THEN
496: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.insert_p()' );

Line 496: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.insert_p()' );

492: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()-' );
493: END IF;
494: EXCEPTION
495: WHEN OTHERS THEN
496: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.insert_p()' );
497: raise;
498: END insert_p;
499:
500: /*===========================================================================+

Line 562: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()+' );

558: l_billto_contact varchar2(150);
559: l_salesrep_name ra_salesreps.name%TYPE;
560: BEGIN
561: IF PG_DEBUG in ('Y', 'C') THEN
562: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()+' );
563: END IF;
564: SELECT NVL(trx.cc_error_code,'Unknown'),
565: NVL(trx.cc_error_text,'Unknown Error'),
566: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CC_TRX_CATEGORY',p_cc_trx_category),

Line 578: ARP_CORRECT_CC_ERRORS.get_collector_name(trx.paying_customer_id,site_uses.site_use_id)

574: iby.card_expirydate,
575: trx.payment_server_order_num,
576: trx.approval_code,
577: rm.name,
578: ARP_CORRECT_CC_ERRORS.get_collector_name(trx.paying_customer_id,site_uses.site_use_id)
579: INTO l_cc_error_code,
580: l_cc_error_desc,
581: l_cc_trx_category_dsp,
582: l_cc_trx_number,

Line 685: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()-' );

681:
682:
683:
684: IF PG_DEBUG in ('Y', 'C') THEN
685: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()-' );
686: END IF;
687: EXCEPTION
688: WHEN OTHERS THEN
689: IF PG_DEBUG in ('Y', 'C') THEN

Line 690: arp_standard.debug( 'Exception ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()' );

686: END IF;
687: EXCEPTION
688: WHEN OTHERS THEN
689: IF PG_DEBUG in ('Y', 'C') THEN
690: arp_standard.debug( 'Exception ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()' );
691: END IF;
692: raise;
693: END clear_invoice_pay_info;
694:

Line 726: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()+' );

722: l_default_gl_date DATE;
723: l_gl_date DATE;
724: BEGIN
725: IF PG_DEBUG in ('Y', 'C') THEN
726: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()+' );
727: END IF;
728: SELECT max(gl_date)
729: INTO l_gl_date
730: FROM ar_cash_receipt_history

Line 766: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()-' );

762: FND_MSG_PUB.Add;
763: app_exception.raise_exception;
764: END IF;
765: IF PG_DEBUG in ('Y', 'C') THEN
766: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()-' );
767: END IF;
768: EXCEPTION
769: WHEN OTHERS THEN
770: IF PG_DEBUG in ('Y', 'C') THEN

Line 771: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()' );

767: END IF;
768: EXCEPTION
769: WHEN OTHERS THEN
770: IF PG_DEBUG in ('Y', 'C') THEN
771: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()' );
772: END IF;
773: raise;
774: END default_reversal_gl_date;
775:

Line 803: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_date()+' );

799: FUNCTION default_reversal_date(p_cash_receipt_id IN NUMBER) RETURN DATE IS
800: l_receipt_date DATE;
801: BEGIN
802: IF PG_DEBUG in ('Y', 'C') THEN
803: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_date()+' );
804: END IF;
805: SELECT receipt_date
806: INTO l_receipt_date
807: FROM ar_cash_receipts

Line 816: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_date()+' );

812: ELSE
813: RETURN l_receipt_date;
814: END IF;
815: IF PG_DEBUG in ('Y', 'C') THEN
816: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_date()+' );
817: END IF;
818: END default_reversal_date;
819:
820: /*===========================================================================+

Line 856: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.reverse_receipt()+' );

852: l_msg_index NUMBER;
853: API_exception EXCEPTION;
854: BEGIN
855: IF PG_DEBUG in ('Y', 'C') THEN
856: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.reverse_receipt()+' );
857: END IF;
858: --
859: -- Populate the arguments to pass to AR_RECEIPT_API_PUB.Reverse
860: --

Line 938: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.reverse_receipt()-' );

934:
935: END IF; -- l_return_status
936:
937: IF PG_DEBUG in ('Y', 'C') THEN
938: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.reverse_receipt()-' );
939: END IF;
940: EXCEPTION
941: WHEN API_exception THEN
942: IF PG_DEBUG in ('Y', 'C') THEN

Line 943: arp_util.debug('ARP_CORRECT_CC_ERRORS.reverse_action: ' || 'API EXCEPTION: ' ||

939: END IF;
940: EXCEPTION
941: WHEN API_exception THEN
942: IF PG_DEBUG in ('Y', 'C') THEN
943: arp_util.debug('ARP_CORRECT_CC_ERRORS.reverse_action: ' || 'API EXCEPTION: ' ||
944: 'ARP_CORRECT_CC_ERRORS.reverse_receipt'
945: ||SQLERRM);
946: END IF;
947: RAISE;

Line 944: 'ARP_CORRECT_CC_ERRORS.reverse_receipt'

940: EXCEPTION
941: WHEN API_exception THEN
942: IF PG_DEBUG in ('Y', 'C') THEN
943: arp_util.debug('ARP_CORRECT_CC_ERRORS.reverse_action: ' || 'API EXCEPTION: ' ||
944: 'ARP_CORRECT_CC_ERRORS.reverse_receipt'
945: ||SQLERRM);
946: END IF;
947: RAISE;
948: WHEN OTHERS THEN

Line 950: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.reverse_receipt '

946: END IF;
947: RAISE;
948: WHEN OTHERS THEN
949: IF PG_DEBUG in ('Y', 'C') THEN
950: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.reverse_receipt '
951: ||SQLERRM);
952: END IF;
953: RAISE;
954: END reverse_receipt;

Line 1024: arp_util.debug('ARP_CORRECT_CC_ERRORS.Raise_RefundReverse_Event (+)');

1020: l_key VARCHAR2(240);
1021: l_event_name VARCHAR2(150);
1022: BEGIN
1023: IF PG_DEBUG in ('Y', 'C') THEN
1024: arp_util.debug('ARP_CORRECT_CC_ERRORS.Raise_RefundReverse_Event (+)');
1025: END IF;
1026: -- Assign the business event
1027: l_event_name := 'oracle.apps.ar.ccerrorhandling.RefunReverse';
1028: --Get the item key

Line 1099: arp_util.debug('ARP_CORRECT_CC_ERRORS.Raise_RefundReverse_Event (-)');

1095: p_event_key => l_key,
1096: p_parameters => l_list );
1097: l_list.DELETE;
1098: IF PG_DEBUG in ('Y', 'C') THEN
1099: arp_util.debug('ARP_CORRECT_CC_ERRORS.Raise_RefundReverse_Event (-)');
1100: END IF;
1101: EXCEPTION
1102: WHEN others THEN
1103: IF PG_DEBUG in ('Y', 'C') THEN

Line 1104: arp_util.debug('ERR RAISING EVENT in ARP_CORRECT_CC_ERRORS.Raise_RefundReverse_Event: '||l_event_name);

1100: END IF;
1101: EXCEPTION
1102: WHEN others THEN
1103: IF PG_DEBUG in ('Y', 'C') THEN
1104: arp_util.debug('ERR RAISING EVENT in ARP_CORRECT_CC_ERRORS.Raise_RefundReverse_Event: '||l_event_name);
1105: END IF;
1106: raise;
1107: END Raise_RefundReverse_Event;
1108:

Line 1188: arp_util.debug('ARP_CORRECT_CC_ERRORS.Raise_Collection_Event (+)');

1184: l_key VARCHAR2(240);
1185: l_event_name VARCHAR2(150);
1186: BEGIN
1187: IF PG_DEBUG in ('Y', 'C') THEN
1188: arp_util.debug('ARP_CORRECT_CC_ERRORS.Raise_Collection_Event (+)');
1189: END IF;
1190: --Assign the business event name
1191: l_event_name := 'oracle.apps.ar.ccerrorhandling.ClrInvPayInfoORReverseReceipt';
1192: --Get the item key

Line 1282: arp_util.debug('ARP_CORRECT_CC_ERRORS.Raise_Collection_Event (-)');

1278: p_event_key => l_key,
1279: p_parameters => l_list );
1280: l_list.DELETE;
1281: IF PG_DEBUG in ('Y', 'C') THEN
1282: arp_util.debug('ARP_CORRECT_CC_ERRORS.Raise_Collection_Event (-)');
1283: END IF;
1284: EXCEPTION
1285: WHEN others THEN
1286: IF PG_DEBUG in ('Y', 'C') THEN

Line 1287: arp_util.debug('ERR RAISING EVENT from ARP_CORRECT_CC_ERRORS.Raise_Collection_Event: '||l_event_name);

1283: END IF;
1284: EXCEPTION
1285: WHEN others THEN
1286: IF PG_DEBUG in ('Y', 'C') THEN
1287: arp_util.debug('ERR RAISING EVENT from ARP_CORRECT_CC_ERRORS.Raise_Collection_Event: '||l_event_name);
1288: raise;
1289: END IF;
1290: END Raise_Collection_Event;
1291:

Line 1320: arp_util.debug('ARP_CORRECT_CC_ERRORS.AddParamEnvToList ()+');

1316: l_rang NUMBER;
1317: l_org_name VARCHAR2(240);
1318: BEGIN
1319: IF PG_DEBUG in ('Y', 'C') THEN
1320: arp_util.debug('ARP_CORRECT_CC_ERRORS.AddParamEnvToList ()+');
1321: END IF;
1322: l_rang := 0;
1323:
1324: /* Get the org_name to pass while raising the business event */

Line 1350: arp_util.debug('ARP_CORRECT_CC_ERRORS.AddParamEnvToList ()-');

1346: l_param.SetValue( l_org_name );
1347: l_rang := l_rang + 1;
1348: x_list(l_rang) := l_param;
1349: IF PG_DEBUG in ('Y', 'C') THEN
1350: arp_util.debug('ARP_CORRECT_CC_ERRORS.AddParamEnvToList ()-');
1351: END IF;
1352: EXCEPTION
1353: WHEN OTHERS THEN
1354: IF PG_DEBUG in ('Y', 'C') THEN

Line 1355: arp_util.debug('EXCEPTION ARP_CORRECT_CC_ERRORS.AddParamEnvToList ()');

1351: END IF;
1352: EXCEPTION
1353: WHEN OTHERS THEN
1354: IF PG_DEBUG in ('Y', 'C') THEN
1355: arp_util.debug('EXCEPTION ARP_CORRECT_CC_ERRORS.AddParamEnvToList ()');
1356: END IF;
1357: raise;
1358: END AddParamEnvToList;
1359:

Line 1426: arp_util.debug('ARP_CORRECT_CC_ERRORS.raise_event ()+');

1422: EventNotFound EXCEPTION;
1423: EventNotARCC EXCEPTION;
1424: BEGIN
1425: IF PG_DEBUG in ('Y', 'C') THEN
1426: arp_util.debug('ARP_CORRECT_CC_ERRORS.raise_event ()+');
1427: END IF;
1428:
1429: SAVEPOINT ar_cccorrection_raise_event;
1430:

Line 1448: arp_util.debug('ARP_CORRECT_CC_ERRORS.raise_event ()-');

1444: p_parameters => p_parameters,
1445: p_event_data => p_data);
1446:
1447: IF PG_DEBUG in ('Y', 'C') THEN
1448: arp_util.debug('ARP_CORRECT_CC_ERRORS.raise_event ()-');
1449: END IF;
1450:
1451: EXCEPTION
1452: WHEN EventNotFound THEN

Line 1509: arp_util.debug('ARP_CORRECT_CC_ERRORS.attach_notes()+');

1505: p_text IN VARCHAR2) IS
1506: l_note_id ar_notes.note_id%type;
1507: BEGIN
1508: IF PG_DEBUG in ('Y', 'C') THEN
1509: arp_util.debug('ARP_CORRECT_CC_ERRORS.attach_notes()+');
1510: END IF;
1511:
1512: INSERT INTO ar_notes
1513: (

Line 1543: arp_util.debug('ARP_CORRECT_CC_ERRORS.attach_notes()-');

1539: pg_user_id,
1540: sysdate
1541: );
1542: IF PG_DEBUG in ('Y', 'C') THEN
1543: arp_util.debug('ARP_CORRECT_CC_ERRORS.attach_notes()-');
1544: END IF;
1545: EXCEPTION
1546: WHEN OTHERS THEN
1547: IF PG_DEBUG in ('Y', 'C') THEN

Line 1548: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.attach_notes()');

1544: END IF;
1545: EXCEPTION
1546: WHEN OTHERS THEN
1547: IF PG_DEBUG in ('Y', 'C') THEN
1548: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.attach_notes()');
1549: END IF;
1550: raise;
1551: END attach_notes;
1552:

Line 1585: arp_util.debug('ARP_CORRECT_CC_ERRORS.lock_table_nowait()+');

1581: p_trx_number IN VARCHAR2) IS
1582: l_dummy_number NUMBER;
1583: BEGIN
1584: IF PG_DEBUG in ('Y', 'C') THEN
1585: arp_util.debug('ARP_CORRECT_CC_ERRORS.lock_table_nowait()+');
1586: END IF;
1587: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN
1588: arp_cash_receipts_pkg.nowaitlock_version_p(p_key,p_object_version_number);
1589: ELSE

Line 1595: arp_util.debug('ARP_CORRECT_CC_ERRORS.lock_table_nowait()-');

1591: -- which does locking
1592: ARP_CT_PKG.lock_p(p_key);
1593: END IF;
1594: IF PG_DEBUG in ('Y', 'C') THEN
1595: arp_util.debug('ARP_CORRECT_CC_ERRORS.lock_table_nowait()-');
1596: END IF;
1597: EXCEPTION
1598: WHEN NO_DATA_FOUND THEN
1599: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN

Line 1609: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.lock_table_nowait()');

1605: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1606: FND_MSG_PUB.Add;
1607: END IF;
1608: IF PG_DEBUG in ('Y', 'C') THEN
1609: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.lock_table_nowait()');
1610: END IF;
1611: app_exception.raise_exception;
1612: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1613: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN

Line 1623: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.lock_table_nowait()');

1619: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1620: FND_MSG_PUB.Add;
1621: END IF;
1622: IF PG_DEBUG in ('Y', 'C') THEN
1623: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.lock_table_nowait()');
1624: END IF;
1625: app_exception.raise_exception;
1626: WHEN OTHERS THEN
1627: raise;

Line 1658: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_error_occurred()+');

1654: FUNCTION cc_error_occurred(p_mode VARCHAR2,p_request_id NUMBER) RETURN VARCHAR2 IS
1655: l_return_status VARCHAR2(1);
1656: BEGIN
1657: IF PG_DEBUG in ('Y', 'C') THEN
1658: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_error_occurred()+');
1659: END IF;
1660: l_return_status := 'Y';
1661: IF p_mode = 'REMITTANCE' THEN
1662: BEGIN

Line 1675: arp_util.debug('Exception : ARP_CORRECT_CC_ERRORS.cc_error_occurred');

1671: WHEN NO_DATA_FOUND THEN
1672: l_return_status := 'N';
1673: WHEN OTHERS THEN
1674: IF PG_DEBUG in ('Y', 'C') THEN
1675: arp_util.debug('Exception : ARP_CORRECT_CC_ERRORS.cc_error_occurred');
1676: END IF;
1677: raise;
1678: END;
1679: ELSE

Line 1693: arp_util.debug('Exception : ARP_CORRECT_CC_ERRORS.cc_error_occured');

1689: WHEN NO_DATA_FOUND THEN
1690: l_return_status := 'N';
1691: WHEN OTHERS THEN
1692: IF PG_DEBUG in ('Y', 'C') THEN
1693: arp_util.debug('Exception : ARP_CORRECT_CC_ERRORS.cc_error_occured');
1694: END IF;
1695: raise;
1696: END;
1697: END IF;

Line 1699: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_error_occurred()-');

1695: raise;
1696: END;
1697: END IF;
1698: IF PG_DEBUG in ('Y', 'C') THEN
1699: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_error_occurred()-');
1700: END IF;
1701: RETURN l_return_status;
1702: END cc_error_occurred;
1703:

Line 1749: arp_util.debug('arp_correct_cc_errors.correct_remittance_errors()+');

1745: AND cc_error_flag = 'Y'
1746: AND cc_error_code IS NOT NULL;
1747: BEGIN
1748: IF PG_DEBUG in ('Y', 'C') THEN
1749: arp_util.debug('arp_correct_cc_errors.correct_remittance_errors()+');
1750: END IF;
1751: FOR cr_rec IN cr LOOP
1752:
1753: -- Call get_action_code

Line 1814: arp_util.debug('arp_correct_cc_errors.correct_remittance_errors()-');

1810: insert_p(l_cc_error_hist);
1811: END IF;
1812: END LOOP;
1813: IF PG_DEBUG in ('Y', 'C') THEN
1814: arp_util.debug('arp_correct_cc_errors.correct_remittance_errors()-');
1815: END IF;
1816: EXCEPTION
1817: WHEN OTHERS THEN
1818: IF PG_DEBUG in ('Y', 'C') THEN

Line 1819: arp_util.debug('Exception in arp_correct_cc_errors.correct_remittance_errors()');

1815: END IF;
1816: EXCEPTION
1817: WHEN OTHERS THEN
1818: IF PG_DEBUG in ('Y', 'C') THEN
1819: arp_util.debug('Exception in arp_correct_cc_errors.correct_remittance_errors()');
1820: END IF;
1821: raise;
1822: END correct_remittance_errors;
1823:

Line 1871: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_creation_errors()+');

1867: AND trx.cc_error_flag = 'Y'
1868: AND cc_error_code IS NOT NULL;
1869: BEGIN
1870: IF PG_DEBUG in ('Y', 'C') THEN
1871: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_creation_errors()+');
1872: END IF;
1873: FOR inv_rec IN inv LOOP
1874: get_action_code( p_cc_trx_id => inv_rec.customer_trx_id,
1875: p_cc_trx_category => inv_rec.type,

Line 1927: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_creation_errors()-');

1923: insert_p(l_cc_error_hist);
1924: END IF;
1925: END LOOP;
1926: IF PG_DEBUG in ('Y', 'C') THEN
1927: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_creation_errors()-');
1928: END IF;
1929: EXCEPTION
1930: WHEN OTHERS THEN
1931: IF PG_DEBUG in ('Y', 'C') THEN

Line 1932: arp_util.debug('EXCEPTION ARP_CORRECT_CC_ERRORS.correct_creation_errors()');

1928: END IF;
1929: EXCEPTION
1930: WHEN OTHERS THEN
1931: IF PG_DEBUG in ('Y', 'C') THEN
1932: arp_util.debug('EXCEPTION ARP_CORRECT_CC_ERRORS.correct_creation_errors()');
1933: END IF;
1934: RAISE;
1935: END correct_creation_errors;
1936:

Line 1972: arp_util.debug('ARP_CORRECT_CC_ERRORS.retry()+');

1968: p_error_notes IN VARCHAR2) IS
1969: l_error_notes VARCHAR2(240);
1970: BEGIN
1971: IF PG_DEBUG in ('Y', 'C') THEN
1972: arp_util.debug('ARP_CORRECT_CC_ERRORS.retry()+');
1973: END IF;
1974: IF (p_error_notes IS NULL) OR(p_error_notes = ' ') THEN
1975: l_error_notes := NULL;
1976: ELSE

Line 2001: arp_util.debug('ARP_CORRECT_CC_ERRORS.retry()-');

1997: p_text => l_error_notes);
1998: END IF;
1999: END IF;
2000: IF PG_DEBUG in ('Y', 'C') THEN
2001: arp_util.debug('ARP_CORRECT_CC_ERRORS.retry()-');
2002: END IF;
2003: EXCEPTION
2004: WHEN OTHERS THEN
2005: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.retry()');

Line 2005: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.retry()');

2001: arp_util.debug('ARP_CORRECT_CC_ERRORS.retry()-');
2002: END IF;
2003: EXCEPTION
2004: WHEN OTHERS THEN
2005: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.retry()');
2006: raise;
2007: END retry;
2008:
2009: /*===========================================================================+

Line 2043: arp_util.debug('ARP_CORRECT_CC_ERRORS.reauthorize()+');

2039: p_error_notes IN VARCHAR2) IS
2040: l_error_notes VARCHAR2(240);
2041: BEGIN
2042: IF PG_DEBUG in ('Y', 'C') THEN
2043: arp_util.debug('ARP_CORRECT_CC_ERRORS.reauthorize()+');
2044: END IF;
2045: IF (p_error_notes IS NULL) OR(p_error_notes = ' ') THEN
2046: l_error_notes := NULL;
2047: ELSE

Line 2064: arp_util.debug('ARP_CORRECT_CC_ERRORS.authorize()-');

2060: comments = DECODE(p_error_notes,NULL,comments,substrb('<'||l_error_notes||'>'||comments,1,240))
2061: WHERE cash_receipt_id = p_cc_trx_id;
2062: END IF;
2063: IF PG_DEBUG in ('Y', 'C') THEN
2064: arp_util.debug('ARP_CORRECT_CC_ERRORS.authorize()-');
2065: END IF;
2066: EXCEPTION
2067: WHEN OTHERS THEN
2068: IF PG_DEBUG in ('Y', 'C') THEN

Line 2069: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.reauthorize()');

2065: END IF;
2066: EXCEPTION
2067: WHEN OTHERS THEN
2068: IF PG_DEBUG in ('Y', 'C') THEN
2069: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.reauthorize()');
2070: END IF;
2071: raise;
2072: END reauthorize;
2073:

Line 2145: arp_util.debug('ARP_CORRECT_CC_ERRORS.obtain_alternate_payment()+');

2141: PAY_exception EXCEPTION;
2142:
2143: BEGIN
2144: IF PG_DEBUG in ('Y', 'C') THEN
2145: arp_util.debug('ARP_CORRECT_CC_ERRORS.obtain_alternate_payment()+');
2146: END IF;
2147: IF (p_error_notes IS NULL) OR (p_error_notes = ' ') THEN
2148:
2149: ---Bug 4192368 get notes from description field of lookup

Line 2222: ARP_CORRECT_CC_ERRORS.get_collector_name(cr.pay_from_customer,cr.customer_site_use_id),

2218: decode(iby.INSTRUMENT_TYPE,'CREDITCARD',iby.CARD_NUMBER,iby.ACCOUNT_NUMBER),
2219: decode(iby.INSTRUMENT_TYPE,'CREDITCARD',iby.CARD_EXPIRYDATE,null),
2220: cr.payment_server_order_num,
2221: cr.approval_code approval_code,
2222: ARP_CORRECT_CC_ERRORS.get_collector_name(cr.pay_from_customer,cr.customer_site_use_id),
2223: rm.name
2224: INTO l_cc_error_code,
2225: l_cc_error_desc,
2226: l_cc_trx_category_dsp,

Line 2321: arp_util.debug('ARP_CORRECT_CC_ERRORS.reverse_action: ' || 'API EXCEPTION: ' ||

2317: +------------------------------------------------------------*/
2318: -- send an error message
2319:
2320: RAISE PAY_exception;
2321: arp_util.debug('ARP_CORRECT_CC_ERRORS.reverse_action: ' || 'API EXCEPTION: ' ||
2322: 'ARP_CORRECT_CC_ERRORS.reverse_receipt'
2323: ||SQLERRM);
2324:
2325: END IF;

Line 2322: 'ARP_CORRECT_CC_ERRORS.reverse_receipt'

2318: -- send an error message
2319:
2320: RAISE PAY_exception;
2321: arp_util.debug('ARP_CORRECT_CC_ERRORS.reverse_action: ' || 'API EXCEPTION: ' ||
2322: 'ARP_CORRECT_CC_ERRORS.reverse_receipt'
2323: ||SQLERRM);
2324:
2325: END IF;
2326: IF PG_DEBUG in ('Y', 'C') THEN

Line 2327: arp_util.debug('ARP_CORRECT_CC_ERRORS.obtain_alternate_payment()-');

2323: ||SQLERRM);
2324:
2325: END IF;
2326: IF PG_DEBUG in ('Y', 'C') THEN
2327: arp_util.debug('ARP_CORRECT_CC_ERRORS.obtain_alternate_payment()-');
2328: END IF;
2329: EXCEPTION
2330:
2331: WHEN PAY_exception THEN

Line 2333: arp_util.debug('ARP_CORRECT_CC_ERRORS.reverse_action: ' || 'API EXCEPTION: ' ||

2329: EXCEPTION
2330:
2331: WHEN PAY_exception THEN
2332: IF PG_DEBUG in ('Y', 'C') THEN
2333: arp_util.debug('ARP_CORRECT_CC_ERRORS.reverse_action: ' || 'API EXCEPTION: ' ||
2334: 'ARP_CORRECT_CC_ERRORS.reverse_receipt'
2335: ||SQLERRM);
2336: END IF;
2337: RAISE;

Line 2334: 'ARP_CORRECT_CC_ERRORS.reverse_receipt'

2330:
2331: WHEN PAY_exception THEN
2332: IF PG_DEBUG in ('Y', 'C') THEN
2333: arp_util.debug('ARP_CORRECT_CC_ERRORS.reverse_action: ' || 'API EXCEPTION: ' ||
2334: 'ARP_CORRECT_CC_ERRORS.reverse_receipt'
2335: ||SQLERRM);
2336: END IF;
2337: RAISE;
2338:

Line 2343: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.obtain_alternate_payment()');

2339:
2340:
2341: WHEN OTHERS THEN
2342: IF PG_DEBUG in ('Y', 'C') THEN
2343: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.obtain_alternate_payment()');
2344: END IF;
2345: raise;
2346: END obtain_alternate_payment;
2347:

Line 2394: arp_util.debug('arp_correct_cc_errors.cc_auto_correct()+');

2390: FOR UPDATE OF customer_trx_id;
2391: BEGIN
2392: IF PG_DEBUG in ('Y', 'C') THEN
2393: arp_util.debug('Begin : ' ||to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
2394: arp_util.debug('arp_correct_cc_errors.cc_auto_correct()+');
2395: arp_util.debug('--------------- Input parameters --------------------');
2396: arp_util.debug('p_request_id :'||to_char(p_request_id));
2397: arp_util.debug('Called from : '||p_mode);
2398: END IF;

Line 2417: arp_util.debug('arp_correct_cc_errors.cc_auto_correct()-');

2413: END IF;
2414: retcode := 0;
2415: errbuf := 'Sucess!';
2416: IF PG_DEBUG in ('Y', 'C') THEN
2417: arp_util.debug('arp_correct_cc_errors.cc_auto_correct()-');
2418: arp_util.debug('End : ' ||to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
2419: END IF;
2420: EXCEPTION
2421: WHEN OTHERS THEN

Line 2423: arp_util.debug('Exception in arp_correct_cc_errors.cc_auto_correct');

2419: END IF;
2420: EXCEPTION
2421: WHEN OTHERS THEN
2422: IF PG_DEBUG in ('Y', 'C') THEN
2423: arp_util.debug('Exception in arp_correct_cc_errors.cc_auto_correct');
2424: END IF;
2425: IF lock_trx%ISOPEN THEN
2426: CLOSE lock_trx;
2427: END IF;

Line 2468: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_funds_error()+');

2464: p_error_notes IN VARCHAR2) IS
2465: l_error_notes VARCHAR2(240);
2466: BEGIN
2467: IF PG_DEBUG in ('Y', 'C') THEN
2468: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_funds_error()+');
2469:
2470: arp_util.debug('value of p_cc_trx_id '||'<'||p_cc_trx_id||'>');
2471: arp_util.debug('value of p_cc_trx_category '||'<'||p_cc_trx_category||'>');
2472: arp_util.debug('value of p_corrective_action'||'<'||p_corrective_action||'>');

Line 2565: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_funds_error()-');

2561: END IF; /* end Clear Payment Information */
2562:
2563:
2564: IF PG_DEBUG in ('Y', 'C') THEN
2565: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_funds_error()-');
2566: END IF;
2567: EXCEPTION
2568: WHEN OTHERS THEN
2569: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.correct_funds_error()'|| SQLERRM );

Line 2569: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.correct_funds_error()'|| SQLERRM );

2565: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_funds_error()-');
2566: END IF;
2567: EXCEPTION
2568: WHEN OTHERS THEN
2569: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.correct_funds_error()'|| SQLERRM );
2570: raise;
2571: END correct_funds_error;
2572:
2573:

Line 2605: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover()+');

2601: p_mode IN VARCHAR2) IS
2602: l_request_id NUMBER;
2603: BEGIN
2604: IF PG_DEBUG in ('Y', 'C') THEN
2605: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover()+');
2606: END IF;
2607: IF cc_error_occurred(p_mode,p_request_id) = 'Y' THEN
2608: IF PG_DEBUG in ('Y', 'C') THEN
2609: arp_util.debug('cc error has occurred while automatic receipt processing..');

Line 2627: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover()-');

2623: arp_util.debug('No cc error has occurred while automatic receipt processing..');
2624: END IF;
2625: END IF;
2626: IF PG_DEBUG in ('Y', 'C') THEN
2627: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover()-');
2628: END IF;
2629: END cc_auto_correct_cover;
2630: /*---------------------------------------------+
2631: | Package initialization section. |

Line 2643: END ARP_CORRECT_CC_ERRORS;

2639: SELECT user_name
2640: INTO pg_user_name
2641: FROM fnd_user
2642: WHERE user_id = pg_user_id;
2643: END ARP_CORRECT_CC_ERRORS;