DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_PROJECTS_MAINT_UTILS

Line 1: PACKAGE BODY PA_PROJECTS_MAINT_UTILS AS

1: PACKAGE BODY PA_PROJECTS_MAINT_UTILS AS
2: /* $Header: PARMPRUB.pls 120.5 2009/06/15 07:09:38 admarath ship $ */
3: -- API name : check_org_name_or_id
4: -- Type : Public
5: -- Pre-reqs : None.

Line 381: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS', p_procedure_name => 'CHECK_PROBABILITY_CODE_OR_ID');

377: x_error_msg_code := SQLCODE ;
378:
379: x_probability_member_id := NULL;
380: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
381: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS', p_procedure_name => 'CHECK_PROBABILITY_CODE_OR_ID');
382: RAISE;
383: END CHECK_PROBABILITY_CODE_OR_ID;
384:
385: -- API name : check_calendar_name_or_id

Line 728: IF pa_projects_maint_utils.class_check_mandatory (p_class_category, l_project_id) = 'Y' THEN

724: l_project_id := p_object_id;
725: end if;
726:
727: /* changes for bug 2681127 */
728: IF pa_projects_maint_utils.class_check_mandatory (p_class_category, l_project_id) = 'Y' THEN
729: x_error_msg_code := 'PA_CLASS_CATEGORY_MANDATORY';
730: x_return_status := 'E' ;
731: RETURN;
732: END IF;

Line 735: l_dummy := PA_PROJECTS_MAINT_UTILS.CLASS_CHECK_TRANS(l_project_id);

731: RETURN;
732: END IF;
733: /* changes for bug 2681127 end */
734:
735: l_dummy := PA_PROJECTS_MAINT_UTILS.CLASS_CHECK_TRANS(l_project_id);
736: IF l_dummy ='Y'
737: THEN
738: OPEN class_delrec(p_class_category);
739: FETCH class_delrec INTO l_rec_status_flag;

Line 754: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',

750: EXCEPTION
751: WHEN OTHERS THEN
752: x_return_status := 'U';
753: x_error_msg_code := SQLCODE;
754: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
755: p_procedure_name => 'CHECK_CLASS_CATG_CAN_DELETE',
756: p_error_text => SUBSTRB(SQLERRM,1,240));
757: raise;
758: END CHECK_CLASS_CATG_CAN_DELETE;

Line 811: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',

807: EXCEPTION
808: WHEN OTHERS THEN
809: x_return_status := 'U';
810: x_error_msg_code := SQLCODE;
811: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
812: p_procedure_name => 'CHECK_DUPLICATE_CLASS_CATG',
813: p_error_text => SUBSTRB(SQLERRM,1,240));
814: raise;
815: END CHECK_DUPLICATE_CLASS_CATG;

Line 868: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',

864: EXCEPTION
865: WHEN OTHERS THEN
866: x_return_status := 'U';
867: x_error_msg_code := SQLCODE;
868: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
869: p_procedure_name => 'CHECK_CLASS_CATG_ONE_ONLY_CODE',
870: p_error_text => SUBSTRB(SQLERRM,1,240));
871: raise;
872: END CHECK_CLASS_CATG_ONE_ONLY_CODE;

Line 938: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',

934: EXCEPTION
935: WHEN OTHERS THEN
936: x_return_status := 'U';
937: x_error_msg_code := SQLCODE;
938: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
939: p_procedure_name => 'CHECK_CLASS_CATG_CAN_OVERRIDE',
940: p_error_text => SUBSTRB(SQLERRM,1,240));
941: raise;
942: END CHECK_CLASS_CATG_CAN_OVERRIDE;

Line 985: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',

981: EXCEPTION
982: WHEN OTHERS THEN
983: x_return_status := 'U';
984: x_error_msg_code := SQLCODE;
985: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
986: p_procedure_name => 'CHECK_PROBABILITY_CAN_CHANGE',
987: p_error_text => SUBSTRB(SQLERRM,1,240));
988: raise;
989: END CHECK_PROBABILITY_CAN_CHANGE;

Line 1036: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',

1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: x_return_status := 'U';
1035: x_error_msg_code := SQLCODE;
1036: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
1037: p_procedure_name => 'CHECK_BILL_JOB_GRP_REQ',
1038: p_error_text => SUBSTRB(SQLERRM,1,240));
1039: raise;
1040: END CHECK_BILL_JOB_GRP_REQ;

Line 2006: pa_debug.init_err_stack ('pa_projects_maint_utils.Check_ClassCode_Name_Or_Id');

2002: l_id_found_flag VARCHAR(1) := 'N';
2003:
2004: BEGIN
2005:
2006: pa_debug.init_err_stack ('pa_projects_maint_utils.Check_ClassCode_Name_Or_Id');
2007:
2008: IF p_classcode_id IS NOT NULL AND p_classcode_id <> FND_API.G_MISS_NUM THEN
2009:
2010: IF p_check_id_flag = 'Y' THEN

Line 2085: (p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',

2081:
2082: WHEN OTHERS THEN
2083: x_classcode_id := null;
2084: fnd_msg_pub.add_exc_msg
2085: (p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
2086: p_procedure_name => pa_debug.g_err_stack );
2087: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2088: -- 4537865
2089: x_error_message_code := SQLCODE ;

Line 2124: pa_debug.init_err_stack ('pa_projects_maint_utils.Check_ClassCategory_Name_Or_Id');

2120: l_id_found_flag VARCHAR(1) := 'N';
2121:
2122: BEGIN
2123:
2124: pa_debug.init_err_stack ('pa_projects_maint_utils.Check_ClassCategory_Name_Or_Id');
2125:
2126: IF p_class_category_id IS NOT NULL AND p_class_category_id <> FND_API.G_MISS_NUM THEN
2127:
2128: IF p_check_id_flag = 'Y' THEN

Line 2201: (p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',

2197:
2198: WHEN OTHERS THEN
2199: x_class_category_id := null;
2200: fnd_msg_pub.add_exc_msg
2201: (p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
2202: p_procedure_name => pa_debug.g_err_stack );
2203: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2204: -- 4537865
2205: x_error_message_code := SQLCODE ;

Line 2273: END PA_PROJECTS_MAINT_UTILS;

2269: RETURN x_mandatory_flag;
2270: END CLASS_CHECK_MANDATORY;
2271:
2272:
2273: END PA_PROJECTS_MAINT_UTILS;