[Home] [Help]
193: -- 18-DEC-02 gjain For bug 2588244 Added logic in copy_project to copy the
194: -- default calendar from the organization specified in quick entry
195: --
196: -- 11-Feb-03 sacgupta Bug2787577.
197: -- Modified the call to pa_accum_proj_list.Insert_Accum API.
198: -- Now this API will be called for Projects only and not for
199: -- Project Templates.
200: --
201: -- 23-APR-09 jsundara Bug8297384
5487: -- anlee end of changes
5488:
5489: --EH Changes
5490: --
5491: -- Bug2787577. If x_template_flag = 'Y', do not call API pa_accum_proj_list.Insert_accum.
5492: -- Encapsulated the EH changes inside the IF - END IF
5493: --
5494: IF x_template_flag = 'N' THEN
5495: BEGIN
5493: --
5494: IF x_template_flag = 'N' THEN
5495: BEGIN
5496: x_err_stage := 'PSI Project List-Insert Accum';
5497: pa_accum_proj_list.Insert_Accum
5498: ( p_project_id => x_new_project_id
5499: ,x_return_status => l_return_status
5500: ,x_msg_count => l_msg_count
5501: ,x_msg_data => l_msg_data
5503: IF l_return_status <> fnd_api.g_ret_sts_success
5504: THEN
5505: x_err_code := 735;
5506: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_INSERT_ACCUM');
5507: x_err_stack := x_err_stack||'->pa_accum_proj_list.Insert_Accum';
5508: rollback to copy_project;
5509: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5510: return;
5511: END IF;
5513: x_err_code := 735;
5514: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5515: -- IF x_err_stage IS NULL
5516: -- THEN
5517: x_err_stage := 'API: '||'pa_accum_proj_list.Insert_Accum'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5518: -- END IF;
5519: rollback to copy_project;
5520: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5521: return;