DBA Data[Home] [Help]

APPS.AHL_MC_ITEMGROUP_PUB dependencies on FND_LOG

Line 112: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

108:
109: -- Initialize API return status to success
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 114: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

110: x_return_status := FND_API.G_RET_STS_SUCCESS;
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

Line 163: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

159: END IF;
160:
161: -- Convert values to ID's for Item Association record columns.
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;

Line 165: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

161: -- Convert values to ID's for Item Association record columns.
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:

Line 183: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

179:
180: END IF;
181:
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;

Line 185: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

181:
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;

Line 331: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

327:
328: IF p_x_item_group_rec.operation_flag ='C' THEN
329:
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;

Line 333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

329:
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

Line 352: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

348: x_msg_data => x_msg_data );
349:
350: ELSIF p_x_item_group_rec.operation_flag ='M' THEN
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;

Line 354: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

350: ELSIF p_x_item_group_rec.operation_flag ='M' THEN
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

Line 372: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

368: x_msg_data => x_msg_data );
369:
370: ELSIF p_x_item_group_rec.operation_flag ='D' THEN
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;

Line 374: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

370: ELSIF p_x_item_group_rec.operation_flag ='D' THEN
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

Line 408: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

404: ( p_count => x_msg_count,
405: p_data => x_msg_data,
406: p_encoded => fnd_api.g_false);
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;

Line 410: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

406: p_encoded => fnd_api.g_false);
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: --

Line 423: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

419: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
420: p_data => x_msg_data,
421: p_encoded => fnd_api.g_false);
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;

Line 425: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

421: p_encoded => fnd_api.g_false);
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:

Line 436: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

432: Rollback to Process_Item_group_Pub;
433: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
434: p_data => x_msg_data,
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;

Line 438: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

434: p_data => x_msg_data,
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

Line 453: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

449: END IF;
450: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
451: p_data => x_msg_data,
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,

Line 455: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

451: p_data => x_msg_data,
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;

Line 457: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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:
461:

Line 519: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

515: l_dummy varchar2(200);
516:
517: BEGIN
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;

Line 521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

517: BEGIN
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:

Line 654: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

650: -- return changed record.
651: p_x_item_assoc_rec := l_item_assoc_rec;
652:
653:
654: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
655: THEN
656: l_dummy := 'Inventory p_x_item_assoc_rec '||to_char(p_x_item_assoc_rec.inventory_item_id);
657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
658: 'ahl_mc_itemgroup_pvt.Convert_InTo_ID', l_dummy);

Line 657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

653:
654: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
655: THEN
656: l_dummy := 'Inventory p_x_item_assoc_rec '||to_char(p_x_item_assoc_rec.inventory_item_id);
657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
658: 'ahl_mc_itemgroup_pvt.Convert_InTo_ID', l_dummy);
659: END IF;
660:
661:

Line 662: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

658: 'ahl_mc_itemgroup_pvt.Convert_InTo_ID', l_dummy);
659: END IF;
660:
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;

Line 664: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

660:
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;