eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_UPGRADE_CASH_ACCRUAL dependencies on ARP_STANDARD

Line 21: arp_standard.debug(p_msg_text);

17: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)
18: IS
19: BEGIN
20: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
21: arp_standard.debug(p_msg_text);
22: END IF;
23: END;
24:
25: PROCEDURE log(

Line 2592: arp_standard.debug( 'setting the currency context back to null');

2588: p_ae_sys_rec => g_ae_sys_rec,
2589: p_inv_cm => 'I',
2590: p_cash_mfar => 'CASH');
2591:
2592: arp_standard.debug( 'setting the currency context back to null');
2593: fnd_client_info.set_currency_context(NULL);
2594:
2595: END LOOP;
2596: CLOSE c_app;

Line 2616: -- arp_standard.debug( 'setting the currency context back to null');

2612: -- p_app_rec => l_app_rec,
2613: -- p_ae_sys_rec => g_ae_sys_rec,
2614: -- p_inv_cm => 'C',
2615: -- p_cash_mfar => 'CASH');
2616: -- arp_standard.debug( 'setting the currency context back to null');
2617: -- fnd_client_info.set_currency_context(NULL);
2618: -- END LOOP;
2619: -- CLOSE c_cm_from_app;
2620:

Line 2763: arp_standard.debug( 'setting the currency context back to null');

2759: p_ae_sys_rec => g_ae_sys_rec,
2760: p_inv_cm => 'I',
2761: p_cash_mfar => 'MFAR');
2762:
2763: arp_standard.debug( 'setting the currency context back to null');
2764: fnd_client_info.set_currency_context(NULL);
2765:
2766: END LOOP;
2767: CLOSE c_app;

Line 2793: arp_standard.debug( 'setting the currency context back to null');

2789: p_inv_cm => 'C',
2790: p_cash_mfar => 'MFAR');
2791:
2792:
2793: arp_standard.debug( 'setting the currency context back to null');
2794: fnd_client_info.set_currency_context(NULL);
2795:
2796: END LOOP;
2797: CLOSE c_cm_from_app;

Line 2910: arp_standard.debug('COMPARE_RA_REM_AMT +');

2906: over_applications EXCEPTION;
2907:
2908:
2909: BEGIN
2910: arp_standard.debug('COMPARE_RA_REM_AMT +');
2911:
2912: x_app_rec := p_app_rec;
2913:
2914: ARP_DET_DIST_PKG.get_latest_amount_remaining

Line 2960: arp_standard.debug(' l_chrg_app :'||l_chrg_app);

2956: l_entire := l_chrg_entire + l_freight_entire + l_tax_entire + l_line_entire;
2957: l_rem := l_chrg_rem + l_freight_rem + l_tax_rem + l_line_rem;
2958: --
2959:
2960: arp_standard.debug(' l_chrg_app :'||l_chrg_app);
2961: arp_standard.debug(' l_chrg_ed :'||l_chrg_ed);
2962: arp_standard.debug(' l_chrg_uned:'||l_chrg_uned);
2963:
2964: arp_standard.debug(' l_freight_app :'||l_freight_app);

Line 2961: arp_standard.debug(' l_chrg_ed :'||l_chrg_ed);

2957: l_rem := l_chrg_rem + l_freight_rem + l_tax_rem + l_line_rem;
2958: --
2959:
2960: arp_standard.debug(' l_chrg_app :'||l_chrg_app);
2961: arp_standard.debug(' l_chrg_ed :'||l_chrg_ed);
2962: arp_standard.debug(' l_chrg_uned:'||l_chrg_uned);
2963:
2964: arp_standard.debug(' l_freight_app :'||l_freight_app);
2965: arp_standard.debug(' l_freight_ed :'||l_freight_ed);

Line 2962: arp_standard.debug(' l_chrg_uned:'||l_chrg_uned);

2958: --
2959:
2960: arp_standard.debug(' l_chrg_app :'||l_chrg_app);
2961: arp_standard.debug(' l_chrg_ed :'||l_chrg_ed);
2962: arp_standard.debug(' l_chrg_uned:'||l_chrg_uned);
2963:
2964: arp_standard.debug(' l_freight_app :'||l_freight_app);
2965: arp_standard.debug(' l_freight_ed :'||l_freight_ed);
2966: arp_standard.debug(' l_freight_uned:'||l_freight_uned);

Line 2964: arp_standard.debug(' l_freight_app :'||l_freight_app);

2960: arp_standard.debug(' l_chrg_app :'||l_chrg_app);
2961: arp_standard.debug(' l_chrg_ed :'||l_chrg_ed);
2962: arp_standard.debug(' l_chrg_uned:'||l_chrg_uned);
2963:
2964: arp_standard.debug(' l_freight_app :'||l_freight_app);
2965: arp_standard.debug(' l_freight_ed :'||l_freight_ed);
2966: arp_standard.debug(' l_freight_uned:'||l_freight_uned);
2967:
2968: arp_standard.debug(' l_tax_app :'||l_tax_app);

Line 2965: arp_standard.debug(' l_freight_ed :'||l_freight_ed);

2961: arp_standard.debug(' l_chrg_ed :'||l_chrg_ed);
2962: arp_standard.debug(' l_chrg_uned:'||l_chrg_uned);
2963:
2964: arp_standard.debug(' l_freight_app :'||l_freight_app);
2965: arp_standard.debug(' l_freight_ed :'||l_freight_ed);
2966: arp_standard.debug(' l_freight_uned:'||l_freight_uned);
2967:
2968: arp_standard.debug(' l_tax_app :'||l_tax_app);
2969: arp_standard.debug(' l_tax_ed :'||l_tax_ed);

Line 2966: arp_standard.debug(' l_freight_uned:'||l_freight_uned);

2962: arp_standard.debug(' l_chrg_uned:'||l_chrg_uned);
2963:
2964: arp_standard.debug(' l_freight_app :'||l_freight_app);
2965: arp_standard.debug(' l_freight_ed :'||l_freight_ed);
2966: arp_standard.debug(' l_freight_uned:'||l_freight_uned);
2967:
2968: arp_standard.debug(' l_tax_app :'||l_tax_app);
2969: arp_standard.debug(' l_tax_ed :'||l_tax_ed);
2970: arp_standard.debug(' l_tax_uned:'||l_tax_uned);

