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: /* Commenting for bug 8367755

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:

Line 2290: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

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

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

Line 2313: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

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

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

Line 2356: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

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

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

Line 2377: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

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

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

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

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

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

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

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

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

Line 2397: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY;

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

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

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

Line 2399: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY;

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

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

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

Line 2401: l_plan_pref_code := PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2483: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

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

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

Line 2516: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 2546: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

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

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

Line 2573: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

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

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

Line 2650: p_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT ) THEN

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

Line 2677: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 2693: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 2714: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

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

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

Line 2753: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

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

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

Line 2776: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

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

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

Line 2806: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

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

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

Line 2825: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

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

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

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

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

Line 2851: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

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

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

Line 2866: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

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

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

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

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

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

Line 3040: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3036:
3037: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3038: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3039:
3040: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3041: END IF;
3042:
3043: l_calling_context := p_calling_context; /* Bug# 2674353 */
3044:

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

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

Line 3304: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3300: IF P_PA_DEBUG_MODE = 'Y' THEN
3301: pa_debug.g_err_stage:= 'Error Calling create_assgmt_from_rolluptmp';
3302: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,5);
3303: END IF;
3304: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3305: END IF;
3306:
3307: --Bug # 3507156-
3308: --Commented the api PROCESS_MODIFIED_LINES

Line 3331: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3327: IF P_PA_DEBUG_MODE = 'Y' THEN
3328: pa_debug.g_err_stage:= 'Error Calling PROCESS_MODIFIED_LINES';
3329: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,5);
3330: END IF;
3331: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3332: END IF;
3333:
3334: IF P_PA_DEBUG_MODE = 'Y' THEN
3335: pa_debug.g_err_stage:= 'Exiting CREATE_FINPLAN_LINES';

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

3453: ,ATTRIBUTE12
3454: ,ATTRIBUTE13
3455: ,ATTRIBUTE14
3456: ,ATTRIBUTE15
3457: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3458: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3459: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3460: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3461: ,PROJFUNC_CURRENCY_CODE

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

3454: ,ATTRIBUTE13
3455: ,ATTRIBUTE14
3456: ,ATTRIBUTE15
3457: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3458: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3459: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3460: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3461: ,PROJFUNC_CURRENCY_CODE
3462: ,PROJFUNC_COST_RATE_TYPE

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

3455: ,ATTRIBUTE14
3456: ,ATTRIBUTE15
3457: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3458: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3459: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3460: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3461: ,PROJFUNC_CURRENCY_CODE
3462: ,PROJFUNC_COST_RATE_TYPE
3463: ,PROJFUNC_COST_EXCHANGE_RATE

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

3456: ,ATTRIBUTE15
3457: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3458: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3459: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3460: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3461: ,PROJFUNC_CURRENCY_CODE
3462: ,PROJFUNC_COST_RATE_TYPE
3463: ,PROJFUNC_COST_EXCHANGE_RATE
3464: ,PROJFUNC_COST_RATE_DATE_TYPE

Line 3484: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,'User',

