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.10 2008/02/29 03:13:14 sracha ship $*/
3:
4: -- Declare Constants --
5: -----------------------

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

2: /* $Header: AHLVASGB.pls 120.10 2008/02/29 03:13:14 sracha 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 999: -- p_x_resrc_assign_tbl IN OUT NOCOPY AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type,

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3218: p_x_resrc_assign_tbl IN OUT NOCOPY AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type,

3214: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
3215: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
3216: p_module_type IN VARCHAR2 := NULL,
3217: p_operation_flag IN VARCHAR2,
3218: p_x_resrc_assign_tbl IN OUT NOCOPY AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type,
3219: x_return_status OUT NOCOPY VARCHAR2,
3220: x_msg_count OUT NOCOPY NUMBER,
3221: x_msg_data OUT NOCOPY VARCHAR2
3222: )

Line 3229: l_resrc_Assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

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

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

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

Line 3391: END AHL_PP_RESRC_ASSIGN_PVT;

3387: AHL_DEBUG_PUB.disable_debug;
3388: END IF;
3389: END Process_Resrc_Assign;
3390:
3391: END AHL_PP_RESRC_ASSIGN_PVT;