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_ENIGMA_IPC_PROCS_PVT dependencies on FND_LOG

Line 9: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;

5:
6: ------------------------------------------------------------------------------------
7: -- Common constants and variables
8: ------------------------------------------------------------------------------------
9: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
10: l_log_statement NUMBER := FND_LOG.level_statement;
11: l_log_procedure NUMBER := FND_LOG.level_procedure;
12: l_log_error NUMBER := FND_LOG.level_error;
13: l_log_unexpected NUMBER := FND_LOG.level_unexpected;

Line 10: l_log_statement NUMBER := FND_LOG.level_statement;

6: ------------------------------------------------------------------------------------
7: -- Common constants and variables
8: ------------------------------------------------------------------------------------
9: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
10: l_log_statement NUMBER := FND_LOG.level_statement;
11: l_log_procedure NUMBER := FND_LOG.level_procedure;
12: l_log_error NUMBER := FND_LOG.level_error;
13: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
14:

Line 11: l_log_procedure NUMBER := FND_LOG.level_procedure;

7: -- Common constants and variables
8: ------------------------------------------------------------------------------------
9: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
10: l_log_statement NUMBER := FND_LOG.level_statement;
11: l_log_procedure NUMBER := FND_LOG.level_procedure;
12: l_log_error NUMBER := FND_LOG.level_error;
13: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
14:
15: l_ig_report_type VARCHAR2(30) := 'IPC_AIG';

Line 12: l_log_error NUMBER := FND_LOG.level_error;

8: ------------------------------------------------------------------------------------
9: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
10: l_log_statement NUMBER := FND_LOG.level_statement;
11: l_log_procedure NUMBER := FND_LOG.level_procedure;
12: l_log_error NUMBER := FND_LOG.level_error;
13: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
14:
15: l_ig_report_type VARCHAR2(30) := 'IPC_AIG';
16: l_mc_report_type VARCHAR2(30) := 'IPC_MC';

Line 13: l_log_unexpected NUMBER := FND_LOG.level_unexpected;

9: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
10: l_log_statement NUMBER := FND_LOG.level_statement;
11: l_log_procedure NUMBER := FND_LOG.level_procedure;
12: l_log_error NUMBER := FND_LOG.level_error;
13: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
14:
15: l_ig_report_type VARCHAR2(30) := 'IPC_AIG';
16: l_mc_report_type VARCHAR2(30) := 'IPC_MC';
17: l_ic_report_type VARCHAR2(30) := 'IPC_CL';

Line 197: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

193: --
194:
195: BEGIN
196: IF (l_log_procedure >= l_log_current_level) THEN
197: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
198: END IF;
199:
200: -- Standard start of API savepoint
201: SAVEPOINT Process_Item_Group_Pub;

Line 221: FND_LOG.string(l_log_statement, l_full_name, 'l_user_id = '||l_user_id||', l_resp_id = '||l_resp_id);

217: -- get the Enigma user and responsibility, and call apps_initialize
218: l_user_id := FND_PROFILE.VALUE('AHL_ENIGMA_USER');
219: l_resp_id := FND_PROFILE.VALUE('AHL_ENIGMA_RESPONSIBILITY');
220: IF (l_log_statement >= l_log_current_level) THEN
221: FND_LOG.string(l_log_statement, l_full_name, 'l_user_id = '||l_user_id||', l_resp_id = '||l_resp_id);
222: END IF;
223: BEGIN
224: FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_app_id);
225: EXCEPTION

Line 228: FND_LOG.string(l_log_statement, l_full_name, 'FND_GLOBAL.APPS_INITIALIZE call failed - '||SQLERRM);

224: FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_app_id);
225: EXCEPTION
226: WHEN OTHERS THEN
227: IF (l_log_statement >= l_log_current_level) THEN
228: FND_LOG.string(l_log_statement, l_full_name, 'FND_GLOBAL.APPS_INITIALIZE call failed - '||SQLERRM);
229: END IF;
230: END;
231:
232: -- get the org id from the new profile

Line 236: FND_LOG.string(l_log_statement, l_full_name, 'l_org_id = '||l_org_id);

232: -- get the org id from the new profile
233: l_org_id := FND_PROFILE.VALUE('AHL_ENIGMA_ITEM_ORG');
234:
235: IF (l_log_statement >= l_log_current_level) THEN
236: FND_LOG.string(l_log_statement, l_full_name, 'l_org_id = '||l_org_id);
237: END IF;
238:
239: -- check for the profile value
240: IF (l_org_id IS NULL) THEN

Line 247: FND_LOG.string(l_log_statement, l_full_name,

243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246: IF (l_log_statement >= l_log_current_level) THEN
247: FND_LOG.string(l_log_statement, l_full_name,
248: 'operation flag for the header = '||l_item_group_rec.operation_flag);
249: END IF;
250:
251: -- convert the operation flag: 'N' to 'C'

Line 264: FND_LOG.string(l_log_statement, l_full_name, 'l_items_tbl.COUNT = '|| l_items_tbl.COUNT);

260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END IF;
262:
263: IF (l_log_statement >= l_log_current_level) THEN
264: FND_LOG.string(l_log_statement, l_full_name, 'l_items_tbl.COUNT = '|| l_items_tbl.COUNT);
265: END IF;
266:
267: -- check for item associations table
268: IF (l_items_tbl.COUNT < 1) THEN

Line 270: FND_LOG.string(l_log_statement, l_full_name, 'no items for association');

266:
267: -- check for item associations table
268: IF (l_items_tbl.COUNT < 1) THEN
269: IF (l_log_statement >= l_log_current_level) THEN
270: FND_LOG.string(l_log_statement, l_full_name, 'no items for association');
271: END IF;
272: -- items table can't be empty for creation - it needs at least one item
273: IF (l_item_group_rec.operation_flag = 'C') THEN
274: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ENIGMA_AIG_NO_ITEMS'); -- At least one association item is required to create the Item Group. (new message)

Line 298: FND_LOG.string(l_log_statement, l_full_name,

294: END IF;
295: CLOSE get_ig_id_csr;
296:
297: IF (l_log_statement >= l_log_current_level) THEN
298: FND_LOG.string(l_log_statement, l_full_name,
299: 'Calling private API AHL_MC_ITEMGROUP_PVT.Remove_Item_group.');
300: END IF;
301:
302: -- call the private API

Line 313: FND_LOG.string(l_log_statement, l_full_name,

309: p_item_group_rec => l_item_group_rec
310: );
311:
312: IF (l_log_statement >= l_log_current_level) THEN
313: FND_LOG.string(l_log_statement, l_full_name,
314: 'AHL_MC_ITEMGROUP_PVT.Remove_Item_group returned x_return_status as ' || x_return_status);
315: END IF;
316:
317: -- check for the return status

Line 320: FND_LOG.string(l_log_statement, l_full_name,

316:
317: -- check for the return status
318: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
319: IF (l_log_statement >= l_log_current_level) THEN
320: FND_LOG.string(l_log_statement, l_full_name,
321: 'Raising exception with x_return_status = ' || x_return_status);
322: END IF;
323: RAISE FND_API.G_EXC_ERROR;
324: END IF;

Line 388: FND_LOG.string(l_log_statement, l_full_name,

384: END IF;
385: END IF;
386:
387: IF (l_log_statement >= l_log_current_level) THEN
388: FND_LOG.string(l_log_statement, l_full_name,
389: 'Calling private API AHL_MC_ITEMGROUP_PVT.Create_Item_group.');
390: END IF;
391:
392: -- call the private API

Line 404: FND_LOG.string(l_log_statement, l_full_name,

400: p_x_items_tbl => l_items_tbl
401: );
402:
403: IF (l_log_statement >= l_log_current_level) THEN
404: FND_LOG.string(l_log_statement, l_full_name,
405: 'AHL_MC_ITEMGROUP_PVT.Create_Item_group returned x_return_status as ' || x_return_status);
406: END IF;
407:
408: -- check for the return status

Line 411: FND_LOG.string(l_log_statement, l_full_name,

407:
408: -- check for the return status
409: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
410: IF (l_log_statement >= l_log_current_level) THEN
411: FND_LOG.string(l_log_statement, l_full_name,
412: 'Raising exception with x_return_status = ' || x_return_status);
413: END IF;
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;

Line 419: FND_LOG.string(l_log_statement, l_full_name,

415: END IF;
416:
417: -- move the item group to Complete status
418: IF (l_log_statement >= l_log_current_level) THEN
419: FND_LOG.string(l_log_statement, l_full_name,
420: 'Calling private API AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups.');
421: END IF;
422:
423: -- call the private API

Line 437: FND_LOG.string(l_log_statement, l_full_name,

433: p_object_version_number => 1
434: );
435:
436: IF (l_log_statement >= l_log_current_level) THEN
437: FND_LOG.string(l_log_statement, l_full_name,
438: 'AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups returned x_return_status as ' || x_return_status);
439: END IF;
440:
441: -- check for the return status

Line 444: FND_LOG.string(l_log_statement, l_full_name,

440:
441: -- check for the return status
442: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
443: IF (l_log_statement >= l_log_current_level) THEN
444: FND_LOG.string(l_log_statement, l_full_name,
445: 'Raising exception with x_return_status = ' || x_return_status);
446: END IF;
447: RAISE FND_API.G_EXC_ERROR;
448: END IF;

Line 547: FND_LOG.string(l_log_statement, l_full_name,

543: END IF;
544: END IF;
545:
546: IF (l_log_statement >= l_log_current_level) THEN
547: FND_LOG.string(l_log_statement, l_full_name,
548: 'Calling private API AHL_MC_ITEMGROUP_PVT.Modify_Item_group.');
549: END IF;
550:
551: -- call the private API

Line 563: FND_LOG.string(l_log_statement, l_full_name,

559: p_x_items_tbl => l_items_tbl
560: );
561:
562: IF (l_log_statement >= l_log_current_level) THEN
563: FND_LOG.string(l_log_statement, l_full_name,
564: 'AHL_MC_ITEMGROUP_PVT.Modify_Item_group returned x_return_status as ' || x_return_status);
565: END IF;
566:
567: -- check for the return status

Line 570: FND_LOG.string(l_log_statement, l_full_name,

566:
567: -- check for the return status
568: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
569: IF (l_log_statement >= l_log_current_level) THEN
570: FND_LOG.string(l_log_statement, l_full_name,
571: 'Raising exception with x_return_status = ' || x_return_status);
572: END IF;
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;

Line 594: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'End of the API');

590: p_msg_count => 0
591: );
592:
593: IF (l_log_procedure >= l_log_current_level) THEN
594: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'End of the API');
595: END IF;
596:
597: EXCEPTION
598: WHEN FND_API.G_EXC_ERROR THEN

Line 726: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

722: --
723:
724: BEGIN
725: IF (l_log_procedure >= l_log_current_level) THEN
726: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
727: END IF;
728:
729: -- Standard start of API savepoint
730: SAVEPOINT Process_Master_Config_Pub;

Line 750: FND_LOG.string(l_log_statement, l_full_name, 'l_user_id = '||l_user_id||', l_resp_id = '||l_resp_id);

746: -- get the Enigma user and responsibility, and call apps_initialize
747: l_user_id := FND_PROFILE.VALUE('AHL_ENIGMA_USER');
748: l_resp_id := FND_PROFILE.VALUE('AHL_ENIGMA_RESPONSIBILITY');
749: IF (l_log_statement >= l_log_current_level) THEN
750: FND_LOG.string(l_log_statement, l_full_name, 'l_user_id = '||l_user_id||', l_resp_id = '||l_resp_id);
751: END IF;
752: BEGIN
753: FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_app_id);
754: EXCEPTION

Line 757: FND_LOG.string(l_log_statement, l_full_name, 'FND_GLOBAL.APPS_INITIALIZE call failed - '||SQLERRM);

753: FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_app_id);
754: EXCEPTION
755: WHEN OTHERS THEN
756: IF (l_log_statement >= l_log_current_level) THEN
757: FND_LOG.string(l_log_statement, l_full_name, 'FND_GLOBAL.APPS_INITIALIZE call failed - '||SQLERRM);
758: END IF;
759: END;
760:
761: IF (l_log_statement >= l_log_current_level) THEN

Line 762: FND_LOG.string(l_log_statement, l_full_name,

758: END IF;
759: END;
760:
761: IF (l_log_statement >= l_log_current_level) THEN
762: FND_LOG.string(l_log_statement, l_full_name,
763: 'l_nodes_tbl.COUNT = '|| l_nodes_tbl.COUNT);
764: END IF;
765:
766: -- check for nodes table

Line 769: FND_LOG.string(l_log_statement, l_full_name, 'no nodes for the MC');

765:
766: -- check for nodes table
767: IF (l_nodes_tbl.COUNT < 1) THEN
768: IF (l_log_statement >= l_log_current_level) THEN
769: FND_LOG.string(l_log_statement, l_full_name, 'no nodes for the MC');
770: END IF;
771: -- nodes table can't be empty - it needs at least the root node
772: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ENIGMA_NO_NODES'); -- At least one position is required to create the Master Configuration. (new message)
773: FND_MSG_PUB.ADD;

Line 841: FND_LOG.string(l_log_statement, l_full_name,

837: l_nodes_tbl(1).position_necessity_code := 'MANDATORY';
838: l_nodes_tbl(1).display_order := 1;
839:
840: IF (l_log_statement >= l_log_current_level) THEN
841: FND_LOG.string(l_log_statement, l_full_name,
842: 'Calling private API AHL_MC_MasterConfig_PVT.Create_Master_Config.');
843: END IF;
844:
845: -- call the private API

Line 857: FND_LOG.string(l_log_statement, l_full_name,

853: p_x_node_rec => l_nodes_tbl(1)
854: );
855:
856: IF (l_log_statement >= l_log_current_level) THEN
857: FND_LOG.string(l_log_statement, l_full_name,
858: 'AHL_MC_MasterConfig_PVT.Create_Master_Config returned x_return_status as ' || x_return_status||
859: ', MC header id = '||l_mc_header_rec.mc_header_id||
860: ', root node relationship id = '||l_nodes_tbl(1).relationship_id);
861: END IF;

Line 866: FND_LOG.string(l_log_statement, l_full_name,

862:
863: -- check for the return status
864: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
865: IF (l_log_statement >= l_log_current_level) THEN
866: FND_LOG.string(l_log_statement, l_full_name,
867: 'Raising exception with x_return_status = ' || x_return_status);
868: END IF;
869: RAISE FND_API.G_EXC_ERROR;
870: END IF;

Line 908: FND_LOG.string(l_log_statement, l_full_name,

904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
905: END IF;
906:
907: IF (l_log_statement >= l_log_current_level) THEN
908: FND_LOG.string(l_log_statement, l_full_name,
909: 'Calling private API AHL_MC_Node_PVT.Create_Node.');
910: END IF;
911:
912: -- call the private API

Line 925: FND_LOG.string(l_log_statement, l_full_name,

921: p_x_subconfig_tbl => l_SubConfig_Tbl_Type
922: );
923:
924: IF (l_log_statement >= l_log_current_level) THEN
925: FND_LOG.string(l_log_statement, l_full_name,
926: 'AHL_MC_Node_PVT.Create_Node returned x_return_status as ' || x_return_status||
927: ', node relationship id = '||l_nodes_tbl(i).relationship_id);
928: END IF;
929:

Line 933: FND_LOG.string(l_log_statement, l_full_name,

929:
930: -- check for the return status
931: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
932: IF (l_log_statement >= l_log_current_level) THEN
933: FND_LOG.string(l_log_statement, l_full_name,
934: 'Raising exception with x_return_status = ' || x_return_status);
935: END IF;
936: RAISE FND_API.G_EXC_ERROR;
937: END IF;

Line 973: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'End of the API');

969: p_msg_count => 0
970: );
971:
972: IF (l_log_procedure >= l_log_current_level) THEN
973: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'End of the API');
974: END IF;
975:
976: EXCEPTION
977: WHEN FND_API.G_EXC_ERROR THEN

Line 1088: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

1084: --
1085:
1086: BEGIN
1087: IF (l_log_procedure >= l_log_current_level) THEN
1088: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
1089: END IF;
1090:
1091: -- Standard start of API savepoint
1092: SAVEPOINT Process_Item_Composition_Pub;

Line 1112: FND_LOG.string(l_log_statement, l_full_name, 'l_user_id = '||l_user_id||', l_resp_id = '||l_resp_id);

1108: -- get the Enigma user and responsibility, and call apps_initialize
1109: l_user_id := FND_PROFILE.VALUE('AHL_ENIGMA_USER');
1110: l_resp_id := FND_PROFILE.VALUE('AHL_ENIGMA_RESPONSIBILITY');
1111: IF (l_log_statement >= l_log_current_level) THEN
1112: FND_LOG.string(l_log_statement, l_full_name, 'l_user_id = '||l_user_id||', l_resp_id = '||l_resp_id);
1113: END IF;
1114: BEGIN
1115: FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_app_id);
1116: EXCEPTION

Line 1119: FND_LOG.string(l_log_statement, l_full_name, 'FND_GLOBAL.APPS_INITIALIZE call failed - '||SQLERRM);

1115: FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_app_id);
1116: EXCEPTION
1117: WHEN OTHERS THEN
1118: IF (l_log_statement >= l_log_current_level) THEN
1119: FND_LOG.string(l_log_statement, l_full_name, 'FND_GLOBAL.APPS_INITIALIZE call failed - '||SQLERRM);
1120: END IF;
1121: END;
1122:
1123: -- get the org id from the new profile

Line 1127: FND_LOG.string(l_log_statement, l_full_name, 'l_org_id = '||l_org_id);

1123: -- get the org id from the new profile
1124: l_org_id := FND_PROFILE.VALUE('AHL_ENIGMA_ITEM_ORG');
1125:
1126: IF (l_log_statement >= l_log_current_level) THEN
1127: FND_LOG.string(l_log_statement, l_full_name, 'l_org_id = '||l_org_id);
1128: END IF;
1129:
1130: -- check for the profile value
1131: IF (l_org_id IS NULL) THEN

Line 1142: FND_LOG.string(l_log_statement, l_full_name,

1138: l_ic_header_rec.inventory_org_id := l_org_id;
1139: l_ic_header_rec.inventory_master_org_id := l_org_id;
1140:
1141: IF (l_log_statement >= l_log_current_level) THEN
1142: FND_LOG.string(l_log_statement, l_full_name,
1143: 'operation flag for the header = '||l_ic_header_rec.operation_flag);
1144: END IF;
1145:
1146: -- convert the operation flag: 'N' to 'C'

Line 1159: FND_LOG.string(l_log_statement, l_full_name, 'l_det_tbl.COUNT = '|| l_det_tbl.COUNT);

1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1156: END IF;
1157:
1158: IF (l_log_statement >= l_log_current_level) THEN
1159: FND_LOG.string(l_log_statement, l_full_name, 'l_det_tbl.COUNT = '|| l_det_tbl.COUNT);
1160: END IF;
1161:
1162: -- check for item details table
1163: IF (l_det_tbl.COUNT < 1) THEN

Line 1165: FND_LOG.string(l_log_statement, l_full_name, 'no items for the composition');

1161:
1162: -- check for item details table
1163: IF (l_det_tbl.COUNT < 1) THEN
1164: IF (l_log_statement >= l_log_current_level) THEN
1165: FND_LOG.string(l_log_statement, l_full_name, 'no items for the composition');
1166: END IF;
1167: -- items table can't be empty for creation and update - it needs at least one item
1168: IF (l_ic_header_rec.operation_flag <> 'D') THEN
1169: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ENIGMA_CL_NO_ITEMS'); -- At least one composition item is required to create or update the Composition List. (new message)

Line 1192: FND_LOG.string(l_log_statement, l_full_name,

1188: END IF;
1189: CLOSE get_ic_id_csr;
1190:
1191: IF (l_log_statement >= l_log_current_level) THEN
1192: FND_LOG.string(l_log_statement, l_full_name,
1193: 'Calling private API AHL_MC_ITEM_COMP_PVT.Delete_Item_Composition.');
1194: END IF;
1195:
1196: -- call the private API

Line 1208: FND_LOG.string(l_log_statement, l_full_name,

1204: p_object_version_number => l_ic_header_rec.object_version_number
1205: );
1206:
1207: IF (l_log_statement >= l_log_current_level) THEN
1208: FND_LOG.string(l_log_statement, l_full_name,
1209: 'AHL_MC_ITEM_COMP_PVT.Delete_Item_Composition returned x_return_status as ' || x_return_status);
1210: END IF;
1211:
1212: -- check for the return status

Line 1215: FND_LOG.string(l_log_statement, l_full_name,

1211:
1212: -- check for the return status
1213: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1214: IF (l_log_statement >= l_log_current_level) THEN
1215: FND_LOG.string(l_log_statement, l_full_name,
1216: 'Raising exception with x_return_status = ' || x_return_status);
1217: END IF;
1218: RAISE FND_API.G_EXC_ERROR;
1219: END IF;

Line 1273: FND_LOG.string(l_log_statement, l_full_name,

1269: END IF;
1270: END IF;
1271:
1272: IF (l_log_statement >= l_log_current_level) THEN
1273: FND_LOG.string(l_log_statement, l_full_name,
1274: 'Calling private API AHL_MC_ITEM_COMP_PVT.Create_Item_Composition.');
1275: END IF;
1276:
1277: -- call the private API

Line 1289: FND_LOG.string(l_log_statement, l_full_name,

1285: p_x_det_tbl => l_det_tbl
1286: );
1287:
1288: IF (l_log_statement >= l_log_current_level) THEN
1289: FND_LOG.string(l_log_statement, l_full_name,
1290: 'AHL_MC_ITEM_COMP_PVT.Create_Item_Composition returned x_return_status as ' || x_return_status);
1291: END IF;
1292:
1293: -- check for the return status

Line 1296: FND_LOG.string(l_log_statement, l_full_name,

1292:
1293: -- check for the return status
1294: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1295: IF (l_log_statement >= l_log_current_level) THEN
1296: FND_LOG.string(l_log_statement, l_full_name,
1297: 'Raising exception with x_return_status = ' || x_return_status);
1298: END IF;
1299: RAISE FND_API.G_EXC_ERROR;
1300: END IF;

Line 1304: FND_LOG.string(l_log_statement, l_full_name,

1300: END IF;
1301:
1302: -- move the item composition to Complete status
1303: IF (l_log_statement >= l_log_current_level) THEN
1304: FND_LOG.string(l_log_statement, l_full_name,
1305: 'Calling private API AHL_MC_ITEM_COMP_PVT.Approve_Item_Composiiton.');
1306: END IF;
1307:
1308: -- call the private API

Line 1322: FND_LOG.string(l_log_statement, l_full_name,

1318: p_object_version_number => 1
1319: );
1320:
1321: IF (l_log_statement >= l_log_current_level) THEN
1322: FND_LOG.string(l_log_statement, l_full_name,
1323: 'AHL_MC_ITEM_COMP_PVT.Approve_Item_Composiiton returned x_return_status as ' || x_return_status);
1324: END IF;
1325:
1326: -- check for the return status

Line 1329: FND_LOG.string(l_log_statement, l_full_name,

1325:
1326: -- check for the return status
1327: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1328: IF (l_log_statement >= l_log_current_level) THEN
1329: FND_LOG.string(l_log_statement, l_full_name,
1330: 'Raising exception with x_return_status = ' || x_return_status);
1331: END IF;
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;

Line 1407: FND_LOG.string(l_log_statement, l_full_name,

1403: END IF;
1404: END IF;
1405:
1406: IF (l_log_statement >= l_log_current_level) THEN
1407: FND_LOG.string(l_log_statement, l_full_name,
1408: 'Calling private API AHL_MC_ITEM_COMP_PVT.Modify_Item_Composition.');
1409: END IF;
1410:
1411: -- call the private API

Line 1423: FND_LOG.string(l_log_statement, l_full_name,

1419: p_x_det_tbl => l_det_tbl
1420: );
1421:
1422: IF (l_log_statement >= l_log_current_level) THEN
1423: FND_LOG.string(l_log_statement, l_full_name,
1424: 'AHL_MC_ITEM_COMP_PVT.Modify_Item_Composition returned x_return_status as ' || x_return_status);
1425: END IF;
1426:
1427: -- check for the return status

Line 1430: FND_LOG.string(l_log_statement, l_full_name,

1426:
1427: -- check for the return status
1428: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1429: IF (l_log_statement >= l_log_current_level) THEN
1430: FND_LOG.string(l_log_statement, l_full_name,
1431: 'Raising exception with x_return_status = ' || x_return_status);
1432: END IF;
1433: RAISE FND_API.G_EXC_ERROR;
1434: END IF;

Line 1454: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'End of the API');

1450: p_msg_count => 0
1451: );
1452:
1453: IF (l_log_procedure >= l_log_current_level) THEN
1454: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'End of the API');
1455: END IF;
1456:
1457: EXCEPTION
1458: WHEN FND_API.G_EXC_ERROR THEN