DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_UTILS2

Line 14197: l_pa_period_name := pa_utils2.get_pa_period_name(P_TXN_DATE => l_temp_as_of_date,

14193: --- call api to get pa and gl period names for this date
14194:
14195: begin
14196:
14197: l_pa_period_name := pa_utils2.get_pa_period_name(P_TXN_DATE => l_temp_as_of_date,
14198: p_org_id => proj_org_ids_tbl(l_index));
14199: l_gl_period_name := pa_utils2.get_gl_period_name(p_gl_date => l_temp_as_of_date,
14200: p_org_id => proj_org_ids_tbl(l_index));
14201:

Line 14199: l_gl_period_name := pa_utils2.get_gl_period_name(p_gl_date => l_temp_as_of_date,

14195: begin
14196:
14197: l_pa_period_name := pa_utils2.get_pa_period_name(P_TXN_DATE => l_temp_as_of_date,
14198: p_org_id => proj_org_ids_tbl(l_index));
14199: l_gl_period_name := pa_utils2.get_gl_period_name(p_gl_date => l_temp_as_of_date,
14200: p_org_id => proj_org_ids_tbl(l_index));
14201:
14202: exception when others then
14203: pa_debug.log_message('GET_SUMM_ACT: Project Id:'||l_project_id||' Issue in finding periods.', 1);

Line 14212: p_error_text => SUBSTRB('Call of pa_utils2.get_gl_period_name failed: x_msg_data='||SQLERRM,1,120));

14208: /* Added If condition for Bug#5659575*/
14209: if p_extraction_type = 'PUBLISH' then
14210: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
14211: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
14212: p_error_text => SUBSTRB('Call of pa_utils2.get_gl_period_name failed: x_msg_data='||SQLERRM,1,120));
14213: x_return_status := 'E';
14214: RAISE;
14215: else
14216: l_err_msg := 'Periods are not defined for the transaction date :'||l_temp_as_of_date;