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_PVT dependencies on ARP_UTIL

Line 46: arp_util.debug('arp_lockbox_hook_pvt.proc_before_validation()+');

42: l_line_level_cash_app_rule varchar2(2);
43: --
44: BEGIN
45: IF PG_DEBUG in ('Y', 'C') THEN
46: arp_util.debug('arp_lockbox_hook_pvt.proc_before_validation()+');
47: END IF;
48:
49: BEGIN
50: select nvl(a.LINE_LEVEL_CASH_APP_RULE,'N') into l_line_level_cash_app_rule

Line 57: arp_util.debug('Lockbox Number is given through the data file');

53: and a.lockbox_id = b.requested_lockbox_id;
54: EXCEPTION
55: WHEN NO_DATA_FOUND THEN
56: IF PG_DEBUG in ('Y', 'C') THEN
57: arp_util.debug('Lockbox Number is given through the data file');
58: END IF;
59: /* * Bug 7504497 Line Level Cash Application Rule is fetched from ar_lockboxes *
60: * using Lockbox_number provided in the data file. However the data in the *
61: * interface table will not be trimmed at this point which might fail in *

Line 96: arp_util.debug('Multiple Lockboxes are present with different LLCA Rules');

92: and lockbox_number is not null );
93: EXCEPTION
94: WHEN TOO_MANY_ROWS THEN
95: IF PG_DEBUG in ('Y', 'C') THEN
96: arp_util.debug('Multiple Lockboxes are present with different LLCA Rules');
97: END IF;
98: RAISE;
99: WHEN NO_DATA_FOUND THEN
100: IF PG_DEBUG in ('Y', 'C') THEN

Line 101: arp_util.debug('No matching Lockbox found.');

97: END IF;
98: RAISE;
99: WHEN NO_DATA_FOUND THEN
100: IF PG_DEBUG in ('Y', 'C') THEN
101: arp_util.debug('No matching Lockbox found.');
102: END IF;
103: /* Bug 7648756 : There cannot be a case where Lockbox number is neither provided
104: in the flat file nor in the request submission window, unless the customer is
105: running an empty transmission file to close the transmission. If the customer

Line 112: arp_util.debug('Error in fetching Line Level Cash Application Rule.');

108: l_line_level_cash_app_rule := 'N';
109: -- RAISE;
110: WHEN OTHERS THEN
111: IF PG_DEBUG in ('Y', 'C') THEN
112: arp_util.debug('Error in fetching Line Level Cash Application Rule.');
113: arp_util.debug('Error Message '||SQLERRM);
114: END IF;
115: RAISE;
116: END;

Line 113: arp_util.debug('Error Message '||SQLERRM);

109: -- RAISE;
110: WHEN OTHERS THEN
111: IF PG_DEBUG in ('Y', 'C') THEN
112: arp_util.debug('Error in fetching Line Level Cash Application Rule.');
113: arp_util.debug('Error Message '||SQLERRM);
114: END IF;
115: RAISE;
116: END;
117:

Line 138: arp_util.debug('proc_before_validation: ' || 'Exception in checking if OKL is installed');

134:
135: EXCEPTION
136: WHEN OTHERS THEN
137: IF PG_DEBUG in ('Y', 'C') THEN
138: arp_util.debug('proc_before_validation: ' || 'Exception in checking if OKL is installed');
139: END IF;
140: l_okl_flag := 'N';
141: END;
142:

Line 145: arp_util.debug('proc_before_validation: ' || 'OKL is installed');

141: END;
142:
143: IF l_okl_flag = 'Y' THEN
144: IF PG_DEBUG in ('Y', 'C') THEN
145: arp_util.debug('proc_before_validation: ' || 'OKL is installed');
146: END IF;
147: g_okl_installed := TRUE;
148: END IF;
149:

Line 194: arp_util.debug('arp_lockbox_hook_pvt.proc_before_validation()-');

190: out_insert_records := pub_insert_records;
191: END IF;
192:
193: IF PG_DEBUG in ('Y', 'C') THEN
194: arp_util.debug('arp_lockbox_hook_pvt.proc_before_validation()-');
195: END IF;
196: END proc_before_validation;
197: --
198: /*----------------------------------------------------------------------------

Line 240: arp_util.debug('proc_after_validation: ' || 'arp_lockbox_hook_pvt.proc_after_validation()+');

236: x_msg_data VARCHAR(2000);
237: --
238: BEGIN
239: IF PG_DEBUG in ('Y', 'C') THEN
240: arp_util.debug('proc_after_validation: ' || 'arp_lockbox_hook_pvt.proc_after_validation()+');
241: END IF;
242: IF nvl(arp_global.sysparam.ta_installed_flag,'N') = 'Y' THEN
243: -- Removed ARTA logic as functionality is obsolete in R12
244: -- See Bug 4936298

Line 259: arp_util.debug('Calling OKL proc_after_validation');

255: ',:6 ' ||
256: '); ' ||
257: 'END;';
258: IF PG_DEBUG in ('Y', 'C') THEN
259: arp_util.debug('Calling OKL proc_after_validation');
260: END IF;
261: EXECUTE IMMEDIATE l_okl_block USING p_api_version, p_init_msg_list, OUT x_return_status, OUT x_msg_count, OUT x_msg_data, in_trans_req_id;
262: IF PG_DEBUG in ('Y', 'C') THEN
263: arp_util.debug('Returned from OKL proc_after_validation');

Line 263: arp_util.debug('Returned from OKL proc_after_validation');

259: arp_util.debug('Calling OKL proc_after_validation');
260: END IF;
261: EXECUTE IMMEDIATE l_okl_block USING p_api_version, p_init_msg_list, OUT x_return_status, OUT x_msg_count, OUT x_msg_data, in_trans_req_id;
262: IF PG_DEBUG in ('Y', 'C') THEN
263: arp_util.debug('Returned from OKL proc_after_validation');
264: END IF;
265: EXCEPTION
266: -- We ignore any error in OKL and
267: -- continue the process as if OKL is not installed

Line 270: arp_util.debug('Exception in OKL proc_after_validation');

266: -- We ignore any error in OKL and
267: -- continue the process as if OKL is not installed
268: WHEN OTHERS THEN
269: IF PG_DEBUG in ('Y', 'C') THEN
270: arp_util.debug('Exception in OKL proc_after_validation');
271: END IF;
272: null;
273: END;
274: pvt_errorcode := 0;

Line 315: arp_util.debug('proc_after_validation: ' || 'arp_lockbox_hook_pvt.proc_after_validation()-');

311: out_insert_records := pub_insert_records;
312: END IF;
313:
314: IF PG_DEBUG in ('Y', 'C') THEN
315: arp_util.debug('proc_after_validation: ' || 'arp_lockbox_hook_pvt.proc_after_validation()-');
316: END IF;
317: END proc_after_validation;
318: --
319: /*----------------------------------------------------------------------------

Line 341: arp_util.debug('arp_lockbox_hook_pvt.proc_after_second_validation()+');

337: pub_errorbuf varchar2(255);
338: pub_errorcode varchar2(255);
339: BEGIN
340: IF PG_DEBUG in ('Y', 'C') THEN
341: arp_util.debug('arp_lockbox_hook_pvt.proc_after_second_validation()+');
342: END IF;
343: IF nvl(arp_global.sysparam.ta_installed_flag,'N') = 'Y' THEN
344: -- Removed ARTA logic as functionality is obsolete in R12
345: -- See Bug 4936298

Line 370: arp_util.debug('arp_lockbox_hook_pvt.proc_after_second_validation()-');

366: out_errorbuf := pvt_errorbuf;
367: END IF;
368:
369: IF PG_DEBUG in ('Y', 'C') THEN
370: arp_util.debug('arp_lockbox_hook_pvt.proc_after_second_validation()-');
371: END IF;
372: END proc_after_second_validation;
373: --
374: /*----------------------------------------------------------------------------

Line 487: arp_util.debug('arp_lockbox_hook_pvt.proc_for_custom_llca()+');

483: and b.requested_trans_format_id = a.transmission_format_id
484: and a.record_type_lookup_code in ('PAYMENT','OVRFLW PAYMENT') );
485: BEGIN
486: IF PG_DEBUG in ('Y', 'C') THEN
487: arp_util.debug('arp_lockbox_hook_pvt.proc_for_custom_llca()+');
488: END IF;
489: /* Check if the format includes batches */
490: BEGIN
491: SELECT distinct 'Y'

