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;
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;
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:
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:
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:
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';
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:
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;
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;
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:
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:
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
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
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 ,
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;
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;
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:
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:
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
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*/
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:
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;
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;
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:
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:
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
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
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:
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;
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;
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:
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:
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
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
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:
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;
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;
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:
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:
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
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
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:
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;
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;
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:
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:
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
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
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:
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;
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;
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:
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:
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
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
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:
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;
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;
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:
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:
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
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:
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;
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;
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;
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:
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:
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
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:
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:
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;
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;
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:
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:
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
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:
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:
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;
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;
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:
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:
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
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
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:
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;
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;
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:
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:
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
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
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(