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_COPY_FROM_PKG dependencies on PA_FP_COPY_FROM_PKG

Line 1: PACKAGE BODY pa_fp_copy_from_pkg AS

1: PACKAGE BODY pa_fp_copy_from_pkg AS
2: /* $Header: PAFPCPFB.pls 120.27.12020000.2 2013/03/27 05:16:35 bpottipa ship $*/
3:
4: g_plsql_max_array_size NUMBER := 200;
5: g_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_from_pkg';

Line 5: g_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_from_pkg';

1: PACKAGE BODY pa_fp_copy_from_pkg AS
2: /* $Header: PAFPCPFB.pls 120.27.12020000.2 2013/03/27 05:16:35 bpottipa ship $*/
3:
4: g_plsql_max_array_size NUMBER := 200;
5: g_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_from_pkg';
6:
7: -- Bug Fix: 4569365. Removed MRC code.
8: -- g_mrc_exception EXCEPTION;
9:

Line 215: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

211:
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: x_msg_count := 1;
214: x_msg_data := SQLERRM;
215: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
216: ,p_procedure_name => 'ACQUIRE_LOCKS_FOR_COPY_PLAN');
217: IF P_PA_DEBUG_MODE = 'Y' THEN
218: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
219: pa_debug.write('Acquire_Locks_For_Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,5);

Line 364: pa_debug.init_err_stack('PA_FP_COPY_FROM_PKG.Copy_Plan');

360: x_msg_count := 0;
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362:
363: IF P_PA_DEBUG_MODE = 'Y' THEN
364: pa_debug.init_err_stack('PA_FP_COPY_FROM_PKG.Copy_Plan');
365: END IF;
366: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
367: l_debug_mode := NVL(l_debug_mode, 'Y');
368: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 770: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

766: WHEN Others THEN
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: x_msg_count := 1;
769: x_msg_data := SQLERRM;
770: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
771: ,p_procedure_name => 'COPY_PLAN');
772: IF P_PA_DEBUG_MODE = 'Y' THEN
773: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
774: pa_debug.write('Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,5);

Line 837: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Acquire_Lock_For_Copy_Actual');

833: x_msg_count := 0;
834: x_return_status := FND_API.G_RET_STS_SUCCESS;
835:
836: IF P_PA_DEBUG_MODE = 'Y' THEN
837: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Acquire_Lock_For_Copy_Actual');
838: END IF;
839: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
840: l_debug_mode := NVL(l_debug_mode, 'Y');
841:

Line 936: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

932: WHEN Others THEN
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: x_msg_count := 1;
935: x_msg_data := SQLERRM;
936: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
937: ,p_procedure_name => 'ACQUIRE_LOCKS_FOR_COPY_ACTUAL');
938:
939: IF P_PA_DEBUG_MODE = 'Y' THEN
940: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 1149: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Version');

1145:
1146: x_msg_count := 0;
1147: x_return_status := FND_API.G_RET_STS_SUCCESS;
1148: IF p_pa_debug_mode = 'Y' THEN
1149: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Version');
1150: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1151: l_debug_mode := NVL(l_debug_mode, 'Y');
1152: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
1153: END IF;

Line 1862: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_COPY_FROM_PKG'

1858: WHEN Others THEN
1859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1860: x_msg_count := 1;
1861: x_msg_data := SQLERRM;
1862: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_COPY_FROM_PKG'
1863: ,p_procedure_name => 'COPY_BUDGET_VERSION');
1864:
1865: IF P_PA_DEBUG_MODE = 'Y' THEN
1866: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 1953: p_function =>'pa_fp_copy_from_pkg.create_res_task_maps'

1949:
1950: -- Set curr function
1951: IF l_debug_mode = 'Y' THEN
1952: pa_debug.set_curr_function(
1953: p_function =>'pa_fp_copy_from_pkg.create_res_task_maps'
1954: ,p_debug_mode => l_debug_mode );
1955:
1956: -- Check for business rules violations
1957: pa_debug.g_err_stage:='Validating input parameters';

Line 2193: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'

2189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2190: x_msg_count := 1;
2191: x_msg_data := SQLERRM;
2192:
2193: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'
2194: ,p_procedure_name => 'create_res_task_maps');
2195:
2196: IF l_debug_mode = 'Y' THEN
2197: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2279: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Resource_Assignments');

2275: BEGIN
2276: x_msg_count := 0;
2277: x_return_status := FND_API.G_RET_STS_SUCCESS;
2278: IF P_PA_DEBUG_MODE = 'Y' THEN
2279: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Resource_Assignments');
2280: END IF;
2281: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2282: l_debug_mode := NVL(l_debug_mode, 'Y');
2283: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 4076: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