Line 502: arp_util.debug('No batches present in the transmission');

498: AND b.transmission_request_id = in_trans_req_id )
499: AND field_type_lookup_code = 'BATCH NAME';
500: EXCEPTION
501: WHEN NO_DATA_FOUND THEN
502: arp_util.debug('No batches present in the transmission');
503: l_batches := 'N';
504: END;
505: /* Get Pay_unrelated_invoices_Flag from ar_system_parameters */
506: BEGIN

Line 737: arp_util.debug('Number of Invoices inside custom code :' || l_last_invoice_index);

733: * inserted into ar_payments_interface for the matching number, which would eventually fail*
734: * in validation.
735: */
736: IF PG_DEBUG in ('Y', 'C') THEN
737: arp_util.debug('Number of Invoices inside custom code :' || l_last_invoice_index);
738: END IF;
739: FOR i in 1..l_unres_invoice_index LOOP
740: k := 1;
741: DECLARE

Line 746: arp_util.debug('For '|| l_unres_inv_array(i).matching_number);

742: l_resolved_array invoice_array;
743: BEGIN
744: FOR j in 1..l_last_invoice_index LOOP
745: IF PG_DEBUG in ('Y', 'C') THEN
746: arp_util.debug('For '|| l_unres_inv_array(i).matching_number);
747: arp_util.debug('And '|| l_invoice_array(j).matching_number);
748: arp_util.debug('And '|| l_invoice_array(j).invoice_number);
749: arp_util.debug('Size :'||l_resolved_array.last || 'K :' ||k);
750: END IF;

