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.PA_FIN_PLAN_PVT dependencies on PA_FP_CONSTANTS_PKG

Line 490: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

486: p_msg_name => 'PA_FP_AR_BV_REJ_CODES_EXIST');
487:
488:
489: CLOSE c_chk_rej_codes;
490: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
491:
492: END IF;
493:
494: CLOSE c_chk_rej_codes;

Line 660: budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING, -- bug 3978894 'W',

656: update pa_budget_versions
657: set last_update_date = SYSDATE,
658: last_updated_by = FND_GLOBAL.user_id,
659: last_update_login = FND_GLOBAL.login_id,
660: budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING, -- bug 3978894 'W',
661: record_version_number = record_version_number+1
662: where budget_version_id = p_budget_version_id;
663:
664: --Bug 3882819. The impact of partially implemented change orders should be considered

Line 986: PA_UTILS.ADD_MESSAGE(p_app_short_name => PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,

982: p_new_version_id => l_target_version_id,
983: x_return_status => l_return_status,
984: x_msg_code => l_error_msg_code);
985: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
986: PA_UTILS.ADD_MESSAGE(p_app_short_name => PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
987: p_msg_name => l_error_msg_code);
988:
989: RAISE pa_fin_plan_pub.rollback_on_error;
990: END IF;

Line 1096: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1092: ' : version_type : ' || l_fc_version_type;
1093: pa_debug.write('PAFPPVTB.BASELINE_FINPLAN',pa_debug.g_err_stage,5);
1094: END IF;
1095:
1096: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1097:
1098: END IF;
1099:
1100: /* FC Version would be created only when one already doesnt exists */

Line 1109: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT

1105: ,p_fin_plan_type_id => l_fc_plan_type_ids_tbl(i)
1106: ,p_element_type => l_fc_version_type
1107: ,p_version_name => 'Initial' || l_version_name || 'Forecast Version'
1108: ,p_description => 'Initial' || l_version_name || 'Forecast Version'
1109: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT
1110: ,px_budget_version_id => l_curr_work_ver_id
1111: ,x_proj_fp_option_id => l_curr_work_fp_opt_id
1112: ,x_return_status => x_return_status
1113: ,x_msg_count => x_msg_count

Line 1125: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1121: ' : version_type : ' || l_fc_version_type;
1122: pa_debug.write('PAFPPVTB.BASELINE_FINPLAN',pa_debug.g_err_stage,5);
1123: END IF;
1124:
1125: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1126:
1127: END IF;
1128:
1129: PA_FIN_PLAN_PUB.Copy_Version

Line 1150: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1146: l_fc_plan_type_ids_tbl(i);
1147: pa_debug.write('PAFPPVTB.BASELINE_FINPLAN',pa_debug.g_err_stage,5);
1148: END IF;
1149:
1150: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1151:
1152: END IF;
1153:
1154: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1204: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1200: ' : version_type : ' || l_fc_version_type;
1201: pa_debug.write('PAFPPVTB.BASELINE_FINPLAN',pa_debug.g_err_stage,5);
1202: END IF;
1203:
1204: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1205:
1206: END IF;
1207:
1208: /* FC Version would be created only when one already doesnt exists */

Line 1217: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT

1213: ,p_fin_plan_type_id => l_fc_plan_type_ids_tbl(i)
1214: ,p_element_type => l_fc_version_type
1215: ,p_version_name => 'Initial' || l_version_name || 'Forecast Version'
1216: ,p_description => 'Initial' || l_version_name || 'Forecast Version'
1217: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT
1218: ,px_budget_version_id => l_curr_work_ver_id
1219: ,x_proj_fp_option_id => l_curr_work_fp_opt_id
1220: ,x_return_status => x_return_status
1221: ,x_msg_count => x_msg_count

Line 1233: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1229: ' : version_type : ' || l_fc_version_type;
1230: pa_debug.write('PAFPPVTB.BASELINE_FINPLAN',pa_debug.g_err_stage,5);
1231: END IF;
1232:
1233: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1234:
1235: END IF;
1236:
1237: PA_FIN_PLAN_PUB.Copy_Version

Line 1258: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1254: l_fc_plan_type_ids_tbl(i);
1255: pa_debug.write('PAFPPVTB.BASELINE_FINPLAN',pa_debug.g_err_stage,5);
1256: END IF;
1257:
1258: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1259:
1260: END IF;
1261:
1262: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1289: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

1285: when pa_fin_plan_pvt.baseline_finplan_error then
1286: rollback to before_fp_baseline;
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1288: return;
1289: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1290: rollback to before_fp_baseline;
1291: --Bug 4044009
1292: x_return_status := FND_API.G_RET_STS_ERROR;
1293: l_msg_count := FND_MSG_PUB.count_msg;

Line 1538: budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_SUBMITTED, -- bug 3978894 'S',

1534: update pa_budget_versions
1535: set last_update_date = SYSDATE,
1536: last_updated_by = FND_GLOBAL.user_id,
1537: last_update_login = FND_GLOBAL.login_id,
1538: budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_SUBMITTED, -- bug 3978894 'S',
1539: record_version_number = record_version_number+1
1540: where budget_version_id = p_budget_version_id;
1541: --dbms_output.put_line('update pa_budget_versions statement executed');
1542: -- Check whether workflow is being used for this project budget

