DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_FP_MAINTAIN_ACTUAL_PUB

Line 9478: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP

9474: l_struture_version_ids.extend(1);
9475: l_struture_version_ids(1) := l_structure_version_id;
9476: l_proj_thru_dates_tbl.extend(1);
9477: l_proj_thru_dates_tbl(1) := p_as_of_date;
9478: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP
9479: (P_PROJECT_ID_TAB => l_project_ids,
9480: P_WP_STR_VERSION_ID_TAB => l_struture_version_ids,
9481: P_ACTUALS_THRU_DATE => l_proj_thru_dates_tbl,
9482: P_CALLING_CONTEXT => 'WP_PROGRESS',

Line 9497: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));

9493: EXCEPTION
9494: WHEN OTHERS THEN
9495: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9496: p_procedure_name => 'update_progress',
9497: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
9498: RAISE FND_API.G_EXC_ERROR;
9499: END;
9500:
9501: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 18075: x_Msg => 'Calling PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP',

18071:
18072: ---here call the budget lines api
18073: IF g1_debug_mode = 'Y' THEN
18074: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.get_summarized_actuals',
18075: x_Msg => 'Calling PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP',
18076: x_Log_Level=> 3);
18077: END IF;
18078:
18079: FORALL i IN 1..l_index_etc

Line 18217: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP

18213: skip_proj_ids_tbl(1) := proj_ids_tbl(i);
18214: skip_latest_wp_str_ver_id_tbl(1) := latest_wp_struct_ver_ids_tbl(i);
18215: skip_proj_thru_dates_tbl(1) := proj_thru_dates_tbl(i);
18216: /* Call this Api in single project mode */
18217: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP
18218: (P_PROJECT_ID_TAB => skip_proj_ids_tbl,
18219: P_WP_STR_VERSION_ID_TAB => skip_latest_wp_str_ver_id_tbl,
18220: P_ACTUALS_THRU_DATE => skip_proj_thru_dates_tbl,
18221: P_CALLING_CONTEXT => 'WP_SUMMARIZED_ACTUAL',

Line 18237: l_err_msg := SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP: '||SQLERRM,1,120);

18233: Rollback to ACT_FP_PROJECT;
18234: end if;
18235:
18236: EXCEPTION WHEN OTHERS THEN
18237: l_err_msg := SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP: '||SQLERRM,1,120);
18238: l_act_err_flag(i) := 1;
18239: l_act_err_msg(i) := l_err_msg;
18240: l_act_out_report := 'Y';
18241: Rollback to ACT_FP_PROJECT;

Line 18285: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP

18281:
18282: -- End: Fix for Bug # 4018249.
18283:
18284: begin
18285: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP
18286: (P_PROJECT_ID_TAB => proj_ids_tbl,
18287: P_WP_STR_VERSION_ID_TAB => latest_wp_struct_ver_ids_tbl,
18288: P_ACTUALS_THRU_DATE => proj_thru_dates_tbl,
18289: P_CALLING_CONTEXT => 'WP_SUMMARIZED_ACTUAL',

Line 18298: pa_debug.log_message('GET_SUMM_ACT: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP returned error.', 1);

18294: x_MSG_COUNT => x_msg_count,
18295: x_MSG_DATA => x_msg_data);
18296:
18297: if (x_return_status <> 'S') then
18298: pa_debug.log_message('GET_SUMM_ACT: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP returned error.', 1);
18299: end if;
18300:
18301: IF g1_debug_mode = 'Y' THEN
18302: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.get_summarized_actuals',

Line 18303: x_Msg => 'Done PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP',

18299: end if;
18300:
18301: IF g1_debug_mode = 'Y' THEN
18302: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.get_summarized_actuals',
18303: x_Msg => 'Done PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP',
18304: x_Log_Level=> 3);
18305: END IF;
18306:
18307: EXCEPTION when others then

Line 18308: pa_debug.log_message('GET_SUMM_ACT: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP returned exception.', 1);

18304: x_Log_Level=> 3);
18305: END IF;
18306:
18307: EXCEPTION when others then
18308: pa_debug.log_message('GET_SUMM_ACT: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP returned exception.', 1);
18309: x_return_status := 'E';
18310: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
18311: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
18312: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));

Line 18312: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));

18308: pa_debug.log_message('GET_SUMM_ACT: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP returned exception.', 1);
18309: x_return_status := 'E';
18310: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
18311: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
18312: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
18313: raise;
18314: end;
18315:
18316: -- Begin: Fix for Bug # 4018249.

Line 21936: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP

21932: l_struture_version_ids(1) := l_structure_version_id_tbl(i);
21933: l_proj_thru_dates_tbl.extend(1);
21934: l_proj_thru_dates_tbl(1) := p_as_of_date_tbl(i);
21935: -- We can additionally check the existence of data before calling
21936: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP
21937: (P_PROJECT_ID_TAB => l_project_ids,
21938: P_WP_STR_VERSION_ID_TAB => l_struture_version_ids,
21939: P_ACTUALS_THRU_DATE => l_proj_thru_dates_tbl,
21940: P_CALLING_CONTEXT => 'WP_PROGRESS',

Line 21966: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));

21962: EXCEPTION
21963: WHEN OTHERS THEN
21964: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
21965: p_procedure_name => 'UPDATE_PROGRESS_BULK',
21966: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
21967: RAISE FND_API.G_EXC_ERROR;
21968: END;
21969: END IF; --l_check
21970: END IF;