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_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.4 2005/08/25 02:01:18 avaithia noship $ */
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 715: IF pa_projects_maint_utils.class_check_mandatory (p_class_category, l_project_id) = 'Y' THEN

711: l_project_id := p_object_id;
712: end if;
713:
714: /* changes for bug 2681127 */
715: IF pa_projects_maint_utils.class_check_mandatory (p_class_category, l_project_id) = 'Y' THEN
716: x_error_msg_code := 'PA_CLASS_CATEGORY_MANDATORY';
717: x_return_status := 'E' ;
718: RETURN;
719: END IF;

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

718: RETURN;
719: END IF;
720: /* changes for bug 2681127 end */
721:
722: l_dummy := PA_PROJECTS_MAINT_UTILS.CLASS_CHECK_TRANS(l_project_id);
723: IF l_dummy ='Y'
724: THEN
725: OPEN class_delrec(p_class_category);
726: FETCH class_delrec INTO l_rec_status_flag;

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

737: EXCEPTION
738: WHEN OTHERS THEN
739: x_return_status := 'U';
740: x_error_msg_code := SQLCODE;
741: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
742: p_procedure_name => 'CHECK_CLASS_CATG_CAN_DELETE',
743: p_error_text => SUBSTRB(SQLERRM,1,240));
744: raise;
745: END CHECK_CLASS_CATG_CAN_DELETE;

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

794: EXCEPTION
795: WHEN OTHERS THEN
796: x_return_status := 'U';
797: x_error_msg_code := SQLCODE;
798: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
799: p_procedure_name => 'CHECK_DUPLICATE_CLASS_CATG',
800: p_error_text => SUBSTRB(SQLERRM,1,240));
801: raise;
802: END CHECK_DUPLICATE_CLASS_CATG;

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

851: EXCEPTION
852: WHEN OTHERS THEN
853: x_return_status := 'U';
854: x_error_msg_code := SQLCODE;
855: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
856: p_procedure_name => 'CHECK_CLASS_CATG_ONE_ONLY_CODE',
857: p_error_text => SUBSTRB(SQLERRM,1,240));
858: raise;
859: END CHECK_CLASS_CATG_ONE_ONLY_CODE;

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

921: EXCEPTION
922: WHEN OTHERS THEN
923: x_return_status := 'U';
924: x_error_msg_code := SQLCODE;
925: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
926: p_procedure_name => 'CHECK_CLASS_CATG_CAN_OVERRIDE',
927: p_error_text => SUBSTRB(SQLERRM,1,240));
928: raise;
929: END CHECK_CLASS_CATG_CAN_OVERRIDE;

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

968: EXCEPTION
969: WHEN OTHERS THEN
970: x_return_status := 'U';
971: x_error_msg_code := SQLCODE;
972: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
973: p_procedure_name => 'CHECK_PROBABILITY_CAN_CHANGE',
974: p_error_text => SUBSTRB(SQLERRM,1,240));
975: raise;
976: END CHECK_PROBABILITY_CAN_CHANGE;

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

1019: EXCEPTION
1020: WHEN OTHERS THEN
1021: x_return_status := 'U';
1022: x_error_msg_code := SQLCODE;
1023: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
1024: p_procedure_name => 'CHECK_BILL_JOB_GRP_REQ',
1025: p_error_text => SUBSTRB(SQLERRM,1,240));
1026: raise;
1027: END CHECK_BILL_JOB_GRP_REQ;

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

1989: l_id_found_flag VARCHAR(1) := 'N';
1990:
1991: BEGIN
1992:
1993: pa_debug.init_err_stack ('pa_projects_maint_utils.Check_ClassCode_Name_Or_Id');
1994:
1995: IF p_classcode_id IS NOT NULL AND p_classcode_id <> FND_API.G_MISS_NUM THEN
1996:
1997: IF p_check_id_flag = 'Y' THEN

Line 2072: (p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',

2068:
2069: WHEN OTHERS THEN
2070: x_classcode_id := null;
2071: fnd_msg_pub.add_exc_msg
2072: (p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
2073: p_procedure_name => pa_debug.g_err_stack );
2074: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2075: -- 4537865
2076: x_error_message_code := SQLCODE ;

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

2107: l_id_found_flag VARCHAR(1) := 'N';
2108:
2109: BEGIN
2110:
2111: pa_debug.init_err_stack ('pa_projects_maint_utils.Check_ClassCategory_Name_Or_Id');
2112:
2113: IF p_class_category_id IS NOT NULL AND p_class_category_id <> FND_API.G_MISS_NUM THEN
2114:
2115: IF p_check_id_flag = 'Y' THEN

Line 2188: (p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',

2184:
2185: WHEN OTHERS THEN
2186: x_class_category_id := null;
2187: fnd_msg_pub.add_exc_msg
2188: (p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
2189: p_procedure_name => pa_debug.g_err_stack );
2190: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2191: -- 4537865
2192: x_error_message_code := SQLCODE ;

Line 2260: END PA_PROJECTS_MAINT_UTILS;

2256: RETURN x_mandatory_flag;
2257: END CLASS_CHECK_MANDATORY;
2258:
2259:
2260: END PA_PROJECTS_MAINT_UTILS;