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 56: arp_util.debug('Lockbox Number is given through the data file');

52: where b.transmission_request_id = in_trans_req_id
53: and a.lockbox_id = b.requested_lockbox_id;
54: EXCEPTION
55: WHEN NO_DATA_FOUND THEN
56: arp_util.debug('Lockbox Number is given through the data file');
57: /* * Bug 7504497 Line Level Cash Application Rule is fetched from ar_lockboxes *
58: * using Lockbox_number provided in the data file. However the data in the *
59: * interface table will not be trimmed at this point which might fail in *
60: * fetching data from ar_lockboxes. Hence trimmed Lockbox number here. The *

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

88: where transmission_request_id = in_trans_req_id
89: and lockbox_number is not null );
90: EXCEPTION
91: WHEN TOO_MANY_ROWS THEN
92: arp_util.debug('Multiple Lockboxes are present with different LLCA Rules');
93: fnd_file.put_line(FND_FILE.LOG, 'Multiple Lockboxes are present with different LLCA Rules');
94: RAISE;
95: WHEN NO_DATA_FOUND THEN
96: arp_util.debug('No matching Lockbox found.');

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

92: arp_util.debug('Multiple Lockboxes are present with different LLCA Rules');
93: fnd_file.put_line(FND_FILE.LOG, 'Multiple Lockboxes are present with different LLCA Rules');
94: RAISE;
95: WHEN NO_DATA_FOUND THEN
96: arp_util.debug('No matching Lockbox found.');
97: RAISE;
98: WHEN OTHERS THEN
99: arp_util.debug('Error in fetching Line Level Cash Application Rule.');
100: arp_util.debug('Error Message '||SQLERRM);

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

95: WHEN NO_DATA_FOUND THEN
96: arp_util.debug('No matching Lockbox found.');
97: RAISE;
98: WHEN OTHERS THEN
99: arp_util.debug('Error in fetching Line Level Cash Application Rule.');
100: arp_util.debug('Error Message '||SQLERRM);
101: RAISE;
102: END;
103: END;

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

96: arp_util.debug('No matching Lockbox found.');
97: RAISE;
98: WHEN OTHERS THEN
99: arp_util.debug('Error in fetching Line Level Cash Application Rule.');
100: arp_util.debug('Error Message '||SQLERRM);
101: RAISE;
102: END;
103: END;
104:

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

119:
120: EXCEPTION
121: WHEN OTHERS THEN
122: IF PG_DEBUG in ('Y', 'C') THEN
123: arp_util.debug('proc_before_validation: ' || 'Exception in checking if OKL is installed');
124: END IF;
125: l_okl_flag := 'N';
126: END;
127:

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

126: END;
127:
128: IF l_okl_flag = 'Y' THEN
129: IF PG_DEBUG in ('Y', 'C') THEN
130: arp_util.debug('proc_before_validation: ' || 'OKL is installed');
131: END IF;
132: g_okl_installed := TRUE;
133: END IF;
134:

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

175: out_insert_records := pub_insert_records;
176: END IF;
177:
178: IF PG_DEBUG in ('Y', 'C') THEN
179: arp_util.debug('arp_lockbox_hook_pvt.proc_before_validation()-');
180: END IF;
181: END proc_before_validation;
182: --
183: /*----------------------------------------------------------------------------

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

221: x_msg_data VARCHAR(2000);
222: --
223: BEGIN
224: IF PG_DEBUG in ('Y', 'C') THEN
225: arp_util.debug('proc_after_validation: ' || 'arp_lockbox_hook_pvt.proc_after_validation()+');
226: END IF;
227: IF nvl(arp_global.sysparam.ta_installed_flag,'N') = 'Y' THEN
228: -- Removed ARTA logic as functionality is obsolete in R12
229: -- See Bug 4936298

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

240: ',:6 ' ||
241: '); ' ||
242: 'END;';
243: IF PG_DEBUG in ('Y', 'C') THEN
244: arp_util.debug('Calling OKL proc_after_validation');
245: END IF;
246: 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;
247: IF PG_DEBUG in ('Y', 'C') THEN
248: arp_util.debug('Returned from OKL proc_after_validation');

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

244: arp_util.debug('Calling OKL proc_after_validation');
245: END IF;
246: 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;
247: IF PG_DEBUG in ('Y', 'C') THEN
248: arp_util.debug('Returned from OKL proc_after_validation');
249: END IF;
250: EXCEPTION
251: -- We ignore any error in OKL and
252: -- continue the process as if OKL is not installed

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

251: -- We ignore any error in OKL and
252: -- continue the process as if OKL is not installed
253: WHEN OTHERS THEN
254: IF PG_DEBUG in ('Y', 'C') THEN
255: arp_util.debug('Exception in OKL proc_after_validation');
256: END IF;
257: null;
258: END;
259: pvt_errorcode := 0;

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

296: out_insert_records := pub_insert_records;
297: END IF;
298:
299: IF PG_DEBUG in ('Y', 'C') THEN
300: arp_util.debug('proc_after_validation: ' || 'arp_lockbox_hook_pvt.proc_after_validation()-');
301: END IF;
302: END proc_after_validation;
303: --
304: /*----------------------------------------------------------------------------

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

322: pub_errorbuf varchar2(255);
323: pub_errorcode varchar2(255);
324: BEGIN
325: IF PG_DEBUG in ('Y', 'C') THEN
326: arp_util.debug('arp_lockbox_hook_pvt.proc_after_second_validation()+');
327: END IF;
328: IF nvl(arp_global.sysparam.ta_installed_flag,'N') = 'Y' THEN
329: -- Removed ARTA logic as functionality is obsolete in R12
330: -- See Bug 4936298

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

351: out_errorbuf := pvt_errorbuf;
352: END IF;
353:
354: IF PG_DEBUG in ('Y', 'C') THEN
355: arp_util.debug('arp_lockbox_hook_pvt.proc_after_second_validation()-');
356: END IF;
357: END proc_after_second_validation;
358: --
359: /*----------------------------------------------------------------------------

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

468: and b.requested_trans_format_id = a.transmission_format_id
469: and a.record_type_lookup_code in ('PAYMENT','OVRFLW PAYMENT') );
470: BEGIN
471: IF PG_DEBUG in ('Y', 'C') THEN
472: arp_util.debug('arp_lockbox_hook_pvt.proc_for_custom_llca()+');
473: END IF;
474: /* Check if the format includes batches */
475: BEGIN
476: SELECT distinct 'Y'

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

