DBA Data[Home] [Help]

APPS.PA_FP_WP_GEN_BUDGET_AMT_PUB dependencies on PA_FP_WP_GEN_BUDGET_AMT_PUB

Line 1: PACKAGE body PA_FP_WP_GEN_BUDGET_AMT_PUB as

1: PACKAGE body PA_FP_WP_GEN_BUDGET_AMT_PUB as
2: /* $Header: PAFPWPGB.pls 120.13.12010000.3 2009/02/01 08:22:48 jsundara ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: PROCEDURE GENERATE_WP_BUDGET_AMT

Line 31: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_WP_GEN_BUDGET_AMT_PUB.GENERATE_WP_BUDGET_AMT';

27: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
28: X_MSG_COUNT OUT NOCOPY NUMBER,
29: X_MSG_DATA OUT NOCOPY VARCHAR2)
30: IS
31: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_WP_GEN_BUDGET_AMT_PUB.GENERATE_WP_BUDGET_AMT';
32: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
33: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
34: l_wp_ptype_id Number;
35: l_wp_status VARCHAR2(20);

Line 1397: PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES',

1393: IF P_PA_DEBUG_MODE = 'Y' THEN
1394: pa_fp_gen_amount_utils.fp_debug
1395: ( p_called_mode => p_called_mode,
1396: p_msg => 'Before calling
1397: PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES',
1398: p_module_name => l_module_name,
1399: p_log_level => 5 );
1400: END IF;
1401: PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES

Line 1401: PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES

1397: PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES',
1398: p_module_name => l_module_name,
1399: p_log_level => 5 );
1400: END IF;
1401: PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES
1402: ( P_PROJECT_ID => P_PROJECT_ID,
1403: P_SOURCE_BV_ID => l_source_id,
1404: P_TARGET_BV_ID => P_BUDGET_VERSION_ID,
1405: P_CALLING_CONTEXT => l_calling_context,

Line 1415: PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES: '

1411: IF P_PA_DEBUG_MODE = 'Y' THEN
1412: pa_fp_gen_amount_utils.fp_debug
1413: ( p_called_mode => p_called_mode,
1414: p_msg => 'Status after calling
1415: PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES: '
1416: ||x_return_status,
1417: p_module_name => l_module_name,
1418: p_log_level => 5 );
1419: END IF;

Line 2543: 'PA_FP_WP_GEN_BUDGET_AMT_PUB.GET_CALC_API_FLAG_PARAMS',

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 => 'Before calling ' ||
2543: 'PA_FP_WP_GEN_BUDGET_AMT_PUB.GET_CALC_API_FLAG_PARAMS',
2544: p_module_name => l_module_name,
2545: p_log_level => 5 );
2546: END IF;
2547: PA_FP_WP_GEN_BUDGET_AMT_PUB.GET_CALC_API_FLAG_PARAMS

Line 2547: PA_FP_WP_GEN_BUDGET_AMT_PUB.GET_CALC_API_FLAG_PARAMS

2543: 'PA_FP_WP_GEN_BUDGET_AMT_PUB.GET_CALC_API_FLAG_PARAMS',
2544: p_module_name => l_module_name,
2545: p_log_level => 5 );
2546: END IF;
2547: PA_FP_WP_GEN_BUDGET_AMT_PUB.GET_CALC_API_FLAG_PARAMS
2548: ( P_PROJECT_ID => p_project_id,
2549: P_FP_COLS_REC_SOURCE => l_fp_cols_rec_source,
2550: P_FP_COLS_REC_TARGET => l_fp_cols_rec_target,
2551: P_CALLING_CONTEXT => l_calling_context,

Line 2560: 'PA_FP_WP_GEN_BUDGET_AMT_PUB.GET_CALC_API_FLAG_PARAMS: ' ||

2556: IF p_pa_debug_mode = 'Y' THEN
2557: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2558: ( p_called_mode => p_called_mode,
2559: p_msg => 'Status after calling ' ||
2560: 'PA_FP_WP_GEN_BUDGET_AMT_PUB.GET_CALC_API_FLAG_PARAMS: ' ||
2561: x_return_status,
2562: p_module_name => l_module_name,
2563: p_log_level => 5 );
2564: END IF;

Line 2705: ( p_pkg_name => 'PA_FP_WP_GEN_BUDGET_AMT_PUB',

2701: x_msg_count := 1;
2702: x_msg_data := substr(sqlerrm,1,240);
2703: -- dbms_output.put_line('error msg :'||x_msg_data);
2704: FND_MSG_PUB.add_exc_msg
2705: ( p_pkg_name => 'PA_FP_WP_GEN_BUDGET_AMT_PUB',
2706: p_procedure_name => 'GENERATE_WP_BUDGET_AMT',
2707: p_error_text => substr(sqlerrm,1,240));
2708: IF P_PA_DEBUG_MODE = 'Y' THEN
2709: pa_fp_gen_amount_utils.fp_debug

Line 2732: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES';

2728: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2729: X_MSG_COUNT OUT NOCOPY NUMBER,
2730: X_MSG_DATA OUT NOCOPY VARCHAR2)
2731: IS
2732: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES';
2733: l_txn_currency_flag VARCHAR2(1):='Y';
2734:
2735: /* String constants for valid Calling Context values */
2736: lc_BudgetGeneration CONSTANT VARCHAR2(30) := 'BUDGET_GENERATION';

Line 5549: ( p_pkg_name => 'PA_FP_WP_GEN_BUDGET_AMT_PUB',

5545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5546: x_msg_count := 1;
5547: x_msg_data := substr(sqlerrm,1,240);
5548: FND_MSG_PUB.add_exc_msg
5549: ( p_pkg_name => 'PA_FP_WP_GEN_BUDGET_AMT_PUB',
5550: p_procedure_name => 'MAINTAIN_BUDGET_LINES',
5551: p_error_text => substr(sqlerrm,1,240) );
5552:
5553: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 5593: l_module_name VARCHAR2(100) := 'PA.PLSQL.PA_FP_WP_GEN_BUDGET_AMT_PUB.'

5589: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5590: X_MSG_COUNT OUT NOCOPY NUMBER,
5591: X_MSG_DATA OUT NOCOPY VARCHAR2)
5592: IS
5593: l_module_name VARCHAR2(100) := 'PA.PLSQL.PA_FP_WP_GEN_BUDGET_AMT_PUB.'
5594: || 'GET_CALC_API_FLAG_PARAMS';
5595:
5596: l_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;
5597: l_wp_track_cost_flag VARCHAR2(1);

Line 5810: ( p_pkg_name => 'PA_FP_WP_GEN_BUDGET_AMT_PUB',

5806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5807: x_msg_count := 1;
5808: x_msg_data := substr(sqlerrm,1,240);
5809: FND_MSG_PUB.ADD_EXC_MSG
5810: ( p_pkg_name => 'PA_FP_WP_GEN_BUDGET_AMT_PUB',
5811: p_procedure_name => 'GET_CALC_API_FLAG_PARAMS',
5812: p_error_text => substr(sqlerrm,1,240) );
5813:
5814: IF p_pa_debug_mode = 'Y' THEN

Line 5825: END PA_FP_WP_GEN_BUDGET_AMT_PUB;

5821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5822:
5823: END GET_CALC_API_FLAG_PARAMS;
5824:
5825: END PA_FP_WP_GEN_BUDGET_AMT_PUB;