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_ITEM_PVT dependencies on INV_ITEM_GRP

Line 51: l_asset_group INV_Item_GRP.Item_Rec_Type;

47: l_x_return_status VARCHAR2(1);
48: l_x_msg_count NUMBER;
49: l_x_msg_data VARCHAR2(20000);
50:
51: l_asset_group INV_Item_GRP.Item_Rec_Type;
52: l_x_inventory_item_id NUMBER;
53: l_master_org_id number;
54:
55: l_api_name CONSTANT VARCHAR2(30) := 'insert_item';

Line 64: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;

60: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
61: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
62:
63: -- output variables of inv package
64: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
65: l_x_curr_item_return_status VARCHAR2(1);
66: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
67: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
68: l_x_master_item_return_status VARCHAR2(1);

Line 66: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;

62:
63: -- output variables of inv package
64: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
65: l_x_curr_item_return_status VARCHAR2(1);
66: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
67: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
68: l_x_master_item_return_status VARCHAR2(1);
69: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
70:

Line 67: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;

63: -- output variables of inv package
64: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
65: l_x_curr_item_return_status VARCHAR2(1);
66: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
67: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
68: l_x_master_item_return_status VARCHAR2(1);
69: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
70:
71:

Line 69: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;

65: l_x_curr_item_return_status VARCHAR2(1);
66: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
67: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
68: l_x_master_item_return_status VARCHAR2(1);
69: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
70:
71:
72: v_row PLS_INTEGER;
73:

Line 166: 'Calling INV_ITEM_GRP.Create_Item...'||

162:
163:
164: IF (l_plog) THEN
165: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
166: 'Calling INV_ITEM_GRP.Create_Item...'||
167: 'Comms_NL_Trackable_Flag: '||l_asset_group.comms_nl_trackable_flag||
168: ' Inventory_Item_Flag: '||l_asset_group.Inventory_item_flag);
169: END IF;
170:

Line 171: INV_ITEM_GRP.Create_Item

167: 'Comms_NL_Trackable_Flag: '||l_asset_group.comms_nl_trackable_flag||
168: ' Inventory_Item_Flag: '||l_asset_group.Inventory_item_flag);
169: END IF;
170:
171: INV_ITEM_GRP.Create_Item
172: (
173: p_Item_rec => l_asset_group,
174: p_Template_Id => p_source_tmpl_id,
175: p_Template_Name => p_template_name,

Line 183: 'Returned from INV_ITEM_GRP.Create_Item...'||

179: );
180:
181: IF (l_plog) THEN
182: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
183: 'Returned from INV_ITEM_GRP.Create_Item...'||
184: 'Comms_NL_Trackable_Flag: '||l_x_master_item_rec.comms_nl_trackable_flag||
185: ' Inventory_Item_Flag: '||l_x_master_item_rec.Inventory_item_flag);
186: END IF;
187:

Line 195: 'Calling INV_ITEM_GRP.Create_Item...'||

191: l_asset_group.organization_id := p_organization_id;
192:
193: IF (l_plog) THEN
194: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
195: 'Calling INV_ITEM_GRP.Create_Item...'||
196: 'Comms_NL_Trackable_Flag: '||l_asset_group.comms_nl_trackable_flag||
197: ' Inventory_Item_Flag: '||l_asset_group.Inventory_item_flag);
198: END IF;
199:

Line 200: INV_ITEM_GRP.Create_Item

196: 'Comms_NL_Trackable_Flag: '||l_asset_group.comms_nl_trackable_flag||
197: ' Inventory_Item_Flag: '||l_asset_group.Inventory_item_flag);
198: END IF;
199:
200: INV_ITEM_GRP.Create_Item
201: (
202: p_Item_rec => l_asset_group,
203: x_Item_rec => l_x_curr_item_rec,
204: x_return_status => l_x_return_status,

Line 211: 'Returned from INV_ITEM_GRP.Create_Item...'||

207: );
208:
209: IF (l_plog) THEN
210: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
211: 'Returned from INV_ITEM_GRP.Create_Item...'||
212: 'Comms_NL_Trackable_Flag: '||l_x_curr_item_rec.comms_nl_trackable_flag||
213: ' Inventory_Item_Flag: '||l_x_curr_item_rec.Inventory_item_flag);
214: END IF;
215:

Line 286: l_asset_group INV_Item_GRP.Item_Rec_Type;

282: l_x_msg_count NUMBER;
283: l_x_msg_data VARCHAR2(20000);
284: l_master_org_id number;
285:
286: l_asset_group INV_Item_GRP.Item_Rec_Type;
287: l_x_inventory_item_id NUMBER;
288:
289: l_api_name CONSTANT VARCHAR2(30) := 'Update_item';
290:

Line 298: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;

294: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
295: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
296:
297: -- output variables of inv package
298: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
299: l_x_curr_item_return_status VARCHAR2(1);
300: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
301: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
302:

Line 300: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;

