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_UTIL

Line 30: | arp_util.debug |

26: | |
27: | SCOPE - PUBLIC |
28: | |
29: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
30: | arp_util.debug |
31: | |
32: | ARGUMENTS : IN: |
33: | None |
34: | OUT: |

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 71: arp_util.debug('selecting the default remit to address.');

67:
68: IF pg_remit_to_address_rec.cust_acct_site_id IS NULL
69: THEN
70:
71: arp_util.debug('selecting the default remit to address.');
72:
73: SELECT acct_site.cust_acct_site_id,
74: loc.address1, loc.address2, loc.address3,
75: loc.address4, loc.city, loc.state,

Line 92: arp_util.debug('getting the default remit to address from the cache');

88: AND rt.status = 'A'
89: AND NVL( acct_site.status, 'A' ) = 'A';
90:
91: ELSE
92: arp_util.debug('getting the default remit to address from the cache');
93:
94: END IF;
95:
96: p_remit_to_address_id := pg_remit_to_address_rec.cust_acct_site_id;

Line 99: arp_util.debug(' ');

95:
96: p_remit_to_address_id := pg_remit_to_address_rec.cust_acct_site_id;
97: p_remit_to_address_rec := pg_remit_to_address_rec;
98:
99: arp_util.debug(' ');
100: arp_util.debug('The default remit to address is:');
101: arp_util.debug('ID: = ' || pg_remit_to_address_rec.cust_acct_site_id);
102: arp_util.debug('address1: = ' || pg_remit_to_address_rec.address1);
103: arp_util.debug('address2: = ' || pg_remit_to_address_rec.address2);

Line 100: arp_util.debug('The default remit to address is:');

96: p_remit_to_address_id := pg_remit_to_address_rec.cust_acct_site_id;
97: p_remit_to_address_rec := pg_remit_to_address_rec;
98:
99: arp_util.debug(' ');
100: arp_util.debug('The default remit to address is:');
101: arp_util.debug('ID: = ' || pg_remit_to_address_rec.cust_acct_site_id);
102: arp_util.debug('address1: = ' || pg_remit_to_address_rec.address1);
103: arp_util.debug('address2: = ' || pg_remit_to_address_rec.address2);
104: arp_util.debug('address3: = ' || pg_remit_to_address_rec.address3);

Line 101: arp_util.debug('ID: = ' || pg_remit_to_address_rec.cust_acct_site_id);

97: p_remit_to_address_rec := pg_remit_to_address_rec;
98:
99: arp_util.debug(' ');
100: arp_util.debug('The default remit to address is:');
101: arp_util.debug('ID: = ' || pg_remit_to_address_rec.cust_acct_site_id);
102: arp_util.debug('address1: = ' || pg_remit_to_address_rec.address1);
103: arp_util.debug('address2: = ' || pg_remit_to_address_rec.address2);
104: arp_util.debug('address3: = ' || pg_remit_to_address_rec.address3);
105: arp_util.debug('address4: = ' || pg_remit_to_address_rec.address4);

Line 102: arp_util.debug('address1: = ' || pg_remit_to_address_rec.address1);

98:
99: arp_util.debug(' ');
100: arp_util.debug('The default remit to address is:');
101: arp_util.debug('ID: = ' || pg_remit_to_address_rec.cust_acct_site_id);
102: arp_util.debug('address1: = ' || pg_remit_to_address_rec.address1);
103: arp_util.debug('address2: = ' || pg_remit_to_address_rec.address2);
104: arp_util.debug('address3: = ' || pg_remit_to_address_rec.address3);
105: arp_util.debug('address4: = ' || pg_remit_to_address_rec.address4);
106: arp_util.debug('city : = ' || pg_remit_to_address_rec.city);

Line 103: arp_util.debug('address2: = ' || pg_remit_to_address_rec.address2);

99: arp_util.debug(' ');
100: arp_util.debug('The default remit to address is:');
101: arp_util.debug('ID: = ' || pg_remit_to_address_rec.cust_acct_site_id);
102: arp_util.debug('address1: = ' || pg_remit_to_address_rec.address1);
103: arp_util.debug('address2: = ' || pg_remit_to_address_rec.address2);
104: arp_util.debug('address3: = ' || pg_remit_to_address_rec.address3);
105: arp_util.debug('address4: = ' || pg_remit_to_address_rec.address4);
106: arp_util.debug('city : = ' || pg_remit_to_address_rec.city);
107: arp_util.debug('state : = ' || pg_remit_to_address_rec.state);

Line 104: arp_util.debug('address3: = ' || pg_remit_to_address_rec.address3);

100: arp_util.debug('The default remit to address is:');
101: arp_util.debug('ID: = ' || pg_remit_to_address_rec.cust_acct_site_id);
102: arp_util.debug('address1: = ' || pg_remit_to_address_rec.address1);
103: arp_util.debug('address2: = ' || pg_remit_to_address_rec.address2);
104: arp_util.debug('address3: = ' || pg_remit_to_address_rec.address3);
105: arp_util.debug('address4: = ' || pg_remit_to_address_rec.address4);
106: arp_util.debug('city : = ' || pg_remit_to_address_rec.city);
107: arp_util.debug('state : = ' || pg_remit_to_address_rec.state);
108: arp_util.debug('provence: = ' || pg_remit_to_address_rec.province);

Line 105: arp_util.debug('address4: = ' || pg_remit_to_address_rec.address4);

101: arp_util.debug('ID: = ' || pg_remit_to_address_rec.cust_acct_site_id);
102: arp_util.debug('address1: = ' || pg_remit_to_address_rec.address1);
103: arp_util.debug('address2: = ' || pg_remit_to_address_rec.address2);
104: arp_util.debug('address3: = ' || pg_remit_to_address_rec.address3);
105: arp_util.debug('address4: = ' || pg_remit_to_address_rec.address4);
106: arp_util.debug('city : = ' || pg_remit_to_address_rec.city);
107: arp_util.debug('state : = ' || pg_remit_to_address_rec.state);
108: arp_util.debug('provence: = ' || pg_remit_to_address_rec.province);
109: arp_util.debug('postal code: = ' || pg_remit_to_address_rec.postal_code);

Line 106: arp_util.debug('city : = ' || pg_remit_to_address_rec.city);

