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.AHL_PP_RESRC_REQUIRE_PVT dependencies on AHL_PP_RESRC_REQUIRE_PVT

Line 1: PACKAGE BODY AHL_PP_RESRC_REQUIRE_PVT AS

1: PACKAGE BODY AHL_PP_RESRC_REQUIRE_PVT AS
2: /* $Header: AHLVREQB.pls 120.12.12010000.4 2008/12/28 02:31:31 sracha ship $*/
3:
4: ----------------------------------------------
5: -- Declare Constants --

Line 7: G_PKG_NAME VARCHAR2(30):= 'AHL_PP_RESRC_REQUIRE_PVT';

3:
4: ----------------------------------------------
5: -- Declare Constants --
6: -----------------------
7: G_PKG_NAME VARCHAR2(30):= 'AHL_PP_RESRC_REQUIRE_PVT';
8: G_MODULE_TYPE VARCHAR2(30);
9: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
10:
11: -------------------------------------------------

Line 1024: -- p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,

1020: -- x_msg_count OUT NUMBER Required
1021: -- x_msg_data OUT VARCHAR2 Required
1022: --
1023: -- Create Resource Requirement Parameters:
1024: -- p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
1025: -- Contains Resource Reqirement information to create
1026: --
1027: -- Version :
1028: -- Initial Version 1.0

Line 1039: p_x_resrc_Require_Tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,

1035: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
1036: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1037: p_module_type IN VARCHAR2 := NULL,
1038: p_interface_flag IN VARCHAR2,
1039: p_x_resrc_Require_Tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
1040: x_return_status OUT NOCOPY VARCHAR2,
1041: x_msg_count OUT NOCOPY NUMBER,
1042: x_msg_data OUT NOCOPY VARCHAR2
1043: )

Line 1207: Ahl_Debug_Pub.debug( 'Enter AHL_PP_RESRC_Require_PVT. Create_Resrc_Require +PPResrc_Require_Pvt+');

1203: END IF;
1204: -- Debug info.
1205: -- Dbms_Output.Enable(50000);
1206: IF G_DEBUG='Y' THEN
1207: Ahl_Debug_Pub.debug( 'Enter AHL_PP_RESRC_Require_PVT. Create_Resrc_Require +PPResrc_Require_Pvt+');
1208: END IF;
1209: G_MODULE_TYPE:=P_MODULE_TYPE;
1210:
1211: -- Standard call to check for call compatibility.

Line 2062: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_Require_PVT',

2058:
2059: Ahl_Debug_Pub.debug('Inside Exception' || '**SQL ERRORS');
2060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2061: THEN
2062: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_Require_PVT',
2063: p_procedure_name => 'Create_Resrc_Require',
2064: p_error_text => SUBSTR(SQLERRM,1,240));
2065: END IF;
2066: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2103: -- p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,

2099: -- x_msg_count OUT NUMBER Required
2100: -- x_msg_data OUT VARCHAR2 Required
2101: --
2102: -- Update Resource Requirement Parameters:
2103: -- p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
2104: -- Contains Resource Requirement information to perform Updation
2105: --
2106: -- Version :
2107: -- Initial Version 1.0

Line 2256: Ahl_Debug_Pub.debug( 'Enter ahl_pp_resrc_require_pvt. Update Resource Requirement +PPResrc_Require_Pvt+');

2252:
2253: AHL_DEBUG_PUB.enable_debug;
2254:
2255: -- Debug info.
2256: Ahl_Debug_Pub.debug( 'Enter ahl_pp_resrc_require_pvt. Update Resource Requirement +PPResrc_Require_Pvt+');
2257: END IF;
2258:
2259: G_MODULE_TYPE:=P_MODULE_TYPE;
2260: -- Standard call to check for call compatibility.

Line 2969: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_Require_PVT',

2965: ROLLBACK TO Update_Resrc_Require;
2966: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2967: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2968: THEN
2969: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_Require_PVT',
2970: p_procedure_name => 'UPDATE_Resrc_Require',
2971: p_error_text => SUBSTR(SQLERRM,1,240));
2972: END IF;
2973: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2999: p_x_resrc_Require_Tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,

