DBA Data[Home] [Help]

APPS.PA_FP_COPY_FROM_PKG dependencies on PA_PROJECT_CORE1

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

5587:
5588: /*===================================================================
5589: This api copies all the budgets from source project to target
5590: project.this api only take care of the non upgraded budget versions
5591: and is based on the existing logic in pa_project_core1.copy_project.
5592: The output error parameters are designed to be in sync with existing
5593: code in pa_project_core1.copy_project
5594: ===================================================================*/
5595:

Line 5593: code in pa_project_core1.copy_project

5589: This api copies all the budgets from source project to target
5590: project.this api only take care of the non upgraded budget versions
5591: and is based on the existing logic in pa_project_core1.copy_project.
5592: The output error parameters are designed to be in sync with existing
5593: code in pa_project_core1.copy_project
5594: ===================================================================*/
5595:
5596: PROCEDURE Copy_Budgets_From_Project(
5597: p_from_project_id IN NUMBER

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

5645:
5646: IF (l_return_status <> 'S') Then
5647: x_err_code := 725;
5648: -- x_err_stage := 'PA_NO_PROJ_CREATED';
5649: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_COPY_BUDGT_CONTRL');
5650:
5651: x_err_stack := x_err_stack||'->PA_BUDGET_FUND_PKG.Copy_Budgetary_Controls';
5652: -- bug 3163280 rollback to copy_project;
5653: return;

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

5655:
5656: EXCEPTION WHEN OTHERS THEN
5657:
5658: x_err_code := 725;
5659: x_err_stage := pa_project_core1.get_message_from_stack( null );
5660: IF x_err_stage IS NULL
5661: THEN
5662: x_err_stage := 'API: '||'PA_BUDGET_FUND_PKG.Copy_Budgetary_Controls'||
5663: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

5742: IF ( x_err_code < 0 ) THEN -- Oracle error
5743: x_err_code := 750;
5744: IF x_err_stage IS NULL
5745: THEN
5746: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_GET_BASLIN_VER_ID');
5747: END IF;
5748: x_err_stack := x_err_stack||'->pa_budget_utils.get_baselined_version_id';
5749: -- bug 3163280 ROLLBACK TO copy_project;
5750: RETURN;

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

5750: RETURN;
5751: END IF;
5752: EXCEPTION WHEN OTHERS THEN
5753: x_err_code := 750;
5754: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5755: IF x_err_stage IS NULL
5756: THEN
5757: x_err_stage := 'API: '||'pa_budget_utils.get_baselined_version_id'||
5758: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

5786: IF ( x_err_code < 0 ) THEN -- Oracle error
5787: x_err_code := 755;
5788: IF x_err_stage IS NULL
5789: THEN
5790: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_GET_DRFT_VER_ID');
5791: END IF;
5792: x_err_stack := x_err_stack||'->pa_budget_utils.get_draft_version_id';
5793: -- bug 3163280 ROLLBACK TO copy_project;
5794: RETURN;

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

5794: RETURN;
5795: END IF;
5796: EXCEPTION WHEN OTHERS THEN
5797: x_err_code := 755;
5798: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5799: IF x_err_stage IS NULL
5800: THEN
5801: x_err_stage := 'API: '||'pa_budget_utils.get_draft_version_id'||
5802: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

5831: if ( x_err_code > 0 or x_err_code < 0 ) then
5832: x_err_code := 760;
5833: IF x_err_stage IS NULL
5834: THEN
5835: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_BUDGT_CORE_COPY');
5836: END IF;
5837: x_err_stack := x_err_stack||'->pa_budget_core.copy';
5838: -- bug 3163280 rollback to copy_project;
5839: return; -- Application or Oracle error

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

5839: return; -- Application or Oracle error
5840: end if;
5841: EXCEPTION WHEN OTHERS THEN
5842: x_err_code := 760;
5843: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5844: IF x_err_stage IS NULL
5845: THEN
5846: x_err_stage := 'API: '||'pa_budget_core.copy'||
5847: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

5894: IF ( x_err_code <> 0 ) THEN
5895: x_err_code := 785;
5896: IF x_err_stage IS NULL
5897: THEN
5898: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_SUBMIT_BUDGT');
5899: END IF;
5900: x_err_stack := x_err_stack||'->pa_budget_utils2.submit_budget';
5901: ROLLBACK TO before_bill_baseline;
5902: RETURN; -- Application or Oracle error

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

5902: RETURN; -- Application or Oracle error
5903: END IF;
5904: EXCEPTION WHEN OTHERS THEN
5905: x_err_code := 785;
5906: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5907: IF x_err_stage IS NULL
5908: THEN
5909: x_err_stage := 'API: '||'pa_budget_utils2.submit_budget'||
5910: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);

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

5947: IF ( x_err_code <> 0 ) THEN
5948: x_err_code := 790;
5949: IF x_err_stage IS NULL
5950: THEN
5951: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_REWORK_BUDGT');
5952: END IF;
5953: x_err_stack := x_err_stack||'->pa_budget_utils2.rework_budget';
5954: ROLLBACK TO before_bill_baseline;
5955: RETURN; -- Application or Oracle error

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

5955: RETURN; -- Application or Oracle error
5956: END IF;
5957: EXCEPTION WHEN OTHERS THEN
5958: x_err_code := 790;
5959: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5960: IF x_err_stage IS NULL
5961: THEN
5962: x_err_stage := 'API: '||'pa_budget_utils2.rework_budget'||
5963: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);