APPS.EAM_MTL_TXN_PROCESS dependencies on FND_LOG

Line 64: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

60: l_proc_mode number := 1;
61: l_api_name CONSTANT VARCHAR2(30) := 'processmtltxn';
62: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
63: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
64: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
65: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
66: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
67: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
68: l_mti_qty number;

Line 65: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;

61: l_api_name CONSTANT VARCHAR2(30) := 'processmtltxn';
62: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
63: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
64: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
65: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
66: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
67: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
68: l_mti_qty number;
69: l_qty_issued number;

Line 66: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;

62: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
63: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
64: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
65: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
66: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
67: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
68: l_mti_qty number;
69: l_qty_issued number;
70: l_remain_qty number;

Line 67: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;

63: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
64: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
65: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
66: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
67: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
68: l_mti_qty number;
69: l_qty_issued number;
70: l_remain_qty number;
71: l_tx_mode number;

Line 163: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

159:
160: Begin
161:
162: if (l_plog) then
163: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
164: 'Start of ' || l_module || '('
165: || 'p_txn_header_id='|| p_txn_header_id || ',p_item_id='|| p_item_id
166: || ',p_trx_type_id='|| p_trx_type_id || ',p_trx_src_id='|| p_trx_src_id
167: || ',p_operation_seq_num='|| p_operation_seq_num

Line 233: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

229: select quantity_issued into l_qty_issued
230: from wip_requirement_operations
231: where wip_entity_id = p_trx_src_id
232: and inventory_item_id = p_item_id;
233: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
234: 'Qty to return in MTI='|| l_mti_qty|| ', Qty to return by user='
235: || p_trx_qty|| ', Qty issued to job=' || l_qty_issued);
236: end if;
237: l_remain_qty := l_qty_issued - l_mti_qty;

Line 414: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

410: select mtl_material_transactions_s.nextval into INV_TRANSACTIONS.G_Serial_ID
411: from dual;
412: end if;
413:
414: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
415: 'Inserting into MTI with Tx Header ID=' || x_header_id);
416: end if;
417: /* Calling the Inventory Transaction API to insert data into MTI table .*/
418:

Line 748: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

744:
745: if(p_wip_process = 1) then
746: -- only call txn processor if online processing. 4(form level) is treated as 1.
747: if (l_tx_mode in (1,4)) then
748: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
749: 'Calling tx processor: INV_TXN_MANAGER_PUB.process_Transactions');
750: end if;
751: x_inv_ret_status := INV_TXN_MANAGER_PUB.process_Transactions(
752: p_api_version => 1.0,

Line 760: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

756: x_msg_count => x_mssg_count,
757: x_msg_data => x_error_mssg,
758: x_trans_count => x_trans_count
759: );
760: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
761: 'INV_TXN_MANAGER_PUB.process_Transactions returned. '||
762: 'Return status:'|| x_wip_ret_status);
763: end if;
764: if(x_wip_ret_status = FND_API.G_RET_STS_UNEXP_ERROR OR

Line 767: if (l_log) then FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module,

763: end if;
764: if(x_wip_ret_status = FND_API.G_RET_STS_UNEXP_ERROR OR
765: x_wip_ret_status = FND_API.G_RET_STS_ERROR OR
766: x_inv_ret_status <> 0) then
767: if (l_log) then FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module,
768: 'INV_TXN_MANAGER_PUB.process_Transactions returned a error. '||
769: 'Return message:'|| x_error_mssg);
770: end if;
771: x_error_flag := 2;