450: write_debug_and_log('- Transaction Exchange Rate: '||p_trx_exchange_rate);
451: write_debug_and_log('- Exchange Rate found: '||p_exchange_rate);
452: write_debug_and_log('ERROR =>'|| SQLERRM);
453:
454: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
455: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
456: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
457: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
458: FND_MSG_PUB.ADD;
451: write_debug_and_log('- Exchange Rate found: '||p_exchange_rate);
452: write_debug_and_log('ERROR =>'|| SQLERRM);
453:
454: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
455: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
456: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
457: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
458: FND_MSG_PUB.ADD;
459:
452: write_debug_and_log('ERROR =>'|| SQLERRM);
453:
454: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
455: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
456: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
457: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
458: FND_MSG_PUB.ADD;
459:
460: END get_exchange_rate;
453:
454: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
455: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
456: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
457: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
458: FND_MSG_PUB.ADD;
459:
460: END get_exchange_rate;
461:
865: write_debug_and_log('- Receipt Method Id: '||p_receipt_method_id);
866: write_debug_and_log('- Payment Schedule Id: '||p_payment_schedule_id);
867: write_debug_and_log('ERROR =>'|| SQLERRM);
868:
869: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
870: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
871: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
872: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
873: FND_MSG_PUB.ADD;
866: write_debug_and_log('- Payment Schedule Id: '||p_payment_schedule_id);
867: write_debug_and_log('ERROR =>'|| SQLERRM);
868:
869: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
870: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
871: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
872: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
873: FND_MSG_PUB.ADD;
874:
867: write_debug_and_log('ERROR =>'|| SQLERRM);
868:
869: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
870: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
871: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
872: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
873: FND_MSG_PUB.ADD;
874:
875: END get_payment_information;
868:
869: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
870: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
871: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
872: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
873: FND_MSG_PUB.ADD;
874:
875: END get_payment_information;
876:
1065: write_debug_and_log('- Card Id: '||p_bank_account_id);
1066: write_debug_and_log('- Expiration Date: '||p_expiration_date);
1067: write_debug_and_log('ERROR =>'|| SQLERRM);
1068:
1069: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1070: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1071: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1072:
1073: FND_MSG_PUB.ADD;
1066: write_debug_and_log('- Expiration Date: '||p_expiration_date);
1067: write_debug_and_log('ERROR =>'|| SQLERRM);
1068:
1069: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1070: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1071: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1072:
1073: FND_MSG_PUB.ADD;
1074:
1067: write_debug_and_log('ERROR =>'|| SQLERRM);
1068:
1069: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1070: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1071: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1072:
1073: FND_MSG_PUB.ADD;
1074:
1075: END;
1986: write_debug_and_log('- Account Number: '||p_bank_account_number);
1987: write_debug_and_log('- Holder Name: '||p_account_holder_name);
1988: write_debug_and_log('ERROR =>'|| SQLERRM);
1989:
1990: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1991: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1992: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1993:
1994: FND_MSG_PUB.ADD;
1987: write_debug_and_log('- Holder Name: '||p_account_holder_name);
1988: write_debug_and_log('ERROR =>'|| SQLERRM);
1989:
1990: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1991: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1992: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1993:
1994: FND_MSG_PUB.ADD;
1995:
1988: write_debug_and_log('ERROR =>'|| SQLERRM);
1989:
1990: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1991: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1992: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1993:
1994: FND_MSG_PUB.ADD;
1995:
1996: END is_bank_account_duplicate;
2501: END IF;
2502:
2503: ROLLBACK TO create_invoice_pay_list_sp;
2504:
2505: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2506: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2507: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2508: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2509: FND_MSG_PUB.ADD;
2502:
2503: ROLLBACK TO create_invoice_pay_list_sp;
2504:
2505: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2506: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2507: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2508: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2509: FND_MSG_PUB.ADD;
2510: END create_invoice_pay_list;
2503: ROLLBACK TO create_invoice_pay_list_sp;
2504:
2505: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2506: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2507: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2508: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2509: FND_MSG_PUB.ADD;
2510: END create_invoice_pay_list;
2511:
2504:
2505: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2506: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2507: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2508: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2509: FND_MSG_PUB.ADD;
2510: END create_invoice_pay_list;
2511:
2512: /*============================================================
2679: arp_standard.debug('- Currency Code: '||p_currency_code);
2680: arp_standard.debug('ERROR =>'|| SQLERRM);
2681: END IF;
2682:
2683: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2684: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2685: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2686: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2687: FND_MSG_PUB.ADD;
2680: arp_standard.debug('ERROR =>'|| SQLERRM);
2681: END IF;
2682:
2683: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2684: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2685: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2686: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2687: FND_MSG_PUB.ADD;
2688:
2681: END IF;
2682:
2683: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2684: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2685: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2686: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2687: FND_MSG_PUB.ADD;
2688:
2689: END create_open_credit_pay_list;
2682:
2683: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2684: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2685: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2686: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2687: FND_MSG_PUB.ADD;
2688:
2689: END create_open_credit_pay_list;
2690:
2864: END;
2865:
2866: ROLLBACK TO cal_disc_and_service_charge_sp;
2867:
2868: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2869: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2870: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2871: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2872: FND_MSG_PUB.ADD;
2865:
2866: ROLLBACK TO cal_disc_and_service_charge_sp;
2867:
2868: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2869: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2870: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2871: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2872: FND_MSG_PUB.ADD;
2873:
2866: ROLLBACK TO cal_disc_and_service_charge_sp;
2867:
2868: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2869: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2870: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2871: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2872: FND_MSG_PUB.ADD;
2873:
2874: END cal_discount_and_service_chrg;
2867:
2868: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2869: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2870: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2871: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2872: FND_MSG_PUB.ADD;
2873:
2874: END cal_discount_and_service_chrg;
2875:
3422: write_debug_and_log('- Singe Use Flag: '||p_single_use_flag);
3423: write_debug_and_log('- Return Status: '||p_status);
3424: write_debug_and_log('ERROR =>'|| SQLERRM);
3425:
3426: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3427: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3428: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3429: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3430: FND_MSG_PUB.ADD;
3423: write_debug_and_log('- Return Status: '||p_status);
3424: write_debug_and_log('ERROR =>'|| SQLERRM);
3425:
3426: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3427: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3428: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3429: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3430: FND_MSG_PUB.ADD;
3431: END create_payment_instrument;
3424: write_debug_and_log('ERROR =>'|| SQLERRM);
3425:
3426: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3427: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3428: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3429: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3430: FND_MSG_PUB.ADD;
3431: END create_payment_instrument;
3432:
3425:
3426: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3427: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3428: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3429: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3430: FND_MSG_PUB.ADD;
3431: END create_payment_instrument;
3432:
3433: /*============================================================
3527: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
3528: write_debug_and_log('- Return Status: '||x_return_status);
3529: write_debug_and_log('ERROR =>'|| SQLERRM);
3530:
3531: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3532: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3533: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3534: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3535: FND_MSG_PUB.ADD;
3528: write_debug_and_log('- Return Status: '||x_return_status);
3529: write_debug_and_log('ERROR =>'|| SQLERRM);
3530:
3531: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3532: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3533: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3534: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3535: FND_MSG_PUB.ADD;
3536:
3529: write_debug_and_log('ERROR =>'|| SQLERRM);
3530:
3531: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3532: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3533: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3534: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3535: FND_MSG_PUB.ADD;
3536:
3537: END create_cc_bill_to_site;
3530:
3531: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3532: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3533: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3534: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3535: FND_MSG_PUB.ADD;
3536:
3537: END create_cc_bill_to_site;
3538:
3648: write_debug_and_log('- Bank Account Id: '||p_bank_account_id);
3649: write_debug_and_log('- Return Status: '||p_status);
3650: write_debug_and_log('ERROR =>'|| SQLERRM);
3651:
3652: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3653: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3654: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3655: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3656: FND_MSG_PUB.ADD;
3649: write_debug_and_log('- Return Status: '||p_status);
3650: write_debug_and_log('ERROR =>'|| SQLERRM);
3651:
3652: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3653: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3654: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3655: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3656: FND_MSG_PUB.ADD;
3657:
3650: write_debug_and_log('ERROR =>'|| SQLERRM);
3651:
3652: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3653: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3654: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3655: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3656: FND_MSG_PUB.ADD;
3657:
3658: END create_receipt;
3651:
3652: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3653: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3654: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3655: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3656: FND_MSG_PUB.ADD;
3657:
3658: END create_receipt;
3659:
3978: write_debug_and_log('- Cash Receipt Id: '||p_cash_receipt_id);
3979: write_debug_and_log('- Return Status: '||p_return_status);
3980: write_debug_and_log(SQLERRM);
3981:
3982: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3983: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3985: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3986: FND_MSG_PUB.ADD;
3979: write_debug_and_log('- Return Status: '||p_return_status);
3980: write_debug_and_log(SQLERRM);
3981:
3982: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3983: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3985: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3986: FND_MSG_PUB.ADD;
3987: END;
3980: write_debug_and_log(SQLERRM);
3981:
3982: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3983: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3985: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3986: FND_MSG_PUB.ADD;
3987: END;
3988:
3981:
3982: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3983: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3985: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3986: FND_MSG_PUB.ADD;
3987: END;
3988:
3989: END apply_cash;
4162: END;
4163:
4164: ROLLBACK TO service_charge_sp;
4165:
4166: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4167: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4168: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4169: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4170: FND_MSG_PUB.ADD;
4163:
4164: ROLLBACK TO service_charge_sp;
4165:
4166: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4167: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4168: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4169: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4170: FND_MSG_PUB.ADD;
4171:
4164: ROLLBACK TO service_charge_sp;
4165:
4166: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4167: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4168: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4169: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4170: FND_MSG_PUB.ADD;
4171:
4172: END get_service_charge;
4165:
4166: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4167: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4168: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4169: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4170: FND_MSG_PUB.ADD;
4171:
4172: END get_service_charge;
4173:
4306: write_debug_and_log('- Total Service charge: '||l_total_service_charge);
4307: write_debug_and_log('- Return Status: '||l_return_status);
4308: write_debug_and_log(SQLERRM);
4309:
4310: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4311: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4312: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4313: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4314: FND_MSG_PUB.ADD;
4307: write_debug_and_log('- Return Status: '||l_return_status);
4308: write_debug_and_log(SQLERRM);
4309:
4310: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4311: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4312: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4313: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4314: FND_MSG_PUB.ADD;
4315: END;
4308: write_debug_and_log(SQLERRM);
4309:
4310: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4311: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4312: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4313: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4314: FND_MSG_PUB.ADD;
4315: END;
4316:
4309:
4310: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4311: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4312: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4313: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4314: FND_MSG_PUB.ADD;
4315: END;
4316:
4317: END apply_service_charge;
5190: write_debug_and_log('- Cash Receipt Id: '||p_cash_receipt_id);
5191: write_debug_and_log('- Return Status: '||p_status);
5192: write_debug_and_log('ERROR =>'|| SQLERRM);
5193:
5194: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5195: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5196: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5197: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5198: FND_MSG_PUB.ADD;
5191: write_debug_and_log('- Return Status: '||p_status);
5192: write_debug_and_log('ERROR =>'|| SQLERRM);
5193:
5194: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5195: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5196: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5197: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5198: FND_MSG_PUB.ADD;
5199:
5192: write_debug_and_log('ERROR =>'|| SQLERRM);
5193:
5194: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5195: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5196: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5197: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5198: FND_MSG_PUB.ADD;
5199:
5200: p_status := FND_API.G_RET_STS_ERROR;
5193:
5194: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5195: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5196: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5197: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5198: FND_MSG_PUB.ADD;
5199:
5200: p_status := FND_API.G_RET_STS_ERROR;
5201: write_error_messages(x_msg_data, x_msg_count);
5305: elsif rct_info.creation_status = 'CONFIRMED' THEN
5306: l_action := 'AUTHONLY';
5307: else
5308: arp_standard.debug('ERROR: Creation status is ' || rct_info.creation_status);
5309: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');
5310: FND_MSG_PUB.Add;
5311:
5312: x_return_status := FND_API.G_RET_STS_ERROR; -- should never happen
5313: RETURN;
5392:
5393: if (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5394: AND (NVL(p_called_from,'NONE') = 'IREC') then
5395:
5396: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
5397: FND_MSG_PUB.Add;
5398: x_return_status := l_return_status;
5399: --Bug 7673372 - When IBY API throws an error without contacting 3rd pmt system the error msg would
5400: --returned in x_response.Result_Message;
5458: --Add message to message stack only it it is called from iReceivables
5459: --if not pass the message stack received from iPayment
5460:
5461: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) AND (NVL(p_called_from,'NONE') = 'IREC') then
5462: FND_MESSAGE.set_name('AR', 'AR_CC_CAPTURE_FAILED');
5463: FND_MSG_PUB.Add;
5464: end if;
5465: x_return_status := l_return_status;
5466: --Bug 7673372 - When IBY API throws an error without contacting 3rd pmt system the error msg would
5485: write_debug_and_log('- Cash Receipt Id: '||p_cash_receipt_id);
5486: write_debug_and_log('- Return Status: '||x_return_status);
5487: write_debug_and_log(SQLERRM);
5488:
5489: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5490: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5491: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5492: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5493: FND_MSG_PUB.ADD;
5486: write_debug_and_log('- Return Status: '||x_return_status);
5487: write_debug_and_log(SQLERRM);
5488:
5489: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5490: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5491: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5492: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5493: FND_MSG_PUB.ADD;
5494: END;
5487: write_debug_and_log(SQLERRM);
5488:
5489: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5490: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5491: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5492: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5493: FND_MSG_PUB.ADD;
5494: END;
5495:
5488:
5489: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5490: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5491: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5492: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5493: FND_MSG_PUB.ADD;
5494: END;
5495:
5496: END process_payment;
5832: END IF;
5833:
5834: ROLLBACK to create_trx_list_record_sp;
5835:
5836: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5837: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5838: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5839: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5840: FND_MSG_PUB.ADD;
5833:
5834: ROLLBACK to create_trx_list_record_sp;
5835:
5836: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5837: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5838: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5839: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5840: FND_MSG_PUB.ADD;
5841:
5834: ROLLBACK to create_trx_list_record_sp;
5835:
5836: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5837: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5838: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5839: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5840: FND_MSG_PUB.ADD;
5841:
5842: END create_transaction_list_record;
5835:
5836: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5837: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5838: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5839: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5840: FND_MSG_PUB.ADD;
5841:
5842: END create_transaction_list_record;
5843:
6578: write_debug_and_log('l_location_id'|| l_location_id);
6579: write_debug_and_log('- Return Status: '||x_return_status);
6580: write_debug_and_log(SQLERRM);
6581:
6582: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
6583: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
6584: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6585: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6586: FND_MSG_PUB.ADD;
6579: write_debug_and_log('- Return Status: '||x_return_status);
6580: write_debug_and_log(SQLERRM);
6581:
6582: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
6583: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
6584: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6585: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6586: FND_MSG_PUB.ADD;
6587:
6580: write_debug_and_log(SQLERRM);
6581:
6582: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
6583: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
6584: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6585: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6586: FND_MSG_PUB.ADD;
6587:
6588: END update_cc_bill_to_site;
6581:
6582: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
6583: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
6584: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6585: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6586: FND_MSG_PUB.ADD;
6587:
6588: END update_cc_bill_to_site;
6589:
6646: write_debug_and_log('p_channel_code'|| p_channel_code);
6647: write_debug_and_log('- Return Status: '||x_return_status);
6648: write_debug_and_log(SQLERRM);
6649:
6650: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
6651: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
6652: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6653: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6654: FND_MSG_PUB.ADD;
6647: write_debug_and_log('- Return Status: '||x_return_status);
6648: write_debug_and_log(SQLERRM);
6649:
6650: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
6651: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
6652: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6653: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6654: FND_MSG_PUB.ADD;
6655: END get_payment_channel_attribs;
6648: write_debug_and_log(SQLERRM);
6649:
6650: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
6651: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
6652: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6653: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6654: FND_MSG_PUB.ADD;
6655: END get_payment_channel_attribs;
6656:
6649:
6650: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
6651: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
6652: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6653: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6654: FND_MSG_PUB.ADD;
6655: END get_payment_channel_attribs;
6656:
6657: /*=====================================================================