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_UTIL

Line 738: IF (arp_util.validate_and_default_gl_date(

734: INTO l_sob_id
735: FROM ar_cash_receipts
736: WHERE cash_receipt_id = p_cash_receipt_id;
737:
738: IF (arp_util.validate_and_default_gl_date(
739: l_gl_date,
740: NULL,
741: l_gl_date,
742: NULL,

Line 882: arp_util.debug('reverse_action: ' || 'API error count '||to_char(NVL(l_msg_count,0)));

878: /*------------------------------------------------+
879: | Write API output to the concurrent program log |
880: +------------------------------------------------*/
881: IF PG_DEBUG in ('Y', 'C') THEN
882: arp_util.debug('reverse_action: ' || 'API error count '||to_char(NVL(l_msg_count,0)));
883: END IF;
884:
885: IF NVL(l_msg_count,0) > 0 Then
886:

Line 894: arp_util.debug('reverse_action: ' || l_msg_data);

890: | There is one message returned by the API, so it|
891: | has been sent out NOCOPY in the parameter x_msg_data |
892: +------------------------------------------------*/
893: IF PG_DEBUG in ('Y', 'C') THEN
894: arp_util.debug('reverse_action: ' || l_msg_data);
895: END IF;
896:
897: ELSIF l_msg_count > 1 Then
898:

Line 909: arp_util.debug('reverse_action: ' || to_char(l_count)||' : '||l_msg_data);

905:
906: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
907: FND_API.G_FALSE);
908: IF PG_DEBUG in ('Y', 'C') THEN
909: arp_util.debug('reverse_action: ' || to_char(l_count)||' : '||l_msg_data);
910: END IF;
911:
912: END LOOP;
913:

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 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 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 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 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 2393: arp_util.debug('Begin : ' ||to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));

2389: AND cc_error_code IS NOT NULL
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);

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 2395: arp_util.debug('--------------- Input parameters --------------------');

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;
2399: IF (p_mode = 'REMITTANCE') THEN

Line 2396: arp_util.debug('p_request_id :'||to_char(p_request_id));

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;
2399: IF (p_mode = 'REMITTANCE') THEN
2400: IF PG_DEBUG in ('Y', 'C') THEN

Line 2397: arp_util.debug('Called from : '||p_mode);

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;
2399: IF (p_mode = 'REMITTANCE') THEN
2400: IF PG_DEBUG in ('Y', 'C') THEN
2401: arp_util.debug('Locking ar_cash_receipts records for processing..');

Line 2401: arp_util.debug('Locking ar_cash_receipts records for processing..');

2397: arp_util.debug('Called from : '||p_mode);
2398: END IF;
2399: IF (p_mode = 'REMITTANCE') THEN
2400: IF PG_DEBUG in ('Y', 'C') THEN
2401: arp_util.debug('Locking ar_cash_receipts records for processing..');
2402: END IF;
2403: OPEN lock_cr;
2404: CLOSE lock_cr;
2405: correct_remittance_errors(p_request_id);

Line 2408: arp_util.debug('Locking ra_customer_trx records for processing..');

2404: CLOSE lock_cr;
2405: correct_remittance_errors(p_request_id);
2406: ELSE
2407: IF PG_DEBUG in ('Y', 'C') THEN
2408: arp_util.debug('Locking ra_customer_trx records for processing..');
2409: END IF;
2410: OPEN lock_trx;
2411: CLOSE lock_trx;
2412: correct_creation_errors(p_request_id);

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 2418: arp_util.debug('End : ' ||to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));

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
2422: IF PG_DEBUG in ('Y', 'C') 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 2470: arp_util.debug('value of p_cc_trx_id '||'<'||p_cc_trx_id||'>');

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||'>');
2473: arp_util.debug('value of p_instrument_number'||'<'||p_instrument_number||'>');
2474: arp_util.debug('value of p_expiration_date '||'<'||p_expiration_date||'>');

Line 2471: arp_util.debug('value of p_cc_trx_category '||'<'||p_cc_trx_category||'>');

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||'>');
2473: arp_util.debug('value of p_instrument_number'||'<'||p_instrument_number||'>');
2474: arp_util.debug('value of p_expiration_date '||'<'||p_expiration_date||'>');
2475: arp_util.debug('value of p_error_notes '||'<'||p_error_notes||'>');

Line 2472: arp_util.debug('value of p_corrective_action'||'<'||p_corrective_action||'>');

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||'>');
2473: arp_util.debug('value of p_instrument_number'||'<'||p_instrument_number||'>');
2474: arp_util.debug('value of p_expiration_date '||'<'||p_expiration_date||'>');
2475: arp_util.debug('value of p_error_notes '||'<'||p_error_notes||'>');
2476: END IF;

Line 2473: arp_util.debug('value of p_instrument_number'||'<'||p_instrument_number||'>');

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||'>');
2473: arp_util.debug('value of p_instrument_number'||'<'||p_instrument_number||'>');
2474: arp_util.debug('value of p_expiration_date '||'<'||p_expiration_date||'>');
2475: arp_util.debug('value of p_error_notes '||'<'||p_error_notes||'>');
2476: END IF;
2477: IF (p_error_notes IS NULL) OR(p_error_notes = ' ') THEN

Line 2474: arp_util.debug('value of p_expiration_date '||'<'||p_expiration_date||'>');

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||'>');
2473: arp_util.debug('value of p_instrument_number'||'<'||p_instrument_number||'>');
2474: arp_util.debug('value of p_expiration_date '||'<'||p_expiration_date||'>');
2475: arp_util.debug('value of p_error_notes '||'<'||p_error_notes||'>');
2476: END IF;
2477: IF (p_error_notes IS NULL) OR(p_error_notes = ' ') THEN
2478: l_error_notes := NULL;

Line 2475: arp_util.debug('value of p_error_notes '||'<'||p_error_notes||'>');

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||'>');
2473: arp_util.debug('value of p_instrument_number'||'<'||p_instrument_number||'>');
2474: arp_util.debug('value of p_expiration_date '||'<'||p_expiration_date||'>');
2475: arp_util.debug('value of p_error_notes '||'<'||p_error_notes||'>');
2476: END IF;
2477: IF (p_error_notes IS NULL) OR(p_error_notes = ' ') THEN
2478: l_error_notes := NULL;
2479: ELSE

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 2609: arp_util.debug('cc error has occurred while automatic receipt processing..');

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..');
2610: arp_util.debug('So calling the concurrent program to correct any automatically correctable issues');
2611: END IF;
2612: l_request_id := fnd_request.submit_request(
2613: application=>'AR',

Line 2610: arp_util.debug('So calling the concurrent program to correct any automatically correctable issues');

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..');
2610: arp_util.debug('So calling the concurrent program to correct any automatically correctable issues');
2611: END IF;
2612: l_request_id := fnd_request.submit_request(
2613: application=>'AR',
2614: program=>'ARCCAUTOCON',

Line 2618: arp_util.debug('Submitted request no : ' || l_request_id);

2614: program=>'ARCCAUTOCON',
2615: argument1=>p_request_id,
2616: argument2=>p_mode);
2617: IF PG_DEBUG in ('Y', 'C') THEN
2618: arp_util.debug('Submitted request no : ' || l_request_id);
2619: END IF;
2620: commit;
2621: ELSE
2622: IF PG_DEBUG in ('Y', 'C') THEN

Line 2623: arp_util.debug('No cc error has occurred while automatic receipt processing..');

2619: END IF;
2620: commit;
2621: ELSE
2622: IF PG_DEBUG in ('Y', 'C') THEN
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()-');

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. |