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.3.12020000.2 2012/12/10 16:38:34 prakkum ship $ */
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.3.12020000.2 2012/12/10 16:38:34 prakkum ship $ */
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:
10: -- Assigned Work Order Query---------------------------
11:

Line 72: l_api_name,'AHL_WORKORDER_SEARCH_PUB')

68:
69: -- Standard call to check for call compatibility.
70: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
71: p_api_version,
72: l_api_name,'AHL_WORKORDER_SEARCH_PUB')
73: THEN
74: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76:

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

479: WHEN OTHERS THEN
480: -- dbms_output.put_line(' OTHERS ');
481: ROLLBACK TO Search_Work_Orders;
482: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
483: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'AHL_WORKORDER_SEARCH_PUB',
484: p_procedure_name => 'Get_Workorder_Search_Results',
485: p_error_text => SQLERRM);
486:
487: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

Line 493: END AHL_WORKORDER_SEARCH_PUB;

489: p_encoded => Fnd_Api.g_false);
490:
491: END get_wo_search_results;
492:
493: END AHL_WORKORDER_SEARCH_PUB;