Line 747: arp_util.debug('And '|| l_invoice_array(j).matching_number);

743: BEGIN
744: FOR j in 1..l_last_invoice_index LOOP
745: IF PG_DEBUG in ('Y', 'C') THEN
746: arp_util.debug('For '|| l_unres_inv_array(i).matching_number);
747: arp_util.debug('And '|| l_invoice_array(j).matching_number);
748: arp_util.debug('And '|| l_invoice_array(j).invoice_number);
749: arp_util.debug('Size :'||l_resolved_array.last || 'K :' ||k);
750: END IF;
751: IF l_unres_inv_array(i).matching_number = l_invoice_array(j).matching_number

Line 748: arp_util.debug('And '|| l_invoice_array(j).invoice_number);

744: FOR j in 1..l_last_invoice_index LOOP
745: IF PG_DEBUG in ('Y', 'C') THEN
746: arp_util.debug('For '|| l_unres_inv_array(i).matching_number);
747: arp_util.debug('And '|| l_invoice_array(j).matching_number);
748: arp_util.debug('And '|| l_invoice_array(j).invoice_number);
749: arp_util.debug('Size :'||l_resolved_array.last || 'K :' ||k);
750: END IF;
751: IF l_unres_inv_array(i).matching_number = l_invoice_array(j).matching_number
752: AND l_unres_inv_array(i).item_number = l_invoice_array(j).item_number THEN

Line 749: arp_util.debug('Size :'||l_resolved_array.last || 'K :' ||k);

745: IF PG_DEBUG in ('Y', 'C') THEN
746: arp_util.debug('For '|| l_unres_inv_array(i).matching_number);
747: arp_util.debug('And '|| l_invoice_array(j).matching_number);
748: arp_util.debug('And '|| l_invoice_array(j).invoice_number);
749: arp_util.debug('Size :'||l_resolved_array.last || 'K :' ||k);
750: END IF;
751: IF l_unres_inv_array(i).matching_number = l_invoice_array(j).matching_number
752: AND l_unres_inv_array(i).item_number = l_invoice_array(j).item_number THEN
753: IF l_batches = 'Y' THEN

Line 782: arp_util.debug('Custom Number '||l_unres_inv_array(i).matching_number||' has been resolved into ');

778: l_res_invoice_index := l_resolved_array.last;
779: l_inv_precision := 0;
780:
781: IF PG_DEBUG in ('Y', 'C') THEN
782: arp_util.debug('Custom Number '||l_unres_inv_array(i).matching_number||' has been resolved into ');
783: arp_util.debug(nvl(l_res_invoice_index, 0)||' invoices.');
784: END IF;
785:
786: IF l_res_invoice_index IS NOT NULL THEN

Line 783: arp_util.debug(nvl(l_res_invoice_index, 0)||' invoices.');