4072: WHEN Others THEN
4073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4074: x_msg_count := 1;
4075: x_msg_data := SQLERRM;
4076: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
4077: ,p_procedure_name => 'COPY_RESOURCE_ASSIGNMENTS');
4078:
4079: IF P_PA_DEBUG_MODE = 'Y' THEN
4080: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 4674: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'

4670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4671: x_msg_count := 1;
4672: x_msg_data := SQLERRM;
4673:
4674: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'
4675: ,p_procedure_name => 'derv_missing_amts_chk_neg_qty');
4676:
4677: IF l_debug_mode = 'Y' THEN
4678: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 4766: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines');

4762:
4763: x_msg_count := 0;
4764: x_return_status := FND_API.G_RET_STS_SUCCESS;
4765: IF P_PA_DEBUG_MODE = 'Y' THEN
4766: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines');
4767: END IF;
4768: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4769: l_debug_mode := NVL(l_debug_mode, 'Y');
4770: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 5255: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

5251: WHEN Others THEN
5252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5253: x_msg_count := 1;
5254: x_msg_data := SQLERRM;
5255: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
5256: ,p_procedure_name => 'COPY_BUDGET_LINES');
5257:
5258: IF P_PA_DEBUG_MODE = 'Y' THEN
5259: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

Line 5297: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Periods_Denorm');

5293:
5294: x_msg_count := 0;
5295: x_return_status := FND_API.G_RET_STS_SUCCESS;
5296: IF P_PA_DEBUG_MODE = 'Y' THEN
5297: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Periods_Denorm');
5298: END IF;
5299: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
5300: l_debug_mode := NVL(l_debug_mode, 'Y');
5301: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 5573: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

5569: WHEN Others THEN
5570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5571: x_msg_count := 1;
5572: x_msg_data := SQLERRM;
5573: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
5574: ,p_procedure_name => 'Copy_Periods_Denorm');
5575:
5576: IF P_PA_DEBUG_MODE = 'Y' THEN
5577: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

Line 6038: l_proj_fp_options_id_tbl PA_FP_COPY_FROM_PKG.PROJ_FP_OPTIONS_ID_TBL_TYP;

6034: l_index NUMBER;
6035: l_shift_days NUMBER;
6036: l_period_type VARCHAR2(15);
6037:
6038: l_proj_fp_options_id_tbl PA_FP_COPY_FROM_PKG.PROJ_FP_OPTIONS_ID_TBL_TYP;
6039:
6040: l_source_template_flag pa_projects_all.template_flag%TYPE;
6041: l_source_current_flag pa_budget_versions.current_flag%TYPE;
6042: l_source_version_id pa_budget_versions.budget_version_id%TYPE;

Line 6095: pa_debug.init_err_stack('PA_FP_COPY_FROM_PKG.Copy_Finplans_From_Project');

6091: x_msg_count := 0;
6092: x_return_status := FND_API.G_RET_STS_SUCCESS;
6093:
6094: IF P_PA_DEBUG_MODE = 'Y' THEN
6095: pa_debug.init_err_stack('PA_FP_COPY_FROM_PKG.Copy_Finplans_From_Project');
6096: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
6097: -- Check if source project id is NULL,if so throw an error message
6098: pa_debug.g_err_stage := 'Checking for valid parameters:';
6099: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

Line 6119: p_value1 => 'PA_FP_COPY_FROM_PKG.Copy_Finplans_From_Project');

6115:
6116: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
6117: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
6118: p_token1 => 'PROCEDURENAME',
6119: p_value1 => 'PA_FP_COPY_FROM_PKG.Copy_Finplans_From_Project');
6120: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6121:
6122: END IF;
6123:

Line 6223: PA_FP_COPY_FROM_PKG.Get_Fp_Options_To_Be_Copied(

6219: pa_debug.g_err_stage := 'Calling Get_Fp_Options_To_Be_Copied api';
6220: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6221: END IF;
6222:
6223: PA_FP_COPY_FROM_PKG.Get_Fp_Options_To_Be_Copied(
6224: p_source_project_id => p_source_project_id
6225: ,p_copy_versions => p_copy_version_and_elements /* Bug 2981655 */
6226: ,x_fp_options_ids_tbl => l_proj_fp_options_id_tbl
6227: ,x_return_status => l_return_status

Line 6300: PA_FP_COPY_FROM_PKG.Copy_Budget_Version(

6296: END IF;
6297:
6298: l_target_version_id := NULL;
6299:
6300: PA_FP_COPY_FROM_PKG.Copy_Budget_Version(
6301: p_source_project_id => p_source_project_id
6302: ,p_target_project_id => p_target_project_id
6303: ,p_source_version_id => l_source_version_id
6304: ,p_copy_mode => PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING

Line 6408: PA_FP_COPY_FROM_PKG.Copy_Resource_Assignments(

6404: pa_debug.g_err_stage := 'Calling Copy_Resource_Assignments';
6405: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6406: END IF;
6407:
6408: PA_FP_COPY_FROM_PKG.Copy_Resource_Assignments(
6409: p_source_plan_version_id => l_source_version_id
6410: ,p_target_plan_version_id => l_target_version_id
6411: ,p_adj_percentage => 0.99999
6412: ,x_return_status => l_return_status

Line 6430: PA_FP_COPY_FROM_PKG.Copy_Budget_Lines(

6426: pa_debug.g_err_stage := 'Calling Copy_Budget_Lines';
6427: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6428: END IF;
6429:
6430: PA_FP_COPY_FROM_PKG.Copy_Budget_Lines(
6431: p_source_project_id => p_source_project_id
6432: ,p_target_project_id => p_target_project_id
6433: ,p_source_plan_version_id => l_source_version_id
6434: ,p_target_plan_version_id => l_target_version_id

Line 6511: * copy_attachments is already done in PA_FP_COPY_FROM_PKG.Copy_Budget_Version

6507: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6508: END IF;
6509:
6510: /* BUG FIX 2955827
6511: * copy_attachments is already done in PA_FP_COPY_FROM_PKG.Copy_Budget_Version
6512: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(
6513: x_from_entity_name => 'PA_BUDGET_VERSIONS'
6514: ,x_from_pk1_value => l_source_version_id
6515: ,x_from_pk2_value => NULL

Line 6844: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

6840:
6841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6842: x_msg_count := 1;
6843: x_msg_data := SQLERRM;
6844: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
6845: ,p_procedure_name => 'Copy_Finplans_From_Project');
6846:
6847: IF P_PA_DEBUG_MODE = 'Y' THEN
6848: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 6911: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Get_Fp_Options_To_Be_Copied');

6907: x_msg_count := 0;
6908: x_return_status := FND_API.G_RET_STS_SUCCESS;
6909:
6910: IF p_pa_debug_mode = 'Y' THEN
6911: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Get_Fp_Options_To_Be_Copied');
6912: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
6913: END IF;
6914:
6915: -- Check if source project id is NULL,if so throw an error message

Line 7219: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

7215:
7216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7217: x_msg_count := 1;
7218: x_msg_data := SQLERRM;
7219: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
7220: ,p_procedure_name => 'Get_Fp_Options_To_Be_Copied');
7221:
7222: IF P_PA_DEBUG_MODE = 'Y' THEN
7223: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 7362: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines');

7358:
7359: x_msg_count := 0;
7360: x_return_status := FND_API.G_RET_STS_SUCCESS;
7361: IF P_PA_DEBUG_MODE = 'Y' THEN
7362: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines');
7363: END IF;
7364: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
7365: l_debug_mode := NVL(l_debug_mode, 'Y');
7366: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 8152: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

8148:
8149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8150: x_msg_count := 1;
8151: x_msg_data := SQLERRM;
8152: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
8153: ,p_procedure_name => 'COPY_BUDGET_LINES');
8154: IF P_PA_DEBUG_MODE = 'Y' THEN
8155: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;
8156: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,6);

Line 8201: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Current_Period_Profiles');

8197: x_msg_count := 0;
8198: x_return_status := FND_API.G_RET_STS_SUCCESS;
8199:
8200: IF p_pa_debug_mode = 'Y' THEN
8201: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Current_Period_Profiles');
8202: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
8203: END IF;
8204:
8205: -- Check for NOT NULL parameters

Line 8236: PA_FP_COPY_FROM_PKG.Get_Create_Shifted_PD_Profile (

8232: EXIT WHEN current_period_profiles_cur%NOTFOUND;
8233:
8234: /* Bug 2987076 - Period profile would not be created if periods are not available for the shifted dates */
8235:
8236: PA_FP_COPY_FROM_PKG.Get_Create_Shifted_PD_Profile (
8237: p_target_project_id => p_target_project_id
8238: ,p_source_period_profile_id => l_source_period_profile_id
8239: ,p_shift_days => p_shift_days
8240: ,x_target_period_profile_id => l_target_period_profile_id

Line 8288: ( p_pkg_name => 'PA_FP_COPY_FROM_PKG'

8284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8285: x_msg_count := 1;
8286: x_msg_data := SQLERRM;
8287: FND_MSG_PUB.add_exc_msg
8288: ( p_pkg_name => 'PA_FP_COPY_FROM_PKG'
8289: ,p_procedure_name => 'Copy_Current_Period_Profiles'
8290: ,p_error_text => sqlerrm);
8291: IF p_pa_debug_mode = 'Y' THEN
8292: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;

Line 8385: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Get_Create_Shifted_PD_Profile');

8381:
8382: x_msg_count := 0;
8383: x_return_status := FND_API.G_RET_STS_SUCCESS;
8384: IF P_PA_DEBUG_MODE = 'Y' THEN
8385: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Get_Create_Shifted_PD_Profile');
8386: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
8387: END IF;
8388: -- Check for NOT NULL parameters
8389:

Line 8707: ( p_pkg_name => 'PA_FP_COPY_FROM_PKG'

8703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8704: x_msg_count := 1;
8705: x_msg_data := SQLERRM;
8706: FND_MSG_PUB.add_exc_msg
8707: ( p_pkg_name => 'PA_FP_COPY_FROM_PKG'
8708: ,p_procedure_name => 'Get_Create_Shifted_PD_Profile'
8709: ,p_error_text => sqlerrm);
8710: IF p_pa_debug_mode = 'Y' THEN
8711: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;

Line 8976: pa_fp_copy_from_pkg.copy_budget_version

8972: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level3);
8973: END IF;
8974:
8975: --Call the method that copies the budget version
8976: pa_fp_copy_from_pkg.copy_budget_version
8977: ( p_source_project_id => p_source_project_id
8978: ,p_target_project_id => p_target_project_id
8979: ,p_source_version_id => l_src_budget_version_id
8980: ,p_copy_mode => 'W'

Line 9178: PA_FP_COPY_FROM_PKG.Update_Plan_Setup_For_WP_Copy(

9174: -- When this api is called to create a working workplan structure version from
9175: -- a published version, all the data in 'Additional Workplan settings' pages
9176: -- should be synchronised with workplan plan type data
9177:
9178: PA_FP_COPY_FROM_PKG.Update_Plan_Setup_For_WP_Copy(
9179: p_project_id => p_target_project_id
9180: ,p_wp_version_id => l_targ_budget_version_id
9181: ,x_return_status => x_return_status
9182: ,x_msg_count => x_msg_count

Line 9303: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'

9299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9300: x_msg_count := 1;
9301: x_msg_data := SQLERRM;
9302:
9303: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'
9304: ,p_procedure_name => 'copy_wp_budget_versions');
9305:
9306: IF l_debug_mode = 'Y' THEN
9307: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 9512: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines_Appr_Rev');

9508:
9509: x_msg_count := 0;
9510: x_return_status := FND_API.G_RET_STS_SUCCESS;
9511: IF P_PA_DEBUG_MODE = 'Y' THEN
9512: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines_Appr_Rev');
9513: END IF;
9514: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
9515: l_debug_mode := NVL(l_debug_mode, 'Y');
9516: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 10055: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

10051: WHEN Others THEN
10052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10053: x_msg_count := 1;
10054: x_msg_data := SQLERRM;
10055: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
10056: ,p_procedure_name => 'COPY_BUDGET_LINES_APPR_REV');
10057:
10058: IF P_PA_DEBUG_MODE = 'Y' THEN
10059: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

Line 10187: p_function =>'PA_FP_COPY_FROM_PKG.Update_Plan_Setup_For_WP_Copy'

10183:
10184: -- Set curr function
10185: IF l_debug_mode = 'Y' THEN
10186: pa_debug.set_curr_function(
10187: p_function =>'PA_FP_COPY_FROM_PKG.Update_Plan_Setup_For_WP_Copy'
10188: ,p_debug_mode => l_debug_mode );
10189:
10190: -- Check for business rules violations
10191: pa_debug.g_err_stage:='Validating input parameters';

Line 10210: p_value1 => 'PA_FP_COPY_FROM_PKG.Update_Plan_Setup_For_WP_Copy');

10206:
10207: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
10208: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
10209: p_token1 => 'PROCEDURENAME',
10210: p_value1 => 'PA_FP_COPY_FROM_PKG.Update_Plan_Setup_For_WP_Copy');
10211:
10212: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10213:
10214: END IF;

Line 10464: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_COPY_FROM_PKG'

10460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10461: x_msg_count := 1;
10462: x_msg_data := SQLERRM;
10463:
10464: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_COPY_FROM_PKG'
10465: ,p_procedure_name => 'Update_Plan_Setup_For_WP_Copy');
10466:
10467: IF l_debug_mode = 'Y' THEN
10468: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 10477: END pa_fp_copy_from_pkg;

10473:
10474: RAISE;
10475: END Update_Plan_Setup_For_WP_Copy;
10476:
10477: END pa_fp_copy_from_pkg;