483: AND b.transmission_request_id = in_trans_req_id )
484: AND field_type_lookup_code = 'BATCH NAME';
485: EXCEPTION
486: WHEN NO_DATA_FOUND THEN
487: arp_util.debug('No batches present in the transmission');
488: l_batches := 'N';
489: END;
490: /* Get Pay_unrelated_invoices_Flag from ar_system_parameters */
491: BEGIN

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

717: * interface_line_details, if any. If a record failed in validation then a record is *
718: * inserted into ar_payments_interface for the matching number, which would eventually fail*
719: * in validation.
720: */
721: arp_util.debug('Number of Invoices inside custom code :' || l_last_invoice_index);
722: FOR i in 1..l_unres_invoice_index LOOP
723: k := 1;
724: DECLARE
725: l_resolved_array invoice_array;

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

724: DECLARE
725: l_resolved_array invoice_array;
726: BEGIN
727: FOR j in 1..l_last_invoice_index LOOP
728: arp_util.debug('For '|| l_unres_inv_array(i).matching_number);
729: arp_util.debug('And '|| l_invoice_array(j).matching_number);
730: arp_util.debug('And '|| l_invoice_array(j).invoice_number);
731: arp_util.debug('Size :'||l_resolved_array.last || 'K :' ||k);
732: IF l_unres_inv_array(i).matching_number = l_invoice_array(j).matching_number

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

725: l_resolved_array invoice_array;
726: BEGIN
727: FOR j in 1..l_last_invoice_index LOOP
728: arp_util.debug('For '|| l_unres_inv_array(i).matching_number);
729: arp_util.debug('And '|| l_invoice_array(j).matching_number);
730: arp_util.debug('And '|| l_invoice_array(j).invoice_number);
731: arp_util.debug('Size :'||l_resolved_array.last || 'K :' ||k);
732: IF l_unres_inv_array(i).matching_number = l_invoice_array(j).matching_number
733: AND l_unres_inv_array(i).item_number = l_invoice_array(j).item_number THEN

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

726: BEGIN
727: FOR j in 1..l_last_invoice_index LOOP
728: arp_util.debug('For '|| l_unres_inv_array(i).matching_number);
729: arp_util.debug('And '|| l_invoice_array(j).matching_number);
730: arp_util.debug('And '|| l_invoice_array(j).invoice_number);
731: arp_util.debug('Size :'||l_resolved_array.last || 'K :' ||k);
732: IF l_unres_inv_array(i).matching_number = l_invoice_array(j).matching_number
733: AND l_unres_inv_array(i).item_number = l_invoice_array(j).item_number THEN
734: IF l_batches = 'Y' THEN

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

