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_PP_MATERIALS_PVT dependencies on AHL_DEBUG_PUB

Line 8: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

4: -----------------------
5: -- Declare Constants --
6: -----------------------
7: G_PKG_NAME VARCHAR2(30) := 'AHL_PP_MATERIALS_PVT';
8: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
9:
10: -------------------------------------------------
11: -- Declare Locally used Record and Table Types --
12: -------------------------------------------------

Line 203: AHL_DEBUG_PUB.debug( 'XVISITTASK:'|| x_visit_task_id);

199: WHERE workorder_id = p_workorder_id;
200: END IF;
201: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
202: IF G_DEBUG='Y' THEN
203: AHL_DEBUG_PUB.debug( 'XVISITTASK:'|| x_visit_task_id);
204: END IF;
205:
206: EXCEPTION
207: WHEN NO_DATA_FOUND THEN

Line 242: AHL_DEBUG_PUB.debug( 'XWOID:'|| x_workorder_id);

238: END IF;
239:
240: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
241: IF G_DEBUG='Y' THEN
242: AHL_DEBUG_PUB.debug( 'XWOID:'|| x_workorder_id);
243: END IF;
244:
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN

Line 807: AHL_DEBUG_PUB.enable_debug;

803: -- Standard Start of API savepoint
804: SAVEPOINT create_material_reqst;
805: -- Check if API is called in debug mode. If yes, enable debug.
806: IF G_DEBUG='Y' THEN
807: AHL_DEBUG_PUB.enable_debug;
808: END IF;
809: -- Debug info.
810: IF G_DEBUG='Y' THEN
811: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. create material reqst','+PPMRP+');

Line 811: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. create material reqst','+PPMRP+');

807: AHL_DEBUG_PUB.enable_debug;
808: END IF;
809: -- Debug info.
810: IF G_DEBUG='Y' THEN
811: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. create material reqst','+PPMRP+');
812: AHL_DEBUG_PUB.debug( 'INTERAFCE FALG'||p_interface_flag);
813: AHL_DEBUG_PUB.debug( 'Total Number Records:'||p_x_req_material_tbl.COUNT);
814: END IF;
815: -- Standard call to check for call compatibility.

Line 812: AHL_DEBUG_PUB.debug( 'INTERAFCE FALG'||p_interface_flag);

808: END IF;
809: -- Debug info.
810: IF G_DEBUG='Y' THEN
811: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. create material reqst','+PPMRP+');
812: AHL_DEBUG_PUB.debug( 'INTERAFCE FALG'||p_interface_flag);
813: AHL_DEBUG_PUB.debug( 'Total Number Records:'||p_x_req_material_tbl.COUNT);
814: END IF;
815: -- Standard call to check for call compatibility.
816: IF FND_API.to_boolean(l_init_msg_list)

Line 813: AHL_DEBUG_PUB.debug( 'Total Number Records:'||p_x_req_material_tbl.COUNT);

809: -- Debug info.
810: IF G_DEBUG='Y' THEN
811: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. create material reqst','+PPMRP+');
812: AHL_DEBUG_PUB.debug( 'INTERAFCE FALG'||p_interface_flag);
813: AHL_DEBUG_PUB.debug( 'Total Number Records:'||p_x_req_material_tbl.COUNT);
814: END IF;
815: -- Standard call to check for call compatibility.
816: IF FND_API.to_boolean(l_init_msg_list)
817: THEN

Line 836: AHL_DEBUG_PUB.debug( 'WOID 1:'||p_x_req_material_tbl(i).workorder_id);

832: FOR i IN p_x_req_material_tbl.FIRST..p_x_req_material_tbl.LAST
833: LOOP
834: -- Value to ID Conversion
835: IF G_DEBUG='Y' THEN
836: AHL_DEBUG_PUB.debug( 'WOID 1:'||p_x_req_material_tbl(i).workorder_id);
837: AHL_DEBUG_PUB.debug( 'OPFLAG 1:'||p_x_req_material_tbl(i).operation_flag);
838: AHL_DEBUG_PUB.debug( 'ITEM:'||i||'-'||p_x_req_material_tbl(i).concatenated_segments);
839:
840: END IF;

Line 837: AHL_DEBUG_PUB.debug( 'OPFLAG 1:'||p_x_req_material_tbl(i).operation_flag);

833: LOOP
834: -- Value to ID Conversion
835: IF G_DEBUG='Y' THEN
836: AHL_DEBUG_PUB.debug( 'WOID 1:'||p_x_req_material_tbl(i).workorder_id);
837: AHL_DEBUG_PUB.debug( 'OPFLAG 1:'||p_x_req_material_tbl(i).operation_flag);
838: AHL_DEBUG_PUB.debug( 'ITEM:'||i||'-'||p_x_req_material_tbl(i).concatenated_segments);
839:
840: END IF;
841:

Line 838: AHL_DEBUG_PUB.debug( 'ITEM:'||i||'-'||p_x_req_material_tbl(i).concatenated_segments);

