[Home] [Help]
391:
392: FOR CSP_RESERVED_LINES_rec IN CSP_RESERVED_LINES(CSP_REPAIR_PO_HEADERS_rec.REPAIR_PO_HEADER_ID)
393: LOOP
394:
395: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS
396: (CSP_RESERVED_LINES_rec.defective_organization_id
397: ,CSP_RESERVED_LINES_rec.inventory_item_id
398: ,x_item_number
399: ,x_item_description
403: ,x_msg_count
404: );
405:
406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
407: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_RESERVED_LINES_rec.defective_organization_id);
408: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');
409: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_ORG_NAME,TRUE);
410: FND_MSG_PUB.ADD;
411: Add_Err_Msg;
486: End;
487: End if;
488:
489: If l_ship_to_location_id is null then
490: L_ORGANIZATION_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(l_dest_organization_id);
491: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPTO_LOCATION_ID');
492: FND_MESSAGE.SET_TOKEN ('DESTINATION_ORG', L_ORGANIZATION_NAME, TRUE);
493: FND_MSG_PUB.ADD;
494: Add_Err_Msg;
566: LOOP
567:
568: SAVEPOINT RUN_REPAIR_EXECUTION_PVT; /* Create this save point if the commit not exits the loop */
569:
570: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS
571: (IO_QTY_RECEIVED_CHECK_REC.DESTINATION_ORGANIZATION_ID
572: ,IO_QTY_RECEIVED_CHECK_REC.item_id
573: ,x_item_number
574: ,x_item_description
578: ,x_msg_count
579: );
580:
581: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
582: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
583: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
584: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
585: FND_MSG_PUB.ADD;
586: Add_Err_Msg;
611: L_CLASS_CODE := NULL;
612: End;
613:
614: If L_CLASS_CODE is null then
615: L_ORGANIZATION_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
616: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_WIP_CLASS_CODE');
617: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG', L_ORGANIZATION_NAME, TRUE);
618: FND_MSG_PUB.ADD;
619: Add_Err_Msg;
956: Else
957: FINAL_COMPLETION_FLAG := 'N';
958: End if;
959:
960: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS
961: (CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id
962: ,CSP_REPAIR_PO_HEADERS_rec.INVENTORY_ITEM_ID
963: ,x_item_number
964: ,x_item_description
968: ,x_msg_count
969: );
970:
971: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
972: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
973: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');
974: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
975: FND_MSG_PUB.ADD;
976: Add_Err_Msg;
1414: Balance_due_qty := nvl(CSP_REPAIR_PO_SCRAP_rec.quantity,0) - nvl(CSP_REPAIR_PO_SCRAP_rec.received_qty,0);
1415: Available_scrap_qty := nvl(CSP_REPAIR_PO_SCRAP_rec.defect_received_qty,0) -
1416: (nvl(CSP_REPAIR_PO_SCRAP_rec.scrap_qty,0) + nvl(CSP_REPAIR_PO_SCRAP_rec.adjusted_qty,0));
1417:
1418: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS
1419: (CSP_REPAIR_PO_SCRAP_rec.repair_supplier_org_id
1420: ,L_SCRAP_ADJUST_ITEM_ID
1421: ,x_item_number
1422: ,x_item_description
1425: ,x_msg_data
1426: ,x_msg_count
1427: );
1428: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1429: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_SCRAP_rec.repair_supplier_org_id);
1430: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
1431: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
1432: FND_MSG_PUB.ADD;
1433: RAISE EXCP_USER_DEFINED;