Line 2968: arp_standard.debug(' l_tax_app :'||l_tax_app);

2964: arp_standard.debug(' l_freight_app :'||l_freight_app);
2965: arp_standard.debug(' l_freight_ed :'||l_freight_ed);
2966: arp_standard.debug(' l_freight_uned:'||l_freight_uned);
2967:
2968: arp_standard.debug(' l_tax_app :'||l_tax_app);
2969: arp_standard.debug(' l_tax_ed :'||l_tax_ed);
2970: arp_standard.debug(' l_tax_uned:'||l_tax_uned);
2971:
2972: arp_standard.debug(' l_line_app :'||l_line_app);

Line 2969: arp_standard.debug(' l_tax_ed :'||l_tax_ed);

2965: arp_standard.debug(' l_freight_ed :'||l_freight_ed);
2966: arp_standard.debug(' l_freight_uned:'||l_freight_uned);
2967:
2968: arp_standard.debug(' l_tax_app :'||l_tax_app);
2969: arp_standard.debug(' l_tax_ed :'||l_tax_ed);
2970: arp_standard.debug(' l_tax_uned:'||l_tax_uned);
2971:
2972: arp_standard.debug(' l_line_app :'||l_line_app);
2973: arp_standard.debug(' l_line_ed :'||l_line_ed);

Line 2970: arp_standard.debug(' l_tax_uned:'||l_tax_uned);

2966: arp_standard.debug(' l_freight_uned:'||l_freight_uned);
2967:
2968: arp_standard.debug(' l_tax_app :'||l_tax_app);
2969: arp_standard.debug(' l_tax_ed :'||l_tax_ed);
2970: arp_standard.debug(' l_tax_uned:'||l_tax_uned);
2971:
2972: arp_standard.debug(' l_line_app :'||l_line_app);
2973: arp_standard.debug(' l_line_ed :'||l_line_ed);
2974: arp_standard.debug(' l_line_uned:'||l_line_uned);

Line 2972: arp_standard.debug(' l_line_app :'||l_line_app);

2968: arp_standard.debug(' l_tax_app :'||l_tax_app);
2969: arp_standard.debug(' l_tax_ed :'||l_tax_ed);
2970: arp_standard.debug(' l_tax_uned:'||l_tax_uned);
2971:
2972: arp_standard.debug(' l_line_app :'||l_line_app);
2973: arp_standard.debug(' l_line_ed :'||l_line_ed);
2974: arp_standard.debug(' l_line_uned:'||l_line_uned);
2975:
2976: arp_standard.debug(' Sum of all the bucket of the application :'||l_entire);

Line 2973: arp_standard.debug(' l_line_ed :'||l_line_ed);

2969: arp_standard.debug(' l_tax_ed :'||l_tax_ed);
2970: arp_standard.debug(' l_tax_uned:'||l_tax_uned);
2971:
2972: arp_standard.debug(' l_line_app :'||l_line_app);
2973: arp_standard.debug(' l_line_ed :'||l_line_ed);
2974: arp_standard.debug(' l_line_uned:'||l_line_uned);
2975:
2976: arp_standard.debug(' Sum of all the bucket of the application :'||l_entire);
2977: arp_standard.debug(' Sum of all the remaining bucket on transaction :'||l_rem);

Line 2974: arp_standard.debug(' l_line_uned:'||l_line_uned);

2970: arp_standard.debug(' l_tax_uned:'||l_tax_uned);
2971:
2972: arp_standard.debug(' l_line_app :'||l_line_app);
2973: arp_standard.debug(' l_line_ed :'||l_line_ed);
2974: arp_standard.debug(' l_line_uned:'||l_line_uned);
2975:
2976: arp_standard.debug(' Sum of all the bucket of the application :'||l_entire);
2977: arp_standard.debug(' Sum of all the remaining bucket on transaction :'||l_rem);
2978:

Line 2976: arp_standard.debug(' Sum of all the bucket of the application :'||l_entire);

2972: arp_standard.debug(' l_line_app :'||l_line_app);
2973: arp_standard.debug(' l_line_ed :'||l_line_ed);
2974: arp_standard.debug(' l_line_uned:'||l_line_uned);
2975:
2976: arp_standard.debug(' Sum of all the bucket of the application :'||l_entire);
2977: arp_standard.debug(' Sum of all the remaining bucket on transaction :'||l_rem);
2978:
2979:
2980: --

Line 2977: arp_standard.debug(' Sum of all the remaining bucket on transaction :'||l_rem);

2973: arp_standard.debug(' l_line_ed :'||l_line_ed);
2974: arp_standard.debug(' l_line_uned:'||l_line_uned);
2975:
2976: arp_standard.debug(' Sum of all the bucket of the application :'||l_entire);
2977: arp_standard.debug(' Sum of all the remaining bucket on transaction :'||l_rem);
2978:
2979:
2980: --
2981: -- We should verify that all rem are less or equal to the all buckets of the application

Line 2985: arp_standard.debug(' SUM_ALL_APP_BUCKET > SUM_ALL_REM_BUCKET - Overapplication');

2981: -- We should verify that all rem are less or equal to the all buckets of the application
2982: -- Otherwise this is a abnormal situation as it means overapplication
2983: --
2984: IF l_entire > l_rem THEN
2985: arp_standard.debug(' SUM_ALL_APP_BUCKET > SUM_ALL_REM_BUCKET - Overapplication');
2986: RAISE over_applications;
2987: END IF;
2988:
2989: --

Line 2992: arp_standard.debug(' l_run_rem :'||l_run_rem);

2988:
2989: --
2990: --Prorate sum of apps over rem
2991: --
2992: arp_standard.debug(' l_run_rem :'||l_run_rem);
2993: arp_standard.debug(' l_line_rem :'||l_line_rem);
2994:
2995: l_run_rem := l_run_rem + l_line_rem;
2996:

