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_TRX_DEFAULTS_3 dependencies on ARP_TRX_DEFAULTS_3

Line 1: PACKAGE BODY ARP_TRX_DEFAULTS_3 AS

1: PACKAGE BODY ARP_TRX_DEFAULTS_3 AS
2: /* $Header: ARTUDF3B.pls 120.32.12020000.2 2012/07/24 14:41:09 ashlkuma ship $ */
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5:

Line 57: arp_util.debug('arp_trx_defaults_3.get_default_remit_to()+');

53:
54:
55: BEGIN
56:
57: arp_util.debug('arp_trx_defaults_3.get_default_remit_to()+');
58:
59:
60: /*----------------------------------------------------------------+
61: | If the default remit to address has not been determined, |

Line 113: arp_util.debug('arp_trx_defaults_3.get_default_remit_to()-');

109: arp_util.debug('postal code: = ' || pg_remit_to_address_rec.postal_code);
110: arp_util.debug('country: = ' || pg_remit_to_address_rec.country);
111: arp_util.debug(' ');
112:
113: arp_util.debug('arp_trx_defaults_3.get_default_remit_to()-');
114:
115: EXCEPTION
116: WHEN OTHERS THEN
117: arp_util.debug('EXCEPTION: arp_trx_defaults_3.get_default_remit_to()');

Line 117: arp_util.debug('EXCEPTION: arp_trx_defaults_3.get_default_remit_to()');

113: arp_util.debug('arp_trx_defaults_3.get_default_remit_to()-');
114:
115: EXCEPTION
116: WHEN OTHERS THEN
117: arp_util.debug('EXCEPTION: arp_trx_defaults_3.get_default_remit_to()');
118: RAISE;
119:
120: END;
121:

Line 243: arp_util.debug('arp_trx_defaults_3.get_remit_to_address()+');

239:
240:
241: BEGIN
242:
243: arp_util.debug('arp_trx_defaults_3.get_remit_to_address()+');
244:
245: /*----------------------------------+
246: | Initialize the OUT NOCOPY parameters |
247: +----------------------------------*/

Line 400: arp_util.debug('arp_trx_defaults_3.get_remit_to_address()-');

396: arp_util.debug('postal code: = ' || l_remit_to_address_rec.postal_code);
397: arp_util.debug('country: = ' || l_remit_to_address_rec.country);
398: arp_util.debug(' ');
399:
400: arp_util.debug('arp_trx_defaults_3.get_remit_to_address()-');
401:
402: EXCEPTION
403: WHEN OTHERS THEN
404: arp_util.debug('EXCEPTION: arp_trx_defaults_3.get_remit_to_address()');

Line 404: arp_util.debug('EXCEPTION: arp_trx_defaults_3.get_remit_to_address()');

400: arp_util.debug('arp_trx_defaults_3.get_remit_to_address()-');
401:
402: EXCEPTION
403: WHEN OTHERS THEN
404: arp_util.debug('EXCEPTION: arp_trx_defaults_3.get_remit_to_address()');
405:
406: arp_util.debug('---------- ' ||
407: 'Parameters for arp_trx_defaults_3.get_remit_to_address() ' ||
408: '---------- ');

Line 407: 'Parameters for arp_trx_defaults_3.get_remit_to_address() ' ||

403: WHEN OTHERS THEN
404: arp_util.debug('EXCEPTION: arp_trx_defaults_3.get_remit_to_address()');
405:
406: arp_util.debug('---------- ' ||
407: 'Parameters for arp_trx_defaults_3.get_remit_to_address() ' ||
408: '---------- ');
409:
410: arp_util.debug('p_match_state : ' || p_match_state );
411: arp_util.debug('p_match_country : ' || p_match_country );

Line 612: arp_util.debug('arp_trx_defaults_3.check_payment_method()+');

608:
609: BEGIN
610:
611: IF PG_DEBUG in ('Y', 'C') THEN
612: arp_util.debug('arp_trx_defaults_3.check_payment_method()+');
613: END IF;
614:
615: /* 19-APR-2000 J Rautiainen BR Implementation.
616: * Moved select statement to cursor. Also removed NO_DATA_FOUND

Line 646: arp_util.debug('arp_trx_defaults_3.check_payment_method()-');

642: arp_util.debug('check_payment_method: ' || 'p_receipt_method_id = ' ||
643: TO_CHAR(l_receipt_method_id ) );
644: arp_util.debug('check_payment_method: ' || 'p_creation_method_code = ' || l_creation_method_code );
645: arp_util.debug('check_payment_method: ' || 'return value = TRUE');
646: arp_util.debug('arp_trx_defaults_3.check_payment_method()-');
647: END IF;
648:
649:
650: return(TRUE);

Line 657: 'EXCEPTION: arp_trx_defaults_3.check_payment_method()');

653:
654: WHEN OTHERS THEN
655: IF PG_DEBUG in ('Y', 'C') THEN
656: arp_util.debug('check_payment_method: ' ||
657: 'EXCEPTION: arp_trx_defaults_3.check_payment_method()');
658: arp_util.debug('------- parameters for check_payment_method ----');
659: arp_util.debug('check_payment_method: ' || 'p_trx_date = ' || TO_CHAR(p_trx_date) );
660: arp_util.debug('check_payment_method: ' || 'p_customer_id = ' || TO_CHAR(p_customer_id) );
661: arp_util.debug('check_payment_method: ' || 'p_site_use_id = ' || TO_CHAR(p_site_use_id) );

Line 738: arp_util.debug('arp_trx_defaults_3.check_bank_default()+');

734:
735: BEGIN
736:
737: IF PG_DEBUG in ('Y', 'C') THEN
738: arp_util.debug('arp_trx_defaults_3.check_bank_default()+');
739: END IF;
740: /* PAYMENT UPTAKE removed the code to default the bank_account */
741:
742: return(TRUE);

Line 808: arp_util.debug('arp_trx_defaults_3.get_payment_method_default()+');

804:
805: BEGIN
806:
807: IF PG_DEBUG in ('Y', 'C') THEN
808: arp_util.debug('arp_trx_defaults_3.get_payment_method_default()+');
809: END IF;
810:
811:
812: /*-----------------------------------------------------------------+

Line 929: arp_util.debug('arp_trx_defaults_3.get_payment_method_default()-');

925: END IF;
926: END IF;
927:
928: IF PG_DEBUG in ('Y', 'C') THEN
929: arp_util.debug('arp_trx_defaults_3.get_payment_method_default()-');
930: END IF;
931:
932: EXCEPTION
933: WHEN NO_DATA_FOUND THEN NULL;

Line 937: 'EXCEPTION: arp_trx_defaults_3.get_payment_method_default()');

933: WHEN NO_DATA_FOUND THEN NULL;
934: WHEN OTHERS THEN
935: IF PG_DEBUG in ('Y', 'C') THEN
936: arp_util.debug('get_payment_method_default: ' ||
937: 'EXCEPTION: arp_trx_defaults_3.get_payment_method_default()');
938: arp_util.debug('get_payment_method_default: ' ||
939: '------- parameters for get_payment_method_default ----');
940: arp_util.debug('get_payment_method_default: ' || 'p_trx_date = ' || TO_CHAR(p_trx_date) );
941: arp_util.debug('get_payment_method_default: ' || 'p_currency_code = ' || p_currency_code );

Line 1022: arp_util.debug('arp_trx_defaults_3.get_bank_defaults()+');

1018:
1019: BEGIN
1020:
1021: IF PG_DEBUG in ('Y', 'C') THEN
1022: arp_util.debug('arp_trx_defaults_3.get_bank_defaults()+');
1023: END IF;
1024:
1025:
1026: /*-----------------------------------------------------------------+

Line 1174: arp_util.debug('arp_trx_defaults_3.get_bank_defaults()-');

1170: END IF;
1171: END IF;
1172:
1173: IF PG_DEBUG in ('Y', 'C') THEN
1174: arp_util.debug('arp_trx_defaults_3.get_bank_defaults()-');
1175: END IF;
1176:
1177: EXCEPTION
1178: WHEN NO_DATA_FOUND THEN NULL;

Line 1182: 'EXCEPTION: arp_trx_defaults_3.get_bank_defaults()');

1178: WHEN NO_DATA_FOUND THEN NULL;
1179: WHEN OTHERS THEN
1180: IF PG_DEBUG in ('Y', 'C') THEN
1181: arp_util.debug('get_bank_defaults: ' ||
1182: 'EXCEPTION: arp_trx_defaults_3.get_bank_defaults()');
1183: arp_util.debug('get_bank_defaults: ' ||
1184: '------- parameters for get_bank_defaults ----');
1185: arp_util.debug('get_bank_defaults: ' || 'p_trx_date = ' || TO_CHAR(p_trx_date) );
1186: arp_util.debug('get_bank_defaults: ' || 'p_currency_code = ' || p_currency_code );

Line 1275: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'arp_trx_defaults_3.get_pay_method_and_bank_deflt()+');

1271:
1272: BEGIN
1273:
1274: IF PG_DEBUG in ('Y', 'C') THEN
1275: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'arp_trx_defaults_3.get_pay_method_and_bank_deflt()+');
1276: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'calling get_payment_method_default()');
1277: END IF;
1278: get_payment_method_default(
1279: p_trx_date,

Line 1319: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'arp_trx_defaults_3.get_pay_method_and_bank_deflt()-');

1315: p_trx_manual_flag /* Bug-3770337-PM */
1316: );
1317: END IF;
1318: IF PG_DEBUG in ('Y', 'C') THEN
1319: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'arp_trx_defaults_3.get_pay_method_and_bank_deflt()-');
1320: END IF;
1321:
1322: EXCEPTION
1323: WHEN NO_DATA_FOUND THEN NULL;

Line 1327: 'EXCEPTION: arp_trx_defaults_3.get_pay_method_and_bank_deflt()');

1323: WHEN NO_DATA_FOUND THEN NULL;
1324: WHEN OTHERS THEN
1325: IF PG_DEBUG in ('Y', 'C') THEN
1326: arp_util.debug('get_pay_method_and_bank_deflts: ' ||
1327: 'EXCEPTION: arp_trx_defaults_3.get_pay_method_and_bank_deflt()');
1328: arp_util.debug('get_pay_method_and_bank_deflts: ' ||
1329: '------- parameters for get_pay_method_and_bank_deflt ----');
1330: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_trx_date = ' || TO_CHAR(p_trx_date) );
1331: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_currency_code = ' || p_currency_code );

Line 1391: arp_util.debug('arp_trx_defaults_3.get_remit_to_default()+');

1387:
1388: BEGIN
1389:
1390: IF PG_DEBUG in ('Y', 'C') THEN
1391: arp_util.debug('arp_trx_defaults_3.get_remit_to_default()+');
1392: END IF;
1393:
1394:
1395: BEGIN

Line 1396: arp_trx_defaults_3.get_remit_to_address(

1392: END IF;
1393:
1394:
1395: BEGIN
1396: arp_trx_defaults_3.get_remit_to_address(
1397: p_state,
1398: p_country,
1399: p_postal_code,
1400: NULL,

Line 1449: arp_util.debug('arp_trx_defaults_3.get_remit_to_default()-');

1445: WHEN OTHERS THEN RAISE;
1446: END;
1447:
1448: IF PG_DEBUG in ('Y', 'C') THEN
1449: arp_util.debug('arp_trx_defaults_3.get_remit_to_default()-');
1450: END IF;
1451:
1452: EXCEPTION
1453: WHEN NO_DATA_FOUND THEN NULL;

Line 1456: arp_util.debug('EXCEPTION: arp_trx_defaults_3.get_remit_to_default()');

1452: EXCEPTION
1453: WHEN NO_DATA_FOUND THEN NULL;
1454: WHEN OTHERS THEN
1455: IF PG_DEBUG in ('Y', 'C') THEN
1456: arp_util.debug('EXCEPTION: arp_trx_defaults_3.get_remit_to_default()');
1457: arp_util.debug('------- parameters for get_remit_to_default ----');
1458: arp_util.debug('get_remit_to_default: ' || 'p_state = ' || p_state);
1459: arp_util.debug('get_remit_to_default: ' || 'p_postal_code = ' || p_postal_code);
1460: arp_util.debug('get_remit_to_default: ' || 'p_countrye = ' || p_country);

Line 1533: arp_util.debug('arp_trx_defaults_3.get_term_default()+');

1529:
1530: BEGIN
1531:
1532: IF PG_DEBUG in ('Y', 'C') THEN
1533: arp_util.debug('arp_trx_defaults_3.get_term_default()+');
1534: END IF;
1535:
1536: /*------------------------------------------------------+
1537: | If the term has already been specified, do nothing |

Line 1750: arp_util.debug('arp_trx_defaults_3.get_term_default()-');

1746:
1747: END IF;
1748:
1749: IF PG_DEBUG in ('Y', 'C') THEN
1750: arp_util.debug('arp_trx_defaults_3.get_term_default()-');
1751: END IF;
1752:
1753: EXCEPTION
1754: WHEN NO_DATA_FOUND THEN NULL;

Line 1757: arp_util.debug('EXCEPTION: arp_trx_defaults_3.get_term_default()');

1753: EXCEPTION
1754: WHEN NO_DATA_FOUND THEN NULL;
1755: WHEN OTHERS THEN
1756: IF PG_DEBUG in ('Y', 'C') THEN
1757: arp_util.debug('EXCEPTION: arp_trx_defaults_3.get_term_default()');
1758: END IF;
1759: RAISE;
1760:
1761: END get_term_default;

Line 1819: arp_util.debug('arp_trx_defaults_3.Get_Additional_Customer_Info()+');

1815: l_agreements_exist_flag varchar2(1);
1816:
1817: BEGIN
1818:
1819: arp_util.debug('arp_trx_defaults_3.Get_Additional_Customer_Info()+');
1820:
1821:
1822: l_override_terms :=
1823: arpt_sql_func_util.get_override_terms(p_customer_id,

Line 1872: arp_util.debug('arp_trx_defaults_3.Get_Additional_Customer_Info()-');

1868: l_commitments_exist_flag);
1869: arp_util.debug('p_agreements_exist_flag = ' ||
1870: l_agreements_exist_flag);
1871:
1872: arp_util.debug('arp_trx_defaults_3.Get_Additional_Customer_Info()-');
1873:
1874: EXCEPTION
1875: WHEN OTHERS THEN
1876: arp_util.debug('EXCEPTION : '||

Line 1877: 'arp_trx_defaults_3.Get_Additional_Customer_Info()-');

1873:
1874: EXCEPTION
1875: WHEN OTHERS THEN
1876: arp_util.debug('EXCEPTION : '||
1877: 'arp_trx_defaults_3.Get_Additional_Customer_Info()-');
1878:
1879: RAISE;
1880: END;
1881:

Line 1917: arp_standard.debug('arp_trx_defaults_3.get_payment_channel_name()+');

1913:
1914: l_payment_channel_name iby_fndcpt_all_pmt_channels_v.payment_channel_name%type; --corrected the field name Bug5367658
1915: BEGIN
1916: IF PG_DEBUG in ('Y', 'C') THEN
1917: arp_standard.debug('arp_trx_defaults_3.get_payment_channel_name()+');
1918: END IF;
1919:
1920: Select payment_channel_name
1921: into l_payment_channel_name

Line 1938: 'EXCEPTION: arp_trx_defaults_3.get_payment_channel_name()');

1934:
1935: WHEN OTHERS THEN
1936: IF PG_DEBUG in ('Y', 'C') THEN
1937: arp_util.debug('get_payment_channel_name: ' ||
1938: 'EXCEPTION: arp_trx_defaults_3.get_payment_channel_name()');
1939: arp_util.debug('get_payment_channel_name: ' || '------- parameters for get_payment_channel_name----');
1940: arp_util.debug('get_payment_channel_name: ' || 'p_payment_channel_code = ' || p_payment_channel_code);
1941: END IF;
1942:

Line 1979: arp_standard.debug('arp_trx_defaults_3.get_party_id()+');

1975: ) RETURN NUMBER IS
1976: l_party_id number;
1977: BEGIN
1978: IF PG_DEBUG in ('Y', 'C') THEN
1979: arp_standard.debug('arp_trx_defaults_3.get_party_id()+');
1980: END IF;
1981:
1982: Select party_id
1983: into l_party_id

Line 1998: 'EXCEPTION: arp_trx_defaults_3.get_party_id()');

1994:
1995: WHEN OTHERS THEN
1996: IF PG_DEBUG in ('Y', 'C') THEN
1997: arp_util.debug('get_party_id : ' ||
1998: 'EXCEPTION: arp_trx_defaults_3.get_party_id()');
1999: arp_util.debug('get_party_id: ' || '------- parameters for get_party_id ----');
2000: arp_util.debug('get_party_id: ' || 'p_cust_account_id = ' || p_cust_account_id);
2001: END IF;
2002:

Line 2043: arp_standard.debug('arp_trx_defaults_3.get_payment_instrument()+');

2039: l_instrument iby_ext_bank_accounts.MASKED_BANK_ACCOUNT_NUM%type;
2040: l_instrument_type iby_trxn_extensions_v.instrument_type%type;
2041: BEGIN
2042: IF PG_DEBUG in ('Y', 'C') THEN
2043: arp_standard.debug('arp_trx_defaults_3.get_payment_instrument()+');
2044: END IF;
2045:
2046: --Bug 8278615.
2047: SELECT instrument_type

Line 2104: 'EXCEPTION: arp_trx_defaults_3.get_payment_instrument() '|| sqlerrm);

2100:
2101: WHEN OTHERS THEN
2102: IF PG_DEBUG in ('Y', 'C') THEN
2103: arp_util.debug('get_payment_instrument: ' ||
2104: 'EXCEPTION: arp_trx_defaults_3.get_payment_instrument() '|| sqlerrm);
2105: arp_util.debug('get_payment_instrument: ' || '------- parameters ----');
2106: arp_util.debug('get_payment_instrument: ' || 'p_payment_channel_code= ' ||
2107: p_payment_channel_code);
2108: arp_util.debug('get_payment_instrument: ' || 'p_payment_trxn_extension_id= ' ||

Line 2201: l_payer.party_id := arp_trx_defaults_3.get_party_Id(p_paying_customer_id);

2197:
2198:
2199: BEGIN
2200: l_payer.payment_function := 'CUSTOMER_PAYMENT';
2201: l_payer.party_id := arp_trx_defaults_3.get_party_Id(p_paying_customer_id);
2202: l_payer.org_type := 'OPERATING_UNIT';
2203: l_payer.org_id := p_org_id;
2204: l_payer.cust_account_id := p_paying_customer_id;
2205: l_payer.account_site_id := p_paying_site_use_id;

Line 2270: END ARP_TRX_DEFAULTS_3;

2266: END init;
2267:
2268: BEGIN
2269: init;
2270: END ARP_TRX_DEFAULTS_3;