727: FOR j in 1..l_last_invoice_index LOOP
728: arp_util.debug('For '|| l_unres_inv_array(i).matching_number);
729: arp_util.debug('And '|| l_invoice_array(j).matching_number);
730: arp_util.debug('And '|| l_invoice_array(j).invoice_number);
731: arp_util.debug('Size :'||l_resolved_array.last || 'K :' ||k);
732: IF l_unres_inv_array(i).matching_number = l_invoice_array(j).matching_number
733: AND l_unres_inv_array(i).item_number = l_invoice_array(j).item_number THEN
734: IF l_batches = 'Y' THEN
735: IF l_unres_inv_array(i).batch_name = l_invoice_array(j).batch_name THEN

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

758: END LOOP; /* End inner For */
759: l_res_invoice_index := l_resolved_array.last;
760: l_inv_precision := 0;
761:
762: arp_util.debug('Custom Number '||l_unres_inv_array(i).matching_number||' has been resolved into ');
763: arp_util.debug(nvl(l_res_invoice_index, 0)||' invoices.');
764:
765: IF l_res_invoice_index IS NOT NULL THEN
766: SELECT a

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

759: l_res_invoice_index := l_resolved_array.last;
760: l_inv_precision := 0;
761:
762: arp_util.debug('Custom Number '||l_unres_inv_array(i).matching_number||' has been resolved into ');
763: arp_util.debug(nvl(l_res_invoice_index, 0)||' invoices.');
764:
765: IF l_res_invoice_index IS NOT NULL THEN
766: SELECT a
767: INTO l_resolved_number

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

847: FOR j IN 1..l_res_invoice_index LOOP
848: IF (l_trans_to_receipt_rate IS NOT NULL
849: AND l_resolved_array(j).trans_to_receipt_rate IS NOT NULL
850: AND l_trans_to_receipt_rate <> l_resolved_array(j).trans_to_receipt_rate) THEN
851: arp_util.debug('Trans_to_receipt_rate cannot be different to the rate specified at the matching number.');
852: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
853: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
854: l_error_flag := 'T';
855: exit;

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

848: IF (l_trans_to_receipt_rate IS NOT NULL
849: AND l_resolved_array(j).trans_to_receipt_rate IS NOT NULL
850: AND l_trans_to_receipt_rate <> l_resolved_array(j).trans_to_receipt_rate) THEN
851: arp_util.debug('Trans_to_receipt_rate cannot be different to the rate specified at the matching number.');
852: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
853: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
854: l_error_flag := 'T';
855: exit;
856: END IF; /* End TTR check */

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

849: AND l_resolved_array(j).trans_to_receipt_rate IS NOT NULL
850: AND l_trans_to_receipt_rate <> l_resolved_array(j).trans_to_receipt_rate) THEN
851: arp_util.debug('Trans_to_receipt_rate cannot be different to the rate specified at the matching number.');
852: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
853: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
854: l_error_flag := 'T';
855: exit;
856: END IF; /* End TTR check */
857: IF (l_invoice_currency_code IS NOT NULL

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

856: END IF; /* End TTR check */
857: IF (l_invoice_currency_code IS NOT NULL
858: AND l_resolved_array(j).invoice_currency_code IS NOT NULL
859: AND l_invoice_currency_code <> l_resolved_array(j).invoice_currency_code) THEN
860: arp_util.debug('Invoice currency code cannot be different to the currency code specified at the matching number.');
861: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
862: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
863: l_error_flag := 'T';
864: exit;

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

857: IF (l_invoice_currency_code IS NOT NULL
858: AND l_resolved_array(j).invoice_currency_code IS NOT NULL
859: AND l_invoice_currency_code <> l_resolved_array(j).invoice_currency_code) THEN
860: arp_util.debug('Invoice currency code cannot be different to the currency code specified at the matching number.');
861: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
862: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
863: l_error_flag := 'T';
864: exit;
865: END IF; /* End currency code check */

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

858: AND l_resolved_array(j).invoice_currency_code IS NOT NULL
859: AND l_invoice_currency_code <> l_resolved_array(j).invoice_currency_code) THEN
860: arp_util.debug('Invoice currency code cannot be different to the currency code specified at the matching number.');
861: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
862: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
863: l_error_flag := 'T';
864: exit;
865: END IF; /* End currency code check */
866: END LOOP;

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

873: l_res_currency_code VARCHAR2(15);
874: l_currency_code1 VARCHAR2(15);
875: BEGIN
876: l_res_currency_code := trim(l_invoice_currency_code);
877: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
878: arp_util.debug('Currency Code '||l_res_currency_code);
879: FOR j in 1..l_res_invoice_index LOOP
880: SELECT distinct(invoice_currency_code)
881: INTO l_currency_code1

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

874: l_currency_code1 VARCHAR2(15);
875: BEGIN
876: l_res_currency_code := trim(l_invoice_currency_code);
877: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
878: arp_util.debug('Currency Code '||l_res_currency_code);
879: FOR j in 1..l_res_invoice_index LOOP
880: SELECT distinct(invoice_currency_code)
881: INTO l_currency_code1
882: FROM ar_payment_schedules ps,

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

910:
911: l_resolved_array(j).invoice_currency_code := trim(l_currency_code1);
912: l_res_currency_code := nvl(l_res_currency_code, trim(l_currency_code1));
913:
914: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
915: arp_util.debug('Currency Code '|| l_currency_code1);
916: IF l_res_currency_code <> trim(l_currency_code1) THEN
917: arp_util.debug('All Resolved invoices does not belong to the same currency for matching number '||l_invoice_array(i).matching_number);
918: l_error_flag := 'T';

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

911: l_resolved_array(j).invoice_currency_code := trim(l_currency_code1);
912: l_res_currency_code := nvl(l_res_currency_code, trim(l_currency_code1));
913:
914: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
915: arp_util.debug('Currency Code '|| l_currency_code1);
916: IF l_res_currency_code <> trim(l_currency_code1) THEN
917: arp_util.debug('All Resolved invoices does not belong to the same currency for matching number '||l_invoice_array(i).matching_number);
918: l_error_flag := 'T';
919: exit;

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

913:
914: arp_util.debug('For Resolved Number '||l_resolved_array(j).invoice_number);
915: arp_util.debug('Currency Code '|| l_currency_code1);
916: IF l_res_currency_code <> trim(l_currency_code1) THEN
917: arp_util.debug('All Resolved invoices does not belong to the same currency for matching number '||l_invoice_array(i).matching_number);
918: l_error_flag := 'T';
919: exit;
920: END IF;
921: l_invoice_currency_code := trim(l_currency_code1);

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

921: l_invoice_currency_code := trim(l_currency_code1);
922: END LOOP;
923: EXCEPTION
924: WHEN NO_DATA_FOUND THEN
925: arp_util.debug('Invalid Application Number '||l_resolved_array(j).invoice_number);
926: l_error_flag := 'T';
927: WHEN TOO_MANY_ROWS THEN
928: arp_util.debug('Too many applications exist with name '||l_resolved_array(j).invoice_number);
929: l_error_flag := 'T';

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

924: WHEN NO_DATA_FOUND THEN
925: arp_util.debug('Invalid Application Number '||l_resolved_array(j).invoice_number);
926: l_error_flag := 'T';
927: WHEN TOO_MANY_ROWS THEN
928: arp_util.debug('Too many applications exist with name '||l_resolved_array(j).invoice_number);
929: l_error_flag := 'T';
930: WHEN OTHERS THEN
931: arp_util.debug('Exception occured in resolving '||l_resolved_array(j).invoice_number);
932: arp_util.debug('Error Message '||SQLERRM);

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

927: WHEN TOO_MANY_ROWS THEN
928: arp_util.debug('Too many applications exist with name '||l_resolved_array(j).invoice_number);
929: l_error_flag := 'T';
930: WHEN OTHERS THEN
931: arp_util.debug('Exception occured in resolving '||l_resolved_array(j).invoice_number);
932: arp_util.debug('Error Message '||SQLERRM);
933: l_error_flag := 'T';
934: END; /* End check currency code when not provided */
935:

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

928: arp_util.debug('Too many applications exist with name '||l_resolved_array(j).invoice_number);
929: l_error_flag := 'T';
930: WHEN OTHERS THEN
931: arp_util.debug('Exception occured in resolving '||l_resolved_array(j).invoice_number);
932: arp_util.debug('Error Message '||SQLERRM);
933: l_error_flag := 'T';
934: END; /* End check currency code when not provided */
935:
936: IF l_error_flag <> 'T' AND l_invoice_currency_code IS NOT NULL THEN

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

