eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_ASSET_MOVE_PUB dependencies on FND_LOG

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

36:
37: --logging variables
38: l_api_name constant VARCHAR2(30) := 'prepareMoveAsset';
39: l_module VARCHAR2(200);
40: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
41: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
42: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
43: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
44: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

37: --logging variables
38: l_api_name constant VARCHAR2(30) := 'prepareMoveAsset';
39: l_module VARCHAR2(200);
40: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
41: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
42: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
43: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
44: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
45: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

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

38: l_api_name constant VARCHAR2(30) := 'prepareMoveAsset';
39: l_module VARCHAR2(200);
40: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
41: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
42: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
43: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
44: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
45: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
46: l_eam_asset_move_count NUMBER;

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

39: l_module VARCHAR2(200);
40: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
41: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
42: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
43: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
44: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
45: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
46: l_eam_asset_move_count NUMBER;
47: --locator variables

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

40: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
41: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
42: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
43: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
44: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
45: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
46: l_eam_asset_move_count NUMBER;
47: --locator variables
48: x_locator_error_flag NUMBER;

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

60: l_module := 'eam.plsql.'|| l_full_name;
61: END IF;
62:
63: IF (l_plog) THEN
64: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
65: END IF;
66:
67:
68: DELETE FROM EAM_ASSET_MOVE_TEMP;

Line 71: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

67:
68: DELETE FROM EAM_ASSET_MOVE_TEMP;
69:
70: if (l_slog) then
71: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
72: 'Going to get the asset Hierarchy ');
73: end if;
74:
75: getAssetHierarchy( p_parent_instance_id,

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

77: l_asset_move_hierarchy_tbl,
78: p_curr_org_id );
79:
80: if (l_slog) then
81: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
82: 'Completed getting the asset Hierarchy ');
83: end if;
84:
85: IF (p_move_type <> 1) THEN

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

96: LOOP --should be done only for second to last rows.
97: --maint validation should not be done for first asset
98: --hence isItemAssigned validation for the first asset should be done from Controller Class itself
99: --bug 6966482
100: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
101: 'Processing asset ' || l_asset_move_hierarchy_tbl(i).instance_id );
102: end if;
103:
104: eam_asset_move_util.isValidAssetMove( l_asset_move_hierarchy_tbl(i)

Line 120: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

116: SELECT APPS.mtl_material_transactions_s.NEXTVAL
117: INTO l_header_id FROM sys.dual;
118:
119: if (l_slog) then
120: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
121: 'Going to populate the temp ');
122: end if;
123:
124: populateTemp(l_header_id

Line 129: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

125: ,l_asset_move_hierarchy_tbl
126: ,p_parent_instance_id );
127:
128: if (l_slog) then
129: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
130: 'Completed populating the temp ');
131: end if;
132:
133: IF (p_move_type = 1) THEN -- SubInv Transfer

Line 138: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

134: l_move_txn_type_id := 2;
135: ELSE
136: BEGIN
137: if (l_slog) then
138: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
139: 'Selecting the intrasit type from mtl_shipping_network ');
140: end if;
141: SELECT intransit_type INTO l_intransit_type
142: FROM MTL_SHIPPING_NETWORK_VIEW WHERE

Line 159: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

155: END IF;
156: SELECT Count(*) INTO l_eam_asset_move_count
157: FROM EAM_ASSET_MOVE_TEMP;
158: if (l_slog) then
159: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
160: 'The l_eam_asset_move_count is : '||l_eam_asset_move_count);
161: end if;
162:
163: SELECT Count(*) INTO l_prepare_count

Line 167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