102: arp_util.debug('address1: = ' || pg_remit_to_address_rec.address1);
103: arp_util.debug('address2: = ' || pg_remit_to_address_rec.address2);
104: arp_util.debug('address3: = ' || pg_remit_to_address_rec.address3);
105: arp_util.debug('address4: = ' || pg_remit_to_address_rec.address4);
106: arp_util.debug('city : = ' || pg_remit_to_address_rec.city);
107: arp_util.debug('state : = ' || pg_remit_to_address_rec.state);
108: arp_util.debug('provence: = ' || pg_remit_to_address_rec.province);
109: arp_util.debug('postal code: = ' || pg_remit_to_address_rec.postal_code);
110: arp_util.debug('country: = ' || pg_remit_to_address_rec.country);

Line 107: arp_util.debug('state : = ' || pg_remit_to_address_rec.state);

103: arp_util.debug('address2: = ' || pg_remit_to_address_rec.address2);
104: arp_util.debug('address3: = ' || pg_remit_to_address_rec.address3);
105: arp_util.debug('address4: = ' || pg_remit_to_address_rec.address4);
106: arp_util.debug('city : = ' || pg_remit_to_address_rec.city);
107: arp_util.debug('state : = ' || pg_remit_to_address_rec.state);
108: arp_util.debug('provence: = ' || pg_remit_to_address_rec.province);
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(' ');

Line 108: arp_util.debug('provence: = ' || pg_remit_to_address_rec.province);

104: arp_util.debug('address3: = ' || pg_remit_to_address_rec.address3);
105: arp_util.debug('address4: = ' || pg_remit_to_address_rec.address4);
106: arp_util.debug('city : = ' || pg_remit_to_address_rec.city);
107: arp_util.debug('state : = ' || pg_remit_to_address_rec.state);
108: arp_util.debug('provence: = ' || pg_remit_to_address_rec.province);
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:

Line 109: arp_util.debug('postal code: = ' || pg_remit_to_address_rec.postal_code);

105: arp_util.debug('address4: = ' || pg_remit_to_address_rec.address4);
106: arp_util.debug('city : = ' || pg_remit_to_address_rec.city);
107: arp_util.debug('state : = ' || pg_remit_to_address_rec.state);
108: arp_util.debug('provence: = ' || pg_remit_to_address_rec.province);
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()-');

Line 110: arp_util.debug('country: = ' || pg_remit_to_address_rec.country);

106: arp_util.debug('city : = ' || pg_remit_to_address_rec.city);
107: arp_util.debug('state : = ' || pg_remit_to_address_rec.state);
108: arp_util.debug('provence: = ' || pg_remit_to_address_rec.province);
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:

Line 111: arp_util.debug(' ');

107: arp_util.debug('state : = ' || pg_remit_to_address_rec.state);
108: arp_util.debug('provence: = ' || pg_remit_to_address_rec.province);
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

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 132: | arp_util.debug |

128: | |
129: | SCOPE - PUBLIC |
130: | |
131: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
132: | arp_util.debug |
133: | |
134: | ARGUMENTS : IN: |
135: | p_match_state |
136: | p_match_country |

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 293: arp_util.debug('getting address Info. based on address_id');

289:
290: IF ( p_match_address_id IS NOT NULL )
291: THEN
292:
293: arp_util.debug('getting address Info. based on address_id');
294:
295: SELECT loc.state,
296: loc.country,
297: loc.postal_code

Line 320: arp_util.debug('getting address Info. based on site_use_id');

316: IF ( p_match_site_use_id IS NOT NULL AND
317: p_match_address_id IS NULL )
318: THEN
319:
320: arp_util.debug('getting address Info. based on site_use_id');
321:
322: SELECT loc.state,
323: loc.country,
324: loc.postal_code

Line 340: arp_util.debug('getting address Info. based on match values');

336:
337: END IF;
338:
339: ELSE -- match columns were specified case
340: arp_util.debug('getting address Info. based on match values');
341:
342: l_match_state := p_match_state;
343: l_match_country := p_match_country;
344: l_match_postal_code := p_match_postal_code;

Line 352: arp_util.debug('selecting remit to information');

348: /*---------------------------------------------------------------+
349: | Select the remit to information based on the match criteria |
350: +---------------------------------------------------------------*/
351:
352: arp_util.debug('selecting remit to information');
353:
354: OPEN remit_to;
355:
356: FETCH remit_to

Line 386: arp_util.debug(' ');

382:
383:
384: CLOSE remit_to;
385:
386: arp_util.debug(' ');
387: arp_util.debug('The remit to address is:');
388: arp_util.debug('ID: = ' || l_remit_to_address_rec.cust_acct_site_id);
389: arp_util.debug('address1: = ' || l_remit_to_address_rec.address1);
390: arp_util.debug('address2: = ' || l_remit_to_address_rec.address2);

Line 387: arp_util.debug('The remit to address is:');

383:
384: CLOSE remit_to;
385:
386: arp_util.debug(' ');
387: arp_util.debug('The remit to address is:');
388: arp_util.debug('ID: = ' || l_remit_to_address_rec.cust_acct_site_id);
389: arp_util.debug('address1: = ' || l_remit_to_address_rec.address1);
390: arp_util.debug('address2: = ' || l_remit_to_address_rec.address2);
391: arp_util.debug('address3: = ' || l_remit_to_address_rec.address3);

Line 388: arp_util.debug('ID: = ' || l_remit_to_address_rec.cust_acct_site_id);

384: CLOSE remit_to;
385:
386: arp_util.debug(' ');
387: arp_util.debug('The remit to address is:');
388: arp_util.debug('ID: = ' || l_remit_to_address_rec.cust_acct_site_id);
389: arp_util.debug('address1: = ' || l_remit_to_address_rec.address1);
390: arp_util.debug('address2: = ' || l_remit_to_address_rec.address2);
391: arp_util.debug('address3: = ' || l_remit_to_address_rec.address3);
392: arp_util.debug('address4: = ' || l_remit_to_address_rec.address4);

Line 389: arp_util.debug('address1: = ' || l_remit_to_address_rec.address1);

