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.20 2007/11/28 07:46:11 vgovvala 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 355: pa_fp_gen_budget_amt_pub.gen_rev_bdgt_amt_res_sch_wrp',

351: IF p_pa_debug_mode = 'Y' THEN
352: pa_fp_gen_amount_utils.fp_debug
353: (p_called_mode => p_called_mode,
354: p_msg => 'Before calling
355: pa_fp_gen_budget_amt_pub.gen_rev_bdgt_amt_res_sch_wrp',
356: p_module_name => l_module_name,
357: p_log_level => 5);
358: END IF;
359: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');

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

355: pa_fp_gen_budget_amt_pub.gen_rev_bdgt_amt_res_sch_wrp',
356: p_module_name => l_module_name,
357: p_log_level => 5);
358: END IF;
359: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
360: PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP
361: (P_PROJECT_ID => P_PROJECT_ID,
362: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
363: P_FP_COLS_REC => l_fp_cols_rec,

Line 360: PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP

356: p_module_name => l_module_name,
357: p_log_level => 5);
358: END IF;
359: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
360: PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP
361: (P_PROJECT_ID => P_PROJECT_ID,
362: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
363: P_FP_COLS_REC => l_fp_cols_rec,
364: P_PLAN_CLASS_CODE => l_fp_cols_rec.x_plan_class_code,

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

385: END IF;
386: IF p_pa_debug_mode = 'Y' THEN
387: pa_fp_gen_amount_utils.fp_debug
388: (p_called_mode => p_called_mode,
389: p_msg => 'Status after calling pa_fp_gen_budget_amt_pub.'||
390: 'gen_rev_bdgt_amt_res_sch_wrp:'||x_return_status,
391: p_module_name => l_module_name,
392: p_log_level => 5);
393: END IF;

Line 400: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',

396: IF p_pa_debug_mode = 'Y' THEN
397: pa_fp_gen_amount_utils.fp_debug
398: (p_called_mode => p_called_mode,
399: p_msg => 'Before calling
400: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',
401: p_module_name => l_module_name,
402: p_log_level => 5);
403: END IF;
404: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');

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

400: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',
401: p_module_name => l_module_name,
402: p_log_level => 5);
403: END IF;
404: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');
405: PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH
406: (P_PROJECT_ID => P_PROJECT_ID,
407: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
408: P_FP_COLS_REC => l_fp_cols_rec,

Line 405: PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH

401: p_module_name => l_module_name,
402: p_log_level => 5);
403: END IF;
404: --hr_utility.trace('before PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');
405: PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH
406: (P_PROJECT_ID => P_PROJECT_ID,
407: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
408: P_FP_COLS_REC => l_fp_cols_rec,
409: P_PLAN_CLASS_CODE => l_fp_cols_rec.x_plan_class_code,

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

422: P_INIT_MSG_FLAG => P_INIT_MSG_FLAG,
423: X_RETURN_STATUS => X_RETURN_STATUS,
424: X_MSG_COUNT => X_MSG_COUNT,
425: X_MSG_DATA => X_MSG_DATA);
426: --dbms_output.put_line('after PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH:'||x_return_status);
427: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
428: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
429: END IF;
430: IF p_pa_debug_mode = 'Y' THEN

Line 434: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch: '

430: IF p_pa_debug_mode = 'Y' THEN
431: pa_fp_gen_amount_utils.fp_debug
432: (p_called_mode => p_called_mode,
433: p_msg => 'Status after calling
434: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch: '
435: ||x_return_status,
436: p_module_name => l_module_name,
437: p_log_level => 5);
438: END IF;

Line 455: PA_FP_GEN_BUDGET_AMT_PUB.GEN_WP_REV_BDGT_AMT_WRP

451: pa_fp_wp_gen_budget_amt_pub.generate_wp_budget_amt',
452: p_module_name => l_module_name,
453: p_log_level => 5);
454: END IF;
455: PA_FP_GEN_BUDGET_AMT_PUB.GEN_WP_REV_BDGT_AMT_WRP
456: (P_PROJECT_ID => P_PROJECT_ID,
457: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
458: P_PLAN_CLASS_CODE => l_fp_cols_rec.x_plan_class_code,
459: P_GEN_SRC_CODE => l_fp_cols_rec.x_gen_src_code,

Line 768: pa_fp_gen_budget_amt_pub.reset_cost_amounts',

764: IF p_pa_debug_mode = 'Y' THEN
765: pa_fp_gen_amount_utils.fp_debug
766: (p_called_mode => p_called_mode,
767: p_msg => 'Before calling
768: pa_fp_gen_budget_amt_pub.reset_cost_amounts',
769: p_module_name => l_module_name,
770: p_log_level => 5);
771: END IF;
772: PA_FP_GEN_BUDGET_AMT_PUB.RESET_COST_AMOUNTS

Line 772: PA_FP_GEN_BUDGET_AMT_PUB.RESET_COST_AMOUNTS

768: pa_fp_gen_budget_amt_pub.reset_cost_amounts',
769: p_module_name => l_module_name,
770: p_log_level => 5);
771: END IF;
772: PA_FP_GEN_BUDGET_AMT_PUB.RESET_COST_AMOUNTS
773: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
774: X_RETURN_STATUS => X_RETURN_STATUS,
775: X_MSG_COUNT => X_MSG_COUNT,
776: X_MSG_DATA => X_MSG_DATA);

