APPS.EAM_ASSET_MOVE_UTIL dependencies on FND_LOG

Line 22: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

18:
19: --logging variables
20: l_api_name constant VARCHAR2(30) := 'isValidMove';
21: l_module VARCHAR2(200);
22: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
23: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
24: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
25: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
26: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 23: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

19: --logging variables
20: l_api_name constant VARCHAR2(30) := 'isValidMove';
21: l_module VARCHAR2(200);
22: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
23: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
24: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
25: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
26: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
27: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 24: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

20: l_api_name constant VARCHAR2(30) := 'isValidMove';
21: l_module VARCHAR2(200);
22: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
23: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
24: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
25: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
26: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
27: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
28:

Line 25: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

21: l_module VARCHAR2(200);
22: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
23: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
24: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
25: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
26: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
27: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
28:
29:

Line 26: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

22: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
23: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
24: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
25: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
26: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
27: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
28:
29:
30:

Line 38: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);

34: l_module := 'eam.plsql.'|| l_full_name;
35: END IF;
36:
37: IF (l_plog) THEN
38: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
39: END IF;
40:
41: if(eam_asset_move_util.isOpenPeriod(p_curr_org_id,p_transaction_date)) then
42: isValidMove := 'Y';

Line 105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);

101: x_return_status := 'N';
102: END IF;
103:
104: IF (l_plog) THEN
105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
106: END IF;
107:
108: END isValidMove;
109:

Line 123: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

119: isValidMove varchar2(1) := 'N';
120: --logging variables
121: l_api_name constant VARCHAR2(30) := 'isValidAssetMove';
122: l_module VARCHAR2(200);
123: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
124: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
125: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
126: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
127: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 124: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

120: --logging variables
121: l_api_name constant VARCHAR2(30) := 'isValidAssetMove';
122: l_module VARCHAR2(200);
123: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
124: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
125: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
126: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
127: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
128: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 125: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

121: l_api_name constant VARCHAR2(30) := 'isValidAssetMove';
122: l_module VARCHAR2(200);
123: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
124: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
125: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
126: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
127: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
128: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
129:

Line 126: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

122: l_module VARCHAR2(200);
123: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
124: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
125: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
126: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
127: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
128: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
129:
130:

Line 127: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

123: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
124: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
125: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
126: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
127: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
128: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
129:
130:
131: BEGIN

Line 137: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name||'for'||p_asset_hierarchy_REC.instance_id);

133: IF (l_ulog) THEN
134: l_module := 'eam.plsql.'|| l_full_name;
135: END IF;
136: IF (l_plog) THEN
137: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name||'for'||p_asset_hierarchy_REC.instance_id);
138: END IF;
139: IF(p_counter<>1) THEN
140: IF(isInMaintOrg(p_asset_hierarchy_REC.instance_id
141: ,p_asset_hierarchy_REC.current_org_id

Line 169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name||'for'||p_asset_hierarchy_REC.instance_id);

165: -- x_return_message:='Is valid Move';
166: --Dbms_Output.put_line('calling isValidAssetMoveProcedure');
167:
168: IF (l_plog) THEN
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name||'for'||p_asset_hierarchy_REC.instance_id);
170: END IF;
171:
172: eam_asset_move_util.isValidMove(p_asset_hierarchy_REC.instance_id,
173: sysdate ,

Line 214: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

210:
211: --logging variables
212: l_api_name constant VARCHAR2(30) := 'isOpenPeriod';
213: l_module VARCHAR2(200);
214: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
215: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
216: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
217: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
218: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 215: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

211: --logging variables
212: l_api_name constant VARCHAR2(30) := 'isOpenPeriod';
213: l_module VARCHAR2(200);
214: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
215: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
216: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
217: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
218: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
219: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 216: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

212: l_api_name constant VARCHAR2(30) := 'isOpenPeriod';
213: l_module VARCHAR2(200);
214: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
215: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
216: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
217: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
218: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
219: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
220:

Line 217: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

213: l_module VARCHAR2(200);
214: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
215: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
216: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
217: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
218: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
219: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
220:
221:

Line 218: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

214: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
215: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
216: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
217: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
218: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
219: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
220:
221:
222: BEGIN

Line 229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);

225: l_module := 'eam.plsql.'|| l_full_name;
226: END IF;
227:
228: IF (l_plog) THEN
229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
230: END IF;
231:
232: --Dbms_Output.put_line('Processing isOpenPeriod');
233: l_open_past_period :=FALSE ; /*important FOR TIME being 4th parameter IS made NULL*/

Line 243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);

239: return FALSE;
240: END IF;
241:
242: IF (l_plog) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
244: END IF;
245: end isOpenPeriod;
246:
247:

Line 258: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

254: l_flag varchar2(30);
255: --logging variables
256: l_api_name constant VARCHAR2(30) := 'isTransactable';
257: l_module VARCHAR2(200);
258: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
259: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
260: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
261: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
262: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 259: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

255: --logging variables
256: l_api_name constant VARCHAR2(30) := 'isTransactable';
257: l_module VARCHAR2(200);
258: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
259: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
260: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
261: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
262: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
263: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 260: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

256: l_api_name constant VARCHAR2(30) := 'isTransactable';
257: l_module VARCHAR2(200);
258: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
259: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
260: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
261: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
262: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
263: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
264:

Line 261: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

257: l_module VARCHAR2(200);
258: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
259: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
260: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
261: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
262: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
263: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
264:
265:

Line 262: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

258: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
259: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
260: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
261: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
262: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
263: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
264:
265:
266: BEGIN

Line 273: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);

269: l_module := 'eam.plsql.'|| l_full_name;
270: END IF;
271:
272: IF (l_plog) THEN
273: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
274: END IF;
275: --Dbms_Output.put_line('Processing isTransactable');
276:
277: BEGIN

Line 295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);

291: END IF;
292:
293:
294: IF (l_plog) THEN
295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
296: END IF;
297:
298: END isTransactable;
299:

Line 311: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

307: l_subinv_code csi_item_instances.inv_subinventory_name%TYPE;
308: --logging variables
309: l_api_name constant VARCHAR2(30) := 'hasSubInventory';
310: l_module VARCHAR2(200);
311: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
312: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
313: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
314: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
315: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 312: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

308: --logging variables
309: l_api_name constant VARCHAR2(30) := 'hasSubInventory';
310: l_module VARCHAR2(200);
311: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
312: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
313: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
314: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
315: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
316: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 313: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

309: l_api_name constant VARCHAR2(30) := 'hasSubInventory';
310: l_module VARCHAR2(200);
311: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
312: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
313: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
314: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
315: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
316: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
317:

Line 314: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

310: l_module VARCHAR2(200);
311: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
312: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
313: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
314: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
315: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
316: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
317:
318:

Line 315: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

311: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
312: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
313: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
314: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
315: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
316: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
317:
318:
319: BEGIN

Line 326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);

322: l_module := 'eam.plsql.'|| l_full_name;
323: END IF;
324:
325: IF (l_plog) THEN
326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
327: END IF;
328: --Dbms_Output.put_line('Processing hasSubInventory');
329:
330: BEGIN

Line 350: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);

346:
347: END IF;
348:
349: IF (l_plog) THEN
350: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
351: END IF;
352:
353: END hasSubInventory;
354:

Line 366: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

362: l_location_id NUMBER;
363: --logging variables
364: l_api_name constant VARCHAR2(30) := 'isLocated';
365: l_module VARCHAR2(200);
366: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
367: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
368: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
369: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
370: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 367: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

363: --logging variables
364: l_api_name constant VARCHAR2(30) := 'isLocated';
365: l_module VARCHAR2(200);
366: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
367: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
368: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
369: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
370: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
371: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 368: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

364: l_api_name constant VARCHAR2(30) := 'isLocated';
365: l_module VARCHAR2(200);
366: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
367: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
368: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
369: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
370: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
371: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
372:

Line 369: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

365: l_module VARCHAR2(200);
366: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
367: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
368: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
369: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
370: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
371: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
372:
373:

Line 370: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

366: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
367: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
368: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
369: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
370: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
371: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
372:
373:
374: BEGIN

Line 381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);

377: l_module := 'eam.plsql.'|| l_full_name;
378: END IF;
379:
380: IF (l_plog) THEN
381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
382: END IF;
383: -- Dbms_Output.put_line('Processing isLocated');
384:
385: BEGIN

Line 403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);

399:
400: END IF;
401:
402: IF (l_plog) THEN
403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
404: END IF;
405:
406: END isLocated;
407:

Line 420: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

416:
417: --logging variables
418: l_api_name constant VARCHAR2(30) := 'isInTransit';
419: l_module VARCHAR2(200);
420: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
421: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
422: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
423: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
424: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 421: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

417: --logging variables
418: l_api_name constant VARCHAR2(30) := 'isInTransit';
419: l_module VARCHAR2(200);
420: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
421: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
422: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
423: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
424: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
425: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 422: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

