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.AR_IREC_APPLY_CREDITS dependencies on ARP_STANDARD

Line 165: arp_standard.debug(l_debug_info);

161: ----------------------------------------------------------------------------------------
162: l_debug_info := 'Fetch all transactions from Transaction List GT into Apply Credits GT';
163: -----------------------------------------------------------------------------------------
164: IF (PG_DEBUG = 'Y') THEN
165: arp_standard.debug(l_debug_info);
166: END IF;
167:
168: FOR trx IN transaction_list(p_customer_id,
169: p_customer_site_use_id,

Line 324: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

320:
321: EXCEPTION
322: WHEN OTHERS THEN
323: IF (PG_DEBUG = 'Y') THEN
324: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
325: arp_standard.debug('- Customer Id: '||p_customer_id);
326: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
327: arp_standard.debug('- Currency Code: '||p_currency_code);
328: arp_standard.debug('ERROR =>'|| SQLERRM);

Line 325: arp_standard.debug('- Customer Id: '||p_customer_id);

321: EXCEPTION
322: WHEN OTHERS THEN
323: IF (PG_DEBUG = 'Y') THEN
324: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
325: arp_standard.debug('- Customer Id: '||p_customer_id);
326: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
327: arp_standard.debug('- Currency Code: '||p_currency_code);
328: arp_standard.debug('ERROR =>'|| SQLERRM);
329: END IF;

Line 326: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);

322: WHEN OTHERS THEN
323: IF (PG_DEBUG = 'Y') THEN
324: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
325: arp_standard.debug('- Customer Id: '||p_customer_id);
326: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
327: arp_standard.debug('- Currency Code: '||p_currency_code);
328: arp_standard.debug('ERROR =>'|| SQLERRM);
329: END IF;
330:

Line 327: arp_standard.debug('- Currency Code: '||p_currency_code);

323: IF (PG_DEBUG = 'Y') THEN
324: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
325: arp_standard.debug('- Customer Id: '||p_customer_id);
326: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
327: arp_standard.debug('- Currency Code: '||p_currency_code);
328: arp_standard.debug('ERROR =>'|| SQLERRM);
329: END IF;
330:
331: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 328: arp_standard.debug('ERROR =>'|| SQLERRM);

324: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
325: arp_standard.debug('- Customer Id: '||p_customer_id);
326: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
327: arp_standard.debug('- Currency Code: '||p_currency_code);
328: arp_standard.debug('ERROR =>'|| SQLERRM);
329: END IF;
330:
331: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
332: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 503: arp_standard.debug(l_debug_info);

499: ----------------------------------------------------------------------------------------
500: l_debug_info := 'Populate the Apply Credits GT with the transaction';
501: -----------------------------------------------------------------------------------------
502: IF (PG_DEBUG = 'Y') THEN
503: arp_standard.debug(l_debug_info);
504: END IF;
505:
506: if(l_pay_for_cust_id is null) then
507: l_pay_for_cust_id := l_customer_id;

Line 650: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: IF (PG_DEBUG = 'Y') THEN
650: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
651: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
652: arp_standard.debug('ERROR =>'|| SQLERRM);
653: END IF;
654:

Line 651: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);

647: EXCEPTION
648: WHEN OTHERS THEN
649: IF (PG_DEBUG = 'Y') THEN
650: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
651: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
652: arp_standard.debug('ERROR =>'|| SQLERRM);
653: END IF;
654:
655: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 652: arp_standard.debug('ERROR =>'|| SQLERRM);

648: WHEN OTHERS THEN
649: IF (PG_DEBUG = 'Y') THEN
650: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
651: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
652: arp_standard.debug('ERROR =>'|| SQLERRM);
653: END IF;
654:
655: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
656: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 706: arp_standard.debug(l_debug_info);

702: ---------------------------------------------------------------------------
703: l_debug_info := 'Delete all debit transactions from Apply Credits GT';
704: ---------------------------------------------------------------------------
705: IF (PG_DEBUG = 'Y') THEN
706: arp_standard.debug(l_debug_info);
707: END IF;
708:
709: DELETE FROM ar_irec_apply_credit_gt
710: WHERE customer_id = p_customer_id

Line 724: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

720:
721: EXCEPTION
722: WHEN OTHERS THEN
723: IF (PG_DEBUG = 'Y') THEN
724: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
725: arp_standard.debug('- Customer Id: '||p_customer_id);
726: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
727: arp_standard.debug('- Currency Code: '||p_currency_code);
728: arp_standard.debug('ERROR =>'|| SQLERRM);

Line 725: arp_standard.debug('- Customer Id: '||p_customer_id);

721: EXCEPTION
722: WHEN OTHERS THEN
723: IF (PG_DEBUG = 'Y') THEN
724: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
725: arp_standard.debug('- Customer Id: '||p_customer_id);
726: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
727: arp_standard.debug('- Currency Code: '||p_currency_code);
728: arp_standard.debug('ERROR =>'|| SQLERRM);
729: END IF;

Line 726: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);

722: WHEN OTHERS THEN
723: IF (PG_DEBUG = 'Y') THEN
724: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
725: arp_standard.debug('- Customer Id: '||p_customer_id);
726: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
727: arp_standard.debug('- Currency Code: '||p_currency_code);
728: arp_standard.debug('ERROR =>'|| SQLERRM);
729: END IF;
730:

Line 727: arp_standard.debug('- Currency Code: '||p_currency_code);

723: IF (PG_DEBUG = 'Y') THEN
724: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
725: arp_standard.debug('- Customer Id: '||p_customer_id);
726: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
727: arp_standard.debug('- Currency Code: '||p_currency_code);
728: arp_standard.debug('ERROR =>'|| SQLERRM);
729: END IF;
730:
731: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 728: arp_standard.debug('ERROR =>'|| SQLERRM);

724: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
725: arp_standard.debug('- Customer Id: '||p_customer_id);
726: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
727: arp_standard.debug('- Currency Code: '||p_currency_code);
728: arp_standard.debug('ERROR =>'|| SQLERRM);
729: END IF;
730:
731: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
732: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 782: arp_standard.debug(l_debug_info);

778: ---------------------------------------------------------------------------
779: l_debug_info := 'Delete all credit transactions from Apply Credits GT';
780: ---------------------------------------------------------------------------
781: IF (PG_DEBUG = 'Y') THEN
782: arp_standard.debug(l_debug_info);
783: END IF;
784:
785: DELETE FROM ar_irec_apply_credit_gt
786: WHERE customer_id = p_customer_id

Line 798: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

794:
795: EXCEPTION
796: WHEN OTHERS THEN
797: IF (PG_DEBUG = 'Y') THEN
798: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
799: arp_standard.debug('- Customer Id: '||p_customer_id);
800: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
801: arp_standard.debug('- Currency Code: '||p_currency_code);
802: arp_standard.debug('ERROR =>'|| SQLERRM);

Line 799: arp_standard.debug('- Customer Id: '||p_customer_id);

795: EXCEPTION
796: WHEN OTHERS THEN
797: IF (PG_DEBUG = 'Y') THEN
798: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
799: arp_standard.debug('- Customer Id: '||p_customer_id);
800: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
801: arp_standard.debug('- Currency Code: '||p_currency_code);
802: arp_standard.debug('ERROR =>'|| SQLERRM);
803: END IF;

Line 800: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);

796: WHEN OTHERS THEN
797: IF (PG_DEBUG = 'Y') THEN
798: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
799: arp_standard.debug('- Customer Id: '||p_customer_id);
800: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
801: arp_standard.debug('- Currency Code: '||p_currency_code);
802: arp_standard.debug('ERROR =>'|| SQLERRM);
803: END IF;
804:

Line 801: arp_standard.debug('- Currency Code: '||p_currency_code);

797: IF (PG_DEBUG = 'Y') THEN
798: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
799: arp_standard.debug('- Customer Id: '||p_customer_id);
800: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
801: arp_standard.debug('- Currency Code: '||p_currency_code);
802: arp_standard.debug('ERROR =>'|| SQLERRM);
803: END IF;
804:
805: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 802: arp_standard.debug('ERROR =>'|| SQLERRM);

798: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
799: arp_standard.debug('- Customer Id: '||p_customer_id);
800: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
801: arp_standard.debug('- Currency Code: '||p_currency_code);
802: arp_standard.debug('ERROR =>'|| SQLERRM);
803: END IF;
804:
805: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
806: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 851: arp_standard.debug(l_debug_info);

847: ---------------------------------------------------------------------------
848: l_debug_info := 'Delete the transaction from Apply Credits GT';
849: ---------------------------------------------------------------------------
850: IF (PG_DEBUG = 'Y') THEN
851: arp_standard.debug(l_debug_info);
852: END IF;
853:
854: DELETE FROM ar_irec_apply_credit_gt
855: WHERE payment_schedule_id = p_payment_schedule_id;

Line 862: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

858:
859: EXCEPTION
860: WHEN OTHERS THEN
861: IF (PG_DEBUG = 'Y') THEN
862: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
863: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
864: arp_standard.debug('ERROR =>'|| SQLERRM);
865: END IF;
866:

Line 863: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);

859: EXCEPTION
860: WHEN OTHERS THEN
861: IF (PG_DEBUG = 'Y') THEN
862: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
863: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
864: arp_standard.debug('ERROR =>'|| SQLERRM);
865: END IF;
866:
867: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 864: arp_standard.debug('ERROR =>'|| SQLERRM);

860: WHEN OTHERS THEN
861: IF (PG_DEBUG = 'Y') THEN
862: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
863: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
864: arp_standard.debug('ERROR =>'|| SQLERRM);
865: END IF;
866:
867: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
868: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 918: arp_standard.debug(l_debug_info);

914: ---------------------------------------------------------------------------
915: l_debug_info := 'Delete all transactions from Apply Credits GT';
916: ---------------------------------------------------------------------------
917: IF (PG_DEBUG = 'Y') THEN
918: arp_standard.debug(l_debug_info);
919: END IF;
920: -- Bug 5076215 - Apply Credits GT contains data related to the customer and its related customer,
921: -- the related customer transactions are not getting cleared. Since GT contains only session specific data removed the where condition.
922: DELETE FROM ar_irec_apply_credit_gt;

Line 928: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

924:
925: EXCEPTION
926: WHEN OTHERS THEN
927: IF (PG_DEBUG = 'Y') THEN
928: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
929: arp_standard.debug('- Customer Id: '||p_customer_id);
930: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
931: arp_standard.debug('- Currency Code: '||p_currency_code);
932: arp_standard.debug('ERROR =>'|| SQLERRM);

Line 929: arp_standard.debug('- Customer Id: '||p_customer_id);

925: EXCEPTION
926: WHEN OTHERS THEN
927: IF (PG_DEBUG = 'Y') THEN
928: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
929: arp_standard.debug('- Customer Id: '||p_customer_id);
930: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
931: arp_standard.debug('- Currency Code: '||p_currency_code);
932: arp_standard.debug('ERROR =>'|| SQLERRM);
933: END IF;

Line 930: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);

926: WHEN OTHERS THEN
927: IF (PG_DEBUG = 'Y') THEN
928: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
929: arp_standard.debug('- Customer Id: '||p_customer_id);
930: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
931: arp_standard.debug('- Currency Code: '||p_currency_code);
932: arp_standard.debug('ERROR =>'|| SQLERRM);
933: END IF;
934:

Line 931: arp_standard.debug('- Currency Code: '||p_currency_code);

927: IF (PG_DEBUG = 'Y') THEN
928: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
929: arp_standard.debug('- Customer Id: '||p_customer_id);
930: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
931: arp_standard.debug('- Currency Code: '||p_currency_code);
932: arp_standard.debug('ERROR =>'|| SQLERRM);
933: END IF;
934:
935: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 932: arp_standard.debug('ERROR =>'|| SQLERRM);

928: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
929: arp_standard.debug('- Customer Id: '||p_customer_id);
930: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
931: arp_standard.debug('- Currency Code: '||p_currency_code);
932: arp_standard.debug('ERROR =>'|| SQLERRM);
933: END IF;
934:
935: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
936: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 1011: arp_standard.debug(l_debug_info);

1007: ---------------------------------------------------------------------------
1008: l_debug_info := 'Apply credits on credit memo';
1009: ---------------------------------------------------------------------------
1010: IF (PG_DEBUG = 'Y') THEN
1011: arp_standard.debug(l_debug_info);
1012: END IF;
1013: apply_credits_on_credit_memo(p_currency_code,
1014: x_open_invoices_status,
1015: x_dup_appln_dbt_psid,

Line 1026: arp_standard.debug(l_debug_info);

1022: ---------------------------------------------------------------------------
1023: l_debug_info := 'Apply credits on payment';
1024: ---------------------------------------------------------------------------
1025: IF (PG_DEBUG = 'Y') THEN
1026: arp_standard.debug(l_debug_info);
1027: END IF;
1028: apply_credits_on_payment( p_currency_code,
1029: x_open_invoices_status,
1030: x_dup_appln_dbt_psid,

Line 1046: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

1042:
1043: EXCEPTION
1044: WHEN OTHERS THEN
1045: IF (PG_DEBUG = 'Y') THEN
1046: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1047: arp_standard.debug('- Customer Id: '||p_customer_id);
1048: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
1049: arp_standard.debug('- Currency Code: '||p_currency_code);
1050: arp_standard.debug('ERROR =>'|| SQLERRM);

Line 1047: arp_standard.debug('- Customer Id: '||p_customer_id);

1043: EXCEPTION
1044: WHEN OTHERS THEN
1045: IF (PG_DEBUG = 'Y') THEN
1046: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1047: arp_standard.debug('- Customer Id: '||p_customer_id);
1048: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
1049: arp_standard.debug('- Currency Code: '||p_currency_code);
1050: arp_standard.debug('ERROR =>'|| SQLERRM);
1051: END IF;

Line 1048: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);

1044: WHEN OTHERS THEN
1045: IF (PG_DEBUG = 'Y') THEN
1046: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1047: arp_standard.debug('- Customer Id: '||p_customer_id);
1048: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
1049: arp_standard.debug('- Currency Code: '||p_currency_code);
1050: arp_standard.debug('ERROR =>'|| SQLERRM);
1051: END IF;
1052:

Line 1049: arp_standard.debug('- Currency Code: '||p_currency_code);

1045: IF (PG_DEBUG = 'Y') THEN
1046: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1047: arp_standard.debug('- Customer Id: '||p_customer_id);
1048: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
1049: arp_standard.debug('- Currency Code: '||p_currency_code);
1050: arp_standard.debug('ERROR =>'|| SQLERRM);
1051: END IF;
1052:
1053: IF(PG_DIAGNOSTICS = 'Y') THEN

Line 1050: arp_standard.debug('ERROR =>'|| SQLERRM);

1046: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1047: arp_standard.debug('- Customer Id: '||p_customer_id);
1048: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
1049: arp_standard.debug('- Currency Code: '||p_currency_code);
1050: arp_standard.debug('ERROR =>'|| SQLERRM);
1051: END IF;
1052:
1053: IF(PG_DIAGNOSTICS = 'Y') THEN
1054: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 1204: arp_standard.debug(l_debug_info);

1200: --------------------------------------------------------------------------------
1201: l_debug_info := 'Get the credit transaction to apply other transactions against';
1202: --------------------------------------------------------------------------------
1203: IF (PG_DEBUG = 'Y') THEN
1204: arp_standard.debug(l_debug_info);
1205: END IF;
1206: select_credit_to_apply( p_currency_code => p_currency_code,
1207: x_return_status => x_return_status,
1208: x_credit_ps_id => x_dup_appln_crdt_psid,

Line 1218: arp_standard.debug(l_debug_info);

1214: ---------------------------------------------------------------------------
1215: l_debug_info := 'An unexpected error has occurred while finding the credit';
1216: ---------------------------------------------------------------------------
1217: IF (PG_DEBUG = 'Y') THEN
1218: arp_standard.debug(l_debug_info);
1219: END IF;
1220: APP_EXCEPTION.raise_exception;
1221: ELSE
1222: ---------------------------------------------------------------------------

Line 1226: arp_standard.debug(l_debug_info);

1222: ---------------------------------------------------------------------------
1223: l_debug_info := 'Duplicate application error';
1224: ---------------------------------------------------------------------------
1225: IF (PG_DEBUG = 'Y') THEN
1226: arp_standard.debug(l_debug_info);
1227: END IF;
1228:
1229: ROLLBACK TO ARI_APPLY_CREDITS_PMT;
1230:

Line 1245: arp_standard.debug(l_debug_info);

1241: ---------------------------------------------------------------------------
1242: l_debug_info := 'Find cash receipt id';
1243: ---------------------------------------------------------------------------
1244: IF (PG_DEBUG = 'Y') THEN
1245: arp_standard.debug(l_debug_info);
1246: END IF;
1247: OPEN find_cash_receipt(x_dup_appln_crdt_psid);
1248: FETCH find_cash_receipt INTO find_cash_receipt_record;
1249: IF (find_cash_receipt%FOUND) THEN

Line 1263: arp_standard.debug(l_debug_info);

1259: ----------------------------------------------------------------------------------
1260: l_debug_info := 'Apply credits against the selected payment';
1261: ----------------------------------------------------------------------------------
1262: IF (PG_DEBUG = 'Y') THEN
1263: arp_standard.debug(l_debug_info);
1264: END IF;
1265:
1266: FOR credit_trx_record in credit_transactions(p_currency_code)
1267: LOOP

Line 1272: arp_standard.debug('-------Credit Transaction Information------');

1268: --If this is the credit transaction selected to be applied against, do not do anything.
1269: IF (credit_trx_record.payment_schedule_id <> x_dup_appln_crdt_psid) THEN
1270:
1271: IF (PG_DEBUG = 'Y') THEN
1272: arp_standard.debug('-------Credit Transaction Information------');
1273: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);

Line 1273: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);

1269: IF (credit_trx_record.payment_schedule_id <> x_dup_appln_crdt_psid) THEN
1270:
1271: IF (PG_DEBUG = 'Y') THEN
1272: arp_standard.debug('-------Credit Transaction Information------');
1273: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);

Line 1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);

1270:
1271: IF (PG_DEBUG = 'Y') THEN
1272: arp_standard.debug('-------Credit Transaction Information------');
1273: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);

Line 1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);

