DBA Data[Home] [Help]

APPS.WSM_MES_UTILITIES_PVT dependencies on WSM_MES_UTILITIES_PVT

Line 1: PACKAGE BODY WSM_MES_UTILITIES_PVT AS

1: PACKAGE BODY WSM_MES_UTILITIES_PVT AS
2: /* $Header: WSMMESUB.pls 120.26 2006/08/22 06:46:54 nlal noship $ */
3: --mes
4: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
5: g_log_level_error number := FND_LOG.LEVEL_ERROR ;

Line 52: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.move_txn_allowed';

48:
49: -- Logging variables.....
50: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
51: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.move_txn_allowed';
53: l_param_tbl WSM_Log_PVT.param_tbl_type;
54: l_error_count NUMBER;
55: l_return_code NUMBER;
56: l_error_msg VARCHAR2(4000);

Line 239: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.wsm_transaction_allowed';

235:
236: -- Logging variables.....
237: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
238: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
239: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.wsm_transaction_allowed';
240: l_param_tbl WSM_Log_PVT.param_tbl_type;
241: l_error_count NUMBER;
242: l_return_code NUMBER;
243: l_error_msg VARCHAR2(4000);

Line 648: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.wsm_job_changed';

644:
645: -- Logging variables.....
646: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
647: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
648: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.wsm_job_changed';
649: l_param_tbl WSM_Log_PVT.param_tbl_type;
650: l_error_count NUMBER;
651: l_return_code NUMBER;
652: l_error_msg VARCHAR2(4000);

Line 875: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.check_po_req_exists';

871:
872: -- Logging variables.....
873: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
874: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
875: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.check_po_req_exists';
876: l_param_tbl WSM_Log_PVT.param_tbl_type;
877:
878: begin
879: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN

Line 945: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.get_share_from_dept';

941: l_share_from_dept NUMBER;
942: -- Logging variables.....
943: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
944: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
945: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_MES_UTILITIES_PVT.get_share_from_dept';
946: l_param_tbl WSM_Log_PVT.param_tbl_type;
947: l_error_count NUMBER;
948: l_return_code NUMBER;
949: l_error_msg VARCHAR2(4000);