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 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 2811: arp_standard.debug( 'setting the currency context back to null');

2807: p_ae_sys_rec => g_ae_sys_rec,
2808: p_inv_cm => 'I',
2809: p_cash_mfar => 'CASH');
2810:
2811: arp_standard.debug( 'setting the currency context back to null');
2812: fnd_client_info.set_currency_context(NULL);
2813:
2814: END LOOP;
2815: CLOSE c_app;

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

2831: -- p_app_rec => l_app_rec,
2832: -- p_ae_sys_rec => g_ae_sys_rec,
2833: -- p_inv_cm => 'C',
2834: -- p_cash_mfar => 'CASH');
2835: -- arp_standard.debug( 'setting the currency context back to null');
2836: -- fnd_client_info.set_currency_context(NULL);
2837: -- END LOOP;
2838: -- CLOSE c_cm_from_app;
2839:

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

2978: p_ae_sys_rec => g_ae_sys_rec,
2979: p_inv_cm => 'I',
2980: p_cash_mfar => 'MFAR');
2981:
2982: arp_standard.debug( 'setting the currency context back to null');
2983: fnd_client_info.set_currency_context(NULL);
2984:
2985: END LOOP;
2986: CLOSE c_app;

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

3008: p_inv_cm => 'C',
3009: p_cash_mfar => 'MFAR');
3010:
3011:
3012: arp_standard.debug( 'setting the currency context back to null');
3013: fnd_client_info.set_currency_context(NULL);
3014:
3015: END LOOP;
3016: CLOSE c_cm_from_app;

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

3125: over_applications EXCEPTION;
3126:
3127:
3128: BEGIN
3129: arp_standard.debug('COMPARE_RA_REM_AMT +');
3130:
3131: x_app_rec := p_app_rec;
3132:
3133: ARP_DET_DIST_PKG.get_latest_amount_remaining

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

3175: l_entire := l_chrg_entire + l_freight_entire + l_tax_entire + l_line_entire;
3176: l_rem := l_chrg_rem + l_freight_rem + l_tax_rem + l_line_rem;
3177: --
3178:
3179: arp_standard.debug(' l_chrg_app :'||l_chrg_app);
3180: arp_standard.debug(' l_chrg_ed :'||l_chrg_ed);
3181: arp_standard.debug(' l_chrg_uned:'||l_chrg_uned);
3182:
3183: arp_standard.debug(' l_freight_app :'||l_freight_app);

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

3176: l_rem := l_chrg_rem + l_freight_rem + l_tax_rem + l_line_rem;
3177: --
3178:
3179: arp_standard.debug(' l_chrg_app :'||l_chrg_app);
3180: arp_standard.debug(' l_chrg_ed :'||l_chrg_ed);
3181: arp_standard.debug(' l_chrg_uned:'||l_chrg_uned);
3182:
3183: arp_standard.debug(' l_freight_app :'||l_freight_app);
3184: arp_standard.debug(' l_freight_ed :'||l_freight_ed);

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

3177: --
3178:
3179: arp_standard.debug(' l_chrg_app :'||l_chrg_app);
3180: arp_standard.debug(' l_chrg_ed :'||l_chrg_ed);
3181: arp_standard.debug(' l_chrg_uned:'||l_chrg_uned);
3182:
3183: arp_standard.debug(' l_freight_app :'||l_freight_app);
3184: arp_standard.debug(' l_freight_ed :'||l_freight_ed);
3185: arp_standard.debug(' l_freight_uned:'||l_freight_uned);

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

3179: arp_standard.debug(' l_chrg_app :'||l_chrg_app);
3180: arp_standard.debug(' l_chrg_ed :'||l_chrg_ed);
3181: arp_standard.debug(' l_chrg_uned:'||l_chrg_uned);
3182:
3183: arp_standard.debug(' l_freight_app :'||l_freight_app);
3184: arp_standard.debug(' l_freight_ed :'||l_freight_ed);
3185: arp_standard.debug(' l_freight_uned:'||l_freight_uned);
3186:
3187: arp_standard.debug(' l_tax_app :'||l_tax_app);

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

3180: arp_standard.debug(' l_chrg_ed :'||l_chrg_ed);
3181: arp_standard.debug(' l_chrg_uned:'||l_chrg_uned);
3182:
3183: arp_standard.debug(' l_freight_app :'||l_freight_app);
3184: arp_standard.debug(' l_freight_ed :'||l_freight_ed);
3185: arp_standard.debug(' l_freight_uned:'||l_freight_uned);
3186:
3187: arp_standard.debug(' l_tax_app :'||l_tax_app);
3188: arp_standard.debug(' l_tax_ed :'||l_tax_ed);

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

3181: arp_standard.debug(' l_chrg_uned:'||l_chrg_uned);
3182:
3183: arp_standard.debug(' l_freight_app :'||l_freight_app);
3184: arp_standard.debug(' l_freight_ed :'||l_freight_ed);
3185: arp_standard.debug(' l_freight_uned:'||l_freight_uned);
3186:
3187: arp_standard.debug(' l_tax_app :'||l_tax_app);
3188: arp_standard.debug(' l_tax_ed :'||l_tax_ed);
3189: arp_standard.debug(' l_tax_uned:'||l_tax_uned);

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

