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 748: IF (arp_util.validate_and_default_gl_date(

744: INTO l_sob_id
745: FROM ar_cash_receipts
746: WHERE cash_receipt_id = p_cash_receipt_id;
747:
748: IF (arp_util.validate_and_default_gl_date(
749: l_gl_date,
750: NULL,
751: l_gl_date,
752: NULL,

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

888: /*------------------------------------------------+
889: | Write API output to the concurrent program log |
890: +------------------------------------------------*/
891: IF PG_DEBUG in ('Y', 'C') THEN
892: arp_util.debug('reverse_action: ' || 'API error count '||to_char(NVL(l_msg_count,0)));
893: END IF;
894:
895: IF NVL(l_msg_count,0) > 0 Then
896:

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

900: | There is one message returned by the API, so it|
901: | has been sent out NOCOPY in the parameter x_msg_data |
902: +------------------------------------------------*/
903: IF PG_DEBUG in ('Y', 'C') THEN
904: arp_util.debug('reverse_action: ' || l_msg_data);
905: END IF;
906:
907: ELSIF l_msg_count > 1 Then
908:

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

915:
916: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
917: FND_API.G_FALSE);
918: IF PG_DEBUG in ('Y', 'C') THEN
919: arp_util.debug('reverse_action: ' || to_char(l_count)||' : '||l_msg_data);
920: END IF;
921:
922: END LOOP;
923:

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

949: END IF;
950: EXCEPTION
951: WHEN API_exception THEN
952: IF PG_DEBUG in ('Y', 'C') THEN
953: arp_util.debug('ARP_CORRECT_CC_ERRORS.reverse_action: ' || 'API EXCEPTION: ' ||
954: 'ARP_CORRECT_CC_ERRORS.reverse_receipt'
955: ||SQLERRM);
956: END IF;
957: RAISE;

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

956: END IF;
957: RAISE;
958: WHEN OTHERS THEN
959: IF PG_DEBUG in ('Y', 'C') THEN
960: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.reverse_receipt '
961: ||SQLERRM);
962: END IF;
963: RAISE;
964: END reverse_receipt;

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

1028: l_key VARCHAR2(240);
1029: l_event_name VARCHAR2(150);
1030: BEGIN
1031: IF PG_DEBUG in ('Y', 'C') THEN
1032: arp_util.debug('ARP_CORRECT_CC_ERRORS.Raise_RefundReverse_Event (+)');
1033: END IF;
1034: -- Assign the business event
1035: l_event_name := 'oracle.apps.ar.ccerrorhandling.RefunReverse';
1036: --Get the item key

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

1103: p_event_key => l_key,
1104: p_parameters => l_list );
1105: l_list.DELETE;
1106: IF PG_DEBUG in ('Y', 'C') THEN
1107: arp_util.debug('ARP_CORRECT_CC_ERRORS.Raise_RefundReverse_Event (-)');
1108: END IF;
1109: EXCEPTION
1110: WHEN others THEN
1111: IF PG_DEBUG in ('Y', 'C') THEN

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

1108: END IF;
1109: EXCEPTION
1110: WHEN others THEN
1111: IF PG_DEBUG in ('Y', 'C') THEN
1112: arp_util.debug('ERR RAISING EVENT in ARP_CORRECT_CC_ERRORS.Raise_RefundReverse_Event: '||l_event_name);
1113: END IF;
1114: raise;
1115: END Raise_RefundReverse_Event;
1116:

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

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

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

1283: p_event_key => l_key,
1284: p_parameters => l_list );
1285: l_list.DELETE;
1286: IF PG_DEBUG in ('Y', 'C') THEN
1287: arp_util.debug('ARP_CORRECT_CC_ERRORS.Raise_Collection_Event (-)');
1288: END IF;
1289: EXCEPTION
1290: WHEN others THEN
1291: IF PG_DEBUG in ('Y', 'C') THEN

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

1288: END IF;
1289: EXCEPTION
1290: WHEN others THEN
1291: IF PG_DEBUG in ('Y', 'C') THEN
1292: arp_util.debug('ERR RAISING EVENT from ARP_CORRECT_CC_ERRORS.Raise_Collection_Event: '||l_event_name);
1293: raise;
1294: END IF;
1295: END Raise_Collection_Event;
1296:

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

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

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

1351: l_param.SetValue( l_org_name );
1352: l_rang := l_rang + 1;
1353: x_list(l_rang) := l_param;
1354: IF PG_DEBUG in ('Y', 'C') THEN
1355: arp_util.debug('ARP_CORRECT_CC_ERRORS.AddParamEnvToList ()-');
1356: END IF;
1357: EXCEPTION
1358: WHEN OTHERS THEN
1359: IF PG_DEBUG in ('Y', 'C') THEN

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

1356: END IF;
1357: EXCEPTION
1358: WHEN OTHERS THEN
1359: IF PG_DEBUG in ('Y', 'C') THEN
1360: arp_util.debug('EXCEPTION ARP_CORRECT_CC_ERRORS.AddParamEnvToList ()');
1361: END IF;
1362: raise;
1363: END AddParamEnvToList;
1364:

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

