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 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 1205: arp_standard.debug(l_debug_info);

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

Line 1220: arp_standard.debug(l_debug_info);

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

Line 1228: arp_standard.debug(l_debug_info);

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

Line 1249: arp_standard.debug(l_debug_info);

1245: ---------------------------------------------------------------------------
1246:
1247:
1248: IF (PG_DEBUG = 'Y') THEN
1249: arp_standard.debug(l_debug_info);
1250: END IF;
1251: OPEN find_cash_receipt(x_dup_appln_crdt_psid);
1252: FETCH find_cash_receipt INTO find_cash_receipt_record;
1253: IF (find_cash_receipt%FOUND) THEN

Line 1267: arp_standard.debug(l_debug_info);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1304: arp_standard.debug(l_debug_info);

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

Line 1329: arp_standard.debug(l_debug_info);

1325: ----------------------------------------------------------------------------------
1326: l_debug_info := 'Apply payment against selected payment';
1327: ----------------------------------------------------------------------------------
1328: IF (PG_DEBUG = 'Y') THEN
1329: arp_standard.debug(l_debug_info);
1330: END IF;
1331:
1332: AR_RECEIPT_API_PUB.apply_open_receipt
1333: (p_api_version => 1.0,

Line 1371: arp_standard.debug(l_debug_info);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1405: arp_standard.debug(l_debug_info);

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

Line 1418: arp_standard.debug(l_debug_info);

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

Line 1454: arp_standard.debug(l_debug_info);

1450: ---------------------------------------------------------------------------
1451: l_debug_info := 'Close the credit and debit cursors';
1452: ---------------------------------------------------------------------------
1453: IF (PG_DEBUG = 'Y') THEN
1454: arp_standard.debug(l_debug_info);
1455: END IF;
1456:
1457: COMMIT;
1458:

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

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

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

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

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

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

Line 1628: arp_standard.debug(l_debug_info);

1624: ---------------------------------------------------------------------------
1625: l_debug_info := 'Open the credit and debit cursors';
1626: ---------------------------------------------------------------------------
1627: IF (PG_DEBUG = 'Y') THEN
1628: arp_standard.debug(l_debug_info);
1629: END IF;
1630: OPEN debit_transactions(p_currency_code);
1631: OPEN credit_transactions(p_currency_code);
1632:

Line 1638: arp_standard.debug(l_debug_info);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1764: arp_standard.debug(l_debug_info);

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

Line 1874: arp_standard.debug(l_debug_info);

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

Line 1909: arp_standard.debug(l_debug_info);

1905: ---------------------------------------------------------------------------
1906: l_debug_info := 'Close the credit and debit cursors';
1907: ---------------------------------------------------------------------------
1908: IF (PG_DEBUG = 'Y') THEN
1909: arp_standard.debug(l_debug_info);
1910: END IF;
1911: CLOSE credit_transactions;
1912: CLOSE debit_transactions;
1913:

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

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

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

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

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

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

Line 2003: arp_standard.debug(l_debug_info);

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

Line 2015: arp_standard.debug(l_debug_info);

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

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

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

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

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

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

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

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

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

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

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

Line 2134: arp_standard.debug(l_debug_info);

2130: ---------------------------------------------------------------------------
2131: l_debug_info := 'Open the cursor to select credit to apply';
2132: ---------------------------------------------------------------------------
2133: IF (PG_DEBUG = 'Y') THEN
2134: arp_standard.debug(l_debug_info);
2135: END IF;
2136:
2137: OPEN credit_to_apply(p_currency_code);
2138: FETCH credit_to_apply INTO x_credit_ps_id;

Line 2146: arp_standard.debug(l_debug_info);

2142: ---------------------------------------------------------------------------
2143: l_debug_info := 'Open the cursor to return duplicate application transactions';
2144: ---------------------------------------------------------------------------
2145: IF (PG_DEBUG = 'Y') THEN
2146: arp_standard.debug(l_debug_info);
2147: END IF;
2148: OPEN duplicate_application(p_currency_code);
2149: FETCH duplicate_application INTO duplicate_application_record;
2150:

Line 2157: arp_standard.debug(l_debug_info);

2153: ---------------------------------------------------------------------------
2154: l_debug_info := 'If a record is found, return the credit and debit transaction';
2155: ---------------------------------------------------------------------------
2156: IF (PG_DEBUG = 'Y') THEN
2157: arp_standard.debug(l_debug_info);
2158: END IF;
2159:
2160: x_credit_ps_id := duplicate_application_record.payment_schedule_id;
2161: x_debit_ps_id := duplicate_application_record.applied_payment_schedule_id;

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

2170: EXCEPTION
2171: WHEN OTHERS THEN
2172:
2173: IF (PG_DEBUG = 'Y') THEN
2174: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2175: arp_standard.debug('- Currency Code: '||p_currency_code);
2176: arp_standard.debug('ERROR =>'|| SQLERRM);
2177: END IF;
2178:

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

2171: WHEN OTHERS THEN
2172:
2173: IF (PG_DEBUG = 'Y') THEN
2174: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2175: arp_standard.debug('- Currency Code: '||p_currency_code);
2176: arp_standard.debug('ERROR =>'|| SQLERRM);
2177: END IF;
2178:
2179: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

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

2172:
2173: IF (PG_DEBUG = 'Y') THEN
2174: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2175: arp_standard.debug('- Currency Code: '||p_currency_code);
2176: arp_standard.debug('ERROR =>'|| SQLERRM);
2177: END IF;
2178:
2179: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2180: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);