Line 2993: arp_standard.debug(' l_line_rem :'||l_line_rem);

2989: --
2990: --Prorate sum of apps over rem
2991: --
2992: arp_standard.debug(' l_run_rem :'||l_run_rem);
2993: arp_standard.debug(' l_line_rem :'||l_line_rem);
2994:
2995: l_run_rem := l_run_rem + l_line_rem;
2996:
2997: l_line_apps := arpcurr.CurrRound( l_run_rem

Line 3005: arp_standard.debug(' l_line_apps :'||l_line_apps);

3001: - l_run_apps;
3002:
3003: l_run_apps := l_run_apps + l_line_apps;
3004:
3005: arp_standard.debug(' l_line_apps :'||l_line_apps);
3006: arp_standard.debug(' l_run_apps :'||l_run_apps);
3007:
3008: --
3009:

Line 3006: arp_standard.debug(' l_run_apps :'||l_run_apps);

3002:
3003: l_run_apps := l_run_apps + l_line_apps;
3004:
3005: arp_standard.debug(' l_line_apps :'||l_line_apps);
3006: arp_standard.debug(' l_run_apps :'||l_run_apps);
3007:
3008: --
3009:
3010: arp_standard.debug(' l_run_rem :'||l_run_rem);

Line 3010: arp_standard.debug(' l_run_rem :'||l_run_rem);

3006: arp_standard.debug(' l_run_apps :'||l_run_apps);
3007:
3008: --
3009:
3010: arp_standard.debug(' l_run_rem :'||l_run_rem);
3011: arp_standard.debug(' l_tax_rem :'||l_tax_rem);
3012:
3013: l_run_rem := l_run_rem + l_tax_rem;
3014:

Line 3011: arp_standard.debug(' l_tax_rem :'||l_tax_rem);

3007:
3008: --
3009:
3010: arp_standard.debug(' l_run_rem :'||l_run_rem);
3011: arp_standard.debug(' l_tax_rem :'||l_tax_rem);
3012:
3013: l_run_rem := l_run_rem + l_tax_rem;
3014:
3015: l_tax_apps := arpcurr.CurrRound( l_run_rem

Line 3024: arp_standard.debug(' l_tax_apps :'||l_tax_apps);

3020:
3021:
3022: l_run_apps := l_run_apps + l_tax_apps;
3023:
3024: arp_standard.debug(' l_tax_apps :'||l_tax_apps);
3025: arp_standard.debug(' l_run_apps :'||l_run_apps);
3026:
3027: --
3028: arp_standard.debug(' l_run_rem :'||l_run_rem);

Line 3025: arp_standard.debug(' l_run_apps :'||l_run_apps);

3021:
3022: l_run_apps := l_run_apps + l_tax_apps;
3023:
3024: arp_standard.debug(' l_tax_apps :'||l_tax_apps);
3025: arp_standard.debug(' l_run_apps :'||l_run_apps);
3026:
3027: --
3028: arp_standard.debug(' l_run_rem :'||l_run_rem);
3029: arp_standard.debug(' l_freight_rem :'||l_freight_rem);

Line 3028: arp_standard.debug(' l_run_rem :'||l_run_rem);

3024: arp_standard.debug(' l_tax_apps :'||l_tax_apps);
3025: arp_standard.debug(' l_run_apps :'||l_run_apps);
3026:
3027: --
3028: arp_standard.debug(' l_run_rem :'||l_run_rem);
3029: arp_standard.debug(' l_freight_rem :'||l_freight_rem);
3030:
3031: l_run_rem := l_run_rem + l_freight_rem;
3032:

Line 3029: arp_standard.debug(' l_freight_rem :'||l_freight_rem);

3025: arp_standard.debug(' l_run_apps :'||l_run_apps);
3026:
3027: --
3028: arp_standard.debug(' l_run_rem :'||l_run_rem);
3029: arp_standard.debug(' l_freight_rem :'||l_freight_rem);
3030:
3031: l_run_rem := l_run_rem + l_freight_rem;
3032:
3033: l_freight_apps := arpcurr.CurrRound( l_run_rem

Line 3042: arp_standard.debug(' l_freight_apps :'||l_freight_apps);

3038:
3039:
3040: l_run_apps := l_run_apps + l_freight_apps;
3041:
3042: arp_standard.debug(' l_freight_apps :'||l_freight_apps);
3043: arp_standard.debug(' l_run_apps :'||l_run_apps);
3044: --
3045: arp_standard.debug(' l_run_rem :'||l_run_rem);
3046: arp_standard.debug(' l_chrg_rem :'||l_chrg_rem);

Line 3043: arp_standard.debug(' l_run_apps :'||l_run_apps);

3039:
3040: l_run_apps := l_run_apps + l_freight_apps;
3041:
3042: arp_standard.debug(' l_freight_apps :'||l_freight_apps);
3043: arp_standard.debug(' l_run_apps :'||l_run_apps);
3044: --
3045: arp_standard.debug(' l_run_rem :'||l_run_rem);
3046: arp_standard.debug(' l_chrg_rem :'||l_chrg_rem);
3047:

Line 3045: arp_standard.debug(' l_run_rem :'||l_run_rem);

3041:
3042: arp_standard.debug(' l_freight_apps :'||l_freight_apps);
3043: arp_standard.debug(' l_run_apps :'||l_run_apps);
3044: --
3045: arp_standard.debug(' l_run_rem :'||l_run_rem);
3046: arp_standard.debug(' l_chrg_rem :'||l_chrg_rem);
3047:
3048: l_run_rem := l_run_rem + l_chrg_rem;
3049:

Line 3046: arp_standard.debug(' l_chrg_rem :'||l_chrg_rem);

3042: arp_standard.debug(' l_freight_apps :'||l_freight_apps);
3043: arp_standard.debug(' l_run_apps :'||l_run_apps);
3044: --
3045: arp_standard.debug(' l_run_rem :'||l_run_rem);
3046: arp_standard.debug(' l_chrg_rem :'||l_chrg_rem);
3047:
3048: l_run_rem := l_run_rem + l_chrg_rem;
3049:
3050: l_chrg_apps := arpcurr.CurrRound( l_run_rem

Line 3059: arp_standard.debug(' l_chrg_apps :'||l_chrg_apps);

3055:
3056:
3057: l_run_apps := l_run_apps + l_chrg_apps;
3058:
3059: arp_standard.debug(' l_chrg_apps :'||l_chrg_apps);
3060: arp_standard.debug(' l_run_apps :'||l_run_apps);
3061:
3062: IF l_line_apps <> l_line_entire THEN
3063: l_line_apps := l_line_apps - l_line_ed - l_line_uned;

Line 3060: arp_standard.debug(' l_run_apps :'||l_run_apps);

3056:
3057: l_run_apps := l_run_apps + l_chrg_apps;
3058:
3059: arp_standard.debug(' l_chrg_apps :'||l_chrg_apps);
3060: arp_standard.debug(' l_run_apps :'||l_run_apps);
3061:
3062: IF l_line_apps <> l_line_entire THEN
3063: l_line_apps := l_line_apps - l_line_ed - l_line_uned;
3064: END IF;

Line 3082: arp_standard.debug('COMPARE_RA_REM_AMT -');

3078: x_app_rec.LINE_APPLIED := l_line_apps;
3079: x_app_rec.TAX_APPLIED := l_tax_apps;
3080: x_app_rec.FREIGHT_APPLIED := l_freight_apps;
3081: x_app_rec.RECEIVABLES_CHARGES_APPLIED:= l_chrg_apps;
3082: arp_standard.debug('COMPARE_RA_REM_AMT -');
3083:
3084: EXCEPTION
3085: WHEN over_applications THEN
3086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3092: arp_standard.debug('EXCEPTION fnd_api.g_exc_error - over applications ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT

3088: FND_MESSAGE.SET_TOKEN( 'TEXT', 'EXCEPTION over_applications in ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT
3089: sum amount remaining from the invoice:'||l_rem ||'
3090: sum of application buckets :'||l_entire );
3091: FND_MSG_PUB.ADD;
3092: arp_standard.debug('EXCEPTION fnd_api.g_exc_error - over applications ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT
3093: sum amount remaining from the invoice:'||l_rem ||'
3094: sum of application buckets :'||l_entire );
3095: WHEN fnd_api.g_exc_error THEN
3096: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

Line 3099: arp_standard.debug('EXCEPTION fnd_api.g_exc_error - fnd_api.g_exc_error ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT');

3095: WHEN fnd_api.g_exc_error THEN
3096: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
3097: FND_MESSAGE.SET_TOKEN( 'TEXT', 'EXCEPTION fnd_api.g_exc_error in ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT' );
3098: FND_MSG_PUB.ADD;
3099: arp_standard.debug('EXCEPTION fnd_api.g_exc_error - fnd_api.g_exc_error ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT');
3100: WHEN OTHERS THEN
3101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3102: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
3103: FND_MESSAGE.SET_TOKEN( 'TEXT', 'EXCEPTION - OTHERS ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT: '||SQLERRM );

Line 3105: arp_standard.debug('EXCEPTION - OTHERS ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT: '||SQLERRM);

3101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3102: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
3103: FND_MESSAGE.SET_TOKEN( 'TEXT', 'EXCEPTION - OTHERS ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT: '||SQLERRM );
3104: FND_MSG_PUB.ADD;
3105: arp_standard.debug('EXCEPTION - OTHERS ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT: '||SQLERRM);
3106: END COMPARE_RA_REM_AMT;
3107:
3108:
3109:

Line 3116: arp_standard.debug('stamping_11i_mfar_app_post +');

3112:
3113: PROCEDURE stamping_11i_mfar_app_post
3114: IS
3115: BEGIN
3116: arp_standard.debug('stamping_11i_mfar_app_post +');
3117: UPDATE ar_receivable_applications_all ra
3118: SET ra.upgrade_method = 'R12_11IMFAR_POST'
3119: WHERE ra.receivable_application_id IN (
3120: SELECT app.receivable_application_id

Line 3152: arp_standard.debug('stamping_11i_mfar_app_post -');

3148: AND adj.upgrade_method = '11I'
3149: AND adj.status = 'A'
3150: AND adj.postable = 'Y')
3151: );
3152: arp_standard.debug('stamping_11i_mfar_app_post -');
3153: EXCEPTION
3154: WHEN OTHERS THEN
3155: arp_standard.debug('EXCEPTION OTHERS : stamping_11i_mfar_app_post :' || SQLERRM);
3156: RAISE;

Line 3155: arp_standard.debug('EXCEPTION OTHERS : stamping_11i_mfar_app_post :' || SQLERRM);

3151: );
3152: arp_standard.debug('stamping_11i_mfar_app_post -');
3153: EXCEPTION
3154: WHEN OTHERS THEN
3155: arp_standard.debug('EXCEPTION OTHERS : stamping_11i_mfar_app_post :' || SQLERRM);
3156: RAISE;
3157: END stamping_11i_mfar_app_post;
3158:
3159:

Line 3164: arp_standard.debug('stamping_11i_cash_app_post +');

3160:
3161: PROCEDURE stamping_11i_cash_app_post
3162: IS
3163: BEGIN
3164: arp_standard.debug('stamping_11i_cash_app_post +');
3165: UPDATE ar_receivable_applications_all ra
3166: SET ra.upgrade_method = 'R12_11ICASH_POST'
3167: WHERE ra.receivable_application_id IN (
3168: SELECT app.receivable_application_id

Line 3184: arp_standard.debug('stamping_11i_cash_app_post -');

3180: WHERE adj.customer_trx_id = app.applied_customer_trx_id
3181: AND adj.upgrade_method = '11I'
3182: AND adj.status = 'A'
3183: AND adj.postable = 'Y'));
3184: arp_standard.debug('stamping_11i_cash_app_post -');
3185: EXCEPTION
3186: WHEN OTHERS THEN
3187: arp_standard.debug('EXCEPTION OTHERS : stamping_11i_mfar_app_post :' || SQLERRM);
3188: RAISE;

Line 3187: arp_standard.debug('EXCEPTION OTHERS : stamping_11i_mfar_app_post :' || SQLERRM);

3183: AND adj.postable = 'Y'));
3184: arp_standard.debug('stamping_11i_cash_app_post -');
3185: EXCEPTION
3186: WHEN OTHERS THEN
3187: arp_standard.debug('EXCEPTION OTHERS : stamping_11i_mfar_app_post :' || SQLERRM);
3188: RAISE;
3189: END stamping_11i_cash_app_post;
3190:
3191:

Line 3238: arp_standard.debug(' portion_to_move +');

3234: l_tax_portion NUMBER;
3235: l_freight_portion NUMBER;
3236: l_chrg_portion NUMBER;
3237: BEGIN
3238: arp_standard.debug(' portion_to_move +');
3239: arp_standard.debug(' p_total_to_move :'|| p_total_to_move);
3240: arp_standard.debug(' p_freight_ratio :'|| p_freight_ratio);
3241: arp_standard.debug(' p_tax_ratio :'|| p_tax_ratio);
3242: arp_standard.debug(' p_line_ratio :'|| p_line_ratio);

Line 3239: arp_standard.debug(' p_total_to_move :'|| p_total_to_move);

3235: l_freight_portion NUMBER;
3236: l_chrg_portion NUMBER;
3237: BEGIN
3238: arp_standard.debug(' portion_to_move +');
3239: arp_standard.debug(' p_total_to_move :'|| p_total_to_move);
3240: arp_standard.debug(' p_freight_ratio :'|| p_freight_ratio);
3241: arp_standard.debug(' p_tax_ratio :'|| p_tax_ratio);
3242: arp_standard.debug(' p_line_ratio :'|| p_line_ratio);
3243: arp_standard.debug(' p_chrg_ratio :'|| p_chrg_ratio);

Line 3240: arp_standard.debug(' p_freight_ratio :'|| p_freight_ratio);

3236: l_chrg_portion NUMBER;
3237: BEGIN
3238: arp_standard.debug(' portion_to_move +');
3239: arp_standard.debug(' p_total_to_move :'|| p_total_to_move);
3240: arp_standard.debug(' p_freight_ratio :'|| p_freight_ratio);
3241: arp_standard.debug(' p_tax_ratio :'|| p_tax_ratio);
3242: arp_standard.debug(' p_line_ratio :'|| p_line_ratio);
3243: arp_standard.debug(' p_chrg_ratio :'|| p_chrg_ratio);
3244:

Line 3241: arp_standard.debug(' p_tax_ratio :'|| p_tax_ratio);

3237: BEGIN
3238: arp_standard.debug(' portion_to_move +');
3239: arp_standard.debug(' p_total_to_move :'|| p_total_to_move);
3240: arp_standard.debug(' p_freight_ratio :'|| p_freight_ratio);
3241: arp_standard.debug(' p_tax_ratio :'|| p_tax_ratio);
3242: arp_standard.debug(' p_line_ratio :'|| p_line_ratio);
3243: arp_standard.debug(' p_chrg_ratio :'|| p_chrg_ratio);
3244:
3245: IF (p_total_to_move IS NOT NULL) THEN l_total_to_move := p_total_to_move; END IF;

Line 3242: arp_standard.debug(' p_line_ratio :'|| p_line_ratio);

3238: arp_standard.debug(' portion_to_move +');
3239: arp_standard.debug(' p_total_to_move :'|| p_total_to_move);
3240: arp_standard.debug(' p_freight_ratio :'|| p_freight_ratio);
3241: arp_standard.debug(' p_tax_ratio :'|| p_tax_ratio);
3242: arp_standard.debug(' p_line_ratio :'|| p_line_ratio);
3243: arp_standard.debug(' p_chrg_ratio :'|| p_chrg_ratio);
3244:
3245: IF (p_total_to_move IS NOT NULL) THEN l_total_to_move := p_total_to_move; END IF;
3246: IF (p_freight_ratio IS NOT NULL) THEN l_freight_ratio := p_freight_ratio; END IF;

Line 3243: arp_standard.debug(' p_chrg_ratio :'|| p_chrg_ratio);

3239: arp_standard.debug(' p_total_to_move :'|| p_total_to_move);
3240: arp_standard.debug(' p_freight_ratio :'|| p_freight_ratio);
3241: arp_standard.debug(' p_tax_ratio :'|| p_tax_ratio);
3242: arp_standard.debug(' p_line_ratio :'|| p_line_ratio);
3243: arp_standard.debug(' p_chrg_ratio :'|| p_chrg_ratio);
3244:
3245: IF (p_total_to_move IS NOT NULL) THEN l_total_to_move := p_total_to_move; END IF;
3246: IF (p_freight_ratio IS NOT NULL) THEN l_freight_ratio := p_freight_ratio; END IF;
3247: IF (p_tax_ratio IS NOT NULL) THEN l_tax_ratio := p_tax_ratio; END IF;

Line 3254: arp_standard.debug('The amount to move is 0, we return 0 for all portion');

3250:
3251: l_sum_base := l_freight_ratio + l_tax_ratio + l_line_ratio + l_chrg_ratio;
3252:
3253: IF l_total_to_move = 0 THEN
3254: arp_standard.debug('The amount to move is 0, we return 0 for all portion');
3255: x_freight_portion := 0;
3256: x_tax_portion := 0;
3257: x_line_portion := 0;
3258: x_chrg_portion := 0;

Line 3260: arp_standard.debug('The sum of all ratio is 0, we return 0 for all portion');

3256: x_tax_portion := 0;
3257: x_line_portion := 0;
3258: x_chrg_portion := 0;
3259: ELSIF l_sum_base = 0 THEN
3260: arp_standard.debug('The sum of all ratio is 0, we return 0 for all portion');
3261: x_freight_portion := 0;
3262: x_tax_portion := 0;
3263: x_line_portion := 0;
3264: x_chrg_portion := 0;

Line 3306: arp_standard.debug('EXCEPTION OTHERS - portion_to_move '||SQLERRM);

3302: x_chrg_portion := l_chrg_portion;
3303: END IF;
3304: EXCEPTION
3305: WHEN OTHERS THEN
3306: arp_standard.debug('EXCEPTION OTHERS - portion_to_move '||SQLERRM);
3307: RAISE;
3308: END;
3309:
3310: ---------------------------------------

Line 3374: arp_standard.debug('move_bucket +');

3370: frt_rem_greater_frt_app EXCEPTION;
3371: tax_rem_greater_tax_app EXCEPTION;
3372: --
3373: BEGIN
3374: arp_standard.debug('move_bucket +');
3375:
3376: l_line_entire := p_line_entire;
3377: l_freight_entire := p_freight_entire;
3378: l_tax_entire := p_tax_entire;

Line 3400: arp_standard.debug('moving portion charges bucket to other line, tax, freight bucket');

3396: -- This is due to PSA legacy data because the charges adjusted are over all type of line
3397: -- hence a portion of remaing charges are affected to other buckets such as freight or tax
3398: --
3399: IF l_entire > l_rem THEN
3400: arp_standard.debug('moving portion charges bucket to other line, tax, freight bucket');
3401: l_to_move := l_entire - l_rem;
3402: l_chrg_entire := l_entire - l_to_move;
3403: ELSE
3404: RAISE chrg_rem_greater_chrg_app;

Line 3421: arp_standard.debug('moving portion freight bucket to line and tax');

3417: l_line_ratio := p_line_entire;
3418: l_chrg_ratio := 0;
3419:
3420: IF l_entire > l_rem THEN
3421: arp_standard.debug('moving portion freight bucket to line and tax');
3422: l_to_move := l_entire - l_rem;
3423: l_freight_entire := l_entire - l_to_move;
3424: ELSE
3425: RAISE frt_rem_greater_frt_app;

Line 3442: arp_standard.debug('moving portion tax bucket to other line');

3438: l_line_ratio := p_line_entire;
3439: l_chrg_ratio := 0;
3440:
3441: IF l_entire > l_rem THEN
3442: arp_standard.debug('moving portion tax bucket to other line');
3443: l_to_move := l_entire - l_rem;
3444: l_tax_entire := l_entire - l_to_move;
3445: ELSE
3446: RAISE tax_rem_greater_tax_app;

Line 3467: arp_standard.debug(' '||p_which_bucket||' to move : '|| l_to_move );

3463: IF l_entire > l_rem THEN
3464:
3465: -- logic of charges movement.
3466: -- Move charge equivalently over line - tax - freight
3467: arp_standard.debug(' '||p_which_bucket||' to move : '|| l_to_move );
3468:
3469: portion_to_move
3470: (p_total_to_move => l_to_move,
3471: p_freight_ratio => l_freight_ratio,

Line 3487: arp_standard.debug(' x_line_entire :'|| x_line_entire);

3483: x_tax_entire := l_tax_entire + l_tax_portion;
3484: x_chrg_entire := l_chrg_entire + l_chrg_portion;
3485:
3486: END IF;
3487: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3488: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3489: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3490: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3491: arp_standard.debug('move_bucket -');

Line 3488: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);

3484: x_chrg_entire := l_chrg_entire + l_chrg_portion;
3485:
3486: END IF;
3487: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3488: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3489: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3490: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3491: arp_standard.debug('move_bucket -');
3492: EXCEPTION

Line 3489: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);

3485:
3486: END IF;
3487: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3488: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3489: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3490: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3491: arp_standard.debug('move_bucket -');
3492: EXCEPTION
3493: WHEN chrg_rem_greater_chrg_app THEN

Line 3490: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);

