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.AHL_MC_ITEMGROUP_PUB dependencies on AHL_MC_ITEMGROUP_PUB

Line 1: PACKAGE BODY AHL_MC_ITEMGROUP_PUB AS

1: PACKAGE BODY AHL_MC_ITEMGROUP_PUB AS
2: /* $Header: AHLPIGPB.pls 115.18 2004/04/16 14:46:23 sjayacha noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_MC_ITEMGROUP_PVT';

Line 115: 'ahl_mc_itemgroup_pub.process_item_group', 'Begin of process_item_group');

111:
112: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
113: THEN
114: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
115: 'ahl_mc_itemgroup_pub.process_item_group', 'Begin of process_item_group');
116: END IF;
117:
118: IF l_item_group_rec.OPERATION_FLAG <> 'D' THEN
119: IF l_item_group_rec.type_code IS NOT NULL THEN

Line 166: 'ahl_mc_itemgroup_pub.process_item_group', 'Begin Loop to convert Item Name to Id');

162: IF (p_x_items_tbl.COUNT > 0) THEN
163: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
164: THEN
165: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
166: 'ahl_mc_itemgroup_pub.process_item_group', 'Begin Loop to convert Item Name to Id');
167: END IF;
168:
169:
170: FOR i IN p_x_items_tbl.FIRST..p_x_items_tbl.LAST LOOP

Line 186: 'ahl_mc_itemgroup_pub.process_item_group', 'End of Loop');

182: END LOOP;
183: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
184: THEN
185: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
186: 'ahl_mc_itemgroup_pub.process_item_group', 'End of Loop');
187: END IF;
188:
189: END IF;
190:

Line 334: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Create_Item_group');

330:
331: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
332: THEN
333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
334: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Create_Item_group');
335: END IF;
336:
337: -- Call Private API for Create
338:

Line 355: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Modify_Item_group');

351:
352: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
353: THEN
354: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
355: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Modify_Item_group');
356: END IF;
357:
358: -- Call Private API for Create
359: AHL_MC_ItemGroup_Pvt.Modify_Item_group(

Line 375: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Remove_Item_group');

371:
372: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
373: THEN
374: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
375: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Remove_Item_group');
376: END IF;
377:
378: -- Call Private API for Create
379: AHL_MC_ItemGroup_Pvt.Remove_Item_group(

Line 411: 'ahl_mc_itemgroup_pub.process_item_group', 'End of process_item_group');

407:
408: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
409: THEN
410: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
411: 'ahl_mc_itemgroup_pub.process_item_group', 'End of process_item_group');
412: END IF;
413:
414: --
415: EXCEPTION

Line 426: 'ahl_mc_itemgroup_pub.process_item_group', 'Error in process_item_group');

422:
423: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
424: THEN
425: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
426: 'ahl_mc_itemgroup_pub.process_item_group', 'Error in process_item_group');
427: END IF;
428:
429:
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 439: 'ahl_mc_itemgroup_pub.process_item_group', 'Unexpected Error in process_item_group');

435: p_encoded => fnd_api.g_false);
436: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
437: THEN
438: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
439: 'ahl_mc_itemgroup_pub.process_item_group', 'Unexpected Error in process_item_group');
440: END IF;
441:
442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 456: 'ahl_mc_itemgroup_pub.process_item_group', 'Unknown Error in process_item_group');

452: p_encoded => fnd_api.g_false);
453: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
454: THEN
455: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
456: 'ahl_mc_itemgroup_pub.process_item_group', 'Unknown Error in process_item_group');
457: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
458: 'ahl_mc_itemgroup_pub.process_item_group', SQLERRM);
459: END IF;
460:

Line 458: 'ahl_mc_itemgroup_pub.process_item_group', SQLERRM);

454: THEN
455: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
456: 'ahl_mc_itemgroup_pub.process_item_group', 'Unknown Error in process_item_group');
457: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
458: 'ahl_mc_itemgroup_pub.process_item_group', SQLERRM);
459: END IF;
460:
461:
462:

Line 522: 'ahl_mc_itemgroup_pub.Convert_InTo_ID', 'Begin of Convert_InTo_ID');

518:
519: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
520: THEN
521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
522: 'ahl_mc_itemgroup_pub.Convert_InTo_ID', 'Begin of Convert_InTo_ID');
523: END IF;
524:
525:
526: -- For Inventory Organization Code.

Line 665: 'ahl_mc_itemgroup_pub.Convert_InTo_ID', 'End of Convert_InTo_ID');

661:
662: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
663: THEN
664: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
665: 'ahl_mc_itemgroup_pub.Convert_InTo_ID', 'End of Convert_InTo_ID');
666: END IF;
667:
668: END Convert_InTo_ID;
669:

Line 671: End AHL_MC_ITEMGROUP_PUB;

667:
668: END Convert_InTo_ID;
669:
670:
671: End AHL_MC_ITEMGROUP_PUB;