779: l_inv_precision := 0;
780:
781: IF PG_DEBUG in ('Y', 'C') THEN
782: arp_util.debug('Custom Number '||l_unres_inv_array(i).matching_number||' has been resolved into ');
783: arp_util.debug(nvl(l_res_invoice_index, 0)||' invoices.');
784: END IF;
785:
786: IF l_res_invoice_index IS NOT NULL THEN
787: SELECT a

Line 873: arp_util.debug('Trans_to_receipt_rate cannot be different to the rate specified at the matching number.');

869: IF (l_trans_to_receipt_rate IS NOT NULL
870: AND l_resolved_array(j).trans_to_receipt_rate IS NOT NULL
871: AND l_trans_to_receipt_rate <> l_resolved_array(j).trans_to_receipt_rate) THEN
872: IF PG_DEBUG in ('Y', 'C') THEN
873: arp_util.debug('Trans_to_receipt_rate cannot be different to the rate specified at the matching number.');
874: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
875: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
876: END IF;
877: l_error_flag := 'T';

Line 874: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);

870: AND l_resolved_array(j).trans_to_receipt_rate IS NOT NULL
871: AND l_trans_to_receipt_rate <> l_resolved_array(j).trans_to_receipt_rate) THEN
872: IF PG_DEBUG in ('Y', 'C') THEN
873: arp_util.debug('Trans_to_receipt_rate cannot be different to the rate specified at the matching number.');
874: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
875: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
876: END IF;
877: l_error_flag := 'T';
878: exit;

Line 875: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);

871: AND l_trans_to_receipt_rate <> l_resolved_array(j).trans_to_receipt_rate) THEN
872: IF PG_DEBUG in ('Y', 'C') THEN
873: arp_util.debug('Trans_to_receipt_rate cannot be different to the rate specified at the matching number.');
874: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
875: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
876: END IF;
877: l_error_flag := 'T';
878: exit;
879: END IF; /* End TTR check */

Line 884: arp_util.debug('Invoice currency code cannot be different to the currency code specified at the matching number.');

880: IF (l_invoice_currency_code IS NOT NULL
881: AND l_resolved_array(j).invoice_currency_code IS NOT NULL
882: AND l_invoice_currency_code <> l_resolved_array(j).invoice_currency_code) THEN
883: IF PG_DEBUG in ('Y', 'C') THEN
884: arp_util.debug('Invoice currency code cannot be different to the currency code specified at the matching number.');
885: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
886: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
887: END IF;
888: l_error_flag := 'T';

Line 885: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);

881: AND l_resolved_array(j).invoice_currency_code IS NOT NULL
882: AND l_invoice_currency_code <> l_resolved_array(j).invoice_currency_code) THEN
883: IF PG_DEBUG in ('Y', 'C') THEN
884: arp_util.debug('Invoice currency code cannot be different to the currency code specified at the matching number.');
885: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
886: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
887: END IF;
888: l_error_flag := 'T';
889: exit;

Line 886: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);

882: AND l_invoice_currency_code <> l_resolved_array(j).invoice_currency_code) THEN
883: IF PG_DEBUG in ('Y', 'C') THEN
884: arp_util.debug('Invoice currency code cannot be different to the currency code specified at the matching number.');
885: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
886: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
887: END IF;
888: l_error_flag := 'T';
889: exit;
890: END IF; /* End currency code check */

Line 903: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);

899: l_currency_code1 VARCHAR2(15);
900: BEGIN
901: l_res_currency_code := trim(l_invoice_currency_code);
902: IF PG_DEBUG in ('Y', 'C') THEN
903: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
904: arp_util.debug('Currency Code '||l_res_currency_code);
905: END IF;
906: FOR j in 1..l_res_invoice_index LOOP
907: SELECT distinct(invoice_currency_code)

Line 904: arp_util.debug('Currency Code '||l_res_currency_code);

900: BEGIN
901: l_res_currency_code := trim(l_invoice_currency_code);
902: IF PG_DEBUG in ('Y', 'C') THEN
903: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
904: arp_util.debug('Currency Code '||l_res_currency_code);
905: END IF;
906: FOR j in 1..l_res_invoice_index LOOP
907: SELECT distinct(invoice_currency_code)
908: INTO l_currency_code1