385:
386: arp_util.debug(' ');
387: arp_util.debug('The remit to address is:');
388: arp_util.debug('ID: = ' || l_remit_to_address_rec.cust_acct_site_id);
389: arp_util.debug('address1: = ' || l_remit_to_address_rec.address1);
390: arp_util.debug('address2: = ' || l_remit_to_address_rec.address2);
391: arp_util.debug('address3: = ' || l_remit_to_address_rec.address3);
392: arp_util.debug('address4: = ' || l_remit_to_address_rec.address4);
393: arp_util.debug('city : = ' || l_remit_to_address_rec.city);

Line 390: arp_util.debug('address2: = ' || l_remit_to_address_rec.address2);

386: arp_util.debug(' ');
387: arp_util.debug('The remit to address is:');
388: arp_util.debug('ID: = ' || l_remit_to_address_rec.cust_acct_site_id);
389: arp_util.debug('address1: = ' || l_remit_to_address_rec.address1);
390: arp_util.debug('address2: = ' || l_remit_to_address_rec.address2);
391: arp_util.debug('address3: = ' || l_remit_to_address_rec.address3);
392: arp_util.debug('address4: = ' || l_remit_to_address_rec.address4);
393: arp_util.debug('city : = ' || l_remit_to_address_rec.city);
394: arp_util.debug('state : = ' || l_remit_to_address_rec.state);

Line 391: arp_util.debug('address3: = ' || l_remit_to_address_rec.address3);

387: arp_util.debug('The remit to address is:');
388: arp_util.debug('ID: = ' || l_remit_to_address_rec.cust_acct_site_id);
389: arp_util.debug('address1: = ' || l_remit_to_address_rec.address1);
390: arp_util.debug('address2: = ' || l_remit_to_address_rec.address2);
391: arp_util.debug('address3: = ' || l_remit_to_address_rec.address3);
392: arp_util.debug('address4: = ' || l_remit_to_address_rec.address4);
393: arp_util.debug('city : = ' || l_remit_to_address_rec.city);
394: arp_util.debug('state : = ' || l_remit_to_address_rec.state);
395: arp_util.debug('provence: = ' || l_remit_to_address_rec.province);

Line 392: arp_util.debug('address4: = ' || l_remit_to_address_rec.address4);

388: arp_util.debug('ID: = ' || l_remit_to_address_rec.cust_acct_site_id);
389: arp_util.debug('address1: = ' || l_remit_to_address_rec.address1);
390: arp_util.debug('address2: = ' || l_remit_to_address_rec.address2);
391: arp_util.debug('address3: = ' || l_remit_to_address_rec.address3);
392: arp_util.debug('address4: = ' || l_remit_to_address_rec.address4);
393: arp_util.debug('city : = ' || l_remit_to_address_rec.city);
394: arp_util.debug('state : = ' || l_remit_to_address_rec.state);
395: arp_util.debug('provence: = ' || l_remit_to_address_rec.province);
396: arp_util.debug('postal code: = ' || l_remit_to_address_rec.postal_code);

Line 393: arp_util.debug('city : = ' || l_remit_to_address_rec.city);

389: arp_util.debug('address1: = ' || l_remit_to_address_rec.address1);
390: arp_util.debug('address2: = ' || l_remit_to_address_rec.address2);
391: arp_util.debug('address3: = ' || l_remit_to_address_rec.address3);
392: arp_util.debug('address4: = ' || l_remit_to_address_rec.address4);
393: arp_util.debug('city : = ' || l_remit_to_address_rec.city);
394: arp_util.debug('state : = ' || l_remit_to_address_rec.state);
395: arp_util.debug('provence: = ' || l_remit_to_address_rec.province);
396: arp_util.debug('postal code: = ' || l_remit_to_address_rec.postal_code);
397: arp_util.debug('country: = ' || l_remit_to_address_rec.country);

Line 394: arp_util.debug('state : = ' || l_remit_to_address_rec.state);

390: arp_util.debug('address2: = ' || l_remit_to_address_rec.address2);
391: arp_util.debug('address3: = ' || l_remit_to_address_rec.address3);
392: arp_util.debug('address4: = ' || l_remit_to_address_rec.address4);
393: arp_util.debug('city : = ' || l_remit_to_address_rec.city);
394: arp_util.debug('state : = ' || l_remit_to_address_rec.state);
395: arp_util.debug('provence: = ' || l_remit_to_address_rec.province);
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(' ');

Line 395: arp_util.debug('provence: = ' || l_remit_to_address_rec.province);

391: arp_util.debug('address3: = ' || l_remit_to_address_rec.address3);
392: arp_util.debug('address4: = ' || l_remit_to_address_rec.address4);
393: arp_util.debug('city : = ' || l_remit_to_address_rec.city);
394: arp_util.debug('state : = ' || l_remit_to_address_rec.state);
395: arp_util.debug('provence: = ' || l_remit_to_address_rec.province);
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:

Line 396: arp_util.debug('postal code: = ' || l_remit_to_address_rec.postal_code);

392: arp_util.debug('address4: = ' || l_remit_to_address_rec.address4);
393: arp_util.debug('city : = ' || l_remit_to_address_rec.city);
394: arp_util.debug('state : = ' || l_remit_to_address_rec.state);
395: arp_util.debug('provence: = ' || l_remit_to_address_rec.province);
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()-');

Line 397: arp_util.debug('country: = ' || l_remit_to_address_rec.country);

393: arp_util.debug('city : = ' || l_remit_to_address_rec.city);
394: arp_util.debug('state : = ' || l_remit_to_address_rec.state);
395: arp_util.debug('provence: = ' || l_remit_to_address_rec.province);
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:

Line 398: arp_util.debug(' ');

394: arp_util.debug('state : = ' || l_remit_to_address_rec.state);
395: arp_util.debug('provence: = ' || l_remit_to_address_rec.province);
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

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 406: arp_util.debug('---------- ' ||

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: '---------- ');
409:
410: arp_util.debug('p_match_state : ' || p_match_state );

Line 410: arp_util.debug('p_match_state : ' || p_match_state );

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 );
412: arp_util.debug('p_match_postal_code : ' || p_match_postal_code );
413: arp_util.debug('p_match_address_id : ' || p_match_address_id );
414: arp_util.debug('p_match_site_use_id : ' || p_match_site_use_id );

Line 411: arp_util.debug('p_match_country : ' || p_match_country );

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 );
412: arp_util.debug('p_match_postal_code : ' || p_match_postal_code );
413: arp_util.debug('p_match_address_id : ' || p_match_address_id );
414: arp_util.debug('p_match_site_use_id : ' || p_match_site_use_id );
415:

Line 412: arp_util.debug('p_match_postal_code : ' || p_match_postal_code );

408: '---------- ');
409:
410: arp_util.debug('p_match_state : ' || p_match_state );
411: arp_util.debug('p_match_country : ' || p_match_country );
412: arp_util.debug('p_match_postal_code : ' || p_match_postal_code );
413: arp_util.debug('p_match_address_id : ' || p_match_address_id );
414: arp_util.debug('p_match_site_use_id : ' || p_match_site_use_id );
415:
416:

Line 413: arp_util.debug('p_match_address_id : ' || p_match_address_id );

409:
410: arp_util.debug('p_match_state : ' || p_match_state );
411: arp_util.debug('p_match_country : ' || p_match_country );
412: arp_util.debug('p_match_postal_code : ' || p_match_postal_code );
413: arp_util.debug('p_match_address_id : ' || p_match_address_id );
414: arp_util.debug('p_match_site_use_id : ' || p_match_site_use_id );
415:
416:
417: /*-----------------------------------------------------------+

Line 414: arp_util.debug('p_match_site_use_id : ' || p_match_site_use_id );

410: arp_util.debug('p_match_state : ' || p_match_state );
411: arp_util.debug('p_match_country : ' || p_match_country );
412: arp_util.debug('p_match_postal_code : ' || p_match_postal_code );
413: arp_util.debug('p_match_address_id : ' || p_match_address_id );
414: arp_util.debug('p_match_site_use_id : ' || p_match_site_use_id );
415:
416:
417: /*-----------------------------------------------------------+
418: | Close the cursor, but don't raise an error if the close |

Line 442: | arp_util.debug |

438: | |
439: | SCOPE - PUBLIC |
440: | |
441: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
442: | arp_util.debug |
443: | |
444: | ARGUMENTS : IN: |
445: | p_trx_date |
446: | p_customer_id |

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 624: arp_util.debug('check_payment_method: ' || 'return value: FALSE');

620: FETCH payment_method_cur INTO payment_method_rec;
621:
622: IF payment_method_cur%NOTFOUND THEN
623: IF PG_DEBUG in ('Y', 'C') THEN
624: arp_util.debug('check_payment_method: ' || 'return value: FALSE');
625: END IF;
626: CLOSE payment_method_cur;
627: RETURN(FALSE);
628: END IF;

Line 641: arp_util.debug('check_payment_method: ' || 'p_payment_method_name = ' || l_payment_method_name );

637: p_creation_method_code := payment_method_rec.creation_method_code;
638: pg_payment_type_code := payment_method_rec.payment_channel_code; --ajay bug 1081390
639:
640: IF PG_DEBUG in ('Y', 'C') THEN
641: arp_util.debug('check_payment_method: ' || 'p_payment_method_name = ' || l_payment_method_name );
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');

Line 642: arp_util.debug('check_payment_method: ' || 'p_receipt_method_id = ' ||

638: pg_payment_type_code := payment_method_rec.payment_channel_code; --ajay bug 1081390
639:
640: IF PG_DEBUG in ('Y', 'C') THEN
641: arp_util.debug('check_payment_method: ' || 'p_payment_method_name = ' || l_payment_method_name );
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()-');

Line 644: arp_util.debug('check_payment_method: ' || 'p_creation_method_code = ' || l_creation_method_code );

640: IF PG_DEBUG in ('Y', 'C') THEN
641: arp_util.debug('check_payment_method: ' || 'p_payment_method_name = ' || l_payment_method_name );
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:

Line 645: arp_util.debug('check_payment_method: ' || 'return value = TRUE');

641: arp_util.debug('check_payment_method: ' || 'p_payment_method_name = ' || l_payment_method_name );
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:

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 656: arp_util.debug('check_payment_method: ' ||

652: EXCEPTION
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) );

Line 658: arp_util.debug('------- parameters for check_payment_method ----');

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) );
662: arp_util.debug('check_payment_method: ' || 'p_currency_code = ' || p_currency_code );

Line 659: arp_util.debug('check_payment_method: ' || 'p_trx_date = ' || TO_CHAR(p_trx_date) );

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) );
662: arp_util.debug('check_payment_method: ' || 'p_currency_code = ' || p_currency_code );
663: END IF;

Line 660: arp_util.debug('check_payment_method: ' || 'p_customer_id = ' || TO_CHAR(p_customer_id) );

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) );
662: arp_util.debug('check_payment_method: ' || 'p_currency_code = ' || p_currency_code );
663: END IF;
664:

Line 661: arp_util.debug('check_payment_method: ' || 'p_site_use_id = ' || TO_CHAR(p_site_use_id) );

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) );
662: arp_util.debug('check_payment_method: ' || 'p_currency_code = ' || p_currency_code );
663: END IF;
664:
665: RAISE;

Line 662: arp_util.debug('check_payment_method: ' || 'p_currency_code = ' || p_currency_code );

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) );
662: arp_util.debug('check_payment_method: ' || 'p_currency_code = ' || p_currency_code );
663: END IF;
664:
665: RAISE;
666:

Line 680: | arp_util.debug |

676: | |
677: | SCOPE - PRIVATE |
678: | |
679: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
680: | arp_util.debug |
681: | |
682: | ARGUMENTS : IN: |
683: | p_trx_date |
684: | p_customer_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 758: | arp_util.debug |

754: | |
755: | SCOPE - PUBLIC |
756: | |
757: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
758: | arp_util.debug |
759: | |
760: | ARGUMENTS : IN: |
761: | p_trx_date |
762: | p_currency_code |

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 826: arp_util.debug('Invalid parameters for get_payment_method_default()');

822: p_bill_to_site_use_id IS NULL
823: )
824: THEN
825: IF PG_DEBUG in ('Y', 'C') THEN
826: arp_util.debug('Invalid parameters for get_payment_method_default()');
827: END IF;
828: RETURN;
829: END IF;
830:

Line 854: arp_util.debug('get_payment_method_default: ' ||

850: p_creation_method_code
851: ) = TRUE )
852: THEN
853: IF PG_DEBUG in ('Y', 'C') THEN
854: arp_util.debug('get_payment_method_default: ' ||
855: 'Defaulting payment method from: Paying Customer Site');
856: END IF;
857: RETURN;
858: END IF;

Line 874: arp_util.debug('get_payment_method_default: ' || 'Defaulting payment method from: Paying Customer');

870: ) = TRUE )
871: THEN
872:
873: IF PG_DEBUG in ('Y', 'C') THEN
874: arp_util.debug('get_payment_method_default: ' || 'Defaulting payment method from: Paying Customer');
875: END IF;
876: RETURN;
877: END IF;
878:

Line 900: arp_util.debug('get_payment_method_default: ' ||

896: p_creation_method_code
897: ) = TRUE )
898: THEN
899: IF PG_DEBUG in ('Y', 'C') THEN
900: arp_util.debug('get_payment_method_default: ' ||
901: 'Defaulting payment method from: Bill To Customer Site');
902: END IF;
903:
904: RETURN;

Line 921: arp_util.debug('get_payment_method_default: ' || 'Defaulting payment method from: Bill To Customer');

917: p_creation_method_code
918: ) = TRUE )
919: THEN
920: IF PG_DEBUG in ('Y', 'C') THEN
921: arp_util.debug('get_payment_method_default: ' || 'Defaulting payment method from: Bill To Customer');
922: END IF;
923: RETURN;
924: END IF;
925: END IF;

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 936: arp_util.debug('get_payment_method_default: ' ||

932: EXCEPTION
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) );

Line 938: arp_util.debug('get_payment_method_default: ' ||

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 );
942: arp_util.debug('get_payment_method_default: ' || 'p_paying_customer_id = ' || p_paying_customer_id );

Line 940: arp_util.debug('get_payment_method_default: ' || 'p_trx_date = ' || TO_CHAR(p_trx_date) );

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 );
942: arp_util.debug('get_payment_method_default: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
943: arp_util.debug('get_payment_method_default: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
944: arp_util.debug('get_payment_method_default: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );

Line 941: arp_util.debug('get_payment_method_default: ' || 'p_currency_code = ' || p_currency_code );

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 );
942: arp_util.debug('get_payment_method_default: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
943: arp_util.debug('get_payment_method_default: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
944: arp_util.debug('get_payment_method_default: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
945: arp_util.debug('get_payment_method_default: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );

Line 942: arp_util.debug('get_payment_method_default: ' || 'p_paying_customer_id = ' || p_paying_customer_id );

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 );
942: arp_util.debug('get_payment_method_default: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
943: arp_util.debug('get_payment_method_default: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
944: arp_util.debug('get_payment_method_default: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
945: arp_util.debug('get_payment_method_default: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );
946: END IF;

Line 943: arp_util.debug('get_payment_method_default: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );

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 );
942: arp_util.debug('get_payment_method_default: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
943: arp_util.debug('get_payment_method_default: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
944: arp_util.debug('get_payment_method_default: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
945: arp_util.debug('get_payment_method_default: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );
946: END IF;
947:

Line 944: arp_util.debug('get_payment_method_default: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );

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 );
942: arp_util.debug('get_payment_method_default: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
943: arp_util.debug('get_payment_method_default: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
944: arp_util.debug('get_payment_method_default: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
945: arp_util.debug('get_payment_method_default: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );
946: END IF;
947:
948: RAISE;

Line 945: arp_util.debug('get_payment_method_default: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );

941: arp_util.debug('get_payment_method_default: ' || 'p_currency_code = ' || p_currency_code );
942: arp_util.debug('get_payment_method_default: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
943: arp_util.debug('get_payment_method_default: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
944: arp_util.debug('get_payment_method_default: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
945: arp_util.debug('get_payment_method_default: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );
946: END IF;
947:
948: RAISE;
949:

Line 963: | arp_util.debug |

959: | |
960: | SCOPE - PUBLIC |
961: | |
962: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
963: | arp_util.debug |
964: | |
965: | ARGUMENTS : IN: |
966: | p_trx_date |
967: | 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 1040: arp_util.debug('Invalid parameters for get_bank_defaults()');

1036: p_bill_to_site_use_id IS NULL
1037: )
1038: THEN
1039: IF PG_DEBUG in ('Y', 'C') THEN
1040: arp_util.debug('Invalid parameters for get_bank_defaults()');
1041: END IF;
1042: RETURN;
1043: END IF;
1044:

Line 1051: arp_util.debug('get_bank_defaults: ' || 'Defaulting parameters for Credit Card Type ');

1047: from ce_bank_branches_v.. */
1048:
1049: IF ( NVL(p_payment_type_code,'-1') = 'CREDIT_CARD' ) THEN
1050: IF PG_DEBUG in ('Y', 'C') THEN
1051: arp_util.debug('get_bank_defaults: ' || 'Defaulting parameters for Credit Card Type ');
1052: END IF;
1053:
1054: SELECT abb.bank_name,
1055: abb.bank_branch_name,