1271: IF (PG_DEBUG = 'Y') THEN
1272: arp_standard.debug('-------Credit Transaction Information------');
1273: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);

Line 1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);

1272: arp_standard.debug('-------Credit Transaction Information------');
1273: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);

Line 1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);

1273: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);

Line 1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);

1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);

Line 1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);

1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);

Line 1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);

1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);

Line 1281: arp_standard.debug('Status: ' || credit_trx_record.status);

1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);

Line 1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);

1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);

Line 1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);

1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);

Line 1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);

1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);

Line 1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);

1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);

Line 1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);

1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);

Line 1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);

1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1291: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);

Line 1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);

1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1291: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1292: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);

Line 1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);

1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1291: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1292: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1293: END IF;

Line 1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);

1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1291: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1292: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1293: END IF;
1294:

Line 1291: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);

1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1291: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1292: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1293: END IF;
1294:
1295: IF (credit_trx_record.trx_class = 'CM') THEN

Line 1292: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);

1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1291: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1292: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1293: END IF;
1294:
1295: IF (credit_trx_record.trx_class = 'CM') THEN
1296: ----------------------------------------------------------------------------------

Line 1300: arp_standard.debug(l_debug_info);

1296: ----------------------------------------------------------------------------------
1297: l_debug_info := 'Apply credit memo against selected payment';
1298: ----------------------------------------------------------------------------------
1299: IF (PG_DEBUG = 'Y') THEN
1300: arp_standard.debug(l_debug_info);
1301: END IF;
1302:
1303: AR_RECEIPT_API_PUB.apply(
1304: p_api_version => 1.0,

Line 1325: arp_standard.debug(l_debug_info);

1321: ----------------------------------------------------------------------------------
1322: l_debug_info := 'Apply payment against selected payment';
1323: ----------------------------------------------------------------------------------
1324: IF (PG_DEBUG = 'Y') THEN
1325: arp_standard.debug(l_debug_info);
1326: END IF;
1327:
1328: AR_RECEIPT_API_PUB.apply_open_receipt
1329: (p_api_version => 1.0,

Line 1367: arp_standard.debug(l_debug_info);

1363: ----------------------------------------------------------------------------------
1364: l_debug_info := 'Apply invoices against the selected payment';
1365: ----------------------------------------------------------------------------------
1366: IF (PG_DEBUG = 'Y') THEN
1367: arp_standard.debug(l_debug_info);
1368: END IF;
1369:
1370: FOR debit_trx_record in debit_transactions(p_currency_code)
1371: LOOP

Line 1373: arp_standard.debug('-------Debit Transaction Information------');

1369:
1370: FOR debit_trx_record in debit_transactions(p_currency_code)
1371: LOOP
1372: IF (PG_DEBUG = 'Y') THEN
1373: arp_standard.debug('-------Debit Transaction Information------');
1374: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);

Line 1374: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);

1370: FOR debit_trx_record in debit_transactions(p_currency_code)
1371: LOOP
1372: IF (PG_DEBUG = 'Y') THEN
1373: arp_standard.debug('-------Debit Transaction Information------');
1374: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);

Line 1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);

1371: LOOP
1372: IF (PG_DEBUG = 'Y') THEN
1373: arp_standard.debug('-------Debit Transaction Information------');
1374: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);

Line 1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);

1372: IF (PG_DEBUG = 'Y') THEN
1373: arp_standard.debug('-------Debit Transaction Information------');
1374: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);

Line 1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);

1373: arp_standard.debug('-------Debit Transaction Information------');
1374: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);

Line 1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);

1374: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);

Line 1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);

1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);

Line 1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);

1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);

Line 1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);

1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);

Line 1382: arp_standard.debug('Status: ' || debit_trx_record.status);

1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);

Line 1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);

1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);

Line 1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);

1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);

Line 1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);

1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);

Line 1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);

1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);

Line 1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);

1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);

Line 1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);

1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1392: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);

Line 1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);

1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1392: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1393: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);

Line 1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);

1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1392: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1393: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1394: END IF;

Line 1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);

1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1392: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1393: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1394: END IF;
1395:

Line 1392: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);

1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1392: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1393: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1394: END IF;
1395:
1396: IF (x_open_invoices_status = 'N') THEN

Line 1393: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);

1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1392: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1393: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1394: END IF;
1395:
1396: IF (x_open_invoices_status = 'N') THEN
1397: ----------------------------------------------------------------------------------

Line 1401: arp_standard.debug(l_debug_info);

1397: ----------------------------------------------------------------------------------
1398: l_debug_info := 'Check if invoice will remain open after the application';
1399: ----------------------------------------------------------------------------------
1400: IF (PG_DEBUG = 'Y') THEN
1401: arp_standard.debug(l_debug_info);
1402: END IF;
1403:
1404: IF (debit_trx_record.amount_due_remaining
1405: - ( debit_trx_record.discount_amount + debit_trx_record.application_amount) > 0) THEN