834: -- Value to ID Conversion
835: IF G_DEBUG='Y' THEN
836: AHL_DEBUG_PUB.debug( 'WOID 1:'||p_x_req_material_tbl(i).workorder_id);
837: AHL_DEBUG_PUB.debug( 'OPFLAG 1:'||p_x_req_material_tbl(i).operation_flag);
838: AHL_DEBUG_PUB.debug( 'ITEM:'||i||'-'||p_x_req_material_tbl(i).concatenated_segments);
839:
840: END IF;
841:
842: IF ( ( p_x_req_material_tbl(i).workorder_id IS NOT NULL AND

Line 849: AHL_DEBUG_PUB.debug( 'WOID 2:'||p_x_req_material_tbl(i).workorder_id);

845: p_x_req_material_tbl(i).job_number <> FND_API.G_MISS_CHAR ) )
846: THEN
847: --
848: IF G_DEBUG='Y' THEN
849: AHL_DEBUG_PUB.debug( 'WOID 2:'||p_x_req_material_tbl(i).workorder_id);
850: END IF;
851: --
852: Get_workorder_id
853: (p_workorder_id => p_x_req_material_tbl(i).workorder_id,

Line 913: AHL_DEBUG_PUB.debug( 'VTID'||p_x_req_material_tbl(i).visit_task_id);

909: END IF;
910: -- Assign
911: p_x_req_material_tbl(i).visit_task_id := l_visit_task_id;
912: IF G_DEBUG='Y' THEN
913: AHL_DEBUG_PUB.debug( 'VTID'||p_x_req_material_tbl(i).visit_task_id);
914: AHL_DEBUG_PUB.debug( 'Job Number:'||p_x_req_material_tbl(i).job_number);
915:
916: END IF;
917: -- Validate for organization,department,project_task_id

Line 914: AHL_DEBUG_PUB.debug( 'Job Number:'||p_x_req_material_tbl(i).job_number);

910: -- Assign
911: p_x_req_material_tbl(i).visit_task_id := l_visit_task_id;
912: IF G_DEBUG='Y' THEN
913: AHL_DEBUG_PUB.debug( 'VTID'||p_x_req_material_tbl(i).visit_task_id);
914: AHL_DEBUG_PUB.debug( 'Job Number:'||p_x_req_material_tbl(i).job_number);
915:
916: END IF;
917: -- Validate for organization,department,project_task_id
918: Get_visit_task_details

Line 969: AHL_DEBUG_PUB.debug( 'ORID'||p_x_req_material_tbl(i).organization_id);

965: p_x_req_material_tbl(i).project_id := l_project_id;
966: --
967:
968: IF G_DEBUG='Y' THEN
969: AHL_DEBUG_PUB.debug( 'ORID'||p_x_req_material_tbl(i).organization_id);
970: AHL_DEBUG_PUB.debug( 'DEID'||p_x_req_material_tbl(i).department_id);
971: AHL_DEBUG_PUB.debug( 'PTID'||p_x_req_material_tbl(i).project_task_id);
972: AHL_DEBUG_PUB.debug( 'PJID'||p_x_req_material_tbl(i).project_id);
973: AHL_DEBUG_PUB.debug( 'CITEM:'||p_x_req_material_tbl(i).concatenated_segments);

Line 970: AHL_DEBUG_PUB.debug( 'DEID'||p_x_req_material_tbl(i).department_id);

966: --
967:
968: IF G_DEBUG='Y' THEN
969: AHL_DEBUG_PUB.debug( 'ORID'||p_x_req_material_tbl(i).organization_id);
970: AHL_DEBUG_PUB.debug( 'DEID'||p_x_req_material_tbl(i).department_id);
971: AHL_DEBUG_PUB.debug( 'PTID'||p_x_req_material_tbl(i).project_task_id);
972: AHL_DEBUG_PUB.debug( 'PJID'||p_x_req_material_tbl(i).project_id);
973: AHL_DEBUG_PUB.debug( 'CITEM:'||p_x_req_material_tbl(i).concatenated_segments);
974: END IF;

Line 971: AHL_DEBUG_PUB.debug( 'PTID'||p_x_req_material_tbl(i).project_task_id);

967:
968: IF G_DEBUG='Y' THEN
969: AHL_DEBUG_PUB.debug( 'ORID'||p_x_req_material_tbl(i).organization_id);
970: AHL_DEBUG_PUB.debug( 'DEID'||p_x_req_material_tbl(i).department_id);
971: AHL_DEBUG_PUB.debug( 'PTID'||p_x_req_material_tbl(i).project_task_id);
972: AHL_DEBUG_PUB.debug( 'PJID'||p_x_req_material_tbl(i).project_id);
973: AHL_DEBUG_PUB.debug( 'CITEM:'||p_x_req_material_tbl(i).concatenated_segments);
974: END IF;
975: -- Convert concatenated segments to Item ID

Line 972: AHL_DEBUG_PUB.debug( 'PJID'||p_x_req_material_tbl(i).project_id);

968: IF G_DEBUG='Y' THEN
969: AHL_DEBUG_PUB.debug( 'ORID'||p_x_req_material_tbl(i).organization_id);
970: AHL_DEBUG_PUB.debug( 'DEID'||p_x_req_material_tbl(i).department_id);
971: AHL_DEBUG_PUB.debug( 'PTID'||p_x_req_material_tbl(i).project_task_id);
972: AHL_DEBUG_PUB.debug( 'PJID'||p_x_req_material_tbl(i).project_id);
973: AHL_DEBUG_PUB.debug( 'CITEM:'||p_x_req_material_tbl(i).concatenated_segments);
974: END IF;
975: -- Convert concatenated segments to Item ID
976: IF (p_x_req_material_tbl(i).concatenated_segments IS NOT NULL AND

Line 973: AHL_DEBUG_PUB.debug( 'CITEM:'||p_x_req_material_tbl(i).concatenated_segments);

969: AHL_DEBUG_PUB.debug( 'ORID'||p_x_req_material_tbl(i).organization_id);
970: AHL_DEBUG_PUB.debug( 'DEID'||p_x_req_material_tbl(i).department_id);
971: AHL_DEBUG_PUB.debug( 'PTID'||p_x_req_material_tbl(i).project_task_id);
972: AHL_DEBUG_PUB.debug( 'PJID'||p_x_req_material_tbl(i).project_id);
973: AHL_DEBUG_PUB.debug( 'CITEM:'||p_x_req_material_tbl(i).concatenated_segments);
974: END IF;
975: -- Convert concatenated segments to Item ID
976: IF (p_x_req_material_tbl(i).concatenated_segments IS NOT NULL AND
977: p_x_req_material_tbl(i).concatenated_segments <> Fnd_Api.G_MISS_CHAR ) OR

Line 1003: AHL_DEBUG_PUB.debug( 'IVID'||p_x_req_material_tbl(i).requested_quantity);

999:
1000: --Assign the returned value
1001: p_x_req_material_tbl(i).inventory_item_id := l_inventory_item_id;
1002: IF G_DEBUG='Y' THEN
1003: AHL_DEBUG_PUB.debug( 'IVID'||p_x_req_material_tbl(i).requested_quantity);
1004: END IF;
1005:
1006: -- Validate for Requested Quantity
1007: IF (p_x_req_material_tbl(i).requested_quantity IS NULL OR

Line 1022: AHL_DEBUG_PUB.debug( 'RDATE1:'||p_x_req_material_tbl(i).requested_date);

1018: END IF;
1019: --
1020:
1021: IF G_DEBUG='Y' THEN
1022: AHL_DEBUG_PUB.debug( 'RDATE1:'||p_x_req_material_tbl(i).requested_date);
1023: END IF;
1024: --
1025: IF (p_interface_flag = 'Y' OR p_interface_flag is null )THEN
1026:

Line 1042: AHL_DEBUG_PUB.debug( 'RDATE'||p_x_req_material_tbl(i).requested_date);

1038: END IF;
1039: END IF;
1040: --
1041: IF G_DEBUG='Y' THEN
1042: AHL_DEBUG_PUB.debug( 'RDATE'||p_x_req_material_tbl(i).requested_date);
1043: AHL_DEBUG_PUB.debug( 'OSID'||p_x_req_material_tbl(i).operation_sequence);
1044: END IF;
1045: --Check for operation sequence
1046: IF( p_x_req_material_tbl(i).operation_sequence IS NULL OR

Line 1043: AHL_DEBUG_PUB.debug( 'OSID'||p_x_req_material_tbl(i).operation_sequence);

1039: END IF;
1040: --
1041: IF G_DEBUG='Y' THEN
1042: AHL_DEBUG_PUB.debug( 'RDATE'||p_x_req_material_tbl(i).requested_date);
1043: AHL_DEBUG_PUB.debug( 'OSID'||p_x_req_material_tbl(i).operation_sequence);
1044: END IF;
1045: --Check for operation sequence
1046: IF( p_x_req_material_tbl(i).operation_sequence IS NULL OR
1047: p_x_req_material_tbl(i).operation_sequence = FND_API.G_MISS_NUM)

Line 1069: AHL_DEBUG_PUB.debug('OPID'||p_x_req_material_tbl(i).workorder_operation_id);

1065: -- dbms_output.put_line( 'interface flag:'||p_interface_flag);
1066:
1067: -- Check for workorder operation ID
1068: IF G_DEBUG='Y' THEN
1069: AHL_DEBUG_PUB.debug('OPID'||p_x_req_material_tbl(i).workorder_operation_id);
1070: END IF;
1071:
1072: --
1073: IF (p_x_req_material_tbl(i).workorder_operation_id IS NULL OR

Line 1141: AHL_DEBUG_PUB.debug('Local OPID:'||l_workorder_operation_id);

1137: END IF;
1138: */
1139:
1140: IF G_DEBUG='Y' THEN
1141: AHL_DEBUG_PUB.debug('Local OPID:'||l_workorder_operation_id);
1142: AHL_DEBUG_PUB.debug('OPID2 :'||p_x_req_material_tbl(i).workorder_operation_id);
1143: END IF;
1144: --Check for operation sequence
1145: -- dbms_output.put_line( 'before uinque check:'||p_x_req_material_tbl(i).inventory_item_id);

Line 1142: AHL_DEBUG_PUB.debug('OPID2 :'||p_x_req_material_tbl(i).workorder_operation_id);

1138: */
1139:
1140: IF G_DEBUG='Y' THEN
1141: AHL_DEBUG_PUB.debug('Local OPID:'||l_workorder_operation_id);
1142: AHL_DEBUG_PUB.debug('OPID2 :'||p_x_req_material_tbl(i).workorder_operation_id);
1143: END IF;
1144: --Check for operation sequence
1145: -- dbms_output.put_line( 'before uinque check:'||p_x_req_material_tbl(i).inventory_item_id);
1146: -- dbms_output.put_line( 'before unique check:'||p_x_req_material_tbl(i).organization_id);

Line 1218: -- AHL_DEBUG_PUB.debug('after interface flag yes or null call:'||p_x_req_material_tbl(1).workorder_id);

1214: --
1215: -- dbms_output.put_line( 'inside:'||p_interface_flag);
1216:
1217: -- IF G_DEBUG='Y' THEN
1218: -- AHL_DEBUG_PUB.debug('after interface flag yes or null call:'||p_x_req_material_tbl(1).workorder_id);
1219: -- END IF;
1220: --
1221: -- dbms_output.put_line( 'inside:'||p_interface_flag);
1222:

Line 1263: AHL_DEBUG_PUB.debug('Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);

1259: -- sracha: Fix for FP bug# 6802777.
1260: l_req_material_tbl(j).DEPARTMENT_ID := p_x_req_material_tbl(i).department_id;
1261: --
1262: IF G_DEBUG='Y' THEN
1263: AHL_DEBUG_PUB.debug('Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);
1264: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);
1265: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
1266: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
1267: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);

Line 1264: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);

1260: l_req_material_tbl(j).DEPARTMENT_ID := p_x_req_material_tbl(i).department_id;
1261: --
1262: IF G_DEBUG='Y' THEN
1263: AHL_DEBUG_PUB.debug('Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);
1264: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);
1265: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
1266: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
1267: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
1268: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);

Line 1265: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);

1261: --
1262: IF G_DEBUG='Y' THEN
1263: AHL_DEBUG_PUB.debug('Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);
1264: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);
1265: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
1266: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
1267: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
1268: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);
1269: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);

Line 1266: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);

1262: IF G_DEBUG='Y' THEN
1263: AHL_DEBUG_PUB.debug('Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);
1264: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);
1265: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
1266: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
1267: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
1268: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);
1269: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);
1270: AHL_DEBUG_PUB.debug('Before Eam job pvt.OperationSequence:'||l_req_material_tbl(j).OPERATION_SEQUENCE);

Line 1267: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);

1263: AHL_DEBUG_PUB.debug('Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);
1264: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);
1265: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
1266: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
1267: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
1268: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);
1269: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);
1270: AHL_DEBUG_PUB.debug('Before Eam job pvt.OperationSequence:'||l_req_material_tbl(j).OPERATION_SEQUENCE);
1271: END IF;

Line 1268: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);

1264: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);
1265: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
1266: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
1267: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
1268: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);
1269: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);
1270: AHL_DEBUG_PUB.debug('Before Eam job pvt.OperationSequence:'||l_req_material_tbl(j).OPERATION_SEQUENCE);
1271: END IF;
1272:

Line 1269: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);

1265: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
1266: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
1267: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
1268: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);
1269: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);
1270: AHL_DEBUG_PUB.debug('Before Eam job pvt.OperationSequence:'||l_req_material_tbl(j).OPERATION_SEQUENCE);
1271: END IF;
1272:
1273: -- dbms_output.put_line( 'Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);

Line 1270: AHL_DEBUG_PUB.debug('Before Eam job pvt.OperationSequence:'||l_req_material_tbl(j).OPERATION_SEQUENCE);

1266: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
1267: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
1268: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);
1269: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);
1270: AHL_DEBUG_PUB.debug('Before Eam job pvt.OperationSequence:'||l_req_material_tbl(j).OPERATION_SEQUENCE);
1271: END IF;
1272:
1273: -- dbms_output.put_line( 'Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);
1274: -- dbms_output.put_line( 'Before Eam job pvt.quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);

Line 1289: AHL_DEBUG_PUB.debug('before wip job call');

1285: --
1286: -- dbms_output.put_line( 'before wip jobs:');
1287:
1288: IF G_DEBUG='Y' THEN
1289: AHL_DEBUG_PUB.debug('before wip job call');
1290: END IF;
1291: -- Before Ahl Eam job Call
1292:
1293: AHL_EAM_JOB_PVT.process_material_req

Line 1310: AHL_DEBUG_PUB.debug('after wip job call:'||l_return_status);

1306:
1307: -- dbms_output.put_line( 'after wip jobs:'||l_return_status);
1308:
1309: IF G_DEBUG='Y' THEN
1310: AHL_DEBUG_PUB.debug('after wip job call:'||l_return_status);
1311: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_count);
1312: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_data);
1313: END IF;
1314: --

Line 1311: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_count);

1307: -- dbms_output.put_line( 'after wip jobs:'||l_return_status);
1308:
1309: IF G_DEBUG='Y' THEN
1310: AHL_DEBUG_PUB.debug('after wip job call:'||l_return_status);
1311: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_count);
1312: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_data);
1313: END IF;
1314: --
1315: l_msg_count := FND_MSG_PUB.count_msg;

Line 1312: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_data);

1308:
1309: IF G_DEBUG='Y' THEN
1310: AHL_DEBUG_PUB.debug('after wip job call:'||l_return_status);
1311: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_count);
1312: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_data);
1313: END IF;
1314: --
1315: l_msg_count := FND_MSG_PUB.count_msg;
1316: --

Line 1327: AHL_DEBUG_PUB.debug('Before insert status call');

1323:
1324: END IF;
1325: --
1326: IF G_DEBUG='Y' THEN
1327: AHL_DEBUG_PUB.debug('Before insert status call');
1328: END IF;
1329: -- dbms_output.put_line( 'after wip jobs:');
1330:
1331: --

Line 1447: AHL_DEBUG_PUB.debug('fetching dff_default_values');

1443: l_Req_Material_Tbl(i).last_updated_date := p_x_req_material_tbl(i).last_updated_date;
1444: END IF;
1445:
1446: IF G_DEBUG='Y' THEN
1447: AHL_DEBUG_PUB.debug('fetching dff_default_values');
1448: END IF;
1449:
1450: get_dff_default_values
1451: (

Line 1456: AHL_DEBUG_PUB.debug('dff_default_values have been fetched');

1452: p_req_material_rec => p_x_req_material_tbl(i),
1453: flex_fields_defaults => dff_default_values
1454: );
1455: IF G_DEBUG='Y' THEN
1456: AHL_DEBUG_PUB.debug('dff_default_values have been fetched');
1457: END IF;
1458: -- Attribte Category
1459: IF p_x_req_material_tbl(i).attribute_category = FND_API.G_MISS_CHAR
1460: THEN

Line 1609: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_x_req_material_tbl(i).rt_oper_material_id);

1605: INTO l_schedule_material_id FROM DUAL;
1606: --
1607: --
1608: IF G_DEBUG='Y' THEN
1609: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_x_req_material_tbl(i).rt_oper_material_id);
1610: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_interface_flag);
1611:
1612: END IF;
1613: --Check for materials added from route.Already in scheudle material entity

Line 1610: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_interface_flag);

1606: --
1607: --
1608: IF G_DEBUG='Y' THEN
1609: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_x_req_material_tbl(i).rt_oper_material_id);
1610: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_interface_flag);
1611:
1612: END IF;
1613: --Check for materials added from route.Already in scheudle material entity
1614: -- were schedule during LTP process

Line 1618: AHL_DEBUG_PUB.debug( 'FLAG=N RTID:'||p_x_req_material_tbl(i).rt_oper_material_id);

1614: -- were schedule during LTP process
1615: IF (p_interface_flag = 'N' or p_interface_flag = 'n') THEN
1616: --
1617: IF G_DEBUG='Y' THEN
1618: AHL_DEBUG_PUB.debug( 'FLAG=N RTID:'||p_x_req_material_tbl(i).rt_oper_material_id);
1619: AHL_DEBUG_PUB.debug( 'FLAG=N VTID:'||p_x_req_material_tbl(i).visit_task_id);
1620: AHL_DEBUG_PUB.debug( 'FLAG=N ITID:'||p_x_req_material_tbl(i).inventory_item_id);
1621: END IF;
1622: IF (p_x_req_material_tbl(i).rt_oper_material_id IS NOT NULL AND

Line 1619: AHL_DEBUG_PUB.debug( 'FLAG=N VTID:'||p_x_req_material_tbl(i).visit_task_id);

1615: IF (p_interface_flag = 'N' or p_interface_flag = 'n') THEN
1616: --
1617: IF G_DEBUG='Y' THEN
1618: AHL_DEBUG_PUB.debug( 'FLAG=N RTID:'||p_x_req_material_tbl(i).rt_oper_material_id);
1619: AHL_DEBUG_PUB.debug( 'FLAG=N VTID:'||p_x_req_material_tbl(i).visit_task_id);
1620: AHL_DEBUG_PUB.debug( 'FLAG=N ITID:'||p_x_req_material_tbl(i).inventory_item_id);
1621: END IF;
1622: IF (p_x_req_material_tbl(i).rt_oper_material_id IS NOT NULL AND
1623: p_x_req_material_tbl(i).rt_oper_material_id <> FND_API.G_MISS_NUM)

Line 1620: AHL_DEBUG_PUB.debug( 'FLAG=N ITID:'||p_x_req_material_tbl(i).inventory_item_id);

1616: --
1617: IF G_DEBUG='Y' THEN
1618: AHL_DEBUG_PUB.debug( 'FLAG=N RTID:'||p_x_req_material_tbl(i).rt_oper_material_id);
1619: AHL_DEBUG_PUB.debug( 'FLAG=N VTID:'||p_x_req_material_tbl(i).visit_task_id);
1620: AHL_DEBUG_PUB.debug( 'FLAG=N ITID:'||p_x_req_material_tbl(i).inventory_item_id);
1621: END IF;
1622: IF (p_x_req_material_tbl(i).rt_oper_material_id IS NOT NULL AND
1623: p_x_req_material_tbl(i).rt_oper_material_id <> FND_API.G_MISS_NUM)
1624: THEN

Line 1632: AHL_DEBUG_PUB.debug( 'Inside MATID:'||l_material_rec.scheduled_material_id);

1628: FETCH Get_rt_mat_cur INTO l_material_rec;
1629: CLOSE Get_rt_mat_cur;
1630: --
1631: IF G_DEBUG='Y' THEN
1632: AHL_DEBUG_PUB.debug( 'Inside MATID:'||l_material_rec.scheduled_material_id);
1633: AHL_DEBUG_PUB.debug( 'inside VTID:'||l_material_rec.visit_task_id);
1634: AHL_DEBUG_PUB.debug( 'inside ITID:'||l_material_rec.inventory_item_id);
1635: AHL_DEBUG_PUB.debug( 'inside DES:'||l_schedule_designator);
1636: END IF;

Line 1633: AHL_DEBUG_PUB.debug( 'inside VTID:'||l_material_rec.visit_task_id);

1629: CLOSE Get_rt_mat_cur;
1630: --
1631: IF G_DEBUG='Y' THEN
1632: AHL_DEBUG_PUB.debug( 'Inside MATID:'||l_material_rec.scheduled_material_id);
1633: AHL_DEBUG_PUB.debug( 'inside VTID:'||l_material_rec.visit_task_id);
1634: AHL_DEBUG_PUB.debug( 'inside ITID:'||l_material_rec.inventory_item_id);
1635: AHL_DEBUG_PUB.debug( 'inside DES:'||l_schedule_designator);
1636: END IF;
1637: --

Line 1634: AHL_DEBUG_PUB.debug( 'inside ITID:'||l_material_rec.inventory_item_id);

1630: --
1631: IF G_DEBUG='Y' THEN
1632: AHL_DEBUG_PUB.debug( 'Inside MATID:'||l_material_rec.scheduled_material_id);
1633: AHL_DEBUG_PUB.debug( 'inside VTID:'||l_material_rec.visit_task_id);
1634: AHL_DEBUG_PUB.debug( 'inside ITID:'||l_material_rec.inventory_item_id);
1635: AHL_DEBUG_PUB.debug( 'inside DES:'||l_schedule_designator);
1636: END IF;
1637: --
1638: IF ( l_material_rec.scheduled_material_id IS NOT NULL

Line 1635: AHL_DEBUG_PUB.debug( 'inside DES:'||l_schedule_designator);

1631: IF G_DEBUG='Y' THEN
1632: AHL_DEBUG_PUB.debug( 'Inside MATID:'||l_material_rec.scheduled_material_id);
1633: AHL_DEBUG_PUB.debug( 'inside VTID:'||l_material_rec.visit_task_id);
1634: AHL_DEBUG_PUB.debug( 'inside ITID:'||l_material_rec.inventory_item_id);
1635: AHL_DEBUG_PUB.debug( 'inside DES:'||l_schedule_designator);
1636: END IF;
1637: --
1638: IF ( l_material_rec.scheduled_material_id IS NOT NULL
1639: --Adithya added for FP Bug# 6366740

Line 1659: AHL_DEBUG_PUB.debug( 'p_x_req_material_tbl(i).mrp_net_flag:'||p_x_req_material_tbl(i).mrp_net_flag);

1655: --p_x_req_material_tbl(i).mrp_net_flag := 1;
1656: p_x_req_material_tbl(i).mrp_net_flag := 2;
1657:
1658: IF G_DEBUG='Y' THEN
1659: AHL_DEBUG_PUB.debug( 'p_x_req_material_tbl(i).mrp_net_flag:'||p_x_req_material_tbl(i).mrp_net_flag);
1660: END IF;
1661:
1662: ELSE
1663: IF G_DEBUG='Y' THEN

Line 1664: AHL_DEBUG_PUB.debug( 'else flag Mat id:'||l_schedule_material_id);

1660: END IF;
1661:
1662: ELSE
1663: IF G_DEBUG='Y' THEN
1664: AHL_DEBUG_PUB.debug( 'else flag Mat id:'||l_schedule_material_id);
1665: END IF;
1666: -- Create Record in schedule materials
1667: Insert_Row (
1668: X_SCHEDULED_MATERIAL_ID => l_schedule_material_id,

Line 1728: AHL_DEBUG_PUB.debug( 'schedule material id 5:'||l_schedule_material_id);

1724: END IF; --Get_rt_mat_cur
1725:
1726: -- Get Project and Task id
1727: IF G_DEBUG='Y' THEN
1728: AHL_DEBUG_PUB.debug( 'schedule material id 5:'||l_schedule_material_id);
1729: END IF;
1730: ELSE
1731: IF G_DEBUG='Y' THEN
1732: AHL_DEBUG_PUB.debug( 'schedule material id 6:'||l_schedule_material_id);

Line 1732: AHL_DEBUG_PUB.debug( 'schedule material id 6:'||l_schedule_material_id);

1728: AHL_DEBUG_PUB.debug( 'schedule material id 5:'||l_schedule_material_id);
1729: END IF;
1730: ELSE
1731: IF G_DEBUG='Y' THEN
1732: AHL_DEBUG_PUB.debug( 'schedule material id 6:'||l_schedule_material_id);
1733: END IF;
1734:
1735: -- Create Record in schedule materials
1736: Insert_Row (

Line 1797: AHL_DEBUG_PUB.debug( 'after rt oper material id:'||l_schedule_material_id);

1793:
1794: --
1795: END IF; -- --rt oper id not null
1796: IF G_DEBUG='Y' THEN
1797: AHL_DEBUG_PUB.debug( 'after rt oper material id:'||l_schedule_material_id);
1798: END IF;
1799: --
1800: END IF; -- --Interface flag
1801: --

Line 1803: AHL_DEBUG_PUB.debug( 'schedule material id:'||l_schedule_material_id);

1799: --
1800: END IF; -- --Interface flag
1801: --
1802: IF G_DEBUG='Y' THEN
1803: AHL_DEBUG_PUB.debug( 'schedule material id:'||l_schedule_material_id);
1804: END IF;
1805: --
1806: END IF; --Material id g_miss_num
1807: --

Line 1812: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);

1808: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id
1809: FROM DUAL;
1810: --
1811: IF G_DEBUG='Y' THEN
1812: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
1813: END IF;
1814: --Create Record in transactions table
1815: Log_Transaction_Record
1816: ( p_wo_operation_txn_id => l_wo_operation_txn_id,

Line 1835: AHL_DEBUG_PUB.debug( 'before calling MRP l_schedule_designator:'||l_schedule_designator);

1831:
1832: --Call MRP Process
1833: --
1834: IF G_DEBUG='Y' THEN
1835: AHL_DEBUG_PUB.debug( 'before calling MRP l_schedule_designator:'||l_schedule_designator);
1836: END IF;
1837: IF (p_interface_flag IS NULL OR p_interface_flag = 'Y') THEN
1838:
1839: -- Create Record in schedule materials

Line 1943: Ahl_Debug_Pub.debug( 'End of public api Create Material Reqst','+PPMRP+');

1939: COMMIT;
1940: END IF;
1941: -- Debug info
1942: IF G_DEBUG='Y' THEN
1943: Ahl_Debug_Pub.debug( 'End of public api Create Material Reqst','+PPMRP+');
1944: -- Check if API is called in debug mode. If yes, disable debug.
1945: Ahl_Debug_Pub.disable_debug;
1946: END IF;
1947:

Line 1945: Ahl_Debug_Pub.disable_debug;

1941: -- Debug info
1942: IF G_DEBUG='Y' THEN
1943: Ahl_Debug_Pub.debug( 'End of public api Create Material Reqst','+PPMRP+');
1944: -- Check if API is called in debug mode. If yes, disable debug.
1945: Ahl_Debug_Pub.disable_debug;
1946: END IF;
1947:
1948: EXCEPTION
1949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1956: AHL_DEBUG_PUB.log_app_messages (

1952: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1953: p_count => x_msg_count,
1954: p_data => x_msg_data);
1955: IF G_DEBUG='Y' THEN
1956: AHL_DEBUG_PUB.log_app_messages (
1957: x_msg_count, x_msg_data, 'ERROR' );
1958: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
1959: -- Check if API is called in debug mode. If yes, disable debug.
1960: AHL_DEBUG_PUB.disable_debug;

Line 1958: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');

1954: p_data => x_msg_data);
1955: IF G_DEBUG='Y' THEN
1956: AHL_DEBUG_PUB.log_app_messages (
1957: x_msg_count, x_msg_data, 'ERROR' );
1958: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
1959: -- Check if API is called in debug mode. If yes, disable debug.
1960: AHL_DEBUG_PUB.disable_debug;
1961: END IF;
1962:

Line 1960: AHL_DEBUG_PUB.disable_debug;

1956: AHL_DEBUG_PUB.log_app_messages (
1957: x_msg_count, x_msg_data, 'ERROR' );
1958: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
1959: -- Check if API is called in debug mode. If yes, disable debug.
1960: AHL_DEBUG_PUB.disable_debug;
1961: END IF;
1962:
1963: WHEN FND_API.G_EXC_ERROR THEN
1964: ROLLBACK TO create_material_reqst;

Line 1971: AHL_DEBUG_PUB.log_app_messages (

1967: p_count => x_msg_count,
1968: p_data => X_msg_data);
1969: IF G_DEBUG='Y' THEN
1970: -- Debug info.
1971: AHL_DEBUG_PUB.log_app_messages (
1972: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1973: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
1974: -- Check if API is called in debug mode. If yes, disable debug.
1975: AHL_DEBUG_PUB.disable_debug;

Line 1973: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');

1969: IF G_DEBUG='Y' THEN
1970: -- Debug info.
1971: AHL_DEBUG_PUB.log_app_messages (
1972: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1973: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
1974: -- Check if API is called in debug mode. If yes, disable debug.
1975: AHL_DEBUG_PUB.disable_debug;
1976: END IF;
1977: WHEN OTHERS THEN

Line 1975: AHL_DEBUG_PUB.disable_debug;

1971: AHL_DEBUG_PUB.log_app_messages (
1972: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1973: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
1974: -- Check if API is called in debug mode. If yes, disable debug.
1975: AHL_DEBUG_PUB.disable_debug;
1976: END IF;
1977: WHEN OTHERS THEN
1978: ROLLBACK TO create_material_reqst;
1979: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1991: AHL_DEBUG_PUB.log_app_messages (

1987: p_count => x_msg_count,
1988: p_data => X_msg_data);
1989: IF G_DEBUG='Y' THEN
1990: -- Debug info.
1991: AHL_DEBUG_PUB.log_app_messages (
1992: x_msg_count, x_msg_data, 'SQL ERROR' );
1993: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
1994: -- Check if API is called in debug mode. If yes, disable debug.
1995: AHL_DEBUG_PUB.disable_debug;

Line 1993: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');

1989: IF G_DEBUG='Y' THEN
1990: -- Debug info.
1991: AHL_DEBUG_PUB.log_app_messages (
1992: x_msg_count, x_msg_data, 'SQL ERROR' );
1993: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
1994: -- Check if API is called in debug mode. If yes, disable debug.
1995: AHL_DEBUG_PUB.disable_debug;
1996: END IF;
1997: END Create_Material_Reqst;

Line 1995: AHL_DEBUG_PUB.disable_debug;

1991: AHL_DEBUG_PUB.log_app_messages (
1992: x_msg_count, x_msg_data, 'SQL ERROR' );
1993: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
1994: -- Check if API is called in debug mode. If yes, disable debug.
1995: AHL_DEBUG_PUB.disable_debug;
1996: END IF;
1997: END Create_Material_Reqst;
1998: --
1999: -- Start of Comments --

Line 2174: AHL_DEBUG_PUB.enable_debug;

2170: -- Standard Start of API savepoint
2171: SAVEPOINT update_material_reqst;
2172: -- Check if API is called in debug mode. If yes, enable debug.
2173: IF G_DEBUG='Y' THEN
2174: AHL_DEBUG_PUB.enable_debug;
2175: -- Debug info.
2176: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. update material reqst','+PPMRP+');
2177: END IF;
2178: -- Standard call to check for call compatibility.

Line 2176: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. update material reqst','+PPMRP+');

2172: -- Check if API is called in debug mode. If yes, enable debug.
2173: IF G_DEBUG='Y' THEN
2174: AHL_DEBUG_PUB.enable_debug;
2175: -- Debug info.
2176: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. update material reqst','+PPMRP+');
2177: END IF;
2178: -- Standard call to check for call compatibility.
2179: IF FND_API.to_boolean(p_init_msg_list)
2180: THEN

Line 2205: AHL_DEBUG_PUB.debug( 'WOID :'||p_x_req_material_tbl(i).workorder_id);

2201: p_x_req_material_tbl(i).job_number <> FND_API.G_MISS_CHAR ) )
2202: THEN
2203: --
2204: IF G_DEBUG='Y' THEN
2205: AHL_DEBUG_PUB.debug( 'WOID :'||p_x_req_material_tbl(i).workorder_id);
2206: END IF;
2207: --
2208: Get_workorder_id
2209: (p_workorder_id => p_x_req_material_tbl(i).workorder_id,

Line 2249: AHL_DEBUG_PUB.debug( 'WOID 2:'||p_x_req_material_tbl(i).workorder_id);

2245: -- ACL Changes
2246:
2247: --
2248: IF G_DEBUG='Y' THEN
2249: AHL_DEBUG_PUB.debug( 'WOID 2:'||p_x_req_material_tbl(i).workorder_id);
2250: END IF;
2251: END IF; --Module type
2252:
2253: --Get Requirement operation details

Line 2269: AHL_DEBUG_PUB.debug( 'INVID :'||p_x_req_material_tbl(i).inventory_item_id);

2265: p_x_req_material_tbl(i).visit_id := l_req_material_rec.visit_id;
2266: p_x_req_material_tbl(i).visit_task_id := l_req_material_rec.visit_task_id;
2267: --
2268: IF G_DEBUG='Y' THEN
2269: AHL_DEBUG_PUB.debug( 'INVID :'||p_x_req_material_tbl(i).inventory_item_id);
2270: END IF;
2271:
2272: -- Validate for Requested Quantity
2273: IF (p_x_req_material_tbl(i).requested_quantity IS NULL OR

Line 2306: AHL_DEBUG_PUB.debug( 'QTY :'||p_x_req_material_tbl(i).requested_quantity);

2302: END IF;-- p_x_req_material_tbl(i).requested_quantity <
2303: END IF; --p_x_req_material_tbl(i).requested_quantity <>
2304: END IF;
2305: IF G_DEBUG='Y' THEN
2306: AHL_DEBUG_PUB.debug( 'QTY :'||p_x_req_material_tbl(i).requested_quantity);
2307: END IF;
2308: IF p_module_type <> 'API' THEN
2309: -- Validate for Requested Date
2310: IF (p_x_req_material_tbl(i).requested_date IS NULL OR

Line 2322: AHL_DEBUG_PUB.debug( 'DATE :'||p_x_req_material_tbl(i).requested_date);

2318: Fnd_Msg_Pub.ADD;
2319: END IF;
2320: END IF;
2321: IF G_DEBUG='Y' THEN
2322: AHL_DEBUG_PUB.debug( 'DATE :'||p_x_req_material_tbl(i).requested_date);
2323: END IF;
2324:
2325: -- Validate for Schedule Material ID
2326: IF (p_x_req_material_tbl(i).schedule_material_id IS NULL AND

Line 2332: AHL_DEBUG_PUB.debug( 'SCHID :'||p_x_req_material_tbl(i).schedule_material_id);

2328: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');
2329: Fnd_Msg_Pub.ADD;
2330: END IF;
2331: IF G_DEBUG='Y' THEN
2332: AHL_DEBUG_PUB.debug( 'SCHID :'||p_x_req_material_tbl(i).schedule_material_id);
2333: AHL_DEBUG_PUB.debug( 'OSID'||p_x_req_material_tbl(i).operation_sequence);
2334: END IF;
2335: --Check for workorder status
2336: OPEN Check_wo_status_cur(p_x_req_material_tbl(i).workorder_id);

Line 2333: AHL_DEBUG_PUB.debug( 'OSID'||p_x_req_material_tbl(i).operation_sequence);

2329: Fnd_Msg_Pub.ADD;
2330: END IF;
2331: IF G_DEBUG='Y' THEN
2332: AHL_DEBUG_PUB.debug( 'SCHID :'||p_x_req_material_tbl(i).schedule_material_id);
2333: AHL_DEBUG_PUB.debug( 'OSID'||p_x_req_material_tbl(i).operation_sequence);
2334: END IF;
2335: --Check for workorder status
2336: OPEN Check_wo_status_cur(p_x_req_material_tbl(i).workorder_id);
2337: FETCH Check_wo_status_cur INTO l_dummy;

Line 2366: AHL_DEBUG_PUB.debug( 'End of validations');

2362:
2363: -- Calling Wip job api
2364: --
2365: IF G_DEBUG='Y' THEN
2366: AHL_DEBUG_PUB.debug( 'End of validations');
2367: AHL_DEBUG_PUB.debug('Before processing updates');
2368: END IF;
2369: --
2370:

Line 2367: AHL_DEBUG_PUB.debug('Before processing updates');

2363: -- Calling Wip job api
2364: --
2365: IF G_DEBUG='Y' THEN
2366: AHL_DEBUG_PUB.debug( 'End of validations');
2367: AHL_DEBUG_PUB.debug('Before processing updates');
2368: END IF;
2369: --
2370:
2371: --IF p_module_type <> 'API' THEN

Line 2405: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);

2401: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id
2402: FROM DUAL;
2403: --
2404: IF G_DEBUG='Y' THEN
2405: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
2406: END IF;
2407: Log_Transaction_Record
2408: ( p_wo_operation_txn_id => l_wo_operation_txn_id,
2409: p_object_version_number => 1,

Line 2445: AHL_DEBUG_PUB.debug('Request Date from DB for sch. Mat ID:1:' || l_req_material_rec.old_requested_date || ':' || p_x_req_material_tbl(i).schedule_material_id);

2441: l_req_material_tbl(j).OPERATION_FLAG := 'U';
2442:
2443: j := j + 1;
2444: IF G_DEBUG='Y' THEN
2445: AHL_DEBUG_PUB.debug('Request Date from DB for sch. Mat ID:1:' || l_req_material_rec.old_requested_date || ':' || p_x_req_material_tbl(i).schedule_material_id);
2446: AHL_DEBUG_PUB.debug('Changed Request Date :' || p_x_req_material_tbl(i).requested_date );
2447: END IF;
2448: --
2449: END LOOP;

Line 2446: AHL_DEBUG_PUB.debug('Changed Request Date :' || p_x_req_material_tbl(i).requested_date );

2442:
2443: j := j + 1;
2444: IF G_DEBUG='Y' THEN
2445: AHL_DEBUG_PUB.debug('Request Date from DB for sch. Mat ID:1:' || l_req_material_rec.old_requested_date || ':' || p_x_req_material_tbl(i).schedule_material_id);
2446: AHL_DEBUG_PUB.debug('Changed Request Date :' || p_x_req_material_tbl(i).requested_date );
2447: END IF;
2448: --
2449: END LOOP;
2450: END IF; --Material tbl

Line 2453: AHL_DEBUG_PUB.debug('beforer wip job record assign');

2449: END LOOP;
2450: END IF; --Material tbl
2451:
2452: IF G_DEBUG='Y' THEN
2453: AHL_DEBUG_PUB.debug('beforer wip job record assign');
2454: END IF;
2455:
2456: IF l_req_material_tbl.COUNT > 0 THEN
2457: --

Line 2459: AHL_DEBUG_PUB.debug('before Eam Workorder job call');

2455:
2456: IF l_req_material_tbl.COUNT > 0 THEN
2457: --
2458: IF G_DEBUG='Y' THEN
2459: AHL_DEBUG_PUB.debug('before Eam Workorder job call');
2460: AHL_DEBUG_PUB.debug('before Eam Api jobs call''count :'||l_req_material_tbl.count);
2461:
2462: END IF;
2463: -- Call wip job api

Line 2460: AHL_DEBUG_PUB.debug('before Eam Api jobs call''count :'||l_req_material_tbl.count);

2456: IF l_req_material_tbl.COUNT > 0 THEN
2457: --
2458: IF G_DEBUG='Y' THEN
2459: AHL_DEBUG_PUB.debug('before Eam Workorder job call');
2460: AHL_DEBUG_PUB.debug('before Eam Api jobs call''count :'||l_req_material_tbl.count);
2461:
2462: END IF;
2463: -- Call wip job api
2464: --

Line 2482: AHL_DEBUG_PUB.debug('AHLVPPMB: after wip job call'||l_return_status);

2478: );
2479: --
2480: END IF; --Eam table count > 0
2481: IF G_DEBUG='Y' THEN
2482: AHL_DEBUG_PUB.debug('AHLVPPMB: after wip job call'||l_return_status);
2483: END IF;
2484: --END IF; --Module type null
2485:
2486: IF l_return_status ='S' THEN

Line 2503: AHL_DEBUG_PUB.debug('Request Date from DB for sch. Mat ID:2:' || l_req_material_rec.old_requested_date

2499: -- Added for R12 serial reservations enhancements - ER# 4295982.
2500: -- If requested date is changed, then call reservations api to change the
2501: -- requested date in WMS.
2502: IF G_DEBUG='Y' THEN
2503: AHL_DEBUG_PUB.debug('Request Date from DB for sch. Mat ID:2:' || l_req_material_rec.old_requested_date
2504: || ':' || p_x_req_material_tbl(i).schedule_material_id);
2505: AHL_DEBUG_PUB.debug('Changed Request Date :' || p_x_req_material_tbl(i).requested_date );
2506: END IF;
2507:

Line 2505: AHL_DEBUG_PUB.debug('Changed Request Date :' || p_x_req_material_tbl(i).requested_date );

2501: -- requested date in WMS.
2502: IF G_DEBUG='Y' THEN
2503: AHL_DEBUG_PUB.debug('Request Date from DB for sch. Mat ID:2:' || l_req_material_rec.old_requested_date
2504: || ':' || p_x_req_material_tbl(i).schedule_material_id);
2505: AHL_DEBUG_PUB.debug('Changed Request Date :' || p_x_req_material_tbl(i).requested_date );
2506: END IF;
2507:
2508: IF (trunc(p_x_req_material_tbl(i).requested_date) <> trunc(l_req_material_rec.old_requested_date))
2509: THEN

Line 2511: AHL_DEBUG_PUB.debug('Before Call to Upd RSV ') ;

2507:
2508: IF (trunc(p_x_req_material_tbl(i).requested_date) <> trunc(l_req_material_rec.old_requested_date))
2509: THEN
2510: IF G_DEBUG='Y' THEN
2511: AHL_DEBUG_PUB.debug('Before Call to Upd RSV ') ;
2512: END IF;
2513:
2514: -- call update reservations api.
2515: AHL_RSV_RESERVATIONS_PVT.Update_Reservation(

Line 2527: AHL_DEBUG_PUB.debug('After Call to Upd RSV- Return Status:' || x_return_status);

2523: p_scheduled_material_id => p_x_req_material_tbl(i).schedule_material_id,
2524: p_requested_date => p_x_req_material_tbl(i).requested_date);
2525:
2526: IF G_DEBUG='Y' THEN
2527: AHL_DEBUG_PUB.debug('After Call to Upd RSV- Return Status:' || x_return_status);
2528: END IF;
2529:
2530: -- Raise error if exceptions occur
2531: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2787: AHL_DEBUG_PUB.debug( 'END OF UPDATE PROCESS');

2783: END IF;
2784: END IF;
2785:
2786: IF G_DEBUG='Y' THEN
2787: AHL_DEBUG_PUB.debug( 'END OF UPDATE PROCESS');
2788: END IF;
2789: --
2790: ------------------------End of Body---------------------------------------
2791: --Standard check to count messages

Line 2810: Ahl_Debug_Pub.debug( 'End of public api Update Material Reqst','+PPMRP+');

2806: COMMIT;
2807: END IF;
2808: -- Debug info
2809: IF G_DEBUG='Y' THEN
2810: Ahl_Debug_Pub.debug( 'End of public api Update Material Reqst','+PPMRP+');
2811: -- Check if API is called in debug mode. If yes, disable debug.
2812: Ahl_Debug_Pub.disable_debug;
2813: END IF;
2814:

Line 2812: Ahl_Debug_Pub.disable_debug;

2808: -- Debug info
2809: IF G_DEBUG='Y' THEN
2810: Ahl_Debug_Pub.debug( 'End of public api Update Material Reqst','+PPMRP+');
2811: -- Check if API is called in debug mode. If yes, disable debug.
2812: Ahl_Debug_Pub.disable_debug;
2813: END IF;
2814:
2815: EXCEPTION
2816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2823: AHL_DEBUG_PUB.log_app_messages (

2819: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2820: p_count => x_msg_count,
2821: p_data => x_msg_data);
2822: IF G_DEBUG='Y' THEN
2823: AHL_DEBUG_PUB.log_app_messages (
2824: x_msg_count, x_msg_data, 'ERROR' );
2825: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
2826: -- Check if API is called in debug mode. If yes, disable debug.
2827: AHL_DEBUG_PUB.disable_debug;

Line 2825: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');

2821: p_data => x_msg_data);
2822: IF G_DEBUG='Y' THEN
2823: AHL_DEBUG_PUB.log_app_messages (
2824: x_msg_count, x_msg_data, 'ERROR' );
2825: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
2826: -- Check if API is called in debug mode. If yes, disable debug.
2827: AHL_DEBUG_PUB.disable_debug;
2828: END IF;
2829: WHEN FND_API.G_EXC_ERROR THEN

Line 2827: AHL_DEBUG_PUB.disable_debug;

2823: AHL_DEBUG_PUB.log_app_messages (
2824: x_msg_count, x_msg_data, 'ERROR' );
2825: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
2826: -- Check if API is called in debug mode. If yes, disable debug.
2827: AHL_DEBUG_PUB.disable_debug;
2828: END IF;
2829: WHEN FND_API.G_EXC_ERROR THEN
2830: ROLLBACK TO update_material_reqst;
2831: X_return_status := FND_API.G_RET_STS_ERROR;

Line 2837: AHL_DEBUG_PUB.log_app_messages (

2833: p_count => x_msg_count,
2834: p_data => X_msg_data);
2835: IF G_DEBUG='Y' THEN
2836: -- Debug info.
2837: AHL_DEBUG_PUB.log_app_messages (
2838: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2839: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
2840: -- Check if API is called in debug mode. If yes, disable debug.
2841: AHL_DEBUG_PUB.disable_debug;

Line 2839: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');

2835: IF G_DEBUG='Y' THEN
2836: -- Debug info.
2837: AHL_DEBUG_PUB.log_app_messages (
2838: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2839: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
2840: -- Check if API is called in debug mode. If yes, disable debug.
2841: AHL_DEBUG_PUB.disable_debug;
2842: END IF;
2843: WHEN OTHERS THEN

Line 2841: AHL_DEBUG_PUB.disable_debug;

2837: AHL_DEBUG_PUB.log_app_messages (
2838: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2839: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
2840: -- Check if API is called in debug mode. If yes, disable debug.
2841: AHL_DEBUG_PUB.disable_debug;
2842: END IF;
2843: WHEN OTHERS THEN
2844: ROLLBACK TO update_material_reqst;
2845: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2857: AHL_DEBUG_PUB.log_app_messages (

2853: p_count => x_msg_count,
2854: p_data => X_msg_data);
2855: IF G_DEBUG='Y' THEN
2856: -- Debug info.
2857: AHL_DEBUG_PUB.log_app_messages (
2858: x_msg_count, x_msg_data, 'SQL ERROR' );
2859: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
2860: -- Check if API is called in debug mode. If yes, disable debug.
2861: AHL_DEBUG_PUB.disable_debug;

Line 2859: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');

2855: IF G_DEBUG='Y' THEN
2856: -- Debug info.
2857: AHL_DEBUG_PUB.log_app_messages (
2858: x_msg_count, x_msg_data, 'SQL ERROR' );
2859: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
2860: -- Check if API is called in debug mode. If yes, disable debug.
2861: AHL_DEBUG_PUB.disable_debug;
2862: END IF;
2863: END Update_Material_Reqst;

Line 2861: AHL_DEBUG_PUB.disable_debug;

2857: AHL_DEBUG_PUB.log_app_messages (
2858: x_msg_count, x_msg_data, 'SQL ERROR' );
2859: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
2860: -- Check if API is called in debug mode. If yes, disable debug.
2861: AHL_DEBUG_PUB.disable_debug;
2862: END IF;
2863: END Update_Material_Reqst;
2864: -- Start of Comments --
2865: -- Procedure name : Remove_Material_Reqst

Line 3037: Ahl_Debug_Pub.enable_debug;

3033: -- Standard Start of API savepoint
3034: SAVEPOINT remove_material_request;
3035: -- Check if API is called in debug mode. If yes, enable debug.
3036: IF G_DEBUG='Y' THEN
3037: Ahl_Debug_Pub.enable_debug;
3038: -- Debug info.
3039: Ahl_Debug_Pub.debug( 'enter ahl_pp_materials_pvt Remove Material Request ','+MAATP+');
3040: --
3041: END IF;

Line 3039: Ahl_Debug_Pub.debug( 'enter ahl_pp_materials_pvt Remove Material Request ','+MAATP+');

3035: -- Check if API is called in debug mode. If yes, enable debug.
3036: IF G_DEBUG='Y' THEN
3037: Ahl_Debug_Pub.enable_debug;
3038: -- Debug info.
3039: Ahl_Debug_Pub.debug( 'enter ahl_pp_materials_pvt Remove Material Request ','+MAATP+');
3040: --
3041: END IF;
3042: -- Standard call to check for call compatibility.
3043: IF Fnd_Api.to_boolean(p_init_msg_list)

Line 3119: Ahl_Debug_Pub.debug( 'Obj Number:'||p_x_req_material_tbl(i).object_version_number);

3115: Fnd_Msg_Pub.ADD;
3116: END IF;
3117: --
3118: IF G_DEBUG='Y' THEN
3119: Ahl_Debug_Pub.debug( 'Obj Number:'||p_x_req_material_tbl(i).object_version_number);
3120: Ahl_Debug_Pub.debug( 'Sch mat Id:'||p_x_req_material_tbl(i).schedule_material_id);
3121: END IF;
3122: -- Check for object version number
3123: IF (p_x_req_material_tbl(i).object_version_number IS NOT NULL AND

Line 3120: Ahl_Debug_Pub.debug( 'Sch mat Id:'||p_x_req_material_tbl(i).schedule_material_id);

3116: END IF;
3117: --
3118: IF G_DEBUG='Y' THEN
3119: Ahl_Debug_Pub.debug( 'Obj Number:'||p_x_req_material_tbl(i).object_version_number);
3120: Ahl_Debug_Pub.debug( 'Sch mat Id:'||p_x_req_material_tbl(i).schedule_material_id);
3121: END IF;
3122: -- Check for object version number
3123: IF (p_x_req_material_tbl(i).object_version_number IS NOT NULL AND
3124: p_x_req_material_tbl(i).object_version_number <> FND_API.G_MISS_NUM) THEN

Line 3153: Ahl_Debug_Pub.debug( 'before wip jobs call:');

3149: END LOOP;
3150: END IF;
3151: --
3152: IF G_DEBUG='Y' THEN
3153: Ahl_Debug_Pub.debug( 'before wip jobs call:');
3154: END IF;
3155: --
3156: IF p_x_req_material_tbl.COUNT >0 THEN
3157: j := 1;

Line 3197: AHL_DEBUG_PUB.debug('Reserved quantity for sch. material ID:' || p_x_req_material_tbl(i).schedule_material_id || ' is: ' || l_reserved_quantity || 'for INV ID: ' || l_material_rec.inventory_item_id);

3193: CLOSE get_count_resrv_cur;
3194:
3195: IF (l_reserved_quantity > 0) THEN
3196: IF G_DEBUG='Y' THEN
3197: AHL_DEBUG_PUB.debug('Reserved quantity for sch. material ID:' || p_x_req_material_tbl(i).schedule_material_id || ' is: ' || l_reserved_quantity || 'for INV ID: ' || l_material_rec.inventory_item_id);
3198:
3199: AHL_DEBUG_PUB.debug('Before calling delete reservation api');
3200: END IF;
3201:

Line 3199: AHL_DEBUG_PUB.debug('Before calling delete reservation api');

3195: IF (l_reserved_quantity > 0) THEN
3196: IF G_DEBUG='Y' THEN
3197: AHL_DEBUG_PUB.debug('Reserved quantity for sch. material ID:' || p_x_req_material_tbl(i).schedule_material_id || ' is: ' || l_reserved_quantity || 'for INV ID: ' || l_material_rec.inventory_item_id);
3198:
3199: AHL_DEBUG_PUB.debug('Before calling delete reservation api');
3200: END IF;
3201:
3202: -- delete reservations.
3203: AHL_RSV_RESERVATIONS_PVT.DELETE_RESERVATION(

Line 3214: AHL_DEBUG_PUB.debug('After calling delete reservation api. Return status:' || x_return_status);

3210: x_msg_data => x_msg_data,
3211: p_scheduled_material_id => p_x_req_material_tbl(i).schedule_material_id);
3212:
3213: IF G_DEBUG='Y' THEN
3214: AHL_DEBUG_PUB.debug('After calling delete reservation api. Return status:' || x_return_status);
3215: END IF;
3216:
3217: -- check return status.
3218: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3230: AHL_DEBUG_PUB.debug('beforer Eam wip job call');

3226: END LOOP;
3227:
3228: END IF; --Material tbl
3229: IF G_DEBUG='Y' THEN
3230: AHL_DEBUG_PUB.debug('beforer Eam wip job call');
3231: END IF;
3232: -- Call wip job api
3233: AHL_EAM_JOB_PVT.process_material_req
3234: (

Line 3248: AHL_DEBUG_PUB.debug('after wip job call');

3244: p_material_req_tbl => l_req_material_tbl
3245: );
3246: --
3247: IF G_DEBUG='Y' THEN
3248: AHL_DEBUG_PUB.debug('after wip job call');
3249: END IF;
3250: IF l_return_Status = 'S' THEN
3251:
3252: --Remove the records

Line 3267: AHL_DEBUG_PUB.debug('after set request quantity to zero');

3263: WHERE SCHEDULED_MATERIAL_ID = p_x_req_material_tbl(i).schedule_material_id;
3264: END IF;
3265: --
3266: IF G_DEBUG='Y' THEN
3267: AHL_DEBUG_PUB.debug('after set request quantity to zero');
3268: END IF;
3269: --
3270: END LOOP;
3271: END IF;

Line 3297: Ahl_Debug_Pub.debug( 'End of private api Remove Material Request ','+MAMRP+');

3293: COMMIT;
3294: END IF;
3295: -- Debug info
3296: IF G_DEBUG='Y' THEN
3297: Ahl_Debug_Pub.debug( 'End of private api Remove Material Request ','+MAMRP+');
3298: -- Check if API is called in debug mode. If yes, disable debug.
3299: Ahl_Debug_Pub.disable_debug;
3300: END IF;
3301:

Line 3299: Ahl_Debug_Pub.disable_debug;

3295: -- Debug info
3296: IF G_DEBUG='Y' THEN
3297: Ahl_Debug_Pub.debug( 'End of private api Remove Material Request ','+MAMRP+');
3298: -- Check if API is called in debug mode. If yes, disable debug.
3299: Ahl_Debug_Pub.disable_debug;
3300: END IF;
3301:
3302: EXCEPTION
3303: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 3311: Ahl_Debug_Pub.log_app_messages (

3307: p_count => x_msg_count,
3308: p_data => x_msg_data);
3309:
3310: IF G_DEBUG='Y' THEN
3311: Ahl_Debug_Pub.log_app_messages (
3312: x_msg_count, x_msg_data, 'ERROR' );
3313: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
3314: -- Check if API is called in debug mode. If yes, disable debug.
3315: Ahl_Debug_Pub.disable_debug;

Line 3313: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');

3309:
3310: IF G_DEBUG='Y' THEN
3311: Ahl_Debug_Pub.log_app_messages (
3312: x_msg_count, x_msg_data, 'ERROR' );
3313: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
3314: -- Check if API is called in debug mode. If yes, disable debug.
3315: Ahl_Debug_Pub.disable_debug;
3316: END IF;
3317: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 3315: Ahl_Debug_Pub.disable_debug;

3311: Ahl_Debug_Pub.log_app_messages (
3312: x_msg_count, x_msg_data, 'ERROR' );
3313: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
3314: -- Check if API is called in debug mode. If yes, disable debug.
3315: Ahl_Debug_Pub.disable_debug;
3316: END IF;
3317: WHEN Fnd_Api.G_EXC_ERROR THEN
3318: ROLLBACK TO remove_material_request;
3319: X_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 3325: Ahl_Debug_Pub.log_app_messages (

3321: p_count => x_msg_count,
3322: p_data => X_msg_data);
3323: IF G_DEBUG='Y' THEN
3324: -- Debug info.
3325: Ahl_Debug_Pub.log_app_messages (
3326: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3327: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
3328: -- Check if API is called in debug mode. If yes, disable debug.
3329: Ahl_Debug_Pub.disable_debug;

Line 3327: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');

3323: IF G_DEBUG='Y' THEN
3324: -- Debug info.
3325: Ahl_Debug_Pub.log_app_messages (
3326: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3327: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
3328: -- Check if API is called in debug mode. If yes, disable debug.
3329: Ahl_Debug_Pub.disable_debug;
3330: END IF;
3331: WHEN OTHERS THEN

Line 3329: Ahl_Debug_Pub.disable_debug;

3325: Ahl_Debug_Pub.log_app_messages (
3326: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3327: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
3328: -- Check if API is called in debug mode. If yes, disable debug.
3329: Ahl_Debug_Pub.disable_debug;
3330: END IF;
3331: WHEN OTHERS THEN
3332: ROLLBACK TO remove_material_request;
3333: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 3346: Ahl_Debug_Pub.log_app_messages (

3342: p_data => X_msg_data);
3343:
3344: IF G_DEBUG='Y' THEN
3345: -- Debug info.
3346: Ahl_Debug_Pub.log_app_messages (
3347: x_msg_count, x_msg_data, 'SQL ERROR' );
3348: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MTMRP+');
3349: -- Check if API is called in debug mode. If yes, disable debug.
3350: Ahl_Debug_Pub.disable_debug;

Line 3348: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MTMRP+');

3344: IF G_DEBUG='Y' THEN
3345: -- Debug info.
3346: Ahl_Debug_Pub.log_app_messages (
3347: x_msg_count, x_msg_data, 'SQL ERROR' );
3348: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MTMRP+');
3349: -- Check if API is called in debug mode. If yes, disable debug.
3350: Ahl_Debug_Pub.disable_debug;
3351: END IF;
3352: END Remove_Material_Request;

Line 3350: Ahl_Debug_Pub.disable_debug;

3346: Ahl_Debug_Pub.log_app_messages (
3347: x_msg_count, x_msg_data, 'SQL ERROR' );
3348: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MTMRP+');
3349: -- Check if API is called in debug mode. If yes, disable debug.
3350: Ahl_Debug_Pub.disable_debug;
3351: END IF;
3352: END Remove_Material_Request;
3353:
3354:

Line 3420: AHL_DEBUG_PUB.enable_debug;

3416: -- Standard Start of API savepoint
3417: SAVEPOINT process_material_request;
3418: -- Check if API is called in debug mode. If yes, enable debug.
3419: IF G_DEBUG='Y' THEN
3420: AHL_DEBUG_PUB.enable_debug;
3421: -- Debug info.
3422: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. process material request','+PPMRP+');
3423: --
3424: END IF;

Line 3422: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. process material request','+PPMRP+');

3418: -- Check if API is called in debug mode. If yes, enable debug.
3419: IF G_DEBUG='Y' THEN
3420: AHL_DEBUG_PUB.enable_debug;
3421: -- Debug info.
3422: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. process material request','+PPMRP+');
3423: --
3424: END IF;
3425: -- Standard call to check for call compatibility.
3426: IF FND_API.to_boolean(p_init_msg_list)

Line 3547: Ahl_Debug_Pub.debug( 'End of public api Process Material Request','+PPMRP+');

3543: COMMIT;
3544: END IF;
3545: -- Debug info
3546: IF G_DEBUG='Y' THEN
3547: Ahl_Debug_Pub.debug( 'End of public api Process Material Request','+PPMRP+');
3548: -- Check if API is called in debug mode. If yes, disable debug.
3549: Ahl_Debug_Pub.disable_debug;
3550: --
3551: END IF;

Line 3549: Ahl_Debug_Pub.disable_debug;

3545: -- Debug info
3546: IF G_DEBUG='Y' THEN
3547: Ahl_Debug_Pub.debug( 'End of public api Process Material Request','+PPMRP+');
3548: -- Check if API is called in debug mode. If yes, disable debug.
3549: Ahl_Debug_Pub.disable_debug;
3550: --
3551: END IF;
3552: EXCEPTION
3553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3560: AHL_DEBUG_PUB.log_app_messages (

3556: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3557: p_count => x_msg_count,
3558: p_data => x_msg_data);
3559: IF G_DEBUG='Y' THEN
3560: AHL_DEBUG_PUB.log_app_messages (
3561: x_msg_count, x_msg_data, 'ERROR' );
3562: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
3563: -- Check if API is called in debug mode. If yes, disable debug.
3564: AHL_DEBUG_PUB.disable_debug;

Line 3562: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');

3558: p_data => x_msg_data);
3559: IF G_DEBUG='Y' THEN
3560: AHL_DEBUG_PUB.log_app_messages (
3561: x_msg_count, x_msg_data, 'ERROR' );
3562: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
3563: -- Check if API is called in debug mode. If yes, disable debug.
3564: AHL_DEBUG_PUB.disable_debug;
3565: END IF;
3566: WHEN FND_API.G_EXC_ERROR THEN

Line 3564: AHL_DEBUG_PUB.disable_debug;

3560: AHL_DEBUG_PUB.log_app_messages (
3561: x_msg_count, x_msg_data, 'ERROR' );
3562: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
3563: -- Check if API is called in debug mode. If yes, disable debug.
3564: AHL_DEBUG_PUB.disable_debug;
3565: END IF;
3566: WHEN FND_API.G_EXC_ERROR THEN
3567: ROLLBACK TO process_material_request;
3568: X_return_status := FND_API.G_RET_STS_ERROR;

Line 3574: AHL_DEBUG_PUB.log_app_messages (

3570: p_count => x_msg_count,
3571: p_data => X_msg_data);
3572: IF G_DEBUG='Y' THEN
3573: -- Debug info.
3574: AHL_DEBUG_PUB.log_app_messages (
3575: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3576: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
3577: -- Check if API is called in debug mode. If yes, disable debug.
3578: AHL_DEBUG_PUB.disable_debug;

Line 3576: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');

3572: IF G_DEBUG='Y' THEN
3573: -- Debug info.
3574: AHL_DEBUG_PUB.log_app_messages (
3575: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3576: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
3577: -- Check if API is called in debug mode. If yes, disable debug.
3578: AHL_DEBUG_PUB.disable_debug;
3579: --
3580: END IF;

Line 3578: AHL_DEBUG_PUB.disable_debug;

3574: AHL_DEBUG_PUB.log_app_messages (
3575: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3576: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
3577: -- Check if API is called in debug mode. If yes, disable debug.
3578: AHL_DEBUG_PUB.disable_debug;
3579: --
3580: END IF;
3581: WHEN OTHERS THEN
3582: ROLLBACK TO process_material_request;

Line 3595: AHL_DEBUG_PUB.log_app_messages (

3591: p_count => x_msg_count,
3592: p_data => X_msg_data);
3593: IF G_DEBUG='Y' THEN
3594: -- Debug info.
3595: AHL_DEBUG_PUB.log_app_messages (
3596: x_msg_count, x_msg_data, 'SQL ERROR' );
3597: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
3598: -- Check if API is called in debug mode. If yes, disable debug.
3599: AHL_DEBUG_PUB.disable_debug;

Line 3597: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');

3593: IF G_DEBUG='Y' THEN
3594: -- Debug info.
3595: AHL_DEBUG_PUB.log_app_messages (
3596: x_msg_count, x_msg_data, 'SQL ERROR' );
3597: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
3598: -- Check if API is called in debug mode. If yes, disable debug.
3599: AHL_DEBUG_PUB.disable_debug;
3600: END IF;
3601: END Process_Material_Request;

Line 3599: AHL_DEBUG_PUB.disable_debug;

3595: AHL_DEBUG_PUB.log_app_messages (
3596: x_msg_count, x_msg_data, 'SQL ERROR' );
3597: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
3598: -- Check if API is called in debug mode. If yes, disable debug.
3599: AHL_DEBUG_PUB.disable_debug;
3600: END IF;
3601: END Process_Material_Request;
3602: --
3603: -- aps obsoleted

Line 4418: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_id'||x_req_material_tbl(i).workorder_id);

4414: FOR i IN x_req_material_tbl.FIRST..x_req_material_tbl.LAST
4415: LOOP
4416:
4417: IF G_DEBUG='Y' THEN
4418: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_id'||x_req_material_tbl(i).workorder_id);
4419: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);
4420: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);
4421: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);
4422: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);

Line 4419: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);

4415: LOOP
4416:
4417: IF G_DEBUG='Y' THEN
4418: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_id'||x_req_material_tbl(i).workorder_id);
4419: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);
4420: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);
4421: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);
4422: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);
4423: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).requested_date'||x_req_material_tbl(i).requested_date);

Line 4420: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);

4416:
4417: IF G_DEBUG='Y' THEN
4418: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_id'||x_req_material_tbl(i).workorder_id);
4419: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);
4420: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);
4421: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);
4422: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);
4423: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).requested_date'||x_req_material_tbl(i).requested_date);
4424:

Line 4421: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);

4417: IF G_DEBUG='Y' THEN
4418: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_id'||x_req_material_tbl(i).workorder_id);
4419: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);
4420: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);
4421: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);
4422: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);
4423: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).requested_date'||x_req_material_tbl(i).requested_date);
4424:
4425: END IF;

Line 4422: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);

4418: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_id'||x_req_material_tbl(i).workorder_id);
4419: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);
4420: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);
4421: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);
4422: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);
4423: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).requested_date'||x_req_material_tbl(i).requested_date);
4424:
4425: END IF;
4426:

Line 4423: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).requested_date'||x_req_material_tbl(i).requested_date);

4419: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);
4420: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);
4421: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);
4422: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);
4423: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).requested_date'||x_req_material_tbl(i).requested_date);
4424:
4425: END IF;
4426:
4427: END LOOP;

Line 4430: AHL_DEBUG_PUB.debug( 'x_req_material_tbl.count'||x_req_material_tbl.count);

4426:
4427: END LOOP;
4428: END IF;
4429: IF G_DEBUG='Y' THEN
4430: AHL_DEBUG_PUB.debug( 'x_req_material_tbl.count'||x_req_material_tbl.count);
4431: END IF;
4432:
4433: ------------------------End of Body---------------------------------------
4434: --Standard check to count messages

Line 4850: AHL_DEBUG_PUB.debug('flex_fields_defaults.ATTRIBUTE_CATEGORY : ' || flex_fields_defaults.ATTRIBUTE_CATEGORY);

4846: ELSE
4847: flex_fields_defaults.ATTRIBUTE_CATEGORY := p_req_material_rec.ATTRIBUTE_CATEGORY;
4848: END IF;
4849: IF G_DEBUG='Y' THEN
4850: AHL_DEBUG_PUB.debug('flex_fields_defaults.ATTRIBUTE_CATEGORY : ' || flex_fields_defaults.ATTRIBUTE_CATEGORY);
4851: END IF;
4852: IF(flex_fields_defaults.ATTRIBUTE_CATEGORY IS NOT NULL)THEN
4853: fnd_dflex.get_contexts(flexfield, contexts);
4854: FOR j IN 1 .. contexts.ncontexts LOOP