3183: arp_standard.debug(' l_freight_app :'||l_freight_app);
3184: arp_standard.debug(' l_freight_ed :'||l_freight_ed);
3185: arp_standard.debug(' l_freight_uned:'||l_freight_uned);
3186:
3187: arp_standard.debug(' l_tax_app :'||l_tax_app);
3188: arp_standard.debug(' l_tax_ed :'||l_tax_ed);
3189: arp_standard.debug(' l_tax_uned:'||l_tax_uned);
3190:
3191: arp_standard.debug(' l_line_app :'||l_line_app);

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

3184: arp_standard.debug(' l_freight_ed :'||l_freight_ed);
3185: arp_standard.debug(' l_freight_uned:'||l_freight_uned);
3186:
3187: arp_standard.debug(' l_tax_app :'||l_tax_app);
3188: arp_standard.debug(' l_tax_ed :'||l_tax_ed);
3189: arp_standard.debug(' l_tax_uned:'||l_tax_uned);
3190:
3191: arp_standard.debug(' l_line_app :'||l_line_app);
3192: arp_standard.debug(' l_line_ed :'||l_line_ed);

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

3185: arp_standard.debug(' l_freight_uned:'||l_freight_uned);
3186:
3187: arp_standard.debug(' l_tax_app :'||l_tax_app);
3188: arp_standard.debug(' l_tax_ed :'||l_tax_ed);
3189: arp_standard.debug(' l_tax_uned:'||l_tax_uned);
3190:
3191: arp_standard.debug(' l_line_app :'||l_line_app);
3192: arp_standard.debug(' l_line_ed :'||l_line_ed);
3193: arp_standard.debug(' l_line_uned:'||l_line_uned);

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

3187: arp_standard.debug(' l_tax_app :'||l_tax_app);
3188: arp_standard.debug(' l_tax_ed :'||l_tax_ed);
3189: arp_standard.debug(' l_tax_uned:'||l_tax_uned);
3190:
3191: arp_standard.debug(' l_line_app :'||l_line_app);
3192: arp_standard.debug(' l_line_ed :'||l_line_ed);
3193: arp_standard.debug(' l_line_uned:'||l_line_uned);
3194:
3195: arp_standard.debug(' Sum of all the bucket of the application :'||l_entire);

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

3188: arp_standard.debug(' l_tax_ed :'||l_tax_ed);
3189: arp_standard.debug(' l_tax_uned:'||l_tax_uned);
3190:
3191: arp_standard.debug(' l_line_app :'||l_line_app);
3192: arp_standard.debug(' l_line_ed :'||l_line_ed);
3193: arp_standard.debug(' l_line_uned:'||l_line_uned);
3194:
3195: arp_standard.debug(' Sum of all the bucket of the application :'||l_entire);
3196: arp_standard.debug(' Sum of all the remaining bucket on transaction :'||l_rem);

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

3189: arp_standard.debug(' l_tax_uned:'||l_tax_uned);
3190:
3191: arp_standard.debug(' l_line_app :'||l_line_app);
3192: arp_standard.debug(' l_line_ed :'||l_line_ed);
3193: arp_standard.debug(' l_line_uned:'||l_line_uned);
3194:
3195: arp_standard.debug(' Sum of all the bucket of the application :'||l_entire);
3196: arp_standard.debug(' Sum of all the remaining bucket on transaction :'||l_rem);
3197:

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

3191: arp_standard.debug(' l_line_app :'||l_line_app);
3192: arp_standard.debug(' l_line_ed :'||l_line_ed);
3193: arp_standard.debug(' l_line_uned:'||l_line_uned);
3194:
3195: arp_standard.debug(' Sum of all the bucket of the application :'||l_entire);
3196: arp_standard.debug(' Sum of all the remaining bucket on transaction :'||l_rem);
3197:
3198:
3199: --

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

3192: arp_standard.debug(' l_line_ed :'||l_line_ed);
3193: arp_standard.debug(' l_line_uned:'||l_line_uned);
3194:
3195: arp_standard.debug(' Sum of all the bucket of the application :'||l_entire);
3196: arp_standard.debug(' Sum of all the remaining bucket on transaction :'||l_rem);
3197:
3198:
3199: --
3200: -- We should verify that all rem are less or equal to the all buckets of the application

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

3200: -- We should verify that all rem are less or equal to the all buckets of the application
3201: -- Otherwise this is a abnormal situation as it means overapplication
3202: --
3203: IF l_entire > l_rem THEN
3204: arp_standard.debug(' SUM_ALL_APP_BUCKET > SUM_ALL_REM_BUCKET - Overapplication');
3205: RAISE over_applications;
3206: END IF;
3207:
3208: --

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

3207:
3208: --
3209: --Prorate sum of apps over rem
3210: --
3211: arp_standard.debug(' l_run_rem :'||l_run_rem);
3212: arp_standard.debug(' l_line_rem :'||l_line_rem);
3213:
3214: l_run_rem := l_run_rem + l_line_rem;
3215:

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

