DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_TYPES_UTILS dependencies on PA_FIN_PLAN_TYPES_UTILS

Line 1: PACKAGE BODY pa_fin_plan_types_utils as

1: PACKAGE BODY pa_fin_plan_types_utils as
2: /* $Header: PAFTYPUB.pls 120.1 2005/08/19 16:32:29 mwasowic noship $ */
3:
4: /*********************************************************************
5: Important : The appropriate procedures that make a call to the below

Line 9: g_module_name VARCHAR2(100) := 'pa.plsql.pa_fin_plan_types_utils';

5: Important : The appropriate procedures that make a call to the below
6: procedures must make a call to FND_MSG_PUB.initialize.
7: **********************************************************************/
8:
9: g_module_name VARCHAR2(100) := 'pa.plsql.pa_fin_plan_types_utils';
10:
11: procedure name_val
12: (p_name IN pa_fin_plan_types_tl.name%TYPE,
13: p_fin_plan_type_id IN

Line 160: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',

156: when OTHERS then
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: x_msg_count := 1;
159: x_msg_data := SQLERRM;
160: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',
161: p_procedure_name => 'name_val');
162: raise FND_API.G_EXC_UNEXPECTED_ERROR;
163: end name_val;
164:

Line 222: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',

218: when OTHERS then
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: x_msg_count := 1;
221: x_msg_data := SQLERRM;
222: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',
223: p_procedure_name => 'end_date_active_val');
224: raise FND_API.G_EXC_UNEXPECTED_ERROR;
225: end end_date_active_val;
226: ***********************************************************************************/

Line 290: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',

286: when others then
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: x_msg_count := 1;
289: x_msg_data := SQLERRM;
290: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',
291: p_procedure_name => 'generated_flag_val');
292: raise FND_API.G_EXC_UNEXPECTED_ERROR;
293: end generated_flag_val;
294:

Line 351: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',

347: when others then
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: x_msg_count := 1;
350: x_msg_data := SQLERRM;
351: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',
352: p_procedure_name => 'used_in_billing_flag_val');
353: raise FND_API.G_EXC_UNEXPECTED_ERROR;
354: end used_in_billing_flag_val;
355:

Line 371: if pa_fin_plan_types_utils.isfptypeused(p_fin_plan_type_id => p_fin_plan_type_id) =

367: l_data VARCHAR2(2000);
368: l_msg_data VARCHAR2(2000);
369: begin
370:
371: if pa_fin_plan_types_utils.isfptypeused(p_fin_plan_type_id => p_fin_plan_type_id) =
372: 'Y' then
373: /* If a plan type has already been used by a project, that plan type should not
374: be deleted */
375: x_return_status := FND_API.G_RET_STS_ERROR;

Line 406: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',

402: when others then
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: x_msg_count := 1;
405: x_msg_data := SQLERRM;
406: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',
407: p_procedure_name => 'delete_val');
408: raise FND_API.G_EXC_UNEXPECTED_ERROR;
409: end delete_val;
410:

Line 439: pa_fin_plan_types_utils.name_val

435: begin
436:
437: x_return_status := FND_API.G_RET_STS_SUCCESS;
438:
439: pa_fin_plan_types_utils.name_val
440: (p_name => p_name,
441: p_fin_plan_type_id => p_fin_plan_type_id,
442: x_return_status => x_return_status,
443: x_msg_count => x_msg_count,

Line 457: pa_fin_plan_types_utils.generated_flag_val

453: /***********************************************************************
454: Commented since generated_flag and used_in_billing_flag
455: are obsolete after change in functionality
456:
457: pa_fin_plan_types_utils.generated_flag_val
458: (p_fin_plan_type_id => p_fin_plan_type_id,
459: p_generated_flag => p_generated_flag,
460: p_pre_defined_flag => p_pre_defined_flag,
461: p_fin_plan_type_code => p_fin_plan_type_code,

Line 467: pa_fin_plan_types_utils.used_in_billing_flag_val

463: x_return_status => x_return_status,
464: x_msg_count => x_msg_count,
465: x_msg_data => x_msg_data);
466:
467: pa_fin_plan_types_utils.used_in_billing_flag_val
468: (p_fin_plan_type_id => p_fin_plan_type_id,
469: p_used_in_billing_flag => p_used_in_billing_flag,
470: x_return_status => x_return_status,
471: x_msg_count => x_msg_count,

Line 498: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',

494: when others then
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: x_msg_count := 1;
497: x_msg_data := SQLERRM;
498: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',
499: p_procedure_name => 'validate');
500: raise FND_API.G_EXC_UNEXPECTED_ERROR;
501: end validate;
502:

Line 721: => 'PA_FIN_PLAN_TYPES_UTILS'

717: pa_debug.reset_curr_function;
718: END IF;
719:
720: FND_MSG_PUB.add_exc_msg( p_pkg_name
721: => 'PA_FIN_PLAN_TYPES_UTILS'
722: ,p_procedure_name
723: => 'Get_concate_statuses');
724: RAISE;
725:

Line 804: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',

800: WHEN OTHERS THEN
801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
802: x_msg_count := 1;
803: x_msg_data := SQLERRM;
804: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_UTILS',
805: p_procedure_name => 'get_workplan_pt_details');
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807:
808: END GET_WORKPLAN_PT_DETAILS;

Line 893: END pa_fin_plan_types_utils;

889:
890:
891: END Is_Rev_Impl_Partially;
892:
893: END pa_fin_plan_types_utils;