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 815: PA_BUDGET_UTILS.create_draft

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

Line 899: ( p_pkg_name => 'PA_BUDGET_UTILS'

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

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

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

Line 2269: pa_budget_utils.summerize_project_totals( x_budget_version_id => l_budget_version_id

2265: pa_debug.g_err_stage := 'About to summarize totals in budget model';
2266: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2267: END IF;
2268:
2269: pa_budget_utils.summerize_project_totals( x_budget_version_id => l_budget_version_id
2270: , x_err_code => l_err_code
2271: , x_err_stage => l_err_stage
2272: , x_err_stack => l_err_stack );
2273:

Line 2323: ( p_pkg_name => 'PA_BUDGET_UTILS'

2319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2320: THEN
2321:
2322: FND_MSG_PUB.add_exc_msg
2323: ( p_pkg_name => 'PA_BUDGET_UTILS'
2324: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
2325: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
2326:
2327: END IF;

Line 4361: PA_BUDGET_UTILS.VERIFY_BUDGET_RULES

4357:
4358: /* -- dbms_output.put_line('Verify Budget Rules - SUBMIT'); */
4359:
4360:
4361: PA_BUDGET_UTILS.VERIFY_BUDGET_RULES
4362: (p_draft_version_id => l_curr_working_version_id
4363: , p_mark_as_original => l_mark_as_original
4364: , p_event => 'SUBMIT'
4365: , p_project_id => l_project_id

Line 4404: PA_BUDGET_UTILS.VERIFY_BUDGET_RULES

4400: --
4401: -- BASELINE RULES -------------------------------------------------------------
4402: --
4403:
4404: PA_BUDGET_UTILS.VERIFY_BUDGET_RULES
4405: (p_draft_version_id => l_curr_working_version_id
4406: , p_mark_as_original => l_mark_as_original
4407: , p_event => 'BASELINE'
4408: , p_project_id => l_project_id

Line 5000: -- PA_BUDGET_UTILS.summerize_project_totals

4996: --
4997: --Called subprograms:
4998: -- pa_budget_pvt.insert_budget_line
4999: -- pa_budget_lines_v_pkg.check_overlapping_dates
5000: -- PA_BUDGET_UTILS.summerize_project_totals
5001: --
5002: --
5003: --
5004: --History:

Line 5341: PA_BUDGET_UTILS.summerize_project_totals

5337: END IF;
5338:
5339:
5340: --summarizing the totals in the table pa_budget_versions
5341: PA_BUDGET_UTILS.summerize_project_totals
5342: ( x_budget_version_id => l_budget_version_id
5343: , x_err_code => l_err_code
5344: , x_err_stage => l_err_stage
5345: , x_err_stack => l_err_stack );

Line 5394: ( p_pkg_name => 'PA_BUDGET_UTILS'

5390:
5391: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5392: THEN
5393: FND_MSG_PUB.add_exc_msg
5394: ( p_pkg_name => 'PA_BUDGET_UTILS'
5395: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
5396: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
5397: END IF;
5398:

Line 6449: PA_BUDGET_UTILS.delete_draft( x_budget_version_id => l_budget_version_id

6445: l_any_error_occurred_flag := 'Y';
6446: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6447: END IF;
6448:
6449: PA_BUDGET_UTILS.delete_draft( x_budget_version_id => l_budget_version_id
6450: ,x_err_code => l_err_code
6451: ,x_err_stage => l_err_stage
6452: ,x_err_stack => l_err_stack );
6453:

Line 6510: ( p_pkg_name => 'PA_BUDGET_UTILS'

6506: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
6507: END IF;
6508:
6509: FND_MSG_PUB.add_exc_msg
6510: ( p_pkg_name => 'PA_BUDGET_UTILS'
6511: , p_procedure_name => 'DELETE_DRAFT'
6512: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
6513:
6514: END IF;

Line 6965: -- PA_BUDGET_UTILS.delete_draft

6961: --Called subprograms:
6962: -- FND_API.compatible_api_call
6963: -- PA_PROJECT_PVT.convert_pm_projref_to_id
6964: -- PA_PM_FUNCTION_SECURITY_PUB.check_budget_security
6965: -- PA_BUDGET_UTILS.delete_draft
6966: -- PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
6967: -- PA_FIN_PLAN_UTILS.get_version_type
6968: -- PA_FIN_PLAN_UTILS.is_orgforecast_plan
6969: -- PA_FIN_PLAN_UTILS.retrieve_record_version_number

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

7469: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7470: END IF;
7471:
7472: --Calling delete API
7473: PA_BUDGET_UTILS.delete_draft( x_budget_version_id => l_budget_version_no_rec.budget_version_id
7474: ,x_err_code => l_err_code
7475: ,x_err_stage => l_err_stage
7476: ,x_err_stack => l_err_stack );
7477:

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

7481: THEN
7482: IF NOT PA_PROJECT_PVT.check_valid_message(l_err_stage)
7483: THEN
7484: IF(l_debug_mode='Y') THEN
7485: pa_debug.g_err_stage := 'PA_BUDGET_UTILS.DELETE_DRAFT falied';
7486: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
7487: END IF;
7488: PA_INTERFACE_UTILS_PUB.map_new_amg_msg
7489: ( p_old_message_code => 'PA_DELETE_DRAFT_FAILED'

Line 7530: ( p_pkg_name => 'PA_BUDGET_UTILS'

7526: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
7527: END IF;
7528:
7529: FND_MSG_PUB.add_exc_msg
7530: ( p_pkg_name => 'PA_BUDGET_UTILS'
7531: , p_procedure_name => 'DELETE_DRAFT'
7532: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
7533: END IF; --FND_MSG_PUB.check_msg_level
7534:

Line 8661: PA_BUDGET_UTILS.summerize_project_totals( x_budget_version_id => l_budget_version_id

8657:
8658: IF l_budget_type_code IS NOT NULL --old budgets model
8659: THEN
8660: --summarizing the totals in the table pa_budget_versions
8661: PA_BUDGET_UTILS.summerize_project_totals( x_budget_version_id => l_budget_version_id
8662: , x_err_code => l_err_code
8663: , x_err_stage => l_err_stage
8664: , x_err_stack => l_err_stack );
8665:

Line 8708: ( p_pkg_name => 'PA_BUDGET_UTILS'

8704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8705: THEN
8706:
8707: FND_MSG_PUB.add_exc_msg
8708: ( p_pkg_name => 'PA_BUDGET_UTILS'
8709: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
8710: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
8711:
8712: END IF;

Line 12471: PA_BUDGET_UTILS.summerize_project_totals( x_budget_version_id => l_budget_version_id

12467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12468: END IF;
12469:
12470:
12471: PA_BUDGET_UTILS.summerize_project_totals( x_budget_version_id => l_budget_version_id
12472: , x_err_code => l_err_code
12473: , x_err_stage => l_err_stage
12474: , x_err_stack => l_err_stack );
12475:

Line 12506: ( p_pkg_name => 'PA_BUDGET_UTILS'

12502: RAISE FND_API.G_EXC_ERROR;
12503: ELSIF l_err_code < 0 THEN
12504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12505: FND_MSG_PUB.add_exc_msg
12506: ( p_pkg_name => 'PA_BUDGET_UTILS'
12507: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
12508: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
12509:
12510: END IF;

Line 13673: PA_BUDGET_UTILS.summerize_project_totals

13669: RAISE FND_API.G_EXC_ERROR;
13670: END IF;
13671:
13672: --summarizing the totals in the table pa_budget_versions
13673: PA_BUDGET_UTILS.summerize_project_totals
13674: (x_budget_version_id => l_budget_version_id
13675: ,x_err_code => l_err_code
13676: ,x_err_stage => l_err_stage
13677: ,x_err_stack => l_err_stack );

Line 13727: ( p_pkg_name => 'PA_BUDGET_UTILS'

13723:
13724: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13725: THEN
13726: FND_MSG_PUB.add_exc_msg
13727: ( p_pkg_name => 'PA_BUDGET_UTILS'
13728: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
13729: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
13730: END IF;
13731:

Line 16275: PA_BUDGET_UTILS.summerize_project_totals

16271: END IF;
16272: */
16273: --Summarizing the totals in the table pa_budget_versions
16274:
16275: PA_BUDGET_UTILS.summerize_project_totals
16276: (x_budget_version_id => l_budget_version_id,
16277: x_err_code => l_err_code,
16278: x_err_stage => l_err_stage,
16279: x_err_stack => l_err_stack);

Line 16328: ( p_pkg_name => 'PA_BUDGET_UTILS'

16324: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16325: THEN
16326:
16327: FND_MSG_PUB.add_exc_msg
16328: ( p_pkg_name => 'PA_BUDGET_UTILS'
16329: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
16330: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
16331:
16332: END IF;