Line 2219: l_calling_context := nvl(p_calling_context,PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT); /* Bug# 2674353 */

2215: IF P_PA_DEBUG_MODE = 'Y' THEN
2216: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,2);
2217: END IF;
2218:
2219: l_calling_context := nvl(p_calling_context,PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT); /* Bug# 2674353 */
2220: l_resource_list_id := p_resource_list_id; --bug#2831968
2221:
2222: IF p_ci_id is NULL THEN -- Bug # 2672654
2223:

Line 2244: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2240:
2241: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2242: pa_debug.g_err_stage:= 'Error Calling Get_Baselined_Version_Info';
2243: IF P_PA_DEBUG_MODE = 'Y' THEN
2244: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2245: END IF;
2246: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2247: END IF;
2248:

Line 2246: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2242: pa_debug.g_err_stage:= 'Error Calling Get_Baselined_Version_Info';
2243: IF P_PA_DEBUG_MODE = 'Y' THEN
2244: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2245: END IF;
2246: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2247: END IF;
2248:
2249: pa_debug.g_err_stage:= 'current Baselined Version id ->' || l_baselined_version_id;
2250: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2251: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2247: END IF;
2248:
2249: pa_debug.g_err_stage:= 'current Baselined Version id ->' || l_baselined_version_id;
2250: IF P_PA_DEBUG_MODE = 'Y' THEN
2251: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2252: END IF;
2253: -- bug#2831968 l_resource_list_id := p_resource_list_id;
2254:
2255:

Line 2265: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2261: END IF;
2262:
2263: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
2264: p_msg_name => 'PA_BU_BASE_RES_LIST_EXISTS');
2265: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2266: END IF;
2267: END IF;
2268:
2269: pa_debug.g_err_stage:='Entering of validation for resource list';

Line 2289: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2285: ,x_msg_count => x_msg_count
2286: ,x_msg_data => x_msg_data );
2287:
2288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2289: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2290: END IF;
2291:
2292: pa_debug.g_err_stage:='Current working version id -> ' || l_curr_work_version_id;
2293: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2310: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2306:
2307: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2308: pa_debug.g_err_stage:= 'Could not obtain the CI information for the version';
2309: IF P_PA_DEBUG_MODE = 'Y' THEN
2310: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2311: END IF;
2312: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2313: ELSE
2314: pa_debug.g_err_stage:= 'obtained the CI information for the version';

