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: null;
11: end;

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

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

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

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

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

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

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

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

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

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

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

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

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

1116: L_txn_header_id NUMBER;
1117: L_txn_temp_id NUMBER;
1118:
1119: e_Invalid_Inputs EXCEPTION;
1120: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1121: BEGIN
1122:
1123: -- Standard start of API savepoint
1124: SAVEPOINT Process_LPN_CountRequest;