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.22.12020000.2 2012/12/07 13:32:42 sareepar 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 1202: -- p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,

1198: -- x_msg_count OUT NUMBER Required
1199: -- x_msg_data OUT VARCHAR2 Required
1200: --
1201: -- Create Resource Requirement Parameters:
1202: -- p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
1203: -- Contains Resource Reqirement information to create
1204: --
1205: -- Version :
1206: -- Initial Version 1.0

Line 1217: p_x_resrc_Require_Tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,

1213: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
1214: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1215: p_module_type IN VARCHAR2 := NULL,
1216: p_interface_flag IN VARCHAR2,
1217: p_x_resrc_Require_Tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
1218: x_return_status OUT NOCOPY VARCHAR2,
1219: x_msg_count OUT NOCOPY NUMBER,
1220: x_msg_data OUT NOCOPY VARCHAR2
1221: )

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

1381: END IF;
1382: -- Debug info.
1383: -- Dbms_Output.Enable(50000);
1384: IF G_DEBUG='Y' THEN
1385: Ahl_Debug_Pub.debug( 'Enter AHL_PP_RESRC_Require_PVT. Create_Resrc_Require +PPResrc_Require_Pvt+');
1386: END IF;
1387: G_MODULE_TYPE:=P_MODULE_TYPE;
1388:
1389: -- Standard call to check for call compatibility.

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

2256:
2257: Ahl_Debug_Pub.debug('Inside Exception' || '**SQL ERRORS');
2258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2259: THEN
2260: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_Require_PVT',
2261: p_procedure_name => 'Create_Resrc_Require',
2262: p_error_text => SUBSTR(SQLERRM,1,240));
2263: END IF;
2264: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

2297: -- x_msg_count OUT NUMBER Required
2298: -- x_msg_data OUT VARCHAR2 Required
2299: --
2300: -- Update Resource Requirement Parameters:
2301: -- p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
2302: -- Contains Resource Requirement information to perform Updation
2303: --
2304: -- Version :
2305: -- Initial Version 1.0

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

2450:
2451: AHL_DEBUG_PUB.enable_debug;
2452:
2453: -- Debug info.
2454: Ahl_Debug_Pub.debug( 'Enter ahl_pp_resrc_require_pvt. Update Resource Requirement +PPResrc_Require_Pvt+');
2455: END IF;
2456:
2457: G_MODULE_TYPE:=P_MODULE_TYPE;
2458: -- Standard call to check for call compatibility.

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

3186: ROLLBACK TO Update_Resrc_Require;
3187: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3188: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3189: THEN
3190: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_Require_PVT',
3191: p_procedure_name => 'UPDATE_Resrc_Require',
3192: p_error_text => SUBSTR(SQLERRM,1,240));
3193: END IF;
3194: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3220: p_x_resrc_Require_Tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,

3216: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
3217: p_commit IN VARCHAR2 := Fnd_Api.g_false,
3218: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
3219: p_module_type IN VARCHAR2 := 'JSP',
3220: p_x_resrc_Require_Tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
3221: x_return_status OUT NOCOPY VARCHAR2,
3222: x_msg_count OUT NOCOPY NUMBER,
3223: x_msg_data OUT NOCOPY VARCHAR2
3224: )

Line 3230: l_Resrc_Require_Rec AHL_PP_RESRC_Require_PVT.Resrc_Require_Rec_Type;

3226: L_API_VERSION CONSTANT NUMBER := 1.0;
3227: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Resource_Requirement';
3228: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
3229:
3230: l_Resrc_Require_Rec AHL_PP_RESRC_Require_PVT.Resrc_Require_Rec_Type;
3231:
3232: l_resrc_type_name VARCHAR2(80);
3233: l_resrc_type_code VARCHAR2(30);
3234: l_unit_of_measure VARCHAR2(30);

Line 3558: p_x_resrc_Require_Tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,

3554: p_commit IN VARCHAR2 := Fnd_Api.g_false,
3555: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
3556: p_module_type IN VARCHAR2 := 'JSP',
3557: p_interface_flag IN VARCHAR2,
3558: p_x_resrc_Require_Tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
3559: x_return_status OUT NOCOPY VARCHAR2,
3560: x_msg_count OUT NOCOPY NUMBER,
3561: x_msg_data OUT NOCOPY VARCHAR2
3562: )

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

3666: IF G_DEBUG='Y' THEN
3667: Ahl_Debug_Pub.enable_debug;
3668:
3669: -- Debug info.
3670: Ahl_Debug_Pub.debug( 'Enter ahl_pp_resrc_require_pvt Remove Resource Requirement +APRRP+');
3671: END IF;
3672: -- Standard call to check for call compatibility.
3673: IF Fnd_Api.to_boolean(p_init_msg_list)
3674: THEN

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

3964: ROLLBACK TO Remove_Resource_Requirement;
3965: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3966: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3967: THEN
3968: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_Require_PVT',
3969: p_procedure_name => 'Remove_Resource_Requirement',
3970: p_error_text => SUBSTR(SQLERRM,1,240));
3971: END IF;
3972: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

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

4005: -- x_msg_count OUT NUMBER Required
4006: -- x_msg_data OUT VARCHAR2 Required
4007: --
4008: -- Process Resource Requirement Parameters:
4009: -- p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
4010: -- Contains........................ on operation flag
4011: --
4012: -- Version :
4013: -- Initial Version 1.0

Line 4025: p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,

4021: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
4022: p_module_type IN VARCHAR2 := NULL,
4023: p_operation_flag IN VARCHAR2,
4024: p_interface_flag IN VARCHAR2,
4025: p_x_resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
4026: x_return_status OUT NOCOPY VARCHAR2,
4027: x_msg_count OUT NOCOPY NUMBER,
4028: x_msg_data OUT NOCOPY VARCHAR2
4029: )

Line 4036: l_resrc_Require_rec AHL_PP_RESRC_Require_PVT.Resrc_Require_Rec_Type;

4032: l_api_version CONSTANT NUMBER := 1.0;
4033: l_msg_count NUMBER;
4034: l_return_status VARCHAR2(1);
4035: l_msg_data VARCHAR2(2000);
4036: l_resrc_Require_rec AHL_PP_RESRC_Require_PVT.Resrc_Require_Rec_Type;
4037: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
4038: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
4039: l_plan_flag NUMBER;
4040:

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

4267: ROLLBACK TO Process_Resrc_Require;
4268: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4270: THEN
4271: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_Require_PVT',
4272: p_procedure_name => 'Process_Resrc_Require',
4273: p_error_text => SUBSTR(SQLERRM,1,240));
4274: END IF;
4275: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4287: END AHL_PP_RESRC_Require_PVT;

4283: AHL_DEBUG_PUB.disable_debug;
4284: END IF;
4285: END Process_Resrc_Require;
4286:
4287: END AHL_PP_RESRC_Require_PVT;