3208: --
3209: --Prorate sum of apps over rem
3210: --
3211: arp_standard.debug(' l_run_rem :'||l_run_rem);
3212: arp_standard.debug(' l_line_rem :'||l_line_rem);
3213:
3214: l_run_rem := l_run_rem + l_line_rem;
3215:
3216: l_line_apps := arpcurr.CurrRound( l_run_rem

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

3220: - l_run_apps;
3221:
3222: l_run_apps := l_run_apps + l_line_apps;
3223:
3224: arp_standard.debug(' l_line_apps :'||l_line_apps);
3225: arp_standard.debug(' l_run_apps :'||l_run_apps);
3226:
3227: --
3228:

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

3221:
3222: l_run_apps := l_run_apps + l_line_apps;
3223:
3224: arp_standard.debug(' l_line_apps :'||l_line_apps);
3225: arp_standard.debug(' l_run_apps :'||l_run_apps);
3226:
3227: --
3228:
3229: arp_standard.debug(' l_run_rem :'||l_run_rem);

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

3225: arp_standard.debug(' l_run_apps :'||l_run_apps);
3226:
3227: --
3228:
3229: arp_standard.debug(' l_run_rem :'||l_run_rem);
3230: arp_standard.debug(' l_tax_rem :'||l_tax_rem);
3231:
3232: l_run_rem := l_run_rem + l_tax_rem;
3233:

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

3226:
3227: --
3228:
3229: arp_standard.debug(' l_run_rem :'||l_run_rem);
3230: arp_standard.debug(' l_tax_rem :'||l_tax_rem);
3231:
3232: l_run_rem := l_run_rem + l_tax_rem;
3233:
3234: l_tax_apps := arpcurr.CurrRound( l_run_rem

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

3239:
3240:
3241: l_run_apps := l_run_apps + l_tax_apps;
3242:
3243: arp_standard.debug(' l_tax_apps :'||l_tax_apps);
3244: arp_standard.debug(' l_run_apps :'||l_run_apps);
3245:
3246: --
3247: arp_standard.debug(' l_run_rem :'||l_run_rem);

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

3240:
3241: l_run_apps := l_run_apps + l_tax_apps;
3242:
3243: arp_standard.debug(' l_tax_apps :'||l_tax_apps);
3244: arp_standard.debug(' l_run_apps :'||l_run_apps);
3245:
3246: --
3247: arp_standard.debug(' l_run_rem :'||l_run_rem);
3248: arp_standard.debug(' l_freight_rem :'||l_freight_rem);

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

3243: arp_standard.debug(' l_tax_apps :'||l_tax_apps);
3244: arp_standard.debug(' l_run_apps :'||l_run_apps);
3245:
3246: --
3247: arp_standard.debug(' l_run_rem :'||l_run_rem);
3248: arp_standard.debug(' l_freight_rem :'||l_freight_rem);
3249:
3250: l_run_rem := l_run_rem + l_freight_rem;
3251:

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

3244: arp_standard.debug(' l_run_apps :'||l_run_apps);
3245:
3246: --
3247: arp_standard.debug(' l_run_rem :'||l_run_rem);
3248: arp_standard.debug(' l_freight_rem :'||l_freight_rem);
3249:
3250: l_run_rem := l_run_rem + l_freight_rem;
3251:
3252: l_freight_apps := arpcurr.CurrRound( l_run_rem

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

3257:
3258:
3259: l_run_apps := l_run_apps + l_freight_apps;
3260:
3261: arp_standard.debug(' l_freight_apps :'||l_freight_apps);
3262: arp_standard.debug(' l_run_apps :'||l_run_apps);
3263: --
3264: arp_standard.debug(' l_run_rem :'||l_run_rem);
3265: arp_standard.debug(' l_chrg_rem :'||l_chrg_rem);

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

3258:
3259: l_run_apps := l_run_apps + l_freight_apps;
3260:
3261: arp_standard.debug(' l_freight_apps :'||l_freight_apps);
3262: arp_standard.debug(' l_run_apps :'||l_run_apps);
3263: --
3264: arp_standard.debug(' l_run_rem :'||l_run_rem);
3265: arp_standard.debug(' l_chrg_rem :'||l_chrg_rem);
3266:

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

3260:
3261: arp_standard.debug(' l_freight_apps :'||l_freight_apps);
3262: arp_standard.debug(' l_run_apps :'||l_run_apps);
3263: --
3264: arp_standard.debug(' l_run_rem :'||l_run_rem);
3265: arp_standard.debug(' l_chrg_rem :'||l_chrg_rem);
3266:
3267: l_run_rem := l_run_rem + l_chrg_rem;
3268:

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

3261: arp_standard.debug(' l_freight_apps :'||l_freight_apps);
3262: arp_standard.debug(' l_run_apps :'||l_run_apps);
3263: --
3264: arp_standard.debug(' l_run_rem :'||l_run_rem);
3265: arp_standard.debug(' l_chrg_rem :'||l_chrg_rem);
3266:
3267: l_run_rem := l_run_rem + l_chrg_rem;
3268:
3269: l_chrg_apps := arpcurr.CurrRound( l_run_rem

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

3274:
3275:
3276: l_run_apps := l_run_apps + l_chrg_apps;
3277:
3278: arp_standard.debug(' l_chrg_apps :'||l_chrg_apps);
3279: arp_standard.debug(' l_run_apps :'||l_run_apps);
3280:
3281: IF l_line_apps <> l_line_entire THEN
3282: l_line_apps := l_line_apps - l_line_ed - l_line_uned;

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

3275:
3276: l_run_apps := l_run_apps + l_chrg_apps;
3277:
3278: arp_standard.debug(' l_chrg_apps :'||l_chrg_apps);
3279: arp_standard.debug(' l_run_apps :'||l_run_apps);
3280:
3281: IF l_line_apps <> l_line_entire THEN
3282: l_line_apps := l_line_apps - l_line_ed - l_line_uned;
3283: END IF;

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

3297: x_app_rec.LINE_APPLIED := l_line_apps;
3298: x_app_rec.TAX_APPLIED := l_tax_apps;
3299: x_app_rec.FREIGHT_APPLIED := l_freight_apps;
3300: x_app_rec.RECEIVABLES_CHARGES_APPLIED:= l_chrg_apps;
3301: arp_standard.debug('COMPARE_RA_REM_AMT -');
3302:
3303: EXCEPTION
3304: WHEN over_applications THEN
3305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3307: FND_MESSAGE.SET_TOKEN( 'TEXT', 'EXCEPTION over_applications in ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT
3308: sum amount remaining from the invoice:'||l_rem ||'
3309: sum of application buckets :'||l_entire );
3310: FND_MSG_PUB.ADD;
3311: arp_standard.debug('EXCEPTION fnd_api.g_exc_error - over applications ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT
3312: sum amount remaining from the invoice:'||l_rem ||'
3313: sum of application buckets :'||l_entire );
3314: WHEN fnd_api.g_exc_error THEN
3315: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

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

3314: WHEN fnd_api.g_exc_error THEN
3315: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
3316: FND_MESSAGE.SET_TOKEN( 'TEXT', 'EXCEPTION fnd_api.g_exc_error in ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT' );
3317: FND_MSG_PUB.ADD;
3318: arp_standard.debug('EXCEPTION fnd_api.g_exc_error - fnd_api.g_exc_error ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT');
3319: WHEN OTHERS THEN
3320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3321: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
3322: FND_MESSAGE.SET_TOKEN( 'TEXT', 'EXCEPTION - OTHERS ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT: '||SQLERRM );

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

3320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3321: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
3322: FND_MESSAGE.SET_TOKEN( 'TEXT', 'EXCEPTION - OTHERS ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT: '||SQLERRM );
3323: FND_MSG_PUB.ADD;
3324: arp_standard.debug('EXCEPTION - OTHERS ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT: '||SQLERRM);
3325: END COMPARE_RA_REM_AMT;
3326:
3327:
3328:

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

3331:
3332: PROCEDURE stamping_11i_mfar_app_post
3333: IS
3334: BEGIN
3335: arp_standard.debug('stamping_11i_mfar_app_post +');
3336: UPDATE ar_receivable_applications_all ra
3337: SET ra.upgrade_method = 'R12_11IMFAR_POST'
3338: WHERE ra.receivable_application_id IN (
3339: SELECT app.receivable_application_id

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

3367: AND adj.upgrade_method = '11I'
3368: AND adj.status = 'A'
3369: AND adj.postable = 'Y')
3370: );
3371: arp_standard.debug('stamping_11i_mfar_app_post -');
3372: EXCEPTION
3373: WHEN OTHERS THEN
3374: arp_standard.debug('EXCEPTION OTHERS : stamping_11i_mfar_app_post :' || SQLERRM);
3375: RAISE;

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

3370: );
3371: arp_standard.debug('stamping_11i_mfar_app_post -');
3372: EXCEPTION
3373: WHEN OTHERS THEN
3374: arp_standard.debug('EXCEPTION OTHERS : stamping_11i_mfar_app_post :' || SQLERRM);
3375: RAISE;
3376: END stamping_11i_mfar_app_post;
3377:
3378:

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

3379:
3380: PROCEDURE stamping_11i_cash_app_post
3381: IS
3382: BEGIN
3383: arp_standard.debug('stamping_11i_cash_app_post +');
3384: UPDATE ar_receivable_applications_all ra
3385: SET ra.upgrade_method = 'R12_11ICASH_POST'
3386: WHERE ra.receivable_application_id IN (
3387: SELECT app.receivable_application_id

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

3399: WHERE adj.customer_trx_id = app.applied_customer_trx_id
3400: AND adj.upgrade_method = '11I'
3401: AND adj.status = 'A'
3402: AND adj.postable = 'Y'));
3403: arp_standard.debug('stamping_11i_cash_app_post -');
3404: EXCEPTION
3405: WHEN OTHERS THEN
3406: arp_standard.debug('EXCEPTION OTHERS : stamping_11i_mfar_app_post :' || SQLERRM);
3407: RAISE;

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

3402: AND adj.postable = 'Y'));
3403: arp_standard.debug('stamping_11i_cash_app_post -');
3404: EXCEPTION
3405: WHEN OTHERS THEN
3406: arp_standard.debug('EXCEPTION OTHERS : stamping_11i_mfar_app_post :' || SQLERRM);
3407: RAISE;
3408: END stamping_11i_cash_app_post;
3409:
3410:

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

3453: l_tax_portion NUMBER;
3454: l_freight_portion NUMBER;
3455: l_chrg_portion NUMBER;
3456: BEGIN
3457: arp_standard.debug(' portion_to_move +');
3458: arp_standard.debug(' p_total_to_move :'|| p_total_to_move);
3459: arp_standard.debug(' p_freight_ratio :'|| p_freight_ratio);
3460: arp_standard.debug(' p_tax_ratio :'|| p_tax_ratio);
3461: arp_standard.debug(' p_line_ratio :'|| p_line_ratio);

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

3454: l_freight_portion NUMBER;
3455: l_chrg_portion NUMBER;
3456: BEGIN
3457: arp_standard.debug(' portion_to_move +');
3458: arp_standard.debug(' p_total_to_move :'|| p_total_to_move);
3459: arp_standard.debug(' p_freight_ratio :'|| p_freight_ratio);
3460: arp_standard.debug(' p_tax_ratio :'|| p_tax_ratio);
3461: arp_standard.debug(' p_line_ratio :'|| p_line_ratio);
3462: arp_standard.debug(' p_chrg_ratio :'|| p_chrg_ratio);

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

3455: l_chrg_portion NUMBER;
3456: BEGIN
3457: arp_standard.debug(' portion_to_move +');
3458: arp_standard.debug(' p_total_to_move :'|| p_total_to_move);
3459: arp_standard.debug(' p_freight_ratio :'|| p_freight_ratio);
3460: arp_standard.debug(' p_tax_ratio :'|| p_tax_ratio);
3461: arp_standard.debug(' p_line_ratio :'|| p_line_ratio);
3462: arp_standard.debug(' p_chrg_ratio :'|| p_chrg_ratio);
3463:

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

3456: BEGIN
3457: arp_standard.debug(' portion_to_move +');
3458: arp_standard.debug(' p_total_to_move :'|| p_total_to_move);
3459: arp_standard.debug(' p_freight_ratio :'|| p_freight_ratio);
3460: arp_standard.debug(' p_tax_ratio :'|| p_tax_ratio);
3461: arp_standard.debug(' p_line_ratio :'|| p_line_ratio);
3462: arp_standard.debug(' p_chrg_ratio :'|| p_chrg_ratio);
3463:
3464: IF (p_total_to_move IS NOT NULL) THEN l_total_to_move := p_total_to_move; END IF;

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

3457: arp_standard.debug(' portion_to_move +');
3458: arp_standard.debug(' p_total_to_move :'|| p_total_to_move);
3459: arp_standard.debug(' p_freight_ratio :'|| p_freight_ratio);
3460: arp_standard.debug(' p_tax_ratio :'|| p_tax_ratio);
3461: arp_standard.debug(' p_line_ratio :'|| p_line_ratio);
3462: arp_standard.debug(' p_chrg_ratio :'|| p_chrg_ratio);
3463:
3464: IF (p_total_to_move IS NOT NULL) THEN l_total_to_move := p_total_to_move; END IF;
3465: IF (p_freight_ratio IS NOT NULL) THEN l_freight_ratio := p_freight_ratio; END IF;

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

3458: arp_standard.debug(' p_total_to_move :'|| p_total_to_move);
3459: arp_standard.debug(' p_freight_ratio :'|| p_freight_ratio);
3460: arp_standard.debug(' p_tax_ratio :'|| p_tax_ratio);
3461: arp_standard.debug(' p_line_ratio :'|| p_line_ratio);
3462: arp_standard.debug(' p_chrg_ratio :'|| p_chrg_ratio);
3463:
3464: IF (p_total_to_move IS NOT NULL) THEN l_total_to_move := p_total_to_move; END IF;
3465: IF (p_freight_ratio IS NOT NULL) THEN l_freight_ratio := p_freight_ratio; END IF;
3466: IF (p_tax_ratio IS NOT NULL) THEN l_tax_ratio := p_tax_ratio; END IF;

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

3469:
3470: l_sum_base := l_freight_ratio + l_tax_ratio + l_line_ratio + l_chrg_ratio;
3471:
3472: IF l_total_to_move = 0 THEN
3473: arp_standard.debug('The amount to move is 0, we return 0 for all portion');
3474: x_freight_portion := 0;
3475: x_tax_portion := 0;
3476: x_line_portion := 0;
3477: x_chrg_portion := 0;

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

3475: x_tax_portion := 0;
3476: x_line_portion := 0;
3477: x_chrg_portion := 0;
3478: ELSIF l_sum_base = 0 THEN
3479: arp_standard.debug('The sum of all ratio is 0, we return 0 for all portion');
3480: x_freight_portion := 0;
3481: x_tax_portion := 0;
3482: x_line_portion := 0;
3483: x_chrg_portion := 0;

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

3521: x_chrg_portion := l_chrg_portion;
3522: END IF;
3523: EXCEPTION
3524: WHEN OTHERS THEN
3525: arp_standard.debug('EXCEPTION OTHERS - portion_to_move '||SQLERRM);
3526: RAISE;
3527: END;
3528:
3529: ---------------------------------------

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

3589: frt_rem_greater_frt_app EXCEPTION;
3590: tax_rem_greater_tax_app EXCEPTION;
3591: --
3592: BEGIN
3593: arp_standard.debug('move_bucket +');
3594:
3595: l_line_entire := p_line_entire;
3596: l_freight_entire := p_freight_entire;
3597: l_tax_entire := p_tax_entire;

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

3615: -- This is due to PSA legacy data because the charges adjusted are over all type of line
3616: -- hence a portion of remaing charges are affected to other buckets such as freight or tax
3617: --
3618: IF l_entire > l_rem THEN
3619: arp_standard.debug('moving portion charges bucket to other line, tax, freight bucket');
3620: l_to_move := l_entire - l_rem;
3621: l_chrg_entire := l_entire - l_to_move;
3622: ELSE
3623: RAISE chrg_rem_greater_chrg_app;

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

3636: l_line_ratio := p_line_entire;
3637: l_chrg_ratio := 0;
3638:
3639: IF l_entire > l_rem THEN
3640: arp_standard.debug('moving portion freight bucket to line and tax');
3641: l_to_move := l_entire - l_rem;
3642: l_freight_entire := l_entire - l_to_move;
3643: ELSE
3644: RAISE frt_rem_greater_frt_app;

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

3657: l_line_ratio := p_line_entire;
3658: l_chrg_ratio := 0;
3659:
3660: IF l_entire > l_rem THEN
3661: arp_standard.debug('moving portion tax bucket to other line');
3662: l_to_move := l_entire - l_rem;
3663: l_tax_entire := l_entire - l_to_move;
3664: ELSE
3665: RAISE tax_rem_greater_tax_app;

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

3682: IF l_entire > l_rem THEN
3683:
3684: -- logic of charges movement.
3685: -- Move charge equivalently over line - tax - freight
3686: arp_standard.debug(' '||p_which_bucket||' to move : '|| l_to_move );
3687:
3688: portion_to_move
3689: (p_total_to_move => l_to_move,
3690: p_freight_ratio => l_freight_ratio,

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

3702: x_tax_entire := l_tax_entire + l_tax_portion;
3703: x_chrg_entire := l_chrg_entire + l_chrg_portion;
3704:
3705: END IF;
3706: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3707: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3708: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3709: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3710: arp_standard.debug('move_bucket -');

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

3703: x_chrg_entire := l_chrg_entire + l_chrg_portion;
3704:
3705: END IF;
3706: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3707: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3708: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3709: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3710: arp_standard.debug('move_bucket -');
3711: EXCEPTION

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

3704:
3705: END IF;
3706: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3707: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3708: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3709: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3710: arp_standard.debug('move_bucket -');
3711: EXCEPTION
3712: WHEN chrg_rem_greater_chrg_app THEN

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

3705: END IF;
3706: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3707: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3708: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3709: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3710: arp_standard.debug('move_bucket -');
3711: EXCEPTION
3712: WHEN chrg_rem_greater_chrg_app THEN
3713: x_line_entire := p_line_entire;

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

3706: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3707: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3708: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3709: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3710: arp_standard.debug('move_bucket -');
3711: EXCEPTION
3712: WHEN chrg_rem_greater_chrg_app THEN
3713: x_line_entire := p_line_entire;
3714: x_freight_entire := p_freight_entire;

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

3713: x_line_entire := p_line_entire;
3714: x_freight_entire := p_freight_entire;
3715: x_tax_entire := p_tax_entire;
3716: x_chrg_entire := p_chrg_entire;
3717: arp_standard.debug(' USER EXCEPTION chrg_rem_greater_chrg_app');
3718: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3719: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3720: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3721: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);

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

3714: x_freight_entire := p_freight_entire;
3715: x_tax_entire := p_tax_entire;
3716: x_chrg_entire := p_chrg_entire;
3717: arp_standard.debug(' USER EXCEPTION chrg_rem_greater_chrg_app');
3718: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3719: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3720: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3721: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3722: arp_standard.debug('move_bucket -');

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

3715: x_tax_entire := p_tax_entire;
3716: x_chrg_entire := p_chrg_entire;
3717: arp_standard.debug(' USER EXCEPTION chrg_rem_greater_chrg_app');
3718: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3719: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3720: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3721: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3722: arp_standard.debug('move_bucket -');
3723: WHEN frt_rem_greater_frt_app THEN

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

3716: x_chrg_entire := p_chrg_entire;
3717: arp_standard.debug(' USER EXCEPTION chrg_rem_greater_chrg_app');
3718: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3719: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3720: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3721: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3722: arp_standard.debug('move_bucket -');
3723: WHEN frt_rem_greater_frt_app THEN
3724: x_line_entire := p_line_entire;

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

3717: arp_standard.debug(' USER EXCEPTION chrg_rem_greater_chrg_app');
3718: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3719: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3720: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3721: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3722: arp_standard.debug('move_bucket -');
3723: WHEN frt_rem_greater_frt_app THEN
3724: x_line_entire := p_line_entire;
3725: x_freight_entire := p_freight_entire;

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

3718: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3719: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3720: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3721: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3722: arp_standard.debug('move_bucket -');
3723: WHEN frt_rem_greater_frt_app THEN
3724: x_line_entire := p_line_entire;
3725: x_freight_entire := p_freight_entire;
3726: x_tax_entire := p_tax_entire;

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

3724: x_line_entire := p_line_entire;
3725: x_freight_entire := p_freight_entire;
3726: x_tax_entire := p_tax_entire;
3727: x_chrg_entire := p_chrg_entire;
3728: arp_standard.debug(' USER EXCEPTION frt_rem_greater_frt_app');
3729: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3730: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3731: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3732: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);

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

