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.20.12010000.2 2008/09/10 23:53:41 skkoppul 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.20.12010000.2 2008/09/10 23:53:41 skkoppul 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 4064: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

4060: WHEN Others THEN
4061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4062: x_msg_count := 1;
4063: x_msg_data := SQLERRM;
4064: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
4065: ,p_procedure_name => 'COPY_RESOURCE_ASSIGNMENTS');
4066:
4067: IF P_PA_DEBUG_MODE = 'Y' THEN
4068: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

4658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4659: x_msg_count := 1;
4660: x_msg_data := SQLERRM;
4661:
4662: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'
4663: ,p_procedure_name => 'derv_missing_amts_chk_neg_qty');
4664:
4665: IF l_debug_mode = 'Y' THEN
4666: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

4750:
4751: x_msg_count := 0;
4752: x_return_status := FND_API.G_RET_STS_SUCCESS;
4753: IF P_PA_DEBUG_MODE = 'Y' THEN
4754: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines');
4755: END IF;
4756: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4757: l_debug_mode := NVL(l_debug_mode, 'Y');
4758: IF P_PA_DEBUG_MODE = 'Y' THEN

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

5239: WHEN Others THEN
5240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5241: x_msg_count := 1;
5242: x_msg_data := SQLERRM;
5243: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
5244: ,p_procedure_name => 'COPY_BUDGET_LINES');
5245:
5246: IF P_PA_DEBUG_MODE = 'Y' THEN
5247: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

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

5281:
5282: x_msg_count := 0;
5283: x_return_status := FND_API.G_RET_STS_SUCCESS;
5284: IF P_PA_DEBUG_MODE = 'Y' THEN
5285: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Periods_Denorm');
5286: END IF;
5287: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
5288: l_debug_mode := NVL(l_debug_mode, 'Y');
5289: IF P_PA_DEBUG_MODE = 'Y' THEN

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

5557: WHEN Others THEN
5558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5559: x_msg_count := 1;
5560: x_msg_data := SQLERRM;
5561: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
5562: ,p_procedure_name => 'Copy_Periods_Denorm');
5563:
5564: IF P_PA_DEBUG_MODE = 'Y' THEN
5565: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

Line 6025: l_proj_fp_options_id_tbl PA_FP_COPY_FROM_PKG.PROJ_FP_OPTIONS_ID_TBL_TYP;

6021: l_index NUMBER;
6022: l_shift_days NUMBER;
6023: l_period_type VARCHAR2(15);
6024:
6025: l_proj_fp_options_id_tbl PA_FP_COPY_FROM_PKG.PROJ_FP_OPTIONS_ID_TBL_TYP;
6026:
6027: l_source_template_flag pa_projects_all.template_flag%TYPE;
6028: l_source_current_flag pa_budget_versions.current_flag%TYPE;
6029: l_source_version_id pa_budget_versions.budget_version_id%TYPE;

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

6078: x_msg_count := 0;
6079: x_return_status := FND_API.G_RET_STS_SUCCESS;
6080:
6081: IF P_PA_DEBUG_MODE = 'Y' THEN
6082: pa_debug.init_err_stack('PA_FP_COPY_FROM_PKG.Copy_Finplans_From_Project');
6083: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
6084: -- Check if source project id is NULL,if so throw an error message
6085: pa_debug.g_err_stage := 'Checking for valid parameters:';
6086: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

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

6102:
6103: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
6104: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
6105: p_token1 => 'PROCEDURENAME',
6106: p_value1 => 'PA_FP_COPY_FROM_PKG.Copy_Finplans_From_Project');
6107: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6108:
6109: END IF;
6110:

