2711: /*EB Tax uptake - Bug No : 6472296*/
2712: /*
2713: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
2714: (p_api_version => 1.0,
2715: p_init_msg_list => FND_API.G_FALSE,
2716: p_commit => FND_API.G_FALSE,
2717: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2718: x_return_status => l_return_status,
2719: x_msg_count => l_msg_count,
2712: /*
2713: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
2714: (p_api_version => 1.0,
2715: p_init_msg_list => FND_API.G_FALSE,
2716: p_commit => FND_API.G_FALSE,
2717: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2718: x_return_status => l_return_status,
2719: x_msg_count => l_msg_count,
2720: x_msg_data => l_msg_data,
2713: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
2714: (p_api_version => 1.0,
2715: p_init_msg_list => FND_API.G_FALSE,
2716: p_commit => FND_API.G_FALSE,
2717: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2718: x_return_status => l_return_status,
2719: x_msg_count => l_msg_count,
2720: x_msg_data => l_msg_data,
2721: p_tax_id => p_cc_acct_lines_rec.tax_id,
2730: P_Line_Id =>p_cc_acct_lines_rec.cc_acct_line_id,
2731: P_Tax_Amount =>l_unbilled_tax_amt,
2732: P_Return_Status =>l_return_status,
2733: P_Error_Code =>P_Error_Code);
2734: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2735: THEN
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;
2738: END IF;
2732: P_Return_Status =>l_return_status,
2733: P_Error_Code =>P_Error_Code);
2734: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2735: THEN
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;
2738: END IF;
2739: /*EB Tax uptake - Bug No : 6472296 END*/
2740: l_unbilled_amt := l_unbilled_amt + Nvl(l_unbilled_tax_amt,0);
2835: /*EB Tax uptake - Bug No : 6472296*/
2836: /*
2837: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
2838: (p_api_version => 1.0,
2839: p_init_msg_list => FND_API.G_FALSE,
2840: p_commit => FND_API.G_FALSE,
2841: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2842: x_return_status => l_return_status,
2843: x_msg_count => l_msg_count,
2836: /*
2837: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
2838: (p_api_version => 1.0,
2839: p_init_msg_list => FND_API.G_FALSE,
2840: p_commit => FND_API.G_FALSE,
2841: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2842: x_return_status => l_return_status,
2843: x_msg_count => l_msg_count,
2844: x_msg_data => l_msg_data,
2837: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
2838: (p_api_version => 1.0,
2839: p_init_msg_list => FND_API.G_FALSE,
2840: p_commit => FND_API.G_FALSE,
2841: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2842: x_return_status => l_return_status,
2843: x_msg_count => l_msg_count,
2844: x_msg_data => l_msg_data,
2845: p_tax_id => p_cc_acct_lines_rec.tax_id,
2855: P_Tax_Amount =>l_dr_tran_tax_amt,
2856: P_Return_Status =>l_return_status,
2857: P_Error_Code =>P_Error_Code);
2858:
2859: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2860: THEN
2861: RAISE FND_API.G_EXC_ERROR;
2862: END IF;
2863: END IF;
2857: P_Error_Code =>P_Error_Code);
2858:
2859: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2860: THEN
2861: RAISE FND_API.G_EXC_ERROR;
2862: END IF;
2863: END IF;
2864: l_dr_tran_amount := l_dr_tran_amount + Nvl(l_dr_tran_tax_amt,0);
2865:
2864: l_dr_tran_amount := l_dr_tran_amount + Nvl(l_dr_tran_tax_amt,0);
2865:
2866: /* igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
2867: (p_api_version => 1.0,
2868: p_init_msg_list => FND_API.G_FALSE,
2869: p_commit => FND_API.G_FALSE,
2870: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2871: x_return_status => l_return_status,
2872: x_msg_count => l_msg_count,
2865:
2866: /* igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
2867: (p_api_version => 1.0,
2868: p_init_msg_list => FND_API.G_FALSE,
2869: p_commit => FND_API.G_FALSE,
2870: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2871: x_return_status => l_return_status,
2872: x_msg_count => l_msg_count,
2873: x_msg_data => l_msg_data,
2866: /* igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
2867: (p_api_version => 1.0,
2868: p_init_msg_list => FND_API.G_FALSE,
2869: p_commit => FND_API.G_FALSE,
2870: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2871: x_return_status => l_return_status,
2872: x_msg_count => l_msg_count,
2873: x_msg_data => l_msg_data,
2874: p_tax_id => p_cc_acct_lines_rec.tax_id,
2884: P_Tax_Amount =>l_cr_tran_tax_amt,
2885: P_Return_Status =>l_return_status,
2886: P_Error_Code =>P_Error_Code);
2887: /*EB Tax uptake - Bug No : 6472296 END*/
2888: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2889: THEN
2890: RAISE FND_API.G_EXC_ERROR;
2891: END IF;
2892: END IF;
2886: P_Error_Code =>P_Error_Code);
2887: /*EB Tax uptake - Bug No : 6472296 END*/
2888: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2889: THEN
2890: RAISE FND_API.G_EXC_ERROR;
2891: END IF;
2892: END IF;
2893: l_cr_tran_amount := l_cr_tran_amount + Nvl(l_cr_tran_tax_amt,0);
2894: -- Bug 2409502, End
3014: /*EB Tax uptake - Bug No : 6472296*/
3015: /*
3016: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
3017: (p_api_version => 1.0,
3018: p_init_msg_list => FND_API.G_FALSE,
3019: p_commit => FND_API.G_FALSE,
3020: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3021: x_return_status => l_return_status,
3022: x_msg_count => l_msg_count,
3015: /*
3016: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
3017: (p_api_version => 1.0,
3018: p_init_msg_list => FND_API.G_FALSE,
3019: p_commit => FND_API.G_FALSE,
3020: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3021: x_return_status => l_return_status,
3022: x_msg_count => l_msg_count,
3023: x_msg_data => l_msg_data,
3016: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
3017: (p_api_version => 1.0,
3018: p_init_msg_list => FND_API.G_FALSE,
3019: p_commit => FND_API.G_FALSE,
3020: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3021: x_return_status => l_return_status,
3022: x_msg_count => l_msg_count,
3023: x_msg_data => l_msg_data,
3024: p_tax_id => p_cc_acct_lines_rec.tax_id,
3034: P_Tax_Amount =>l_tran_tax_amt,
3035: P_Return_Status =>l_return_status,
3036: P_Error_Code =>P_Error_Code);
3037: /*EB Tax uptake - Bug No : 6472296 END*/
3038: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
3039: THEN
3040: RAISE FND_API.G_EXC_ERROR;
3041: END IF;
3042: END IF;
3036: P_Error_Code =>P_Error_Code);
3037: /*EB Tax uptake - Bug No : 6472296 END*/
3038: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
3039: THEN
3040: RAISE FND_API.G_EXC_ERROR;
3041: END IF;
3042: END IF;
3043: l_tran_amount := l_tran_amount + Nvl(l_tran_tax_amt,0);
3044:
3125: /*EB Tax uptake - Bug No : 6472296*/
3126: /*
3127: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
3128: (p_api_version => 1.0,
3129: p_init_msg_list => FND_API.G_FALSE,
3130: p_commit => FND_API.G_FALSE,
3131: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3132: x_return_status => l_return_status,
3133: x_msg_count => l_msg_count,
3126: /*
3127: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
3128: (p_api_version => 1.0,
3129: p_init_msg_list => FND_API.G_FALSE,
3130: p_commit => FND_API.G_FALSE,
3131: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3132: x_return_status => l_return_status,
3133: x_msg_count => l_msg_count,
3134: x_msg_data => l_msg_data,
3127: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
3128: (p_api_version => 1.0,
3129: p_init_msg_list => FND_API.G_FALSE,
3130: p_commit => FND_API.G_FALSE,
3131: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3132: x_return_status => l_return_status,
3133: x_msg_count => l_msg_count,
3134: x_msg_data => l_msg_data,
3135: p_tax_id => p_cc_acct_lines_rec.tax_id,
3145: P_Tax_Amount =>l_unbilled_tax_amt,
3146: P_Return_Status =>l_return_status,
3147: P_Error_Code =>P_Error_Code);
3148:
3149: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
3150: THEN
3151: RAISE FND_API.G_EXC_ERROR;
3152: END IF;
3153: END IF;
3147: P_Error_Code =>P_Error_Code);
3148:
3149: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
3150: THEN
3151: RAISE FND_API.G_EXC_ERROR;
3152: END IF;
3153: END IF;
3154: /*EB Tax uptake - Bug No : 6472296 END*/
3155: l_unbilled_amt := l_unbilled_amt + Nvl(l_unbilled_tax_amt,0);
3222: /*EB Tax uptake - Bug No : 6472296*/
3223: /*
3224: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
3225: (p_api_version => 1.0,
3226: p_init_msg_list => FND_API.G_FALSE,
3227: p_commit => FND_API.G_FALSE,
3228: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3229: x_return_status => l_return_status,
3230: x_msg_count => l_msg_count,
3223: /*
3224: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
3225: (p_api_version => 1.0,
3226: p_init_msg_list => FND_API.G_FALSE,
3227: p_commit => FND_API.G_FALSE,
3228: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3229: x_return_status => l_return_status,
3230: x_msg_count => l_msg_count,
3231: x_msg_data => l_msg_data,
3224: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
3225: (p_api_version => 1.0,
3226: p_init_msg_list => FND_API.G_FALSE,
3227: p_commit => FND_API.G_FALSE,
3228: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3229: x_return_status => l_return_status,
3230: x_msg_count => l_msg_count,
3231: x_msg_data => l_msg_data,
3232: p_tax_id => p_cc_acct_lines_rec.tax_id,
3241: P_Line_Id =>p_cc_acct_lines_rec.cc_acct_line_id,
3242: P_Tax_Amount =>l_tran_tax_amt,
3243: P_Return_Status =>l_return_status,
3244: P_Error_Code =>P_Error_Code);
3245: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
3246: THEN
3247: RAISE FND_API.G_EXC_ERROR;
3248: END IF;
3249: END IF;
3243: P_Return_Status =>l_return_status,
3244: P_Error_Code =>P_Error_Code);
3245: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
3246: THEN
3247: RAISE FND_API.G_EXC_ERROR;
3248: END IF;
3249: END IF;
3250: /*EB Tax uptake - Bug No : 6472296 END*/
3251: l_tran_amount := l_tran_amount + Nvl(l_tran_tax_amt,0);
3347: /*EB Tax uptake - Bug No : 6472296*/
3348: /*
3349: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
3350: (p_api_version => 1.0,
3351: p_init_msg_list => FND_API.G_FALSE,
3352: p_commit => FND_API.G_FALSE,
3353: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3354: x_return_status => l_return_status,
3355: x_msg_count => l_msg_count,
3348: /*
3349: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
3350: (p_api_version => 1.0,
3351: p_init_msg_list => FND_API.G_FALSE,
3352: p_commit => FND_API.G_FALSE,
3353: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3354: x_return_status => l_return_status,
3355: x_msg_count => l_msg_count,
3356: x_msg_data => l_msg_data,
3349: igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
3350: (p_api_version => 1.0,
3351: p_init_msg_list => FND_API.G_FALSE,
3352: p_commit => FND_API.G_FALSE,
3353: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3354: x_return_status => l_return_status,
3355: x_msg_count => l_msg_count,
3356: x_msg_data => l_msg_data,
3357: p_tax_id => p_cc_acct_lines_rec.tax_id,
3367: P_Tax_Amount =>l_tran_tax_amt,
3368: P_Return_Status =>l_return_status,
3369: P_Error_Code =>P_Error_Code);
3370:
3371: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
3372: THEN
3373: RAISE FND_API.G_EXC_ERROR;
3374: END IF;
3375: END IF;
3369: P_Error_Code =>P_Error_Code);
3370:
3371: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
3372: THEN
3373: RAISE FND_API.G_EXC_ERROR;
3374: END IF;
3375: END IF;
3376: /*EB Tax uptake - Bug No : 6472296 END*/
3377: l_tran_amount := l_tran_amount + Nvl(l_tran_tax_amt,0);
3754: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
3755:
3756: IF (l_debug_mode = 'Y')
3757: THEN
3758: l_debug := FND_API.G_TRUE;
3759: ELSE
3760: l_debug := FND_API.G_FALSE;
3761: END IF;
3762:
3756: IF (l_debug_mode = 'Y')
3757: THEN
3758: l_debug := FND_API.G_TRUE;
3759: ELSE
3760: l_debug := FND_API.G_FALSE;
3761: END IF;
3762:
3763: BEGIN
3764:
3775: p_ret_status => l_bc_return_status,
3776: p_batch_result_code => l_batch_result_code,
3777: p_doc_type => 'CC',
3778: p_debug => l_debug,
3779: p_conc_proc => FND_API.G_FALSE);
3780: END IF;
3781:
3782: IF (l_cc_headers_rec.cc_type <> 'R')
3783: THEN
3792: p_ret_status => l_bc_return_status,
3793: p_batch_result_code => l_batch_result_code,
3794: p_doc_type => 'CC',
3795: p_debug => l_debug,
3796: p_conc_proc => FND_API.G_FALSE);
3797: END IF;
3798:
3799: EXCEPTION
3800: WHEN OTHERS