3725: x_freight_entire := p_freight_entire;
3726: x_tax_entire := p_tax_entire;
3727: x_chrg_entire := p_chrg_entire;
3728: arp_standard.debug(' USER EXCEPTION frt_rem_greater_frt_app');
3729: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3730: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3731: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3732: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3733: arp_standard.debug('move_bucket -');

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

3726: x_tax_entire := p_tax_entire;
3727: x_chrg_entire := p_chrg_entire;
3728: arp_standard.debug(' USER EXCEPTION frt_rem_greater_frt_app');
3729: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3730: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3731: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3732: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3733: arp_standard.debug('move_bucket -');
3734: WHEN tax_rem_greater_tax_app THEN

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

3727: x_chrg_entire := p_chrg_entire;
3728: arp_standard.debug(' USER EXCEPTION frt_rem_greater_frt_app');
3729: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3730: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3731: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3732: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3733: arp_standard.debug('move_bucket -');
3734: WHEN tax_rem_greater_tax_app THEN
3735: x_line_entire := p_line_entire;

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

3728: arp_standard.debug(' USER EXCEPTION frt_rem_greater_frt_app');
3729: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3730: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3731: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3732: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3733: arp_standard.debug('move_bucket -');
3734: WHEN tax_rem_greater_tax_app THEN
3735: x_line_entire := p_line_entire;
3736: x_freight_entire := p_freight_entire;

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