Line 2312: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2308: pa_debug.g_err_stage:= 'Could not obtain the CI information for the version';
2309: IF P_PA_DEBUG_MODE = 'Y' THEN
2310: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2311: END IF;
2312: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2313: ELSE
2314: pa_debug.g_err_stage:= 'obtained the CI information for the version';
2315: IF P_PA_DEBUG_MODE = 'Y' THEN
2316: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 2316: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2312: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2313: ELSE
2314: pa_debug.g_err_stage:= 'obtained the CI information for the version';
2315: IF P_PA_DEBUG_MODE = 'Y' THEN
2316: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2317: END IF;
2318: END IF;
2319:
2320: /* Bug 2688610 - should call delete_version rather than delete_version_helper.

Line 2355: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2351: pa_debug.g_err_stage := 'Error in lock unlock version - cannot delete working version';
2352: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,5);
2353: END IF;
2354:
2355: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2356:
2357: END IF;
2358:
2359: l_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number

Line 2374: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2370:
2371: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2372: pa_debug.g_err_stage:= 'Could not delete the current working version';
2373: IF P_PA_DEBUG_MODE = 'Y' THEN
2374: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2375: END IF;
2376: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2377: ELSE
2378: pa_debug.g_err_stage:= 'Deleted the current working version';

Line 2376: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2372: pa_debug.g_err_stage:= 'Could not delete the current working version';
2373: IF P_PA_DEBUG_MODE = 'Y' THEN
2374: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2375: END IF;
2376: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2377: ELSE
2378: pa_debug.g_err_stage:= 'Deleted the current working version';
2379: IF P_PA_DEBUG_MODE = 'Y' THEN
2380: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 2380: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2376: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2377: ELSE
2378: pa_debug.g_err_stage:= 'Deleted the current working version';
2379: IF P_PA_DEBUG_MODE = 'Y' THEN
2380: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2381: END IF;
2382: END IF;
2383:
2384: END IF;--IF l_calling_context <> PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT THEN

Line 2384: END IF;--IF l_calling_context <> PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT THEN

2380: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2381: END IF;
2382: END IF;
2383:
2384: END IF;--IF l_calling_context <> PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT THEN
2385:
2386: END IF; --l_curr_work_version_id is not null
2387: ELSE
2388: pa_debug.g_err_stage:= 'p_ci_id is not null - control item version';

Line 2390: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2386: END IF; --l_curr_work_version_id is not null
2387: ELSE
2388: pa_debug.g_err_stage:= 'p_ci_id is not null - control item version';
2389: IF P_PA_DEBUG_MODE = 'Y' THEN
2390: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2391: END IF;
2392: END IF; -- p_ci_id is NULL. Bug 2672654
2393:
2394: --Get the preference code

Line 2395: IF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN

2391: END IF;
2392: END IF; -- p_ci_id is NULL. Bug 2672654
2393:
2394: --Get the preference code
2395: IF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN
2396: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY;
2397: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE) THEN
2398: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY;
2399: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) THEN

Line 2396: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY;

2392: END IF; -- p_ci_id is NULL. Bug 2672654
2393:
2394: --Get the preference code
2395: IF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN
2396: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY;
2397: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE) THEN
2398: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY;
2399: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) THEN
2400: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME;

Line 2397: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE) THEN

2393:
2394: --Get the preference code
2395: IF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN
2396: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY;
2397: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE) THEN
2398: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY;
2399: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) THEN
2400: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME;
2401: END IF;

Line 2398: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY;

2394: --Get the preference code
2395: IF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN
2396: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY;
2397: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE) THEN
2398: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY;
2399: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) THEN
2400: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME;
2401: END IF;
2402:

Line 2399: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) THEN

2395: IF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN
2396: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY;
2397: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE) THEN
2398: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY;
2399: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) THEN
2400: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME;
2401: END IF;
2402:
2403: pa_debug.g_err_stage:= 'Preference code is -> ' || l_plan_pref_code;

Line 2400: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME;

2396: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY;
2397: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE) THEN
2398: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY;
2399: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) THEN
2400: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME;
2401: END IF;
2402:
2403: pa_debug.g_err_stage:= 'Preference code is -> ' || l_plan_pref_code;
2404: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2405: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2401: END IF;
2402:
2403: pa_debug.g_err_stage:= 'Preference code is -> ' || l_plan_pref_code;
2404: IF P_PA_DEBUG_MODE = 'Y' THEN
2405: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2406: END IF;
2407:
2408: --Get the amount set id.
2409: pa_fin_plan_utils.GET_OR_CREATE_AMOUNT_SET_ID

Line 2434: IF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN

2430: ,x_return_status => x_return_status
2431: ,x_message_data => x_msg_data
2432: );
2433:
2434: IF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN
2435: l_amount_set_id := l_cost_amount_set_id;
2436: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE) THEN
2437: l_amount_set_id := l_rev_amount_set_id;
2438: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) THEN

Line 2436: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE) THEN

2432: );
2433:
2434: IF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN
2435: l_amount_set_id := l_cost_amount_set_id;
2436: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE) THEN
2437: l_amount_set_id := l_rev_amount_set_id;
2438: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) THEN
2439: l_amount_set_id := l_all_amount_set_id;
2440: END IF;

Line 2438: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) THEN

2434: IF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN
2435: l_amount_set_id := l_cost_amount_set_id;
2436: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE) THEN
2437: l_amount_set_id := l_rev_amount_set_id;
2438: ELSIF(p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) THEN
2439: l_amount_set_id := l_all_amount_set_id;
2440: END IF;
2441:
2442: pa_debug.g_err_stage:= 'amount set id is -> ' || l_amount_set_id;

Line 2444: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2440: END IF;
2441:
2442: pa_debug.g_err_stage:= 'amount set id is -> ' || l_amount_set_id;
2443: IF P_PA_DEBUG_MODE = 'Y' THEN
2444: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2445: END IF;
2446:
2447: l_created_version_id := NULL;
2448: /* Create the plan version */

Line 2480: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2476:
2477: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2478: pa_debug.g_err_stage:= 'Error in calling Create_Version';
2479: IF P_PA_DEBUG_MODE = 'Y' THEN
2480: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2481: END IF;
2482: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2483: END IF;
2484:

Line 2482: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2478: pa_debug.g_err_stage:= 'Error in calling Create_Version';
2479: IF P_PA_DEBUG_MODE = 'Y' THEN
2480: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2481: END IF;
2482: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2483: END IF;
2484:
2485: x_budget_version_id := l_created_version_id;
2486:

Line 2490: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2486:
2487:
2488: pa_debug.g_err_stage:= 'Created budget version id is : '||l_created_version_id;
2489: IF P_PA_DEBUG_MODE = 'Y' THEN
2490: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2491: END IF;
2492:
2493: -- If the created version is a NON-CI version "AND" --- added this condition for bug 2881681
2494: -- If either of the replace current working or Create working version flags is Y then make

Line 2515: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2511: ,x_msg_count => x_msg_count
2512: ,x_msg_data => x_msg_data );
2513:
2514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2515: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2516: END IF;
2517:
2518: -- Further processing is required only if the newly created version is not the current working verion
2519:

Line 2545: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2541: pa_debug.g_err_stage := 'Error executing lock unlock version';
2542: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,3);
2543: END IF;
2544:
2545: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2546:
2547: END IF;
2548:
2549: IF l_debug_mode = 'Y' THEN

Line 2570: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2566:
2567: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2568: IF P_PA_DEBUG_MODE = 'Y' THEN
2569: pa_debug.g_err_stage:= 'Error executing Set_Current_Working ';
2570: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2571: END IF;
2572: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2573: END IF;
2574:

Line 2572: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2568: IF P_PA_DEBUG_MODE = 'Y' THEN
2569: pa_debug.g_err_stage:= 'Error executing Set_Current_Working ';
2570: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2571: END IF;
2572: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2573: END IF;
2574:
2575: END IF; -- IF l_created_version_id <> l_CW_version_id THEN
2576:

Line 2646: IF (l_calling_context = PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE AND p_ci_id IS NOT NULL) THEN

2642: /* Bug# 2676352 - For automatic baselined ci versions, budget_lines_tab is not passed and we should
2643: be creating resource assignments and fp elements based on defaults. It is to be noted that for
2644: autobaseline case, resource list id is always none and hence calling insert_defaults should be fine */
2645:
2646: IF (l_calling_context = PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE AND p_ci_id IS NOT NULL) THEN
2647:
2648: IF ( p_impacted_task_id IS NULL OR
2649: p_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT ) THEN
2650:

Line 2649: p_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT ) THEN

2645:
2646: IF (l_calling_context = PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE AND p_ci_id IS NOT NULL) THEN
2647:
2648: IF ( p_impacted_task_id IS NULL OR
2649: p_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT ) THEN
2650:
2651: -- -- Bug # 3507156
2652: -- References to PA_FP_ELEMENTS table have been commented out (FP M)
2653: -- Comment START.

Line 2676: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2672: ,x_msg_count => x_msg_count
2673: ,x_msg_data => x_msg_data);
2674:
2675: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2676: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2677: END IF;
2678:
2679:
2680: pa_debug.g_err_stage:='Calling pa_fp_elements_pub.create_enterable_resources...';

Line 2692: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2688: ,x_msg_count => x_msg_count
2689: ,x_msg_data => x_msg_data);
2690:
2691: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2692: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2693: END IF;
2694:
2695: */
2696: ---- Bug # 3507156

Line 2713: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2709: ,X_msg_count => x_msg_count
2710: ,X_msg_data => x_msg_data);
2711:
2712: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2713: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2714: END IF;
2715:
2716: ELSE
2717:

Line 2722: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2718: -- Fetching top task id and parent task id of impacted task id
2719:
2720: pa_debug.g_err_stage:= 'Fetching impacted task details';
2721: IF P_PA_DEBUG_MODE = 'Y' THEN
2722: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2723: END IF;
2724:
2725: OPEN impacted_task_cur(p_impacted_task_id);
2726: FETCH impacted_task_cur INTO impacted_task_rec;

Line 2752: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2748: pa_debug.g_err_stage := 'Error while fetching uncat res list id info ...';
2749: IF P_PA_DEBUG_MODE = 'Y' THEN
2750: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,5);
2751: END IF;
2752: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2753: END IF;
2754:
2755: l_task_elem_version_id_tbl.extend();
2756: l_task_elem_version_id_tbl(1) := impacted_task_rec.element_version_id;

Line 2773: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2769:
2770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2771: pa_debug.g_err_stage:= 'Exception while inserting a row into pa_resource_assignments;';
2772: IF P_PA_DEBUG_MODE = 'Y' THEN
2773: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2774: END IF;
2775: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2776: END IF;
2777:

Line 2775: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2771: pa_debug.g_err_stage:= 'Exception while inserting a row into pa_resource_assignments;';
2772: IF P_PA_DEBUG_MODE = 'Y' THEN
2773: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2774: END IF;
2775: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2776: END IF;
2777:
2778: END;
2779:

Line 2803: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2799:
2800: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2801: pa_debug.g_err_stage:= 'Error Calling CREATE_FINPLAN_LINES';
2802: IF P_PA_DEBUG_MODE = 'Y' THEN
2803: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2804: END IF;
2805: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2806: END IF;
2807: */

Line 2805: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2801: pa_debug.g_err_stage:= 'Error Calling CREATE_FINPLAN_LINES';
2802: IF P_PA_DEBUG_MODE = 'Y' THEN
2803: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2804: END IF;
2805: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2806: END IF;
2807: */
2808: --Bug # 3507156-
2809: --Added a call to PA_FIN_PLAN_PVT.ADD_FIN_PLAN_LINES

Line 2822: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2818:
2819: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2820: pa_debug.g_err_stage:= 'Error Calling ADD_FIN_PLAN_LINES';
2821: IF P_PA_DEBUG_MODE = 'Y' THEN
2822: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2823: END IF;
2824: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2825: END IF;
2826: END IF;

Line 2824: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2820: pa_debug.g_err_stage:= 'Error Calling ADD_FIN_PLAN_LINES';
2821: IF P_PA_DEBUG_MODE = 'Y' THEN
2822: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2823: END IF;
2824: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2825: END IF;
2826: END IF;
2827:
2828: pa_debug.g_err_stage:= 'Restoring the Control Item links if any';

Line 2830: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

