DBA Data[Home] [Help]

APPS.AHL_WORKORDER_SEARCH_PUB dependencies on AHL_WORKORDER_SEARCH_PUB

Line 1: PACKAGE BODY AHL_WORKORDER_SEARCH_PUB AS

1: PACKAGE BODY AHL_WORKORDER_SEARCH_PUB AS
2: /* $Header: AHLPWSOB.pls 120.0.12010000.2 2008/11/30 22:00:58 sikumar noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_WORKORDER_SEARCH_PUB';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_WORKORDER_SEARCH_PUB';

1: PACKAGE BODY AHL_WORKORDER_SEARCH_PUB AS
2: /* $Header: AHLPWSOB.pls 120.0.12010000.2 2008/11/30 22:00:58 sikumar noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_WORKORDER_SEARCH_PUB';
5:
6: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
7: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_WORKORDER_SEARCH_PUB';
8:

Line 7: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_WORKORDER_SEARCH_PUB';

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_WORKORDER_SEARCH_PUB';
5:
6: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
7: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_WORKORDER_SEARCH_PUB';
8:
9: G_BPEL_USER_ROLE_KEY VARCHAR2(240) := 'AHL_PRD_TECH_RESP';--FND_PROFILE.VALUE('AHL_BPEL_USER_ROLE');
10:
11: FUNCTION init_user_and_role(p_user_id IN VARCHAR2) RETURN VARCHAR2 IS

Line 96: l_api_name,'AHL_WORKORDER_SEARCH_PUB')

92:
93: -- Standard call to check for call compatibility.
94: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
95: p_api_version,
96: l_api_name,'AHL_WORKORDER_SEARCH_PUB')
97: THEN
98: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:

Line 500: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'AHL_WORKORDER_SEARCH_PUB',

496: WHEN OTHERS THEN
497: -- dbms_output.put_line(' OTHERS ');
498: ROLLBACK TO Search_Work_Orders;
499: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
500: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'AHL_WORKORDER_SEARCH_PUB',
501: p_procedure_name => 'Get_Workorder_Search_Results',
502: p_error_text => SQLERRM);
503:
504: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

Line 510: END AHL_WORKORDER_SEARCH_PUB;

506: p_encoded => Fnd_Api.g_false);
507:
508: END get_wo_search_results;
509:
510: END AHL_WORKORDER_SEARCH_PUB;