1427: EventNotFound EXCEPTION;
1428: EventNotARCC EXCEPTION;
1429: BEGIN
1430: IF PG_DEBUG in ('Y', 'C') THEN
1431: arp_util.debug('ARP_CORRECT_CC_ERRORS.raise_event ()+');
1432: END IF;
1433:
1434: SAVEPOINT ar_cccorrection_raise_event;
1435:

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

1449: p_parameters => p_parameters,
1450: p_event_data => p_data);
1451:
1452: IF PG_DEBUG in ('Y', 'C') THEN
1453: arp_util.debug('ARP_CORRECT_CC_ERRORS.raise_event ()-');
1454: END IF;
1455:
1456: EXCEPTION
1457: WHEN EventNotFound THEN

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

1510: p_text IN VARCHAR2) IS
1511: l_note_id ar_notes.note_id%type;
1512: BEGIN
1513: IF PG_DEBUG in ('Y', 'C') THEN
1514: arp_util.debug('ARP_CORRECT_CC_ERRORS.attach_notes()+');
1515: END IF;
1516:
1517: INSERT INTO ar_notes
1518: (

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

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

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

1549: END IF;
1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: IF PG_DEBUG in ('Y', 'C') THEN
1553: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.attach_notes()');
1554: END IF;
1555: raise;
1556: END attach_notes;
1557:

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

1586: p_trx_number IN VARCHAR2) IS
1587: l_dummy_number NUMBER;
1588: BEGIN
1589: IF PG_DEBUG in ('Y', 'C') THEN
1590: arp_util.debug('ARP_CORRECT_CC_ERRORS.lock_table_nowait()+');
1591: END IF;
1592: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN
1593: arp_cash_receipts_pkg.nowaitlock_version_p(p_key,p_object_version_number);
1594: ELSE

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

1596: -- which does locking
1597: ARP_CT_PKG.lock_p(p_key);
1598: END IF;
1599: IF PG_DEBUG in ('Y', 'C') THEN
1600: arp_util.debug('ARP_CORRECT_CC_ERRORS.lock_table_nowait()-');
1601: END IF;
1602: EXCEPTION
1603: WHEN NO_DATA_FOUND THEN
1604: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN

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

1610: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1611: FND_MSG_PUB.Add;
1612: END IF;
1613: IF PG_DEBUG in ('Y', 'C') THEN
1614: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.lock_table_nowait()');
1615: END IF;
1616: app_exception.raise_exception;
1617: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1618: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN

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

1624: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1625: FND_MSG_PUB.Add;
1626: END IF;
1627: IF PG_DEBUG in ('Y', 'C') THEN
1628: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.lock_table_nowait()');
1629: END IF;
1630: app_exception.raise_exception;
1631: WHEN OTHERS THEN
1632: raise;

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

1659: FUNCTION cc_error_occurred(p_mode VARCHAR2,p_request_id NUMBER) RETURN VARCHAR2 IS
1660: l_return_status VARCHAR2(1);
1661: BEGIN
1662: IF PG_DEBUG in ('Y', 'C') THEN
1663: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_error_occurred()+');
1664: END IF;
1665: l_return_status := 'Y';
1666: IF p_mode = 'REMITTANCE' THEN
1667: BEGIN

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

1679: WHEN NO_DATA_FOUND THEN
1680: l_return_status := 'N';
1681: WHEN OTHERS THEN
1682: IF PG_DEBUG in ('Y', 'C') THEN
1683: arp_util.debug('Exception : ARP_CORRECT_CC_ERRORS.cc_error_occurred');
1684: END IF;
1685: raise;
1686: END;
1687: ELSE

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

1700: WHEN NO_DATA_FOUND THEN
1701: l_return_status := 'N';
1702: WHEN OTHERS THEN
1703: IF PG_DEBUG in ('Y', 'C') THEN
1704: arp_util.debug('Exception : ARP_CORRECT_CC_ERRORS.cc_error_occured');
1705: END IF;
1706: raise;
1707: END;
1708: END IF;

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

1706: raise;
1707: END;
1708: END IF;
1709: IF PG_DEBUG in ('Y', 'C') THEN
1710: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_error_occurred()-');
1711: END IF;
1712: RETURN l_return_status;
1713: END cc_error_occurred;
1714:

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

1759: AND cc_error_flag = 'Y'
1760: AND cc_error_code IS NOT NULL;
1761: BEGIN
1762: IF PG_DEBUG in ('Y', 'C') THEN
1763: arp_util.debug('arp_correct_cc_errors.correct_remittance_errors()+');
1764: END IF;
1765: FOR cr_rec IN cr LOOP
1766:
1767: -- Call get_action_code

Line 1779: arp_util.debug('l_cc_action_code '|| l_cc_action_code);

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);
1778:
1779: arp_util.debug('l_cc_action_code '|| l_cc_action_code);
1780: arp_util.debug('l_cc_action_type '|| l_cc_action_type);
1781: arp_util.debug('l_cc_error_desc '|| l_cc_error_desc);
1782: arp_util.debug('l_error_notes '|| l_error_notes);
1783:

