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 41: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

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

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

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

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

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

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

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

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

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

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

66: l_module := 'eam.plsql.'|| l_full_name;
67: END IF;
68:
69: IF (l_plog) THEN
70: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
71: END IF;
72:
73:
74: DELETE FROM EAM_ASSET_MOVE_TEMP;

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

73:
74: DELETE FROM EAM_ASSET_MOVE_TEMP;
75:
76: if (l_slog) then
77: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
78: 'Going to get the asset Hierarchy ');
79: end if;
80:
81: getAssetHierarchy( p_parent_instance_id,

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

83: l_asset_move_hierarchy_tbl,
84: p_curr_org_id );
85:
86: if (l_slog) then
87: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
88: 'Completed getting the asset Hierarchy ');
89: end if;
90:
91: IF (p_move_type <> 1) THEN

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

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

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

122: SELECT APPS.mtl_material_transactions_s.NEXTVAL
123: INTO l_header_id FROM sys.dual;
124:
125: if (l_slog) then
126: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
127: 'Going to populate the temp ');
128: end if;
129:
130: populateTemp(l_header_id

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

131: ,l_asset_move_hierarchy_tbl
132: ,p_parent_instance_id );
133:
134: if (l_slog) then
135: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
136: 'Completed populating the temp ');
137: end if;
138:
139: IF (p_move_type = 1) THEN -- SubInv Transfer

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

140: l_move_txn_type_id := 2;
141: ELSE
142: BEGIN
143: if (l_slog) then
144: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
145: 'Selecting the intrasit type from mtl_shipping_network ');
146: end if;
147: SELECT intransit_type INTO l_intransit_type
148: FROM MTL_SHIPPING_NETWORK_VIEW WHERE

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

161: END IF;
162: SELECT Count(*) INTO l_eam_asset_move_count
163: FROM EAM_ASSET_MOVE_TEMP;
164: if (l_slog) then
165: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
166: 'The l_eam_asset_move_count is : '||l_eam_asset_move_count);
167: end if;
168:
169: SELECT Count(*) INTO l_prepare_count

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

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

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

227: l_parent_inf_rec eam_asset_move_pub.asset_move_hierarchy_REC_TYPE;
228: --logging variables
229: l_api_name constant VARCHAR2(30) := 'getAssetHierarchy';
230: l_module VARCHAR2(200);
231: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
232: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
233: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
234: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
235: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

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

228: --logging variables
229: l_api_name constant VARCHAR2(30) := 'getAssetHierarchy';
230: l_module VARCHAR2(200);
231: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
232: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
233: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
234: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
235: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
236: l_cursor_count NUMBER :=1;

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

229: l_api_name constant VARCHAR2(30) := 'getAssetHierarchy';
230: l_module VARCHAR2(200);
231: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
232: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
233: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
234: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
235: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
236: l_cursor_count NUMBER :=1;
237: l_parent_object_id NUMBER;

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

230: l_module VARCHAR2(200);
231: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
232: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
233: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
234: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
235: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
236: l_cursor_count NUMBER :=1;
237: l_parent_object_id NUMBER;
238: CURSOR PARENT_ASSET_HIERARCHY_CUR(p_parent_instance_id IN NUMBER,p_current_org_id IN NUMBER)

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

277: IF (l_ulog) THEN
278: l_module := 'eam.plsql.'|| l_full_name;
279: END IF;
280: IF (l_plog) THEN
281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
282: END IF;
283:
284: /*if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
285: 'getting the asset hierarchy of' || l_asset_move_hierarchy_tbl(i).instance_id ); --%%%SAVEPOINT LOOP_START;

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

280: IF (l_plog) THEN
281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
282: END IF;
283:
284: /*if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
285: 'getting the asset hierarchy of' || l_asset_move_hierarchy_tbl(i).instance_id ); --%%%SAVEPOINT LOOP_START;
286: END IF; */
287:
288: BEGIN

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

298: SELECT 0
299: INTO l_parent_object_id
300: FROM dual;
301:
302: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
303: 'Exception while searching for parent object id' );
304: END IF;
305: -- dbms_output.put_line('Exception while searching for parent object id');
306: END;

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

305: -- dbms_output.put_line('Exception while searching for parent object id');
306: END;
307: --dbms_output.put_line('l_parent_object_id is'||l_parent_object_id);
308:
309: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
310: 'l_parent_object_id is' || l_parent_object_id );
311: END IF; --Commented for 6955393
312:
313: SELECT cii.instance_id ,

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

347: --populating the values of the parent instance id into the asset_hierarchy_table
348:
349: IF(p_includeChild='Y') THEN
350:
351: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
352: 'including the child assets' );
353: END IF;
354: --dbms_output.put_line('including the child assets');
355:

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