Line 1095: arp_util.debug('get_bank_defaults: ' ||

1091: p_bank_branch_id
1092: ) = TRUE )
1093: THEN
1094: IF PG_DEBUG in ('Y', 'C') THEN
1095: arp_util.debug('get_bank_defaults: ' ||
1096: 'Defaulting bank from: Paying Customer Site');
1097: END IF;
1098: RETURN;
1099: END IF;

Line 1116: arp_util.debug('get_bank_defaults: ' || 'Defaulting bank from: Paying Customer');

1112: ) = TRUE )
1113: THEN
1114:
1115: IF PG_DEBUG in ('Y', 'C') THEN
1116: arp_util.debug('get_bank_defaults: ' || 'Defaulting bank from: Paying Customer');
1117: END IF;
1118: RETURN;
1119: END IF;
1120:

Line 1143: arp_util.debug('get_bank_defaults: ' ||

1139: p_bank_branch_id
1140: ) = TRUE )
1141: THEN
1142: IF PG_DEBUG in ('Y', 'C') THEN
1143: arp_util.debug('get_bank_defaults: ' ||
1144: 'Defaulting bank from: Bill To Customer Site');
1145: END IF;
1146:
1147: RETURN;

Line 1166: arp_util.debug('get_bank_defaults: ' || 'Defaulting bank from: Bill To Customer');