3729: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3730: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3731: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3732: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3733: arp_standard.debug('move_bucket -');
3734: WHEN tax_rem_greater_tax_app THEN
3735: x_line_entire := p_line_entire;
3736: x_freight_entire := p_freight_entire;
3737: x_tax_entire := p_tax_entire;

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

3735: x_line_entire := p_line_entire;
3736: x_freight_entire := p_freight_entire;
3737: x_tax_entire := p_tax_entire;
3738: x_chrg_entire := p_chrg_entire;
3739: arp_standard.debug(' USER EXCEPTION tax_rem_greater_tax_app');
3740: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3741: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3742: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3743: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);

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

3736: x_freight_entire := p_freight_entire;
3737: x_tax_entire := p_tax_entire;
3738: x_chrg_entire := p_chrg_entire;
3739: arp_standard.debug(' USER EXCEPTION tax_rem_greater_tax_app');
3740: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3741: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3742: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3743: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3744: arp_standard.debug('move_bucket -');

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

3737: x_tax_entire := p_tax_entire;
3738: x_chrg_entire := p_chrg_entire;
3739: arp_standard.debug(' USER EXCEPTION tax_rem_greater_tax_app');
3740: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3741: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3742: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3743: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3744: arp_standard.debug('move_bucket -');
3745: WHEN OTHERS THEN

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