Line 1780: arp_util.debug('l_cc_action_type '|| l_cc_action_type);

1776: x_cc_action_type => l_cc_action_type,
1777: x_error_notes => l_error_notes);
1778:
1779: arp_util.debug('l_cc_action_code '|| l_cc_action_code);
1780: arp_util.debug('l_cc_action_type '|| l_cc_action_type);
1781: arp_util.debug('l_cc_error_desc '|| l_cc_error_desc);
1782: arp_util.debug('l_error_notes '|| l_error_notes);
1783:
1784: IF l_cc_action_code = 'RET' THEN

Line 1781: arp_util.debug('l_cc_error_desc '|| l_cc_error_desc);

1777: x_error_notes => l_error_notes);
1778:
1779: arp_util.debug('l_cc_action_code '|| l_cc_action_code);
1780: arp_util.debug('l_cc_action_type '|| l_cc_action_type);
1781: arp_util.debug('l_cc_error_desc '|| l_cc_error_desc);
1782: arp_util.debug('l_error_notes '|| l_error_notes);
1783:
1784: IF l_cc_action_code = 'RET' THEN
1785: -- Unmark the errors so that receipt can be picked next time

Line 1782: arp_util.debug('l_error_notes '|| l_error_notes);

1778:
1779: arp_util.debug('l_cc_action_code '|| l_cc_action_code);
1780: arp_util.debug('l_cc_action_type '|| l_cc_action_type);
1781: arp_util.debug('l_cc_error_desc '|| l_cc_error_desc);
1782: arp_util.debug('l_error_notes '|| l_error_notes);
1783:
1784: IF l_cc_action_code = 'RET' THEN
1785: -- Unmark the errors so that receipt can be picked next time
1786: retry(p_cc_trx_id => cr_rec.cash_receipt_id,

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

1827: insert_p(l_cc_error_hist);
1828: END IF;
1829: END LOOP;
1830: IF PG_DEBUG in ('Y', 'C') THEN
1831: arp_util.debug('arp_correct_cc_errors.correct_remittance_errors()-');
1832: END IF;
1833: EXCEPTION
1834: WHEN OTHERS THEN
1835: IF PG_DEBUG in ('Y', 'C') THEN

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

1832: END IF;
1833: EXCEPTION
1834: WHEN OTHERS THEN
1835: IF PG_DEBUG in ('Y', 'C') THEN
1836: arp_util.debug('Exception in arp_correct_cc_errors.correct_remittance_errors()');
1837: END IF;
1838: raise;
1839: END correct_remittance_errors;
1840:

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

1887: AND trx.cc_error_flag = 'Y'
1888: AND cc_error_code IS NOT NULL;
1889: BEGIN
1890: IF PG_DEBUG in ('Y', 'C') THEN
1891: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_creation_errors()+');
1892: END IF;
1893: FOR inv_rec IN inv LOOP
1894: get_action_code( p_cc_trx_id => inv_rec.customer_trx_id,
1895: p_cc_trx_category => inv_rec.type,

Line 1905: arp_util.debug('l_cc_action_code '|| l_cc_action_code);

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);
1904:
1905: arp_util.debug('l_cc_action_code '|| l_cc_action_code);
1906: arp_util.debug('l_cc_action_type '|| l_cc_action_type);
1907: arp_util.debug('l_cc_error_desc '|| l_cc_error_desc);
1908: arp_util.debug('l_error_notes '|| l_error_notes);
1909:

Line 1906: arp_util.debug('l_cc_action_type '|| l_cc_action_type);

1902: x_cc_action_type => l_cc_action_type,
1903: x_error_notes => l_error_notes);
1904:
1905: arp_util.debug('l_cc_action_code '|| l_cc_action_code);
1906: arp_util.debug('l_cc_action_type '|| l_cc_action_type);
1907: arp_util.debug('l_cc_error_desc '|| l_cc_error_desc);
1908: arp_util.debug('l_error_notes '|| l_error_notes);
1909:
1910: IF l_cc_action_code = 'RET' THEN

Line 1907: arp_util.debug('l_cc_error_desc '|| l_cc_error_desc);

1903: x_error_notes => l_error_notes);
1904:
1905: arp_util.debug('l_cc_action_code '|| l_cc_action_code);
1906: arp_util.debug('l_cc_action_type '|| l_cc_action_type);
1907: arp_util.debug('l_cc_error_desc '|| l_cc_error_desc);
1908: arp_util.debug('l_error_notes '|| l_error_notes);
1909:
1910: IF l_cc_action_code = 'RET' THEN
1911: -- Unmark the errors so that invoice is picked next time

Line 1908: arp_util.debug('l_error_notes '|| l_error_notes);