163: SELECT Count(*) INTO l_prepare_count
164: FROM EAM_ASSET_MOVE_TEMP
165: WHERE PREPARE_STATUS = 'N';
166: if (l_slog) then
167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
168: 'The l_prepare_count is : '||l_prepare_count);
169: end if;
170: IF(l_prepare_count = 0 OR p_context = 'M') THEN -- If Transaction has to happen (User Clicked Apply after Validation Messages are displayed
171:

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

219: l_parent_inf_rec eam_asset_move_pub.asset_move_hierarchy_REC_TYPE;
220: --logging variables
221: l_api_name constant VARCHAR2(30) := 'getAssetHierarchy';
222: l_module VARCHAR2(200);
223: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
224: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
225: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
226: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
227: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

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

220: --logging variables
221: l_api_name constant VARCHAR2(30) := 'getAssetHierarchy';
222: l_module VARCHAR2(200);
223: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
224: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
225: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
226: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
227: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
228: l_cursor_count NUMBER :=1;

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

221: l_api_name constant VARCHAR2(30) := 'getAssetHierarchy';
222: l_module VARCHAR2(200);
223: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
224: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
225: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
226: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
227: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
228: l_cursor_count NUMBER :=1;
229: l_parent_object_id NUMBER;

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

222: l_module VARCHAR2(200);
223: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
224: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
225: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
226: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
227: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
228: l_cursor_count NUMBER :=1;
229: l_parent_object_id NUMBER;
230: CURSOR PARENT_ASSET_HIERARCHY_CUR(p_parent_instance_id IN NUMBER,p_current_org_id IN NUMBER)

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

264: IF (l_ulog) THEN
265: l_module := 'eam.plsql.'|| l_full_name;
266: END IF;
267: IF (l_plog) THEN
268: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
269: END IF;
270:
271: /*if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
272: 'getting the asset hierarchy of' || l_asset_move_hierarchy_tbl(i).instance_id ); --%%%SAVEPOINT LOOP_START;

Line 271: /*if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

267: IF (l_plog) THEN
268: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
269: END IF;
270:
271: /*if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
272: 'getting the asset hierarchy of' || l_asset_move_hierarchy_tbl(i).instance_id ); --%%%SAVEPOINT LOOP_START;
273: END IF; */
274:
275: BEGIN

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

285: SELECT 0
286: INTO l_parent_object_id
287: FROM dual;
288:
289: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
290: 'Exception while searching for parent object id' );
291: END IF;
292: -- dbms_output.put_line('Exception while searching for parent object id');
293: END;

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

292: -- dbms_output.put_line('Exception while searching for parent object id');
293: END;
294: --dbms_output.put_line('l_parent_object_id is'||l_parent_object_id);
295:
296: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
297: 'l_parent_object_id is' || l_parent_object_id );
298: END IF; --Commented for 6955393
299:
300: SELECT cii.instance_id ,

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

334: --populating the values of the parent instance id into the asset_hierarchy_table
335:
336: IF(p_includeChild='Y') THEN
337:
338: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
339: 'including the child assets' );
340: END IF;
341: --dbms_output.put_line('including the child assets');
342:

Line 362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'exiting the getassethierarchy' );

358: l_cursor_count:=l_cursor_count+1;
359: END LOOP ;
360: END IF;
361: if (l_slog) then
362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'exiting the getassethierarchy' );
363: END IF;
364: --dbms_output.put_line('exiting the getassethierarchy..................');
365: END getAssetHierarchy ;
366: PROCEDURE populateTemp

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

376: l_intermediate_subinventory VARCHAR2(20);
377: --logging variables
378: l_api_name constant VARCHAR2(30) := 'populateTemp';
379: l_module VARCHAR2(200);
380: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
381: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
382: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
383: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
384: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

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

377: --logging variables
378: l_api_name constant VARCHAR2(30) := 'populateTemp';
379: l_module VARCHAR2(200);
380: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
381: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
382: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
383: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
384: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
385:

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

378: l_api_name constant VARCHAR2(30) := 'populateTemp';
379: l_module VARCHAR2(200);
380: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
381: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
382: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
383: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
384: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
385:
386: CURSOR child_parent_cur

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

