eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_FP_GEN_BUDGET_AMT_PUB

Line 1: PACKAGE body PA_FP_GEN_BUDGET_AMT_PUB as

1: PACKAGE body PA_FP_GEN_BUDGET_AMT_PUB as
2: /* $Header: PAFPGAMB.pls 120.22.12020000.4 2013/05/23 07:35:56 bpottipa ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:

Line 25: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP';

21: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
22: X_MSG_COUNT OUT NOCOPY NUMBER,
23: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
24:
25: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP';
26:
27: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
28: l_ci_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
29: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 65: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP');

61: X_MSG_COUNT := 0;
62: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
63:
64: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
65: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP');
66: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
67: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_WRP'
68: ,p_debug_mode => p_pa_debug_mode);
69: END IF;

Line 367: pa_fp_gen_budget_amt_pub.gen_rev_bdgt_amt_res_sch_wrp',

363: IF p_pa_debug_mode = 'Y' THEN
364: pa_fp_gen_amount_utils.fp_debug
365: (p_called_mode => p_called_mode,
366: p_msg => 'Before calling
367: pa_fp_gen_budget_amt_pub.gen_rev_bdgt_amt_res_sch_wrp',
368: p_module_name => l_module_name,
369: p_log_level => 5);
370: END IF;
371: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');

Line 371: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');

367: pa_fp_gen_budget_amt_pub.gen_rev_bdgt_amt_res_sch_wrp',
368: p_module_name => l_module_name,
369: p_log_level => 5);
370: END IF;
371: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
372: PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP
373: (P_PROJECT_ID => P_PROJECT_ID,
374: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
375: P_FP_COLS_REC => l_fp_cols_rec,

Line 372: PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP

368: p_module_name => l_module_name,
369: p_log_level => 5);
370: END IF;
371: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
372: PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP
373: (P_PROJECT_ID => P_PROJECT_ID,
374: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
375: P_FP_COLS_REC => l_fp_cols_rec,
376: P_PLAN_CLASS_CODE => l_fp_cols_rec.x_plan_class_code,

Line 401: p_msg => 'Status after calling pa_fp_gen_budget_amt_pub.'||

397: END IF;
398: IF p_pa_debug_mode = 'Y' THEN
399: pa_fp_gen_amount_utils.fp_debug
400: (p_called_mode => p_called_mode,
401: p_msg => 'Status after calling pa_fp_gen_budget_amt_pub.'||
402: 'gen_rev_bdgt_amt_res_sch_wrp:'||x_return_status,
403: p_module_name => l_module_name,
404: p_log_level => 5);
405: END IF;

Line 412: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',

408: IF p_pa_debug_mode = 'Y' THEN
409: pa_fp_gen_amount_utils.fp_debug
410: (p_called_mode => p_called_mode,
411: p_msg => 'Before calling
412: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',
413: p_module_name => l_module_name,
414: p_log_level => 5);
415: END IF;
416: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');

Line 416: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');

412: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',
413: p_module_name => l_module_name,
414: p_log_level => 5);
415: END IF;
416: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');
417: PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH
418: (P_PROJECT_ID => P_PROJECT_ID,
419: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
420: P_FP_COLS_REC => l_fp_cols_rec,

Line 417: PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH

413: p_module_name => l_module_name,
414: p_log_level => 5);
415: END IF;
416: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');
417: PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH
418: (P_PROJECT_ID => P_PROJECT_ID,
419: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
420: P_FP_COLS_REC => l_fp_cols_rec,
421: P_PLAN_CLASS_CODE => l_fp_cols_rec.x_plan_class_code,

Line 438: --dbms_output.put_line('after PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH:'||x_return_status);

434: P_INIT_MSG_FLAG => P_INIT_MSG_FLAG,
435: X_RETURN_STATUS => X_RETURN_STATUS,
436: X_MSG_COUNT => X_MSG_COUNT,
437: X_MSG_DATA => X_MSG_DATA);
438: --dbms_output.put_line('after PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH:'||x_return_status);
439: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
440: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
441: END IF;
442: IF p_pa_debug_mode = 'Y' THEN

Line 446: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch: '

442: IF p_pa_debug_mode = 'Y' THEN
443: pa_fp_gen_amount_utils.fp_debug
444: (p_called_mode => p_called_mode,
445: p_msg => 'Status after calling
446: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch: '
447: ||x_return_status,
448: p_module_name => l_module_name,
449: p_log_level => 5);
450: END IF;

Line 467: PA_FP_GEN_BUDGET_AMT_PUB.GEN_WP_REV_BDGT_AMT_WRP

463: pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt',
464: p_module_name => l_module_name,
465: p_log_level => 5);
466: END IF;
467: PA_FP_GEN_BUDGET_AMT_PUB.GEN_WP_REV_BDGT_AMT_WRP
468: (P_PROJECT_ID => P_PROJECT_ID,
469: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
470: P_PLAN_CLASS_CODE => l_fp_cols_rec.x_plan_class_code,
471: P_GEN_SRC_CODE => l_fp_cols_rec.x_gen_src_code,

Line 780: pa_fp_gen_budget_amt_pub.reset_cost_amounts',

776: IF p_pa_debug_mode = 'Y' THEN
777: pa_fp_gen_amount_utils.fp_debug
778: (p_called_mode => p_called_mode,
779: p_msg => 'Before calling
780: pa_fp_gen_budget_amt_pub.reset_cost_amounts',
781: p_module_name => l_module_name,
782: p_log_level => 5);
783: END IF;
784: PA_FP_GEN_BUDGET_AMT_PUB.RESET_COST_AMOUNTS

Line 784: PA_FP_GEN_BUDGET_AMT_PUB.RESET_COST_AMOUNTS

780: pa_fp_gen_budget_amt_pub.reset_cost_amounts',
781: p_module_name => l_module_name,
782: p_log_level => 5);
783: END IF;
784: PA_FP_GEN_BUDGET_AMT_PUB.RESET_COST_AMOUNTS
785: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
786: X_RETURN_STATUS => X_RETURN_STATUS,
787: X_MSG_COUNT => X_MSG_COUNT,
788: X_MSG_DATA => X_MSG_DATA);

Line 797: pa_fp_gen_budget_amt_pub.reset_cost_amounts: '

793: IF p_pa_debug_mode = 'Y' THEN
794: pa_fp_gen_amount_utils.fp_debug
795: (p_called_mode => p_called_mode,
796: p_msg => 'Status after calling
797: pa_fp_gen_budget_amt_pub.reset_cost_amounts: '
798: ||x_return_status,
799: p_module_name => l_module_name,
800: p_log_level => 5);
801: END IF;

Line 873: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

869: WHEN OTHERS THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: x_msg_data := SUBSTR(SQLERRM,1,240);
872: FND_MSG_PUB.add_exc_msg
873: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
874: ,p_procedure_name => 'GENERATE_BUDGET_AMT_WRP');
875:
876: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
877: PA_DEBUG.reset_err_stack;

Line 936: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH';

932: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
933: X_MSG_COUNT OUT NOCOPY NUMBER,
934: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
935:
936: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH';
937:
938: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
939:
940: CURSOR PROJ_DETAILS IS

Line 2078: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');

2074: X_MSG_COUNT := 0;
2075: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2076:
2077: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
2078: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');
2079: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
2080: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_RES_SCH'
2081: ,p_debug_mode => p_pa_debug_mode);
2082: END IF;

Line 2502: pa_fp_gen_budget_amt_pub.create_res_asg',

2498: IF p_pa_debug_mode = 'Y' THEN
2499: pa_fp_gen_amount_utils.fp_debug
2500: (p_called_mode => p_called_mode,
2501: p_msg => 'Before calling
2502: pa_fp_gen_budget_amt_pub.create_res_asg',
2503: p_module_name => l_module_name,
2504: p_log_level => 5);
2505: END IF;
2506:

Line 2507: PA_FP_GEN_BUDGET_AMT_PUB.CREATE_RES_ASG

2503: p_module_name => l_module_name,
2504: p_log_level => 5);
2505: END IF;
2506:
2507: PA_FP_GEN_BUDGET_AMT_PUB.CREATE_RES_ASG
2508: (P_PROJECT_ID => P_PROJECT_ID,
2509: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2510: P_STRU_SHARING_CODE => l_stru_sharing_code,
2511: P_GEN_SRC_CODE => 'RESOURCE_SCHEDULE',

Line 2523: pa_fp_gen_budget_amt_pub.create_res_asg: '

2519: IF p_pa_debug_mode = 'Y' THEN
2520: pa_fp_gen_amount_utils.fp_debug
2521: (p_called_mode => p_called_mode,
2522: p_msg => 'Status after calling
2523: pa_fp_gen_budget_amt_pub.create_res_asg: '
2524: ||x_return_status,
2525: p_module_name => l_module_name,
2526: p_log_level => 5);
2527: END IF;

Line 2535: pa_fp_gen_budget_amt_pub.update_res_asg',

2531: IF p_pa_debug_mode = 'Y' THEN
2532: pa_fp_gen_amount_utils.fp_debug
2533: (p_called_mode => p_called_mode,
2534: p_msg => 'Before calling
2535: pa_fp_gen_budget_amt_pub.update_res_asg',
2536: p_module_name => l_module_name,
2537: p_log_level => 5);
2538: END IF;
2539: PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG

Line 2539: PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG

2535: pa_fp_gen_budget_amt_pub.update_res_asg',
2536: p_module_name => l_module_name,
2537: p_log_level => 5);
2538: END IF;
2539: PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG
2540: (P_PROJECT_ID => P_PROJECT_ID,
2541: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2542: P_STRU_SHARING_CODE => l_stru_sharing_code,
2543: P_GEN_SRC_CODE => 'RESOURCE_SCHEDULE',

Line 2555: pa_fp_gen_budget_amt_pub.update_res_asg: '

2551: IF p_pa_debug_mode = 'Y' THEN
2552: pa_fp_gen_amount_utils.fp_debug
2553: (p_called_mode => p_called_mode,
2554: p_msg => 'Status after calling
2555: pa_fp_gen_budget_amt_pub.update_res_asg: '
2556: ||x_return_status,
2557: p_module_name => l_module_name,
2558: p_log_level => 5);
2559: END IF;

Line 4395: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

4391: WHEN OTHERS THEN
4392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4393: x_msg_data := SUBSTR(SQLERRM,1,240);
4394: FND_MSG_PUB.add_exc_msg
4395: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
4396: ,p_procedure_name => 'GENERATE_BUDGET_AMT_RES_SCH');
4397:
4398: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4399: PA_DEBUG.reset_err_stack;

Line 4418: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.CREATE_RES_ASG';

4414: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4415: X_MSG_COUNT OUT NOCOPY NUMBER,
4416: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
4417:
4418: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.CREATE_RES_ASG';
4419:
4420: --Cursor used when planning type is Project
4421: CURSOR RES_ASG1 IS
4422: SELECT T.RESOURCE_LIST_MEMBER_ID,

Line 5786: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

5782: x_msg_data := SUBSTR(SQLERRM,1,240);
5783: -- dbms_output.put_line('inside excep create res asg');
5784: -- dbms_output.put_line(SUBSTR(SQLERRM,1,240));
5785: FND_MSG_PUB.add_exc_msg
5786: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5787: ,p_procedure_name => 'CREATE_RES_ASG');
5788:
5789: IF P_PA_DEBUG_MODE = 'Y' THEN
5790: PA_DEBUG.Reset_Curr_Function;

Line 5810: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG';

5806: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5807: X_MSG_COUNT OUT NOCOPY NUMBER,
5808: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
5809:
5810: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG';
5811:
5812: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
5813:
5814: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6222: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

6218: WHEN OTHERS THEN
6219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6220: x_msg_data := SUBSTR(SQLERRM,1,240);
6221: FND_MSG_PUB.add_exc_msg
6222: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6223: ,p_procedure_name => 'UPDATE_RES_ASG');
6224: IF P_PA_DEBUG_MODE = 'Y' THEN
6225: PA_DEBUG.Reset_Curr_Function;
6226: END IF;

Line 6249: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.DEL_MANUAL_BDGT_LINES';

6245: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6246: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6247: X_MSG_COUNT OUT NOCOPY NUMBER,
6248: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6249: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.DEL_MANUAL_BDGT_LINES';
6250:
6251: l_del_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6252: l_exist_flag VARCHAR2(1) := 'N';
6253: l_count NUMBER;

Line 6331: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

6327: WHEN OTHERS THEN
6328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6329: x_msg_data := SUBSTR(SQLERRM,1,240);
6330: FND_MSG_PUB.add_exc_msg
6331: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6332: ,p_procedure_name => 'DEL_MANUAL_BDGT_LINES');
6333:
6334: IF P_PA_DEBUG_MODE = 'Y' THEN
6335: PA_DEBUG.Reset_Curr_Function;

Line 6350: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_INIT_AMOUNTS';

6346: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6347: X_MSG_COUNT OUT NOCOPY NUMBER,
6348: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6349:
6350: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_INIT_AMOUNTS';
6351:
6352: BEGIN
6353:
6354: X_MSG_COUNT := 0;

Line 6389: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

6385: WHEN OTHERS THEN
6386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6387: x_msg_data := SUBSTR(SQLERRM,1,240);
6388: FND_MSG_PUB.add_exc_msg
6389: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6390: ,p_procedure_name => 'UPDATE_INIT_AMOUNTS');
6391:
6392: IF P_PA_DEBUG_MODE = 'Y' THEN
6393: PA_DEBUG.Reset_Curr_Function;

Line 6410: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_BV_FOR_GEN_DATE';

6406: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6407: X_MSG_COUNT OUT NOCOPY NUMBER,
6408: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6409:
6410: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_BV_FOR_GEN_DATE';
6411:
6412: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
6413: l_last_update_login NUMBER := FND_GLOBAL.login_id;
6414: l_sysdate DATE := SYSDATE;

Line 6447: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

6443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6444: x_msg_data := SUBSTR(SQLERRM,1,240);
6445: rollback;
6446: FND_MSG_PUB.add_exc_msg
6447: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6448: ,p_procedure_name => 'UPDATE_BV_FOR_GEN_DATE');
6449:
6450: IF P_PA_DEBUG_MODE = 'Y' THEN
6451: PA_DEBUG.Reset_Curr_Function;

Line 6466: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GET_GENERATED_RES_ASG';

6462: P_CHK_DUPLICATE_FLAG IN VARCHAR2,
6463: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6464: X_MSG_COUNT OUT NOCOPY NUMBER,
6465: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6466: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GET_GENERATED_RES_ASG';
6467:
6468: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6469: l_cmt_res_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6470: l_exist_flag VARCHAR2(1);

Line 6524: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

6520: WHEN OTHERS THEN
6521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6522: x_msg_data := SUBSTR(SQLERRM,1,240);
6523: FND_MSG_PUB.add_exc_msg
6524: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6525: ,p_procedure_name => 'GET_GENERATED_RES_ASG');
6526:
6527: IF P_PA_DEBUG_MODE = 'Y' THEN
6528: PA_DEBUG.Reset_Curr_Function;

Line 6557: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.INSERT_TXN_CURRENCY';

6553: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
6554: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6555: X_MSG_COUNT OUT NOCOPY NUMBER,
6556: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6557: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.INSERT_TXN_CURRENCY';
6558:
6559: l_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
6560: l_budget_version_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6561: l_proj_fp_options_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 6744: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

6740: WHEN OTHERS THEN
6741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6742: x_msg_data := SUBSTR(SQLERRM,1,240);
6743: FND_MSG_PUB.add_exc_msg
6744: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6745: ,p_procedure_name => 'INSERT_TXN_CURRENCY');
6746:
6747: IF P_PA_DEBUG_MODE = 'Y' THEN
6748: PA_DEBUG.Reset_Curr_Function;

Line 6759: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.RESET_COST_AMOUNTS';

6755: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6756: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6757: X_MSG_COUNT OUT NOCOPY NUMBER,
6758: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6759: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.RESET_COST_AMOUNTS';
6760: BEGIN
6761:
6762: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6763: X_MSG_COUNT := 0;

Line 6796: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

6792: WHEN OTHERS THEN
6793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6794: x_msg_data := SUBSTR(SQLERRM,1,240);
6795: FND_MSG_PUB.add_exc_msg
6796: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6797: ,p_procedure_name => 'RESET_COST_AMOUNTS');
6798:
6799: IF P_PA_DEBUG_MODE = 'Y' THEN
6800: PA_DEBUG.Reset_Curr_Function;

Line 6830: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP';

6826: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6827: X_MSG_COUNT OUT NOCOPY NUMBER,
6828: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6829:
6830: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP';
6831:
6832: /*local variable for calling get planning rates*/
6833: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6834: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 6942: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');

