DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_FP_MAINTAIN_ACTUAL_PUB

Line 9911: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP

9907: l_struture_version_ids.extend(1);
9908: l_struture_version_ids(1) := l_structure_version_id;
9909: l_proj_thru_dates_tbl.extend(1);
9910: l_proj_thru_dates_tbl(1) := p_as_of_date;
9911: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP
9912: (P_PROJECT_ID_TAB => l_project_ids,
9913: P_WP_STR_VERSION_ID_TAB => l_struture_version_ids,
9914: P_ACTUALS_THRU_DATE => l_proj_thru_dates_tbl,
9915: P_CALLING_CONTEXT => 'WP_PROGRESS',

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

9926: EXCEPTION
9927: WHEN OTHERS THEN
9928: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9929: p_procedure_name => 'update_progress',
9930: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
9931: RAISE FND_API.G_EXC_ERROR;
9932: END;
9933:
9934: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

19507:
19508: ---here call the budget lines api
19509: IF g1_debug_mode = 'Y' THEN
19510: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.get_summarized_actuals',
19511: x_Msg => 'Calling PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP',
19512: x_Log_Level=> 3);
19513: END IF;
19514:
19515: -- FORALL i IN 1..l_index_etc

Line 19662: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP

19658: skip_proj_ids_tbl(1) := proj_ids_tbl(i);
19659: skip_latest_wp_str_ver_id_tbl(1) := latest_wp_struct_ver_ids_tbl(i);
19660: skip_proj_thru_dates_tbl(1) := proj_thru_dates_tbl(i);
19661: /* Call this Api in single project mode */
19662: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP
19663: (P_PROJECT_ID_TAB => skip_proj_ids_tbl,
19664: P_WP_STR_VERSION_ID_TAB => skip_latest_wp_str_ver_id_tbl,
19665: P_ACTUALS_THRU_DATE => skip_proj_thru_dates_tbl,
19666: P_CALLING_CONTEXT => 'WP_SUMMARIZED_ACTUAL',

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

19678: Rollback to ACT_FP_PROJECT;
19679: end if;
19680:
19681: EXCEPTION WHEN OTHERS THEN
19682: l_err_msg := SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP: '||SQLERRM,1,120);
19683: l_act_err_flag(i) := 1;
19684: l_act_err_msg(i) := l_err_msg;
19685: l_act_out_report := 'Y';
19686: Rollback to ACT_FP_PROJECT;

Line 19730: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP

19726:
19727: -- End: Fix for Bug # 4018249.
19728:
19729: begin
19730: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP
19731: (P_PROJECT_ID_TAB => proj_ids_tbl,
19732: P_WP_STR_VERSION_ID_TAB => latest_wp_struct_ver_ids_tbl,
19733: P_ACTUALS_THRU_DATE => proj_thru_dates_tbl,
19734: P_CALLING_CONTEXT => 'WP_SUMMARIZED_ACTUAL',

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

19739: x_MSG_COUNT => x_msg_count,
19740: x_MSG_DATA => x_msg_data);
19741:
19742: if (x_return_status <> 'S') then
19743: pa_debug.log_message('GET_SUMM_ACT: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP returned error.', 1);
19744: end if;
19745:
19746: IF g1_debug_mode = 'Y' THEN
19747: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.get_summarized_actuals',

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

19744: end if;
19745:
19746: IF g1_debug_mode = 'Y' THEN
19747: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.get_summarized_actuals',
19748: x_Msg => 'Done PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP',
19749: x_Log_Level=> 3);
19750: END IF;
19751:
19752: EXCEPTION when others then

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

19749: x_Log_Level=> 3);
19750: END IF;
19751:
19752: EXCEPTION when others then
19753: pa_debug.log_message('GET_SUMM_ACT: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP returned exception.', 1);
19754: x_return_status := 'E';
19755: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19756: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
19757: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));

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

19753: pa_debug.log_message('GET_SUMM_ACT: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP returned exception.', 1);
19754: x_return_status := 'E';
19755: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19756: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
19757: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
19758: raise;
19759: end;
19760:
19761: -- Begin: Fix for Bug # 4018249.

Line 23424: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP

23420: l_struture_version_ids(1) := l_structure_version_id_tbl(i);
23421: l_proj_thru_dates_tbl.extend(1);
23422: l_proj_thru_dates_tbl(1) := p_as_of_date_tbl(i);
23423: -- We can additionally check the existence of data before calling
23424: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP
23425: (P_PROJECT_ID_TAB => l_project_ids,
23426: P_WP_STR_VERSION_ID_TAB => l_struture_version_ids,
23427: P_ACTUALS_THRU_DATE => l_proj_thru_dates_tbl,
23428: P_CALLING_CONTEXT => 'WP_PROGRESS',

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

23450: EXCEPTION
23451: WHEN OTHERS THEN
23452: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
23453: p_procedure_name => 'UPDATE_PROGRESS_BULK',
23454: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
23455: RAISE FND_API.G_EXC_ERROR;
23456: END;
23457: END IF; --l_check
23458: END IF;