1904:
1905: arp_util.debug('l_cc_action_code '|| l_cc_action_code);
1906: arp_util.debug('l_cc_action_type '|| l_cc_action_type);
1907: arp_util.debug('l_cc_error_desc '|| l_cc_error_desc);
1908: arp_util.debug('l_error_notes '|| l_error_notes);
1909:
1910: IF l_cc_action_code = 'RET' THEN
1911: -- Unmark the errors so that invoice is picked next time
1912: retry(p_cc_trx_id => inv_rec.customer_trx_id,

Line 1935: arp_util.debug('Update current_record_flag. Sql%rowcount '|| sql%rowcount);

1931: WHERE cc_trx_id = inv_rec.customer_trx_id
1932: AND cc_trx_category = inv_rec.type
1933: AND payment_trxn_extension_id = inv_rec.payment_trxn_extension_id
1934: AND cc_error_code = inv_rec.cc_error_code;
1935: arp_util.debug('Update current_record_flag. Sql%rowcount '|| sql%rowcount);
1936:
1937: END IF;
1938: l_cc_error_hist.request_id := inv_rec.request_id;
1939: l_cc_error_hist.cc_trx_category := inv_rec.type;

Line 1950: arp_util.debug('Calling Insert into ar_cc_error_history');

1946: l_cc_error_hist.payment_trxn_extension_id := inv_rec.payment_trxn_extension_id;
1947: l_cc_error_hist.first_record_flag := l_first_record_flag;
1948: l_cc_error_hist.current_record_flag := 'Y';
1949:
1950: arp_util.debug('Calling Insert into ar_cc_error_history');
1951: insert_p(l_cc_error_hist);
1952: END IF;
1953: END LOOP;
1954: IF PG_DEBUG in ('Y', 'C') THEN

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

1951: insert_p(l_cc_error_hist);
1952: END IF;
1953: END LOOP;
1954: IF PG_DEBUG in ('Y', 'C') THEN
1955: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_creation_errors()-');
1956: END IF;
1957: EXCEPTION
1958: WHEN OTHERS THEN
1959: IF PG_DEBUG in ('Y', 'C') THEN

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

1956: END IF;
1957: EXCEPTION
1958: WHEN OTHERS THEN
1959: IF PG_DEBUG in ('Y', 'C') THEN
1960: arp_util.debug('EXCEPTION ARP_CORRECT_CC_ERRORS.correct_creation_errors()');
1961: END IF;
1962: RAISE;
1963: END correct_creation_errors;
1964:

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

1996: p_error_notes IN VARCHAR2) IS
1997: l_error_notes VARCHAR2(240);
1998: BEGIN
1999: IF PG_DEBUG in ('Y', 'C') THEN
2000: arp_util.debug('ARP_CORRECT_CC_ERRORS.retry()+');
2001: arp_util.debug('p_payment_trxn_extension_id ' || p_payment_trxn_extension_id );
2002: arp_util.debug('p_cc_trx_category ' || p_cc_trx_category);
2003: arp_util.debug('p_error_notes ' || p_error_notes);
2004: END IF;

Line 2001: arp_util.debug('p_payment_trxn_extension_id ' || p_payment_trxn_extension_id );

1997: l_error_notes VARCHAR2(240);
1998: BEGIN
1999: IF PG_DEBUG in ('Y', 'C') THEN
2000: arp_util.debug('ARP_CORRECT_CC_ERRORS.retry()+');
2001: arp_util.debug('p_payment_trxn_extension_id ' || p_payment_trxn_extension_id );
2002: arp_util.debug('p_cc_trx_category ' || p_cc_trx_category);
2003: arp_util.debug('p_error_notes ' || p_error_notes);
2004: END IF;
2005: IF (p_error_notes IS NULL) OR(p_error_notes = ' ') THEN

Line 2002: arp_util.debug('p_cc_trx_category ' || p_cc_trx_category);

1998: BEGIN
1999: IF PG_DEBUG in ('Y', 'C') THEN
2000: arp_util.debug('ARP_CORRECT_CC_ERRORS.retry()+');
2001: arp_util.debug('p_payment_trxn_extension_id ' || p_payment_trxn_extension_id );
2002: arp_util.debug('p_cc_trx_category ' || p_cc_trx_category);
2003: arp_util.debug('p_error_notes ' || p_error_notes);
2004: END IF;
2005: IF (p_error_notes IS NULL) OR(p_error_notes = ' ') THEN
2006: l_error_notes := NULL;

Line 2003: arp_util.debug('p_error_notes ' || p_error_notes);

1999: IF PG_DEBUG in ('Y', 'C') THEN
2000: arp_util.debug('ARP_CORRECT_CC_ERRORS.retry()+');
2001: arp_util.debug('p_payment_trxn_extension_id ' || p_payment_trxn_extension_id );
2002: arp_util.debug('p_cc_trx_category ' || p_cc_trx_category);
2003: arp_util.debug('p_error_notes ' || p_error_notes);
2004: END IF;
2005: IF (p_error_notes IS NULL) OR(p_error_notes = ' ') THEN
2006: l_error_notes := NULL;
2007: ELSE

Line 2011: arp_util.debug('Updating ar_cash_receipts record');

2007: ELSE
2008: l_error_notes := p_error_notes;
2009: END IF;
2010: IF p_cc_trx_category IN ('CASH','MISC') THEN
2011: arp_util.debug('Updating ar_cash_receipts record');
2012: arp_util.debug('cash_receipt_id '|| p_cc_trx_id);
2013:
2014: UPDATE ar_cash_receipts
2015: SET cc_error_flag = NULL,

Line 2012: arp_util.debug('cash_receipt_id '|| p_cc_trx_id);

2008: l_error_notes := p_error_notes;
2009: END IF;
2010: IF p_cc_trx_category IN ('CASH','MISC') THEN
2011: arp_util.debug('Updating ar_cash_receipts record');
2012: arp_util.debug('cash_receipt_id '|| p_cc_trx_id);
2013:
2014: UPDATE ar_cash_receipts
2015: SET cc_error_flag = NULL,
2016: cc_error_code = NULL,

Line 2022: arp_util.debug ('Sql rows updated ' || sql%rowcount);

2018: comments = DECODE(p_error_notes,NULL,comments,substrb('<'||l_error_notes||'>'||comments,1,2000)),
2019: rec_version_number = rec_version_number+1
2020: WHERE cash_receipt_id = p_cc_trx_id;
2021:
2022: arp_util.debug ('Sql rows updated ' || sql%rowcount);
2023:
2024: ELSE
2025: arp_util.debug('Updating ra_customer_trx records');
2026: arp_util.debug('customer_trx_id '|| p_cc_trx_id);

Line 2025: arp_util.debug('Updating ra_customer_trx records');

2021:
2022: arp_util.debug ('Sql rows updated ' || sql%rowcount);
2023:
2024: ELSE
2025: arp_util.debug('Updating ra_customer_trx records');
2026: arp_util.debug('customer_trx_id '|| p_cc_trx_id);
2027:
2028: UPDATE ra_customer_trx
2029: SET cc_error_flag =NULL,

Line 2026: arp_util.debug('customer_trx_id '|| p_cc_trx_id);

2022: arp_util.debug ('Sql rows updated ' || sql%rowcount);
2023:
2024: ELSE
2025: arp_util.debug('Updating ra_customer_trx records');
2026: arp_util.debug('customer_trx_id '|| p_cc_trx_id);
2027:
2028: UPDATE ra_customer_trx
2029: SET cc_error_flag =NULL,
2030: cc_error_code = NULL,

Line 2034: arp_util.debug ('Sql rows updated ' || sql%rowcount);

2030: cc_error_code = NULL,
2031: cc_error_text = NULL
2032: WHERE customer_trx_id = p_cc_trx_id;
2033:
2034: arp_util.debug ('Sql rows updated ' || sql%rowcount);
2035:
2036: IF l_error_notes IS NOT NULL THEN
2037: attach_notes(p_customer_trx_id => p_cc_trx_id,
2038: p_text => l_error_notes);

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

2039: END IF;
2040: END IF;
2041:
2042: IF PG_DEBUG in ('Y', 'C') THEN
2043: arp_util.debug('ARP_CORRECT_CC_ERRORS.retry()-');
2044: END IF;
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.retry()');

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

2043: arp_util.debug('ARP_CORRECT_CC_ERRORS.retry()-');
2044: END IF;
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.retry()');
2048: raise;
2049: END retry;
2050:
2051: /*===========================================================================+

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

2099: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
2100:
2101: BEGIN
2102: IF PG_DEBUG in ('Y', 'C') THEN
2103: arp_util.debug('ARP_CORRECT_CC_ERRORS.reauthorize()+');
2104: END IF;
2105: IF (p_error_notes IS NULL) OR(p_error_notes = ' ') THEN
2106: l_error_notes := NULL;
2107: ELSE

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

2198: END IF;
2199:
2200: END IF;
2201: IF PG_DEBUG in ('Y', 'C') THEN
2202: arp_util.debug('ARP_CORRECT_CC_ERRORS.authorize()-');
2203: END IF;
2204: EXCEPTION
2205: WHEN OTHERS THEN
2206: IF PG_DEBUG in ('Y', 'C') THEN

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

2203: END IF;
2204: EXCEPTION
2205: WHEN OTHERS THEN
2206: IF PG_DEBUG in ('Y', 'C') THEN
2207: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.reauthorize()');
2208: END IF;
2209: raise;
2210: END reauthorize;
2211:

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

2278: PAY_exception EXCEPTION;
2279:
2280: BEGIN
2281: IF PG_DEBUG in ('Y', 'C') THEN
2282: arp_util.debug('ARP_CORRECT_CC_ERRORS.obtain_alternate_payment()+');
2283: END IF;
2284: IF (p_error_notes IS NULL) OR (p_error_notes = ' ') THEN
2285:
2286: ---Bug 4192368 get notes from description field of lookup

Line 2316: arp_util.debug('p_cc_trx_category '|| p_cc_trx_category);

2312: |2)Reverse the receipt |
2313: |3)Attach an comment to the receipt |
2314: |4)Raise business event for this |
2315: +--------------------------------------------------------------*/
2316: arp_util.debug('p_cc_trx_category '|| p_cc_trx_category);
2317: /* Loop through invoices */
2318: FOR inv_cur IN inv LOOP
2319: -- Lock the invoice that needs to be cleared
2320: -- Locking should be nowait when the package is being called