296:
297: -- output variables of inv package
298: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
299: l_x_curr_item_return_status VARCHAR2(1);
300: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
301: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
302:
303: v_row PLS_INTEGER;
304:

Line 301: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;

297: -- output variables of inv package
298: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
299: l_x_curr_item_return_status VARCHAR2(1);
300: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
301: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
302:
303: v_row PLS_INTEGER;
304:
305: BEGIN

Line 324: 'Calling INV_ITEM_GRP.Update_Item...');

320: 'Comms_NL_Trackable_Flag: '||l_asset_group.comms_nl_trackable_flag||
321: ' Inventory_Item_Flag: '||l_asset_group.Inventory_item_flag);
322:
323: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
324: 'Calling INV_ITEM_GRP.Update_Item...');
325: END IF;
326:
327: if p_source_tmpl_id is not null or p_template_name is not null then
328:

Line 336: INV_ITEM_GRP.Update_Item

332: where organization_id = p_organization_id;
333:
334: l_asset_group.organization_id := l_master_org_id;
335:
336: INV_ITEM_GRP.Update_Item
337: (
338: p_Item_rec => l_asset_group,
339: p_Template_Id => p_source_tmpl_id,
340: p_Template_Name => p_template_name,

Line 365: INV_ITEM_GRP.Update_Item

361: end if;
362:
363: l_asset_group.organization_id := p_organization_id;
364:
365: INV_ITEM_GRP.Update_Item
366: (
367: p_Item_rec => l_asset_group,
368: x_Item_rec => l_x_curr_item_rec,
369: x_return_status => l_x_return_status,

Line 375: 'Returned from INV_ITEM_GRP.Update_Item...'||

371: );
372:
373: IF (l_plog) THEN
374: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
375: 'Returned from INV_ITEM_GRP.Update_Item...'||
376: 'Comms_NL_Trackable_Flag: '||l_x_curr_item_rec.comms_nl_trackable_flag||
377: ' Inventory_Item_Flag: '||l_x_curr_item_rec.Inventory_item_flag);
378: END IF;
379:

Line 418: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;

414:
415:
416: IS
417:
418: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
419: l_x_return_status VARCHAR2(1);
420: l_api_name CONSTANT VARCHAR2(30) := 'Lock_item';
421:
422: l_module varchar2(200);

Line 444: 'Calling INV_ITEM_GRP.Lock_Item...');

440: || 'p_organization_id = ' || p_organization_id
441: || 'p_inventory_item_id = ' ||p_inventory_item_id);
442:
443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
444: 'Calling INV_ITEM_GRP.Lock_Item...');
445: END IF;
446:
447: INV_ITEM_GRP.Lock_Item
448: ( p_Item_ID => p_inventory_item_id

Line 447: INV_ITEM_GRP.Lock_Item

443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
444: 'Calling INV_ITEM_GRP.Lock_Item...');
445: END IF;
446:
447: INV_ITEM_GRP.Lock_Item
448: ( p_Item_ID => p_inventory_item_id
449: , p_Org_ID => p_organization_id
450: , x_return_status => l_x_return_status
451: , x_Error_tbl => l_x_curr_item_error_tbl

Line 459: 'Returned from INV_ITEM_GRP.Lock_Item with l_x_return_status '||l_x_return_status);

455: x_return_status := l_x_return_status;
456:
457: IF (l_plog) THEN
458: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
459: 'Returned from INV_ITEM_GRP.Lock_Item with l_x_return_status '||l_x_return_status);
460: END IF;
461: if nvl(l_x_return_status, 'S') not in ('E','U') then
462: return;
463: else

Line 488: '==============INV_ITEM_GRP.Lock_Item :EXPECTED ERROR===================');

484: IF (l_plog) THEN
485: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
486: 'Rollback To Lock_Item.....');
487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
488: '==============INV_ITEM_GRP.Lock_Item :EXPECTED ERROR===================');
489: END IF;
490: x_return_status := fnd_api.g_ret_sts_error;
491: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
492: WHEN fnd_api.g_exc_unexpected_error THEN

Line 498: '==============INV_ITEM_GRP.Lock_Item :UNEXPECTED ERROR===================');

494: IF (l_plog) THEN
495: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
496: 'Rollback To Lock_Item.....');
497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
498: '==============INV_ITEM_GRP.Lock_Item :UNEXPECTED ERROR===================');
499: END IF;
500: x_return_status := fnd_api.g_ret_sts_unexp_error;
501: fnd_msg_pub.count_and_get(
502: p_count => x_msg_count

Line 510: '==============INV_ITEM_GRP.Lock_Item :OTHER ERROR===================');

506: IF (l_plog) THEN
507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
508: 'Rollback To Lock_Item.....');
509: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
510: '==============INV_ITEM_GRP.Lock_Item :OTHER ERROR===================');
511: END IF;
512: x_return_status := fnd_api.g_ret_sts_unexp_error;
513:
514: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN