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,
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);
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;
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:
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');
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);
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;
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:
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');
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);
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
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);
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;
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:
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');
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);
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
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);
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;
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:
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');
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);
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;
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:
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');
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);
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;
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);
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;
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:
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');
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);
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,
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,
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);
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;
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:
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
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');
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,
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: ---------------------------------------------------------------------------
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:
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
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
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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;
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:
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
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: ----------------------------------------------------------------------------------
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,
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,
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
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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;
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:
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
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: ----------------------------------------------------------------------------------
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
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,
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:
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:
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
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');
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:
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;
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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------');
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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;
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:
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
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
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)
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,
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:
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:
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
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');
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
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,
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);
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;
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:
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');
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);
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;
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:
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;
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:
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');
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);