3738: x_chrg_entire := p_chrg_entire;
3739: arp_standard.debug(' USER EXCEPTION tax_rem_greater_tax_app');
3740: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3741: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3742: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3743: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3744: arp_standard.debug('move_bucket -');
3745: WHEN OTHERS THEN
3746: RAISE;

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

3739: arp_standard.debug(' USER EXCEPTION tax_rem_greater_tax_app');
3740: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3741: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3742: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3743: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3744: arp_standard.debug('move_bucket -');
3745: WHEN OTHERS THEN
3746: RAISE;
3747: END;

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

3740: arp_standard.debug(' x_line_entire :'|| x_line_entire);
3741: arp_standard.debug(' x_freight_entire :'|| x_freight_entire);
3742: arp_standard.debug(' x_tax_entire :'|| x_tax_entire);
3743: arp_standard.debug(' x_chrg_entire :'|| x_chrg_entire);
3744: arp_standard.debug('move_bucket -');
3745: WHEN OTHERS THEN
3746: RAISE;
3747: END;
3748:

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

3804: i NUMBER := 0;
3805: over_applications EXCEPTION;
3806:
3807: BEGIN
3808: arp_standard.debug('lease_app_bucket_amts +');
3809: arp_standard.debug(' p_line_rem :'|| p_line_rem);
3810: arp_standard.debug(' p_tax_rem :'|| p_tax_rem);
3811: arp_standard.debug(' p_freight_rem:'|| p_freight_rem);
3812: arp_standard.debug(' p_chrg_rem :'|| p_chrg_rem);

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