1162: p_bank_branch_id
1163: ) = TRUE )
1164: THEN
1165: IF PG_DEBUG in ('Y', 'C') THEN
1166: arp_util.debug('get_bank_defaults: ' || 'Defaulting bank from: Bill To Customer');
1167: END IF;
1168: RETURN;
1169: END IF;
1170: END IF;

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 1181: arp_util.debug('get_bank_defaults: ' ||

1177: EXCEPTION
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) );

Line 1183: arp_util.debug('get_bank_defaults: ' ||

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 );
1187: arp_util.debug('get_bank_defaults: ' || 'p_paying_customer_id = ' || p_paying_customer_id );

Line 1185: arp_util.debug('get_bank_defaults: ' || 'p_trx_date = ' || TO_CHAR(p_trx_date) );

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 );
1187: arp_util.debug('get_bank_defaults: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
1188: arp_util.debug('get_bank_defaults: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
1189: arp_util.debug('get_bank_defaults: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );

Line 1186: arp_util.debug('get_bank_defaults: ' || 'p_currency_code = ' || p_currency_code );

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 );
1187: arp_util.debug('get_bank_defaults: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
1188: arp_util.debug('get_bank_defaults: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
1189: arp_util.debug('get_bank_defaults: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
1190: arp_util.debug('get_bank_defaults: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );

Line 1187: arp_util.debug('get_bank_defaults: ' || 'p_paying_customer_id = ' || p_paying_customer_id );

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 );
1187: arp_util.debug('get_bank_defaults: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
1188: arp_util.debug('get_bank_defaults: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
1189: arp_util.debug('get_bank_defaults: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
1190: arp_util.debug('get_bank_defaults: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );
1191: END IF;

Line 1188: arp_util.debug('get_bank_defaults: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );

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 );
1187: arp_util.debug('get_bank_defaults: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
1188: arp_util.debug('get_bank_defaults: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
1189: arp_util.debug('get_bank_defaults: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
1190: arp_util.debug('get_bank_defaults: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );
1191: END IF;
1192:

Line 1189: arp_util.debug('get_bank_defaults: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );

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 );
1187: arp_util.debug('get_bank_defaults: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
1188: arp_util.debug('get_bank_defaults: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
1189: arp_util.debug('get_bank_defaults: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
1190: arp_util.debug('get_bank_defaults: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );
1191: END IF;
1192:
1193: RAISE;

Line 1190: arp_util.debug('get_bank_defaults: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );

1186: arp_util.debug('get_bank_defaults: ' || 'p_currency_code = ' || p_currency_code );
1187: arp_util.debug('get_bank_defaults: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
1188: arp_util.debug('get_bank_defaults: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
1189: arp_util.debug('get_bank_defaults: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
1190: arp_util.debug('get_bank_defaults: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );
1191: END IF;
1192:
1193: RAISE;
1194:

Line 1208: | arp_util.debug |

1204: | |
1205: | SCOPE - PUBLIC |
1206: | |
1207: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1208: | arp_util.debug |
1209: | |
1210: | ARGUMENTS : IN: |
1211: | p_trx_date |
1212: | 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 1276: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'calling get_payment_method_default()');

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,
1280: p_currency_code,

Line 1300: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'calling get_bank_defaults()');

1296: p_bank_branch_id := NULL;
1297: ELSE
1298:
1299: IF PG_DEBUG in ('Y', 'C') THEN
1300: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'calling get_bank_defaults()');
1301: END IF;
1302: get_bank_defaults(
1303: p_trx_date,
1304: p_currency_code,

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 1326: arp_util.debug('get_pay_method_and_bank_deflts: ' ||

1322: EXCEPTION
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) );

Line 1328: arp_util.debug('get_pay_method_and_bank_deflts: ' ||

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 );
1332: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_customer_id = ' || p_paying_customer_id );

Line 1330: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_trx_date = ' || TO_CHAR(p_trx_date) );

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 );
1332: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
1333: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
1334: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );

Line 1331: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_currency_code = ' || p_currency_code );

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 );
1332: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
1333: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
1334: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
1335: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );

Line 1332: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_customer_id = ' || p_paying_customer_id );

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 );
1332: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
1333: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
1334: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
1335: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );
1336: END IF;

Line 1333: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );

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 );
1332: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
1333: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
1334: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
1335: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );
1336: END IF;
1337:

Line 1334: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );

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 );
1332: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
1333: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
1334: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
1335: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );
1336: END IF;
1337:
1338: RAISE;

Line 1335: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );

1331: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_currency_code = ' || p_currency_code );
1332: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_customer_id = ' || p_paying_customer_id );
1333: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_paying_site_use_id = ' || p_paying_site_use_id );
1334: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_bill_to_customer_id = ' || p_bill_to_customer_id );
1335: arp_util.debug('get_pay_method_and_bank_deflts: ' || 'p_bill_to_site_use_id = ' || p_bill_to_site_use_id );
1336: END IF;
1337:
1338: RAISE;
1339:

Line 1353: | arp_util.debug |

1349: | |
1350: | SCOPE - PUBLIC |
1351: | |
1352: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1353: | arp_util.debug |
1354: | |
1355: | ARGUMENTS : IN: |
1356: | p_state |
1357: | p_postal_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 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 1457: arp_util.debug('------- parameters for get_remit_to_default ----');

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);
1461: END IF;

Line 1458: arp_util.debug('get_remit_to_default: ' || 'p_state = ' || p_state);

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);
1461: END IF;
1462:

Line 1459: arp_util.debug('get_remit_to_default: ' || 'p_postal_code = ' || p_postal_code);

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);
1461: END IF;
1462:
1463: RAISE;

Line 1460: arp_util.debug('get_remit_to_default: ' || 'p_countrye = ' || p_country);

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);
1461: END IF;
1462:
1463: RAISE;
1464:

Line 1482: | arp_util.debug |

1478: | |
1479: | SCOPE - PRIVATE |
1480: | |
1481: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1482: | arp_util.debug |
1483: | |
1484: | ARGUMENTS : IN: |
1485: | p_term_id |
1486: | p_type_term_id |

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 1774: | arp_util.debug |

1770: | |
1771: | SCOPE - PUBLIC |
1772: | |
1773: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1774: | arp_util.debug |
1775: | |
1776: | ARGUMENTS : IN: |
1777: | p_customer_id |
1778: | p_site_use_id |

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 1851: arp_util.debug('p_customer_id = ' ||

1847: p_override_terms := l_override_terms;
1848: p_commitments_exist_flag := l_commitments_exist_flag;
1849: p_agreements_exist_flag := l_agreements_exist_flag;
1850:
1851: arp_util.debug('p_customer_id = ' ||
1852: TO_CHAR(p_customer_id));
1853: arp_util.debug('p_site_use_id = ' ||
1854: TO_CHAR(p_site_use_id));
1855: arp_util.debug('p_invoice_currency_code = ' ||

Line 1853: arp_util.debug('p_site_use_id = ' ||

1849: p_agreements_exist_flag := l_agreements_exist_flag;
1850:
1851: arp_util.debug('p_customer_id = ' ||
1852: TO_CHAR(p_customer_id));
1853: arp_util.debug('p_site_use_id = ' ||
1854: TO_CHAR(p_site_use_id));
1855: arp_util.debug('p_invoice_currency_code = ' ||
1856: p_invoice_currency_code);
1857: arp_util.debug('p_previous_customer_trx_id = ' ||

Line 1855: arp_util.debug('p_invoice_currency_code = ' ||

1851: arp_util.debug('p_customer_id = ' ||
1852: TO_CHAR(p_customer_id));
1853: arp_util.debug('p_site_use_id = ' ||
1854: TO_CHAR(p_site_use_id));
1855: arp_util.debug('p_invoice_currency_code = ' ||
1856: p_invoice_currency_code);
1857: arp_util.debug('p_previous_customer_trx_id = ' ||
1858: TO_CHAR(p_previous_customer_trx_id));
1859: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||

Line 1857: arp_util.debug('p_previous_customer_trx_id = ' ||

1853: arp_util.debug('p_site_use_id = ' ||
1854: TO_CHAR(p_site_use_id));
1855: arp_util.debug('p_invoice_currency_code = ' ||
1856: p_invoice_currency_code);
1857: arp_util.debug('p_previous_customer_trx_id = ' ||
1858: TO_CHAR(p_previous_customer_trx_id));
1859: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||
1860: TO_CHAR(p_ct_prev_initial_cust_trx_id));
1861: arp_util.debug('p_trx_date = ' ||

Line 1859: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||

1855: arp_util.debug('p_invoice_currency_code = ' ||
1856: p_invoice_currency_code);
1857: arp_util.debug('p_previous_customer_trx_id = ' ||
1858: TO_CHAR(p_previous_customer_trx_id));
1859: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||
1860: TO_CHAR(p_ct_prev_initial_cust_trx_id));
1861: arp_util.debug('p_trx_date = ' ||
1862: TO_CHAR(p_trx_date));
1863: arp_util.debug('p_code_combination_id_gain = ' ||

Line 1861: arp_util.debug('p_trx_date = ' ||

1857: arp_util.debug('p_previous_customer_trx_id = ' ||
1858: TO_CHAR(p_previous_customer_trx_id));
1859: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||
1860: TO_CHAR(p_ct_prev_initial_cust_trx_id));
1861: arp_util.debug('p_trx_date = ' ||
1862: TO_CHAR(p_trx_date));
1863: arp_util.debug('p_code_combination_id_gain = ' ||
1864: TO_CHAR(p_code_combination_id_gain));
1865:

Line 1863: arp_util.debug('p_code_combination_id_gain = ' ||

1859: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||
1860: TO_CHAR(p_ct_prev_initial_cust_trx_id));
1861: arp_util.debug('p_trx_date = ' ||
1862: TO_CHAR(p_trx_date));
1863: arp_util.debug('p_code_combination_id_gain = ' ||
1864: TO_CHAR(p_code_combination_id_gain));
1865:
1866: arp_util.debug('p_override_terms = ' || l_override_terms);
1867: arp_util.debug('p_commitments_exist_flag = ' ||

Line 1866: arp_util.debug('p_override_terms = ' || l_override_terms);

1862: TO_CHAR(p_trx_date));
1863: arp_util.debug('p_code_combination_id_gain = ' ||
1864: TO_CHAR(p_code_combination_id_gain));
1865:
1866: arp_util.debug('p_override_terms = ' || l_override_terms);
1867: arp_util.debug('p_commitments_exist_flag = ' ||
1868: l_commitments_exist_flag);
1869: arp_util.debug('p_agreements_exist_flag = ' ||
1870: l_agreements_exist_flag);

Line 1867: arp_util.debug('p_commitments_exist_flag = ' ||

1863: arp_util.debug('p_code_combination_id_gain = ' ||
1864: TO_CHAR(p_code_combination_id_gain));
1865:
1866: arp_util.debug('p_override_terms = ' || l_override_terms);
1867: arp_util.debug('p_commitments_exist_flag = ' ||
1868: l_commitments_exist_flag);
1869: arp_util.debug('p_agreements_exist_flag = ' ||
1870: l_agreements_exist_flag);
1871:

Line 1869: arp_util.debug('p_agreements_exist_flag = ' ||

1865:
1866: arp_util.debug('p_override_terms = ' || l_override_terms);
1867: arp_util.debug('p_commitments_exist_flag = ' ||
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:

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 1876: arp_util.debug('EXCEPTION : '||

1872: arp_util.debug('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;

Line 1893: | arp_util.debug |

1889: | |
1890: | SCOPE - PUBLIC |
1891: | |
1892: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1893: | arp_util.debug |
1894: | |
1895: | ARGUMENTS : IN: |
1896: | p_payment_channel_code |
1897: | OUT: |

Line 1931: arp_util.debug('get_payment_channel_name: ' || ' NOT FOUND ');

1927: EXCEPTION
1928: WHEN NO_DATA_FOUND
1929: THEN
1930: IF PG_DEBUG in ('Y', 'C') THEN
1931: arp_util.debug('get_payment_channel_name: ' || ' NOT FOUND ');
1932: END IF;
1933: RETURN(NULL);
1934:
1935: WHEN OTHERS THEN

Line 1937: arp_util.debug('get_payment_channel_name: ' ||

1933: RETURN(NULL);
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;

Line 1939: arp_util.debug('get_payment_channel_name: ' || '------- parameters for get_payment_channel_name----');

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:
1943: RAISE;

Line 1940: arp_util.debug('get_payment_channel_name: ' || 'p_payment_channel_code = ' || p_payment_channel_code);

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:
1943: RAISE;
1944:

Line 1956: | arp_util.debug |

1952: | |
1953: | SCOPE - PUBLIC |
1954: | |
1955: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1956: | arp_util.debug |
1957: | |
1958: | ARGUMENTS : IN: |
1959: | p_cust_account_id |
1960: | OUT: |

Line 1991: arp_util.debug('get_party_id: ' || ' NOT FOUND ');

1987: EXCEPTION
1988: WHEN NO_DATA_FOUND
1989: THEN
1990: IF PG_DEBUG in ('Y', 'C') THEN
1991: arp_util.debug('get_party_id: ' || ' NOT FOUND ');
1992: END IF;
1993: RETURN(NULL);
1994:
1995: WHEN OTHERS THEN

Line 1997: arp_util.debug('get_party_id : ' ||

1993: RETURN(NULL);
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;

Line 1999: arp_util.debug('get_party_id: ' || '------- parameters for get_party_id ----');

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:
2003: RAISE;

Line 2000: arp_util.debug('get_party_id: ' || 'p_cust_account_id = ' || p_cust_account_id);

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:
2003: RAISE;
2004:

Line 2016: | arp_util.debug |

2012: | channel code and the payment trxn extension id. |
2013: | SCOPE - PUBLIC |
2014: | |
2015: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2016: | arp_util.debug |
2017: | |
2018: | ARGUMENTS : IN: |
2019: | p_payment_trxn_extension_id |
2020: | OUT: |

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

2050: WHERE payment_channel_code = p_payment_channel_code
2051: AND instrument_type in ('CREDITCARD', 'BANKACCOUNT');
2052:
2053: IF PG_DEBUG in ('Y', 'C') THEN
2054: arp_util.debug('p_payment_trxn_extension_id: ' || p_payment_trxn_extension_id);
2055: arp_util.debug('l_instrument_type: ' || l_instrument_type);
2056: END IF;
2057:
2058: SELECT decode (nvl(u.instrument_type, p.instrument_type)

Line 2055: arp_util.debug('l_instrument_type: ' || l_instrument_type);

2051: AND instrument_type in ('CREDITCARD', 'BANKACCOUNT');
2052:
2053: IF PG_DEBUG in ('Y', 'C') THEN
2054: arp_util.debug('p_payment_trxn_extension_id: ' || p_payment_trxn_extension_id);
2055: arp_util.debug('l_instrument_type: ' || l_instrument_type);
2056: END IF;
2057:
2058: SELECT decode (nvl(u.instrument_type, p.instrument_type)
2059: , 'BANKACCOUNT', b.masked_bank_account_num

Line 2082: arp_util.debug('l_instrument: ' || l_instrument);

2078: AND trxn_extension_id = p_payment_trxn_extension_id
2079: AND nvl(u.instrument_type, p.instrument_type) = l_instrument_type;
2080:
2081: IF PG_DEBUG in ('Y', 'C') THEN
2082: arp_util.debug('l_instrument: ' || l_instrument);
2083: END IF;
2084:
2085: RETURN l_instrument;
2086: EXCEPTION

Line 2090: arp_util.debug('get_payment_instrument: ' || ' NOT FOUND ');

2086: EXCEPTION
2087: WHEN NO_DATA_FOUND
2088: THEN
2089: IF PG_DEBUG in ('Y', 'C') THEN
2090: arp_util.debug('get_payment_instrument: ' || ' NOT FOUND ');
2091: END IF;
2092: RETURN(NULL);
2093:
2094: WHEN TOO_MANY_ROWS

Line 2097: arp_util.debug('get_payment_instrument: ' || 'TWO MANY ROWS FOUND ');

2093:
2094: WHEN TOO_MANY_ROWS
2095: THEN
2096: IF PG_DEBUG in ('Y', 'C') THEN
2097: arp_util.debug('get_payment_instrument: ' || 'TWO MANY ROWS FOUND ');
2098: END IF;
2099: RAISE;
2100:
2101: WHEN OTHERS THEN

Line 2103: arp_util.debug('get_payment_instrument: ' ||

2099: RAISE;
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);

Line 2105: arp_util.debug('get_payment_instrument: ' || '------- parameters ----');

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= ' ||
2109: p_payment_trxn_extension_id);

Line 2106: arp_util.debug('get_payment_instrument: ' || 'p_payment_channel_code= ' ||

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= ' ||
2109: p_payment_trxn_extension_id);
2110: END IF;

Line 2108: arp_util.debug('get_payment_instrument: ' || 'p_payment_trxn_extension_id= ' ||

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= ' ||
2109: p_payment_trxn_extension_id);
2110: END IF;
2111:
2112: RAISE;

Line 2125: | arp_util.debug |

2121: | channel code and the payment trxn extension id. |
2122: | SCOPE - PUBLIC |
2123: | |
2124: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2125: | arp_util.debug |
2126: | |
2127: | ARGUMENTS : IN: |
2128: | p_payment_trxn_extension_id |
2129: | OUT: p_bank_name,p_branch_name,p_instr_assign_id |

Line 2165: arp_util.debug('ar_br_bank_defaults - No data found');

2161: and payment_channel_code = p_payment_channel_code;
2162:
2163: exception
2164: when no_data_found then
2165: arp_util.debug('ar_br_bank_defaults - No data found');
2166: when others then
2167: arp_util.debug('ar_br_bank_defaults - Others');
2168: End;
2169:

Line 2167: arp_util.debug('ar_br_bank_defaults - Others');

2163: exception
2164: when no_data_found then
2165: arp_util.debug('ar_br_bank_defaults - No data found');
2166: when others then
2167: arp_util.debug('ar_br_bank_defaults - Others');
2168: End;
2169:
2170:
2171: --Bug 5507178 To Default the Instrument Details for a transaction

Line 2237: arp_util.debug('Unable to default the Instrument Details');

2233: x_response => l_response);
2234:
2235:
2236: IF (l_return_status <> 'S') THEN
2237: arp_util.debug('Unable to default the Instrument Details');
2238:
2239: ELSE
2240: /*Bug6135223*/
2241: If l_instr_assignments.count = 0 Then