3486: END IF;
3487: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3488: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3489: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3490: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3491: arp_standard.debug('move_bucket -');
3492: EXCEPTION
3493: WHEN chrg_rem_greater_chrg_app THEN
3494: x_line_entire := p_line_entire;

Line 3491: arp_standard.debug('move_bucket -');

3487: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3488: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3489: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3490: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3491: arp_standard.debug('move_bucket -');
3492: EXCEPTION
3493: WHEN chrg_rem_greater_chrg_app THEN
3494: x_line_entire := p_line_entire;
3495: x_freight_entire := p_freight_entire;

Line 3498: arp_standard.debug(' USER EXCEPTION chrg_rem_greater_chrg_app');

3494: x_line_entire := p_line_entire;
3495: x_freight_entire := p_freight_entire;
3496: x_tax_entire := p_tax_entire;
3497: x_chrg_entire := p_chrg_entire;
3498: arp_standard.debug(' USER EXCEPTION chrg_rem_greater_chrg_app');
3499: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3500: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3501: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3502: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);

Line 3499: arp_standard.debug(' x_line_entire :'|| x_line_entire);

3495: x_freight_entire := p_freight_entire;
3496: x_tax_entire := p_tax_entire;
3497: x_chrg_entire := p_chrg_entire;
3498: arp_standard.debug(' USER EXCEPTION chrg_rem_greater_chrg_app');
3499: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3500: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3501: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3502: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3503: arp_standard.debug('move_bucket -');

