DBA Data[Home] [Help]

APPS.AHL_PP_RESRC_ASSIGN_PVT dependencies on AHL_PP_RESRC_ASSIGN_PVT

Line 1: PACKAGE BODY AHL_PP_RESRC_ASSIGN_PVT AS

1: PACKAGE BODY AHL_PP_RESRC_ASSIGN_PVT AS
2: /* $Header: AHLVASGB.pls 120.11.12020000.2 2012/12/11 03:17:00 prakkum ship $*/
3:
4: -- Declare Constants --
5: -----------------------

Line 6: G_PKG_NAME VARCHAR2(30) := 'AHL_PP_RESRC_ASSIGN_PVT';

2: /* $Header: AHLVASGB.pls 120.11.12020000.2 2012/12/11 03:17:00 prakkum ship $*/
3:
4: -- Declare Constants --
5: -----------------------
6: G_PKG_NAME VARCHAR2(30) := 'AHL_PP_RESRC_ASSIGN_PVT';
7: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
8: -------------------------------------------------
9: -- Declare Locally used Record and Table Types --
10: -------------------------------------------------

Line 1001: -- p_x_resrc_assign_tbl IN OUT NOCOPY AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type,

997: -- x_msg_count OUT NUMBER Required
998: -- x_msg_data OUT VARCHAR2 Required
999: --
1000: -- Create Resource Assignment Parameters:
1001: -- p_x_resrc_assign_tbl IN OUT NOCOPY AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type,
1002: -- Contains Resource information to perform Resource reservation
1003: --
1004: -- Version :
1005: -- Initial Version 1.0

Line 1212: AHL_DEBUG_PUB.debug( 'Enter AHL_PP_RESRC_ASSIGN_PVT. Create_Resrc_Assign','+PPResrc_Assign_Pvt+');

1208: END IF;
1209:
1210: -- Debug info.
1211: IF G_DEBUG='Y' THEN
1212: AHL_DEBUG_PUB.debug( 'Enter AHL_PP_RESRC_ASSIGN_PVT. Create_Resrc_Assign','+PPResrc_Assign_Pvt+');
1213: END IF;
1214:
1215: -- Standard call to check for call compatibility.
1216: IF FND_API.to_boolean(p_init_msg_list)

Line 1942: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',

1938: ROLLBACK TO Create_Resrc_Assign;
1939: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1941: THEN
1942: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
1943: p_procedure_name => 'CREATE_Resrc_Assign',
1944: p_error_text => SUBSTR(SQLERRM,1,240));
1945: END IF;
1946: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1988: -- p_x_resrc_assign_tbl IN OUT NOCOPY AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type,

1984: -- x_msg_count OUT NUMBER Required
1985: -- x_msg_data OUT VARCHAR2 Required
1986: --
1987: -- Update Resource Assignment Parameters:
1988: -- p_x_resrc_assign_tbl IN OUT NOCOPY AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type,
1989: -- Contains Resource information to perform Resource reservation
1990: --
1991: -- Version :
1992: -- Initial Version 1.0

Line 2883: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',

2879: ROLLBACK TO update_Resrc_Assign;
2880: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2882: THEN
2883: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
2884: p_procedure_name => 'UPDATE_Resrc_Assign',
2885: p_error_text => SUBSTR(SQLERRM,1,240));
2886: END IF;
2887: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3164: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',

3160: ROLLBACK TO remove_Resource_Assignment;
3161: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3162: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3163: THEN
3164: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
3165: p_procedure_name => 'REMOVE_Resource_Assignment',
3166: p_error_text => SUBSTR(SQLERRM,1,240));
3167: END IF;
3168: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 3205: -- p_x_resrc_assign_tbl IN OUT NOCOPY AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type,

3201: -- x_msg_count OUT NUMBER Required
3202: -- x_msg_data OUT VARCHAR2 Required
3203: --
3204: -- Process Resource Assignment Parameters:
3205: -- p_x_resrc_assign_tbl IN OUT NOCOPY AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type,
3206: -- Contains........................ on operation flag
3207: --
3208: -- Version :
3209: -- Initial Version 1.0

Line 3220: p_x_resrc_assign_tbl IN OUT NOCOPY AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type,

3216: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
3217: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
3218: p_module_type IN VARCHAR2 := NULL,
3219: p_operation_flag IN VARCHAR2,
3220: p_x_resrc_assign_tbl IN OUT NOCOPY AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_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 3231: l_resrc_Assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

3227: l_api_version CONSTANT NUMBER := 1.0;
3228: l_msg_count NUMBER;
3229: l_return_status VARCHAR2(1);
3230: l_msg_data VARCHAR2(2000);
3231: l_resrc_Assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
3232:
3233: BEGIN
3234: --------------------Initialize ----------------------------------
3235: -- Standard Start of API savepoint

Line 3377: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',

3373: ROLLBACK TO Process_Resrc_Assign;
3374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3375: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3376: THEN
3377: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
3378: p_procedure_name => 'Process_Resrc_Assign',
3379: p_error_text => SUBSTR(SQLERRM,1,240));
3380: END IF;
3381: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3393: END AHL_PP_RESRC_ASSIGN_PVT;

3389: AHL_DEBUG_PUB.disable_debug;
3390: END IF;
3391: END Process_Resrc_Assign;
3392:
3393: END AHL_PP_RESRC_ASSIGN_PVT;