2995: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
2996: p_commit IN VARCHAR2 := Fnd_Api.g_false,
2997: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
2998: p_module_type IN VARCHAR2 := 'JSP',
2999: p_x_resrc_Require_Tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
3000: x_return_status OUT NOCOPY VARCHAR2,
3001: x_msg_count OUT NOCOPY NUMBER,
3002: x_msg_data OUT NOCOPY VARCHAR2
3003: )

Line 3009: l_Resrc_Require_Rec AHL_PP_RESRC_Require_PVT.Resrc_Require_Rec_Type;

3005: L_API_VERSION CONSTANT NUMBER := 1.0;
3006: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Resource_Requirement';
3007: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
3008:
3009: l_Resrc_Require_Rec AHL_PP_RESRC_Require_PVT.Resrc_Require_Rec_Type;
3010:
3011: l_resrc_type_name VARCHAR2(80);
3012: l_resrc_type_code VARCHAR2(30);
3013: l_unit_of_measure VARCHAR2(30);

Line 3313: p_x_resrc_Require_Tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,

3309: p_commit IN VARCHAR2 := Fnd_Api.g_false,
3310: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
3311: p_module_type IN VARCHAR2 := 'JSP',
3312: p_interface_flag IN VARCHAR2,
3313: p_x_resrc_Require_Tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
3314: x_return_status OUT NOCOPY VARCHAR2,
3315: x_msg_count OUT NOCOPY NUMBER,
3316: x_msg_data OUT NOCOPY VARCHAR2
3317: )

Line 3425: Ahl_Debug_Pub.debug( 'Enter ahl_pp_resrc_require_pvt Remove Resource Requirement +APRRP+');

3421: IF G_DEBUG='Y' THEN
3422: Ahl_Debug_Pub.enable_debug;
3423:
3424: -- Debug info.
3425: Ahl_Debug_Pub.debug( 'Enter ahl_pp_resrc_require_pvt Remove Resource Requirement +APRRP+');
3426: END IF;
3427: -- Standard call to check for call compatibility.
3428: IF Fnd_Api.to_boolean(p_init_msg_list)
3429: THEN

Line 3723: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_Require_PVT',

3719: ROLLBACK TO Remove_Resource_Requirement;
3720: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3721: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3722: THEN
3723: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_Require_PVT',
3724: p_procedure_name => 'Remove_Resource_Requirement',
3725: p_error_text => SUBSTR(SQLERRM,1,240));
3726: END IF;
3727: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 3764: -- p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,

3760: -- x_msg_count OUT NUMBER Required
3761: -- x_msg_data OUT VARCHAR2 Required
3762: --
3763: -- Process Resource Requirement Parameters:
3764: -- p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
3765: -- Contains........................ on operation flag
3766: --
3767: -- Version :
3768: -- Initial Version 1.0

Line 3780: p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,

3776: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
3777: p_module_type IN VARCHAR2 := NULL,
3778: p_operation_flag IN VARCHAR2,
3779: p_interface_flag IN VARCHAR2,
3780: p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
3781: x_return_status OUT NOCOPY VARCHAR2,
3782: x_msg_count OUT NOCOPY NUMBER,
3783: x_msg_data OUT NOCOPY VARCHAR2
3784: )

Line 3791: l_resrc_Require_rec AHL_PP_RESRC_Require_PVT.Resrc_Require_Rec_Type;

3787: l_api_version CONSTANT NUMBER := 1.0;
3788: l_msg_count NUMBER;
3789: l_return_status VARCHAR2(1);
3790: l_msg_data VARCHAR2(2000);
3791: l_resrc_Require_rec AHL_PP_RESRC_Require_PVT.Resrc_Require_Rec_Type;
3792: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
3793: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
3794: l_plan_flag NUMBER;
3795:

Line 3999: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_Require_PVT',

3995: ROLLBACK TO Process_Resrc_Require;
3996: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3997: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3998: THEN
3999: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_Require_PVT',
4000: p_procedure_name => 'Process_Resrc_Require',
4001: p_error_text => SUBSTR(SQLERRM,1,240));
4002: END IF;
4003: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4015: END AHL_PP_RESRC_Require_PVT;

4011: AHL_DEBUG_PUB.disable_debug;
4012: END IF;
4013: END Process_Resrc_Require;
4014:
4015: END AHL_PP_RESRC_Require_PVT;