Line 1414: arp_standard.debug(l_debug_info);

1410: ----------------------------------------------------------------------------------
1411: l_debug_info := 'Apply invoice against selected payment';
1412: ----------------------------------------------------------------------------------
1413: IF (PG_DEBUG = 'Y') THEN
1414: arp_standard.debug(l_debug_info);
1415: END IF;
1416:
1417: AR_RECEIPT_API_PUB.apply(
1418: p_api_version => 1.0,

Line 1450: arp_standard.debug(l_debug_info);

1446: ---------------------------------------------------------------------------
1447: l_debug_info := 'Close the credit and debit cursors';
1448: ---------------------------------------------------------------------------
1449: IF (PG_DEBUG = 'Y') THEN
1450: arp_standard.debug(l_debug_info);
1451: END IF;
1452:
1453: COMMIT;
1454:

Line 1460: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

1456:
1457: EXCEPTION
1458: WHEN OTHERS THEN
1459: IF (PG_DEBUG = 'Y') THEN
1460: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1461: arp_standard.debug('- Currency Code: '||p_currency_code);
1462: arp_standard.debug('ERROR =>'|| SQLERRM);
1463: END IF;
1464:

Line 1461: arp_standard.debug('- Currency Code: '||p_currency_code);

1457: EXCEPTION
1458: WHEN OTHERS THEN
1459: IF (PG_DEBUG = 'Y') THEN
1460: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1461: arp_standard.debug('- Currency Code: '||p_currency_code);
1462: arp_standard.debug('ERROR =>'|| SQLERRM);
1463: END IF;
1464:
1465: IF(PG_DIAGNOSTICS = 'Y') THEN

Line 1462: arp_standard.debug('ERROR =>'|| SQLERRM);

1458: WHEN OTHERS THEN
1459: IF (PG_DEBUG = 'Y') THEN
1460: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1461: arp_standard.debug('- Currency Code: '||p_currency_code);
1462: arp_standard.debug('ERROR =>'|| SQLERRM);
1463: END IF;
1464:
1465: IF(PG_DIAGNOSTICS = 'Y') THEN
1466: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 1624: arp_standard.debug(l_debug_info);

1620: ---------------------------------------------------------------------------
1621: l_debug_info := 'Open the credit and debit cursors';
1622: ---------------------------------------------------------------------------
1623: IF (PG_DEBUG = 'Y') THEN
1624: arp_standard.debug(l_debug_info);
1625: END IF;
1626: OPEN debit_transactions(p_currency_code);
1627: OPEN credit_transactions(p_currency_code);
1628:

Line 1634: arp_standard.debug(l_debug_info);

1630: ---------------------------------------------------------------------------
1631: l_debug_info := 'Fetch debit and credit transactions';
1632: ---------------------------------------------------------------------------
1633: IF (PG_DEBUG = 'Y') THEN
1634: arp_standard.debug(l_debug_info);
1635: END IF;
1636:
1637: IF (l_next_transaction = 'DEBIT') THEN
1638: FETCH debit_transactions INTO debit_trx_record;

Line 1683: arp_standard.debug('-------Debit Transaction Information------');

1679:
1680: END IF;
1681:
1682: IF (PG_DEBUG = 'Y') THEN
1683: arp_standard.debug('-------Debit Transaction Information------');
1684: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);

Line 1684: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);

1680: END IF;
1681:
1682: IF (PG_DEBUG = 'Y') THEN
1683: arp_standard.debug('-------Debit Transaction Information------');
1684: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);

Line 1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);

1681:
1682: IF (PG_DEBUG = 'Y') THEN
1683: arp_standard.debug('-------Debit Transaction Information------');
1684: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);

Line 1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);

1682: IF (PG_DEBUG = 'Y') THEN
1683: arp_standard.debug('-------Debit Transaction Information------');
1684: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);

Line 1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);

1683: arp_standard.debug('-------Debit Transaction Information------');
1684: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);

Line 1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);

1684: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);

Line 1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);

1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);

Line 1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);

1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);

Line 1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);

1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);

Line 1692: arp_standard.debug('Status: ' || debit_trx_record.status);

1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);

Line 1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);

1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);

Line 1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);

1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);

Line 1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);

1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);

Line 1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);

1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);

Line 1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);

1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);

Line 1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);

1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);

Line 1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);

1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);

Line 1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);

1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');

Line 1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);

1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);

Line 1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);

1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);

Line 1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);

1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);

Line 1704: arp_standard.debug('-------Credit Transaction Information------');

1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);

Line 1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);

1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);

Line 1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);

1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);

Line 1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);

1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);

Line 1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);

1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);

Line 1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);

1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);

Line 1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);

1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);

Line 1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);

1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);

Line 1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);

1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);

Line 1713: arp_standard.debug('Status: ' || credit_trx_record.status);

1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);

Line 1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);

1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);

Line 1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);

1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);

Line 1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);

1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);

Line 1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);

1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);

Line 1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);

1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);

Line 1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);

1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1723: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);

Line 1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);

1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1723: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1724: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);

Line 1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);

1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1723: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1724: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1725: END IF;

Line 1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);

1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1723: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1724: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1725: END IF;
1726:

Line 1723: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);

1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1723: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1724: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1725: END IF;
1726:
1727: -- Bug 4103527 - Display error icons for duplicate application

Line 1724: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);

1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1723: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1724: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1725: END IF;
1726:
1727: -- Bug 4103527 - Display error icons for duplicate application
1728: BEGIN

Line 1760: arp_standard.debug(l_debug_info);

1756: ---------------------------------------------------------------------------
1757: l_debug_info := 'Apply credit memo against the debit transaction';
1758: ---------------------------------------------------------------------------
1759: IF (PG_DEBUG = 'Y') THEN
1760: arp_standard.debug(l_debug_info);
1761: END IF;
1762:
1763: --Bug 4042557: Fetch the GL date for the credit memo
1764: select trunc(gl_date), trunc(trx_date)

Line 1870: arp_standard.debug(l_debug_info);