Line 942: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);

938: l_resolved_array(j).invoice_currency_code := trim(l_currency_code1);
939: l_res_currency_code := nvl(l_res_currency_code, trim(l_currency_code1));
940:
941: IF PG_DEBUG in ('Y', 'C') THEN
942: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
943: arp_util.debug('Currency Code '|| l_currency_code1);
944: END IF;
945: IF l_res_currency_code <> trim(l_currency_code1) THEN
946: IF PG_DEBUG in ('Y', 'C') THEN

Line 943: arp_util.debug('Currency Code '|| l_currency_code1);

939: l_res_currency_code := nvl(l_res_currency_code, trim(l_currency_code1));
940:
941: IF PG_DEBUG in ('Y', 'C') THEN
942: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
943: arp_util.debug('Currency Code '|| l_currency_code1);
944: END IF;
945: IF l_res_currency_code <> trim(l_currency_code1) THEN
946: IF PG_DEBUG in ('Y', 'C') THEN
947: arp_util.debug('All Resolved invoices does not belong to the same currency for matching number '||l_invoice_array(i).matching_number);

Line 947: arp_util.debug('All Resolved invoices does not belong to the same currency for matching number '||l_invoice_array(i).matching_number);

943: arp_util.debug('Currency Code '|| l_currency_code1);
944: END IF;
945: IF l_res_currency_code <> trim(l_currency_code1) THEN
946: IF PG_DEBUG in ('Y', 'C') THEN
947: arp_util.debug('All Resolved invoices does not belong to the same currency for matching number '||l_invoice_array(i).matching_number);
948: END IF;
949: l_error_flag := 'T';
950: exit;
951: END IF;

Line 957: arp_util.debug('Invalid Application Number '||l_resolved_array(j).invoice_number);

953: END LOOP;
954: EXCEPTION
955: WHEN NO_DATA_FOUND THEN
956: IF PG_DEBUG in ('Y', 'C') THEN
957: arp_util.debug('Invalid Application Number '||l_resolved_array(j).invoice_number);
958: END IF;
959: l_error_flag := 'T';
960: WHEN TOO_MANY_ROWS THEN
961: IF PG_DEBUG in ('Y', 'C') THEN

Line 962: arp_util.debug('Too many applications exist with name '||l_resolved_array(j).invoice_number);

958: END IF;
959: l_error_flag := 'T';
960: WHEN TOO_MANY_ROWS THEN
961: IF PG_DEBUG in ('Y', 'C') THEN
962: arp_util.debug('Too many applications exist with name '||l_resolved_array(j).invoice_number);
963: END IF;
964: l_error_flag := 'T';
965: WHEN OTHERS THEN
966: IF PG_DEBUG in ('Y', 'C') THEN

Line 967: arp_util.debug('Exception occured in resolving '||l_resolved_array(j).invoice_number);

963: END IF;
964: l_error_flag := 'T';
965: WHEN OTHERS THEN
966: IF PG_DEBUG in ('Y', 'C') THEN
967: arp_util.debug('Exception occured in resolving '||l_resolved_array(j).invoice_number);
968: arp_util.debug('Error Message '||SQLERRM);
969: END IF;
970: l_error_flag := 'T';
971: END; /* End check currency code when not provided */

Line 968: arp_util.debug('Error Message '||SQLERRM);

964: l_error_flag := 'T';
965: WHEN OTHERS THEN
966: IF PG_DEBUG in ('Y', 'C') THEN
967: arp_util.debug('Exception occured in resolving '||l_resolved_array(j).invoice_number);
968: arp_util.debug('Error Message '||SQLERRM);
969: END IF;
970: l_error_flag := 'T';
971: END; /* End check currency code when not provided */
972:

Line 991: arp_util.debug('Sum of amount_applied_from at the resolved invoices is not equal to the amount_applied_from specified at matching number.');

987: END LOOP;
988: IF l_sum_amount_applied_from <> 0
989: AND l_sum_amount_applied_from <> l_amount_applied_from THEN
990: IF PG_DEBUG in ('Y', 'C') THEN
991: arp_util.debug('Sum of amount_applied_from at the resolved invoices is not equal to the amount_applied_from specified at matching number.');
992: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
993: END IF;
994: l_error_flag := 'T';
995: END IF;

Line 992: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);