Line 785: pa_fp_gen_budget_amt_pub.reset_cost_amounts: '

781: IF p_pa_debug_mode = 'Y' THEN
782: pa_fp_gen_amount_utils.fp_debug
783: (p_called_mode => p_called_mode,
784: p_msg => 'Status after calling
785: pa_fp_gen_budget_amt_pub.reset_cost_amounts: '
786: ||x_return_status,
787: p_module_name => l_module_name,
788: p_log_level => 5);
789: END IF;

Line 861: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

857: WHEN OTHERS THEN
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: x_msg_data := SUBSTR(SQLERRM,1,240);
860: FND_MSG_PUB.add_exc_msg
861: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
862: ,p_procedure_name => 'GENERATE_BUDGET_AMT_WRP');
863:
864: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
865: PA_DEBUG.reset_err_stack;

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

920: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
921: X_MSG_COUNT OUT NOCOPY NUMBER,
922: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
923:
924: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH';
925:
926: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
927:
928: CURSOR PROJ_DETAILS IS

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

2062: X_MSG_COUNT := 0;
2063: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2064:
2065: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
2066: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');
2067: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
2068: pa_debug.set_curr_function( p_function => 'GENERATE_BUDGET_AMT_RES_SCH'
2069: ,p_debug_mode => p_pa_debug_mode);
2070: END IF;

Line 2490: pa_fp_gen_budget_amt_pub.create_res_asg',

2486: IF p_pa_debug_mode = 'Y' THEN
2487: pa_fp_gen_amount_utils.fp_debug
2488: (p_called_mode => p_called_mode,
2489: p_msg => 'Before calling
2490: pa_fp_gen_budget_amt_pub.create_res_asg',
2491: p_module_name => l_module_name,
2492: p_log_level => 5);
2493: END IF;
2494:

Line 2495: PA_FP_GEN_BUDGET_AMT_PUB.CREATE_RES_ASG

2491: p_module_name => l_module_name,
2492: p_log_level => 5);
2493: END IF;
2494:
2495: PA_FP_GEN_BUDGET_AMT_PUB.CREATE_RES_ASG
2496: (P_PROJECT_ID => P_PROJECT_ID,
2497: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2498: P_STRU_SHARING_CODE => l_stru_sharing_code,
2499: P_GEN_SRC_CODE => 'RESOURCE_SCHEDULE',

Line 2511: pa_fp_gen_budget_amt_pub.create_res_asg: '

2507: IF p_pa_debug_mode = 'Y' THEN
2508: pa_fp_gen_amount_utils.fp_debug
2509: (p_called_mode => p_called_mode,
2510: p_msg => 'Status after calling
2511: pa_fp_gen_budget_amt_pub.create_res_asg: '
2512: ||x_return_status,
2513: p_module_name => l_module_name,
2514: p_log_level => 5);
2515: END IF;

Line 2523: pa_fp_gen_budget_amt_pub.update_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 => 'Before calling
2523: pa_fp_gen_budget_amt_pub.update_res_asg',
2524: p_module_name => l_module_name,
2525: p_log_level => 5);
2526: END IF;
2527: PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG

Line 2527: PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG

2523: pa_fp_gen_budget_amt_pub.update_res_asg',
2524: p_module_name => l_module_name,
2525: p_log_level => 5);
2526: END IF;
2527: PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG
2528: (P_PROJECT_ID => P_PROJECT_ID,
2529: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2530: P_STRU_SHARING_CODE => l_stru_sharing_code,
2531: P_GEN_SRC_CODE => 'RESOURCE_SCHEDULE',

Line 2543: pa_fp_gen_budget_amt_pub.update_res_asg: '

2539: IF p_pa_debug_mode = 'Y' THEN
2540: pa_fp_gen_amount_utils.fp_debug
2541: (p_called_mode => p_called_mode,
2542: p_msg => 'Status after calling
2543: pa_fp_gen_budget_amt_pub.update_res_asg: '
2544: ||x_return_status,
2545: p_module_name => l_module_name,
2546: p_log_level => 5);
2547: END IF;

Line 4383: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

4379: WHEN OTHERS THEN
4380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4381: x_msg_data := SUBSTR(SQLERRM,1,240);
4382: FND_MSG_PUB.add_exc_msg
4383: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
4384: ,p_procedure_name => 'GENERATE_BUDGET_AMT_RES_SCH');
4385:
4386: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4387: PA_DEBUG.reset_err_stack;

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