1866: ---------------------------------------------------------------------------
1867: l_debug_info := 'Apply receipt against the debit transaction';
1868: ---------------------------------------------------------------------------
1869: IF (PG_DEBUG = 'Y') THEN
1870: arp_standard.debug(l_debug_info);
1871: END IF;
1872: AR_RECEIPT_API_PUB.apply(
1873: p_api_version => 1.0,
1874: p_init_msg_list => FND_API.G_TRUE,

Line 1905: arp_standard.debug(l_debug_info);

1901: ---------------------------------------------------------------------------
1902: l_debug_info := 'Close the credit and debit cursors';
1903: ---------------------------------------------------------------------------
1904: IF (PG_DEBUG = 'Y') THEN
1905: arp_standard.debug(l_debug_info);
1906: END IF;
1907: CLOSE credit_transactions;
1908: CLOSE debit_transactions;
1909:

Line 1917: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

1913:
1914: EXCEPTION
1915: WHEN OTHERS THEN
1916: IF (PG_DEBUG = 'Y') THEN
1917: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1918: arp_standard.debug('- Currency Code: '||p_currency_code);
1919: arp_standard.debug('ERROR =>'|| SQLERRM);
1920: END IF;
1921:

Line 1918: arp_standard.debug('- Currency Code: '||p_currency_code);

1914: EXCEPTION
1915: WHEN OTHERS THEN
1916: IF (PG_DEBUG = 'Y') THEN
1917: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1918: arp_standard.debug('- Currency Code: '||p_currency_code);
1919: arp_standard.debug('ERROR =>'|| SQLERRM);
1920: END IF;
1921:
1922: IF(PG_DIAGNOSTICS = 'Y') THEN

Line 1919: arp_standard.debug('ERROR =>'|| SQLERRM);

1915: WHEN OTHERS THEN
1916: IF (PG_DEBUG = 'Y') THEN
1917: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1918: arp_standard.debug('- Currency Code: '||p_currency_code);
1919: arp_standard.debug('ERROR =>'|| SQLERRM);
1920: END IF;
1921:
1922: IF(PG_DIAGNOSTICS = 'Y') THEN
1923: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 1999: arp_standard.debug(l_debug_info);

1995: ----------------------------------------------------------------------------------------
1996: l_debug_info := 'Clear the Transaction List GT for the active customer, site, currency code';
1997: -----------------------------------------------------------------------------------------
1998: IF (PG_DEBUG = 'Y') THEN
1999: arp_standard.debug(l_debug_info);
2000: END IF;
2001:
2002: DELETE FROM AR_IREC_PAYMENT_LIST_GT
2003: WHERE CUSTOMER_ID = p_customer_id

Line 2011: arp_standard.debug(l_debug_info);

2007: ----------------------------------------------------------------------------------------
2008: l_debug_info := 'Fetch open debits from Apply Credits GT into Transaction List GT';
2009: -----------------------------------------------------------------------------------------
2010: IF (PG_DEBUG = 'Y') THEN
2011: arp_standard.debug(l_debug_info);
2012: END IF;
2013:
2014: FOR trx IN open_debits_list(p_customer_id,
2015: p_customer_site_use_id,

Line 2031: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

2027:
2028: EXCEPTION
2029: WHEN OTHERS THEN
2030: IF (PG_DEBUG = 'Y') THEN
2031: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2032: arp_standard.debug('- Customer Id: '||p_customer_id);
2033: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2034: arp_standard.debug('- Currency Code: '||p_currency_code);
2035: arp_standard.debug('ERROR =>'|| SQLERRM);

Line 2032: arp_standard.debug('- Customer Id: '||p_customer_id);

2028: EXCEPTION
2029: WHEN OTHERS THEN
2030: IF (PG_DEBUG = 'Y') THEN
2031: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2032: arp_standard.debug('- Customer Id: '||p_customer_id);
2033: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2034: arp_standard.debug('- Currency Code: '||p_currency_code);
2035: arp_standard.debug('ERROR =>'|| SQLERRM);
2036: END IF;

Line 2033: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);

2029: WHEN OTHERS THEN
2030: IF (PG_DEBUG = 'Y') THEN
2031: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2032: arp_standard.debug('- Customer Id: '||p_customer_id);
2033: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2034: arp_standard.debug('- Currency Code: '||p_currency_code);
2035: arp_standard.debug('ERROR =>'|| SQLERRM);
2036: END IF;
2037:

Line 2034: arp_standard.debug('- Currency Code: '||p_currency_code);

2030: IF (PG_DEBUG = 'Y') THEN
2031: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2032: arp_standard.debug('- Customer Id: '||p_customer_id);
2033: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2034: arp_standard.debug('- Currency Code: '||p_currency_code);
2035: arp_standard.debug('ERROR =>'|| SQLERRM);
2036: END IF;
2037:
2038: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 2035: arp_standard.debug('ERROR =>'|| SQLERRM);

2031: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2032: arp_standard.debug('- Customer Id: '||p_customer_id);
2033: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2034: arp_standard.debug('- Currency Code: '||p_currency_code);
2035: arp_standard.debug('ERROR =>'|| SQLERRM);
2036: END IF;
2037:
2038: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2039: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 2147: arp_standard.debug(l_debug_info);

2143: ---------------------------------------------------------------------------
2144: l_debug_info := 'Open the cursor to select credit to apply';
2145: ---------------------------------------------------------------------------
2146: IF (PG_DEBUG = 'Y') THEN
2147: arp_standard.debug(l_debug_info);
2148: END IF;
2149:
2150: OPEN credit_to_apply(p_currency_code);
2151: FETCH credit_to_apply INTO x_credit_ps_id;

Line 2160: arp_standard.debug(l_debug_info);

2156: ---------------------------------------------------------------------------
2157: l_debug_info := 'Open the cursor to return duplicate application transactions';
2158: ---------------------------------------------------------------------------
2159: IF (PG_DEBUG = 'Y') THEN
2160: arp_standard.debug(l_debug_info);
2161: END IF;
2162: OPEN duplicate_application(p_currency_code);
2163: FETCH duplicate_application INTO duplicate_application_record;
2164:

Line 2170: arp_standard.debug(l_debug_info);

2166: ---------------------------------------------------------------------------
2167: l_debug_info := 'If a record is found, return the credit and debit transaction';
2168: ---------------------------------------------------------------------------
2169: IF (PG_DEBUG = 'Y') THEN
2170: arp_standard.debug(l_debug_info);
2171: END IF;
2172:
2173: x_credit_ps_id := duplicate_application_record.payment_schedule_id;
2174: x_debit_ps_id := duplicate_application_record.applied_payment_schedule_id;

Line 2187: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

2183:
2184: EXCEPTION
2185: WHEN OTHERS THEN
2186: IF (PG_DEBUG = 'Y') THEN
2187: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2188: arp_standard.debug('- Currency Code: '||p_currency_code);
2189: arp_standard.debug('ERROR =>'|| SQLERRM);
2190: END IF;
2191:

Line 2188: arp_standard.debug('- Currency Code: '||p_currency_code);

2184: EXCEPTION
2185: WHEN OTHERS THEN
2186: IF (PG_DEBUG = 'Y') THEN
2187: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2188: arp_standard.debug('- Currency Code: '||p_currency_code);
2189: arp_standard.debug('ERROR =>'|| SQLERRM);
2190: END IF;
2191:
2192: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 2189: arp_standard.debug('ERROR =>'|| SQLERRM);

2185: WHEN OTHERS THEN
2186: IF (PG_DEBUG = 'Y') THEN
2187: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2188: arp_standard.debug('- Currency Code: '||p_currency_code);
2189: arp_standard.debug('ERROR =>'|| SQLERRM);
2190: END IF;
2191:
2192: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2193: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);