Line 6210: PA_FP_COPY_FROM_PKG.Get_Fp_Options_To_Be_Copied(

6206: pa_debug.g_err_stage := 'Calling Get_Fp_Options_To_Be_Copied api';
6207: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6208: END IF;
6209:
6210: PA_FP_COPY_FROM_PKG.Get_Fp_Options_To_Be_Copied(
6211: p_source_project_id => p_source_project_id
6212: ,p_copy_versions => p_copy_version_and_elements /* Bug 2981655 */
6213: ,x_fp_options_ids_tbl => l_proj_fp_options_id_tbl
6214: ,x_return_status => l_return_status

Line 6284: PA_FP_COPY_FROM_PKG.Copy_Budget_Version(

6280: END IF;
6281:
6282: l_target_version_id := NULL;
6283:
6284: PA_FP_COPY_FROM_PKG.Copy_Budget_Version(
6285: p_source_project_id => p_source_project_id
6286: ,p_target_project_id => p_target_project_id
6287: ,p_source_version_id => l_source_version_id
6288: ,p_copy_mode => PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING

Line 6391: PA_FP_COPY_FROM_PKG.Copy_Resource_Assignments(

6387: pa_debug.g_err_stage := 'Calling Copy_Resource_Assignments';
6388: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6389: END IF;
6390:
6391: PA_FP_COPY_FROM_PKG.Copy_Resource_Assignments(
6392: p_source_plan_version_id => l_source_version_id
6393: ,p_target_plan_version_id => l_target_version_id
6394: ,p_adj_percentage => 0.99999
6395: ,x_return_status => l_return_status

Line 6413: PA_FP_COPY_FROM_PKG.Copy_Budget_Lines(

6409: pa_debug.g_err_stage := 'Calling Copy_Budget_Lines';
6410: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6411: END IF;
6412:
6413: PA_FP_COPY_FROM_PKG.Copy_Budget_Lines(
6414: p_source_project_id => p_source_project_id
6415: ,p_target_project_id => p_target_project_id
6416: ,p_source_plan_version_id => l_source_version_id
6417: ,p_target_plan_version_id => l_target_version_id

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

6490: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6491: END IF;
6492:
6493: /* BUG FIX 2955827
6494: * copy_attachments is already done in PA_FP_COPY_FROM_PKG.Copy_Budget_Version
6495: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(
6496: x_from_entity_name => 'PA_BUDGET_VERSIONS'
6497: ,x_from_pk1_value => l_source_version_id
6498: ,x_from_pk2_value => NULL

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

6823:
6824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6825: x_msg_count := 1;
6826: x_msg_data := SQLERRM;
6827: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
6828: ,p_procedure_name => 'Copy_Finplans_From_Project');
6829:
6830: IF P_PA_DEBUG_MODE = 'Y' THEN
6831: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

6890: x_msg_count := 0;
6891: x_return_status := FND_API.G_RET_STS_SUCCESS;
6892:
6893: IF p_pa_debug_mode = 'Y' THEN
6894: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Get_Fp_Options_To_Be_Copied');
6895: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
6896: END IF;
6897:
6898: -- Check if source project id is NULL,if so throw an error message

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

7198:
7199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7200: x_msg_count := 1;
7201: x_msg_data := SQLERRM;
7202: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
7203: ,p_procedure_name => 'Get_Fp_Options_To_Be_Copied');
7204:
7205: IF P_PA_DEBUG_MODE = 'Y' THEN
7206: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

7339:
7340: x_msg_count := 0;
7341: x_return_status := FND_API.G_RET_STS_SUCCESS;
7342: IF P_PA_DEBUG_MODE = 'Y' THEN
7343: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines');
7344: END IF;
7345: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
7346: l_debug_mode := NVL(l_debug_mode, 'Y');
7347: IF P_PA_DEBUG_MODE = 'Y' THEN

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

8121:
8122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8123: x_msg_count := 1;
8124: x_msg_data := SQLERRM;
8125: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
8126: ,p_procedure_name => 'COPY_BUDGET_LINES');
8127: IF P_PA_DEBUG_MODE = 'Y' THEN
8128: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;
8129: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,6);

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

8170: x_msg_count := 0;
8171: x_return_status := FND_API.G_RET_STS_SUCCESS;
8172:
8173: IF p_pa_debug_mode = 'Y' THEN
8174: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Current_Period_Profiles');
8175: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
8176: END IF;
8177:
8178: -- Check for NOT NULL parameters

Line 8209: PA_FP_COPY_FROM_PKG.Get_Create_Shifted_PD_Profile (

8205: EXIT WHEN current_period_profiles_cur%NOTFOUND;
8206:
8207: /* Bug 2987076 - Period profile would not be created if periods are not available for the shifted dates */
8208:
8209: PA_FP_COPY_FROM_PKG.Get_Create_Shifted_PD_Profile (
8210: p_target_project_id => p_target_project_id
8211: ,p_source_period_profile_id => l_source_period_profile_id
8212: ,p_shift_days => p_shift_days
8213: ,x_target_period_profile_id => l_target_period_profile_id

Line 8261: ( p_pkg_name => 'PA_FP_COPY_FROM_PKG'

8257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8258: x_msg_count := 1;
8259: x_msg_data := SQLERRM;
8260: FND_MSG_PUB.add_exc_msg
8261: ( p_pkg_name => 'PA_FP_COPY_FROM_PKG'
8262: ,p_procedure_name => 'Copy_Current_Period_Profiles'
8263: ,p_error_text => sqlerrm);
8264: IF p_pa_debug_mode = 'Y' THEN
8265: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;

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

8354:
8355: x_msg_count := 0;
8356: x_return_status := FND_API.G_RET_STS_SUCCESS;
8357: IF P_PA_DEBUG_MODE = 'Y' THEN
8358: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Get_Create_Shifted_PD_Profile');
8359: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
8360: END IF;
8361: -- Check for NOT NULL parameters
8362:

Line 8680: ( p_pkg_name => 'PA_FP_COPY_FROM_PKG'

8676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8677: x_msg_count := 1;
8678: x_msg_data := SQLERRM;
8679: FND_MSG_PUB.add_exc_msg
8680: ( p_pkg_name => 'PA_FP_COPY_FROM_PKG'
8681: ,p_procedure_name => 'Get_Create_Shifted_PD_Profile'
8682: ,p_error_text => sqlerrm);
8683: IF p_pa_debug_mode = 'Y' THEN
8684: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;

Line 8949: pa_fp_copy_from_pkg.copy_budget_version

8945: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level3);
8946: END IF;
8947:
8948: --Call the method that copies the budget version
8949: pa_fp_copy_from_pkg.copy_budget_version
8950: ( p_source_project_id => p_source_project_id
8951: ,p_target_project_id => p_target_project_id
8952: ,p_source_version_id => l_src_budget_version_id
8953: ,p_copy_mode => 'W'

Line 9151: PA_FP_COPY_FROM_PKG.Update_Plan_Setup_For_WP_Copy(

9147: -- When this api is called to create a working workplan structure version from
9148: -- a published version, all the data in 'Additional Workplan settings' pages
9149: -- should be synchronised with workplan plan type data
9150:
9151: PA_FP_COPY_FROM_PKG.Update_Plan_Setup_For_WP_Copy(
9152: p_project_id => p_target_project_id
9153: ,p_wp_version_id => l_targ_budget_version_id
9154: ,x_return_status => x_return_status
9155: ,x_msg_count => x_msg_count

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

9272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9273: x_msg_count := 1;
9274: x_msg_data := SQLERRM;
9275:
9276: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'
9277: ,p_procedure_name => 'copy_wp_budget_versions');
9278:
9279: IF l_debug_mode = 'Y' THEN
9280: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

9481:
9482: x_msg_count := 0;
9483: x_return_status := FND_API.G_RET_STS_SUCCESS;
9484: IF P_PA_DEBUG_MODE = 'Y' THEN
9485: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines_Appr_Rev');
9486: END IF;
9487: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
9488: l_debug_mode := NVL(l_debug_mode, 'Y');
9489: IF P_PA_DEBUG_MODE = 'Y' THEN

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

10024: WHEN Others THEN
10025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10026: x_msg_count := 1;
10027: x_msg_data := SQLERRM;
10028: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
10029: ,p_procedure_name => 'COPY_BUDGET_LINES_APPR_REV');
10030:
10031: IF P_PA_DEBUG_MODE = 'Y' THEN
10032: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

Line 10160: p_function =>'PA_FP_COPY_FROM_PKG.Update_Plan_Setup_For_WP_Copy'

10156:
10157: -- Set curr function
10158: IF l_debug_mode = 'Y' THEN
10159: pa_debug.set_curr_function(
10160: p_function =>'PA_FP_COPY_FROM_PKG.Update_Plan_Setup_For_WP_Copy'
10161: ,p_debug_mode => l_debug_mode );
10162:
10163: -- Check for business rules violations
10164: pa_debug.g_err_stage:='Validating input parameters';

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

10179:
10180: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
10181: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
10182: p_token1 => 'PROCEDURENAME',
10183: p_value1 => 'PA_FP_COPY_FROM_PKG.Update_Plan_Setup_For_WP_Copy');
10184:
10185: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10186:
10187: END IF;

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

10433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10434: x_msg_count := 1;
10435: x_msg_data := SQLERRM;
10436:
10437: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_COPY_FROM_PKG'
10438: ,p_procedure_name => 'Update_Plan_Setup_For_WP_Copy');
10439:
10440: IF l_debug_mode = 'Y' THEN
10441: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 10450: END pa_fp_copy_from_pkg;

10446:
10447: RAISE;
10448: END Update_Plan_Setup_For_WP_Copy;
10449:
10450: END pa_fp_copy_from_pkg;