Line 3500: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);

3496: x_tax_entire := p_tax_entire;
3497: x_chrg_entire := p_chrg_entire;
3498: arp_standard.debug(' USER EXCEPTION chrg_rem_greater_chrg_app');
3499: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3500: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3501: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3502: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3503: arp_standard.debug('move_bucket -');
3504: WHEN frt_rem_greater_frt_app THEN

Line 3501: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);

3497: x_chrg_entire := p_chrg_entire;
3498: arp_standard.debug(' USER EXCEPTION chrg_rem_greater_chrg_app');
3499: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3500: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3501: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3502: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3503: arp_standard.debug('move_bucket -');
3504: WHEN frt_rem_greater_frt_app THEN
3505: x_line_entire := p_line_entire;

Line 3502: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);

3498: arp_standard.debug(' USER EXCEPTION chrg_rem_greater_chrg_app');
3499: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3500: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3501: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3502: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3503: arp_standard.debug('move_bucket -');
3504: WHEN frt_rem_greater_frt_app THEN
3505: x_line_entire := p_line_entire;
3506: x_freight_entire := p_freight_entire;

Line 3503: arp_standard.debug('move_bucket -');

3499: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3500: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3501: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3502: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3503: arp_standard.debug('move_bucket -');
3504: WHEN frt_rem_greater_frt_app THEN
3505: x_line_entire := p_line_entire;
3506: x_freight_entire := p_freight_entire;
3507: x_tax_entire := p_tax_entire;

Line 3509: arp_standard.debug(' USER EXCEPTION frt_rem_greater_frt_app');

3505: x_line_entire := p_line_entire;
3506: x_freight_entire := p_freight_entire;
3507: x_tax_entire := p_tax_entire;
3508: x_chrg_entire := p_chrg_entire;
3509: arp_standard.debug(' USER EXCEPTION frt_rem_greater_frt_app');
3510: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3511: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3512: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3513: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);

Line 3510: arp_standard.debug(' x_line_entire :'|| x_line_entire);

3506: x_freight_entire := p_freight_entire;
3507: x_tax_entire := p_tax_entire;
3508: x_chrg_entire := p_chrg_entire;
3509: arp_standard.debug(' USER EXCEPTION frt_rem_greater_frt_app');
3510: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3511: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3512: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3513: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3514: arp_standard.debug('move_bucket -');

Line 3511: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);

3507: x_tax_entire := p_tax_entire;
3508: x_chrg_entire := p_chrg_entire;
3509: arp_standard.debug(' USER EXCEPTION frt_rem_greater_frt_app');
3510: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3511: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3512: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3513: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3514: arp_standard.debug('move_bucket -');
3515: WHEN tax_rem_greater_tax_app THEN

Line 3512: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);

3508: x_chrg_entire := p_chrg_entire;
3509: arp_standard.debug(' USER EXCEPTION frt_rem_greater_frt_app');
3510: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3511: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3512: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3513: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3514: arp_standard.debug('move_bucket -');
3515: WHEN tax_rem_greater_tax_app THEN
3516: x_line_entire := p_line_entire;

Line 3513: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);

3509: arp_standard.debug(' USER EXCEPTION frt_rem_greater_frt_app');
3510: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3511: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3512: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3513: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3514: arp_standard.debug('move_bucket -');
3515: WHEN tax_rem_greater_tax_app THEN
3516: x_line_entire := p_line_entire;
3517: x_freight_entire := p_freight_entire;

Line 3514: arp_standard.debug('move_bucket -');

3510: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3511: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3512: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3513: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3514: arp_standard.debug('move_bucket -');
3515: WHEN tax_rem_greater_tax_app THEN
3516: x_line_entire := p_line_entire;
3517: x_freight_entire := p_freight_entire;
3518: x_tax_entire := p_tax_entire;

Line 3520: arp_standard.debug(' USER EXCEPTION tax_rem_greater_tax_app');

3516: x_line_entire := p_line_entire;
3517: x_freight_entire := p_freight_entire;
3518: x_tax_entire := p_tax_entire;
3519: x_chrg_entire := p_chrg_entire;
3520: arp_standard.debug(' USER EXCEPTION tax_rem_greater_tax_app');
3521: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3522: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3523: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3524: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);

Line 3521: arp_standard.debug(' x_line_entire :'|| x_line_entire);

3517: x_freight_entire := p_freight_entire;
3518: x_tax_entire := p_tax_entire;
3519: x_chrg_entire := p_chrg_entire;
3520: arp_standard.debug(' USER EXCEPTION tax_rem_greater_tax_app');
3521: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3522: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3523: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3524: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3525: arp_standard.debug('move_bucket -');

Line 3522: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);

3518: x_tax_entire := p_tax_entire;
3519: x_chrg_entire := p_chrg_entire;
3520: arp_standard.debug(' USER EXCEPTION tax_rem_greater_tax_app');
3521: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3522: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3523: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3524: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3525: arp_standard.debug('move_bucket -');
3526: WHEN OTHERS THEN

Line 3523: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);

3519: x_chrg_entire := p_chrg_entire;
3520: arp_standard.debug(' USER EXCEPTION tax_rem_greater_tax_app');
3521: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3522: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3523: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3524: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3525: arp_standard.debug('move_bucket -');
3526: WHEN OTHERS THEN
3527: RAISE;

Line 3524: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);

3520: arp_standard.debug(' USER EXCEPTION tax_rem_greater_tax_app');
3521: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3522: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3523: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3524: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3525: arp_standard.debug('move_bucket -');
3526: WHEN OTHERS THEN
3527: RAISE;
3528: END;

Line 3525: arp_standard.debug('move_bucket -');

3521: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3522: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3523: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3524: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3525: arp_standard.debug('move_bucket -');
3526: WHEN OTHERS THEN
3527: RAISE;
3528: END;
3529:

Line 3589: arp_standard.debug('lease_app_bucket_amts +');

3585: i NUMBER := 0;
3586: over_applications EXCEPTION;
3587:
3588: BEGIN
3589: arp_standard.debug('lease_app_bucket_amts +');
3590: arp_standard.debug(' p_line_rem :'|| p_line_rem);
3591: arp_standard.debug(' p_tax_rem :'|| p_tax_rem);
3592: arp_standard.debug(' p_freight_rem:'|| p_freight_rem);
3593: arp_standard.debug(' p_chrg_rem :'|| p_chrg_rem);

Line 3590: arp_standard.debug(' p_line_rem :'|| p_line_rem);

3586: over_applications EXCEPTION;
3587:
3588: BEGIN
3589: arp_standard.debug('lease_app_bucket_amts +');
3590: arp_standard.debug(' p_line_rem :'|| p_line_rem);
3591: arp_standard.debug(' p_tax_rem :'|| p_tax_rem);
3592: arp_standard.debug(' p_freight_rem:'|| p_freight_rem);
3593: arp_standard.debug(' p_chrg_rem :'|| p_chrg_rem);
3594: arp_standard.debug(' -----------------------------');

Line 3591: arp_standard.debug(' p_tax_rem :'|| p_tax_rem);