2826: END IF;
2827:
2828: pa_debug.g_err_stage:= 'Restoring the Control Item links if any';
2829: IF P_PA_DEBUG_MODE = 'Y' THEN
2830: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2831: END IF;
2832:
2833: /* Commented out for bug 3550073
2834: IF ( nvl(l_ci_rec_tab.last,0) > 0 ) THEN

Line 2848: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2844:
2845: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2846: pa_debug.g_err_stage:= 'Error Calling FP_CI_LINK_CONTROL_ITEMS';
2847: IF P_PA_DEBUG_MODE = 'Y' THEN
2848: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2849: END IF;
2850: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2851: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS
2852:

Line 2850: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2846: pa_debug.g_err_stage:= 'Error Calling FP_CI_LINK_CONTROL_ITEMS';
2847: IF P_PA_DEBUG_MODE = 'Y' THEN
2848: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2849: END IF;
2850: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2851: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS
2852:
2853: END LOOP; --first..last
2854: END IF; -- l_ci_rec_tab is not null */

Line 2859: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL2);

2855:
2856:
2857: pa_debug.g_err_stage:= 'Exiting CREATE_DRAFT';
2858: IF P_PA_DEBUG_MODE = 'Y' THEN
2859: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL2);
2860: pa_debug.reset_err_stack;
2861: END IF;
2862:
2863: EXCEPTION

Line 2865: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

2861: END IF;
2862:
2863: EXCEPTION
2864:
2865: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2866:
2867: x_return_status := FND_API.G_RET_STS_ERROR;
2868: l_msg_count := FND_MSG_PUB.count_msg;
2869: IF l_msg_count = 1 THEN

Line 2885: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2881: END IF;
2882:
2883: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
2884: IF P_PA_DEBUG_MODE = 'Y' THEN
2885: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2886: pa_debug.reset_err_stack;
2887: END IF;
2888: RAISE;
2889:

Line 2899: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2895: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fin_plan_pvt'
2896: ,p_procedure_name => 'CREATE_DRAFT');
2897: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
2898: IF P_PA_DEBUG_MODE = 'Y' THEN
2899: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2900: pa_debug.reset_err_stack;
2901: END IF;
2902: RAISE;
2903:

Line 3035: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3031:
3032: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3033: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3034:
3035: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3036: END IF;
3037:
3038: l_calling_context := p_calling_context; /* Bug# 2674353 */
3039:

Line 3125: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3121: pa_fp_rollup_tmp table in case they are not being passed to this API. */
3122:
3123: IF P_PA_DEBUG_MODE = 'Y' THEN
3124: pa_debug.g_err_stage:= 'Getting the proj and projfunc currency codes';
3125: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3126: END IF;
3127:
3128: SELECT project_currency_code
3129: ,projfunc_currency_code

Line 3296: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3292: IF P_PA_DEBUG_MODE = 'Y' THEN
3293: pa_debug.g_err_stage:= 'Error Calling create_assgmt_from_rolluptmp';
3294: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,5);
3295: END IF;
3296: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3297: END IF;
3298:
3299: --Bug # 3507156-
3300: --Commented the api PROCESS_MODIFIED_LINES

Line 3323: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3319: IF P_PA_DEBUG_MODE = 'Y' THEN
3320: pa_debug.g_err_stage:= 'Error Calling PROCESS_MODIFIED_LINES';
3321: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,5);
3322: END IF;
3323: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3324: END IF;
3325:
3326: IF P_PA_DEBUG_MODE = 'Y' THEN
3327: pa_debug.g_err_stage:= 'Exiting CREATE_FINPLAN_LINES';

Line 3449: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

3445: ,ATTRIBUTE12
3446: ,ATTRIBUTE13
3447: ,ATTRIBUTE14
3448: ,ATTRIBUTE15
3449: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3450: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3451: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3452: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3453: ,PROJFUNC_CURRENCY_CODE

Line 3450: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

3446: ,ATTRIBUTE13
3447: ,ATTRIBUTE14
3448: ,ATTRIBUTE15
3449: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3450: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3451: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3452: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3453: ,PROJFUNC_CURRENCY_CODE
3454: ,PROJFUNC_COST_RATE_TYPE

Line 3451: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

3447: ,ATTRIBUTE14
3448: ,ATTRIBUTE15
3449: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3450: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3451: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3452: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3453: ,PROJFUNC_CURRENCY_CODE
3454: ,PROJFUNC_COST_RATE_TYPE
3455: ,PROJFUNC_COST_EXCHANGE_RATE

Line 3452: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

3448: ,ATTRIBUTE15
3449: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3450: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3451: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3452: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3453: ,PROJFUNC_CURRENCY_CODE
3454: ,PROJFUNC_COST_RATE_TYPE
3455: ,PROJFUNC_COST_EXCHANGE_RATE
3456: ,PROJFUNC_COST_RATE_DATE_TYPE

Line 3476: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,'User',

