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_LOCKBOX_HOOK dependencies on ARP_LOCKBOX_HOOK

Line 1: PACKAGE BODY ARP_LOCKBOX_HOOK AS

1: PACKAGE BODY ARP_LOCKBOX_HOOK AS
2: /*$Header: ARRLBHKB.pls 120.7.12010000.5 2009/03/20 17:36:59 aghoraka ship $*/
3: --
4: /*----------------------------------------------------------------------------
5: proc_before_validation

Line 29: arp_util.debug('arp_lockbox_hook.proc_before_validation()+');

25: in_trans_req_id IN VARCHAR2,
26: out_insert_records OUT NOCOPY VARCHAR2) IS
27: BEGIN
28: IF PG_DEBUG in ('Y', 'C') THEN
29: arp_util.debug('arp_lockbox_hook.proc_before_validation()+');
30: END IF;
31: out_errorcode := 0;
32: out_errorbuf := NULL;
33: out_insert_records := 'Y';

Line 35: arp_util.debug('arp_lockbox_hook.proc_before_validation()-');

31: out_errorcode := 0;
32: out_errorbuf := NULL;
33: out_insert_records := 'Y';
34: IF PG_DEBUG in ('Y', 'C') THEN
35: arp_util.debug('arp_lockbox_hook.proc_before_validation()-');
36: END IF;
37: END proc_before_validation;
38: --
39: /*----------------------------------------------------------------------------

Line 68: arp_util.debug('arp_lockbox_hook.proc_after_validation()+');

64: out_insert_records OUT NOCOPY VARCHAR2) IS
65: --
66: BEGIN
67: IF PG_DEBUG in ('Y', 'C') THEN
68: arp_util.debug('arp_lockbox_hook.proc_after_validation()+');
69: END IF;
70: out_errorcode := 9;
71: out_errorbuf := NULL;
72: out_insert_records := 'N';

Line 74: arp_util.debug('arp_lockbox_hook.proc_after_validation()-');

70: out_errorcode := 9;
71: out_errorbuf := NULL;
72: out_insert_records := 'N';
73: IF PG_DEBUG in ('Y', 'C') THEN
74: arp_util.debug('arp_lockbox_hook.proc_after_validation()-');
75: END IF;
76: END proc_after_validation;
77: --
78: /*----------------------------------------------------------------------------

Line 96: arp_util.debug('arp_lockbox_hook.proc_after_second_validation()+');

92: out_errorcode OUT NOCOPY VARCHAR2,
93: in_trans_req_id IN VARCHAR2) IS
94: BEGIN
95: IF PG_DEBUG in ('Y', 'C') THEN
96: arp_util.debug('arp_lockbox_hook.proc_after_second_validation()+');
97: END IF;
98: out_errorcode := 0;
99: out_errorbuf := NULL;
100: IF PG_DEBUG in ('Y', 'C') THEN

Line 101: arp_util.debug('arp_lockbox_hook.proc_after_second_validation()-');

97: END IF;
98: out_errorcode := 0;
99: out_errorbuf := NULL;
100: IF PG_DEBUG in ('Y', 'C') THEN
101: arp_util.debug('arp_lockbox_hook.proc_after_second_validation()-');
102: END IF;
103: END proc_after_second_validation;
104: --
105: /*----------------------------------------------------------------------------

Line 111: arp_lockbox_Hook.cursor_for_matching_rule, which can be used to

107:
108: cursor_for_matching_rule
109:
110: Oracle Receivables supplies the Packaged Procedure
111: arp_lockbox_Hook.cursor_for_matching_rule, which can be used to
112: add a matching rule to Lockbox functionality.
113: If for example you need to match matching numbers and date passed to
114: Lockbox with numbers and dates in your own custom tables
115: custom_table.custom_number and custom_table.custom_date, instead of

Line 203: arp_util.debug('arp_lockbox_hook.cursor_for_matching_rule()+');

199: PROCEDURE CURSOR_FOR_MATCHING_RULE(p_matching_option IN VARCHAR2,
200: p_cursor_string OUT NOCOPY VARCHAR2) IS
201: BEGIN
202: IF PG_DEBUG in ('Y', 'C') THEN
203: arp_util.debug('arp_lockbox_hook.cursor_for_matching_rule()+');
204: END IF;
205: p_cursor_string := 'select -9999, NULL, NULL from dual';
206: IF PG_DEBUG in ('Y', 'C') THEN
207: arp_util.debug('arp_lockbox_hook.cursor_for_matching_rule()+');

Line 207: arp_util.debug('arp_lockbox_hook.cursor_for_matching_rule()+');

203: arp_util.debug('arp_lockbox_hook.cursor_for_matching_rule()+');
204: END IF;
205: p_cursor_string := 'select -9999, NULL, NULL from dual';
206: IF PG_DEBUG in ('Y', 'C') THEN
207: arp_util.debug('arp_lockbox_hook.cursor_for_matching_rule()+');
208: END IF;
209: RETURN;
210: END cursor_for_matching_rule;
211: --

Line 218: arp_lockbox_Hook.cursor_for_custom_llca, which can be used to :-

214:
215: cursor_for_custom_llca
216:
217: Oracle Receivables supplies the Packaged Procedure
218: arp_lockbox_Hook.cursor_for_custom_llca, which can be used to :-
219:
220: 1. Customise lockbox to add any matching rules of customers chioce.
221: 2. Earlier custom matching rule functionality provided in the PROCEDURE
222: CURSOR_FOR_MATCHING_RULE, has a limitaion that each custom matching number

Line 337: PROCEDURE CURSOR_FOR_CUSTOM_LLCA( p_unresolved_inv_array IN OUT NOCOPY arp_lockbox_hook_pvt.invoice_array,

333: supplied with the matching number, then make sure that all the resolved
334: numbers for this matching number belong to the same currency code(=invoice_
335: currency_code with the matching number, if given).
336: ----------------------------------------------------------------------------*/
337: PROCEDURE CURSOR_FOR_CUSTOM_LLCA( p_unresolved_inv_array IN OUT NOCOPY arp_lockbox_hook_pvt.invoice_array,
338: p_invoice_array IN OUT NOCOPY arp_lockbox_hook_pvt.invoice_array,
339: p_line_array IN OUT NOCOPY arp_lockbox_hook_pvt.line_array ) IS
340:
341: /*******************PSEUDO CODE************************************************

Line 338: p_invoice_array IN OUT NOCOPY arp_lockbox_hook_pvt.invoice_array,

334: numbers for this matching number belong to the same currency code(=invoice_
335: currency_code with the matching number, if given).
336: ----------------------------------------------------------------------------*/
337: PROCEDURE CURSOR_FOR_CUSTOM_LLCA( p_unresolved_inv_array IN OUT NOCOPY arp_lockbox_hook_pvt.invoice_array,
338: p_invoice_array IN OUT NOCOPY arp_lockbox_hook_pvt.invoice_array,
339: p_line_array IN OUT NOCOPY arp_lockbox_hook_pvt.line_array ) IS
340:
341: /*******************PSEUDO CODE************************************************
342: Declare cursor to fetch receipt applications.

Line 339: p_line_array IN OUT NOCOPY arp_lockbox_hook_pvt.line_array ) IS

335: currency_code with the matching number, if given).
336: ----------------------------------------------------------------------------*/
337: PROCEDURE CURSOR_FOR_CUSTOM_LLCA( p_unresolved_inv_array IN OUT NOCOPY arp_lockbox_hook_pvt.invoice_array,
338: p_invoice_array IN OUT NOCOPY arp_lockbox_hook_pvt.invoice_array,
339: p_line_array IN OUT NOCOPY arp_lockbox_hook_pvt.line_array ) IS
340:
341: /*******************PSEUDO CODE************************************************
342: Declare cursor to fetch receipt applications.
343: Declare cusrsor to fetch line level application details.

Line 348: arp_util.debug('arp_lockbox_hook.cursor_for_custom_llca()+');

344: ********************PSEUDO CODE***********************************************/
345:
346: BEGIN
347: IF PG_DEBUG in ('Y', 'C') THEN
348: arp_util.debug('arp_lockbox_hook.cursor_for_custom_llca()+');
349: END IF;
350:
351: /***********************PSEUDO CODE*****************************************
352: Loop till last record in p_unresolved_inv_array

Line 369: arp_util.debug('arp_lockbox_hook.cursor_for_custom_llca()-');

365:
366: End Loop.
367: ************************PSEUDO CODE****************************************/
368: IF PG_DEBUG in ('Y', 'C') THEN
369: arp_util.debug('arp_lockbox_hook.cursor_for_custom_llca()-');
370: END IF;
371: RETURN;
372: END cursor_for_custom_llca;
373: --

Line 374: END arp_lockbox_hook;

370: END IF;
371: RETURN;
372: END cursor_for_custom_llca;
373: --
374: END arp_lockbox_hook;