3480: ,PROJFUNC_REV_RATE_DATE
3481: ,PROJFUNC_REV_RATE_TYPE
3482: ,PROJFUNC_REV_EXCHANGE_RATE
3483: ,DECODE(p_calling_context,
3484: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,'User',
3485: PROJECT_REV_RATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_TYPE
3486: ,DECODE(p_calling_context,
3487: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,DECODE(PROJFUNC_REVENUE,
3488: NULL,NULL,

Line 3487: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,DECODE(PROJFUNC_REVENUE,

3483: ,DECODE(p_calling_context,
3484: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,'User',
3485: PROJECT_REV_RATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_TYPE
3486: ,DECODE(p_calling_context,
3487: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,DECODE(PROJFUNC_REVENUE,
3488: NULL,NULL,
3489: 0,0,
3490: (PROJECT_REVENUE/PROJFUNC_REVENUE)),
3491: PROJECT_REV_EXCHANGE_RATE)--Bug 4133468. PROJECT_REV_EXCHANGE_RATE

Line 3493: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,

3489: 0,0,
3490: (PROJECT_REVENUE/PROJFUNC_REVENUE)),
3491: PROJECT_REV_EXCHANGE_RATE)--Bug 4133468. PROJECT_REV_EXCHANGE_RATE
3492: ,DECODE(p_calling_context,
3493: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3494: PROJECT_REV_RATE_DATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_DATE_TYPE
3495: ,DECODE(p_calling_context,
3496: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3497: PROJECT_REV_RATE_DATE)--Bug 4133468. PROJECT_REV_RATE_DATE

Line 3496: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,

3492: ,DECODE(p_calling_context,
3493: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3494: PROJECT_REV_RATE_DATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_DATE_TYPE
3495: ,DECODE(p_calling_context,
3496: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3497: PROJECT_REV_RATE_DATE)--Bug 4133468. PROJECT_REV_RATE_DATE
3498: ,PM_PRODUCT_CODE -- , l_pm_product_code changed to pm_product_code for bug 3833724
3499: ,PM_BUDGET_LINE_REFERENCE -- Added for bug 3833724
3500: FROM pa_fp_rollup_tmp tmp

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

3595: ,ATTRIBUTE12
3596: ,ATTRIBUTE13
3597: ,ATTRIBUTE14
3598: ,ATTRIBUTE15
3599: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3600: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3601: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3602: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3603: ,PROJFUNC_CURRENCY_CODE

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

3596: ,ATTRIBUTE13
3597: ,ATTRIBUTE14
3598: ,ATTRIBUTE15
3599: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3600: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3601: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3602: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3603: ,PROJFUNC_CURRENCY_CODE
3604: ,PROJFUNC_COST_RATE_TYPE

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

3597: ,ATTRIBUTE14
3598: ,ATTRIBUTE15
3599: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3600: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3601: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3602: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3603: ,PROJFUNC_CURRENCY_CODE
3604: ,PROJFUNC_COST_RATE_TYPE
3605: ,PROJFUNC_COST_EXCHANGE_RATE

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

3598: ,ATTRIBUTE15
3599: ,nvl(RAW_COST_SOURCE,decode(PROJFUNC_RAW_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3600: ,nvl(BURDENED_COST_SOURCE,decode(PROJFUNC_BURDENED_COST,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3601: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3602: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
3603: ,PROJFUNC_CURRENCY_CODE
3604: ,PROJFUNC_COST_RATE_TYPE
3605: ,PROJFUNC_COST_EXCHANGE_RATE
3606: ,PROJFUNC_COST_RATE_DATE_TYPE

Line 3620: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,'User',

3616: ,PROJFUNC_REV_RATE_DATE
3617: ,PROJFUNC_REV_RATE_TYPE
3618: ,PROJFUNC_REV_EXCHANGE_RATE
3619: ,DECODE(p_calling_context,
3620: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,'User',
3621: PROJECT_REV_RATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_TYPE
3622: ,DECODE(p_calling_context,
3623: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,DECODE(PROJFUNC_REVENUE,
3624: NULL,NULL,

Line 3623: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,DECODE(PROJFUNC_REVENUE,

3619: ,DECODE(p_calling_context,
3620: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,'User',
3621: PROJECT_REV_RATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_TYPE
3622: ,DECODE(p_calling_context,
3623: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,DECODE(PROJFUNC_REVENUE,
3624: NULL,NULL,
3625: 0,0,
3626: (PROJECT_REVENUE/PROJFUNC_REVENUE)),
3627: PROJECT_REV_EXCHANGE_RATE)--Bug 4133468. PROJECT_REV_EXCHANGE_RATE

Line 3629: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,

3625: 0,0,
3626: (PROJECT_REVENUE/PROJFUNC_REVENUE)),
3627: PROJECT_REV_EXCHANGE_RATE)--Bug 4133468. PROJECT_REV_EXCHANGE_RATE
3628: ,DECODE(p_calling_context,
3629: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3630: PROJECT_REV_RATE_DATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_DATE_TYPE
3631: ,DECODE(p_calling_context,
3632: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3633: PROJECT_REV_RATE_DATE)--Bug 4133468. PROJECT_REV_RATE_DATE

Line 3632: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,

3628: ,DECODE(p_calling_context,
3629: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3630: PROJECT_REV_RATE_DATE_TYPE)--Bug 4133468. PROJECT_REV_RATE_DATE_TYPE
3631: ,DECODE(p_calling_context,
3632: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3633: PROJECT_REV_RATE_DATE)--Bug 4133468. PROJECT_REV_RATE_DATE
3634: ,PM_PRODUCT_CODE -- , l_pm_product_code changed to pm_product_code for bug 3833724
3635: ,PM_BUDGET_LINE_REFERENCE -- Added for bug 3833724
3636: FROM pa_fp_rollup_tmp tmp

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

3655: -- corresponding that is not getting processed and stored in pa_fp_spread_calc_tmp1
3656: -- coz of that start date of that budget line is not taken in consideration.
3657: -- To avoid this planning_start_date is updated with original value if the original
3658: -- planning_start_date is least.
3659: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API) THEN
3660: -- For scenario if actuals exist then planning start date for resource assignment
3661: -- should be least of the value presnt in pa_fp_spread_calc_tmp1 and pa_budget_lines
3662: -- else it should be least of value present in pa_fp_spread_calc_tmp1.
3663:

Line 3720: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3716: IF p_pa_debug_mode = 'Y' THEN
3717: pa_debug.reset_err_stack;
3718: END IF;
3719: EXCEPTION
3720: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3721:
3722: x_return_status := FND_API.G_RET_STS_ERROR;
3723: l_msg_count := FND_MSG_PUB.count_msg;
3724: IF l_msg_count = 1 THEN

Line 3863: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3859: pa_debug.g_err_stage := 'p_fin_plan_type_id is '||p_fin_plan_type_id ;
3860: pa_debug.write('convert_plan_type_name_to_id: ' || g_module_name
3861: ,pa_debug.g_err_stage,l_debug_level5);
3862: END IF;
3863: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3864:
3865: ELSE
3866:
3867: close l_fin_plan_type_id_csr;

Line 3889: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3885: pa_debug.g_err_stage := 'p_fin_plan_type_name is '||p_fin_plan_type_name ;
3886: pa_debug.write('convert_plan_type_name_to_id: ' || g_module_name
3887: ,pa_debug.g_err_stage,l_debug_level5);
3888: END IF;
3889: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3890:
3891: END IF;
3892: IF l_debug_mode='Y' THEN
3893: pa_debug.g_err_stage := 'x_fin_plan_type_id derived is '||x_fin_plan_type_id ;

Line 3906: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3902: (p_app_short_name => 'PA',
3903: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3904:
3905: x_return_status := FND_API.G_RET_STS_ERROR;
3906: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3907: END IF;
3908:
3909: IF l_debug_mode='Y' THEN
3910: pa_debug.g_err_stage := 'p_fin_plan_type_name is '||p_fin_plan_type_name ;

Line 3916: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3912: ,pa_debug.g_err_stage,l_debug_level5);
3913: pa_debug.reset_curr_function;
3914: END IF;
3915: EXCEPTION
3916: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3917:
3918: IF x_return_status IS NULL OR
3919: x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3920: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4042: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4038:
4039: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4040: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4041:
4042: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4043:
4044: END IF;
4045:
4046: ---------------------------------------------------------------

Line 4061: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE

4057: FROM pa_proj_fp_options pfo
4058: ,pa_fin_plan_types_b pft
4059: WHERE pfo.project_id = p_project_id
4060: AND pfo.fin_plan_type_id = pft.fin_plan_type_id
4061: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
4062: AND nvl(pft.use_for_workplan_flag,'N') = 'Y';
4063:
4064: -----------------------------------------------------------------
4065: -- Fetching the workplan structure version ids for the project id

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

4077: FETCH c_struct_ver BULK COLLECT INTO l_sv_id_tbl;
4078: IF c_struct_ver%NOTFOUND THEN
4079: IF p_pa_debug_mode = 'Y' THEN
4080: pa_debug.g_err_stage:= 'No Structure versions for the project_id passed - project_id: '||p_project_id;
4081: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4082: END IF;
4083: END IF;
4084: CLOSE c_struct_ver;
4085:

Line 4165: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4161: pa_debug.write('Delete_wp_option: ' || g_module_name,pa_debug.g_err_stage,5);
4162: pa_debug.reset_curr_function;
4163: END IF;
4164:
4165: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4166: l_msg_count := FND_MSG_PUB.count_msg;
4167: IF l_msg_count = 1 THEN
4168: PA_INTERFACE_UTILS_PUB.get_messages
4169: (p_encoded => FND_API.G_TRUE

Line 4262: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4258:
4259: l_sv_id_tbl_count := p_struct_elem_version_id_tbl.COUNT;
4260:
4261: IF l_sv_id_tbl_count = 0 THEN
4262: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4263: END IF;
4264:
4265:
4266: ------------------------------------------------------------------

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

4289:
4290: IF c_budget_ver%NOTFOUND THEN
4291: IF p_pa_debug_mode = 'Y' THEN
4292: pa_debug.g_err_stage:= 'Could not fetch budget_version_id !!!...';
4293: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4294: END IF;
4295: EXIT; -- Come out of LoopB, Jump to next iteration of LoopA
4296: END IF;
4297:

Line 4305: p_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN,

4301: ------------------------------------------------------------------
4302: pa_fin_plan_pub.Delete_Version
4303: (p_budget_version_id => c1.budget_version_id,
4304: p_record_version_number => c1.record_version_number,
4305: p_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN,
4306: p_project_id => c1.project_id,
4307: x_return_Status => l_return_Status,
4308: x_msg_count => l_msg_count,
4309: x_msg_data => l_msg_data);

Line 4322: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4318: pa_debug.reset_curr_function;
4319: END IF;
4320: EXCEPTION
4321:
4322: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4323: l_msg_count := FND_MSG_PUB.count_msg;
4324: IF l_msg_count = 1 THEN
4325: PA_INTERFACE_UTILS_PUB.get_messages
4326: (p_encoded => FND_API.G_TRUE

Line 4492: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4488: pa_debug.g_err_stage:= 'Error Calling CREATE_FINPLAN_LINES';
4489: pa_debug.write('CREATE_DRAFT: '||g_module_name,pa_debug.g_err_stage,5);
4490: END IF;
4491:
4492: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4493:
4494: END IF;
4495:
4496: END IF;

Line 4597: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)

4593: We are passing the parameter p_calling_module as G_AMG_API if its a AMG flow. This parameter would be internally used by
4594: calculate API to skip the call to client extensions for AMG flows.
4595: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be
4596: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/
4597: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4598: THEN
4599: PA_FP_CALC_PLAN_PKG.calculate
4600: ( p_project_id => l_project_id
4601: ,p_budget_version_id => p_fin_plan_version_id

Line 4633: ,p_calling_module => PA_FP_CONSTANTS_PKG.G_AMG_API

4629: ,p_del_spread_calc_tmp1_flg => 'N' /* Bug: 4309290.Added the parameter to identify if
4630: PA_FP_SPREAD_CALC_TMP1 is to be deleted or not. Frm AMG flow
4631: we will pass N and for other calls to calculate api it would
4632: be yes */
4633: ,p_calling_module => PA_FP_CONSTANTS_PKG.G_AMG_API
4634: ,x_return_status => x_return_status
4635: ,x_msg_count => x_msg_count
4636: ,x_msg_data => x_msg_data);
4637: ELSE

Line 4685: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)

4681: We are passing the parameter p_calling_module as G_AMG_API if its a AMG flow. This parameter would be internally used by
4682: calculate API to skip the call to client extensions for AMG flows.
4683: Also added the parameter so as not to delete the PA_FP_SPREAD_CALC_TMP1 table in calcualte API . This parameter whould be
4684: passed in all the flows so as not to delete the PA_FP_SPREAD_CALC_TMP1 table.*/
4685: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4686: THEN
4687: PA_FP_CALC_PLAN_PKG.calculate
4688: ( p_project_id => l_project_id
4689: ,p_budget_version_id => p_fin_plan_version_id

Line 4700: ,p_calling_module => PA_FP_CONSTANTS_PKG.G_AMG_API

4696: ,p_total_burdened_cost_tab => l_total_burdened_cost_tab
4697: ,p_total_revenue_tab => l_total_revenue_tab
4698: ,p_line_start_date_tab => l_line_start_date_tab
4699: ,p_line_end_date_tab => l_line_end_date_tab
4700: ,p_calling_module => PA_FP_CONSTANTS_PKG.G_AMG_API
4701: ,p_del_spread_calc_tmp1_flg => 'N'
4702: ,x_return_status => x_return_status
4703: ,x_msg_count => x_msg_count
4704: ,x_msg_data => x_msg_data);

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

4719: ,p_del_spread_calc_tmp1_flg => 'N'
4720: ,x_return_status => x_return_status
4721: ,x_msg_count => x_msg_count
4722: ,x_msg_data => x_msg_data);
4723: END IF; -- IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API)
4724:
4725: END IF;
4726:
4727: IF l_debug_mode = 'Y' THEN

Line 4739: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4735: pa_debug.g_err_stage:='Called API PA_FP_CALC_PLAN_PKG.calculate returned error';
4736: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
4737: END IF;
4738:
4739: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4740:
4741: END IF;
4742: IF l_debug_mode = 'Y' THEN
4743: pa_debug.g_err_stage:='Exiting ADD FIN PLAN LINES x_return_status: '||x_return_status;

Line 4749: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4745: pa_debug.reset_curr_function;
4746: END IF;
4747: EXCEPTION
4748:
4749: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4750:
4751: x_return_status := FND_API.G_RET_STS_ERROR;
4752: l_msg_count := FND_MSG_PUB.count_msg;
4753:

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

4767:
4768: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
4769:
4770: IF P_PA_DEBUG_MODE = 'Y' THEN
4771: pa_debug.write('ADD_FIN_PLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4772: pa_debug.reset_curr_function;
4773: END IF;
4774: RETURN;
4775:

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

4783: ,p_procedure_name => 'ADD_FIN_PLAN_LINES');
4784: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
4785:
4786: IF P_PA_DEBUG_MODE = 'Y' THEN
4787: pa_debug.write('ADD_FIN_PLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4788: pa_debug.reset_curr_function;
4789: END IF;
4790: RAISE;
4791: