DBA Data[Home] [Help]

APPS.AHL_MC_ITEM_COMP_PUB dependencies on FND_LOG

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

60: -- Initialize API return status to success
61:
62: x_return_status :=FND_API.G_RET_STS_SUCCESS;
63:
64: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
65: THEN
66: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
67: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', 'Begin of Process_Item_Composition');
68: END IF;

Line 66: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

62: x_return_status :=FND_API.G_RET_STS_SUCCESS;
63:
64: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
65: THEN
66: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
67: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', 'Begin of Process_Item_Composition');
68: END IF;
69:
70:

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

194: IF FND_API.TO_BOOLEAN(p_commit) THEN
195: COMMIT WORK;
196: END IF;
197:
198: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
199: THEN
200: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
201: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', 'End of Process_Item_Composition');
202: END IF;

Line 200: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

196: END IF;
197:
198: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
199: THEN
200: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
201: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', 'End of Process_Item_Composition');
202: END IF;
203:
204:

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

209: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
210: p_data => x_msg_data,
211: p_encoded => fnd_api.g_false);
212:
213: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
214: THEN
215: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
216: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', 'Error in Process_Item_Composition');
217: END IF;

Line 215: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

211: p_encoded => fnd_api.g_false);
212:
213: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
214: THEN
215: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
216: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', 'Error in Process_Item_Composition');
217: END IF;
218:
219:

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

223: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
224: p_data => x_msg_data,
225: p_encoded => fnd_api.g_false);
226:
227: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
228: THEN
229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
230: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', 'Unexpected Error in Process_Item_Composition');
231: END IF;

Line 229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

225: p_encoded => fnd_api.g_false);
226:
227: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
228: THEN
229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
230: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', 'Unexpected Error in Process_Item_Composition');
231: END IF;
232:
233: WHEN OTHERS THEN

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

241: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
242: p_data => x_msg_data,
243: p_encoded => fnd_api.g_false);
244:
245: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
246: THEN
247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
248: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', 'Unknown Error in Process_Item_Composition');
249: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

243: p_encoded => fnd_api.g_false);
244:
245: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
246: THEN
247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
248: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', 'Unknown Error in Process_Item_Composition');
249: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
250: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', SQLERRM);
251: END IF;

Line 249: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

245: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
246: THEN
247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
248: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', 'Unknown Error in Process_Item_Composition');
249: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
250: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', SQLERRM);
251: END IF;
252:
253:

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

300: l_dummy varchar2(200);
301:
302: BEGIN
303:
304: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
305: THEN
306: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
307: 'ahl_mc_item_comp_pvt.Convert_InTo_ID', 'Begin of Convert_InTo_ID');
308: END IF;

Line 306: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

302: BEGIN
303:
304: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
305: THEN
306: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
307: 'ahl_mc_item_comp_pvt.Convert_InTo_ID', 'Begin of Convert_InTo_ID');
308: END IF;
309:
310: IF (l_item_comp_rec.item_group_name IS NOT NULL) THEN

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

396: -- return changed record.
397: p_x_item_comp_rec := l_item_comp_rec;
398:
399:
400: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
401: THEN
402: l_dummy := 'Inventory p_x_item_comp_rec '||to_char(p_x_item_comp_rec.inventory_item_id);
403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
404: 'ahl_mc_item_comp_pvt.Convert_InTo_ID', l_dummy);

Line 403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

399:
400: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
401: THEN
402: l_dummy := 'Inventory p_x_item_comp_rec '||to_char(p_x_item_comp_rec.inventory_item_id);
403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
404: 'ahl_mc_item_comp_pvt.Convert_InTo_ID', l_dummy);
405: END IF;
406:
407:

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

404: 'ahl_mc_item_comp_pvt.Convert_InTo_ID', l_dummy);
405: END IF;
406:
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_item_comp_pvt.Convert_InTo_ID', 'End of Convert_InTo_ID');
412: END IF;

Line 410: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

406:
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_item_comp_pvt.Convert_InTo_ID', 'End of Convert_InTo_ID');
412: END IF;
413:
414: END Convert_code_to_ID;