APPS.EAM_MTL_TXN_PROCESS dependencies on FND_LOG

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

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

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

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

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

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

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

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

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

77:
78: Begin
79:
80: if (l_plog) then
81: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
82: 'Start of ' || l_module || '('
83: || 'p_txn_header_id='|| p_txn_header_id || ',p_item_id='|| p_item_id
84: || ',p_trx_type_id='|| p_trx_type_id || ',p_trx_src_id='|| p_trx_src_id
85: || ',p_operation_seq_num='|| p_operation_seq_num

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

147: select quantity_issued into l_qty_issued
148: from wip_requirement_operations
149: where wip_entity_id = p_trx_src_id
150: and inventory_item_id = p_item_id;
151: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
152: 'Qty to return in MTI='|| l_mti_qty|| ', Qty to return by user='
153: || p_trx_qty|| ', Qty issued to job=' || l_qty_issued);
154: end if;
155: l_remain_qty := l_qty_issued - l_mti_qty;

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

312: select mtl_material_transactions_s.nextval into INV_TRANSACTIONS.G_Serial_ID
313: from dual;
314: end if;
315:
316: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
317: 'Inserting into MTI with Tx Header ID=' || x_header_id);
318: end if;
319: /* Calling the Inventory Transaction API to insert data into MTI table .*/
320:

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

412:
413: if(p_wip_process = 1) then
414: -- only call txn processor if online processing. 4(form level) is treated as 1.
415: if (l_tx_mode in (1,4)) then
416: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
417: 'Calling tx processor: INV_TXN_MANAGER_PUB.process_Transactions');
418: end if;
419: x_inv_ret_status := INV_TXN_MANAGER_PUB.process_Transactions(
420: p_api_version => 1.0,

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

424: x_msg_count => x_mssg_count,
425: x_msg_data => x_error_mssg,
426: x_trans_count => x_trans_count
427: );
428: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
429: 'INV_TXN_MANAGER_PUB.process_Transactions returned. '||
430: 'Return status:'|| x_wip_ret_status);
431: end if;
432: if(x_wip_ret_status = FND_API.G_RET_STS_UNEXP_ERROR OR

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

431: end if;
432: if(x_wip_ret_status = FND_API.G_RET_STS_UNEXP_ERROR OR
433: x_wip_ret_status = FND_API.G_RET_STS_ERROR OR
434: x_inv_ret_status <> 0) then
435: if (l_log) then FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module,
436: 'INV_TXN_MANAGER_PUB.process_Transactions returned a error. '||
437: 'Return message:'|| x_error_mssg);
438: end if;
439: x_error_flag := 2;