6938: X_MSG_COUNT := 0;
6939: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6940:
6941: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6942: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6943: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6944: pa_debug.set_curr_function( p_function => 'GEN_REV_BDGT_AMT_RES_SCH_WRP',
6945: p_debug_mode => p_pa_debug_mode);
6946: END IF;

Line 6952: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',

6948:
6949: IF p_pa_debug_mode = 'Y' THEN
6950: pa_fp_gen_amount_utils.fp_debug
6951: (p_msg => 'Before calling
6952: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',
6953: p_module_name => l_module_name,
6954: p_log_level => 5);
6955: END IF;
6956: PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH

Line 6956: PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH

6952: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',
6953: p_module_name => l_module_name,
6954: p_log_level => 5);
6955: END IF;
6956: PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH
6957: (P_PROJECT_ID => P_PROJECT_ID,
6958: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
6959: P_FP_COLS_REC => P_FP_COLS_REC,
6960: P_PLAN_CLASS_CODE => P_PLAN_CLASS_CODE,

Line 6984: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch: '

6980: END IF;
6981: IF p_pa_debug_mode = 'Y' THEN
6982: pa_fp_gen_amount_utils.fp_debug
6983: (p_msg => 'Status after calling
6984: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch: '
6985: ||x_return_status,
6986: p_module_name => l_module_name,
6987: p_log_level => 5);
6988: END IF;

Line 7343: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

7339: WHEN OTHERS THEN
7340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7341: x_msg_data := SUBSTR(SQLERRM,1,240);
7342: FND_MSG_PUB.add_exc_msg
7343: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
7344: ,p_procedure_name => 'GEN_REV_BDGT_AMT_RES_SCH_WRP');
7345:
7346: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7347: PA_DEBUG.reset_err_stack;

Line 7376: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_WP_REV_BDGT_AMT_WRP';

7372: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
7373: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7374: X_MSG_COUNT OUT NOCOPY NUMBER,
7375: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
7376: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_WP_REV_BDGT_AMT_WRP';
7377:
7378: /*local variable for calling get planning rates*/
7379: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7380: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 7488: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');

7484: X_MSG_COUNT := 0;
7485: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
7486:
7487: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7488: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
7489: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7490: pa_debug.set_curr_function(p_function => 'GEN_WP_REV_BDGT_AMT_WRP',
7491: p_debug_mode => p_pa_debug_mode);
7492: END IF;

Line 7885: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

7881: WHEN OTHERS THEN
7882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7883: x_msg_data := SUBSTR(SQLERRM,1,240);
7884: FND_MSG_PUB.add_exc_msg
7885: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
7886: ,p_procedure_name => 'GEN_WP_REV_BDGT_AMT_WRP');
7887:
7888: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7889: PA_DEBUG.reset_err_stack;

Line 7898: END PA_FP_GEN_BUDGET_AMT_PUB;

7894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7895:
7896: END GEN_WP_REV_BDGT_AMT_WRP;
7897:
7898: END PA_FP_GEN_BUDGET_AMT_PUB;