949: nvl(l_resolved_array(j).amount_applied_from, 0);
950: END LOOP;
951: IF l_sum_amount_applied_from <> 0
952: AND l_sum_amount_applied_from <> l_amount_applied_from THEN
953: arp_util.debug('Sum of amount_applied_from at the resolved invoices is not equal to the amount_applied_from specified at matching number.');
954: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
955: l_error_flag := 'T';
956: END IF;
957: END IF;/* Check Sum of amount_applied_from */

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

950: END LOOP;
951: IF l_sum_amount_applied_from <> 0
952: AND l_sum_amount_applied_from <> l_amount_applied_from THEN
953: arp_util.debug('Sum of amount_applied_from at the resolved invoices is not equal to the amount_applied_from specified at matching number.');
954: arp_util.debug('For Matching Number '||l_unres_inv_array(i).matching_number);
955: l_error_flag := 'T';
956: END IF;
957: END IF;/* Check Sum of amount_applied_from */
958:

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

958:
959: /* Prorate Amount_applied_from to the resolved invoices if not provided in custom hook */
960: l_rem_amt_applied_from := nvl(l_amount_applied_from, 0);
961: IF l_error_flag <> 'T' THEN
962: arp_util.debug('Amount_applied_From '||l_amount_applied_from);
963: If l_amount_applied_from IS NOT NULL THEN
964: FOR j in 1..l_res_invoice_index LOOP
965: arp_util.debug('Prorating Amount_applied_from');
966: IF l_resolved_array(j).amount_applied_from IS NULL THEN

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

961: IF l_error_flag <> 'T' THEN
962: arp_util.debug('Amount_applied_From '||l_amount_applied_from);
963: If l_amount_applied_from IS NOT NULL THEN
964: FOR j in 1..l_res_invoice_index LOOP
965: arp_util.debug('Prorating Amount_applied_from');
966: IF l_resolved_array(j).amount_applied_from IS NULL THEN
967: l_resolved_array(j).amount_applied_from := ROUND(
968: (l_resolved_array(j).amount_applied/l_amount_applied)
969: *l_amount_applied_from);

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

984: SELECT ar_payments_interface_s.nextval
985: INTO l_transmission_rec_id_of
986: FROM dual;
987:
988: arp_util.debug('Validation failed for '||l_unres_inv_array(i).matching_number);
989:
990: /* The Exchange rate info provided at the matching number level does not match
991: with the details provided at the resolved invoice level. So insert the Custom
992: number into the interface tables instead of resolved numbers as an invalid

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

1096: FOR k IN 1..l_last_line_index LOOP
1097: IF l_resolved_array(j).invoice_number = l_line_array(k).invoice_number
1098: AND l_resolved_array(j).item_number = l_line_array(k).item_number
1099: AND NVL(l_resolved_array(j).batch_name, -1) = NVL(l_line_array(k).batch_name, -1)THEN
1100: arp_util.debug('Inserting lines for '|| l_resolved_array(j).invoice_number);
1101: INSERT INTO AR_PMTS_INTERFACE_LINE_DETAILS (
1102: status,
1103: transmission_request_id,
1104: transmission_record_id,

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

1192: END IF;
1193: END IF;
1194:
1195: IF PG_DEBUG in ('Y', 'C') THEN
1196: arp_util.debug('arp_lockbox_hook_pvt.proc_for_custom_llca()-');
1197: END IF;
1198: EXCEPTION
1199: WHEN OTHERS THEN
1200: IF PG_DEBUG in ('Y', 'C') THEN

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

1197: END IF;
1198: EXCEPTION
1199: WHEN OTHERS THEN
1200: IF PG_DEBUG in ('Y', 'C') THEN
1201: arp_util.debug('Exception in proc_for_custom_llca');
1202: arp_util.debug('Error : '||SQLERRM);
1203: fnd_file.put_line(fnd_file.log, 'Exception in proc_for_custom_llca');
1204: fnd_file.put_line(fnd_file.log, 'Error : '||SQLERRM);
1205: END IF;

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

1198: EXCEPTION
1199: WHEN OTHERS THEN
1200: IF PG_DEBUG in ('Y', 'C') THEN
1201: arp_util.debug('Exception in proc_for_custom_llca');
1202: arp_util.debug('Error : '||SQLERRM);
1203: fnd_file.put_line(fnd_file.log, 'Exception in proc_for_custom_llca');
1204: fnd_file.put_line(fnd_file.log, 'Error : '||SQLERRM);
1205: END IF;
1206: RAISE;