371: l_cursor_count:=l_cursor_count+1;
372: END LOOP ;
373: END IF;
374: if (l_slog) then
375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'exiting the getassethierarchy' );
376: END IF;
377: --dbms_output.put_line('exiting the getassethierarchy..................');
378: END getAssetHierarchy ;
379: PROCEDURE populateTemp

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

389: l_intermediate_subinventory VARCHAR2(20);
390: --logging variables
391: l_api_name constant VARCHAR2(30) := 'populateTemp';
392: l_module VARCHAR2(200);
393: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
394: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
395: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
396: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
397: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

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

390: --logging variables
391: l_api_name constant VARCHAR2(30) := 'populateTemp';
392: l_module VARCHAR2(200);
393: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
394: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
395: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
396: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
397: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
398:

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

391: l_api_name constant VARCHAR2(30) := 'populateTemp';
392: l_module VARCHAR2(200);
393: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
394: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
395: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
396: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
397: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
398:
399: CURSOR child_parent_cur

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

392: l_module VARCHAR2(200);
393: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
394: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
395: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
396: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
397: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
398:
399: CURSOR child_parent_cur
400: IS

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

407: l_module := 'eam.plsql.'|| l_full_name;
408: END IF;
409:
410: IF (l_plog) THEN
411: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
412: END IF;
413:
414: IF (l_slog) then
415: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Started populating the temp' );

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

411: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
412: END IF;
413:
414: IF (l_slog) then
415: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Started populating the temp' );
416: END IF;
417:
418: --dbms_output.put_line('Populating Temp');
419: FOR i IN p_asset_move_hierarchy_tbl.FIRST .. p_asset_move_hierarchy_tbl.LAST

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

468: )
469: THEN
470:
471: IF (l_slog) then
472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'selecting the parent objectId for validating child asset'||child_parent_rec.INSTANCE_ID );
473: END IF;
474:
475:
476: SELECT parent_object_id

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

482: AND PARENT_OBJECT_TYPE = 2; --Added for the bug 7721062
483: --can use the below statement as well for filtering out the records
484: --AND parent_object_id IN (SELECT gen_object_id FROM mtl_serial_numbers)
485: IF (l_slog) then
486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'parent objectId for validating the child assest is '||l_parent_object_id);
487: END IF;
488:
489: BEGIN
490: SELECT PREPARE_STATUS

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

494: EXCEPTION
495: WHEN NO_DATA_FOUND THEN
496: SELECT 'U' INTO l_parent_status 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 status');
499: END IF;
500: END;
501:
502: BEGIN

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

507: EXCEPTION
508: WHEN NO_DATA_FOUND THEN
509: SELECT 'Unknown' INTO l_parent_msg FROM dual;
510: IF (l_slog) then
511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'No_data_found exception occured when checking for parent message');
512: END IF;
513: END;
514:
515: IF(l_parent_status ='N') THEN

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

518: PREPARE_MSG ='EAM_PAR_ASSET_FAIL'
519: WHERE CURRENT OF child_parent_cur;
520:
521: IF (l_slog) then
522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'populated its parent status to this asset as it is not moving');
523: END IF;
524:
525: END IF;
526: END IF;

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

525: END IF;
526: END IF;
527: END LOOP;
528: IF (l_slog) then
529: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Exiting the PopulateTemp' );
530: END IF;
531: -- dbms_output.put_line('End of Populating Temp');
532: END populateTemp;
533:

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

568:
569: -- logging variables
570: l_api_name constant VARCHAR2(30) := 'addAssetsToInterface';
571: l_module VARCHAR2(200);
572: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
573: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
574: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
575: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
576: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

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

569: -- logging variables
570: l_api_name constant VARCHAR2(30) := 'addAssetsToInterface';
571: l_module VARCHAR2(200);
572: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
573: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
574: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
575: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
576: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
577: l_quantity NUMBER;

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

570: l_api_name constant VARCHAR2(30) := 'addAssetsToInterface';
571: l_module VARCHAR2(200);
572: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
573: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
574: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
575: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
576: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
577: l_quantity NUMBER;
578:

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

571: l_module VARCHAR2(200);
572: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
573: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
574: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
575: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
576: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
577: l_quantity NUMBER;
578:
579: --locator control verification variables

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

608: IF (l_ulog) THEN
609: l_module := 'eam.plsql.'|| l_full_name;
610: END IF;
611: IF (l_plog) THEN
612: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Entering ' || l_full_name);
613: END IF;
614:
615: IF (l_slog) then
616: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'p_header_id is '||p_header_id );

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

612: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Entering ' || l_full_name);
613: END IF;
614:
615: IF (l_slog) then
616: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'p_header_id is '||p_header_id );
617: END IF;
618: l_transfer_organization_id := p_transfer_organization_id;
619:
620: /* Check for Locator Control which could be defined

Line 797: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'UOM Code, Serial control code, Lot control code could not be derived in addAssetsToInterface.'|| l_full_name);

793:
794: EXCEPTION
795: WHEN NO_DATA_FOUND THEN
796: IF (l_plog) THEN
797: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'UOM Code, Serial control code, Lot control code could not be derived in addAssetsToInterface.'|| l_full_name);
798: END IF;
799: -- l_Transaction_UOM:='Ea';
800: --Dbms_Output.put_line('ecxeption occured while selecting');
801: END;

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

827:
828: -- insert into MTI, MSNI
829: --dbms_output.put_line('header_id IS' ||INV_TRANSACTIONS.G_Header_ID);
830: IF (l_slog) then
831: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Calling the procedure INV_TRANSACTIONS.LINE_INTERFACE_INSERT' );
832: END IF;
833:
834: IF(p_transaction_type_id=2) THEN --if subinventory transfer
835: IF(p_CURRENT_ORGANIZATION_ID<>l_CURRENT_ORGANIZATION_ID)THEN

Line 859: 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 );

855: begin
856: raise no_data_found; --needs to handle the exception since no shipping network is enbled
857: --between the production org and maint org
858: IF (l_slog) then
859: 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 );
860: END IF;
861: end;
862: end;
863:

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

957:
958: END LOOP;
959:
960: IF (l_plog) THEN
961: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
962: END IF;
963:
964: --Dbms_Output.put_line('end of add assets to interface');
965: END addAssetsToInterface;

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

994: -- Bug Number: 14786085
995: --logging variables
996: l_api_name constant VARCHAR2(30) := 'processAssetMoveTxn';
997: l_module VARCHAR2(200);
998: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
999: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
1000: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1001: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1002: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

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

995: --logging variables
996: l_api_name constant VARCHAR2(30) := 'processAssetMoveTxn';
997: l_module VARCHAR2(200);
998: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
999: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
1000: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1001: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1002: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1003:

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

996: l_api_name constant VARCHAR2(30) := 'processAssetMoveTxn';
997: l_module VARCHAR2(200);
998: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
999: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
1000: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1001: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1002: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1003:
1004: CURSOR Txn_STAT_MMT_CUR(p_txn_header_id IN NUMBER) IS

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

997: l_module VARCHAR2(200);
998: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
999: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
1000: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1001: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1002: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1003:
1004: CURSOR Txn_STAT_MMT_CUR(p_txn_header_id IN NUMBER) IS
1005: SELECT MTI.TRANSACTION_HEADER_ID ,

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

1014: IF (l_ulog) THEN
1015: l_module := 'eam.plsql.'|| l_full_name;
1016: END IF;
1017: IF (l_plog) THEN
1018: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
1019: END IF;
1020:
1021: l_move_txn_type_id := p_move_txn_type_id;
1022:

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

1096:
1097: end if;
1098:
1099: IF (l_plog) THEN
1100: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
1101: END IF;
1102:
1103: IF (l_plog) THEN
1104: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || g_pkg_name);

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

1100: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || l_full_name);
1101: END IF;
1102:
1103: IF (l_plog) THEN
1104: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Exiting ' || g_pkg_name);
1105: END IF;
1106:
1107: END processAssetMoveTxn;
1108: Procedure Get_LocatorControl_Code(

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

1269: l_sysdate DATE;
1270: l_acc_per_id NUMBER;
1271: l_api_name constant VARCHAR2(30) := 'processAssetMoveTxn';
1272: l_module VARCHAR2(200);
1273: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
1274: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
1275: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1276: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1277: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

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

1270: l_acc_per_id NUMBER;
1271: l_api_name constant VARCHAR2(30) := 'processAssetMoveTxn';
1272: l_module VARCHAR2(200);
1273: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
1274: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
1275: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1276: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1277: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1278: l_misc_rec_txn_type NUMBER;

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

1271: l_api_name constant VARCHAR2(30) := 'processAssetMoveTxn';
1272: l_module VARCHAR2(200);
1273: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
1274: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
1275: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1276: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1277: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1278: l_misc_rec_txn_type NUMBER;
1279: l_txn_action_id NUMBER;

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

1272: l_module VARCHAR2(200);
1273: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
1274: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
1275: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1276: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1277: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1278: l_misc_rec_txn_type NUMBER;
1279: l_txn_action_id NUMBER;
1280: l_txn_src_type_id NUMBER;

Line 1328: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'UOM Code could not be derived in addAssetsForMiscReceipt.'|| l_full_name);

1324: EXCEPTION
1325: When no_data_found then
1326:
1327: IF (l_plog) THEN
1328: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'UOM Code could not be derived in addAssetsForMiscReceipt.'|| l_full_name);
1329: END IF;
1330:
1331: END;
1332: