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

Line 31: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

27: G_MAPPING_STATUS_EMPTY CONSTANT VARCHAR2(30) := 'EMPTY';
28: G_MAPPING_STATUS_NA CONSTANT VARCHAR2(30) := 'NA';
29:
30: -- Added by skpathak on 06-NOV-2008 for bug-7336824
31: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
33: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 32: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

28: G_MAPPING_STATUS_NA CONSTANT VARCHAR2(30) := 'NA';
29:
30: -- Added by skpathak on 06-NOV-2008 for bug-7336824
31: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
33: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
36:

Line 33: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

29:
30: -- Added by skpathak on 06-NOV-2008 for bug-7336824
31: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
33: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
36:
37: -------------------------------------------------

Line 34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

30: -- Added by skpathak on 06-NOV-2008 for bug-7336824
31: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
33: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
36:
37: -------------------------------------------------
38: -- Declare Locally used Record and Table Types --

Line 35: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

31: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
33: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
36:
37: -------------------------------------------------
38: -- Declare Locally used Record and Table Types --
39: -------------------------------------------------

Line 203: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

199:
200: BEGIN
201:
202: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
203: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
204: END IF;
205: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
206: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Input values for the Procedure: ' ||
207: 'p_route_id = ' || p_route_id ||

Line 206: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Input values for the Procedure: ' ||

202: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
203: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
204: END IF;
205: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
206: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Input values for the Procedure: ' ||
207: 'p_route_id = ' || p_route_id ||
208: ', p_mr_route_id = ' || p_mr_route_id ||
209: ', p_item_instance_id = ' || p_item_instance_id ||
210: ', p_requirement_date = ' || p_requirement_date ||

Line 279: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'l_disp_req_list.COUNT = ' || l_disp_req_list.COUNT);

275: ELSIF (l_route_req_list.COUNT = 0) THEN
276: x_route_mtl_req_tbl := l_disp_req_list;
277: ELSE
278: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'l_disp_req_list.COUNT = ' || l_disp_req_list.COUNT);
280: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'l_route_req_list.COUNT = ' || l_route_req_list.COUNT);
281: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Both lists are non-empty. Merging...');
282: END IF;
283: x_route_mtl_req_tbl := l_disp_req_list;

Line 280: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'l_route_req_list.COUNT = ' || l_route_req_list.COUNT);

276: x_route_mtl_req_tbl := l_disp_req_list;
277: ELSE
278: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'l_disp_req_list.COUNT = ' || l_disp_req_list.COUNT);
280: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'l_route_req_list.COUNT = ' || l_route_req_list.COUNT);
281: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Both lists are non-empty. Merging...');
282: END IF;
283: x_route_mtl_req_tbl := l_disp_req_list;
284: l_index := x_route_mtl_req_tbl.COUNT;

Line 281: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Both lists are non-empty. Merging...');

277: ELSE
278: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'l_disp_req_list.COUNT = ' || l_disp_req_list.COUNT);
280: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'l_route_req_list.COUNT = ' || l_route_req_list.COUNT);
281: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Both lists are non-empty. Merging...');
282: END IF;
283: x_route_mtl_req_tbl := l_disp_req_list;
284: l_index := x_route_mtl_req_tbl.COUNT;
285: FOR i in l_route_req_list.FIRST .. l_route_req_list.LAST LOOP

Line 300: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Adding Route requirement with index ' || i ||

296: END LOOP;
297: IF(l_found = FALSE) THEN
298: -- Add this Route requirement to the combined list
299: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
300: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Adding Route requirement with index ' || i ||
301: ' to the combined list.');
302: END IF;
303: l_index := l_index + 1;
304: x_route_mtl_req_tbl(l_index) := l_route_req_list(i);

Line 308: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Route requirement with index ' || i || ' is a duplicate. Ignoring.');

304: x_route_mtl_req_tbl(l_index) := l_route_req_list(i);
305: ELSE
306: -- Duplicate: Ignore
307: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
308: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Route requirement with index ' || i || ' is a duplicate. Ignoring.');
309: END IF;
310: END IF;
311: END LOOP;
312: END IF;

Line 315: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Size of the merged list: ' || x_route_mtl_req_tbl.COUNT);

311: END LOOP;
312: END IF;
313:
314: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
315: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Size of the merged list: ' || x_route_mtl_req_tbl.COUNT);
316: END IF;
317:
318: -- Get the first item for item groups if forecasting
319: IF(x_route_mtl_req_tbl.COUNT > 0 AND p_request_type = G_REQ_TYPE_FORECAST) THEN

Line 329: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'For merged requirement ' || i ||

325: FETCH get_item_group_item_csr INTO x_route_mtl_req_tbl(i).INVENTORY_ITEM_ID,
326: x_route_mtl_req_tbl(i).INV_MASTER_ORG_ID;
327: CLOSE get_item_group_item_csr;
328: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
329: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'For merged requirement ' || i ||
330: ', Got Item Id as ' || x_route_mtl_req_tbl(i).INVENTORY_ITEM_ID ||
331: ' for item group id ' || x_route_mtl_req_tbl(i).ITEM_GROUP_ID);
332: END IF;
333: END IF;

Line 345: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

341: p_encoded => fnd_api.g_false
342: );
343:
344: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
345: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
346: END IF;
347:
348: EXCEPTION
349: WHEN FND_API.G_EXC_ERROR THEN

Line 443: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Could not convert from ' || p_source_uom_code ||

439: to_name => null);
440: IF (l_converted_qty < 0) THEN
441: l_converted_qty := null;
442: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
443: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Could not convert from ' || p_source_uom_code ||
444: ' to ' || l_primary_uom || '. Returning null quantity.');
445: END IF;
446: END IF;
447: RETURN l_converted_qty;

Line 537: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

533:
534: BEGIN
535:
536: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
537: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
538: END IF;
539:
540: -- Get the Route Id
541: IF (p_route_id IS NULL AND p_mr_route_id IS NULL) THEN

Line 545: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);

541: IF (p_route_id IS NULL AND p_mr_route_id IS NULL) THEN
542: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_ROUTE_ID_NULL');
543: FND_MSG_PUB.ADD;
544: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
545: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
546: END IF;
547: ELSIF (p_route_id IS NULL) THEN
548: OPEN get_route_id_csr;
549: FETCH get_route_id_csr INTO x_route_id;

Line 563: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);

559: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_ROUTE_ID_INVALID');
560: FND_MESSAGE.Set_Token('ROUTE_ID', x_route_id);
561: FND_MSG_PUB.ADD;
562: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
564: END IF;
565: END IF;
566: CLOSE validate_route_id_csr;
567:

Line 573: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);

569: IF (p_item_instance_id IS NULL) THEN
570: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_INST_ID_NULL');
571: FND_MSG_PUB.ADD;
572: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
573: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
574: END IF;
575: ELSE
576: OPEN validate_instance_id_csr;
577: FETCH validate_instance_id_csr INTO l_dummy;

Line 583: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);

579: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_INST_ID_INVALID');
580: FND_MESSAGE.Set_Token('INST_ID', p_item_instance_id);
581: FND_MSG_PUB.ADD;
582: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
583: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
584: END IF;
585: END IF;
586: CLOSE validate_instance_id_csr;
587: END IF;

Line 594: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);

590: IF (p_request_type IS NULL) THEN
591: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_TYPE_NULL');
592: FND_MSG_PUB.ADD;
593: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
594: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
595: END IF;
596: ELSIF (p_request_type NOT IN (G_REQ_TYPE_FORECAST, G_REQ_TYPE_PLANNED)) THEN
597: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_TYPE_INVALID');
598: FND_MESSAGE.Set_Token('REQ_TYPE', p_request_type);

Line 601: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);

597: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_TYPE_INVALID');
598: FND_MESSAGE.Set_Token('REQ_TYPE', p_request_type);
599: FND_MSG_PUB.ADD;
600: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
601: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
602: END IF;
603: END IF;
604:
605: -- Validate the Requirement Date

Line 610: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);

606: IF (p_requirement_date IS NULL) THEN
607: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_DATE_NULL');
608: FND_MSG_PUB.ADD;
609: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
610: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
611: END IF;
612: ELSIF (TRUNC(p_requirement_date) < TRUNC(SYSDATE)) THEN
613: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_DATE_PAST');
614: FND_MESSAGE.Set_Token('REQ_DATE', p_requirement_date);

Line 617: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);

613: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_DATE_PAST');
614: FND_MESSAGE.Set_Token('REQ_DATE', p_requirement_date);
615: FND_MSG_PUB.ADD;
616: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
618: END IF;
619: END IF;
620:
621: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 622: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

