DBA Data[Home] [Help]

APPS.PA_BUDGET_PUB dependencies on PA_BUDGET_UTILS

Line 45: --Called subprograms: PA_BUDGET_UTILS.create_draft

41: --Type: Procedure
42: --Description: This procedure can be used to create a draft budget with budget lines
43: --
44: --
45: --Called subprograms: PA_BUDGET_UTILS.create_draft
46: -- pa_budget_pvt.insert_budget_line
47: -- pa_budget_lines_v_pkg.check_overlapping_dates
48: -- PA_BUDGET_UTILS.summerize_project_totals
49: -- PA_BUDGET_FUND_PKG.get_budget_ctrl_options

Line 48: -- PA_BUDGET_UTILS.summerize_project_totals

44: --
45: --Called subprograms: PA_BUDGET_UTILS.create_draft
46: -- pa_budget_pvt.insert_budget_line
47: -- pa_budget_lines_v_pkg.check_overlapping_dates
48: -- PA_BUDGET_UTILS.summerize_project_totals
49: -- PA_BUDGET_FUND_PKG.get_budget_ctrl_options
50: --
51: --
52: --

Line 817: PA_BUDGET_UTILS.create_draft

813:
814: /* It is assumed that if the program reaches till this point,then there are no budget lines with errors in the out plsql table*/
815:
816: --Call the api that creates the draft budget
817: PA_BUDGET_UTILS.create_draft
818: (x_project_id => l_project_id
819: ,x_budget_type_code => p_budget_type_code
820: ,x_version_name => l_budget_version_name
821: ,x_description => l_description

Line 901: ( p_pkg_name => 'PA_BUDGET_UTILS'

897: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
898: THEN
899:
900: FND_MSG_PUB.add_exc_msg
901: ( p_pkg_name => 'PA_BUDGET_UTILS'
902: , p_procedure_name => 'CREATE_DRAFT'
903: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
904:
905: END IF;

Line 925: -- INTO l_budget_version_id --PA_BUDGET_UTILS.create_draft returns nothing: BUG.

921:
922: -- Commenting out this select as the create draft now returns the id of hte
923: -- newly created version
924: -- SELECT pa_budget_versions_s.currval --because x_budget_version_id in procedure
925: -- INTO l_budget_version_id --PA_BUDGET_UTILS.create_draft returns nothing: BUG.
926: -- FROM SYS.DUAL;
927:
928: IF l_debug_mode = 'Y' THEN
929: pa_debug.g_err_stage := 'Created version is is '|| l_budget_version_id ;

Line 2295: pa_budget_utils.summerize_project_totals( x_budget_version_id => l_budget_version_id

2291: pa_debug.g_err_stage := 'About to summarize totals in budget model';
2292: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2293: END IF;
2294:
2295: pa_budget_utils.summerize_project_totals( x_budget_version_id => l_budget_version_id
2296: , x_err_code => l_err_code
2297: , x_err_stage => l_err_stage
2298: , x_err_stack => l_err_stack );
2299:

Line 2349: ( p_pkg_name => 'PA_BUDGET_UTILS'

2345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2346: THEN
2347:
2348: FND_MSG_PUB.add_exc_msg
2349: ( p_pkg_name => 'PA_BUDGET_UTILS'
2350: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
2351: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
2352:
2353: END IF;

Line 4467: PA_BUDGET_UTILS.VERIFY_BUDGET_RULES

4463:
4464: /* -- dbms_output.put_line('Verify Budget Rules - SUBMIT'); */
4465:
4466:
4467: PA_BUDGET_UTILS.VERIFY_BUDGET_RULES
4468: (p_draft_version_id => l_curr_working_version_id
4469: , p_mark_as_original => l_mark_as_original
4470: , p_event => 'SUBMIT'
4471: , p_project_id => l_project_id

Line 4510: PA_BUDGET_UTILS.VERIFY_BUDGET_RULES

4506: --
4507: -- BASELINE RULES -------------------------------------------------------------
4508: --
4509:
4510: PA_BUDGET_UTILS.VERIFY_BUDGET_RULES
4511: (p_draft_version_id => l_curr_working_version_id
4512: , p_mark_as_original => l_mark_as_original
4513: , p_event => 'BASELINE'
4514: , p_project_id => l_project_id

Line 5106: -- PA_BUDGET_UTILS.summerize_project_totals

5102: --
5103: --Called subprograms:
5104: -- pa_budget_pvt.insert_budget_line
5105: -- pa_budget_lines_v_pkg.check_overlapping_dates
5106: -- PA_BUDGET_UTILS.summerize_project_totals
5107: --
5108: --
5109: --
5110: --History:

Line 5478: PA_BUDGET_UTILS.summerize_project_totals

5474: END IF;
5475:
5476:
5477: --summarizing the totals in the table pa_budget_versions
5478: PA_BUDGET_UTILS.summerize_project_totals
5479: ( x_budget_version_id => l_budget_version_id
5480: , x_err_code => l_err_code
5481: , x_err_stage => l_err_stage
5482: , x_err_stack => l_err_stack );

Line 5531: ( p_pkg_name => 'PA_BUDGET_UTILS'

5527:
5528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5529: THEN
5530: FND_MSG_PUB.add_exc_msg
5531: ( p_pkg_name => 'PA_BUDGET_UTILS'
5532: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
5533: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
5534: END IF;
5535:

Line 6601: PA_BUDGET_UTILS.delete_draft( x_budget_version_id => l_budget_version_id

6597: l_any_error_occurred_flag := 'Y';
6598: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6599: END IF;
6600:
6601: PA_BUDGET_UTILS.delete_draft( x_budget_version_id => l_budget_version_id
6602: ,x_err_code => l_err_code
6603: ,x_err_stage => l_err_stage
6604: ,x_err_stack => l_err_stack );
6605:

Line 6662: ( p_pkg_name => 'PA_BUDGET_UTILS'

6658: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
6659: END IF;
6660:
6661: FND_MSG_PUB.add_exc_msg
6662: ( p_pkg_name => 'PA_BUDGET_UTILS'
6663: , p_procedure_name => 'DELETE_DRAFT'
6664: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
6665:
6666: END IF;

Line 7117: -- PA_BUDGET_UTILS.delete_draft

7113: --Called subprograms:
7114: -- FND_API.compatible_api_call
7115: -- PA_PROJECT_PVT.convert_pm_projref_to_id
7116: -- PA_PM_FUNCTION_SECURITY_PUB.check_budget_security
7117: -- PA_BUDGET_UTILS.delete_draft
7118: -- PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
7119: -- PA_FIN_PLAN_UTILS.get_version_type
7120: -- PA_FIN_PLAN_UTILS.is_orgforecast_plan
7121: -- PA_FIN_PLAN_UTILS.retrieve_record_version_number

Line 7627: PA_BUDGET_UTILS.delete_draft( x_budget_version_id => l_budget_version_no_rec.budget_version_id

7623: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7624: END IF;
7625:
7626: --Calling delete API
7627: PA_BUDGET_UTILS.delete_draft( x_budget_version_id => l_budget_version_no_rec.budget_version_id
7628: ,x_err_code => l_err_code
7629: ,x_err_stage => l_err_stage
7630: ,x_err_stack => l_err_stack );
7631:

Line 7639: pa_debug.g_err_stage := 'PA_BUDGET_UTILS.DELETE_DRAFT falied';

7635: THEN
7636: IF NOT PA_PROJECT_PVT.check_valid_message(l_err_stage)
7637: THEN
7638: IF(l_debug_mode='Y') THEN
7639: pa_debug.g_err_stage := 'PA_BUDGET_UTILS.DELETE_DRAFT falied';
7640: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
7641: END IF;
7642: PA_INTERFACE_UTILS_PUB.map_new_amg_msg
7643: ( p_old_message_code => 'PA_DELETE_DRAFT_FAILED'

Line 7684: ( p_pkg_name => 'PA_BUDGET_UTILS'

7680: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
7681: END IF;
7682:
7683: FND_MSG_PUB.add_exc_msg
7684: ( p_pkg_name => 'PA_BUDGET_UTILS'
7685: , p_procedure_name => 'DELETE_DRAFT'
7686: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
7687: END IF; --FND_MSG_PUB.check_msg_level
7688:

Line 8840: PA_BUDGET_UTILS.summerize_project_totals( x_budget_version_id => l_budget_version_id

8836:
8837: IF l_budget_type_code IS NOT NULL --old budgets model
8838: THEN
8839: --summarizing the totals in the table pa_budget_versions
8840: PA_BUDGET_UTILS.summerize_project_totals( x_budget_version_id => l_budget_version_id
8841: , x_err_code => l_err_code
8842: , x_err_stage => l_err_stage
8843: , x_err_stack => l_err_stack );
8844:

Line 8887: ( p_pkg_name => 'PA_BUDGET_UTILS'

8883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8884: THEN
8885:
8886: FND_MSG_PUB.add_exc_msg
8887: ( p_pkg_name => 'PA_BUDGET_UTILS'
8888: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
8889: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
8890:
8891: END IF;

Line 12688: PA_BUDGET_UTILS.summerize_project_totals( x_budget_version_id => l_budget_version_id

12684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12685: END IF;
12686:
12687:
12688: PA_BUDGET_UTILS.summerize_project_totals( x_budget_version_id => l_budget_version_id
12689: , x_err_code => l_err_code
12690: , x_err_stage => l_err_stage
12691: , x_err_stack => l_err_stack );
12692:

Line 12723: ( p_pkg_name => 'PA_BUDGET_UTILS'

12719: RAISE FND_API.G_EXC_ERROR;
12720: ELSIF l_err_code < 0 THEN
12721: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12722: FND_MSG_PUB.add_exc_msg
12723: ( p_pkg_name => 'PA_BUDGET_UTILS'
12724: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
12725: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
12726:
12727: END IF;

Line 13918: PA_BUDGET_UTILS.summerize_project_totals

13914: RAISE FND_API.G_EXC_ERROR;
13915: END IF;
13916:
13917: --summarizing the totals in the table pa_budget_versions
13918: PA_BUDGET_UTILS.summerize_project_totals
13919: (x_budget_version_id => l_budget_version_id
13920: ,x_err_code => l_err_code
13921: ,x_err_stage => l_err_stage
13922: ,x_err_stack => l_err_stack );

Line 13972: ( p_pkg_name => 'PA_BUDGET_UTILS'

13968:
13969: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13970: THEN
13971: FND_MSG_PUB.add_exc_msg
13972: ( p_pkg_name => 'PA_BUDGET_UTILS'
13973: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
13974: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
13975: END IF;
13976:

Line 16524: PA_BUDGET_UTILS.summerize_project_totals

16520: END IF;
16521: */
16522: --Summarizing the totals in the table pa_budget_versions
16523:
16524: PA_BUDGET_UTILS.summerize_project_totals
16525: (x_budget_version_id => l_budget_version_id,
16526: x_err_code => l_err_code,
16527: x_err_stage => l_err_stage,
16528: x_err_stack => l_err_stack);

Line 16577: ( p_pkg_name => 'PA_BUDGET_UTILS'

16573: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16574: THEN
16575:
16576: FND_MSG_PUB.add_exc_msg
16577: ( p_pkg_name => 'PA_BUDGET_UTILS'
16578: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
16579: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
16580:
16581: END IF;