3472: ,PROJFUNC_REV_RATE_DATE
3473: ,PROJFUNC_REV_RATE_TYPE
3474: ,PROJFUNC_REV_EXCHANGE_RATE
3475: ,DECODE(p_calling_context,
3476: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,'User',
3477: PROJECT_REV_RATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_TYPE
3478: ,DECODE(p_calling_context,
3479: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,DECODE(PROJFUNC_REVENUE,
3480: NULL,NULL,

Line 3479: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,DECODE(PROJFUNC_REVENUE,

3475: ,DECODE(p_calling_context,
3476: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,'User',
3477: PROJECT_REV_RATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_TYPE
3478: ,DECODE(p_calling_context,
3479: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,DECODE(PROJFUNC_REVENUE,
3480: NULL,NULL,
3481: 0,0,
3482: (PROJECT_REVENUE/PROJFUNC_REVENUE)),
3483: PROJECT_REV_EXCHANGE_RATE)--Bug 4133468. PROJECT_REV_EXCHANGE_RATE

Line 3485: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,

3481: 0,0,
3482: (PROJECT_REVENUE/PROJFUNC_REVENUE)),
3483: PROJECT_REV_EXCHANGE_RATE)--Bug 4133468. PROJECT_REV_EXCHANGE_RATE
3484: ,DECODE(p_calling_context,
3485: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3486: PROJECT_REV_RATE_DATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_DATE_TYPE
3487: ,DECODE(p_calling_context,
3488: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3489: PROJECT_REV_RATE_DATE)--Bug 4133468. PROJECT_REV_RATE_DATE

Line 3488: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,

3484: ,DECODE(p_calling_context,
3485: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3486: PROJECT_REV_RATE_DATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_DATE_TYPE
3487: ,DECODE(p_calling_context,
3488: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3489: PROJECT_REV_RATE_DATE)--Bug 4133468. PROJECT_REV_RATE_DATE
3490: ,PM_PRODUCT_CODE -- , l_pm_product_code changed to pm_product_code for bug 3833724
3491: ,PM_BUDGET_LINE_REFERENCE -- Added for bug 3833724
3492: FROM pa_fp_rollup_tmp tmp

Line 3591: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

3587: ,ATTRIBUTE12
3588: ,ATTRIBUTE13
3589: ,ATTRIBUTE14
3590: ,ATTRIBUTE15
3591: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3592: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3593: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3594: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3595: ,PROJFUNC_CURRENCY_CODE

Line 3592: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

3588: ,ATTRIBUTE13
3589: ,ATTRIBUTE14
3590: ,ATTRIBUTE15
3591: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3592: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3593: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3594: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3595: ,PROJFUNC_CURRENCY_CODE
3596: ,PROJFUNC_COST_RATE_TYPE

Line 3593: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

3589: ,ATTRIBUTE14
3590: ,ATTRIBUTE15
3591: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3592: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3593: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3594: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3595: ,PROJFUNC_CURRENCY_CODE
3596: ,PROJFUNC_COST_RATE_TYPE
3597: ,PROJFUNC_COST_EXCHANGE_RATE

Line 3594: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))

3590: ,ATTRIBUTE15
3591: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3592: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3593: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3594: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3595: ,PROJFUNC_CURRENCY_CODE
3596: ,PROJFUNC_COST_RATE_TYPE
3597: ,PROJFUNC_COST_EXCHANGE_RATE
3598: ,PROJFUNC_COST_RATE_DATE_TYPE

Line 3612: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,'User',

3608: ,PROJFUNC_REV_RATE_DATE
3609: ,PROJFUNC_REV_RATE_TYPE
3610: ,PROJFUNC_REV_EXCHANGE_RATE
3611: ,DECODE(p_calling_context,
3612: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,'User',
3613: PROJECT_REV_RATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_TYPE
3614: ,DECODE(p_calling_context,
3615: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,DECODE(PROJFUNC_REVENUE,
3616: NULL,NULL,

Line 3615: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,DECODE(PROJFUNC_REVENUE,

3611: ,DECODE(p_calling_context,
3612: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,'User',
3613: PROJECT_REV_RATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_TYPE
3614: ,DECODE(p_calling_context,
3615: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,DECODE(PROJFUNC_REVENUE,
3616: NULL,NULL,
3617: 0,0,
3618: (PROJECT_REVENUE/PROJFUNC_REVENUE)),
3619: PROJECT_REV_EXCHANGE_RATE)--Bug 4133468. PROJECT_REV_EXCHANGE_RATE

Line 3621: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,

3617: 0,0,
3618: (PROJECT_REVENUE/PROJFUNC_REVENUE)),
3619: PROJECT_REV_EXCHANGE_RATE)--Bug 4133468. PROJECT_REV_EXCHANGE_RATE
3620: ,DECODE(p_calling_context,
3621: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3622: PROJECT_REV_RATE_DATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_DATE_TYPE
3623: ,DECODE(p_calling_context,
3624: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3625: PROJECT_REV_RATE_DATE)--Bug 4133468. PROJECT_REV_RATE_DATE

Line 3624: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,

3620: ,DECODE(p_calling_context,
3621: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3622: PROJECT_REV_RATE_DATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_DATE_TYPE
3623: ,DECODE(p_calling_context,
3624: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3625: PROJECT_REV_RATE_DATE)--Bug 4133468. PROJECT_REV_RATE_DATE
3626: ,PM_PRODUCT_CODE -- , l_pm_product_code changed to pm_product_code for bug 3833724
3627: ,PM_BUDGET_LINE_REFERENCE -- Added for bug 3833724
3628: FROM pa_fp_rollup_tmp tmp

Line 3651: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API) THEN

3647: -- corresponding that is not getting processed and stored in pa_fp_spread_calc_tmp1
3648: -- coz of that start date of that budget line is not taken in consideration.
3649: -- To avoid this planning_start_date is updated with original value if the original
3650: -- planning_start_date is least.
3651: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API) THEN
3652: -- For scenario if actuals exist then planning start date for resource assignment
3653: -- should be least of the value presnt in pa_fp_spread_calc_tmp1 and pa_budget_lines
3654: -- else it should be least of value present in pa_fp_spread_calc_tmp1.
3655: update pa_resource_assignments pra

Line 3681: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3677: IF p_pa_debug_mode = 'Y' THEN
3678: pa_debug.reset_err_stack;
3679: END IF;
3680: EXCEPTION
3681: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3682:
3683: x_return_status := FND_API.G_RET_STS_ERROR;
3684: l_msg_count := FND_MSG_PUB.count_msg;
3685: IF l_msg_count = 1 THEN

Line 3824: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3820: pa_debug.g_err_stage := 'p_fin_plan_type_id is '||p_fin_plan_type_id ;
3821: pa_debug.write('convert_plan_type_name_to_id: ' || g_module_name
3822: ,pa_debug.g_err_stage,l_debug_level5);
3823: END IF;
3824: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3825:
3826: ELSE
3827:
3828: close l_fin_plan_type_id_csr;

Line 3850: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3846: pa_debug.g_err_stage := 'p_fin_plan_type_name is '||p_fin_plan_type_name ;
3847: pa_debug.write('convert_plan_type_name_to_id: ' || g_module_name
3848: ,pa_debug.g_err_stage,l_debug_level5);
3849: END IF;
3850: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3851:
3852: END IF;
3853: IF l_debug_mode='Y' THEN
3854: pa_debug.g_err_stage := 'x_fin_plan_type_id derived is '||x_fin_plan_type_id ;

Line 3867: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3863: (p_app_short_name => 'PA',
3864: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3865:
3866: x_return_status := FND_API.G_RET_STS_ERROR;
3867: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3868: END IF;
3869:
3870: IF l_debug_mode='Y' THEN
3871: pa_debug.g_err_stage := 'p_fin_plan_type_name is '||p_fin_plan_type_name ;

Line 3877: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3873: ,pa_debug.g_err_stage,l_debug_level5);
3874: pa_debug.reset_curr_function;
3875: END IF;
3876: EXCEPTION
3877: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3878:
3879: IF x_return_status IS NULL OR
3880: x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3881: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4003: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3999:
4000: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4001: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4002:
4003: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4004:
4005: END IF;
4006:
4007: ---------------------------------------------------------------

Line 4022: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE

4018: FROM pa_proj_fp_options pfo
4019: ,pa_fin_plan_types_b pft
4020: WHERE pfo.project_id = p_project_id
4021: AND pfo.fin_plan_type_id = pft.fin_plan_type_id
4022: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
4023: AND nvl(pft.use_for_workplan_flag,'N') = 'Y';
4024:
4025: -----------------------------------------------------------------
4026: -- Fetching the workplan structure version ids for the project id

Line 4042: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

4038: FETCH c_struct_ver BULK COLLECT INTO l_sv_id_tbl;
4039: IF c_struct_ver%NOTFOUND THEN
4040: IF p_pa_debug_mode = 'Y' THEN
4041: pa_debug.g_err_stage:= 'No Structure versions for the project_id passed - project_id: '||p_project_id;
4042: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4043: END IF;
4044: END IF;
4045: CLOSE c_struct_ver;
4046:

Line 4126: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4122: pa_debug.write('Delete_wp_option: ' || g_module_name,pa_debug.g_err_stage,5);
4123: pa_debug.reset_curr_function;
4124: END IF;
4125:
4126: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4127: l_msg_count := FND_MSG_PUB.count_msg;
4128: IF l_msg_count = 1 THEN
4129: PA_INTERFACE_UTILS_PUB.get_messages
4130: (p_encoded => FND_API.G_TRUE

Line 4223: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4219:
4220: l_sv_id_tbl_count := p_struct_elem_version_id_tbl.COUNT;
4221:
4222: IF l_sv_id_tbl_count = 0 THEN
4223: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4224: END IF;
4225:
4226:
4227: ------------------------------------------------------------------

Line 4254: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

4250:
4251: IF c_budget_ver%NOTFOUND THEN
4252: IF p_pa_debug_mode = 'Y' THEN
4253: pa_debug.g_err_stage:= 'Could not fetch budget_version_id !!!...';
4254: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4255: END IF;
4256: EXIT; -- Come out of LoopB, Jump to next iteration of LoopA
4257: END IF;
4258:

Line 4266: p_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN,

4262: ------------------------------------------------------------------
4263: pa_fin_plan_pub.Delete_Version
4264: (p_budget_version_id => c1.budget_version_id,
4265: p_record_version_number => c1.record_version_number,
4266: p_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN,
4267: p_project_id => c1.project_id,
4268: x_return_Status => l_return_Status,
4269: x_msg_count => l_msg_count,
4270: x_msg_data => l_msg_data);

Line 4283: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4279: pa_debug.reset_curr_function;
4280: END IF;
4281: EXCEPTION
4282:
4283: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4284: l_msg_count := FND_MSG_PUB.count_msg;
4285: IF l_msg_count = 1 THEN
4286: PA_INTERFACE_UTILS_PUB.get_messages
4287: (p_encoded => FND_API.G_TRUE

Line 4453: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4449: pa_debug.g_err_stage:= 'Error Calling CREATE_FINPLAN_LINES';
4450: pa_debug.write('CREATE_DRAFT: '||g_module_name,pa_debug.g_err_stage,5);
4451: END IF;
4452:
4453: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4454:
4455: END IF;
4456:
4457: END IF;

Line 4558: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)

4554: We are passing the parameter p_calling_module as G_AMG_API if its a AMG flow. This parameter would be internally used by
4555: calculate API to skip the call to client extensions for AMG flows.
4556: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be
4557: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/
4558: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4559: THEN
4560: PA_FP_CALC_PLAN_PKG.calculate
4561: ( p_project_id => l_project_id
4562: ,p_budget_version_id => p_fin_plan_version_id

Line 4594: ,p_calling_module => PA_FP_CONSTANTS_PKG.G_AMG_API

4590: ,p_del_spread_calc_tmp1_flg => 'N' /* Bug: 4309290.Added the parameter to identify if
4591: PA_FP_SPREAD_CALC_TMP1 is to be deleted or not. Frm AMG flow
4592: we will pass N and for other calls to calculate api it would
4593: be yes */
4594: ,p_calling_module => PA_FP_CONSTANTS_PKG.G_AMG_API
4595: ,x_return_status => x_return_status
4596: ,x_msg_count => x_msg_count
4597: ,x_msg_data => x_msg_data);
4598: ELSE

Line 4646: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)

4642: We are passing the parameter p_calling_module as G_AMG_API if its a AMG flow. This parameter would be internally used by
4643: calculate API to skip the call to client extensions for AMG flows.
4644: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be
4645: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/
4646: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4647: THEN
4648: PA_FP_CALC_PLAN_PKG.calculate
4649: ( p_project_id => l_project_id
4650: ,p_budget_version_id => p_fin_plan_version_id

Line 4661: ,p_calling_module => PA_FP_CONSTANTS_PKG.G_AMG_API

4657: ,p_total_burdened_cost_tab => l_total_burdened_cost_tab
4658: ,p_total_revenue_tab => l_total_revenue_tab
4659: ,p_line_start_date_tab => l_line_start_date_tab
4660: ,p_line_end_date_tab => l_line_end_date_tab
4661: ,p_calling_module => PA_FP_CONSTANTS_PKG.G_AMG_API
4662: ,p_del_spread_calc_tmp1_flg => 'N'
4663: ,x_return_status => x_return_status
4664: ,x_msg_count => x_msg_count
4665: ,x_msg_data => x_msg_data);

Line 4684: END IF; -- IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)

4680: ,p_del_spread_calc_tmp1_flg => 'N'
4681: ,x_return_status => x_return_status
4682: ,x_msg_count => x_msg_count
4683: ,x_msg_data => x_msg_data);
4684: END IF; -- IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4685:
4686: END IF;
4687:
4688: IF l_debug_mode = 'Y' THEN

Line 4700: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4696: pa_debug.g_err_stage:='Called API PA_FP_CALC_PLAN_PKG.calculate returned error';
4697: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
4698: END IF;
4699:
4700: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4701:
4702: END IF;
4703: IF l_debug_mode = 'Y' THEN
4704: pa_debug.g_err_stage:='Exiting ADD FIN PLAN LINES x_return_status: '||x_return_status;

Line 4710: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4706: pa_debug.reset_curr_function;
4707: END IF;
4708: EXCEPTION
4709:
4710: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4711:
4712: x_return_status := FND_API.G_RET_STS_ERROR;
4713: l_msg_count := FND_MSG_PUB.count_msg;
4714:

Line 4732: pa_debug.write('ADD_FIN_PLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

4728:
4729: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
4730:
4731: IF P_PA_DEBUG_MODE = 'Y' THEN
4732: pa_debug.write('ADD_FIN_PLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4733: pa_debug.reset_curr_function;
4734: END IF;
4735: RETURN;
4736:

Line 4748: pa_debug.write('ADD_FIN_PLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

4744: ,p_procedure_name => 'ADD_FIN_PLAN_LINES');
4745: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
4746:
4747: IF P_PA_DEBUG_MODE = 'Y' THEN
4748: pa_debug.write('ADD_FIN_PLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4749: pa_debug.reset_curr_function;
4750: END IF;
4751: RAISE;
4752: