DBA Data[Home] [Help]

APPS.WSM_MES_UTILITIES_PVT dependencies on FND_LOG

Line 4: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;

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 ;
6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;

Line 5: g_log_level_error number := FND_LOG.LEVEL_ERROR ;

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 ;
6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
9: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;

Line 6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;

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 ;
6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
9: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
10:

Line 7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;

3: --mes
4: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
5: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
9: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
10:
11: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;

Line 8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;

4: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
5: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
9: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
10:
11: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
12: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;

Line 9: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;

5: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
6: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
7: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
8: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
9: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
10:
11: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
12: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
13: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;

Line 51: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

47: l_move_next_option number := 0;
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;

Line 59: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN

55: l_return_code NUMBER;
56: l_error_msg VARCHAR2(4000);
57:
58: begin
59: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
60: l_param_tbl.delete;
61: l_param_tbl(1).paramName := 'p_responsibility_id';
62: l_param_tbl(1).paramValue := p_responsibility_id;
63: l_param_tbl(2).paramName := 'p_wip_entity_id';

Line 79: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE

75:
76: WSM_Log_PVT.logProcParams(
77: p_module_name => l_module,
78: p_param_tbl => l_param_tbl,
79: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
80: );
81: END IF;
82:
83: if (p_job_op_seq_num IS NULL or p_status_type = 6) then

Line 238: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

234: l_max_wlt_txn_date date; -- bugfix 5471833
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;

Line 246: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN

242: l_return_code NUMBER;
243: l_error_msg VARCHAR2(4000);
244:
245: begin
246: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
247: l_param_tbl.delete;
248: l_param_tbl(1).paramName := 'p_transaction_type';
249: l_param_tbl(1).paramValue := p_transaction_type;
250: l_param_tbl(2).paramName := 'p_responsibility_id';

Line 268: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE

264:
265: WSM_Log_PVT.logProcParams(
266: p_module_name => l_module,
267: p_param_tbl => l_param_tbl,
268: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
269: );
270: END IF;
271:
272: /* Bugfix 5441529 cannot transact on jobs which failed upgrade */

Line 647: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

643: l_job_name varchar2(100);
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;

Line 655: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN

651: l_return_code NUMBER;
652: l_error_msg VARCHAR2(4000);
653:
654: begin
655: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
656: l_param_tbl.delete;
657: l_param_tbl(1).paramName := 'p_wip_entity_id';
658: l_param_tbl(1).paramValue := p_wip_entity_id;
659: l_param_tbl(2).paramName := 'p_job_op_seq_num';

Line 673: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE

669:
670: WSM_Log_PVT.logProcParams(
671: p_module_name => l_module,
672: p_param_tbl => l_param_tbl,
673: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
674: );
675: END IF;
676:
677: if ((p_job_op_seq_num IS NULL ) OR

Line 874: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

870: l_org_id number;
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

Line 879: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN

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
880: l_param_tbl.delete;
881: l_param_tbl(1).paramName := 'p_wip_entity_id';
882: l_param_tbl(1).paramValue := p_wip_entity_id;
883: l_param_tbl(2).paramName := 'p_txn_type';

Line 889: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE

885:
886: WSM_Log_PVT.logProcParams(
887: p_module_name => l_module,
888: p_param_tbl => l_param_tbl,
889: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
890: );
891: END IF;
892:
893: select organization_id,

Line 944: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

940:
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;

Line 952: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN

948: l_return_code NUMBER;
949: l_error_msg VARCHAR2(4000);
950:
951: begin
952: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
953: l_param_tbl.delete;
954: l_param_tbl(1).paramName := 'p_department_id';
955: l_param_tbl(1).paramValue := p_department_id;
956: l_param_tbl(1).paramName := 'p_resource_id';

Line 962: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE

958:
959: WSM_Log_PVT.logProcParams(
960: p_module_name => l_module,
961: p_param_tbl => l_param_tbl,
962: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
963: );
964: END IF;
965:
966: begin