618: END IF;
619: END IF;
620:
621: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
622: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
623: END IF;
624:
625: END Validate_Mtl_Req_Input;
626:

Line 704: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

700:
701: BEGIN
702:
703: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
704: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
705: END IF;
706:
707: -- Get the Route Effectivity
708: OPEN get_mc_route_eff_id_csr;

Line 725: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'No disposition list found for MC Header Id: ' || p_mc_header_id

721:
722: IF(l_item_route_effectivity_id = -1 AND l_mc_route_effectivity_id = -1) THEN
723: -- No Disposition List available
724: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
725: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'No disposition list found for MC Header Id: ' || p_mc_header_id
726: || ', MC Id: ' || p_mc_id
727: || ', Item Id: ' || p_inst_item_id);
728: END IF;
729: RETURN;

Line 745: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || l_disp_req_rec.RT_OPER_MATERIAL_ID ||

741: -- Quantity in Item's Primary UOM
742: x_disp_req_list(l_index).QUANTITY := l_disp_req_rec.PRIMARY_QUANTITY;
743: x_disp_req_list(l_index).UOM_CODE := l_disp_req_rec.PRIMARY_UOM_CODE;
744: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
745: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || l_disp_req_rec.RT_OPER_MATERIAL_ID ||
746: ', INVENTORY_ITEM_ID = ' || l_disp_req_rec.INVENTORY_ITEM_ID ||
747: ', INV_MASTER_ORG_ID = ' || l_disp_req_rec.INVENTORY_ORG_ID ||
748: ', QUANTITY = ' || l_disp_req_rec.PRIMARY_QUANTITY ||
749: ', UOM_CODE = ' || l_disp_req_rec.PRIMARY_UOM_CODE);

Line 758: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || l_disp_req_rec.RT_OPER_MATERIAL_ID ||

754: x_disp_req_list(l_index).ITEM_GROUP_ID := l_disp_req_rec.ITEM_GROUP_ID;
755: x_disp_req_list(l_index).QUANTITY := l_disp_req_rec.QUANTITY;
756: x_disp_req_list(l_index).UOM_CODE := l_disp_req_rec.UOM_CODE;
757: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
758: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || l_disp_req_rec.RT_OPER_MATERIAL_ID ||
759: ', ITEM_GROUP_ID = ' || l_disp_req_rec.ITEM_GROUP_ID ||
760: ', QUANTITY = ' || l_disp_req_rec.QUANTITY ||
761: ', UOM_CODE = ' || l_disp_req_rec.UOM_CODE);
762: END IF;

Line 778: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || l_disp_req_rec.RT_OPER_MATERIAL_ID ||

774: x_disp_req_list(l_index).QUANTITY,
775: x_disp_req_list(l_index).UOM_CODE;
776: CLOSE get_item_comp_dtls_csr;
777: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
778: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || l_disp_req_rec.RT_OPER_MATERIAL_ID ||
779: ', ITEM_COMP_DETAIL_ID = ' || l_disp_req_rec.ITEM_COMP_DETAIL_ID ||
780: ', INVENTORY_ITEM_ID = ' || x_disp_req_list(l_index).INVENTORY_ITEM_ID ||
781: ', INV_MASTER_ORG_ID = ' || x_disp_req_list(l_index).INV_MASTER_ORG_ID ||
782: ', ITEM_GROUP_ID = ' || x_disp_req_list(l_index).ITEM_GROUP_ID ||

Line 792: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Ignoring Disp. List Requirement with Position Path Id ' || l_disp_req_rec.POSITION_PATH_ID);

788: IF (p_mc_header_id IS NULL) THEN
789: -- Ignore this Position Path specific requirement since the current instance
790: -- is not a UC unit (is not of any MC type)
791: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
792: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Ignoring Disp. List Requirement with Position Path Id ' || l_disp_req_rec.POSITION_PATH_ID);
793: END IF;
794: ELSE
795: -- Get the Position Path requirement if applicable
796: IF (l_disp_req_rec.PATH_POS_COMMON_ID <> l_last_common_id) THEN

Line 827: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Total number of disposition requirements: ' || x_disp_req_list.COUNT);

823: l_index := x_disp_req_list.COUNT; -- Set output table index to always point to the last added record.
824: END IF;
825: END LOOP;
826: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
827: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Total number of disposition requirements: ' || x_disp_req_list.COUNT);
828: END IF;
829:
830: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
831: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

