APPS.MTL_CCEOI_ACTION_PUB dependencies on FND_PROFILE

Line 7: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_CCEOI_ACTION_PUB';
4:
5: procedure mdebug(msg in varchar2)
6: is
7: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8: begin
9: --dbms_output.put_line(msg);
10: inv_log_util.trace(msg , g_pkg_name || ' ',9);
11:

Line 35: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

31:
32: p_cei_id NUMBER := -1;
33: counter number := 0;
34:
35: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
36: begin
37: for c_rec in l_mcei_csr(mtl_cceoi_var_pvt.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID) loop
38: p_cei_id := c_rec.cc_entry_interface_id;
39: counter := counter + 1;

Line 51: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

47: end;
48:
49: PROCEDURE Unlock_CCI_Row(p_iface_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2)
50: IS
51: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
52: BEGIN
53: x_return_status := fnd_api.g_ret_sts_success;
54:
55: update mtl_cc_entries_interface

Line 82: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

78: (
79: x_iface_rec IN OUT NOCOPY MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE,
80: p_cce_rec IN MTL_CYCLE_COUNT_ENTRIES%ROWTYPE )
81: IS
82: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
83: BEGIN
84:
85: -- organization
86: x_iface_rec.organization_id := p_cce_rec.organization_id;

Line 235: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

231: for update of export_flag;
232:
233: counter number := 0;
234:
235: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
236: BEGIN
237: SAVEPOINT Enforce_SKU_CountEntry_Match;
238: --
239: -- Standard Call to check for call compatibility

Line 473: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

469: for update of lock_flag;
470:
471: counter NUMBER := 0;
472:
473: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
474: BEGIN
475:
476: SAVEPOINT Initial_Insert;
477: --

Line 746: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

742:
743: l_return_status VARCHAR2(1);
744: l_result NUMBER;
745:
746: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
747: BEGIN
748: -- Start OF comments
749: -- API name : Import_CountRequest
750: -- TYPE : Public

Line 1124: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1120: l_lpn_context NUMBER;
1121: flag NUMBER; --8712932
1122:
1123: e_Invalid_Inputs EXCEPTION;
1124: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1125: BEGIN
1126:
1127: MTL_CCEOI_VAR_PVT.G_LPN_ID := NULL;
1128: -- Standard start of API savepoint