444: write_debug_and_log('- Transaction Exchange Rate: '||p_trx_exchange_rate);
445: write_debug_and_log('- Exchange Rate found: '||p_exchange_rate);
446: write_debug_and_log('ERROR =>'|| SQLERRM);
447:
448: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
449: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
450: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
451: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
452: FND_MSG_PUB.ADD;
445: write_debug_and_log('- Exchange Rate found: '||p_exchange_rate);
446: write_debug_and_log('ERROR =>'|| SQLERRM);
447:
448: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
449: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
450: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
451: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
452: FND_MSG_PUB.ADD;
453:
446: write_debug_and_log('ERROR =>'|| SQLERRM);
447:
448: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
449: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
450: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
451: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
452: FND_MSG_PUB.ADD;
453:
454: END get_exchange_rate;
447:
448: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
449: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
450: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
451: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
452: FND_MSG_PUB.ADD;
453:
454: END get_exchange_rate;
455:
854: write_debug_and_log('- Receipt Method Id: '||p_receipt_method_id);
855: write_debug_and_log('- Payment Schedule Id: '||p_payment_schedule_id);
856: write_debug_and_log('ERROR =>'|| SQLERRM);
857:
858: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
859: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
860: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
861: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
862: FND_MSG_PUB.ADD;
855: write_debug_and_log('- Payment Schedule Id: '||p_payment_schedule_id);
856: write_debug_and_log('ERROR =>'|| SQLERRM);
857:
858: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
859: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
860: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
861: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
862: FND_MSG_PUB.ADD;
863:
856: write_debug_and_log('ERROR =>'|| SQLERRM);
857:
858: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
859: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
860: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
861: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
862: FND_MSG_PUB.ADD;
863:
864: END get_payment_information;
857:
858: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
859: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
860: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
861: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
862: FND_MSG_PUB.ADD;
863:
864: END get_payment_information;
865:
997: write_debug_and_log('- Card Id: '||p_bank_account_id);
998: write_debug_and_log('- Expiration Date: '||p_expiration_date);
999: write_debug_and_log('ERROR =>'|| SQLERRM);
1000:
1001: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1002: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1003: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1004:
1005: FND_MSG_PUB.ADD;
998: write_debug_and_log('- Expiration Date: '||p_expiration_date);
999: write_debug_and_log('ERROR =>'|| SQLERRM);
1000:
1001: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1002: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1003: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1004:
1005: FND_MSG_PUB.ADD;
1006:
999: write_debug_and_log('ERROR =>'|| SQLERRM);
1000:
1001: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1002: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1003: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1004:
1005: FND_MSG_PUB.ADD;
1006:
1007: END;
1887: write_debug_and_log('- Account Number: '||p_bank_account_number);
1888: write_debug_and_log('- Holder Name: '||p_account_holder_name);
1889: write_debug_and_log('ERROR =>'|| SQLERRM);
1890:
1891: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1892: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1893: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1894:
1895: FND_MSG_PUB.ADD;
1888: write_debug_and_log('- Holder Name: '||p_account_holder_name);
1889: write_debug_and_log('ERROR =>'|| SQLERRM);
1890:
1891: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1892: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1893: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1894:
1895: FND_MSG_PUB.ADD;
1896:
1889: write_debug_and_log('ERROR =>'|| SQLERRM);
1890:
1891: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1892: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1893: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1894:
1895: FND_MSG_PUB.ADD;
1896:
1897: END is_bank_account_duplicate;
2375: END IF;
2376:
2377: ROLLBACK TO create_invoice_pay_list_sp;
2378:
2379: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2380: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2381: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2382: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2383: FND_MSG_PUB.ADD;
2376:
2377: ROLLBACK TO create_invoice_pay_list_sp;
2378:
2379: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2380: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2381: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2382: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2383: FND_MSG_PUB.ADD;
2384: END create_invoice_pay_list;
2377: ROLLBACK TO create_invoice_pay_list_sp;
2378:
2379: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2380: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2381: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2382: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2383: FND_MSG_PUB.ADD;
2384: END create_invoice_pay_list;
2385:
2378:
2379: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2380: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2381: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2382: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2383: FND_MSG_PUB.ADD;
2384: END create_invoice_pay_list;
2385:
2386: /*============================================================
2553: arp_standard.debug('- Currency Code: '||p_currency_code);
2554: arp_standard.debug('ERROR =>'|| SQLERRM);
2555: END IF;
2556:
2557: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2558: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2559: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2560: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2561: FND_MSG_PUB.ADD;
2554: arp_standard.debug('ERROR =>'|| SQLERRM);
2555: END IF;
2556:
2557: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2558: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2559: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2560: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2561: FND_MSG_PUB.ADD;
2562:
2555: END IF;
2556:
2557: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2558: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2559: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2560: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2561: FND_MSG_PUB.ADD;
2562:
2563: END create_open_credit_pay_list;
2556:
2557: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2558: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2559: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2560: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2561: FND_MSG_PUB.ADD;
2562:
2563: END create_open_credit_pay_list;
2564:
2719: END;
2720:
2721: ROLLBACK TO cal_disc_and_service_charge_sp;
2722:
2723: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2724: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2725: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2726: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2727: FND_MSG_PUB.ADD;
2720:
2721: ROLLBACK TO cal_disc_and_service_charge_sp;
2722:
2723: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2724: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2725: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2726: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2727: FND_MSG_PUB.ADD;
2728:
2721: ROLLBACK TO cal_disc_and_service_charge_sp;
2722:
2723: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2724: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2725: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2726: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2727: FND_MSG_PUB.ADD;
2728:
2729: END cal_discount_and_service_chrg;
2722:
2723: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2724: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2725: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2726: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2727: FND_MSG_PUB.ADD;
2728:
2729: END cal_discount_and_service_chrg;
2730:
2953: write_debug_and_log('- Singe Use Flag: '||p_single_use_flag);
2954: write_debug_and_log('- Return Status: '||p_status);
2955: write_debug_and_log('ERROR =>'|| SQLERRM);
2956:
2957: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2958: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2959: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2960: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2961: FND_MSG_PUB.ADD;
2954: write_debug_and_log('- Return Status: '||p_status);
2955: write_debug_and_log('ERROR =>'|| SQLERRM);
2956:
2957: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2958: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2959: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2960: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2961: FND_MSG_PUB.ADD;
2962: END create_payment_instrument;
2955: write_debug_and_log('ERROR =>'|| SQLERRM);
2956:
2957: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2958: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2959: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2960: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2961: FND_MSG_PUB.ADD;
2962: END create_payment_instrument;
2963:
2956:
2957: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2958: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
2959: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2960: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2961: FND_MSG_PUB.ADD;
2962: END create_payment_instrument;
2963:
2964: /*============================================================
3058: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
3059: write_debug_and_log('- Return Status: '||x_return_status);
3060: write_debug_and_log('ERROR =>'|| SQLERRM);
3061:
3062: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3063: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3064: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3065: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3066: FND_MSG_PUB.ADD;
3059: write_debug_and_log('- Return Status: '||x_return_status);
3060: write_debug_and_log('ERROR =>'|| SQLERRM);
3061:
3062: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3063: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3064: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3065: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3066: FND_MSG_PUB.ADD;
3067:
3060: write_debug_and_log('ERROR =>'|| SQLERRM);
3061:
3062: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3063: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3064: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3065: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3066: FND_MSG_PUB.ADD;
3067:
3068: END create_cc_bill_to_site;
3061:
3062: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3063: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3064: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3065: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3066: FND_MSG_PUB.ADD;
3067:
3068: END create_cc_bill_to_site;
3069:
3179: write_debug_and_log('- Bank Account Id: '||p_bank_account_id);
3180: write_debug_and_log('- Return Status: '||p_status);
3181: write_debug_and_log('ERROR =>'|| SQLERRM);
3182:
3183: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3184: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3185: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3186: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3187: FND_MSG_PUB.ADD;
3180: write_debug_and_log('- Return Status: '||p_status);
3181: write_debug_and_log('ERROR =>'|| SQLERRM);
3182:
3183: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3184: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3185: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3186: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3187: FND_MSG_PUB.ADD;
3188:
3181: write_debug_and_log('ERROR =>'|| SQLERRM);
3182:
3183: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3184: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3185: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3186: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3187: FND_MSG_PUB.ADD;
3188:
3189: END create_receipt;
3182:
3183: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3184: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3185: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3186: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3187: FND_MSG_PUB.ADD;
3188:
3189: END create_receipt;
3190:
3506: write_debug_and_log('- Cash Receipt Id: '||p_cash_receipt_id);
3507: write_debug_and_log('- Return Status: '||p_return_status);
3508: write_debug_and_log(SQLERRM);
3509:
3510: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3511: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3512: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3513: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3514: FND_MSG_PUB.ADD;
3507: write_debug_and_log('- Return Status: '||p_return_status);
3508: write_debug_and_log(SQLERRM);
3509:
3510: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3511: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3512: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3513: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3514: FND_MSG_PUB.ADD;
3515: END;
3508: write_debug_and_log(SQLERRM);
3509:
3510: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3511: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3512: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3513: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3514: FND_MSG_PUB.ADD;
3515: END;
3516:
3509:
3510: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3511: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3512: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3513: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3514: FND_MSG_PUB.ADD;
3515: END;
3516:
3517: END apply_cash;
3670: END;
3671:
3672: ROLLBACK TO service_charge_sp;
3673:
3674: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3675: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3676: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3677: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3678: FND_MSG_PUB.ADD;
3671:
3672: ROLLBACK TO service_charge_sp;
3673:
3674: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3675: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3676: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3677: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3678: FND_MSG_PUB.ADD;
3679:
3672: ROLLBACK TO service_charge_sp;
3673:
3674: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3675: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3676: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3677: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3678: FND_MSG_PUB.ADD;
3679:
3680: END get_service_charge;
3673:
3674: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3675: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3676: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3677: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3678: FND_MSG_PUB.ADD;
3679:
3680: END get_service_charge;
3681:
3793: write_debug_and_log('- Total Service charge: '||l_total_service_charge);
3794: write_debug_and_log('- Return Status: '||l_return_status);
3795: write_debug_and_log(SQLERRM);
3796:
3797: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3798: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3799: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3800: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3801: FND_MSG_PUB.ADD;
3794: write_debug_and_log('- Return Status: '||l_return_status);
3795: write_debug_and_log(SQLERRM);
3796:
3797: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3798: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3799: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3800: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3801: FND_MSG_PUB.ADD;
3802: END;
3795: write_debug_and_log(SQLERRM);
3796:
3797: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3798: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3799: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3800: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3801: FND_MSG_PUB.ADD;
3802: END;
3803:
3796:
3797: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
3798: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
3799: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3800: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3801: FND_MSG_PUB.ADD;
3802: END;
3803:
3804: END apply_service_charge;
4564: write_debug_and_log('- Cash Receipt Id: '||p_cash_receipt_id);
4565: write_debug_and_log('- Return Status: '||p_status);
4566: write_debug_and_log('ERROR =>'|| SQLERRM);
4567:
4568: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4569: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4570: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4571: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4572: FND_MSG_PUB.ADD;
4565: write_debug_and_log('- Return Status: '||p_status);
4566: write_debug_and_log('ERROR =>'|| SQLERRM);
4567:
4568: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4569: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4570: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4571: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4572: FND_MSG_PUB.ADD;
4573:
4566: write_debug_and_log('ERROR =>'|| SQLERRM);
4567:
4568: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4569: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4570: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4571: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4572: FND_MSG_PUB.ADD;
4573:
4574: p_status := FND_API.G_RET_STS_ERROR;
4567:
4568: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4569: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4570: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4571: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4572: FND_MSG_PUB.ADD;
4573:
4574: p_status := FND_API.G_RET_STS_ERROR;
4575: write_error_messages(x_msg_data, x_msg_count);
4677: elsif rct_info.creation_status = 'CONFIRMED' THEN
4678: l_action := 'AUTHONLY';
4679: else
4680: arp_standard.debug('ERROR: Creation status is ' || rct_info.creation_status);
4681: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');
4682: FND_MSG_PUB.Add;
4683:
4684: x_return_status := FND_API.G_RET_STS_ERROR; -- should never happen
4685: RETURN;
4759:
4760: if (l_return_status <> FND_API.G_RET_STS_SUCCESS)
4761: AND (NVL(p_called_from,'NONE') = 'IREC') then
4762:
4763: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
4764: FND_MSG_PUB.Add;
4765: x_return_status := l_return_status;
4766: --Bug 7673372 - When IBY API throws an error without contacting 3rd pmt system the error msg would
4767: --returned in x_response.Result_Message;
4824: --Add message to message stack only it it is called from iReceivables
4825: --if not pass the message stack received from iPayment
4826:
4827: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) AND (NVL(p_called_from,'NONE') = 'IREC') then
4828: FND_MESSAGE.set_name('AR', 'AR_CC_CAPTURE_FAILED');
4829: FND_MSG_PUB.Add;
4830: end if;
4831: x_return_status := l_return_status;
4832: --Bug 7673372 - When IBY API throws an error without contacting 3rd pmt system the error msg would
4851: write_debug_and_log('- Cash Receipt Id: '||p_cash_receipt_id);
4852: write_debug_and_log('- Return Status: '||x_return_status);
4853: write_debug_and_log(SQLERRM);
4854:
4855: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4856: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4857: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4858: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4859: FND_MSG_PUB.ADD;
4852: write_debug_and_log('- Return Status: '||x_return_status);
4853: write_debug_and_log(SQLERRM);
4854:
4855: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4856: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4857: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4858: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4859: FND_MSG_PUB.ADD;
4860: END;
4853: write_debug_and_log(SQLERRM);
4854:
4855: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4856: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4857: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4858: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4859: FND_MSG_PUB.ADD;
4860: END;
4861:
4854:
4855: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
4856: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
4857: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4858: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4859: FND_MSG_PUB.ADD;
4860: END;
4861:
4862: END process_payment;
5187: END IF;
5188:
5189: ROLLBACK to create_trx_list_record_sp;
5190:
5191: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5192: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5193: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5194: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5195: FND_MSG_PUB.ADD;
5188:
5189: ROLLBACK to create_trx_list_record_sp;
5190:
5191: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5192: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5193: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5194: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5195: FND_MSG_PUB.ADD;
5196:
5189: ROLLBACK to create_trx_list_record_sp;
5190:
5191: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5192: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5193: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5194: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5195: FND_MSG_PUB.ADD;
5196:
5197: END create_transaction_list_record;
5190:
5191: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5192: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5193: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5194: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5195: FND_MSG_PUB.ADD;
5196:
5197: END create_transaction_list_record;
5198:
5930: write_debug_and_log('l_location_id'|| l_location_id);
5931: write_debug_and_log('- Return Status: '||x_return_status);
5932: write_debug_and_log(SQLERRM);
5933:
5934: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5935: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5936: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5937: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5938: FND_MSG_PUB.ADD;
5931: write_debug_and_log('- Return Status: '||x_return_status);
5932: write_debug_and_log(SQLERRM);
5933:
5934: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5935: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5936: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5937: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5938: FND_MSG_PUB.ADD;
5939:
5932: write_debug_and_log(SQLERRM);
5933:
5934: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5935: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5936: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5937: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5938: FND_MSG_PUB.ADD;
5939:
5940: END update_cc_bill_to_site;
5933:
5934: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
5935: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
5936: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5937: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5938: FND_MSG_PUB.ADD;
5939:
5940: END update_cc_bill_to_site;
5941:
5998: write_debug_and_log('p_channel_code'|| p_channel_code);
5999: write_debug_and_log('- Return Status: '||x_return_status);
6000: write_debug_and_log(SQLERRM);
6001:
6002: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
6003: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
6004: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6005: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6006: FND_MSG_PUB.ADD;
5999: write_debug_and_log('- Return Status: '||x_return_status);
6000: write_debug_and_log(SQLERRM);
6001:
6002: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
6003: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
6004: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6005: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6006: FND_MSG_PUB.ADD;
6007: END get_payment_channel_attribs;
6000: write_debug_and_log(SQLERRM);
6001:
6002: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
6003: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
6004: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6005: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6006: FND_MSG_PUB.ADD;
6007: END get_payment_channel_attribs;
6008:
6001:
6002: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
6003: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
6004: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6005: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6006: FND_MSG_PUB.ADD;
6007: END get_payment_channel_attribs;
6008:
6009: /*=====================================================================