Line 831: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

827: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Total number of disposition requirements: ' || x_disp_req_list.COUNT);
828: END IF;
829:
830: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
831: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
832: END IF;
833:
834: END Get_Disp_List_Requirements;
835:

Line 881: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

877:
878: BEGIN
879:
880: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
881: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
882: END IF;
883:
884: -- First validate the Position Path and get the Position Details
885: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 886: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Calling Validate_Path_Position with ' ||

882: END IF;
883:
884: -- First validate the Position Path and get the Position Details
885: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
886: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Calling Validate_Path_Position with ' ||
887: 'p_position_path_id = ' || p_position_path_id ||
888: ', p_unit_instance_id = ' || p_unit_instance_id ||
889: ', p_requirement_date = ' || p_requirement_date);
890: END IF;

Line 900: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Validate_Path_Position returned ' ||

896: x_item_group_id => l_pos_item_group_id,
897: x_pos_instance_id => l_pos_instance_id);
898:
899: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
900: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Validate_Path_Position returned ' ||
901: 'x_valid_flag = ' || l_valid_flag ||
902: ', x_relationship_id = ' || l_position_id ||
903: ', x_item_group_id = ' || l_pos_item_group_id ||
904: ', x_pos_instance_id = ' || l_pos_instance_id);

Line 917: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Position ' || l_position_id || ' is empty and has item group ' ||

913: -- The position is empty
914: -- If the position has an item group associated, copy that as the requirement
915: IF (l_pos_item_group_id IS NOT NULL) THEN
916: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
917: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Position ' || l_position_id || ' is empty and has item group ' ||
918: l_pos_item_group_id || ' associated with it.');
919: END IF;
920: p_x_disp_req_list(l_next_index).ITEM_GROUP_ID := l_pos_item_group_id;
921: ELSE

Line 928: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Chosen Sub MC Header Id ' || l_sub_unit_mc ||

924: FETCH get_sub_mc_for_pos_csr INTO l_sub_unit_mc;
925: CLOSE get_sub_mc_for_pos_csr;
926: -- Get the Item group for the root node of the chosen Sub MC
927: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
928: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Chosen Sub MC Header Id ' || l_sub_unit_mc ||
929: ' for empty position with id ' || l_position_id);
930: END IF;
931: OPEN get_item_grp_for_mc_csr(c_mc_header_id => l_sub_unit_mc);
932: FETCH get_item_grp_for_mc_csr INTO p_x_disp_req_list(l_next_index).ITEM_GROUP_ID;

Line 945: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Sub unit with Sub MC Header Id ' || l_sub_unit_mc ||

941: FETCH get_sub_unit_mc_csr INTO l_sub_unit_mc;
942: IF(get_sub_unit_mc_csr%FOUND) THEN
943: -- A sub unit (UC) is installed in the position
944: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
945: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Sub unit with Sub MC Header Id ' || l_sub_unit_mc ||
946: ' installed at position with id ' || l_position_id);
947: END IF;
948: -- Get the Item group for the root node of the Sub unit's MC
949: OPEN get_item_grp_for_mc_csr(c_mc_header_id => l_sub_unit_mc);

Line 956: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Simple instance with id ' || l_pos_instance_id ||

952: ELSE
953: -- An instance (not a sub unit) is installed in the position
954: -- Add this position's item group as requirement to the list
955: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
956: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Simple instance with id ' || l_pos_instance_id ||
957: ' installed at position with id ' || l_position_id);
958: END IF;
959: p_x_disp_req_list(l_next_index).ITEM_GROUP_ID := l_pos_item_group_id;
960: END IF; -- Sub unit or instance

Line 966: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Position Id ' || l_position_id || ' corresponds to the root node.');

962: ELSE
963: -- Root Node
964: -- Add the item group requirement to the list
965: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
966: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Position Id ' || l_position_id || ' corresponds to the root node.');
967: END IF;
968: p_x_disp_req_list(l_next_index).ITEM_GROUP_ID := l_pos_item_group_id;
969: END IF; -- Root node or not
970: END IF; -- Position is empty or not

Line 979: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_next_index || ': RT_OPER_MATERIAL_ID = ' || p_rt_oper_mtl_id ||

975: p_x_disp_req_list(l_next_index).RELATIONSHIP_ID := l_position_id;
976: p_x_disp_req_list(l_next_index).QUANTITY := p_quantity;
977: p_x_disp_req_list(l_next_index).UOM_CODE := p_uom;
978: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
979: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_next_index || ': RT_OPER_MATERIAL_ID = ' || p_rt_oper_mtl_id ||
980: ', ITEM_GROUP_ID = ' || p_x_disp_req_list(l_next_index).ITEM_GROUP_ID ||
981: ', POSITION_PATH_ID = ' || p_position_path_id ||
982: ', RELATIONSHIP_ID = ' || l_position_id ||
983: ', QUANTITY = ' || p_quantity ||

Line 988: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

984: ', UOM_CODE = ' || p_uom);
985: END IF;
986:
987: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
988: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
989: END IF;
990:
991: END Get_Pos_Path_Requirement;
992:

Line 1239: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

1235:
1236: BEGIN
1237:
1238: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1239: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1240: END IF;
1241:
1242: -- Get the requirements defined at the route level (if any)
1243: OPEN get_route_level_reqs_csr;

Line 1248: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirements for Route with Id ' || p_route_id || ' are defined at the Route level itself.');

1244: FETCH get_route_level_reqs_csr INTO l_rt_requirement_rec;
1245: IF(get_route_level_reqs_csr%FOUND) THEN
1246: -- Requirements defined at the Route level
1247: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1248: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirements for Route with Id ' || p_route_id || ' are defined at the Route level itself.');
1249: END IF;
1250: LOOP
1251: EXIT WHEN get_route_level_reqs_csr%NOTFOUND;
1252: -- Process this requirement

Line 1268: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || l_rt_requirement_rec.RT_OPER_MATERIAL_ID ||

1264: x_route_req_list(l_index).QUANTITY := l_rt_requirement_rec.PRIMARY_QUANTITY;
1265: x_route_req_list(l_index).UOM_CODE := l_rt_requirement_rec.PRIMARY_UOM_CODE;
1266: END IF;
1267: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1268: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || l_rt_requirement_rec.RT_OPER_MATERIAL_ID ||
1269: ', ITEM_GROUP_ID = ' || x_route_req_list(l_index).ITEM_GROUP_ID ||
1270: ', INVENTORY_ITEM_ID = ' || x_route_req_list(l_index).INVENTORY_ITEM_ID ||
1271: ', INV_MASTER_ORG_ID = ' || x_route_req_list(l_index).INV_MASTER_ORG_ID ||
1272: ', QUANTITY = ' || x_route_req_list(l_index).QUANTITY ||

Line 1283: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirements for Route with Id ' || p_route_id ||

1279: ELSE
1280: -- No requirement defined at route level
1281: CLOSE get_route_level_reqs_csr;
1282: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1283: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirements for Route with Id ' || p_route_id ||
1284: ' are NOT defined at the Route level. Checking at the operation level.');
1285: END IF;
1286: -- AnRaj : Start for fixing perf bug 4919527
1287: -- AnRaj : Changed the code for fixing the performance bug# 4919527

Line 1291: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'p_request type is G_REQ_TYPE_FORECAST');

1287: -- AnRaj : Changed the code for fixing the performance bug# 4919527
1288: -- Split the query into 3 to avoid the cursor get_op_level_reqs_csr
1289: IF p_request_type = G_REQ_TYPE_FORECAST THEN
1290: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1291: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'p_request type is G_REQ_TYPE_FORECAST');
1292: END IF;
1293:
1294: FOR l_op_requirement_rec IN get_op_level_reqs_forecast_csr LOOP
1295: l_index := l_index + 1;

Line 1304: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || x_route_req_list(l_index).RT_OPER_MATERIAL_ID ||

1300: x_route_req_list(l_index).INV_MASTER_ORG_ID := l_op_requirement_rec.INVENTORY_ORG_ID;
1301: x_route_req_list(l_index).QUANTITY := l_op_requirement_rec.QUANTITY;
1302: x_route_req_list(l_index).UOM_CODE := l_op_requirement_rec.UOM_CODE;
1303: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1304: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || x_route_req_list(l_index).RT_OPER_MATERIAL_ID ||
1305: ', ROUTE_OPERATION_ID = ' || x_route_req_list(l_index).ROUTE_OPERATION_ID ||
1306: ', ITEM_GROUP_ID = ' || x_route_req_list(l_index).ITEM_GROUP_ID ||
1307: ', INVENTORY_ITEM_ID = ' || x_route_req_list(l_index).INVENTORY_ITEM_ID ||
1308: ', INV_MASTER_ORG_ID = ' || x_route_req_list(l_index).INV_MASTER_ORG_ID ||