4402: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4403: X_MSG_COUNT OUT NOCOPY NUMBER,
4404: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
4405:
4406: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.CREATE_RES_ASG';
4407:
4408: --Cursor used when planning type is Project
4409: CURSOR RES_ASG1 IS
4410: SELECT T.RESOURCE_LIST_MEMBER_ID,

Line 5154: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

5150: x_msg_data := SUBSTR(SQLERRM,1,240);
5151: -- dbms_output.put_line('inside excep create res asg');
5152: -- dbms_output.put_line(SUBSTR(SQLERRM,1,240));
5153: FND_MSG_PUB.add_exc_msg
5154: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5155: ,p_procedure_name => 'CREATE_RES_ASG');
5156:
5157: IF P_PA_DEBUG_MODE = 'Y' THEN
5158: PA_DEBUG.Reset_Curr_Function;

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

5174: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5175: X_MSG_COUNT OUT NOCOPY NUMBER,
5176: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
5177:
5178: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG';
5179:
5180: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
5181:
5182: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 5565: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

5561: WHEN OTHERS THEN
5562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5563: x_msg_data := SUBSTR(SQLERRM,1,240);
5564: FND_MSG_PUB.add_exc_msg
5565: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5566: ,p_procedure_name => 'UPDATE_RES_ASG');
5567: IF P_PA_DEBUG_MODE = 'Y' THEN
5568: PA_DEBUG.Reset_Curr_Function;
5569: END IF;

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

5588: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
5589: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5590: X_MSG_COUNT OUT NOCOPY NUMBER,
5591: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
5592: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.DEL_MANUAL_BDGT_LINES';
5593:
5594: l_del_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5595: l_exist_flag VARCHAR2(1) := 'N';
5596: l_count NUMBER;

Line 5674: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

5670: WHEN OTHERS THEN
5671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5672: x_msg_data := SUBSTR(SQLERRM,1,240);
5673: FND_MSG_PUB.add_exc_msg
5674: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5675: ,p_procedure_name => 'DEL_MANUAL_BDGT_LINES');
5676:
5677: IF P_PA_DEBUG_MODE = 'Y' THEN
5678: PA_DEBUG.Reset_Curr_Function;

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

5689: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5690: X_MSG_COUNT OUT NOCOPY NUMBER,
5691: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
5692:
5693: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_INIT_AMOUNTS';
5694:
5695: BEGIN
5696:
5697: X_MSG_COUNT := 0;

Line 5732: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

5728: WHEN OTHERS THEN
5729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5730: x_msg_data := SUBSTR(SQLERRM,1,240);
5731: FND_MSG_PUB.add_exc_msg
5732: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5733: ,p_procedure_name => 'UPDATE_INIT_AMOUNTS');
5734:
5735: IF P_PA_DEBUG_MODE = 'Y' THEN
5736: PA_DEBUG.Reset_Curr_Function;

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

5749: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5750: X_MSG_COUNT OUT NOCOPY NUMBER,
5751: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
5752:
5753: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_BV_FOR_GEN_DATE';
5754:
5755: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
5756: l_last_update_login NUMBER := FND_GLOBAL.login_id;
5757: l_sysdate DATE := SYSDATE;

Line 5790: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

5786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5787: x_msg_data := SUBSTR(SQLERRM,1,240);
5788: rollback;
5789: FND_MSG_PUB.add_exc_msg
5790: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5791: ,p_procedure_name => 'UPDATE_BV_FOR_GEN_DATE');
5792:
5793: IF P_PA_DEBUG_MODE = 'Y' THEN
5794: PA_DEBUG.Reset_Curr_Function;

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

5805: P_CHK_DUPLICATE_FLAG IN VARCHAR2,
5806: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5807: X_MSG_COUNT OUT NOCOPY NUMBER,
5808: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
5809: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GET_GENERATED_RES_ASG';
5810:
5811: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5812: l_cmt_res_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5813: l_exist_flag VARCHAR2(1);

Line 5867: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

5863: WHEN OTHERS THEN
5864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5865: x_msg_data := SUBSTR(SQLERRM,1,240);
5866: FND_MSG_PUB.add_exc_msg
5867: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
5868: ,p_procedure_name => 'GET_GENERATED_RES_ASG');
5869:
5870: IF P_PA_DEBUG_MODE = 'Y' THEN
5871: PA_DEBUG.Reset_Curr_Function;

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

