DBA Data[Home] [Help]

APPS.PA_FP_COPY_FROM_PKG dependencies on PA_PROJECT_CORE1

Line 5579: and is based on the existing logic in pa_project_core1.copy_project.

5575:
5576: /*===================================================================
5577: This api copies all the budgets from source project to target
5578: project.this api only take care of the non upgraded budget versions
5579: and is based on the existing logic in pa_project_core1.copy_project.
5580: The output error parameters are designed to be in sync with existing
5581: code in pa_project_core1.copy_project
5582: ===================================================================*/
5583:

Line 5581: code in pa_project_core1.copy_project

5577: This api copies all the budgets from source project to target
5578: project.this api only take care of the non upgraded budget versions
5579: and is based on the existing logic in pa_project_core1.copy_project.
5580: The output error parameters are designed to be in sync with existing
5581: code in pa_project_core1.copy_project
5582: ===================================================================*/
5583:
5584: PROCEDURE Copy_Budgets_From_Project(
5585: p_from_project_id IN NUMBER

Line 5637: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_COPY_BUDGT_CONTRL');

5633:
5634: IF (l_return_status <> 'S') Then
5635: x_err_code := 725;
5636: -- x_err_stage := 'PA_NO_PROJ_CREATED';
5637: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_COPY_BUDGT_CONTRL');
5638:
5639: x_err_stack := x_err_stack||'->PA_BUDGET_FUND_PKG.Copy_Budgetary_Controls';
5640: -- bug 3163280 rollback to copy_project;
5641: return;

Line 5647: x_err_stage := pa_project_core1.get_message_from_stack( null );

5643:
5644: EXCEPTION WHEN OTHERS THEN
5645:
5646: x_err_code := 725;
5647: x_err_stage := pa_project_core1.get_message_from_stack( null );
5648: IF x_err_stage IS NULL
5649: THEN
5650: x_err_stage := 'API: '||'PA_BUDGET_FUND_PKG.Copy_Budgetary_Controls'||
5651: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 5734: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_GET_BASLIN_VER_ID');

5730: IF ( x_err_code < 0 ) THEN -- Oracle error
5731: x_err_code := 750;
5732: IF x_err_stage IS NULL
5733: THEN
5734: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_GET_BASLIN_VER_ID');
5735: END IF;
5736: x_err_stack := x_err_stack||'->pa_budget_utils.get_baselined_version_id';
5737: -- bug 3163280 ROLLBACK TO copy_project;
5738: RETURN;

Line 5742: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5738: RETURN;
5739: END IF;
5740: EXCEPTION WHEN OTHERS THEN
5741: x_err_code := 750;
5742: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5743: IF x_err_stage IS NULL
5744: THEN
5745: x_err_stage := 'API: '||'pa_budget_utils.get_baselined_version_id'||
5746: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 5778: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_GET_DRFT_VER_ID');

5774: IF ( x_err_code < 0 ) THEN -- Oracle error
5775: x_err_code := 755;
5776: IF x_err_stage IS NULL
5777: THEN
5778: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_GET_DRFT_VER_ID');
5779: END IF;
5780: x_err_stack := x_err_stack||'->pa_budget_utils.get_draft_version_id';
5781: -- bug 3163280 ROLLBACK TO copy_project;
5782: RETURN;

Line 5786: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5782: RETURN;
5783: END IF;
5784: EXCEPTION WHEN OTHERS THEN
5785: x_err_code := 755;
5786: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5787: IF x_err_stage IS NULL
5788: THEN
5789: x_err_stage := 'API: '||'pa_budget_utils.get_draft_version_id'||
5790: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 5823: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_BUDGT_CORE_COPY');

5819: if ( x_err_code > 0 or x_err_code < 0 ) then
5820: x_err_code := 760;
5821: IF x_err_stage IS NULL
5822: THEN
5823: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_BUDGT_CORE_COPY');
5824: END IF;
5825: x_err_stack := x_err_stack||'->pa_budget_core.copy';
5826: -- bug 3163280 rollback to copy_project;
5827: return; -- Application or Oracle error

Line 5831: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5827: return; -- Application or Oracle error
5828: end if;
5829: EXCEPTION WHEN OTHERS THEN
5830: x_err_code := 760;
5831: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5832: IF x_err_stage IS NULL
5833: THEN
5834: x_err_stage := 'API: '||'pa_budget_core.copy'||
5835: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 5885: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_SUBMIT_BUDGT');

5881: IF ( x_err_code <> 0 ) THEN
5882: x_err_code := 785;
5883: IF x_err_stage IS NULL
5884: THEN
5885: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_SUBMIT_BUDGT');
5886: END IF;
5887: x_err_stack := x_err_stack||'->pa_budget_utils2.submit_budget';
5888: ROLLBACK TO before_bill_baseline;
5889: RETURN; -- Application or Oracle error

Line 5893: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5889: RETURN; -- Application or Oracle error
5890: END IF;
5891: EXCEPTION WHEN OTHERS THEN
5892: x_err_code := 785;
5893: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5894: IF x_err_stage IS NULL
5895: THEN
5896: x_err_stage := 'API: '||'pa_budget_utils2.submit_budget'||
5897: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

Line 5938: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_REWORK_BUDGT');

5934: IF ( x_err_code <> 0 ) THEN
5935: x_err_code := 790;
5936: IF x_err_stage IS NULL
5937: THEN
5938: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_REWORK_BUDGT');
5939: END IF;
5940: x_err_stack := x_err_stack||'->pa_budget_utils2.rework_budget';
5941: ROLLBACK TO before_bill_baseline;
5942: RETURN; -- Application or Oracle error

Line 5946: -- x_err_stage := pa_project_core1.get_message_from_stack( null );

5942: RETURN; -- Application or Oracle error
5943: END IF;
5944: EXCEPTION WHEN OTHERS THEN
5945: x_err_code := 790;
5946: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5947: IF x_err_stage IS NULL
5948: THEN
5949: x_err_stage := 'API: '||'pa_budget_utils2.rework_budget'||
5950: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);