Line 1315: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'p_request type is G_REQ_TYPE_PLANNED');

1311: END IF;
1312: END LOOP;
1313: ELSIF p_request_type = G_REQ_TYPE_PLANNED THEN
1314: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1315: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'p_request type is G_REQ_TYPE_PLANNED');
1316: END IF;
1317:
1318: FOR l_op_requirement_rec IN get_op_level_reqs_planned_csr LOOP
1319: l_index := l_index + 1;

Line 1328: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || x_route_req_list(l_index).RT_OPER_MATERIAL_ID ||

1324: x_route_req_list(l_index).INV_MASTER_ORG_ID := l_op_requirement_rec.INVENTORY_ORG_ID;
1325: x_route_req_list(l_index).QUANTITY := l_op_requirement_rec.QUANTITY;
1326: x_route_req_list(l_index).UOM_CODE := l_op_requirement_rec.UOM_CODE;
1327: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1328: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || x_route_req_list(l_index).RT_OPER_MATERIAL_ID ||
1329: ', ROUTE_OPERATION_ID = ' || x_route_req_list(l_index).ROUTE_OPERATION_ID ||
1330: ', ITEM_GROUP_ID = ' || x_route_req_list(l_index).ITEM_GROUP_ID ||
1331: ', INVENTORY_ITEM_ID = ' || x_route_req_list(l_index).INVENTORY_ITEM_ID ||
1332: ', INV_MASTER_ORG_ID = ' || x_route_req_list(l_index).INV_MASTER_ORG_ID ||

Line 1342: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'p_request type is neither G_REQ_TYPE_PLANNED nor G_REQ_TYPE_FORECAST');

1338: -- Not too sure whether the value of p_request_type can be anything other than G_REQ_TYPE_FORECAST and G_REQ_TYPE_PLANNED
1339: -- Adding this part for safety purpose, so that no records are missed out
1340: ELSE
1341: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1342: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'p_request type is neither G_REQ_TYPE_PLANNED nor G_REQ_TYPE_FORECAST');
1343: END IF;
1344:
1345: FOR l_op_requirement_rec IN l_op_requirement_neither_csr LOOP
1346: l_index := l_index + 1;

Line 1355: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || x_route_req_list(l_index).RT_OPER_MATERIAL_ID ||

1351: x_route_req_list(l_index).INV_MASTER_ORG_ID := l_op_requirement_rec.INVENTORY_ORG_ID;
1352: x_route_req_list(l_index).QUANTITY := l_op_requirement_rec.QUANTITY;
1353: x_route_req_list(l_index).UOM_CODE := l_op_requirement_rec.UOM_CODE;
1354: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1355: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || x_route_req_list(l_index).RT_OPER_MATERIAL_ID ||
1356: ', ROUTE_OPERATION_ID = ' || x_route_req_list(l_index).ROUTE_OPERATION_ID ||
1357: ', ITEM_GROUP_ID = ' || x_route_req_list(l_index).ITEM_GROUP_ID ||
1358: ', INVENTORY_ITEM_ID = ' || x_route_req_list(l_index).INVENTORY_ITEM_ID ||
1359: ', INV_MASTER_ORG_ID = ' || x_route_req_list(l_index).INV_MASTER_ORG_ID ||

Line 1378: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || x_route_req_list(l_index).RT_OPER_MATERIAL_ID ||

1374: x_route_req_list(l_index).INV_MASTER_ORG_ID := l_op_requirement_rec.INVENTORY_ORG_ID;
1375: x_route_req_list(l_index).QUANTITY := l_op_requirement_rec.QUANTITY;
1376: x_route_req_list(l_index).UOM_CODE := l_op_requirement_rec.UOM_CODE;
1377: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1378: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Requirement ' || l_index || ': RT_OPER_MATERIAL_ID = ' || x_route_req_list(l_index).RT_OPER_MATERIAL_ID ||
1379: ', ROUTE_OPERATION_ID = ' || x_route_req_list(l_index).ROUTE_OPERATION_ID ||
1380: ', ITEM_GROUP_ID = ' || x_route_req_list(l_index).ITEM_GROUP_ID ||
1381: ', INVENTORY_ITEM_ID = ' || x_route_req_list(l_index).INVENTORY_ITEM_ID ||
1382: ', INV_MASTER_ORG_ID = ' || x_route_req_list(l_index).INV_MASTER_ORG_ID ||

Line 1391: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Total number of Route requirements: ' || l_index);

1387: */
1388: -- AnRaj : End for fixing perf bug 4919527
1389: END IF;
1390: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1391: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Total number of Route requirements: ' || l_index);
1392: END IF;
1393: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1394: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
1395: END IF;

Line 1394: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

1390: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1391: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Total number of Route requirements: ' || l_index);
1392: END IF;
1393: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1394: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
1395: END IF;
1396:
1397: END Get_Route_Requirements;
1398:

Line 1481: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

1477:
1478: BEGIN
1479:
1480: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1481: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1482: END IF;
1483:
1484: IF (G_LEVEL_EVENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1485: FND_LOG.STRING(G_LEVEL_EVENT, L_DEBUG_KEY, 'About to call AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance with ' ||

Line 1485: FND_LOG.STRING(G_LEVEL_EVENT, L_DEBUG_KEY, 'About to call AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance with ' ||

1481: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1482: END IF;
1483:
1484: IF (G_LEVEL_EVENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1485: FND_LOG.STRING(G_LEVEL_EVENT, L_DEBUG_KEY, 'About to call AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance with ' ||
1486: ' p_position_id = ' || p_path_position_id ||
1487: ' p_csi_item_instance_id = ' || p_unit_instance_id);
1488: END IF;
1489:

Line 1504: FND_LOG.STRING(G_LEVEL_EVENT, L_DEBUG_KEY, 'Returned from call to AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance:' ||

1500: x_lowest_uc_csi_id => l_lowest_unit_inst_id,
1501: x_mapping_status => l_mapping_status);
1502:
1503: IF (G_LEVEL_EVENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1504: FND_LOG.STRING(G_LEVEL_EVENT, L_DEBUG_KEY, 'Returned from call to AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance:' ||
1505: ' x_return_status = ' || l_return_status ||
1506: ', x_mapping_status = ' || l_mapping_status ||
1507: ', x_item_instance_id = ' || l_installed_inst_id ||
1508: ', x_lowest_uc_csi_id = ' || l_lowest_unit_inst_id);

Line 1587: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

1583: x_pos_instance_id := NULL;
1584: END IF;
1585:
1586: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1587: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
1588: END IF;
1589:
1590: END Validate_Path_Position;
1591:

Line 1639: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Function');

1635: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Get_Unit_Instance';
1636:
1637: BEGIN
1638: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1639: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Function');
1640: END IF;
1641:
1642: IF(p_item_instance_id IS NULL) THEN
1643: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1644: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'p_item_instance_id is null. So, returning null.');

1640: END IF;
1641:
1642: IF(p_item_instance_id IS NULL) THEN
1643: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1644: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'p_item_instance_id is null. So, returning null.');
1645: END IF;
1646: l_instance_id := null;
1647: ELSE
1648: OPEN chk_inst_is_unit_csr;

Line 1652: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'p_item_instance_id (' || p_item_instance_id || ') itself is a unit.');

1648: OPEN chk_inst_is_unit_csr;
1649: FETCH chk_inst_is_unit_csr INTO l_dummy;
1650: IF (chk_inst_is_unit_csr%FOUND) THEN
1651: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1652: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'p_item_instance_id (' || p_item_instance_id || ') itself is a unit.');
1653: END IF;
1654: l_instance_id := p_item_instance_id;
1655: ELSE
1656: OPEN get_parent_instance_csr;

Line 1660: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Unit Instance of ' || p_item_instance_id || ' is ' || l_instance_id);

1656: OPEN get_parent_instance_csr;
1657: FETCH get_parent_instance_csr INTO l_instance_id;
1658: CLOSE get_parent_instance_csr;
1659: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1660: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Unit Instance of ' || p_item_instance_id || ' is ' || l_instance_id);
1661: END IF;
1662: END IF;
1663: CLOSE chk_inst_is_unit_csr;
1664: END IF;

Line 1667: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Function');

1663: CLOSE chk_inst_is_unit_csr;
1664: END IF;
1665:
1666: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1667: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Function');
1668: END IF;
1669: RETURN l_instance_id;
1670:
1671: END Get_Unit_Instance;