3805: over_applications EXCEPTION;
3806:
3807: BEGIN
3808: arp_standard.debug('lease_app_bucket_amts +');
3809: arp_standard.debug(' p_line_rem :'|| p_line_rem);
3810: arp_standard.debug(' p_tax_rem :'|| p_tax_rem);
3811: arp_standard.debug(' p_freight_rem:'|| p_freight_rem);
3812: arp_standard.debug(' p_chrg_rem :'|| p_chrg_rem);
3813: arp_standard.debug(' -----------------------------');

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

3806:
3807: BEGIN
3808: arp_standard.debug('lease_app_bucket_amts +');
3809: arp_standard.debug(' p_line_rem :'|| p_line_rem);
3810: arp_standard.debug(' p_tax_rem :'|| p_tax_rem);
3811: arp_standard.debug(' p_freight_rem:'|| p_freight_rem);
3812: arp_standard.debug(' p_chrg_rem :'|| p_chrg_rem);
3813: arp_standard.debug(' -----------------------------');
3814:

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

3807: BEGIN
3808: arp_standard.debug('lease_app_bucket_amts +');
3809: arp_standard.debug(' p_line_rem :'|| p_line_rem);
3810: arp_standard.debug(' p_tax_rem :'|| p_tax_rem);
3811: arp_standard.debug(' p_freight_rem:'|| p_freight_rem);
3812: arp_standard.debug(' p_chrg_rem :'|| p_chrg_rem);
3813: arp_standard.debug(' -----------------------------');
3814:
3815: l_cur_line := NVL(x_line_entire,0);

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