418: l_api_name constant VARCHAR2(30) := 'isInTransit';
419: l_module VARCHAR2(200);
420: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
421: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
422: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
423: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
424: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
425: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
426:

Line 423: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

419: l_module VARCHAR2(200);
420: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
421: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
422: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
423: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
424: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
425: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
426:
427:

Line 424: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

420: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
421: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
422: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
423: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
424: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
425: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
426:
427:
428: BEGIN

Line 435: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);

431: l_module := 'eam.plsql.'|| l_full_name;
432: END IF;
433:
434: IF (l_plog) THEN
435: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
436: END IF;
437: --Dbms_Output.put_line('Processing isInTransit');
438:
439: BEGIN

Line 458: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);

454: ELSE RETURN FALSE;
455: END IF;
456:
457: IF (l_plog) THEN
458: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
459: END IF;
460:
461: END isInTransit;
462:

Line 472: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

468: l_network_asset_flag varchar2(1);
469: --logging variables
470: l_api_name constant VARCHAR2(30) := 'isAssetRoute';
471: l_module VARCHAR2(200);
472: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
473: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
474: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
475: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
476: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 473: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

469: --logging variables
470: l_api_name constant VARCHAR2(30) := 'isAssetRoute';
471: l_module VARCHAR2(200);
472: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
473: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
474: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
475: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
476: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
477: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 474: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

470: l_api_name constant VARCHAR2(30) := 'isAssetRoute';
471: l_module VARCHAR2(200);
472: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
473: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
474: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
475: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
476: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
477: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
478:

Line 475: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

471: l_module VARCHAR2(200);
472: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
473: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
474: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
475: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
476: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
477: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
478:
479:

Line 476: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

472: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
473: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
474: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
475: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
476: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
477: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
478:
479:
480: BEGIN

Line 487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);

483: l_module := 'eam.plsql.'|| l_full_name;
484: END IF;
485:
486: IF (l_plog) THEN
487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
488: END IF;
489:
490: -- Dbms_Output.put_line('Processing isAssetRoute');
491: BEGIN

Line 508: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);

504: ELSE RETURN FALSE;
505: END IF;
506:
507: IF (l_plog) THEN
508: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
509: END IF;
510: END isAssetRoute;
511:
512:

Line 523: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

519: l_EQUIPMENT_GEN_OBJECT_ID NUMBER;
520: --logging variables
521: l_api_name constant VARCHAR2(30) := 'hasProdEquipLink';
522: l_module VARCHAR2(200);
523: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
524: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
525: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
526: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
527: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 524: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

520: --logging variables
521: l_api_name constant VARCHAR2(30) := 'hasProdEquipLink';
522: l_module VARCHAR2(200);
523: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
524: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
525: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
526: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
527: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
528: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 525: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

521: l_api_name constant VARCHAR2(30) := 'hasProdEquipLink';
522: l_module VARCHAR2(200);
523: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
524: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
525: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
526: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
527: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
528: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
529:

Line 526: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

522: l_module VARCHAR2(200);
523: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
524: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
525: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
526: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
527: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
528: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
529:
530:

Line 527: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

523: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
524: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
525: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
526: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
527: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
528: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
529:
530:
531: BEGIN

Line 538: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);

534: l_module := 'eam.plsql.'|| l_full_name;
535: END IF;
536:
537: IF (l_plog) THEN
538: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
539: END IF;
540:
541: --Dbms_Output.put_line('Processing hasProdEquipLink');
542:

Line 563: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);

559: END IF;
560: --Dbms_Output.put_line('Completed Processing hasProdEquipLink');
561:
562: IF (l_plog) THEN
563: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
564: END IF;
565:
566:
567: END hasProdEquipLink;

Line 580: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

576: l_location_id Number;
577: --logging variables
578: l_api_name constant VARCHAR2(30) := 'hasPropMngrLink';
579: l_module VARCHAR2(200);
580: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
581: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
582: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
583: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
584: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 581: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

577: --logging variables
578: l_api_name constant VARCHAR2(30) := 'hasPropMngrLink';
579: l_module VARCHAR2(200);
580: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
581: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
582: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
583: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
584: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
585: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 582: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

578: l_api_name constant VARCHAR2(30) := 'hasPropMngrLink';
579: l_module VARCHAR2(200);
580: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
581: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
582: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
583: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
584: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
585: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
586:

Line 583: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

579: l_module VARCHAR2(200);
580: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
581: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
582: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
583: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
584: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
585: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
586:
587:

Line 584: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

580: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
581: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
582: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
583: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
584: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
585: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
586:
587:
588: BEGIN

Line 595: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);

591: l_module := 'eam.plsql.'|| l_full_name;
592: END IF;
593:
594: IF (l_plog) THEN
595: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
596: END IF;
597:
598: --Dbms_Output.put_line('Processing hasPropMngrLink');
599:

Line 616: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);

612: ELSE RETURN FALSE;
613: END IF;
614:
615: IF (l_plog) THEN
616: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
617: END IF;
618:
619: END hasPropMngrLink;
620:

Line 639: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

635: l_organization_id NUMBER;
636: --logging variables
637: l_api_name constant VARCHAR2(30) := 'isInMaintOrg';
638: l_module VARCHAR2(200);
639: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
640: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
641: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
642: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
643: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 640: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

636: --logging variables
637: l_api_name constant VARCHAR2(30) := 'isInMaintOrg';
638: l_module VARCHAR2(200);
639: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
640: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
641: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
642: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
643: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
644: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 641: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

637: l_api_name constant VARCHAR2(30) := 'isInMaintOrg';
638: l_module VARCHAR2(200);
639: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
640: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
641: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
642: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
643: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
644: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
645:

Line 642: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

638: l_module VARCHAR2(200);
639: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
640: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
641: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
642: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
643: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
644: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
645:
646:

Line 643: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

639: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
640: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
641: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
642: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
643: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
644: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
645:
646:
647: BEGIN

Line 654: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);

650: l_module := 'eam.plsql.'|| l_full_name;
651: END IF;
652:
653: IF (l_plog) THEN
654: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
655: END IF;
656:
657: --Dbms_Output.put_line('Processing isInMaintOrg');
658:

Line 719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);

715:
716: END IF;
717:
718: IF (l_plog) THEN
719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
720: END IF;
721:
722: END isInMaintOrg;
723:

Line 736: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

732:
733: --logging variables
734: l_api_name constant VARCHAR2(30) := 'isItemAssigned';
735: l_module VARCHAR2(200);
736: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
737: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
738: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
739: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
740: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 737: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

733: --logging variables
734: l_api_name constant VARCHAR2(30) := 'isItemAssigned';
735: l_module VARCHAR2(200);
736: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
737: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
738: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
739: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
740: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
741: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 738: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

734: l_api_name constant VARCHAR2(30) := 'isItemAssigned';
735: l_module VARCHAR2(200);
736: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
737: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
738: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
739: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
740: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
741: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
742:

Line 739: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

735: l_module VARCHAR2(200);
736: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
737: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
738: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
739: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
740: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
741: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
742:
743:

Line 740: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

736: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
737: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
738: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
739: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
740: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
741: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
742:
743:
744: BEGIN

Line 751: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);

747: l_module := 'eam.plsql.'|| l_full_name;
748: END IF;
749:
750: IF (l_plog) THEN
751: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
752: END IF;
753: --Dbms_Output.put_line('Processing isItemAssigned');
754:
755: BEGIN

Line 777: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);

773: RETURN FALSE;
774: END IF ;
775:
776: IF (l_plog) THEN
777: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
778: END IF;
779: END isItemAssigned;
780:
781:

Line 791: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

787: l_shipment_number NUMBER;
788: --logging variables
789: l_api_name constant VARCHAR2(30) := 'isUniqueShipmentNumber';
790: l_module VARCHAR2(200);
791: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
792: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
793: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
794: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
795: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 792: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

788: --logging variables
789: l_api_name constant VARCHAR2(30) := 'isUniqueShipmentNumber';
790: l_module VARCHAR2(200);
791: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
792: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
793: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
794: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
795: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
796: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 793: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

789: l_api_name constant VARCHAR2(30) := 'isUniqueShipmentNumber';
790: l_module VARCHAR2(200);
791: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
792: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
793: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
794: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
795: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
796: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
797:

Line 794: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

790: l_module VARCHAR2(200);
791: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
792: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
793: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
794: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
795: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
796: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
797:
798:

Line 795: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

791: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
792: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
793: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
794: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
795: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
796: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
797:
798:
799: BEGIN

Line 806: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);

802: l_module := 'eam.plsql.'|| l_full_name;
803: END IF;
804:
805: IF (l_plog) THEN
806: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
807: END IF;
808: --Dbms_Output.put_line('Processing isUniqueShipmentNumber');
809:
810: IF((INVTTMTX.ship_number_validation(p_shipment_number))=1) THEN

Line 817: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);

813: RETURN FALSE;
814: END IF;
815:
816: IF (l_plog) THEN
817: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
818: END IF;
819: END isUniqueShipmentNumber;
820:
821: FUNCTION translate_message(