23: and organization_id = X_Organization_Id
24: and process_revision > X_Process_Revision);
25: EXCEPTION
26: WHEN NO_DATA_FOUND then
27: FND_MESSAGE.SET_NAME('BOM','BOM_REVISION_ORDER');
28: APP_EXCEPTION.RAISE_EXCEPTION;
29: END Check_Order;
30:
31: PROCEDURE Check_Unique(X_Organization_Id NUMBER,
42: AND process_revision = X_Process_Revision
43: );
44: EXCEPTION
45: WHEN NO_DATA_FOUND then
46: FND_MESSAGE.SET_NAME('MRP','GEN-DUPLICATE NAME');
47: FND_MESSAGE.SET_TOKEN('ENTITY','revision',TRUE);
48: APP_EXCEPTION.RAISE_EXCEPTION;
49: END Check_Unique;
50:
43: );
44: EXCEPTION
45: WHEN NO_DATA_FOUND then
46: FND_MESSAGE.SET_NAME('MRP','GEN-DUPLICATE NAME');
47: FND_MESSAGE.SET_TOKEN('ENTITY','revision',TRUE);
48: APP_EXCEPTION.RAISE_EXCEPTION;
49: END Check_Unique;
50:
51: END B_RTG_REVS_PKG;