3587:
3588: BEGIN
3589: arp_standard.debug('lease_app_bucket_amts +');
3590: arp_standard.debug(' p_line_rem :'|| p_line_rem);
3591: arp_standard.debug(' p_tax_rem :'|| p_tax_rem);
3592: arp_standard.debug(' p_freight_rem:'|| p_freight_rem);
3593: arp_standard.debug(' p_chrg_rem :'|| p_chrg_rem);
3594: arp_standard.debug(' -----------------------------');
3595:

Line 3592: arp_standard.debug(' p_freight_rem:'|| p_freight_rem);

3588: BEGIN
3589: arp_standard.debug('lease_app_bucket_amts +');
3590: arp_standard.debug(' p_line_rem :'|| p_line_rem);
3591: arp_standard.debug(' p_tax_rem :'|| p_tax_rem);
3592: arp_standard.debug(' p_freight_rem:'|| p_freight_rem);
3593: arp_standard.debug(' p_chrg_rem :'|| p_chrg_rem);
3594: arp_standard.debug(' -----------------------------');
3595:
3596: l_cur_line := NVL(x_line_entire,0);

Line 3593: arp_standard.debug(' p_chrg_rem :'|| p_chrg_rem);

3589: arp_standard.debug('lease_app_bucket_amts +');
3590: arp_standard.debug(' p_line_rem :'|| p_line_rem);
3591: arp_standard.debug(' p_tax_rem :'|| p_tax_rem);
3592: arp_standard.debug(' p_freight_rem:'|| p_freight_rem);
3593: arp_standard.debug(' p_chrg_rem :'|| p_chrg_rem);
3594: arp_standard.debug(' -----------------------------');
3595:
3596: l_cur_line := NVL(x_line_entire,0);
3597: l_cur_tax := NVL(x_tax_entire,0);

Line 3594: arp_standard.debug(' -----------------------------');

3590: arp_standard.debug(' p_line_rem :'|| p_line_rem);
3591: arp_standard.debug(' p_tax_rem :'|| p_tax_rem);
3592: arp_standard.debug(' p_freight_rem:'|| p_freight_rem);
3593: arp_standard.debug(' p_chrg_rem :'|| p_chrg_rem);
3594: arp_standard.debug(' -----------------------------');
3595:
3596: l_cur_line := NVL(x_line_entire,0);
3597: l_cur_tax := NVL(x_tax_entire,0);
3598: l_cur_freight := NVL(x_freight_entire,0);

Line 3656: arp_standard.debug(' x_line_app :'|| l_cur_line);

3652: x_line_entire := l_cur_line;
3653: x_tax_entire := l_cur_tax;
3654: x_freight_entire := l_cur_freight;
3655: x_chrg_entire := l_cur_chrg;
3656: arp_standard.debug(' x_line_app :'|| l_cur_line);
3657: arp_standard.debug(' x_tax_app :'|| l_cur_tax);
3658: arp_standard.debug(' x_freight_app :'|| l_cur_freight);
3659: arp_standard.debug(' x_chrg_app :'|| l_cur_chrg);
3660: arp_standard.debug('lease_app_bucket_amts -');

Line 3657: arp_standard.debug(' x_tax_app :'|| l_cur_tax);

3653: x_tax_entire := l_cur_tax;
3654: x_freight_entire := l_cur_freight;
3655: x_chrg_entire := l_cur_chrg;
3656: arp_standard.debug(' x_line_app :'|| l_cur_line);
3657: arp_standard.debug(' x_tax_app :'|| l_cur_tax);
3658: arp_standard.debug(' x_freight_app :'|| l_cur_freight);
3659: arp_standard.debug(' x_chrg_app :'|| l_cur_chrg);
3660: arp_standard.debug('lease_app_bucket_amts -');
3661:

Line 3658: arp_standard.debug(' x_freight_app :'|| l_cur_freight);

3654: x_freight_entire := l_cur_freight;
3655: x_chrg_entire := l_cur_chrg;
3656: arp_standard.debug(' x_line_app :'|| l_cur_line);
3657: arp_standard.debug(' x_tax_app :'|| l_cur_tax);
3658: arp_standard.debug(' x_freight_app :'|| l_cur_freight);
3659: arp_standard.debug(' x_chrg_app :'|| l_cur_chrg);
3660: arp_standard.debug('lease_app_bucket_amts -');
3661:
3662: EXCEPTION

Line 3659: arp_standard.debug(' x_chrg_app :'|| l_cur_chrg);

3655: x_chrg_entire := l_cur_chrg;
3656: arp_standard.debug(' x_line_app :'|| l_cur_line);
3657: arp_standard.debug(' x_tax_app :'|| l_cur_tax);
3658: arp_standard.debug(' x_freight_app :'|| l_cur_freight);
3659: arp_standard.debug(' x_chrg_app :'|| l_cur_chrg);
3660: arp_standard.debug('lease_app_bucket_amts -');
3661:
3662: EXCEPTION
3663: WHEN over_applications THEN

Line 3660: arp_standard.debug('lease_app_bucket_amts -');

3656: arp_standard.debug(' x_line_app :'|| l_cur_line);
3657: arp_standard.debug(' x_tax_app :'|| l_cur_tax);
3658: arp_standard.debug(' x_freight_app :'|| l_cur_freight);
3659: arp_standard.debug(' x_chrg_app :'|| l_cur_chrg);
3660: arp_standard.debug('lease_app_bucket_amts -');
3661:
3662: EXCEPTION
3663: WHEN over_applications THEN
3664: arp_standard.debug('EXCEPTION fnd_api.g_exc_error - over applications ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT

Line 3664: arp_standard.debug('EXCEPTION fnd_api.g_exc_error - over applications ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT

3660: arp_standard.debug('lease_app_bucket_amts -');
3661:
3662: EXCEPTION
3663: WHEN over_applications THEN
3664: arp_standard.debug('EXCEPTION fnd_api.g_exc_error - over applications ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT
3665: sum amount remaining from the invoice:'||l_rem ||'
3666: sum of application buckets :'||l_app );
3667:
3668: END;