988: IF l_sum_amount_applied_from <> 0
989: AND l_sum_amount_applied_from <> l_amount_applied_from THEN
990: IF PG_DEBUG in ('Y', 'C') THEN
991: arp_util.debug('Sum of amount_applied_from at the resolved invoices is not equal to the amount_applied_from specified at matching number.');
992: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
993: END IF;
994: l_error_flag := 'T';
995: END IF;
996: END IF;/* Check Sum of amount_applied_from */

Line 1002: arp_util.debug('Amount_applied_From '||l_amount_applied_from);

998: /* Prorate Amount_applied_from to the resolved invoices if not provided in custom hook */
999: l_rem_amt_applied_from := nvl(l_amount_applied_from, 0);
1000: IF l_error_flag <> 'T' THEN
1001: IF PG_DEBUG in ('Y', 'C') THEN
1002: arp_util.debug('Amount_applied_From '||l_amount_applied_from);
1003: END IF;
1004: If l_amount_applied_from IS NOT NULL THEN
1005: FOR j in 1..l_res_invoice_index LOOP
1006: IF PG_DEBUG in ('Y', 'C') THEN

Line 1007: arp_util.debug('Prorating Amount_applied_from');

1003: END IF;
1004: If l_amount_applied_from IS NOT NULL THEN
1005: FOR j in 1..l_res_invoice_index LOOP
1006: IF PG_DEBUG in ('Y', 'C') THEN
1007: arp_util.debug('Prorating Amount_applied_from');
1008: END IF;
1009: IF l_resolved_array(j).amount_applied_from IS NULL THEN
1010: l_resolved_array(j).amount_applied_from := ROUND(
1011: (l_resolved_array(j).amount_applied/l_amount_applied)

Line 1032: arp_util.debug('Validation failed for '||l_unres_inv_array(i).matching_number);

1028: INTO l_transmission_rec_id_of
1029: FROM dual;
1030:
1031: IF PG_DEBUG in ('Y', 'C') THEN
1032: arp_util.debug('Validation failed for '||l_unres_inv_array(i).matching_number);
1033: END IF;
1034:
1035: /* The Exchange rate info provided at the matching number level does not match
1036: with the details provided at the resolved invoice level. So insert the Custom

Line 1146: arp_util.debug('Inserting lines for '|| l_resolved_array(j).invoice_number);

1142: IF l_resolved_array(j).invoice_number = l_line_array(k).invoice_number
1143: AND l_resolved_array(j).item_number = l_line_array(k).item_number
1144: AND NVL(l_resolved_array(j).batch_name, -1) = NVL(l_line_array(k).batch_name, -1)THEN
1145: IF PG_DEBUG in ('Y', 'C') THEN
1146: arp_util.debug('Inserting lines for '|| l_resolved_array(j).invoice_number);
1147: END IF;
1148: INSERT INTO AR_PMTS_INTERFACE_LINE_DETAILS (
1149: status,
1150: transmission_request_id,

Line 1243: arp_util.debug('arp_lockbox_hook_pvt.proc_for_custom_llca()-');

1239: END IF;
1240: END IF;
1241:
1242: IF PG_DEBUG in ('Y', 'C') THEN
1243: arp_util.debug('arp_lockbox_hook_pvt.proc_for_custom_llca()-');
1244: END IF;
1245: EXCEPTION
1246: WHEN OTHERS THEN
1247: IF PG_DEBUG in ('Y', 'C') THEN

Line 1248: arp_util.debug('Exception in proc_for_custom_llca');

1244: END IF;
1245: EXCEPTION
1246: WHEN OTHERS THEN
1247: IF PG_DEBUG in ('Y', 'C') THEN
1248: arp_util.debug('Exception in proc_for_custom_llca');
1249: arp_util.debug('Error : '||SQLERRM);
1250: END IF;
1251: RAISE;
1252: END proc_for_custom_llca;

Line 1249: arp_util.debug('Error : '||SQLERRM);

1245: EXCEPTION
1246: WHEN OTHERS THEN
1247: IF PG_DEBUG in ('Y', 'C') THEN
1248: arp_util.debug('Exception in proc_for_custom_llca');
1249: arp_util.debug('Error : '||SQLERRM);
1250: END IF;
1251: RAISE;
1252: END proc_for_custom_llca;
1253: --