5896: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5897: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5898: X_MSG_COUNT OUT NOCOPY NUMBER,
5899: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
5900: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.INSERT_TXN_CURRENCY';
5901:
5902: l_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
5903: l_budget_version_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
5904: l_proj_fp_options_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 6087: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

6083: WHEN OTHERS THEN
6084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6085: x_msg_data := SUBSTR(SQLERRM,1,240);
6086: FND_MSG_PUB.add_exc_msg
6087: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6088: ,p_procedure_name => 'INSERT_TXN_CURRENCY');
6089:
6090: IF P_PA_DEBUG_MODE = 'Y' THEN
6091: PA_DEBUG.Reset_Curr_Function;

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

6098: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6099: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6100: X_MSG_COUNT OUT NOCOPY NUMBER,
6101: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6102: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.RESET_COST_AMOUNTS';
6103: BEGIN
6104:
6105: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6106: X_MSG_COUNT := 0;

Line 6139: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

6135: WHEN OTHERS THEN
6136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6137: x_msg_data := SUBSTR(SQLERRM,1,240);
6138: FND_MSG_PUB.add_exc_msg
6139: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6140: ,p_procedure_name => 'RESET_COST_AMOUNTS');
6141:
6142: IF P_PA_DEBUG_MODE = 'Y' THEN
6143: PA_DEBUG.Reset_Curr_Function;

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

6169: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6170: X_MSG_COUNT OUT NOCOPY NUMBER,
6171: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6172:
6173: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP';
6174:
6175: /*local variable for calling get planning rates*/
6176: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6177: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6281: X_MSG_COUNT := 0;
6282: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6283:
6284: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6285: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6286: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6287: pa_debug.set_curr_function( p_function => 'GEN_REV_BDGT_AMT_RES_SCH_WRP',
6288: p_debug_mode => p_pa_debug_mode);
6289: END IF;

Line 6295: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',

6291:
6292: IF p_pa_debug_mode = 'Y' THEN
6293: pa_fp_gen_amount_utils.fp_debug
6294: (p_msg => 'Before calling
6295: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',
6296: p_module_name => l_module_name,
6297: p_log_level => 5);
6298: END IF;
6299: PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH

Line 6299: PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH

6295: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch',
6296: p_module_name => l_module_name,
6297: p_log_level => 5);
6298: END IF;
6299: PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH
6300: (P_PROJECT_ID => P_PROJECT_ID,
6301: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
6302: P_FP_COLS_REC => P_FP_COLS_REC,
6303: P_PLAN_CLASS_CODE => P_PLAN_CLASS_CODE,

Line 6327: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch: '

6323: END IF;
6324: IF p_pa_debug_mode = 'Y' THEN
6325: pa_fp_gen_amount_utils.fp_debug
6326: (p_msg => 'Status after calling
6327: pa_fp_gen_budget_amt_pub.generate_budget_amt_res_sch: '
6328: ||x_return_status,
6329: p_module_name => l_module_name,
6330: p_log_level => 5);
6331: END IF;

Line 6686: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

6682: WHEN OTHERS THEN
6683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6684: x_msg_data := SUBSTR(SQLERRM,1,240);
6685: FND_MSG_PUB.add_exc_msg
6686: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6687: ,p_procedure_name => 'GEN_REV_BDGT_AMT_RES_SCH_WRP');
6688:
6689: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6690: PA_DEBUG.reset_err_stack;

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

6715: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6716: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6717: X_MSG_COUNT OUT NOCOPY NUMBER,
6718: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6719: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_WP_REV_BDGT_AMT_WRP';
6720:
6721: /*local variable for calling get planning rates*/
6722: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6723: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

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

6827: X_MSG_COUNT := 0;
6828: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6829:
6830: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6831: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6832: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
6833: pa_debug.set_curr_function(p_function => 'GEN_WP_REV_BDGT_AMT_WRP',
6834: p_debug_mode => p_pa_debug_mode);
6835: END IF;

Line 7228: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

7224: WHEN OTHERS THEN
7225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7226: x_msg_data := SUBSTR(SQLERRM,1,240);
7227: FND_MSG_PUB.add_exc_msg
7228: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
7229: ,p_procedure_name => 'GEN_WP_REV_BDGT_AMT_WRP');
7230:
7231: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7232: PA_DEBUG.reset_err_stack;

Line 7241: END PA_FP_GEN_BUDGET_AMT_PUB;

7237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7238:
7239: END GEN_WP_REV_BDGT_AMT_WRP;
7240:
7241: END PA_FP_GEN_BUDGET_AMT_PUB;