3808: arp_standard.debug('lease_app_bucket_amts +');
3809: arp_standard.debug(' p_line_rem :'|| p_line_rem);
3810: arp_standard.debug(' p_tax_rem :'|| p_tax_rem);
3811: arp_standard.debug(' p_freight_rem:'|| p_freight_rem);
3812: arp_standard.debug(' p_chrg_rem :'|| p_chrg_rem);
3813: arp_standard.debug(' -----------------------------');
3814:
3815: l_cur_line := NVL(x_line_entire,0);
3816: l_cur_tax := NVL(x_tax_entire,0);

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

3809: arp_standard.debug(' p_line_rem :'|| p_line_rem);
3810: arp_standard.debug(' p_tax_rem :'|| p_tax_rem);
3811: arp_standard.debug(' p_freight_rem:'|| p_freight_rem);
3812: arp_standard.debug(' p_chrg_rem :'|| p_chrg_rem);
3813: arp_standard.debug(' -----------------------------');
3814:
3815: l_cur_line := NVL(x_line_entire,0);
3816: l_cur_tax := NVL(x_tax_entire,0);
3817: l_cur_freight := NVL(x_freight_entire,0);

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

3871: x_line_entire := l_cur_line;
3872: x_tax_entire := l_cur_tax;
3873: x_freight_entire := l_cur_freight;
3874: x_chrg_entire := l_cur_chrg;
3875: arp_standard.debug(' x_line_app :'|| l_cur_line);
3876: arp_standard.debug(' x_tax_app :'|| l_cur_tax);
3877: arp_standard.debug(' x_freight_app :'|| l_cur_freight);
3878: arp_standard.debug(' x_chrg_app :'|| l_cur_chrg);
3879: arp_standard.debug('lease_app_bucket_amts -');

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

3872: x_tax_entire := l_cur_tax;
3873: x_freight_entire := l_cur_freight;
3874: x_chrg_entire := l_cur_chrg;
3875: arp_standard.debug(' x_line_app :'|| l_cur_line);
3876: arp_standard.debug(' x_tax_app :'|| l_cur_tax);
3877: arp_standard.debug(' x_freight_app :'|| l_cur_freight);
3878: arp_standard.debug(' x_chrg_app :'|| l_cur_chrg);
3879: arp_standard.debug('lease_app_bucket_amts -');
3880:

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

3873: x_freight_entire := l_cur_freight;
3874: x_chrg_entire := l_cur_chrg;
3875: arp_standard.debug(' x_line_app :'|| l_cur_line);
3876: arp_standard.debug(' x_tax_app :'|| l_cur_tax);
3877: arp_standard.debug(' x_freight_app :'|| l_cur_freight);
3878: arp_standard.debug(' x_chrg_app :'|| l_cur_chrg);
3879: arp_standard.debug('lease_app_bucket_amts -');
3880:
3881: EXCEPTION

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

3874: x_chrg_entire := l_cur_chrg;
3875: arp_standard.debug(' x_line_app :'|| l_cur_line);
3876: arp_standard.debug(' x_tax_app :'|| l_cur_tax);
3877: arp_standard.debug(' x_freight_app :'|| l_cur_freight);
3878: arp_standard.debug(' x_chrg_app :'|| l_cur_chrg);
3879: arp_standard.debug('lease_app_bucket_amts -');
3880:
3881: EXCEPTION
3882: WHEN over_applications THEN

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

3875: arp_standard.debug(' x_line_app :'|| l_cur_line);
3876: arp_standard.debug(' x_tax_app :'|| l_cur_tax);
3877: arp_standard.debug(' x_freight_app :'|| l_cur_freight);
3878: arp_standard.debug(' x_chrg_app :'|| l_cur_chrg);
3879: arp_standard.debug('lease_app_bucket_amts -');
3880:
3881: EXCEPTION
3882: WHEN over_applications THEN
3883: arp_standard.debug('EXCEPTION fnd_api.g_exc_error - over applications ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT

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

3879: arp_standard.debug('lease_app_bucket_amts -');
3880:
3881: EXCEPTION
3882: WHEN over_applications THEN
3883: arp_standard.debug('EXCEPTION fnd_api.g_exc_error - over applications ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT
3884: sum amount remaining from the invoice:'||l_rem ||'
3885: sum of application buckets :'||l_app );
3886:
3887: END;