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';
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: /*----------------------------------------------------------------------------
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';
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: /*----------------------------------------------------------------------------
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
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: /*----------------------------------------------------------------------------
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()+');
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: --
345:
346: BEGIN
347: fnd_file.put_line(FND_FILE.LOG, 'CURSOR_FOR_CUSTOM_LLCA()+');
348: IF PG_DEBUG in ('Y', 'C') THEN
349: arp_util.debug('arp_lockbox_hook.cursor_for_custom_llca()+');
350: END IF;
351:
352: /***********************PSEUDO CODE*****************************************
353: Loop till last record in p_unresolved_inv_array
367: End Loop.
368: ************************PSEUDO CODE****************************************/
369: fnd_file.put_line(FND_FILE.LOG, 'CURSOR_FOR_CUSTOM_LLCA()-');
370: IF PG_DEBUG in ('Y', 'C') THEN
371: arp_util.debug('arp_lockbox_hook.cursor_for_custom_llca()-');
372: END IF;
373: RETURN;
374: END cursor_for_custom_llca;
375: --