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');
1200: --------------------------------------------------------------------------------
1201: l_debug_info := 'Get the credit transaction to apply other transactions against';
1202: --------------------------------------------------------------------------------
1203: IF (PG_DEBUG = 'Y') THEN
1204: arp_standard.debug(l_debug_info);
1205: END IF;
1206: select_credit_to_apply( p_currency_code => p_currency_code,
1207: x_return_status => x_return_status,
1208: x_credit_ps_id => x_dup_appln_crdt_psid,
1214: ---------------------------------------------------------------------------
1215: l_debug_info := 'An unexpected error has occurred while finding the credit';
1216: ---------------------------------------------------------------------------
1217: IF (PG_DEBUG = 'Y') THEN
1218: arp_standard.debug(l_debug_info);
1219: END IF;
1220: APP_EXCEPTION.raise_exception;
1221: ELSE
1222: ---------------------------------------------------------------------------
1222: ---------------------------------------------------------------------------
1223: l_debug_info := 'Duplicate application error';
1224: ---------------------------------------------------------------------------
1225: IF (PG_DEBUG = 'Y') THEN
1226: arp_standard.debug(l_debug_info);
1227: END IF;
1228:
1229: ROLLBACK TO ARI_APPLY_CREDITS_PMT;
1230:
1241: ---------------------------------------------------------------------------
1242: l_debug_info := 'Find cash receipt id';
1243: ---------------------------------------------------------------------------
1244: IF (PG_DEBUG = 'Y') THEN
1245: arp_standard.debug(l_debug_info);
1246: END IF;
1247: OPEN find_cash_receipt(x_dup_appln_crdt_psid);
1248: FETCH find_cash_receipt INTO find_cash_receipt_record;
1249: IF (find_cash_receipt%FOUND) THEN
1259: ----------------------------------------------------------------------------------
1260: l_debug_info := 'Apply credits against the selected payment';
1261: ----------------------------------------------------------------------------------
1262: IF (PG_DEBUG = 'Y') THEN
1263: arp_standard.debug(l_debug_info);
1264: END IF;
1265:
1266: FOR credit_trx_record in credit_transactions(p_currency_code)
1267: LOOP
1268: --If this is the credit transaction selected to be applied against, do not do anything.
1269: IF (credit_trx_record.payment_schedule_id <> x_dup_appln_crdt_psid) THEN
1270:
1271: IF (PG_DEBUG = 'Y') THEN
1272: arp_standard.debug('-------Credit Transaction Information------');
1273: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1269: IF (credit_trx_record.payment_schedule_id <> x_dup_appln_crdt_psid) THEN
1270:
1271: IF (PG_DEBUG = 'Y') THEN
1272: arp_standard.debug('-------Credit Transaction Information------');
1273: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1270:
1271: IF (PG_DEBUG = 'Y') THEN
1272: arp_standard.debug('-------Credit Transaction Information------');
1273: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1271: IF (PG_DEBUG = 'Y') THEN
1272: arp_standard.debug('-------Credit Transaction Information------');
1273: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1272: arp_standard.debug('-------Credit Transaction Information------');
1273: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1273: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1274: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1275: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1276: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1277: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1278: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1279: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1280: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1281: arp_standard.debug('Status: ' || credit_trx_record.status);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1282: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1283: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1291: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1284: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1291: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1292: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1285: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1291: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1292: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1293: END IF;
1286: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1291: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1292: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1293: END IF;
1294:
1287: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1291: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1292: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1293: END IF;
1294:
1295: IF (credit_trx_record.trx_class = 'CM') THEN
1288: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1289: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1290: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1291: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1292: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1293: END IF;
1294:
1295: IF (credit_trx_record.trx_class = 'CM') THEN
1296: ----------------------------------------------------------------------------------
1296: ----------------------------------------------------------------------------------
1297: l_debug_info := 'Apply credit memo against selected payment';
1298: ----------------------------------------------------------------------------------
1299: IF (PG_DEBUG = 'Y') THEN
1300: arp_standard.debug(l_debug_info);
1301: END IF;
1302:
1303: AR_RECEIPT_API_PUB.apply(
1304: p_api_version => 1.0,
1321: ----------------------------------------------------------------------------------
1322: l_debug_info := 'Apply payment against selected payment';
1323: ----------------------------------------------------------------------------------
1324: IF (PG_DEBUG = 'Y') THEN
1325: arp_standard.debug(l_debug_info);
1326: END IF;
1327:
1328: AR_RECEIPT_API_PUB.apply_open_receipt
1329: (p_api_version => 1.0,
1363: ----------------------------------------------------------------------------------
1364: l_debug_info := 'Apply invoices against the selected payment';
1365: ----------------------------------------------------------------------------------
1366: IF (PG_DEBUG = 'Y') THEN
1367: arp_standard.debug(l_debug_info);
1368: END IF;
1369:
1370: FOR debit_trx_record in debit_transactions(p_currency_code)
1371: LOOP
1369:
1370: FOR debit_trx_record in debit_transactions(p_currency_code)
1371: LOOP
1372: IF (PG_DEBUG = 'Y') THEN
1373: arp_standard.debug('-------Debit Transaction Information------');
1374: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1370: FOR debit_trx_record in debit_transactions(p_currency_code)
1371: LOOP
1372: IF (PG_DEBUG = 'Y') THEN
1373: arp_standard.debug('-------Debit Transaction Information------');
1374: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1371: LOOP
1372: IF (PG_DEBUG = 'Y') THEN
1373: arp_standard.debug('-------Debit Transaction Information------');
1374: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1372: IF (PG_DEBUG = 'Y') THEN
1373: arp_standard.debug('-------Debit Transaction Information------');
1374: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1373: arp_standard.debug('-------Debit Transaction Information------');
1374: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1374: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1375: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1376: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1377: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1378: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1379: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1380: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1381: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1382: arp_standard.debug('Status: ' || debit_trx_record.status);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1383: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1384: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1392: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1385: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1392: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1393: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1386: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1392: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1393: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1394: END IF;
1387: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1392: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1393: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1394: END IF;
1395:
1388: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1392: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1393: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1394: END IF;
1395:
1396: IF (x_open_invoices_status = 'N') THEN
1389: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1390: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1391: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1392: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1393: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1394: END IF;
1395:
1396: IF (x_open_invoices_status = 'N') THEN
1397: ----------------------------------------------------------------------------------
1397: ----------------------------------------------------------------------------------
1398: l_debug_info := 'Check if invoice will remain open after the application';
1399: ----------------------------------------------------------------------------------
1400: IF (PG_DEBUG = 'Y') THEN
1401: arp_standard.debug(l_debug_info);
1402: END IF;
1403:
1404: IF (debit_trx_record.amount_due_remaining
1405: - ( debit_trx_record.discount_amount + debit_trx_record.application_amount) > 0) THEN
1410: ----------------------------------------------------------------------------------
1411: l_debug_info := 'Apply invoice against selected payment';
1412: ----------------------------------------------------------------------------------
1413: IF (PG_DEBUG = 'Y') THEN
1414: arp_standard.debug(l_debug_info);
1415: END IF;
1416:
1417: AR_RECEIPT_API_PUB.apply(
1418: p_api_version => 1.0,
1446: ---------------------------------------------------------------------------
1447: l_debug_info := 'Close the credit and debit cursors';
1448: ---------------------------------------------------------------------------
1449: IF (PG_DEBUG = 'Y') THEN
1450: arp_standard.debug(l_debug_info);
1451: END IF;
1452:
1453: COMMIT;
1454:
1456:
1457: EXCEPTION
1458: WHEN OTHERS THEN
1459: IF (PG_DEBUG = 'Y') THEN
1460: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1461: arp_standard.debug('- Currency Code: '||p_currency_code);
1462: arp_standard.debug('ERROR =>'|| SQLERRM);
1463: END IF;
1464:
1457: EXCEPTION
1458: WHEN OTHERS THEN
1459: IF (PG_DEBUG = 'Y') THEN
1460: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1461: arp_standard.debug('- Currency Code: '||p_currency_code);
1462: arp_standard.debug('ERROR =>'|| SQLERRM);
1463: END IF;
1464:
1465: IF(PG_DIAGNOSTICS = 'Y') THEN
1458: WHEN OTHERS THEN
1459: IF (PG_DEBUG = 'Y') THEN
1460: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1461: arp_standard.debug('- Currency Code: '||p_currency_code);
1462: arp_standard.debug('ERROR =>'|| SQLERRM);
1463: END IF;
1464:
1465: IF(PG_DIAGNOSTICS = 'Y') THEN
1466: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1620: ---------------------------------------------------------------------------
1621: l_debug_info := 'Open the credit and debit cursors';
1622: ---------------------------------------------------------------------------
1623: IF (PG_DEBUG = 'Y') THEN
1624: arp_standard.debug(l_debug_info);
1625: END IF;
1626: OPEN debit_transactions(p_currency_code);
1627: OPEN credit_transactions(p_currency_code);
1628:
1630: ---------------------------------------------------------------------------
1631: l_debug_info := 'Fetch debit and credit transactions';
1632: ---------------------------------------------------------------------------
1633: IF (PG_DEBUG = 'Y') THEN
1634: arp_standard.debug(l_debug_info);
1635: END IF;
1636:
1637: IF (l_next_transaction = 'DEBIT') THEN
1638: FETCH debit_transactions INTO debit_trx_record;
1679:
1680: END IF;
1681:
1682: IF (PG_DEBUG = 'Y') THEN
1683: arp_standard.debug('-------Debit Transaction Information------');
1684: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1680: END IF;
1681:
1682: IF (PG_DEBUG = 'Y') THEN
1683: arp_standard.debug('-------Debit Transaction Information------');
1684: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1681:
1682: IF (PG_DEBUG = 'Y') THEN
1683: arp_standard.debug('-------Debit Transaction Information------');
1684: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1682: IF (PG_DEBUG = 'Y') THEN
1683: arp_standard.debug('-------Debit Transaction Information------');
1684: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1683: arp_standard.debug('-------Debit Transaction Information------');
1684: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1684: arp_standard.debug('Customer Id: ' || debit_trx_record.customer_id);
1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1685: arp_standard.debug('Customer Site Use Id: ' || debit_trx_record.customer_site_use_id);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1686: arp_standard.debug('Customer Trx Id: ' || debit_trx_record.customer_trx_id);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1687: arp_standard.debug('Trx Number: ' || debit_trx_record.trx_number);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1688: arp_standard.debug('Trx Date: ' || debit_trx_record.trx_date);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1689: arp_standard.debug('Trx Class: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1690: arp_standard.debug('Due Date: ' || debit_trx_record.due_date);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1691: arp_standard.debug('Payment Schedule Id: ' || debit_trx_record.payment_schedule_id);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1692: arp_standard.debug('Status: ' || debit_trx_record.status);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1693: arp_standard.debug('Terms Sequence Number: ' || debit_trx_record.terms_sequence_number);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1694: arp_standard.debug('Line Amount: ' || debit_trx_record.line_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1695: arp_standard.debug('Tax Amount: ' || debit_trx_record.tax_amount);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1696: arp_standard.debug('Freight Amount: ' || debit_trx_record.freight_amount);
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1697: arp_standard.debug('Finance Charges: ' || debit_trx_record.trx_class);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1698: arp_standard.debug('Currency Code: ' || debit_trx_record.currency_code);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1699: arp_standard.debug('Amount Due Original: ' || debit_trx_record.amount_due_original);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1700: arp_standard.debug('Amount Due Remaining: ' || debit_trx_record.amount_due_remaining);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1701: arp_standard.debug('Discount Amount: ' || debit_trx_record.discount_amount);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1702: arp_standard.debug('Application Amount: ' || debit_trx_record.application_amount);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1703: arp_standard.debug('Cash Receipt Id: ' || debit_trx_record.cash_receipt_id);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1704: arp_standard.debug('-------Credit Transaction Information------');
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1705: arp_standard.debug('Customer Id: ' || credit_trx_record.customer_id);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1706: arp_standard.debug('Customer Site Use Id: ' || credit_trx_record.customer_site_use_id);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1707: arp_standard.debug('Customer Trx Id: ' || credit_trx_record.customer_trx_id);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1708: arp_standard.debug('Trx Number: ' || credit_trx_record.trx_number);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1709: arp_standard.debug('Trx Date: ' || credit_trx_record.trx_date);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1710: arp_standard.debug('Trx Class: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1711: arp_standard.debug('Due Date: ' || credit_trx_record.due_date);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1712: arp_standard.debug('Payment Schedule Id: ' || credit_trx_record.payment_schedule_id);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1713: arp_standard.debug('Status: ' || credit_trx_record.status);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1714: arp_standard.debug('Terms Sequence Number: ' || credit_trx_record.terms_sequence_number);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1715: arp_standard.debug('Line Amount: ' || credit_trx_record.line_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1723: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1716: arp_standard.debug('Tax Amount: ' || credit_trx_record.tax_amount);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1723: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1724: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1717: arp_standard.debug('Freight Amount: ' || credit_trx_record.freight_amount);
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1723: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1724: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1725: END IF;
1718: arp_standard.debug('Finance Charges: ' || credit_trx_record.trx_class);
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1723: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1724: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1725: END IF;
1726:
1719: arp_standard.debug('Currency Code: ' || credit_trx_record.currency_code);
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1723: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1724: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1725: END IF;
1726:
1727: -- Bug 4103527 - Display error icons for duplicate application
1720: arp_standard.debug('Amount Due Original: ' || credit_trx_record.amount_due_original);
1721: arp_standard.debug('Amount Due Remaining: ' || credit_trx_record.amount_due_remaining);
1722: arp_standard.debug('Discount Amount: ' || credit_trx_record.discount_amount);
1723: arp_standard.debug('Application Amount: ' || credit_trx_record.application_amount);
1724: arp_standard.debug('Cash Receipt Id: ' || credit_trx_record.cash_receipt_id);
1725: END IF;
1726:
1727: -- Bug 4103527 - Display error icons for duplicate application
1728: BEGIN
1756: ---------------------------------------------------------------------------
1757: l_debug_info := 'Apply credit memo against the debit transaction';
1758: ---------------------------------------------------------------------------
1759: IF (PG_DEBUG = 'Y') THEN
1760: arp_standard.debug(l_debug_info);
1761: END IF;
1762:
1763: --Bug 4042557: Fetch the GL date for the credit memo
1764: select trunc(gl_date), trunc(trx_date)
1866: ---------------------------------------------------------------------------
1867: l_debug_info := 'Apply receipt against the debit transaction';
1868: ---------------------------------------------------------------------------
1869: IF (PG_DEBUG = 'Y') THEN
1870: arp_standard.debug(l_debug_info);
1871: END IF;
1872: AR_RECEIPT_API_PUB.apply(
1873: p_api_version => 1.0,
1874: p_init_msg_list => FND_API.G_TRUE,
1901: ---------------------------------------------------------------------------
1902: l_debug_info := 'Close the credit and debit cursors';
1903: ---------------------------------------------------------------------------
1904: IF (PG_DEBUG = 'Y') THEN
1905: arp_standard.debug(l_debug_info);
1906: END IF;
1907: CLOSE credit_transactions;
1908: CLOSE debit_transactions;
1909:
1913:
1914: EXCEPTION
1915: WHEN OTHERS THEN
1916: IF (PG_DEBUG = 'Y') THEN
1917: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1918: arp_standard.debug('- Currency Code: '||p_currency_code);
1919: arp_standard.debug('ERROR =>'|| SQLERRM);
1920: END IF;
1921:
1914: EXCEPTION
1915: WHEN OTHERS THEN
1916: IF (PG_DEBUG = 'Y') THEN
1917: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1918: arp_standard.debug('- Currency Code: '||p_currency_code);
1919: arp_standard.debug('ERROR =>'|| SQLERRM);
1920: END IF;
1921:
1922: IF(PG_DIAGNOSTICS = 'Y') THEN
1915: WHEN OTHERS THEN
1916: IF (PG_DEBUG = 'Y') THEN
1917: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1918: arp_standard.debug('- Currency Code: '||p_currency_code);
1919: arp_standard.debug('ERROR =>'|| SQLERRM);
1920: END IF;
1921:
1922: IF(PG_DIAGNOSTICS = 'Y') THEN
1923: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1995: ----------------------------------------------------------------------------------------
1996: l_debug_info := 'Clear the Transaction List GT for the active customer, site, currency code';
1997: -----------------------------------------------------------------------------------------
1998: IF (PG_DEBUG = 'Y') THEN
1999: arp_standard.debug(l_debug_info);
2000: END IF;
2001:
2002: DELETE FROM AR_IREC_PAYMENT_LIST_GT
2003: WHERE CUSTOMER_ID = p_customer_id
2007: ----------------------------------------------------------------------------------------
2008: l_debug_info := 'Fetch open debits from Apply Credits GT into Transaction List GT';
2009: -----------------------------------------------------------------------------------------
2010: IF (PG_DEBUG = 'Y') THEN
2011: arp_standard.debug(l_debug_info);
2012: END IF;
2013:
2014: FOR trx IN open_debits_list(p_customer_id,
2015: p_customer_site_use_id,
2027:
2028: EXCEPTION
2029: WHEN OTHERS THEN
2030: IF (PG_DEBUG = 'Y') THEN
2031: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2032: arp_standard.debug('- Customer Id: '||p_customer_id);
2033: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2034: arp_standard.debug('- Currency Code: '||p_currency_code);
2035: arp_standard.debug('ERROR =>'|| SQLERRM);
2028: EXCEPTION
2029: WHEN OTHERS THEN
2030: IF (PG_DEBUG = 'Y') THEN
2031: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2032: arp_standard.debug('- Customer Id: '||p_customer_id);
2033: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2034: arp_standard.debug('- Currency Code: '||p_currency_code);
2035: arp_standard.debug('ERROR =>'|| SQLERRM);
2036: END IF;
2029: WHEN OTHERS THEN
2030: IF (PG_DEBUG = 'Y') THEN
2031: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2032: arp_standard.debug('- Customer Id: '||p_customer_id);
2033: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2034: arp_standard.debug('- Currency Code: '||p_currency_code);
2035: arp_standard.debug('ERROR =>'|| SQLERRM);
2036: END IF;
2037:
2030: IF (PG_DEBUG = 'Y') THEN
2031: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2032: arp_standard.debug('- Customer Id: '||p_customer_id);
2033: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2034: arp_standard.debug('- Currency Code: '||p_currency_code);
2035: arp_standard.debug('ERROR =>'|| SQLERRM);
2036: END IF;
2037:
2038: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2031: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2032: arp_standard.debug('- Customer Id: '||p_customer_id);
2033: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2034: arp_standard.debug('- Currency Code: '||p_currency_code);
2035: arp_standard.debug('ERROR =>'|| SQLERRM);
2036: END IF;
2037:
2038: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2039: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2143: ---------------------------------------------------------------------------
2144: l_debug_info := 'Open the cursor to select credit to apply';
2145: ---------------------------------------------------------------------------
2146: IF (PG_DEBUG = 'Y') THEN
2147: arp_standard.debug(l_debug_info);
2148: END IF;
2149:
2150: OPEN credit_to_apply(p_currency_code);
2151: FETCH credit_to_apply INTO x_credit_ps_id;
2156: ---------------------------------------------------------------------------
2157: l_debug_info := 'Open the cursor to return duplicate application transactions';
2158: ---------------------------------------------------------------------------
2159: IF (PG_DEBUG = 'Y') THEN
2160: arp_standard.debug(l_debug_info);
2161: END IF;
2162: OPEN duplicate_application(p_currency_code);
2163: FETCH duplicate_application INTO duplicate_application_record;
2164:
2166: ---------------------------------------------------------------------------
2167: l_debug_info := 'If a record is found, return the credit and debit transaction';
2168: ---------------------------------------------------------------------------
2169: IF (PG_DEBUG = 'Y') THEN
2170: arp_standard.debug(l_debug_info);
2171: END IF;
2172:
2173: x_credit_ps_id := duplicate_application_record.payment_schedule_id;
2174: x_debit_ps_id := duplicate_application_record.applied_payment_schedule_id;
2183:
2184: EXCEPTION
2185: WHEN OTHERS THEN
2186: IF (PG_DEBUG = 'Y') THEN
2187: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2188: arp_standard.debug('- Currency Code: '||p_currency_code);
2189: arp_standard.debug('ERROR =>'|| SQLERRM);
2190: END IF;
2191:
2184: EXCEPTION
2185: WHEN OTHERS THEN
2186: IF (PG_DEBUG = 'Y') THEN
2187: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2188: arp_standard.debug('- Currency Code: '||p_currency_code);
2189: arp_standard.debug('ERROR =>'|| SQLERRM);
2190: END IF;
2191:
2192: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2185: WHEN OTHERS THEN
2186: IF (PG_DEBUG = 'Y') THEN
2187: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2188: arp_standard.debug('- Currency Code: '||p_currency_code);
2189: arp_standard.debug('ERROR =>'|| SQLERRM);
2190: END IF;
2191:
2192: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2193: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);