379: l_module VARCHAR2(200);
380: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
381: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
382: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
383: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
384: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
385:
386: CURSOR child_parent_cur
387: IS

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

394: l_module := 'eam.plsql.'|| l_full_name;
395: END IF;
396:
397: IF (l_plog) THEN
398: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
399: END IF;
400:
401: IF (l_slog) then
402: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Started populating the temp' );

Line 402: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Started populating the temp' );

398: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
399: END IF;
400:
401: IF (l_slog) then
402: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Started populating the temp' );
403: END IF;
404:
405: --dbms_output.put_line('Populating Temp');
406: FOR i IN p_asset_move_hierarchy_tbl.FIRST .. p_asset_move_hierarchy_tbl.LAST

Line 459: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'selecting the parent objectId for validating child asset'||child_parent_rec.INSTANCE_ID );

455: )
456: THEN
457:
458: IF (l_slog) then
459: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'selecting the parent objectId for validating child asset'||child_parent_rec.INSTANCE_ID );
460: END IF;
461:
462:
463: SELECT parent_object_id

Line 473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'parent objectId for validating the child assest is '||l_parent_object_id);

469: AND PARENT_OBJECT_TYPE = 2; --Added for the bug 7721062
470: --can use the below statement as well for filtering out the records
471: --AND parent_object_id IN (SELECT gen_object_id FROM mtl_serial_numbers)
472: IF (l_slog) then
473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'parent objectId for validating the child assest is '||l_parent_object_id);
474: END IF;
475:
476: BEGIN
477: SELECT PREPARE_STATUS

Line 485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'No_data_found exception occured when checking for parent status');

481: EXCEPTION
482: WHEN NO_DATA_FOUND THEN
483: SELECT 'U' INTO l_parent_status FROM dual;
484: IF (l_slog) then
485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'No_data_found exception occured when checking for parent status');
486: END IF;
487: END;
488:
489: BEGIN

Line 498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'No_data_found exception occured when checking for parent message');

494: EXCEPTION
495: WHEN NO_DATA_FOUND THEN
496: SELECT 'Unknown' INTO l_parent_msg FROM dual;
497: IF (l_slog) then
498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'No_data_found exception occured when checking for parent message');
499: END IF;
500: END;
501:
502: IF(l_parent_status ='N') THEN

Line 509: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'populated its parent status to this asset as it is not moving');

505: PREPARE_MSG ='EAM_PAR_ASSET_FAIL'
506: WHERE CURRENT OF child_parent_cur;
507:
508: IF (l_slog) then
509: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'populated its parent status to this asset as it is not moving');
510: END IF;
511:
512: END IF;
513: END IF;

Line 516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Exiting the PopulateTemp' );

512: END IF;
513: END IF;
514: END LOOP;
515: IF (l_slog) then
516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Exiting the PopulateTemp' );
517: END IF;
518: -- dbms_output.put_line('End of Populating Temp');
519: END populateTemp;
520:

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

554:
555: -- logging variables
556: l_api_name constant VARCHAR2(30) := 'addAssetsToInterface';
557: l_module VARCHAR2(200);
558: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
559: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
560: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
561: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
562: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

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

555: -- logging variables
556: l_api_name constant VARCHAR2(30) := 'addAssetsToInterface';
557: l_module VARCHAR2(200);
558: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
559: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
560: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
561: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
562: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
563: l_quantity NUMBER;

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

556: l_api_name constant VARCHAR2(30) := 'addAssetsToInterface';
557: l_module VARCHAR2(200);
558: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
559: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
560: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
561: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
562: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
563: l_quantity NUMBER;
564:

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

557: l_module VARCHAR2(200);
558: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
559: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
560: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
561: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
562: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
563: l_quantity NUMBER;
564:
565: --locator control verification variables

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

594: IF (l_ulog) THEN
595: l_module := 'eam.plsql.'|| l_full_name;
596: END IF;
597: IF (l_plog) THEN
598: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Entering ' || l_full_name);
599: END IF;
600:
601: IF (l_slog) then
602: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'p_header_id is '||p_header_id );

Line 602: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'p_header_id is '||p_header_id );

598: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Entering ' || l_full_name);
599: END IF;
600:
601: IF (l_slog) then
602: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'p_header_id is '||p_header_id );
603: END IF;
604: l_transfer_organization_id := p_transfer_organization_id;
605:
606: /* Check for Locator Control which could be defined

Line 813: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Calling the procedure INV_TRANSACTIONS.LINE_INTERFACE_INSERT' );

809:
810: -- insert into MTI, MSNI
811: --dbms_output.put_line('header_id IS' ||INV_TRANSACTIONS.G_Header_ID);
812: IF (l_slog) then
813: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Calling the procedure INV_TRANSACTIONS.LINE_INTERFACE_INSERT' );
814: END IF;
815:
816: IF(p_transaction_type_id=2) THEN --if subinventory transfer
817: IF(p_CURRENT_ORGANIZATION_ID<>l_CURRENT_ORGANIZATION_ID)THEN

Line 841: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Null Exception ocuured as no shipping network is enabled between organisation ids'||l_CURRENT_ORGANIZATION_ID||'AND'||p_CURRENT_ORGANIZATION_ID );

837: begin
838: raise no_data_found; --needs to handle the exception since no shipping network is enbled
839: --between the production org and maint org
840: IF (l_slog) then
841: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Null Exception ocuured as no shipping network is enabled between organisation ids'||l_CURRENT_ORGANIZATION_ID||'AND'||p_CURRENT_ORGANIZATION_ID );
842: END IF;
843: end;
844: end;
845:

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

924: l_transfer_organization_id := p_transfer_organization_id;
925: END LOOP;
926:
927: IF (l_plog) THEN
928: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
929: END IF;
930:
931: --Dbms_Output.put_line('end of add assets to interface');
932: END addAssetsToInterface;

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

951: -- x_process_txn_ret_status VARCHAR2(240);
952: --logging variables
953: l_api_name constant VARCHAR2(30) := 'processAssetMoveTxn';
954: l_module VARCHAR2(200);
955: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
956: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
957: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
958: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
959: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

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

952: --logging variables
953: l_api_name constant VARCHAR2(30) := 'processAssetMoveTxn';
954: l_module VARCHAR2(200);
955: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
956: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
957: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
958: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
959: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
960:

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

953: l_api_name constant VARCHAR2(30) := 'processAssetMoveTxn';
954: l_module VARCHAR2(200);
955: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
956: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
957: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
958: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
959: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
960:
961: CURSOR Txn_STAT_MMT_CUR(p_txn_header_id IN NUMBER) IS

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

954: l_module VARCHAR2(200);
955: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
956: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
957: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
958: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
959: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
960:
961: CURSOR Txn_STAT_MMT_CUR(p_txn_header_id IN NUMBER) IS
962: SELECT MTI.TRANSACTION_HEADER_ID ,

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

971: IF (l_ulog) THEN
972: l_module := 'eam.plsql.'|| l_full_name;
973: END IF;
974: IF (l_plog) THEN
975: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
976: END IF;
977: --Dbms_Output.put_line('Calling the INV transaction process API for the above txn_header_id');
978: -- Call the INV transaction process API for the above txn_header_id
979: l_txn_count := INV_TXN_MANAGER_PUB.process_Transactions

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

1012: END LOOP;
1013: COMMIT ;
1014:
1015: IF (l_plog) THEN
1016: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
1017: END IF;
1018:
1019: IF (l_plog) THEN
1020: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || g_pkg_name);

Line 1020: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || g_pkg_name);

1016: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
1017: END IF;
1018:
1019: IF (l_plog) THEN
1020: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || g_pkg_name);
1021: END IF;
1022:
1023: END processAssetMoveTxn;
1024: Procedure Get_LocatorControl_Code(