Line 2453: arp_util.debug('p_cc_trx_category '|| p_cc_trx_category);

2449: | from invoice and Raise business event for this |
2450: |2)Attach an error note to the invoice |
2451: +------------------------------------------------------------*/
2452: -- send an error message
2453: arp_util.debug('p_cc_trx_category '|| p_cc_trx_category);
2454:
2455: -- Clear the credit card information and payment method from invoice
2456: clear_invoice_pay_info(p_customer_trx_id => p_cc_trx_id,
2457: p_cc_trx_category => p_cc_trx_category,

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

2458: p_error_notes => p_error_notes);
2459:
2460: END IF;
2461: IF PG_DEBUG in ('Y', 'C') THEN
2462: arp_util.debug('ARP_CORRECT_CC_ERRORS.obtain_alternate_payment()-');
2463: END IF;
2464: EXCEPTION
2465: WHEN OTHERS THEN
2466: IF PG_DEBUG in ('Y', 'C') THEN

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

2463: END IF;
2464: EXCEPTION
2465: WHEN OTHERS THEN
2466: IF PG_DEBUG in ('Y', 'C') THEN
2467: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.obtain_alternate_payment()');
2468: END IF;
2469: raise;
2470: END obtain_alternate_payment;
2471:

Line 2523: arp_util.debug('Begin : ' ||to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));

2519: AND cc_error_code IS NOT NULL
2520: FOR UPDATE OF customer_trx_id;
2521: BEGIN
2522: IF PG_DEBUG in ('Y', 'C') THEN
2523: arp_util.debug('Begin : ' ||to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
2524: arp_util.debug('arp_correct_cc_errors.cc_auto_correct()+');
2525: arp_util.debug('--------------- Input parameters --------------------');
2526: arp_util.debug('p_request_id :'||to_char(p_request_id));
2527: arp_util.debug('Called from : '||p_mode);

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

2520: FOR UPDATE OF customer_trx_id;
2521: BEGIN
2522: IF PG_DEBUG in ('Y', 'C') THEN
2523: arp_util.debug('Begin : ' ||to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
2524: arp_util.debug('arp_correct_cc_errors.cc_auto_correct()+');
2525: arp_util.debug('--------------- Input parameters --------------------');
2526: arp_util.debug('p_request_id :'||to_char(p_request_id));
2527: arp_util.debug('Called from : '||p_mode);
2528: END IF;

Line 2525: arp_util.debug('--------------- Input parameters --------------------');

2521: BEGIN
2522: IF PG_DEBUG in ('Y', 'C') THEN
2523: arp_util.debug('Begin : ' ||to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
2524: arp_util.debug('arp_correct_cc_errors.cc_auto_correct()+');
2525: arp_util.debug('--------------- Input parameters --------------------');
2526: arp_util.debug('p_request_id :'||to_char(p_request_id));
2527: arp_util.debug('Called from : '||p_mode);
2528: END IF;
2529: IF (p_mode = 'REMITTANCE') THEN

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

2522: IF PG_DEBUG in ('Y', 'C') THEN
2523: arp_util.debug('Begin : ' ||to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
2524: arp_util.debug('arp_correct_cc_errors.cc_auto_correct()+');
2525: arp_util.debug('--------------- Input parameters --------------------');
2526: arp_util.debug('p_request_id :'||to_char(p_request_id));
2527: arp_util.debug('Called from : '||p_mode);
2528: END IF;
2529: IF (p_mode = 'REMITTANCE') THEN
2530: IF PG_DEBUG in ('Y', 'C') THEN

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

2523: arp_util.debug('Begin : ' ||to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
2524: arp_util.debug('arp_correct_cc_errors.cc_auto_correct()+');
2525: arp_util.debug('--------------- Input parameters --------------------');
2526: arp_util.debug('p_request_id :'||to_char(p_request_id));
2527: arp_util.debug('Called from : '||p_mode);
2528: END IF;
2529: IF (p_mode = 'REMITTANCE') THEN
2530: IF PG_DEBUG in ('Y', 'C') THEN
2531: arp_util.debug('Locking ar_cash_receipts records for processing..');

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

2527: arp_util.debug('Called from : '||p_mode);
2528: END IF;
2529: IF (p_mode = 'REMITTANCE') THEN
2530: IF PG_DEBUG in ('Y', 'C') THEN
2531: arp_util.debug('Locking ar_cash_receipts records for processing..');
2532: END IF;
2533: OPEN lock_cr;
2534: CLOSE lock_cr;
2535: correct_remittance_errors(p_request_id);

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

2534: CLOSE lock_cr;
2535: correct_remittance_errors(p_request_id);
2536: ELSE
2537: IF PG_DEBUG in ('Y', 'C') THEN
2538: arp_util.debug('Locking ra_customer_trx records for processing..');
2539: END IF;
2540: OPEN lock_trx;
2541: CLOSE lock_trx;
2542: correct_creation_errors(p_request_id);

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

2543: END IF;
2544: retcode := 0;
2545: errbuf := 'Sucess!';
2546: IF PG_DEBUG in ('Y', 'C') THEN
2547: arp_util.debug('arp_correct_cc_errors.cc_auto_correct()-');
2548: arp_util.debug('End : ' ||to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
2549: END IF;
2550: EXCEPTION
2551: WHEN OTHERS THEN

Line 2548: arp_util.debug('End : ' ||to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));

2544: retcode := 0;
2545: errbuf := 'Sucess!';
2546: IF PG_DEBUG in ('Y', 'C') THEN
2547: arp_util.debug('arp_correct_cc_errors.cc_auto_correct()-');
2548: arp_util.debug('End : ' ||to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
2549: END IF;
2550: EXCEPTION
2551: WHEN OTHERS THEN
2552: IF PG_DEBUG in ('Y', 'C') THEN

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

2549: END IF;
2550: EXCEPTION
2551: WHEN OTHERS THEN
2552: IF PG_DEBUG in ('Y', 'C') THEN
2553: arp_util.debug('Exception in arp_correct_cc_errors.cc_auto_correct');
2554: END IF;
2555: IF lock_trx%ISOPEN THEN
2556: CLOSE lock_trx;
2557: END IF;

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

2594: p_error_notes IN VARCHAR2) IS
2595: l_error_notes VARCHAR2(240);
2596: BEGIN
2597: IF PG_DEBUG in ('Y', 'C') THEN
2598: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_funds_error()+');
2599:
2600: arp_util.debug('value of p_cc_trx_id '||'<'||p_cc_trx_id||'>');
2601: arp_util.debug('value of p_cc_trx_category '||'<'||p_cc_trx_category||'>');
2602: arp_util.debug('value of p_corrective_action'||'<'||p_corrective_action||'>');

Line 2600: arp_util.debug('value of p_cc_trx_id '||'<'||p_cc_trx_id||'>');

2596: BEGIN
2597: IF PG_DEBUG in ('Y', 'C') THEN
2598: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_funds_error()+');
2599:
2600: arp_util.debug('value of p_cc_trx_id '||'<'||p_cc_trx_id||'>');
2601: arp_util.debug('value of p_cc_trx_category '||'<'||p_cc_trx_category||'>');
2602: arp_util.debug('value of p_corrective_action'||'<'||p_corrective_action||'>');
2603: arp_util.debug('value of p_instrument_number'||'<'||p_instrument_number||'>');
2604: arp_util.debug('value of p_expiration_date '||'<'||p_expiration_date||'>');

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

2597: IF PG_DEBUG in ('Y', 'C') THEN
2598: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_funds_error()+');
2599:
2600: arp_util.debug('value of p_cc_trx_id '||'<'||p_cc_trx_id||'>');
2601: arp_util.debug('value of p_cc_trx_category '||'<'||p_cc_trx_category||'>');
2602: arp_util.debug('value of p_corrective_action'||'<'||p_corrective_action||'>');
2603: arp_util.debug('value of p_instrument_number'||'<'||p_instrument_number||'>');
2604: arp_util.debug('value of p_expiration_date '||'<'||p_expiration_date||'>');
2605: arp_util.debug('value of p_error_notes '||'<'||p_error_notes||'>');

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

2598: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_funds_error()+');
2599:
2600: arp_util.debug('value of p_cc_trx_id '||'<'||p_cc_trx_id||'>');
2601: arp_util.debug('value of p_cc_trx_category '||'<'||p_cc_trx_category||'>');
2602: arp_util.debug('value of p_corrective_action'||'<'||p_corrective_action||'>');
2603: arp_util.debug('value of p_instrument_number'||'<'||p_instrument_number||'>');
2604: arp_util.debug('value of p_expiration_date '||'<'||p_expiration_date||'>');
2605: arp_util.debug('value of p_error_notes '||'<'||p_error_notes||'>');
2606: END IF;

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

2599:
2600: arp_util.debug('value of p_cc_trx_id '||'<'||p_cc_trx_id||'>');
2601: arp_util.debug('value of p_cc_trx_category '||'<'||p_cc_trx_category||'>');
2602: arp_util.debug('value of p_corrective_action'||'<'||p_corrective_action||'>');
2603: arp_util.debug('value of p_instrument_number'||'<'||p_instrument_number||'>');
2604: arp_util.debug('value of p_expiration_date '||'<'||p_expiration_date||'>');
2605: arp_util.debug('value of p_error_notes '||'<'||p_error_notes||'>');
2606: END IF;
2607: IF (p_error_notes IS NULL) OR(p_error_notes = ' ') THEN

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

2600: arp_util.debug('value of p_cc_trx_id '||'<'||p_cc_trx_id||'>');
2601: arp_util.debug('value of p_cc_trx_category '||'<'||p_cc_trx_category||'>');
2602: arp_util.debug('value of p_corrective_action'||'<'||p_corrective_action||'>');
2603: arp_util.debug('value of p_instrument_number'||'<'||p_instrument_number||'>');
2604: arp_util.debug('value of p_expiration_date '||'<'||p_expiration_date||'>');
2605: arp_util.debug('value of p_error_notes '||'<'||p_error_notes||'>');
2606: END IF;
2607: IF (p_error_notes IS NULL) OR(p_error_notes = ' ') THEN
2608: l_error_notes := NULL;

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

2601: arp_util.debug('value of p_cc_trx_category '||'<'||p_cc_trx_category||'>');
2602: arp_util.debug('value of p_corrective_action'||'<'||p_corrective_action||'>');
2603: arp_util.debug('value of p_instrument_number'||'<'||p_instrument_number||'>');
2604: arp_util.debug('value of p_expiration_date '||'<'||p_expiration_date||'>');
2605: arp_util.debug('value of p_error_notes '||'<'||p_error_notes||'>');
2606: END IF;
2607: IF (p_error_notes IS NULL) OR(p_error_notes = ' ') THEN
2608: l_error_notes := NULL;
2609: ELSE

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

2691: END IF; /* end Clear Payment Information */
2692:
2693:
2694: IF PG_DEBUG in ('Y', 'C') THEN
2695: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_funds_error()-');
2696: END IF;
2697: EXCEPTION
2698: WHEN OTHERS THEN
2699: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.correct_funds_error()'|| SQLERRM );

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

2695: arp_util.debug('ARP_CORRECT_CC_ERRORS.correct_funds_error()-');
2696: END IF;
2697: EXCEPTION
2698: WHEN OTHERS THEN
2699: arp_util.debug('Exception in ARP_CORRECT_CC_ERRORS.correct_funds_error()'|| SQLERRM );
2700: raise;
2701: END correct_funds_error;
2702:
2703:

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

2733: l_org_id NUMBER;
2734:
2735: BEGIN
2736: IF PG_DEBUG in ('Y', 'C') THEN
2737: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover()+');
2738: arp_util.debug('Calling Program request id passed : ' || p_request_id);
2739: END IF;
2740: IF cc_error_occurred(p_mode,p_request_id) = 'Y' THEN
2741: IF PG_DEBUG in ('Y', 'C') THEN

Line 2738: arp_util.debug('Calling Program request id passed : ' || p_request_id);

2734:
2735: BEGIN
2736: IF PG_DEBUG in ('Y', 'C') THEN
2737: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover()+');
2738: arp_util.debug('Calling Program request id passed : ' || p_request_id);
2739: END IF;
2740: IF cc_error_occurred(p_mode,p_request_id) = 'Y' THEN
2741: IF PG_DEBUG in ('Y', 'C') THEN
2742: arp_util.debug('cc error has occurred while automatic receipt processing..');

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

2738: arp_util.debug('Calling Program request id passed : ' || p_request_id);
2739: END IF;
2740: IF cc_error_occurred(p_mode,p_request_id) = 'Y' THEN
2741: IF PG_DEBUG in ('Y', 'C') THEN
2742: arp_util.debug('cc error has occurred while automatic receipt processing..');
2743: arp_util.debug('So calling the concurrent program to correct any automatically correctable issues');
2744: END IF;
2745:
2746: l_org_id := mo_global.get_current_org_id;

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

2739: END IF;
2740: IF cc_error_occurred(p_mode,p_request_id) = 'Y' THEN
2741: IF PG_DEBUG in ('Y', 'C') THEN
2742: arp_util.debug('cc error has occurred while automatic receipt processing..');
2743: arp_util.debug('So calling the concurrent program to correct any automatically correctable issues');
2744: END IF;
2745:
2746: l_org_id := mo_global.get_current_org_id;
2747:

Line 2749: arp_util.debug('Setting the org_id context to child request '|| l_org_id);

2745:
2746: l_org_id := mo_global.get_current_org_id;
2747:
2748: IF PG_DEBUG in ('Y', 'C') THEN
2749: arp_util.debug('Setting the org_id context to child request '|| l_org_id);
2750: END IF;
2751:
2752: fnd_request.set_org_id(l_org_id);
2753:

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

2756: program=>'ARCCAUTOCON',
2757: argument1=>p_request_id,
2758: argument2=>p_mode);
2759: IF PG_DEBUG in ('Y', 'C') THEN
2760: arp_util.debug('Submitted request no : ' || l_request_id);
2761: END IF;
2762: commit;
2763: ELSE
2764: IF PG_DEBUG in ('Y', 'C') THEN

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

2761: END IF;
2762: commit;
2763: ELSE
2764: IF PG_DEBUG in ('Y', 'C') THEN
2765: arp_util.debug('No cc error has occurred while automatic receipt processing..');
2766: END IF;
2767: END IF;
2768: IF PG_DEBUG in ('Y', 'C') THEN
2769: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover()-');

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

2765: arp_util.debug('No cc error has occurred while automatic receipt processing..');
2766: END IF;
2767: END IF;
2768: IF PG_DEBUG in ('Y', 'C') THEN
2769: arp_util.debug('ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover()-');
2770: END IF;
2771: END cc_auto_correct_cover;
2772: /*---------------------------------------------+
2773: | Package initialization section. |